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@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 _______________________________________________ Pdns-users mailing list Pdns-users@mailman.powerdns.com https://mailman.powerdns.com/mailman/listinfo/pdns-users
