On Mon, Feb 26, 2007 at 03:37:58PM -0700, Jason J. W. Williams wrote: > It would be nice to have a config file option to enable/disable it. In > our environment, there are no zone transfers going on, and its more > important to reconnect to maximize uptime. Also, PowerDNS should > handle rollbacks properly if its going to support InnoDB. In the event > of a rollback, either the entire transfer should be re-applied or > dropped depending on your point of view. > > -J > > On 2/26/07, Norbert Sendetzky <[EMAIL PROTECTED]> wrote: > >Hi Christian > > > >> starting in MySQL 5.0.3 the reconnect-flag in the mysqlclientlib is set > >to > >> 0 by default, which means no auto-reconnecting. > >> > >> Any ideas or plans to solve this? We found several "mysql server has gone > >> away" in the logfile, while the server runs perfectly. > > > >After reading http://dev.mysql.com/doc/refman/5.0/en/auto-reconnect.html I > >consider disabling auto-reconnect a good thing, even if you are annoyed of > >the log file entries :-) > > > >Auto-reconnect is very dangerous while doing an AXFR transfer because it > >rolls > >back the transaction and reenables auto-commit mode. This may leave your > >zone > >in a state where the first half of the records are missing (when a slave > >updates it's zone). > > > > > >Norbert
I thought that the zone AXFR's occur is a transaction. In that case, when a rollback occurs the DB is in the state that it was before the AXFR was attempted, including the serial number. Why would half of the records be suddenly missing? Ken _______________________________________________ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users