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]

Reply via email to