26 Sep
2013
26 Sep
'13
12:10 p.m.
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(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
--
Daniel-Constantin Mierla - http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio Advanced Trainings - Berlin, Oct 21-24; Miami, Nov 11-13, 2013
- more details about Kamailio trainings at http://www.asipto.com -