[Opendnssec-user] MySQL server has gone away

[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


Am 06.11.2017 um 12:45 schrieb 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
> _______________________________________________
> Opendnssec-user mailing list
> Opendnssec-user at lists.opendnssec.org
> https://lists.opendnssec.org/mailman/listinfo/opendnssec-user