Hi,
A quite strange bug just occurs with MySQL 4.0 :
When I execute show processlist, I get :
mysql> show processlist;
+-------+---------+-----------+------------+----------------+------+--------
-----------+----------------------------------------------------------------
--------------------------------------+
| Id | User | Host | db | Command | Time | State
| Info
|
+-------+---------+-----------+------------+----------------+------+--------
-----------+----------------------------------------------------------------
--------------------------------------+
| 1684 | DELAYED | localhost | Hardwarefr | Delayed_insert | 656 | Waiting
on cond | searchhardwarefr10
|
| 1942 | DELAYED | localhost | Hardwarefr | Delayed_insert | 486 | Waiting
on cond | searchhardwarefr11
|
| 2035 | DELAYED | localhost | Hardwarefr | Delayed_insert | 909 | Waiting
on cond | searchhardwarefr9
|
| 2406 | DELAYED | localhost | Hardwarefr | Delayed_insert | 543 | Waiting
on cond | searchconthardwarefr1
|
| 4460 | DELAYED | localhost | Hardwarefr | Delayed_insert | 574 | Waiting
on cond | searchconthardwarefr6
|
| 4526 | DELAYED | localhost | Hardwarefr | Delayed_insert | 1396 | Waiting
on cond | searchconthardwarefr10
|
| 6105 | DELAYED | localhost | Hardwarefr | Delayed_insert | 1579 | Waiting
on cond | searchconthardwarefr11
|
| 8127 | DELAYED | localhost | Hardwarefr | Delayed_insert | 5053 | Waiting
on cond | searchhardwarefr12
|
| 20544 | DELAYED | localhost | Hardwarefr | Delayed_insert | 1802 | Waiting
on cond | searchconthardwarefr9
|
| 25776 | DELAYED | localhost | Hardwarefr | Delayed_insert | 2670 | Waiting
on cond | searchhardwarefr8
|
| 39954 | mysql | localhost | Hardwarefr | Query | 420 | Waiting
for table | SELECT topic FROM searchconthardwarefr1 WHERE mot='lcd' AND
date >= '2001-10-08' |
| 39979 | DELAYED | localhost | Hardwarefr | Delayed_insert | 23 | Waiting
on cond | searchhardwarefr7
|
| 39984 | mysql | localhost | Hardwarefr | Query | 405 | Waiting
for table | SELECT topic FROM searchconthardwarefr1 WHERE mot='lcd' AND
date >= '2001-10-08' |
| 40114 | mysql | localhost | Hardwarefr | Query | 311 | Waiting
for table | SELECT topic FROM searchconthardwarefr1 WHERE mot='lcd' AND
date >= '2001-10-08' |
| 40149 | mysql | localhost | Hardwarefr | Query | 311 | Waiting
for table | SELECT topic FROM searchconthardwarefr1 WHERE mot='chipset' OR
mot='i810' AND date >= '2000-10-08' |
| 40165 | DELAYED | localhost | Hardwarefr | Delayed_insert | 72 | Waiting
on cond | searchhardwarefr4
|
| 40219 | mysql | localhost | Hardwarefr | Query | 277 | Waiting
for table | SELECT topic FROM searchconthardwarefr1 WHERE mot='lcd' AND
date >= '2001-10-08' |
| 40224 | mysql | localhost | Hardwarefr | Query | 277 | Waiting
for table | SELECT topic FROM searchconthardwarefr1 WHERE mot='lcd' AND
date >= '2001-10-08' |
| 40281 | mysql | localhost | Hardwarefr | Query | 210 | Waiting
for table | SELECT topic FROM searchconthardwarefr1 WHERE mot='lcd' AND
date >= '2001-10-08' |
| 40283 | mysql | localhost | Hardwarefr | Query | 202 | Waiting
for table | SELECT topic FROM searchconthardwarefr1 WHERE mot='1.2' AND
date >= '2001-01-08' |
| 40303 | mysql | localhost | Hardwarefr | Query | 208 | Waiting
for table | SELECT topic FROM searchconthardwarefr1 WHERE mot='lcd' AND
date >= '2001-10-08' |
| 40361 | mysql | localhost | Hardwarefr | Query | 189 | Waiting
for table | SELECT topic FROM searchconthardwarefr1 WHERE mot='antec' AND
date >= '2001-08-08' |
| 40363 | root | localhost | NULL | Query | 0 | NULL
| show processlist
|
| 40388 | mysql | localhost | Hardwarefr | Query | 171 | Waiting
for table | SELECT topic FROM searchconthardwarefr1 WHERE mot='celeron' AND
date >= '2001-10-08' |
| 40399 | mysql | localhost | Hardwarefr | Query | 174 | Waiting
for table | SELECT topic FROM searchconthardwarefr1 WHERE mot='antec' AND
date >= '2001-08-08' |
| 40417 | mysql | localhost | Hardwarefr | Query | 148 | Waiting
for table | SELECT topic FROM searchhardwarefr8 WHERE mot='Leadtek' OR
mot='GeForce' OR mot='III' OR mot='Ti200' |
| 40448 | mysql | localhost | Hardwarefr | Query | 162 | Waiting
for table | SELECT topic FROM searchconthardwarefr1 WHERE mot='antec' AND
date >= '2001-08-08' |
| 40486 | mysql | localhost | Hardwarefr | Query | 147 | Waiting
for table | SELECT topic FROM searchconthardwarefr1 WHERE mot='celeron' AND
date >= '2001-10-08' |
| 40519 | DELAYED | localhost | Hardwarefr | Delayed_insert | 138 | Waiting
on cond | searchhardwarefr5
|
| 40547 | mysql | localhost | Hardwarefr | Query | 125 | Waiting
for table | SELECT topic FROM searchconthardwarefr6 WHERE pseudo='fannoute'
|
| 40556 | mysql | localhost | Hardwarefr | Query | 99 | Waiting
for table | SELECT topic FROM searchconthardwarefr1 WHERE mot='1.2' AND
date >= '2001-05-08' |
| 40585 | mysql | localhost | Hardwarefr | Query | 87 | Waiting
for table | SELECT topic FROM searchconthardwarefr1 WHERE pseudo='Esc' AND
date >= '2001-10-08' |
| 40601 | mysql | localhost | Hardwarefr | Query | 89 | Waiting
for table | SELECT topic FROM searchconthardwarefr1 WHERE mot='logiciel' OR
mot='1.2' AND date >= '2001-05-08' |
| 40676 | mysql | localhost | Hardwarefr | Query | 80 | Waiting
for table | SELECT topic FROM searchconthardwarefr1 WHERE mot='antec' AND
date >= '2001-08-08' |
| 40687 | mysql | localhost | Hardwarefr | Query | 73 | Waiting
for table | SELECT topic FROM searchconthardwarefr6 WHERE pseudo='fannoute'
|
| 40699 | DELAYED | localhost | Hardwarefr | Delayed_insert | 70 | Waiting
on cond | searchhardwarefr3
|
| 40777 | DELAYED | localhost | Hardwarefr | Delayed_insert | 32 | Waiting
on cond | searchhardwarefr1
|
| 40790 | mysql | localhost | Hardwarefr | Query | 33 | Waiting
for table | SELECT topic FROM searchconthardwarefr6 WHERE pseudo='lomi59'
AND date >= '2001-10-08' |
| 40805 | mysql | localhost | Hardwarefr | Query | 34 | Waiting
for table | SELECT topic FROM searchconthardwarefr6 WHERE pseudo='fannoute'
|
| 40823 | mysql | localhost | Hardwarefr | Sleep | 8 |
| NULL
|
| 40837 | mysql | localhost | Hardwarefr | Sleep | 9 |
| NULL
|
| 40849 | mysql | localhost | Hardwarefr | Sleep | 9 |
| NULL
|
| 40859 | mysql | localhost | Hardwarefr | Query | 11 | Waiting
for table | SELECT topic FROM searchconthardwarefr1 WHERE mot='ram' OR
mot='Corsaire' OR mot='256M' OR mot='150' |
| 40860 | mysql | localhost | Hardwarefr | Sleep | 3 |
| NULL
|
| 40876 | mysql | localhost | Hardwarefr | Sleep | 10 |
| NULL
|
| 40877 | mysql | localhost | Hardwarefr | Sleep | 10 |
| NULL
|
| 40878 | DELAYED | localhost | Hardwarefr | Delayed_insert | 11 | Waiting
on cond | searchhardwarefr2
|
| 40879 | mysql | localhost | Hardwarefr | Sleep | 10 |
| NULL
|
| 40880 | mysql | localhost | Hardwarefr | Sleep | 1 |
| NULL
|
| 40881 | mysql | localhost | Hardwarefr | Sleep | 3 |
| NULL
|
| 40882 | mysql | localhost | Hardwarefr | Sleep | 9 |
| NULL
|
| 40883 | mysql | localhost | Hardwarefr | Sleep | 9 |
| NULL
|
| 40884 | mysql | localhost | Hardwarefr | Sleep | 9 |
| NULL
|
| 40885 | mysql | localhost | Hardwarefr | Sleep | 9 |
| NULL
|
| 40886 | mysql | localhost | Hardwarefr | Sleep | 8 |
| NULL
|
| 40887 | mysql | localhost | Hardwarefr | Sleep | 5 |
| NULL
|
| 40888 | mysql | localhost | Hardwarefr | Sleep | 8 |
| NULL
|
| 40889 | mysql | localhost | Hardwarefr | Sleep | 7 |
| NULL
|
| 40890 | mysql | localhost | Hardwarefr | Sleep | 7 |
| NULL
|
| 40891 | mysql | localhost | Hardwarefr | Sleep | 6 |
| NULL
|
| 40892 | mysql | localhost | Hardwarefr | Sleep | 6 |
| NULL
|
| 40893 | mysql | localhost | Hardwarefr | Sleep | 5 |
| NULL
|
| 40894 | mysql | localhost | Hardwarefr | Sleep | 4 |
| NULL
|
| 40895 | mysql | localhost | Hardwarefr | Sleep | 2 |
| NULL
|
| 40896 | mysql | localhost | Hardwarefr | Sleep | 4 |
| NULL
|
| 40897 | mysql | localhost | Hardwarefr | Sleep | 2 |
| NULL
|
| 40898 | mysql | localhost | Hardwarefr | Sleep | 2 |
| NULL
|
| 40899 | mysql | localhost | Hardwarefr | Sleep | 2 |
| NULL
|
| 40900 | mysql | localhost | Hardwarefr | Sleep | 1 |
| NULL
|
| 40929 | mysql | localhost | Hardwarefr | Sleep | 2 |
| NULL
|
| 40930 | mysql | localhost | Hardwarefr | Sleep | 2 |
| NULL
|
| 40931 | mysql | localhost | Hardwarefr | Sleep | 2 |
| NULL
|
| 40932 | mysql | localhost | Hardwarefr | Sleep | 2 |
| NULL
|
| 40933 | mysql | localhost | Hardwarefr | Sleep | 2 |
| NULL
|
| 40934 | mysql | localhost | Hardwarefr | Sleep | 2 |
| NULL
|
| 40935 | mysql | localhost | Hardwarefr | Sleep | 2 |
| NULL
|
| 40936 | mysql | localhost | Hardwarefr | Sleep | 1 |
| NULL
|
| 40937 | mysql | localhost | Hardwarefr | Sleep | 1 |
| NULL
|
| 40938 | mysql | localhost | Hardwarefr | Sleep | 1 |
| NULL
|
| 40939 | mysql | localhost | Hardwarefr | Sleep | 0 |
| NULL
|
| 40940 | mysql | localhost | Hardwarefr | Sleep | 0 |
| NULL
|
| 40941 | mysql | localhost | Hardwarefr | Sleep | 0 |
| NULL
|
+-------+---------+-----------+------------+----------------+------+--------
-----------+----------------------------------------------------------------
--------------------------------------+
82 rows in set (0.01 sec)
I don't understand why there are queries waiting for table here ???
More over, show status displays :
| Delayed_insert_threads | 4294967291 |
I don't understand what could be wrong, and I have unfortunately no idea of
how to reproduce this behaviour.
BTW, MySQL runs with delay_key_write enabled, I don't know if it could be
related ?
Best Regards,
Jocelyn Fournier
Presence-PC
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
