[Pdns-users] MySQL backend restart issue

[Chhaily Moun]

Hi there,

I am running PowerDNS authoritative server version 4.5.4 that I recently 
migrated from sqlite3 backend to mysql backend and running to an issue 
that after starting the server for over 30 minutes, it starts to lose 
connection to the MySQL database when updating any record as below:

> Backend reported permanent error which prevented lookup (GSQLBackend 
> unable to lookup 'example.com|ANY':Could not execute mysql statement: 
> SELECT content,ttl,prio,type,domain_id,disabled,name,auth FROM records 
> WHERE disabled=0 and name=? and domain_id=?: Lost connection to MySQL 
> server during query), aborting,
> TCP nameserver had error, cycling backend: GSQLBackend unable to lookup 
> 'example.com|ANY':Could not execute mysql statement: SELECT 
> content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE 
> disabled=0 and name=? and domain_id=?: Lost connection to MySQL server 
> during query,
> TCP server is without backend connections, launching

I found the issue is quite similar to 
https://github.com/PowerDNS/pdns/issues/3824 and I have my.cnf with 
wait_timeout and interactive_timeout set to 28800.

Thanks for any suggestions!

Chhaily
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20220411/50bdf6b8/attachment.htm>