6

I have a script running a batch of very similar queries.
All of them, except one, run without any problem.
Only one query is getting stuck.
In "show processlist" the query has state=null
According to docs, show processlist should report "State=null" only for the "show processlist" thread itself. 

    Server version: 5.0.67 MySQL Community Server (GPL)
    mysql> show processlist;
    +---------+--------+-----------+--------------+---------+------+-------+------------------------------------------------------------------------------------------------------+
    | Id      | User   | Host      | db           | Command | Time | State | Info                                                                                                 |
    +---------+--------+-----------+--------------+---------+------+-------+------------------------------------------------------------------------------------------------------+
    | 3866613 | user   | localhost | db_name      | Query   | 1986 | NULL  | select log_time,log_action,log_action_id,log_object_id, @abcde:=if(log_action='abcde',to_            |
    | 3873414 | root   | localhost | NULL         | Query   |    0 | NULL  | show processlist                                                                                     |
    +---------+--------+-----------+--------------+---------+------+-------+------------------------------------------------------------------------------------------------------+
    2 rows in set (0.00 sec)
Charles
  • 50,943
  • 13
  • 104
  • 142
user1312090
  • 63
  • 1
  • 3

1 Answers1

2

Could be a bug of your version of mysql, take a look at this bug for more information .

aleroot
  • 71,077
  • 30
  • 176
  • 213
  • thanks. seems to me also like a bug in mysql. tried turning off query cache - it did not help. will try upgrading mysql. – user1312090 Apr 04 '12 at 07:07