[OpenSIPS-Devel] Crash [presence]

[Iñaki Baz Castillo]

El Lunes, 15 de Diciembre de 2008, Iñaki Baz Castillo escribió:
> El Miércoles, 10 de Diciembre de 2008, Anca Vamanu escribió:
> > I have been running simple presence server with pua_usrloc with an
> > expireses of 60 for half an hour now and have not experienced the crash
> > yet.
> > Are you sure you have not corrupted the database? Can you please start
> > fresh: stop the server, empty database tables, start the server again.
>
> After I've emptied presence related tables, I don't
> see "ERROR:db_mysql:db_mysql_submit_query" error anymore!!!
>
> (The MySQL ERROR is another bug/thread I've open and for which I can't find
> the solution/cause).
>
> I continue testing it.

Agai forget it, it remains ocurring after some time:

---------
Dec 15 13:58:12 stock /usr/sbin/opensips[20551]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this 
comman
d now
Dec 15 13:58:12 stock /usr/sbin/opensips[20551]: ERROR:core:db_do_delete: error while submitting query
Dec 15 13:58:12 stock /usr/sbin/opensips[20551]: ERROR:pua:db_update: while deleting from db table pua
Dec 15 13:58:12 stock /usr/sbin/opensips[20551]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this 
comman
d now
Dec 15 13:58:12 stock /usr/sbin/opensips[20551]: ERROR:core:db_do_query: error while submitting query
Dec 15 13:58:12 stock /usr/sbin/opensips[20551]: ERROR:xcap_client:query_xcap_update: in sql query
Dec 15 13:58:12 stock /usr/sbin/opensips[20551]: DBG:presence:printf_subs:  ^I[pres_uri]= sip:ibc at aliax.net ^I[to_user]= ibc^I[to_domain]= aliax.net 
^I[w_use
r]= ibc^I[w_domain]= aliax.net ^I[event]= presence ^I[status]= active ^I[expires]= 1229345902 ^I[callid]= 
jlihnbqhivogmld at portatil-aliax.homeip.net^I[local_c
seq]=167 ^I[to_tag]= 64e1a2349be974b6e58e0ee6c1e952b2.eb8e^I[from_tag]= gkaoi ^I[contact]= 
sip:ibc_aliax_net at 87.218.217.85:39809;transport=tcp^I[record_route
]=
Dec 15 13:58:12 stock /usr/sbin/opensips[20551]: DBG:presence:update_db_subs: UPDATEDB_FLAG
Dec 15 13:58:12 stock /usr/sbin/opensips[20551]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this 
comman
d now
Dec 15 13:58:12 stock /usr/sbin/opensips[20551]: ERROR:core:db_do_update: error while submitting query
Dec 15 13:58:12 stock /usr/sbin/opensips[20551]: ERROR:presence:update_db_subs: updating in database
Dec 15 13:58:12 stock /usr/sbin/opensips[20551]: DBG:presence:msg_watchers_clean: cleaning pending subscriptions
Dec 15 13:58:12 stock /usr/sbin/opensips[20551]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this 
comman
d now
Dec 15 13:58:12 stock /usr/sbin/opensips[20551]: ERROR:core:db_do_query: error while submitting query

....
---------------


But I've realized that the OpenSIPS process with this erro is always 
the SAME! so most probably it's in fact the process acting as a 
presence server. Am I right?




-- 
Iñaki Baz Castillo