From: Eric Bergen Date: April 18 2005 10:31pm Subject: Re: Mysqladmin bug List-Archive: http://lists.mysql.com/mysql/182810 Message-Id: <11b1bd99050418153147ffe810@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable 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 wrote: > Hi, >=20 > Our database has been running for some time and it had some threads on it > that I needed to kill. >=20 > I did a mysqladmin process list and got the following >=20 > | 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 | = | >=20 > I tried to kill 2521570862 and got an error >=20 > [mwright@prdpctb1314 mwright]$ mysqladmin kill 2521570862 > mysqladmin: kill failed on 2147483647; error: 'Unknown thread id: > 2147483647' >=20 > I think the thread id number is too large for mysqladmin to deal with, > 2147483647 is the max size of an int. >=20 > Marvin Wright > Flights Developer > Lastminute.com > mwright@stripped >=20 > ********************************************************************** > 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. >=20 > This footnote also confirms that this email message has been swept by > MIMEsweeper for the presence of computer viruses. >=20 > www.mimesweeper.com > ********************************************************************** >=20 >=20 --=20 Eric Bergen eric.bergen@stripped http://www.ebergen.net