Hello mysql,
I've found the following problem often happens to me:
Then mysqld restarted unclear (sigsegv or server reset) the mysql
client library may hang during the automatic reconnect. The backtrace
is similar to this and does not changes other time (at least 2 hours
is not enough for it)
Does anyone have any ideas about this ? It's quite annoying to check
and restart all applications connected after single mysql restart.
(gdb) bt
#0 0xe17d224 in __libc_read () from /lib/libc.so.6
#1 0xe04733c in __DTOR_END__ () from /lib/libpthread.so.0
#2 0x80c5e02 in vio_read (vio=0xac4f6e8, buf=0x82a4250 "Á\fÏ\bXIÝ\n", size=4) at
violite.c:185
#3 0x80c55b0 in my_real_read (net=0xdf1ff364, complen=0xdf1fef50) at net.c:478
#4 0x80c57c9 in my_net_read (net=0xdf1ff364) at net.c:624
#5 0x80c1d7b in net_safe_read (mysql=0xdf1ff364) at libmysql.c:297
#6 0x80c2e3c in mysql_real_connect (mysql=0xdf1ff364, host=0xad3f308 "maindb.local",
user=0xcd9db50 "layers",
passwd=0x9069bf0 "", db=0xd51a390 "counter", port=3306, unix_socket=0x0,
client_flag=8333) at libmysql.c:1351
#7 0x80c373b in mysql_reconnect (mysql=0xb0bdb20) at libmysql.c:1576
#8 0x80c1ebf in simple_command (mysql=0xb0bdb20, command=COM_QUERY,
arg=0x85f5810 "select loads from quickstat where counter_id=16766", length=50,
skipp_check=1 '\001') at libmysql.c:429
#9 0x80c4a7f in mysql_real_query (mysql=0xb0bdb20, query=0x85f5810 "select loads from
quickstat where counter_id=16766",
length=50) at libmysql.c:1767
#10 0x80c4a33 in mysql_query (mysql=0xb0bdb20, query=0x85f5810 "select loads from
quickstat where counter_id=16766")
at libmysql.c:1698
#11 0x8057bce in Query::Open (this=0xdcbf100) at query.cpp:113
#12 0x80ad3cd in GetLoadsFromQuickStat (Q=0xdcbf100, cid=@0xdf1ff860) at
startbuild.cpp:227
#13 0x80ac208 in startBuild (pRI=0xe589d20, pQSet=0x82b57f8) at startbuild.cpp:166
#14 0x8080355 in TblQueue::start (this=0x84fcba8) at controller.cpp:321
#15 0x807fd4e in TblQueue::add (this=0x84fcba8, pRI=0xe589d20) at controller.cpp:242
#16 0x8081867 in QueueController::add (this=0xdffffaf4, pRI=0xe589d20) at
controller.cpp:467
#17 0x80a1cb0 in addRequest (pRI=0xe589d20) at server.cpp:434
#18 0xe038ca3 in pthread_start_thread () from /lib/libpthread.so.0
(gdb) quit
The program is running. Quit anyway (and detach it)? (y or n) y
Detaching from program: /usr/spylog/bin/layers, process 32444
ruby:~ # mcedit /etc/my.cnf
--
Best regards,
Peter mailto:[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
