bind10-devel-20120119 outgoing zone transfer failure

Wed Feb 22 17:56:06 UTC 2012

On Wed, 22 Feb 2012, Spain, Dr. Jeffry A. wrote:

> 2012-02-22 09:40:19.334 DEBUG [b10-xfrout.datasrc] 
> DATASRC_SQLITE_CONNOPEN Opening sqlite database file 
> '/var/bind10-devel/zone.sqlite3'

...

> 2012-02-22 09:40:19.337 ERROR [b10-xfrout.xfrout] 
> XFROUT_XFR_TRANSFER_CHECK_ERROR IXFR client 
> [2001:4870:20ca:158:383e:4365:e3fe:ef7e]:60965: check for transfer of 
> jaspain.biz/IN failed: Could not prepare SQLite statement: SELECT id 
> FROM diffs WHERE zone_id=?1 AND version=?2 and OPERATION=?3 ORDER BY 
> id ASC LIMIT 1: no such table: diffs

Only responding to this point right now. How old is this 
/var/bind10-devel/zone.sqlite3 ?

You may want to back it up and then run:

compatcheck/sqlite3-difftbl-check.py /var/bind10-devel/zone.sqlite3

There was a sqlite3 database change in October that the above script 
detects and can fix (with --upgrade switch).

The "make install" step should check that also.