[Pdns-users] pdnsutil and MySQL connection aborted

[Thomas Plant]

Am 09.05.2019 um 09:06 schrieb Thomas Plant via Pdns-users:
> Am 08.05.2019 um 20:49 schrieb Aki Tuomi:
>> On Wed, May 08, 2019 at 05:27:34PM +0200, Thomas Plant via Pdns-users wrote:
>>> Hello,
>>>
>>> I installed PDNS 4.1.8 fresh from the powerdns repos. Configured MySQL
>>> and for testing I imported our ~3000 domains into pdns using pdnsutil
>>> load-zone.
>>> All was imported happily, data is just fine. But every time I use the
>>> pdnsutil I see the following error from MySQL:
>>>
>>> May  8 17:15:14 pdns1 mysqld: 2019-05-08 17:15:14 13125 [Warning]
>>> Aborted connection 13125 to db: 'pdns' user: 'pdns' host: 'localhost'
>>> (Got an error reading communication packets)
>>>
>>> Is this just a missing mysql_close() when pdnsutil exits? Or something
>>> more worrisome?
>>>
>>> Kind regards,
>>> Thomas
>> Hi!
>>
>> This sounds like a problem. Perhaps you should check the mysql server logs?
>>
>> Aki
> Hi,
>
> set log_warnings=4; in MySQL and got the following when using the pdnsutil:
>
> 2019-05-09  9:02:13 27 [Warning] Aborted connection 27 to db: 'pdns'
> user: 'pdns' host: 'localhost' (Got an error reading communication packets)
> 2019-05-09  9:02:13 27 [Warning] Aborted connection 27 to db: 'pdns'
> user: 'pdns' host: 'localhost' (CLOSE_CONNECTION)
> 2019-05-09  9:02:13 28 [Warning] Aborted connection 28 to db: 'pdns'
> user: 'pdns' host: 'localhost' (Got an error reading communication packets)
> 2019-05-09  9:02:13 28 [Warning] Aborted connection 28 to db: 'pdns'
> user: 'pdns' host: 'localhost' (CLOSE_CONNECTION)
>
> Maybe a general problem with MariaDB 10.3?
> Thomas
> _______________________________________________
> Pdns-users mailing list
> Pdns-users at mailman.powerdns.com
> https://mailman.powerdns.com/mailman/listinfo/pdns-users
Activated the audit module in MySQL. It seems the pdnsutil does a
correct disconnect from the database, but MySQL logs anyway an 'aborted
connection'.

Here the server_audit.log:
20190509 10:13:37,pdns1.zcom.it,pdns,localhost,13,0,CONNECT,pdns,,0
20190509 10:13:37,pdns1.zcom.it,pdns,localhost,13,24,QUERY,pdns,'SET
SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED',0
20190509 10:13:37,pdns1.zcom.it,pdns,localhost,14,0,CONNECT,pdns,,0
20190509 10:13:37,pdns1.zcom.it,pdns,localhost,14,25,QUERY,pdns,'SET
SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED',0
20190509 10:13:37,pdns1.zcom.it,pdns,localhost,14,27,READ,pdns,records,
20190509 10:13:37,pdns1.zcom.it,pdns,localhost,14,27,QUERY,pdns,'SELECT
content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE
disabled=0 and type=? and name=?',0
20190509 10:13:37,pdns1.zcom.it,pdns,localhost,14,29,READ,pdns,records,
20190509 10:13:37,pdns1.zcom.it,pdns,localhost,14,29,QUERY,pdns,'SELECT
content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE
disabled=0 and type=? and name=?',0
20190509 10:13:37,pdns1.zcom.it,pdns,localhost,14,31,READ,pdns,records,
20190509 10:13:37,pdns1.zcom.it,pdns,localhost,14,31,QUERY,pdns,'SELECT
content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE
disabled=0 and type=? and name=?',0
20190509 10:13:37,pdns1.zcom.it,pdns,localhost,14,34,READ,pdns,records,
20190509 10:13:37,pdns1.zcom.it,pdns,localhost,14,34,QUERY,pdns,'SELECT
content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE
(disabled=0 OR ?) and domain_id=? order by name, type',0
20190509 10:13:37,pdns1.zcom.it,pdns,localhost,13,0,DISCONNECT,pdns,,0
20190509 10:13:37,pdns1.zcom.it,pdns,localhost,14,0,DISCONNECT,pdns,,0

And the 'aborted connection' in the MySQL error log:
2019-05-09 10:13:37 13 [Warning] Aborted connection 13 to db: 'pdns'
user: 'pdns' host: 'localhost' (Got an error reading communication packets)
2019-05-09 10:13:37 14 [Warning] Aborted connection 14 to db: 'pdns'
user: 'pdns' host: 'localhost' (Got an error reading communication packets)

Maybe more a logging problem in MySQL than a PowerDNS issue?

Thanks,
Thomas