Re: Innodb corrpution. Very Urgent

Wed, 24 Nov 2004 14:47:14 -0800 

Carlos,

I asked you to post the COMPLETE .err log. Do NOT cut anything off.

Regards,

Heikki

----- Original Message ----- From: "Carlos Augusto" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Wednesday, November 24, 2004 7:38 PM
Subject: Re: Innodb corrpution. Very Urgent


well i=B4m having another problem now... I changed innodb_force_recovery
for 1 and mysql is not running due the following error:

041124 14:13:18 Innodb: fatal error: cannot allocate 2147500032 bytes of
innodb: memory with malloc! total allocated memory
innodb: by inndodb 16975556 bytes. Operating system errno: 8
innodb: Cannot continue operation!
innodb: check if you should increase the swap file of ulimits
innodb: of your operating system
innodb: On freeBSD check you have compiled the OS with
innodb:a big enough maximum process size
....
got signal 11. Aborted!
---
Can anyone help me with this new problem?=20
thanks!
[=B4z]=20
Carlos


On Tue, 23 Nov 2004 15:33:08 -0200, Carlos Augusto <[EMAIL PROTECTED]> wr=
ote:
I appreciate your help, but now i can=B4t get those error logs because i
need access to this database that im not having at the moment.
As fast as i can i=B4ll paste the full error log for you.
Thanks for the help.
[=B4z]
=20
On Mon, 22 Nov 2004 23:09:41 +0200, Heikki Tuuri
=20
=20
<[EMAIL PROTECTED]> wrote:
> Carlos,
>
> ----- Original Message -----
> From: "Carlos Augusto" <[EMAIL PROTECTED]>
> Newsgroups: mailing.database.myodbc
> Sent: Monday, November 22, 2004 10:37 PM
> Subject: Innodb corrpution. Very Urgent
>
> > Hello, i=3DB4m having a problem with a large database...
> > at ibdata1.My ibdata1 is corrupted and i saw other postings and all > > o=
f
> > them asks to use mysqldump, but in my case there=3DB4s a problem...
> > I can=3DB4t run mysqld since ibdata1 is corrupted.=3D20
> > Those anyone have a tip for me?
> > in logfile says that mysqld can=3DB4t run because this corruption.
> > When I make a new instalation of mysql whithout my 4 gb ibdata1, the
> > daemon runs ok...and when i paste my corrupted ibdata1 at /data
> > (shutting down the service) and turn on the service again, it > > don=3DB=
4t
> > turns on.
> > I don=3DB4t know what to do...
>
> please post the COMPLETE .err log of mysqld. Do not cut anything off. > W=
hat
> does mysqld print when you try to start it?
>
> Which MySQL version this is, and what operating system?
>
> The following section:
> http://dev.mysql.com/doc/mysql/en/Forcing_recovery.html
> contains instructions how you can start mysqld, even though the ibdata > =
file
> is corrupt.
>
> > Thanks
> > Carlos
>
> Best regards,
>
> Heikki Tuuri
> Innobase Oy
> Foreign keys, transactions, and row level locking for MySQL
> InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up > My=
ISAM
> tables
> http://www.innodb.com/order.php
>
> Order MySQL technical support from https://order.mysql.com/
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED]
.com 
>
>


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to