List:General Discussion« Previous MessageNext Message »
From:Eric Bergen Date:April 18 2005 10:31pm
Subject:Re: Mysqladmin bug
View as plain text  
Try enclosing 2521570862 in single quotes on the command line. It's
just a guess but it might be bash overflowing that number and not
mysqladmin.

-Eric

On 4/18/05, Marvin Wright <MWright@stripped> wrote:
> 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
> **********************************************************************
> 
> 


-- 
Eric Bergen
eric.bergen@stripped
http://www.ebergen.net
Thread
Mysqladmin bugMarvin Wright18 Apr
  • Re: Mysqladmin bugEric Bergen19 Apr