Bugs item #2636665, was opened at 2009-02-25 13:53 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=2636665&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: trunk Status: Open Resolution: None Priority: 5 Private: No Submitted By: Vasil Kolev (krokodilerian) Assigned to: Nobody/Anonymous (nobody) Summary: Bad parsing of BLOBs in db_postgres+patch Initial Comment: Excerpt from the logs: Feb 25 11:09:20 [12106] DBG:db_postgres:db_postgres_submit_query: 0x8198488 PQsendQuery(select presentity_uri,expires,event,event_id,to_user,to_domain,watcher_username,watcher_domain,callid,to_tag,from_tag ,local_cseq,remote_cseq,record_route,socket_info,contact,local_contact,version,status,reason from active_watchers ) Feb 25 11:09:20 [12106] DBG:core:db_new_result: allocate 28 bytes for result set at 0x81984e8 Feb 25 11:09:20 [12106] DBG:db_postgres:db_postgres_fetch_result: 0x8198488 PQresultStatus(PGRES_TUPLES_OK) PQgetResult(0x9807030) Feb 25 11:09:20 [12106] DBG:db_postgres:db_postgres_get_columns: 20 columns returned from the query Feb 25 11:09:20 [12106] DBG:core:db_allocate_columns: allocate 320 bytes for result columns at 0x8198ae8 ... ... ... Feb 25 11:09:20 [12106] DBG:db_postgres:db_postgres_get_columns: RES_NAMES(0x8198bf0)[13]=[record_route] Feb 25 11:09:20 [12106] DBG:db_postgres:db_postgres_get_columns: use DB_BLOB result type ... ... ... Feb 25 11:09:20 [12106] DBG:db_postgres:db_postgres_convert_rows: allocated 0 bytes for row_buf[13] at 0x8198c88 Feb 25 11:09:20 [12106] DBG:db_postgres:db_postgres_convert_rows: [0][13] Column[record_route]=[] ... ... ... Feb 25 11:09:20 [12106] DBG:db_postgres:db_postgres_str2val: converting BLOB [] Feb 25 11:09:20 [12106] DBG:db_postgres:db_postgres_str2val: got blob len 0 ... ... ... Feb 25 11:09:20 [12106] DBG:db_postgres:db_postgres_convert_rows: PQgetvalue(0x8198488,1,13)=[<98>!<F7><B7><98>!<F7><B7>^P] Feb 25 11:09:20 [12106] DBG:db_postgres:db_postgres_convert_rows: allocated 9 bytes for row_buf[13] at 0x819a7a8 Patch should be self-explanatory :) ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1086410&aid=2636665&group_id=232389 _______________________________________________ Devel mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/devel
