Hello.
Your version of MySQL is rather old. Does the problem remains after upgrading? "Stephen Rasku" <[EMAIL PROTECTED]> wrote: > I am using MySQL 4.0.17 on QNX 6.2.1b. > > I have noticed this in the last couple of days. There were two MySQL > clients running: one since 1:30 that morning; one at 1:30 the previous > morning. These are "reset master" commands we issue from cron to clean up > the transaction logs. > > This morning I tried running mysql from the command line and it hung. I > then run with the debug option enabled. Here is the content of > /tmp/mysql.trace: > > | >my_malloc > | | my: Size: 520 MyFlags: 16 > | | exit: ptr: 8085d28 > | <my_malloc > | >my_malloc > | | my: Size: 512 MyFlags: 48 > | | exit: ptr: 8085b20 > | <my_malloc > | >mysql_close > | | >my_free > | | | my: ptr: 0 > | | <my_free > | | >my_free > | | | my: ptr: 0 > | | <my_free > | | >my_free > | | | my: ptr: 0 > | | <my_free > | | >my_free > | | | my: ptr: 0 > | | <my_free > | | >my_free > | | | my: ptr: 0 > | | <my_free > | | >my_free > | | | my: ptr: 0 > | | <my_free > | | >my_free > | | | my: ptr: 0 > | | <my_free > | | >my_free > | | | my: ptr: 0 > | | <my_free > | | >my_free > | | | my: ptr: 0 > | | <my_free > | | >my_free > | | | my: ptr: 0 > | | <my_free > | | >my_free > | | | my: ptr: 0 > | | <my_free > | | >my_free > | | | my: ptr: 0 > | | <my_free > | | >my_free > | | | my: ptr: 0 > | | <my_free > | | >my_free > | | | my: ptr: 0 > | | <my_free > | | >mysql_close > | | <mysql_close > | <mysql_close > | >mysql_real_connect > | | enter: host: (Null) db: (Null) user: root > | | info: Using UNIX sock '/tmp/mysql.sock' > | | >vio_new > | | | enter: sd=4 > | | | >my_malloc > | | | | my: Size: 84 MyFlags: 16 > | # tail -f /tmp/mysql.trace > | | <mysql_close > | <mysql_close > | >mysql_real_connect > | | enter: host: (Null) db: (Null) user: root > | | info: Using UNIX sock '/tmp/mysql.sock' > | | >vio_new > | | | enter: sd=4 > | | | >my_malloc > | | | | my: Size: 84 MyFlags: 16 > | > > To me, it appears that it is hung in my_malloc(). However not on the first > call. It doesn't appear that I am running out of memory: > > # pidin in > CPU:X86 Processors:1 FreeMem:927Mb/1015Mb BootTime:Apr 21 16:44:25 PDT 2005 > Processor1: 1586 Intel ?86 F15M2S9 2670Mhz FPU > > Any ideas what is going wrong? This system has been running fine for months > until now. > > ...Stephen > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]