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