[Opendnssec-user] MySQL server has gone away

[Thomas E.]

Hello!

I running OpenDNSSEC Version 2.1.3 on Debian Jessie with Mysql DB
Version 5.5.58.

The ODS-Enforcer seems to lose connection to the MySQL DB after a
certain amount of time:

Nov 6 02:02:35 ods ods-enforcerd: DB prepare SQL SELECT zone.id,
zone.rev, zone.policyId, zone.name, zone.signconfNeedsWriting,
zone.signconfPath, zone.nextChange, zone.ttlEndDs, zone.ttlEndDk,
zone.ttlEndRs, zone.rollKskNow, zone
.rollZskNow, zone.rollCskNow, zone.inputAdapterType,
zone.inputAdapterUri, zone.outputAdapterType, zone.outputAdapterUri,
zone.nextKskRoll, zone.nextZskRoll, zone.nextCskRoll FROM zone WHERE
zone.name = ?
Nov 6 02:02:35 ods ods-enforcerd: DB prepare Err 2006: MySQL server has
gone away

Has anyone experienced the same issue? Is this somehow related to any
kind of connection-pooling or anything like this?

Thanks a lot,
Thomas

[Thomas E.]

Hello again,

I found this was already a topic in this list:

https://lists.opendnssec.org/pipermail/opendnssec-user/2017-March/003974.html


Sorry, for that.

I think the explanation for my problem is that the mysql 8 hours default
timeout exceeds. As I have only one zone configured at the moment there
are no queries in the meantime.
I set the wait_timeout value to 86400. I guess this will solve the problem.

Thanks,
Thomas

Post by Thomas E.
Hello!
I running OpenDNSSEC Version 2.1.3 on Debian Jessie with Mysql DB
Version 5.5.58.
The ODS-Enforcer seems to lose connection to the MySQL DB after a
Nov 6 02:02:35 ods ods-enforcerd: DB prepare SQL SELECT zone.id,
zone.rev, zone.policyId, zone.name, zone.signconfNeedsWriting,
zone.signconfPath, zone.nextChange, zone.ttlEndDs, zone.ttlEndDk,
zone.ttlEndRs, zone.rollKskNow, zone
.rollZskNow, zone.rollCskNow, zone.inputAdapterType,
zone.inputAdapterUri, zone.outputAdapterType, zone.outputAdapterUri,
zone.nextKskRoll, zone.nextZskRoll, zone.nextCskRoll FROM zone WHERE
zone.name = ?
Nov 6 02:02:35 ods ods-enforcerd: DB prepare Err 2006: MySQL server has
gone away
Has anyone experienced the same issue? Is this somehow related to any
kind of connection-pooling or anything like this?
Thanks a lot,
Thomas
_______________________________________________
Opendnssec-user mailing list
https://lists.opendnssec.org/mailman/listinfo/opendnssec-user