Hello,
We use jabberd-2.2.9 at FreeBSD 7.2 with MySQL 5.1.44 with one
additional patch:
http://www.mail-archive.com/jabberd2@lists.xiaoka.com/msg01358.html
Sometimes jabberd stops working.
All processes(sm, c2s, s2s, router) are exists.
There are nor anything strange, nor error messages in log files.
Sometimes sm dies.
Here are output from core files:
(gdb) where
#0 0x28735bf9 in my_real_read () from /usr/local/lib/mysql/libmysqlclient.so.16
#1 0x28735dcb in my_net_read () from /usr/local/lib/mysql/libmysqlclient.so.16
#2 0x28730d48 in cli_safe_read () from
/usr/local/lib/mysql/libmysqlclient.so.16
#3 0x28731405 in cli_read_query_result () from
/usr/local/lib/mysql/libmysqlclient.so.16
#4 0x2872fa04 in mysql_real_query () from
/usr/local/lib/mysql/libmysqlclient.so.16
#5 0x28712025 in mysql_query () from /usr/local/lib/mysql/libmysqlclient.so.16
#6 0x285e0298 in _st_mysql_get (drv=0x2861e040, type=0xbfbfe430
"jabber_status", owner=0x69731460 "anto...@peterhost.ru",
filter=0x0, os=0xbfbfe570) at storage_mysql.c:332
#7 0x08057c52 in storage_get (st=0x28604070, type=0x285f9b44 "status",
owner=0x69731460 "anto...@peterhost.ru",
filter=0x0, os=0xbfbfe570) at storage.c:241
#8 0x285f958c in _status_in_sess (mi=0x28601160, sess=0x288bc800,
pkt=0x288a86a0) at mod_status.c:163
#9 0x0805058a in mm_in_sess (mm=0x2862a080, sess=0x288bc800, pkt=0x288a86a0)
at mm.c:451
#10 0x2879e085 in _session_in_router (mi=0x28601380, pkt=0x288a86a0) at
mod_session.c:295
#11 0x08050716 in mm_in_router (mm=0x2862a080, pkt=0x288a86a0) at mm.c:483
#12 0x0804d9c9 in dispatch (sm=0x28602000, pkt=0x288a86a0) at dispatch.c:86
#13 0x0805688e in sm_sx_callback (s=0x28620160, e=event_PACKET,
data=0x4505b480, arg=0x28602000) at sm.c:230
#14 0x0805bbea in __sx_event (file=0x806fb26 "io.c", line=156, s=0x28620160,
e=event_PACKET, data=0x4505b480) at sx.c:328
#15 0x08059cc1 in _sx_process_read (s=0x28620160, buf=0x74c89f60) at io.c:156
#16 0x0805a075 in sx_can_read (s=0x28620160) at io.c:243
#17 0x0805697a in sm_mio_callback (m=0x28601e60, a=action_READ, fd=0x28653050,
data=0x0, arg=0x28602000) at sm.c:256
#18 0x08062891 in _mio_run (m=0x28601e60, timeout=5) at mio_impl.h:261
#19 0x0804efad in main (argc=3, argv=0xbfbfecdc) at main.c:408
(gdb) where
#0 0x28733349 in my_real_read () from /usr/local/lib/mysql/libmysqlclient.so.15
#1 0x287335dc in my_net_read () from /usr/local/lib/mysql/libmysqlclient.so.15
#2 0x2872e3c8 in cli_safe_read () from
/usr/local/lib/mysql/libmysqlclient.so.15
#3 0x2872ea55 in cli_read_query_result () from
/usr/local/lib/mysql/libmysqlclient.so.15
#4 0x2872d104 in mysql_real_query () from
/usr/local/lib/mysql/libmysqlclient.so.15
#5 0x28711505 in mysql_query () from /usr/local/lib/mysql/libmysqlclient.so.15
#6 0x285e0298 in _st_mysql_get (drv=0x2861e040, type=0xbfbfe410
"jabber_status",
owner=0x63161840 "monitor...@peterhost.ru", filter=0x0, os=0xbfbfe54c) at
storage_mysql.c:332
#7 0x08057c52 in storage_get (st=0x28604070, type=0x285f9b44 "status",
owner=0x63161840 "monitor...@peterhost.ru",
filter=0x0, os=0xbfbfe54c) at storage.c:241
#8 0x285f9403 in _status_sess_end (mi=0x286010e0, sess=0x28832000) at
mod_status.c:129
#9 0x08050421 in mm_sess_end (mm=0x2862a080, sess=0x28832000) at mm.c:423
#10 0x0805571d in _sess_end_guts (sess=0x28832000) at sess.c:70
#11 0x080557f8 in sess_end (sess=0x28832000) at sess.c:88
#12 0x28791b0d in _session_in_router (mi=0x28601360, pkt=0x286ee430) at
mod_session.c:219
#13 0x08050716 in mm_in_router (mm=0x2862a080, pkt=0x286ee430) at mm.c:483
#14 0x0804d9c9 in dispatch (sm=0x28602000, pkt=0x286ee430) at dispatch.c:86
#15 0x0805688e in sm_sx_callback (s=0x28620160, e=event_PACKET,
data=0x2861f7c0, arg=0x28602000) at sm.c:230
#16 0x0805bbea in __sx_event (file=0x806fb26 "io.c", line=156, s=0x28620160,
e=event_PACKET, data=0x2861f7c0) at sx.c:328
#17 0x08059cc1 in _sx_process_read (s=0x28620160, buf=0x63161860) at io.c:156
#18 0x0805a075 in sx_can_read (s=0x28620160) at io.c:243
#19 0x0805697a in sm_mio_callback (m=0x28601e40, a=action_READ, fd=0x28653050,
data=0x0, arg=0x28602000) at sm.c:256
#20 0x08062891 in _mio_run (m=0x28601e40, timeout=5) at mio_impl.h:261
#21 0x0804efad in main (argc=3, argv=0xbfbfed0c) at main.c:408
#0 0x28733349 in my_real_read () from /usr/local/lib/mysql/libmysqlclient.so.15
#1 0x287335dc in my_net_read () from /usr/local/lib/mysql/libmysqlclient.so.15
#2 0x2872e3c8 in cli_safe_read () from
/usr/local/lib/mysql/libmysqlclient.so.15
#3 0x2872ea55 in cli_read_query_result () from
/usr/local/lib/mysql/libmysqlclient.so.15
#4 0x2872d104 in mysql_real_query () from
/usr/local/lib/mysql/libmysqlclient.so.15
#5 0x28711505 in mysql_query () from /usr/local/lib/mysql/libmysqlclient.so.15
#6 0x285e0298 in _st_mysql_get (drv=0x2861e040, type=0xbfbfe410
"jabber_status",
owner=0x63161840 "monitor...@peterhost.ru", filter=0x0, os=0xbfbfe54c) at
storage_mysql.c:332
#7 0x08057c52 in storage_get (st=0x28604070, type=0x285f9b44 "status",
owner=0x63161840 "monitor...@peterhost.ru",
filter=0x0, os=0xbfbfe54c) at storage.c:241
#8 0x285f9403 in _status_sess_end (mi=0x286010e0, sess=0x28832000) at
mod_status.c:129
#9 0x08050421 in mm_sess_end (mm=0x2862a080, sess=0x28832000) at mm.c:423
#10 0x0805571d in _sess_end_guts (sess=0x28832000) at sess.c:70
#11 0x080557f8 in sess_end (sess=0x28832000) at sess.c:88
#12 0x28791b0d in _session_in_router (mi=0x28601360, pkt=0x286ee430) at
mod_session.c:219
#13 0x08050716 in mm_in_router (mm=0x2862a080, pkt=0x286ee430) at mm.c:483
#14 0x0804d9c9 in dispatch (sm=0x28602000, pkt=0x286ee430) at dispatch.c:86
#15 0x0805688e in sm_sx_callback (s=0x28620160, e=event_PACKET,
data=0x2861f7c0, arg=0x28602000) at sm.c:230
#16 0x0805bbea in __sx_event (file=0x806fb26 "io.c", line=156, s=0x28620160,
e=event_PACKET, data=0x2861f7c0) at sx.c:328
#17 0x08059cc1 in _sx_process_read (s=0x28620160, buf=0x63161860) at io.c:156
#18 0x0805a075 in sx_can_read (s=0x28620160) at io.c:243
#19 0x0805697a in sm_mio_callback (m=0x28601e40, a=action_READ, fd=0x28653050,
data=0x0, arg=0x28602000) at sm.c:256
#20 0x08062891 in _mio_run (m=0x28601e40, timeout=5) at mio_impl.h:261
#21 0x0804efad in main (argc=3, argv=0xbfbfed0c) at main.c:408
Before mysql 5.1.44 we have used mysql version 5.0.*.
The problem is in libmysqlclient?
--
Dmitry Banshchikov
--
To unsubscribe send a mail to jabberd2+unsubscr...@lists.xiaoka.com
