I'm seeing some very odd locking behaviour on 4.1.13:
mysql> show full processlist;
+----+------+----------------------------+------+---------+------+--------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State |
Info
|
+----+------+----------------------------+------+---------+------+--------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 30 | len | dick.landsonar.com:36746 | NULL | Sleep | 1 | |
NULL
|
| 33 | len | dick.landsonar.com:3233 | us | Sleep | 7423 | |
NULL
|
| 35 | len | yertle.landsonar.com:64667 | us | Sleep | 38 | |
NULL
|
| 36 | len | yertle.landsonar.com:64666 | us | Query | 30 | init |
UPDATE crumb
SET link_ID = 127624294,
dir_Travel = 'T',
last_Modified = SYSDATE()
WHERE link_ID IS NULL AND
customer_ID = 2 AND
source_ID = 2 AND
vehicle_ID = 43920 AND
actual_Time = '2005-03-11 01:19:40' |
| 37 | len | yertle.landsonar.com:64665 | us | Query | 30 | Locked |
UPDATE crumb
SET link_ID = 125170474,
dir_Travel = 'F',
last_Modified = SYSDATE()
WHERE link_ID IS NULL AND
customer_ID = 2 AND
source_ID = 2 AND
vehicle_ID = 161878 AND
actual_Time = '2005-08-14 15:26:17' |
| 38 | len | yertle.landsonar.com:64664 | us | Query | 30 | Locked |
UPDATE crumb
SET link_ID = 125154498,
dir_Travel = 'T',
last_Modified = SYSDATE()
WHERE link_ID IS NULL AND
customer_ID = 2 AND
source_ID = 2 AND
vehicle_ID = 208475 AND
actual_Time = '2006-02-28 20:46:15' |
There is no other activity in the system. The db server is dead idle - no
CPU activity, no disk activity. I'm suspicious that there may be some
sort of bug in the lock manager that we are tickling; the deadlock breaks
eventually, but sometimes it takes 10 minutes or more.
Thoughts?
Thanks,
chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
