Re: 5.0.19 on Solaris: hangs after several days

> 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?

No, I simply installed the new binaries and ran the --upgrade process.

Would this likely make a difference? I'm more than happy to try this  
if this will likely make a difference. (I have run mysqlcheck, with  
no interesting results.)

> 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

The practical problem is that the database is part of a fairly  
critical system and I was only able to get the process list once (but  
didn't save it). Unfortunately, it seems to happen mostly in the  
middle of the night (and I find hundreds of email messages in my  
mailbox complaining the next morning...). Thus, I've had to resort to  
restarting the server every three hours for now.

I did notice that some queries have ridiculously long lock times:

# User@Host: x[x] @
# Query_time: 518  Lock_time: 510  Rows_sent: 2  Rows_examined: 14
SET timestamp=1144720272;

When I re-run the query an hour later, on the same system, the query  
time is maybe 0.16 seconds. I don't know if these are at all  
connected. (The system did not crash at that time.)

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