Philipp, this is probably the bug that I fixed last night. It is present in all 3.23, 4.0 and 4.1 versions.
" [EMAIL PROTECTED], 2004-05-18 01:53:06+03:00, [EMAIL PROTECTED] mem0pool.c: Fix a memory corruption bug: in 32-bit computers, every 4 billionth malloc outside innodb_additional_mem_pool_size was mistreated when freeing the memory; this could corrupt the InnoDB additional mem pool and could have caused crashes anywhere, also inside MySQL, or even database corruption! the bug exists also in 3.23 and 4.1; workaround: configure innodb_additional_mem_pool_size big enough " Best regards, Heikki Innobase Oy InnoDB - transactions, row level locking, and foreign keys for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php Order MySQL support from http://www.mysql.com/support/index.html .......... From: "Heikki Tuuri" ([EMAIL PROTECTED]) Subject: Re: Mysql 4.0.18 crashed6384512 View: Complete Thread (2 articles) Original Format Newsgroups: mailing.database.myodbc Date: 2004-04-06 12:27:44 PST Philipp, ----- Original Message ----- From: "Philipp Steinkrüger" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Wednesday, March 31, 2004 3:59 PM Subject: Mysql 4.0.18 crashed6384512 > ------=_NextPart_000_002D_01C4172E.C75E7F90 > Content-Type: text/plain; > charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > > Hi, > > > today our mysql server 4.0.18-standard (binary) crashed. > I found a similar report (InnoDB: Assertion failure in thread), but it > was with 4.0.16 and one reply said that the bug was fixed in 4.0.17. > > Here is the report from mysql.err: > > InnoDB: Started > /usr/local/mysql/bin/mysqld: ready for connections. > Version: '4.0.18-standard' socket: '/var/run/mysql/mysql.sock' port: = > 3306 > InnoDB: Error: Mem area size is 0. Possibly a memory overrun of the > InnoDB: previous allocated area! > InnoDB: Apparent memory corruption: mem dump len 500; hex = > 666e6f7264f77318750f0a0d0805140f06090a0f07080b08000035fd00001cc600008f690= > 0011c0e0000250280001239ffeb6be40d0d0f0f140f0a0b0f0d0a31313232333334343535= > 363638383838050004050b000000000003000000000000ff0000818181426c756d656e6b6= > 96e646572800000003d0300000000140a0a0a00800000000000190a000000000000000000= > 00633a2f44572f64770000000000028d00004d00858985870000000000000000777318d70= > 00000000000000000d0f56d94d0f56da1d0f56daed0f56dbbd0f56dc8d0f56dd5d0f56de2= > d0f56defd0f56dfcd0f56d09d1f56d16d1f56d23d1f56d30d1f56d9900000000000000107= > bf26d90000000f63d775f9268a520773073656c2e6300a208000000000000000000000000= > 0000000000000000000080000000000000000000000040000000400000000000000001300= > 1303c623e3c693e636869736c656167202d2030342e30332e323030342031383a32352055= > 68723a3c2f693e3c2f423e3c62723e646174756d20e46e6465726ef56d98000000d905000= > 0008e4172f8e1ec6dd0050000f63d775fb307952d78307472782e63008b000000640bf56d= > 720bf56d800bf56d8813da70207bf26dc00500000100000000000000c0050000400000000= > 0000000fe0bf56d70bbdc700816da70c875f26d250000000000; asc = > fnord.s.u.................5........i......%....9..k............1122334455= > 668888.......................Blumenkinder....=3D.........................= > ...c:/DW/dw.........M.............ws.............m...m...m...m...m...m...= > m...m...m...m...m...m#..m0..m.........{.m.....=3Dw_.h. = > [EMAIL PROTECTED]@........0.0<b><i>chislea= > g - 04.03.2004 18:25 Uhr:</i></B><br>datum = > .ndern.m..........Ar...m.....=3Dw_...-x0trx.c.....d..mr..m...m...p = > [EMAIL PROTECTED]; > InnoDB: Scanning backward trying to find previous allocated mem blocks > Mem block at - 600, file w0sel.c, line 2273 > Freed mem block at - 1352, file x0trx.c, line 153 > Freed mem block at - 1696, file x0trx.c, line 139 > Freed mem block at - 21496, file w0sel.c, line 2210 > Freed mem block at - 27600, file x0trx.c, line 139 > Freed mem block at - 30632, file w0sel.c, line 2210 > Freed mem block at - 40648, file w0sel.c, line 2210 > Freed mem block at - 40840, file x0trx.c, line 153 > Freed mem block at - 42088, file x0trx.c, line 153 > Freed mem block at - 42432, file x0trx.c, line 139 > InnoDB: Scanning forward trying to find next allocated mem blocks > Freed mem block at + 16, file w0sel.c, line 2210 > Mem block at + 168, file x0trx.c, line 139 > Mem block at + 1664, file x0trx.c, line 139 > Freed mem block at + 4696, file w0sel.c, line 2210 > Freed mem block at + 28800, file x0trx.c, line 139 > Freed mem block at + 29144, file x0trx.c, line 153 > Freed mem block at + 30712, file 0data.c, line 153 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]