Hi, List!
I've recently upgraded to MySQL 4.1.20 and now I'm facing a strange
problem. Periodically my queries hang up.
mysql> show processlist;
...
| 155 | root | localhost | db | Query | 33385 | Locked | UPDATE
queue SET status='-1', processor_id=NULL |
| 156 | root | localhost | db | Query | 33381 | Locked | UPDATE
queue SET status='-1', processor_id=NULL |
| 157 | root | localhost | db | Query | 33384 | Locked | UPDATE
queue SET status='-1', processor_id=NULL |
| 158 | root | localhost | db | Query | 33384 | Locked | UPDATE
queue SET status='-1', processor_id=NULL |
| 159 | root | localhost | db | Query | 33385 | Locked | UPDATE
queue SET status='-1', processor_id=NULL |
| 160 | root | localhost | db | Query | 33385 | end | UPDATE
queue SET status='-1', processor_id=NULL |
...
Status of the last one is 'end'. What does it mean? I couldn't find
something helpfull in docs.
Furthermore I can't kill this query. After "kill 160" query didn't
disappear from processlist and it's "Command" field changes to "Killed"
but the table is still locked.
What can be a reason for this behavior? Is it a known bug? I couldn't
find corresponding bugreport at bugs.mysql.com.
Thanks in advance!
--
BR,
Eugene Kosov
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]