4 messages in com.mysql.lists.bugsRe: 5.0.19 on Solaris: hangs after se...
FromSent OnAttachments
Henning Schulzrinne09 Apr 2006 19:54 
Valeriy Kravchuk09 Apr 2006 23:44 
Henning Schulzrinne10 Apr 2006 20:25 
Valeriy Kravchuk14 Apr 2006 12:12 
Subject:Re: 5.0.19 on Solaris: hangs after several days
From:Valeriy Kravchuk (vale@mysql.com)
Date:04/09/2006 11:44:08 PM
List:com.mysql.lists.bugs

Hi Henning,

I upgraded from 4.1.12 to 5.0.19 on Solaris (5.8 sun4u). It generally works, but after a few days (and sometimes a few hours), a sequence of events seems to take place:

First of all, please, describe the exact upgrade procedure. Did you use mysqldump and then reloaded data in 5.0.19 or simply installed new binaries?

- queries lock (judging from the processlist) - the connection limit (around 100) is reached - the server becomes unresponsive and has to be killed hard (kill - TERM doesn't work)

Besides upgrading the tables, nothing has changed between 4.1.12 and 5.0.19 (same hardware, some OS).

Please, send the SHOW PROCESSLIST result before/during this hang.

Anyway, looks like you have to add a bug report about this at http://bugs.mysql.com

Best regards,