List:General Discussion« Previous MessageNext Message »
From:Marvin Wright Date:April 18 2005 3:47pm
Subject:Mysqladmin bug
View as plain text  
Hi,

Our database has been running for some time and it had some threads on it
that I needed to kill.

I did a mysqladmin process list and got the following

| 2521285658 | web  | 192.168.11.60:2482   |                 | Sleep       |
747     |                                                                |
|
| 2521498154 | web  | 192.168.11.60:2570   |                 | Sleep       |
335     |                                                                |
|
| 2521570862 | web  | 192.168.11.60:2600   |                 | Sleep       |
190     |                                                                |


I tried to kill 2521570862 and got an error
             
[mwright@prdpctb1314 mwright]$ mysqladmin kill 2521570862
mysqladmin: kill failed on 2147483647; error: 'Unknown thread id:
2147483647'

I think the thread id number is too large for mysqladmin to deal with,
2147483647 is the max size of an int.


Marvin Wright
Flights Developer
Lastminute.com
mwright@stripped




**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**********************************************************************


Thread
Mysqladmin bugMarvin Wright18 Apr
  • Re: Mysqladmin bugEric Bergen19 Apr