Re: MySQL 5.0.18 crashing on AMD64

[Sander Smeenk]

Quoting Pete Harlan ([EMAIL PROTECTED]):
  MySQL version 5.0.18
  | Mar 14 00:32:59 zwart mysqld[29820]: *** glibc detected *** double
  | free or corruption (!prev): 0x012b1ab0 ***
 You don't say which versions of glibc or the kernel you're running,
 but if you're running stock Debian Sarge, that's a problem because of
 its known-buggy glibc 2.3.2.

Sorry. I forgot about that important information.
The servers are running 2.6.15.x and Debian sid, updated to the newest
libc6 (2.3.6) available.

It does look like it was some problem with mysql's binaries on AMD64,
since after upgrading to 5.0.19 it looks to be working again.

It just apears weird to me that only this server would crash mysql :|

The other AMD64 which has the same config, same kernel, same libc6,
didn't crash. Though that mysql was only used for selects and not
inserts updates and crazy select with joins, group by's etc.

But what can the message indicate? All I got from Google was that it
probably had to do with buggy memory. But i ran memtest86+ on the server
and it had 17 passes with zero errors... :|

HTH,
Sander.
-- 
| A balanced diet is a cookie in each hand.
| 1024D/08CEC94D - 34B3 3314 B146 E13C 70C8  9BDB D463 7E41 08CE C94D

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

Re: MySQL 5.0.18 crashing on AMD64

[Pete Harlan]

On Tue, Mar 28, 2006 at 10:12:58AM +0200, Sander Smeenk wrote:
 Hello!
 
 I have a dual Opteron 250 system with 4GB memory running Debian with
 MySQL version 5.0.18 and unfortunately it keeps crashing at (somewhat)
 random intervals with messages like:
 
 | Mar 14 00:32:59 zwart mysqld[29820]: *** glibc detected *** double
 | free or corruption (!prev): 0x012b1ab0 ***
 | Mar 15 02:24:17 zwart mysqld[13255]: *** glibc detected *** free():
 | invalid next size (normal): 0x012d3d30 ***
 | Mar 16 00:32:51 zwart mysqld[17749]: *** glibc detected *** double
 | free or corruption (!prev): 0x01333540 ***
 | Mar 16 14:44:07 zwart mysqld[471]: *** glibc detected *** double
 | free or corruption (!prev): 0x013e4160 ***

You don't say which versions of glibc or the kernel you're running,
but if you're running stock Debian Sarge, that's a problem because of
its known-buggy glibc 2.3.2.

We are still using MySQL 4.0.x, but have had good luck running Debian
testing, and I expect sid would be good too if you don't need to
run much more than a db server on this machine.

I'd also use a recent kernel, though we've been running on a 2.6.13.1
kernel on a dual opteron with 6gb ram since last September without a
problem, so the kernel doesn't have to be that recent.

You can either manually install the later glibc's (2.3.5 or 2.3.6)
from testing/sid, or just update the whole kit and kaboodle.

--Pete

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