Re: [Pdns-users] gmysql deadlock

2021-11-25 Thread Thomas via Pdns-users
Thanks for the answer, but all tables are INNODB. Am 25.11.2021 um 08:50 schrieb Dave Strydom: Hi, Are your pdns tables in MariaDB using MyISAM or InnoDB? We had this issue when using MyIASM tables because it does a full table lock. Switched it to Innodb which does only row locking and the is

Re: [Pdns-users] gmysql deadlock

2021-11-24 Thread Thomas via Pdns-users
Added an 'API-RECTIFY = 0' to the zone meta-data having the deadlocks and the deadlocks did not reapear until now. Am 24.11.2021 um 10:38 schrieb Thomas via Pdns-users: Hello. We are running pdns-4.5.1-1pdns.el8.x86_64 with MariaDB-server-10.4.21 as backend. I am seeing regular messages in o

[Pdns-users] gmysql deadlock

2021-11-24 Thread Thomas via Pdns-users
Hello. We are running pdns-4.5.1-1pdns.el8.x86_64 with MariaDB-server-10.4.21 as backend. I am seeing regular messages in our pdns 4.5.2 regarding deadlocks in MySQL. Exception: GSQLBackend unable to nullify ordername and update auth for ovpn.spotsystem.net for domain_id 17651: Could not exe

[Pdns-users] gmysql Deadlock

2019-12-27 Thread bodenhalt...@gmail.com
Hi, i am not really sure if it is a mysql problem but since the update to pdns 4.2.1 i get a lot errors like: [webserver] 50746175-0898-4b7c-812a-b8244a6c0a81 HTTP ISE for "/api/v1/servers/localhost/zones/domain.de": Exception: GSQLBackend unable to nullify ordername and update auth for domain.de