[sr-dev] continuous rls related db_mysql errors

[Juha Heinanen]

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