[sr-dev] mysql_ping in db_mysql_submit_query

[Juha Heinanen]

Juha Heinanen writes:

> I'll comment the ping code away locally and do tests without it.  If
> hanging doesn't happen without it, I'll add the module param.

Unfortunately udp receiver hangs also without mysql_ping.  Now hang
happens in insert (below).

Will try next without cluster if regular insert would work.

-- Juha


---start 4576 -----------------------------------------------------
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1".
0x00007fa641ed98a0 in __poll_nocancel () at ../sysdeps/unix/syscall-template.S:84
84	../sysdeps/unix/syscall-template.S: No such file or directory.
#0  0x00007fa641ed98a0 in __poll_nocancel () at ../sysdeps/unix/syscall-template.S:84
No locals.
#1  0x00007fa63fe5fec1 in ?? () from /usr/lib/x86_64-linux-gnu/libmariadbclient.so.18
No symbol table info available.
#2  0x00007fa63fe5ff48 in ?? () from /usr/lib/x86_64-linux-gnu/libmariadbclient.so.18
No symbol table info available.
#3  0x00007fa63fe60052 in ?? () from /usr/lib/x86_64-linux-gnu/libmariadbclient.so.18
No symbol table info available.
#4  0x00007fa63fe60115 in ?? () from /usr/lib/x86_64-linux-gnu/libmariadbclient.so.18
No symbol table info available.
#5  0x00007fa63fe3be51 in ?? () from /usr/lib/x86_64-linux-gnu/libmariadbclient.so.18
No symbol table info available.
#6  0x00007fa63fe3ccec in ?? () from /usr/lib/x86_64-linux-gnu/libmariadbclient.so.18
No symbol table info available.
#7  0x00007fa63fe2e87f in ?? () from /usr/lib/x86_64-linux-gnu/libmariadbclient.so.18
No symbol table info available.
#8  0x00007fa63fe2ffae in mysql_free_result () from /usr/lib/x86_64-linux-gnu/libmariadbclient.so.18
No symbol table info available.
#9  0x00007fa63fe31936 in mysql_real_query () from /usr/lib/x86_64-linux-gnu/libmariadbclient.so.18
No symbol table info available.
#10 0x00007fa64040c05c in db_mysql_submit_query (_h=0x7fa641258a90, _s=0x7fa64086b2d0 <sql_str>) at km_dbase.c:112
        i = 0
        code = 32678
        __func__ = "db_mysql_submit_query"
#11 0x00007fa64065ab88 in db_do_submit_query (_h=0x7fa641258a90, _query=0x7fa64086b2d0 <sql_str>, submit_query=0x7fa64040bcf1 <db_mysql_submit_query>) at db_query.c:58
        ret = 32678
        tvb = {tv_sec = 94212721508036, tv_usec = 140352034278032}
        tve = {tv_sec = 108261778181, tv_usec = 1382979469336}
        tz = {tz_minuteswest = 24, tz_dsttime = 65147}
        tdiff = 908405824
        __func__ = "db_do_submit_query"
#12 0x00007fa64065d1ca in db_do_insert_cmd (_h=0x7fa641258a90, _k=0x7fa636252960 <db_keys>, _v=0x7fa636252c40 <db_vals>, _n=24, val2str=0x7fa6404255a6 <db_mysql_val2str>, submit_query=0x7fa64040bcf1 <db_mysql_submit_query>, mode=0) at db_query.c:242
        off = 711
        ret = 322
        __func__ = "db_do_insert_cmd"
#13 0x00007fa64065d831 in db_do_insert (_h=0x7fa641258a90, _k=0x7fa636252960 <db_keys>, _v=0x7fa636252c40 <db_vals>, _n=24, val2str=0x7fa6404255a6 <db_mysql_val2str>, submit_query=0x7fa64040bcf1 <db_mysql_submit_query>) at db_query.c:257
No locals.
#14 0x00007fa640410a6a in db_mysql_insert (_h=0x7fa641258a90, _k=0x7fa636252960 <db_keys>, _v=0x7fa636252c40 <db_vals>, _n=24) at km_dbase.c:494
No locals.
#15 0x00007fa63768055c in db_cluster_insert (_h=0x7fa64145cd90, _k=0x7fa636252960 <db_keys>, _v=0x7fa636252c40 <db_vals>, _n=24) at dbcl_api.c:379
        ret = -1
        i = 5
        k = 32678
        sec = 56341002
        rc = 0
        rok = 0
        j = 0
        dbh = 0x7fa641258a90
        cls = 0x7fa641274c20
        __func__ = "db_cluster_insert"
#16 0x00007fa63601d66c in acc_db_request (rq=0x7fa6292a26f0) at acc.c:476
        m = 24
        n = 690628336
        i = 24
        o = 17
        t = 0x7fa6292a35a8
        dtime = -2.8399536906951675e-300
        __func__ = "acc_db_request"
#17 0x00007fa636030230 in acc_onreply (t=0x7fa6292a9c50, req=0x7fa6292ad410, reply=0xffffffffffffffff, code=408) at acc_logic.c:604
...