| Gleb Paharenko 2005-04-27, 7:23 am |
| Hello.
Your version of MySQL is rather old. Does the problem
remains after upgrading?
"Stephen Rasku" <srasku@tantalus.com> 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
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@ensita.net
/_/ /_/\_, /___/\___\_\___/ 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/mysql? unsub...sie.nctu.edu.tw
|