List:General Discussion« Previous MessageNext Message »
From:Peter Zaitsev Date:May 5 2000 6:09am
Subject:Potential bug in mysql 3.23.14
View as plain text  
I'm running mysql 3.23.14 on RedHat Linux 6.2
Today I saw the following in my processlist:

[pz@geo pz]$ mysqladmin processlist | grep -v Sleep
+-------+-------+-----------+---------+---------+-------+----------------------+------------------------------------------------------------------------------------------------------+
| Id    | User  | Host      | db      | Command | Time  | State                | Info     
                                                                                          
|
+-------+-------+-----------+---------+---------+-------+----------------------+------------------------------------------------------------------------------------------------------+
| 1     | titan | 10.0.0.2  | counter | Killed  | 39566 | update               | INSERT
INTO st10.g00domip (domip, ip, tz, ts) VALUES ('', 3277775400, 8, '2000-05-04 17:40:01')  
   |
| 3     | titan |           | counter | Killed  | 37932 | update               | INSERT
INTO st12.g06pages (page_prot, page_domain, page,query,port,hash)
VALUES(1,4008,'page_src.htm |
| 1997  | titan |           | counter | Query   | 39570 | Copying to tmp table | select
sum(lt.hits) as val, domip.domip as dom,hex(domip.ip) as ip from
layers_st10.g00layers_stat_v |
| 4443  | titan |           |         | Query   | 32895 | Locked               | update
st10.g00domip set domip='hstna030-0053.splitrock.net', rt=rt+1, fldom=161 where
ip=3523193909 |
| 11461 | pz    | localhost |         | Refresh | 575   | Flushing tables      |          
                                                                                          
|
| 11631 | pz    | localhost |         | Query   | 0     |                      | show
processlist                                                                               
     |
+-------+-------+-----------+---------+---------+-------+----------------------+------------------------------------------------------------------------------------------------------+
[pz@geo pz]$ 

As You see some queries just hanged and even can't be killed.
Mysqladmin flush-tables also seems to lock-up during this procedure so it seems to be
unpleasent.
I'll try to repeat this but I'm not shure if I'll be able to do so as I run this type of
queries for several millions per day and as I remember had the same problem only once
before.
The Tables were checked just yesterday so it should not be because of dammaged once.

The processes seems to be just locked (not running in a loop and eating a lot of CPU as I
have much of idle one).


Thread
Potential bug in mysql 3.23.14Peter Zaitsev5 May
  • CalendarKevin Waterson5 May
    • Re: Calendarsinisa5 May
  • Re: Potential bug in mysql 3.23.14sinisa5 May
  • Re: CalendarKevin Waterson5 May
    • Re: Calendarsinisa5 May
  • Potential bug in mysql 3.23.14Michael Widenius5 May
    • Re: Potential bug in mysql 3.23.14Dan Nelson5 May