Do you still know what was previous version/last commit you run and was ok? Maybe the issue can be spotted in commit logs. Lately I haven't worked on presence, maybe Peter or Hugh have more clues.
Cheers, Daniel
On 9/26/13 11:05 AM, Juha Heinanen wrote:
i restarted presence server and it started fine at
Sep 26 11:57:30 siika /usr/sbin/pres-serv[2671]: INFO: ctl [io_listener.c:225]: io_listen_loop(): io_listen_loop: using epoll_lt io watch method (config)
mysql related errors started to appear 1 min 40 seconds later and the first was this:
Sep 26 11:59:10 siika /usr/sbin/pres-serv[2669]: ERROR: db_mysql [km_dbase.c:122]: db_mysql_submit_query(): driver error on query: Table 'rls_presentity' was not locked with LOCK TABLES Sep 26 11:59:10 siika /usr/sbin/pres-serv[2669]: ERROR: <core> [db_query.c:291]: db_do_delete(): error while submitting query Sep 26 11:59:10 siika /usr/sbin/pres-serv[2669]: ERROR: rls [resource_notify.c:1193]: rls_presentity_clean(): in sql delete
after that mysql errors started to repeat themselves at regular intervals:
Sep 26 11:59:14 siika /usr/sbin/pres-serv[2672]: ERROR: db_mysql [km_dbase.c:122]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server during query Sep 26 11:59:14 siika /usr/sbin/pres-serv[2672]: ERROR: <core> [db_query.c:181]: db_do_raw_query(): error while submitting query Sep 26 11:59:14 siika /usr/sbin/pres-serv[2672]: ERROR: db_mysql [km_dbase.c:557]: db_mysql_start_transaction(): executing raw_query Sep 26 11:59:14 siika /usr/sbin/pres-serv[2672]: ERROR: rls [resource_notify.c:960]: timer_send_full_state_notifies(): in start_transaction Sep 26 11:59:18 siika /usr/sbin/pres-serv[2672]: ERROR: db_mysql [km_dbase.c:122]: db_mysql_submit_query(): driver error on query: Lost connection to MySQL server during query Sep 26 11:59:18 siika /usr/sbin/pres-serv[2672]: ERROR: <core> [db_query.c:181]: db_do_raw_query(): error while submitting query Sep 26 11:59:18 siika /usr/sbin/pres-serv[2672]: ERROR: db_mysql [km_dbase.c:557]: db_mysql_start_transaction(): executing raw_query Sep 26 11:59:18 siika /usr/sbin/pres-serv[2672]: ERROR: rls [resource_notify.c:960]: timer_send_full_state_notifies(): in start_transaction ...
-- juha
sr-dev mailing list sr-dev@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev