Yes - update your my.conf to increase the timeouts by a large amount, then
restart mysql daemon. Here's some details:
https://telium.io/en/topic/mysql-server-has-gone-away/
From: asterisk-users [mailto:asterisk-users-bounces at lists.digium.com] On
Behalf Of Federico
Sent: Tuesday, September 19, 2023 11:36 AM
To: 'Asterisk Users Mailing List - Non-Commercial Discussion'
<asterisk-users at lists.digium.com>
Subject: [asterisk-users] CDR gets lost
I noticed that of Asterisk is idle many hours, then the CDR (with
batch=yes) does not get written to the MySQL database anymore. Is there a
keepalive command for ODBC?
cdr show status
Call Detail Record (CDR) settings
----------------------------------
Logging: Enabled
Mode: Simple
Log calls by default: Yes
Log unanswered calls: Yes
Log congestion: Yes
Ignore bridging changes: No
Ignore dial state changes: No
* Registered Backends
-------------------
Adaptive ODBC
cdr_manager (suspended)
cdr-custom
csv
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.digium.com/pipermail/asterisk-users/attachments/20230919/bea261ce/attachment.html>