[OpenSIPS-Devel] [ opensips-Bugs-3207002 ] db_mysql core dump on stop - dialog_update

[SourceForge.net]

Bugs item #3207002, was opened at 2011-03-11 22:45
Message generated for change (Comment added) made by nobody
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=3207002&group_id=232389

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: modules
Group: 1.6.x
Status: Closed
Resolution: Fixed
Priority: 8
Private: No
Submitted By: Patrick Ferguson (patrickferguson)
Assigned to: Nobody/Anonymous (nobody)
Summary: db_mysql core dump on stop - dialog_update

Initial Comment:
I'm still having issues with the re-reading of Context variables from mysql

ERROR:acc:acc_loaded_callback: cannot fetch flags string value

and I'm back to having blank data again on call records after a reset.   Could this be related to a mysql issue?  I'm seeing a log of core dumps after I restart.

in wrapper_single_mysql_stmt_execute dbase.c:86
db_mysql_do_prepared_query at dbase.c:1021
in dialog_update_db at dlg_db_handler.c:988


----------------------------------------------------------------------

Comment By: Nobody/Anonymous (nobody)
Date: 2011-05-11 17:06

Message:
Ok, I've updated my version to 7938.  I'm still getting the issue


Program terminated with signal 11, Segmentation fault.
#0  0x0000003b8ca72bf6 in _int_malloc () from /lib64/libc.so.6
(gdb) bt
#0  0x0000003b8ca72bf6 in _int_malloc () from /lib64/libc.so.6
#1  0x0000003b8ca74bee in malloc () from /lib64/libc.so.6
#2  0x00000035c4827832 in my_malloc () from
/usr/lib64/mysql/libmysqlclient.so.15
#3  0x00000035c4827953 in my_memdup () from
/usr/lib64/mysql/libmysqlclient.so.15
#4  0x00000035c482542a in cli_stmt_execute () from
/usr/lib64/mysql/libmysqlclient.so.15
#5  0x00000035c4826105 in mysql_stmt_execute () from
/usr/lib64/mysql/libmysqlclient.so.15
#6  0x00002b0ef698cbf4 in wrapper_single_mysql_stmt_execute
(conn=0x7e3e50, query=0x2b0ef6ba3f50, v=0x7fffdf222e90, n=7, 
    uv=0x7fffdf222cd0, un=2) at dbase.c:86
#7  db_mysql_do_prepared_query (conn=0x7e3e50, query=0x2b0ef6ba3f50,
v=0x7fffdf222e90, n=7, uv=0x7fffdf222cd0, un=2) at dbase.c:562
#8  0x00002b0ef698dfd3 in db_mysql_update (_h=0x7e3e50, _k=0x7fffdf222f70,
_o=0x0, _v=0x7fffdf222cd0, _uk=0x7fffdf222fe0, 
    _uv=0x7fffdf222e90, _n=2, _un=7) at dbase.c:1021
#9  0x00002b0ef7c6121c in dialog_update_db (ticks=<value optimized out>,
param=<value optimized out>) at dlg_db_handler.c:988
#10 0x00002b0ef7c568aa in mod_destroy () at dialog.c:734
#11 0x000000000047abd4 in destroy_modules () at sr_module.c:370
#12 0x000000000042667b in cleanup (show_status=1) at main.c:336
#13 0x0000000000427a2a in handle_sigs () at main.c:469
#14 0x000000000042ba7b in main_loop (argc=<value optimized out>,
argv=0x20) at main.c:914
#15 main (argc=<value optimized out>, argv=0x20) at main.c:1393


----------------------------------------------------------------------

Comment By: Anca Vamanu (anca_vamanu)
Date: 2011-04-05 10:34

Message:
Hi Patrick,

We found yesterday the source of this bug and fixed it in rev 7859. Please
update your code.

Regards,
Anca Vamanu


----------------------------------------------------------------------

Comment By: Patrick Ferguson (patrickferguson)
Date: 2011-03-21 16:21

Message:
Mysql Version:  Server version: 5.0.77 Source distribution


----------------------------------------------------------------------

Comment By: Patrick Ferguson (patrickferguson)
Date: 2011-03-21 15:23

Message:
Here is the backtrace from gdb

#0  0x0000003d31230265 in raise () from /lib64/libc.so.6
#1  0x0000003d31231d10 in abort () from /lib64/libc.so.6
#2  0x0000003d3126a84b in __libc_message () from /lib64/libc.so.6
#3  0x0000003d31272fae in _int_malloc () from /lib64/libc.so.6
#4  0x0000003d31274cde in malloc () from /lib64/libc.so.6
#5  0x0000003d31a27832 in my_malloc () from
/usr/lib64/mysql/libmysqlclient.so.15
#6  0x0000003d31a27953 in my_memdup () from
/usr/lib64/mysql/libmysqlclient.so.15
#7  0x0000003d31a2542a in cli_stmt_execute () from
/usr/lib64/mysql/libmysqlclient.so.15
#8  0x0000003d31a26105 in mysql_stmt_execute () from
/usr/lib64/mysql/libmysqlclient.so.15
#9  0x00002ba4c1078bf4 in wrapper_single_mysql_stmt_execute
(conn=0x7da308, query=0x2ba4c128ff50, v=0x7fffdde0ba30, n=7, 
    uv=0x7fffdde0b870, un=2) at dbase.c:86
#10 db_mysql_do_prepared_query (conn=0x7da308, query=0x2ba4c128ff50,
v=0x7fffdde0ba30, n=7, uv=0x7fffdde0b870, un=2) at dbase.c:562
#11 0x00002ba4c1079fd3 in db_mysql_update (_h=0x7da308, _k=0x7fffdde0bb10,
_o=0x0, _v=0x7fffdde0b870, _uk=0x7fffdde0bb80, 
    _uv=0x7fffdde0ba30, _n=2, _un=7) at dbase.c:1021
#12 0x00002ba4c38c920c in dialog_update_db (ticks=<value optimized out>,
param=<value optimized out>) at dlg_db_handler.c:988
#13 0x00002ba4c38be89d in mod_destroy () at dialog.c:734
#14 0x000000000047b074 in destroy_modules () at sr_module.c:370
#15 0x000000000042667b in cleanup (show_status=1) at main.c:336
#16 0x0000000000427a2a in handle_sigs () at main.c:469
#17 0x000000000042ba7b in main_loop (argc=<value optimized out>,
argv=0x18) at main.c:914
#18 main (argc=<value optimized out>, argv=0x18) at main.c:1393

----------------------------------------------------------------------

Comment By: Patrick Ferguson (patrickferguson)
Date: 2011-03-17 14:51

Message:
As a test, I set unixODBC to use MySQL only on dialog.

----------------------------------------------------------------------

Comment By: Patrick Ferguson (patrickferguson)
Date: 2011-03-17 14:49

Message:
this is now happening with both db_mysql and db_unixodbc

It appears to dump core when closing the DB connection.
Line 199 of con.c

Patrick

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=3207002&group_id=232389