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