Re: 5.0.19 on Solaris: hangs after several days

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,
-- 
Valeriy Kravchuk, Support Engineer
MySQL AB, Kiev, Ukraine, www.mysql.com 


-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]