[Pdns-users] PowerDNS authoritative, galera
cifali.filipe at gmail.com
Wed Aug 16 11:42:08 UTC 2017
Seems like your MySQL is not ok.
This parts of the message hints it:
*SQLBackend unable to refresh domain_id* 18537: *Could not **execute mysql
statement*: update domains set last_check=? where id=?: *Deadlock f**ound*
when trying to get lock; try restarting transaction
Have you checked MySQL logs? I would start there.
On Tue, Aug 15, 2017 at 11:17 PM, Nick Urbanik <nick.urbanik at optusnet.com.au
> Dear Folks,
> Thank you for the great software.
> We have just set up an authoritative pair of slaves at two different
> locations. The two slaves at each location share an anycast address.
> Both slaves read/write to a galera backend through a unix socket. We
> are using PowerDNS 4.0.4 on RHEL 7.
> These slaves use ordinary DNS replication from a master with a mysql
> backend. The slaves are using Percona-XtraDB-Cluster 5.7.17. The
> masters are using Percona-Server 5.7.18 with corosync and pacemaker,
> We have PowerDNS failing quite often (about twice daily) with this message:
> Aug 16 04:11:45 dnsslave2 pdns-instance: Exiting because
> communicator thread died with error: GSQLBackend unable to refresh
> domain_id 18537: Could not
> execute mysql statement: update domains set last_check=? where id=?:
> Deadlock f
> ound when trying to get lock; try restarting transaction
> Aug 16 04:11:46 dnsslave2 pdns-instance: Got a signal 6, attempting
> print trace:
> [stack trace followed by restart by systemd]
> I would be grateful for any suggestions on what we could do to remedy this.
> Nick Urbanik http://nicku.org 808-71011 nick.urbanik at optusnet.com.au
> GPG: 7FFA CDC7 5A77 0558 DC7A 790A 16DF EC5B BB9D 2C24 ID: BB9D2C24
> I disclaim, therefore I am.
> Pdns-users mailing list
> Pdns-users at mailman.powerdns.com
Filipe Cifali Stangler
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Pdns-users