MySQL Forums
Forum List  »  InnoDB

InnoDB error
Posted by: Holger Kreißl
Date: January 24, 2005 08:48AM

hi,

i used innodb with mysql 4.0.13. After 3 month the database crashed:

InnoDB: Fatal error: cannot allocate 4294959832 bytes of
InnoDB: memory with malloc! Total allocated memory
InnoDB: by InnoDB 17206775 bytes. Operating system errno: 8
InnoDB: Cannot continue operation!
InnoDB: Check if you should increase the swap file or
InnoDB: ulimits of your operating system.
InnoDB: On FreeBSD check you have compiled the OS with
InnoDB: a big enough maximum process size.
InnoDB: We now intentionally generate a seg fault so that
InnoDB: on Linux we get a stack trace.

I was able to rescue my data. So I updatet to mysql 4.0.23, because i thought that it was an bug...

But now, I have an other problem. The database runs a view hours before it hangs up. I can restart mysql but the error repeats...

050124 13:28:44 InnoDB: Started
bin\mysqld-nt: ready for connections.
Version: '4.0.23-nt' socket: '' port: 3306 Source distribution
050124 14:57:08 InnoDB: Operating system error number 995 in a file operation.
InnoDB: See http://dev.mysql.com/doc/mysql/en/InnoDB.html
InnoDB: for installation help.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/mysql/en/Operating_System_error_codes.html
InnoDB: File name .\ibdata1
InnoDB: File operation call: 'Windows aio'.
InnoDB: Cannot continue operation.

I cant find any information about this. Is it a bug? Can it depends on a wrong mysql configuration?...

Some information about the database
- about 20 databases with innodb tablespace
- larges table has about 100.000 entries
- ibdata size about 60 MByte

Maybe its a configuration problem. I used as base the mysql-medium configuration.

innodb_buffer_pool_size = 64M
innodb_additional_mem_pool_size = 2M
innodb_log_file_size = 16M
innodb_log_buffer_size = 16M

I hope there is somebody who knows about that problem.

Best regards
Holger Kreißl

--
http://www.kreissl.info

Options: ReplyQuote


Subject
Views
Written By
Posted
InnoDB error
5056
January 24, 2005 08:48AM
3922
January 24, 2005 01:13PM
3158
January 27, 2005 07:33AM
3475
lg
March 04, 2005 02:52AM
3182
March 05, 2005 01:57AM
13020
lg
March 16, 2005 09:48AM
6392
April 19, 2005 02:22PM
5500
April 25, 2005 07:21AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.