[sr-dev] [kamailio] Database timeout over SSL? (#406)

Tobias Lindgren notifications at github.com
Tue Feb 9 11:45:39 CET 2016 

@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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-dev/attachments/20160209/7a74c7f4/attachment.html>

More information about the sr-dev mailing list