[Pdns-users] pdnsutil and MySQL connection aborted

[Thomas Plant]

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