[sr-dev] continuous rls related db_mysql errors

[Daniel-Constantin Mierla]

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 at 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 -