bind10-devel-20120119 outgoing zone transfer failure

[Jelte Jansen]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 02/22/2012 07:27 PM, Spain, Dr. Jeffry A. wrote:
> 
>> There was a sqlite3 database change in October that the above
>> script detects and can fix (with --upgrade switch).
> 
> The upgrade generated no output, presumably indicating success.
> Below are the log entries generated when I restarted bind10 after
> the upgrade. The sqlite database gets opened and closed a number of
> times in rapid succession -- not sure what that means.
> 
>> The "make install" step should check that also.
> 
> I don't know what happened at that point, and didn't preserve the
> output. If you would like me to troubleshoot this, I can rebuild
> the server and capture the output from the build process. Please
> let me know.
> 
> I will get back to you on whether or not this database upgrade
> fixes the zone transfer problem. Thanks. Jeff.
> 

This is what I think has happened; we have been transitioning to a new
and shiny API for the datasource backends, but have not gotten around
to removing all references to the old one yet. The implementation of
the old API does not know or care about the diffs table, which is not
a problem, but if it happens to be the first one there when a new
database is initiated (i.e. on first startup, or if the sqlite3 file
has been removed), then it'll also not create that table.

So I also think the 'upgrade' script should fix it.

As for the underlying problem, as a somewhat shorter-term fix than
removing all use of the old API (we do still plan to do that Real Soon
Now), I have made a ticket and diff for adding said missing table in
the old create statements as well:

http://bind10.isc.org/ticket/1717

This of course does not fix issues with existing sqlite3 databases
that have been created badly, but at least it shouldn't happen for new
database files anymore.

Jelte

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk9HrE8ACgkQ4nZCKsdOncVgAwCdH3RH+JcP9xubLvikt/OUwU0E
DAIAnAprkcR5qO66qeMwPNqV+wwaTnSL
=7yZI
-----END PGP SIGNATURE-----