[Opendnssec-user] manual key rollover results in "1970-01-01 01:00:00"

[Dennis Baaten]

When running 'ods-enforcer enforce' the queue remains empty and the signconf remains unchanged (file date: Nov  3 11:13).

Syslog states the following. Notice the "DB prepare Err 2006"

Nov 13 12:37:34 traxotic ods-enforcerd: [scheduler] SIGALRM received
Nov 13 12:37:34 traxotic ods-enforcerd: [worker[4]]: report for duty
Nov 13 12:37:34 traxotic ods-enforcerd: [scheduler] no alarm set
Nov 13 12:37:34 traxotic ods-enforcerd: [worker[4]] start working
Nov 13 12:37:34 traxotic ods-enforcerd: [worker[4]]: perform task [enforce] for next zone
Nov 13 12:37:34 traxotic ods-enforcerd: 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
Nov 13 12:37:34 traxotic 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
Nov 13 12:37:34 traxotic ods-enforcerd: DB prepare Err 2006: MySQL server has gone away
Nov 13 12:37:34 traxotic ods-enforcerd: [enforce_task] zonelist NULL
Nov 13 12:37:34 traxotic ods-enforcerd: [worker[4]] finished working
Nov 13 12:37:34 traxotic ods-enforcerd: [worker[4]]: report for duty
Nov 13 12:37:48 traxotic ods-enforcerd: [cmdhandler] 2 clients in progress...
Nov 13 12:37:48 traxotic ods-enforcerd: [cmdhandler] accept client 5
Nov 13 12:37:48 traxotic ods-enforcerd: received command queue[5]
Nov 13 12:37:48 traxotic ods-enforcerd: [cmdhandler] queue command
Nov 13 12:37:48 traxotic ods-enforcerd: [queue_cmd] list tasks command
Nov 13 12:37:48 traxotic ods-enforcerd: [cmdhandler] done handling command queue[5]

After the migration, I did several restarts, because I ran into some permission issues (https://lists.opendnssec.org/pipermail/opendnssec-user/2017-November/004140.html). 

--
Dennis