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 <[EMAIL PROTECTED]> 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 > > [EMAIL PROTECTED] 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 > [EMAIL PROTECTED] > > ********************************************************************** > 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 [EMAIL PROTECTED] http://www.ebergen.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
