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
_______________________________________________
Pdns-users mailing list
Pdns-users@mailman.powerdns.com
https://mailman.powerdns.com/mailman/listinfo/pdns-users
