[OpenSER-Devel] publish crash

[Juha Heinanen]

anca, henning,

i studied a bit more presence/notify.c/get_subs_db db query problem.
syslog shows this:

Mar 31 15:02:23 tutpro /usr/sbin/openser[16750]: DBG:presence:get_subs_db: querying database table = active_watchers 
Mar 31 15:02:23 tutpro /usr/sbin/openser[16750]: DBG:core:db_new_result: allocate 28 bytes for result set at 0x8215480 
Mar 31 15:02:23 tutpro /usr/sbin/openser[16750]: DBG:db_mysql:db_mysql_get_columns: 2 columns returned from the query 
Mar 31 15:02:23 tutpro /usr/sbin/openser[16750]: DBG:core:db_allocate_columns: allocate 8 bytes for result names at 0x82150e8 
Mar 31 15:02:23 tutpro /usr/sbin/openser[16750]: DBG:core:db_allocate_columns: allocate 8 bytes for result types at 0x8215108 
Mar 31 15:02:23 tutpro /usr/sbin/openser[16750]: DBG:db_mysql:db_mysql_get_columns: allocate 8 bytes for RES_NAMES[0] at 0x82154f8 
Mar 31 15:02:23 tutpro /usr/sbin/openser[16750]: DBG:db_mysql:db_mysql_get_columns: RES_NAMES(0x82154f8)[0]=[status] 
Mar 31 15:02:23 tutpro /usr/sbin/openser[16750]: DBG:db_mysql:db_mysql_get_columns: allocate 8 bytes for RES_NAMES[1] at 0x8215510 
Mar 31 15:02:23 tutpro /usr/sbin/openser[16750]: DBG:db_mysql:db_mysql_get_columns: RES_NAMES(0x8215510)[1]=[reason] 
Mar 31 15:02:23 tutpro /usr/sbin/openser[16750]: DBG:db_mysql:db_mysql_convert_rows: allocate 8 bytes for rows at 0x8215520
Mar 31 15:02:23 tutpro /usr/sbin/openser[16750]: DBG:db_mysql:db_mysql_convert_row: allocate 40 bytes for row values at 0x8215530
Mar 31 15:02:23 tutpro /usr/sbin/openser[16750]: DBG:db_mysql:db_mysql_str2val: converting INT [1] 

why there is only 2 columns returned from the query and why their names
are [status] and [reason] instead of [to_user], [to_domain], etc?

for comparison, here is the same kind of output from location table
query, which looks as one would expect:

Mar 31 07:47:02 tutpro /usr/sbin/openser[11709]: DBG:core:db_new_result: allocate 28 bytes for result set at 0x8215308 
Mar 31 07:47:02 tutpro /usr/sbin/openser[11709]: DBG:db_mysql:db_mysql_get_columns: 13 columns returned from the query 
Mar 31 07:47:02 tutpro /usr/sbin/openser[11709]: DBG:core:db_allocate_columns: allocate 52 bytes for result names at 0x82150d0 
Mar 31 07:47:02 tutpro /usr/sbin/openser[11709]: DBG:core:db_allocate_columns: allocate 52 bytes for result types at 0x8215348 
Mar 31 07:47:02 tutpro /usr/sbin/openser[11709]: DBG:db_mysql:db_mysql_get_columns: allocate 8 bytes for RES_NAMES[0] at 0x8215208 
Mar 31 07:47:02 tutpro /usr/sbin/openser[11709]: DBG:db_mysql:db_mysql_get_columns: RES_NAMES(0x8215208)[0]=[contact] 
Mar 31 07:47:02 tutpro /usr/sbin/openser[11709]: DBG:db_mysql:db_mysql_get_columns: allocate 8 bytes for RES_NAMES[1] at 0x82151f8 
Mar 31 07:47:02 tutpro /usr/sbin/openser[11709]: DBG:db_mysql:db_mysql_get_columns: RES_NAMES(0x82151f8)[1]=[expires] 
Mar 31 07:47:02 tutpro /usr/sbin/openser[11709]: DBG:db_mysql:db_mysql_get_columns: allocate 8 bytes for RES_NAMES[2] at 0x8214d98 
Mar 31 07:47:02 tutpro /usr/sbin/openser[11709]: DBG:db_mysql:db_mysql_get_columns: RES_NAMES(0x8214d98)[2]=[q] 
Mar 31 07:47:02 tutpro /usr/sbin/openser[11709]: DBG:db_mysql:db_mysql_get_columns: allocate 8 bytes for RES_NAMES[3] at 0x8215228 
Mar 31 07:47:02 tutpro /usr/sbin/openser[11709]: DBG:db_mysql:db_mysql_get_columns: RES_NAMES(0x8215228)[3]=[callid] 
...

-- juha