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,