@miconda here's a log of Kamailio starting up vs. when the error occurs for
three different timer processes (restarts):
```
Feb 5 12:36:36 /usr/sbin/kamailio[19627]: DEBUG: db_cluster [dbcl_api.c:269]:
db_cluster_init(): initializing with cluster [cluster://k2]
Feb 5 12:36:36 /usr/sbin/kamailio[19627]: DEBUG: db_cluster [dbcl_api.c:269]:
db_cluster_init(): initializing with cluster [cluster://k1]
Feb 5 12:37:42 /usr/sbin/kamailio[19627]: DEBUG: db_cluster [dbcl_api.c:483]:
db_cluster_use_table(): use table (missed_calls) - cluster [k2]
Feb 5 12:37:42 /usr/sbin/kamailio[19627]: DEBUG: db_cluster [dbcl_api.c:492]:
db_cluster_use_table(): set read table (missed_calls) - cluster [k2] (9/0)
Feb 5 12:37:42 /usr/sbin/kamailio[19627]: DEBUG: db_cluster [dbcl_api.c:502]:
db_cluster_use_table(): set write table (missed_calls) - cluster [k2] (9/0)
Feb 5 12:37:42 /usr/sbin/kamailio[19627]: DEBUG: db_cluster [dbcl_api.c:492]:
db_cluster_use_table(): set read table (missed_calls) - cluster [k2] (1/0)
Feb 5 12:37:42 /usr/sbin/kamailio[19627]: DEBUG: db_cluster [dbcl_api.c:502]:
db_cluster_use_table(): set write table (missed_calls) - cluster [k2] (1/0)
Feb 5 12:37:42 /usr/sbin/kamailio[19627]: DEBUG: db_cluster [dbcl_api.c:378]:
db_cluster_insert(): executing db cluster insert command
Feb 5 12:37:42 /usr/sbin/kamailio[19627]: DEBUG: db_cluster [dbcl_api.c:379]:
db_cluster_insert(): serial operation - cluster [k2] (9/0)
Feb 5 12:37:42 /usr/sbin/kamailio[19627]: DEBUG: db_cluster [dbcl_api.c:368]:
db_cluster_raw_query(): executing db cluster raw query command
Feb 5 12:37:42 /usr/sbin/kamailio[19627]: DEBUG: db_cluster [dbcl_api.c:369]:
db_cluster_raw_query(): serial operation - cluster [k1] (9/0)
Feb 5 12:37:42 /usr/sbin/kamailio[19627]: WARNING: db_mysql [km_dbase.c:84]:
db_mysql_submit_query(): driver error on ping: Lost connection to MySQL server
during query
Feb 5 12:37:42 /usr/sbin/kamailio[19627]: ERROR: db_mysql [km_dbase.c:124]:
db_mysql_submit_query(): driver error on query: SSL connection error: socket
layer receive error (2026)
Feb 5 12:37:42 /usr/sbin/kamailio[19627]: DEBUG: db_cluster [dbcl_api.c:369]:
db_cluster_raw_query(): serial operation - failre on cluster [k1] (9/0)
Feb 5 12:37:42 /usr/sbin/kamailio[19627]: DEBUG: db_cluster [dbcl_api.c:369]:
db_cluster_raw_query(): serial operation - cluster [k1] (1/0)
Feb 5 12:31:42 /usr/sbin/kamailio[13312]: DEBUG: db_cluster [dbcl_api.c:269]:
db_cluster_init(): initializing with cluster [cluster://k1]
Feb 5 12:31:42 /usr/sbin/kamailio[13312]: DEBUG: db_cluster [dbcl_api.c:269]:
db_cluster_init(): initializing with cluster [cluster://k2]
Feb 5 12:32:42 /usr/sbin/kamailio[13312]: DEBUG: db_cluster [dbcl_api.c:483]:
db_cluster_use_table(): use table (missed_calls) - cluster [k2]
Feb 5 12:32:42 /usr/sbin/kamailio[13312]: DEBUG: db_cluster [dbcl_api.c:492]:
db_cluster_use_table(): set read table (missed_calls) - cluster [k2] (9/0)
Feb 5 12:32:42 /usr/sbin/kamailio[13312]: DEBUG: db_cluster [dbcl_api.c:502]:
db_cluster_use_table(): set write table (missed_calls) - cluster [k2] (9/0)
Feb 5 12:32:42 /usr/sbin/kamailio[13312]: DEBUG: db_cluster [dbcl_api.c:492]:
db_cluster_use_table(): set read table (missed_calls) - cluster [k2] (1/0)
Feb 5 12:32:42 /usr/sbin/kamailio[13312]: DEBUG: db_cluster [dbcl_api.c:502]:
db_cluster_use_table(): set write table (missed_calls) - cluster [k2] (1/0)
Feb 5 12:32:42 /usr/sbin/kamailio[13312]: DEBUG: db_cluster [dbcl_api.c:378]:
db_cluster_insert(): executing db cluster insert command
Feb 5 12:32:42 /usr/sbin/kamailio[13312]: DEBUG: db_cluster [dbcl_api.c:379]:
db_cluster_insert(): serial operation - cluster [k2] (9/0)
Feb 5 12:32:42 /usr/sbin/kamailio[13312]: DEBUG: db_cluster [dbcl_api.c:368]:
db_cluster_raw_query(): executing db cluster raw query command
Feb 5 12:32:42 /usr/sbin/kamailio[13312]: DEBUG: db_cluster [dbcl_api.c:369]:
db_cluster_raw_query(): serial operation - cluster [k1] (9/0)
Feb 5 12:32:42 /usr/sbin/kamailio[13312]: WARNING: db_mysql [km_dbase.c:84]:
db_mysql_submit_query(): driver error on ping: Lost connection to MySQL server
during query
Feb 5 12:32:42 /usr/sbin/kamailio[13312]: ERROR: db_mysql [km_dbase.c:124]:
db_mysql_submit_query(): driver error on query: SSL connection error: socket
layer receive error (2026)
Feb 5 12:32:42 /usr/sbin/kamailio[13312]: DEBUG: db_cluster [dbcl_api.c:369]:
db_cluster_raw_query(): serial operation - failre on cluster [k1] (9/0)
Feb 5 12:32:42 /usr/sbin/kamailio[13312]: DEBUG: db_cluster [dbcl_api.c:369]:
db_cluster_raw_query(): serial operation - cluster [k1] (1/0)
Feb 5 11:39:03 /usr/sbin/kamailio[6663]: DEBUG: db_cluster [dbcl_api.c:269]:
db_cluster_init(): initializing with cluster [cluster://k2]
Feb 5 11:39:03 /usr/sbin/kamailio[6663]: DEBUG: db_cluster [dbcl_api.c:269]:
db_cluster_init(): initializing with cluster [cluster://k1]
Feb 5 11:40:14 /usr/sbin/kamailio[6663]: DEBUG: db_cluster [dbcl_api.c:483]:
db_cluster_use_table(): use table (missed_calls) - cluster [k2]
Feb 5 11:40:14 /usr/sbin/kamailio[6663]: DEBUG: db_cluster [dbcl_api.c:492]:
db_cluster_use_table(): set read table (missed_calls) - cluster [k2] (9/0)
Feb 5 11:40:14 /usr/sbin/kamailio[6663]: DEBUG: db_cluster [dbcl_api.c:502]:
db_cluster_use_table(): set write table (missed_calls) - cluster [k2] (9/0)
Feb 5 11:40:14 /usr/sbin/kamailio[6663]: DEBUG: db_cluster [dbcl_api.c:492]:
db_cluster_use_table(): set read table (missed_calls) - cluster [k2] (1/0)
Feb 5 11:40:14 /usr/sbin/kamailio[6663]: DEBUG: db_cluster [dbcl_api.c:502]:
db_cluster_use_table(): set write table (missed_calls) - cluster [k2] (1/0)
Feb 5 11:40:14 /usr/sbin/kamailio[6663]: DEBUG: db_cluster [dbcl_api.c:378]:
db_cluster_insert(): executing db cluster insert command
Feb 5 11:40:14 /usr/sbin/kamailio[6663]: DEBUG: db_cluster [dbcl_api.c:379]:
db_cluster_insert(): serial operation - cluster [k2] (9/0)
Feb 5 11:40:14 /usr/sbin/kamailio[6663]: DEBUG: db_cluster [dbcl_api.c:483]:
db_cluster_use_table(): use table (acc) - cluster [k2]
Feb 5 11:40:14 /usr/sbin/kamailio[6663]: DEBUG: db_cluster [dbcl_api.c:492]:
db_cluster_use_table(): set read table (acc) - cluster [k2] (9/0)
Feb 5 11:40:14 /usr/sbin/kamailio[6663]: DEBUG: db_cluster [dbcl_api.c:502]:
db_cluster_use_table(): set write table (acc) - cluster [k2] (9/0)
Feb 5 11:40:14 /usr/sbin/kamailio[6663]: DEBUG: db_cluster [dbcl_api.c:492]:
db_cluster_use_table(): set read table (acc) - cluster [k2] (1/0)
Feb 5 11:40:14 /usr/sbin/kamailio[6663]: DEBUG: db_cluster [dbcl_api.c:502]:
db_cluster_use_table(): set write table (acc) - cluster [k2] (1/0)
Feb 5 11:40:14 /usr/sbin/kamailio[6663]: DEBUG: db_cluster [dbcl_api.c:378]:
db_cluster_insert(): executing db cluster insert command
Feb 5 11:40:14 /usr/sbin/kamailio[6663]: DEBUG: db_cluster [dbcl_api.c:379]:
db_cluster_insert(): serial operation - cluster [k2] (9/0)
Feb 5 11:40:28 /usr/sbin/kamailio[6663]: DEBUG: db_cluster [dbcl_api.c:483]:
db_cluster_use_table(): use table (missed_calls) - cluster [k2]
Feb 5 11:40:28 /usr/sbin/kamailio[6663]: DEBUG: db_cluster [dbcl_api.c:492]:
db_cluster_use_table(): set read table (missed_calls) - cluster [k2] (9/0)
Feb 5 11:40:28 /usr/sbin/kamailio[6663]: DEBUG: db_cluster [dbcl_api.c:502]:
db_cluster_use_table(): set write table (missed_calls) - cluster [k2] (9/0)
Feb 5 11:40:28 /usr/sbin/kamailio[6663]: DEBUG: db_cluster [dbcl_api.c:492]:
db_cluster_use_table(): set read table (missed_calls) - cluster [k2] (1/0)
Feb 5 11:40:28 /usr/sbin/kamailio[6663]: DEBUG: db_cluster [dbcl_api.c:502]:
db_cluster_use_table(): set write table (missed_calls) - cluster [k2] (1/0)
Feb 5 11:40:28 /usr/sbin/kamailio[6663]: DEBUG: db_cluster [dbcl_api.c:378]:
db_cluster_insert(): executing db cluster insert command
Feb 5 11:40:28 /usr/sbin/kamailio[6663]: DEBUG: db_cluster [dbcl_api.c:379]:
db_cluster_insert(): serial operation - cluster [k2] (9/0)
Feb 5 11:40:28 /usr/sbin/kamailio[6663]: DEBUG: db_cluster [dbcl_api.c:368]:
db_cluster_raw_query(): executing db cluster raw query command
Feb 5 11:40:28 /usr/sbin/kamailio[6663]: DEBUG: db_cluster [dbcl_api.c:369]:
db_cluster_raw_query(): serial operation - cluster [k1] (9/0)
Feb 5 11:40:28 /usr/sbin/kamailio[6663]: WARNING: db_mysql [km_dbase.c:84]:
db_mysql_submit_query(): driver error on ping: Lost connection to MySQL server
during query
Feb 5 11:40:28 /usr/sbin/kamailio[6663]: ERROR: db_mysql [km_dbase.c:124]:
db_mysql_submit_query(): driver error on query: SSL connection error: socket
layer receive error (2026)
Feb 5 11:40:28 /usr/sbin/kamailio[6663]: DEBUG: db_cluster [dbcl_api.c:369]:
db_cluster_raw_query(): serial operation - failre on cluster [k1] (9/0)
Feb 5 11:40:28 /usr/sbin/kamailio[6663]: DEBUG: db_cluster [dbcl_api.c:369]:
db_cluster_raw_query(): serial operation - cluster [k1] (1/0)
```
---
Reply to this email directly or view it on GitHub:
https://github.com/kamailio/kamailio/issues/406#issuecomment-181811220
_______________________________________________
sr-dev mailing list
[email protected]
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
