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:[email protected] ^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]= [email protected]^i[local_c seq]=167 ^I[to_tag]= 64e1a2349be974b6e58e0ee6c1e952b2.eb8e^I[from_tag]= gkaoi ^I[contact]= sip:[email protected]: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 _______________________________________________ Devel mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/devel
