BIND 10 #1270: Failed to set up schema ... sqlite3.OperationalError: no such table: zones

[BIND 10 Development]

#1270: Failed to set up schema ... sqlite3.OperationalError: no such table: zones
-------------------------------------+-------------------------------------
            Reporter:  jreed         |                        Owner:
                Type:  defect        |                       Status:  new
            Priority:  major         |                    Milestone:  New
           Component:  data source   |  Tasks
           Sensitive:  0             |                     Keywords:
         Sub-Project:  DNS           |              Defect Severity:  N/A
Estimated Difficulty:  0             |  Feature Depending on Ticket:
         Total Hours:  0             |          Add Hours to Ticket:  0
                                     |                    Internal?:  0
-------------------------------------+-------------------------------------
 Note this was from running bind10 as installed using a FreeBSD ports
 package which was built with CONFIGURE_ARGS= --localstatedir=/var

 Notice that the xfrout traceback got interspersed with real b10-auth
 logging output:

 {{{

 2011-09-29 15:34:59.696 ERROR [b10-auth.auth] AUTH_CONFIG_UPDATE_FAIL
 update of configuration failed: Failed to set up schema CREATE TABLE zones
 (id INTEGER PRIMARY KEY, name STRING NOT NULL COLLATE NOCASE, rdclass
 STRING NOT NULL COLLATE NOCASE DEFAULT 'IN', dnssec BOOLEAN NOT NULL
 DEFAULT 0)
 Traceback (most recent call last):
   File "/usr/local/libexec/bind10-devel/b10-xfrout", line 723, in <module>
     xfrout_server = XfroutServer()
   File "/usr/local/libexec/bind10-devel/b10-xfrout", line 616, in __init__
     self._start_notifier()
   File "/usr/local/libexec/bind10-devel/b10-xfrout", line 628, in
 _start_notifier
     self._notifier = notify_out.NotifyOut(datasrc)
   File "/usr/local/lib/python3.1/site-packages/isc/notify/notify_out.py",
 line 120, in __init__
 2011-09-29 15:34:59.731 INFO  [b10-auth.auth] AUTH_SERVER_STARTED server
 started
     self._init_notify_out(datasrc_file)
   File "/usr/local/lib/python3.1/site-packages/isc/notify/notify_out.py",
 line 132, in _init_notify_out
     for zone_name, zone_class in sqlite3_ds.get_zones_info(datasrc_file):
   File "/usr/local/lib/python3.1/site-packages/isc/datasrc/sqlite3_ds.py",
 line 161, in get_zones_info
     cur.execute("SELECT name, rdclass FROM zones")
 sqlite3.OperationalError: no such table: zones

 }}}

 sqlite3 shows:

 {{{

 freebsd8-64-4# sqlite3 /var/bind10-devel/zone.sqlite3
 SQLite version 3.7.4
 Enter ".help" for instructions
 Enter SQL statements terminated with a ";"
 sqlite> .tables
 schema_version

 }}}

 Maybe different components are using different path to the database?

 Some suggestions:

 - log output give more information like the path to the database.

 - sqlite3_ds.py check before using

 - xfrout fail cleanly on failures (no traceback)

 The problem is in both components.

-- 
Ticket URL: <http://bind10.isc.org/ticket/1270>
BIND 10 Development <http://bind10.isc.org>
BIND 10 Development