[Pdns-users] gmysql deadlock

[Thomas]

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 issues 
> disappeared.
>
> - Dave
>
> On Wed, Nov 24, 2021 at 12:58 PM Thomas via Pdns-users 
> <pdns-users at mailman.powerdns.com> wrote:
>
>     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 our pdns 4.5.2 regarding deadlocks in MySQL.
>>
>>     Exception: GSQLBackend unable to nullify ordername and update
>>     auth for ovpn.spotsystem.net <http://ovpn.spotsystem.net> for
>>     domain_id 17651: Could not execute mysql statement: update
>>     records set ordername=NULL,auth=? where domain_id=? and name=?
>>     and disabled=0: Deadlock found when trying to get lock; try
>>     restarting transaction
>>
>>     I have found the following bug report on Github:
>>     https://github.com/PowerDNS/pdns/issues/8663
>>     In the thread above is mentioned that
>>     setting|"default-api-rectify = no" resolves the deadlock if I did
>>     understand correctly.
>>
>>     What does 'api-rectify' do? And is it save to disable?
>>
>>     Thanks,
>>     Thomas
>>
>>
>>     |
>>
>>     _______________________________________________
>>     Pdns-users mailing list
>>     Pdns-users at mailman.powerdns.com
>>     https://mailman.powerdns.com/mailman/listinfo/pdns-users
>
>     _______________________________________________
>     Pdns-users mailing list
>     Pdns-users at mailman.powerdns.com
>     https://mailman.powerdns.com/mailman/listinfo/pdns-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20211125/cb6a444d/attachment.htm>