[Pdns-users] gsqite3 as autoslave with supermaster

[M1]

I have tried using sqlite3 (2.9.21) as a autoslave. However pdns conplaint 
database error while insert record. I have chmod the sqlite database to 777 
and change to owner to pdns but still not work. If I user mysql backend with 
the same setting it works perfectly.

The slave sqlite database is empty. There is only 1 record in supermasters 
table of value ( 'ip of supermaster', 'dns hostname of supermaster', NULL ).

Thanks.
Steve

below is the log file :
=====================================
May 10 16:17:22 mail pdns[13982]: PowerDNS 2.9.21 (C) 2001-2006 PowerDNS.COM 
BV (May 10 2007, 15:44:04, gcc 4.1.1 (Gentoo 4.1.1-r3)) starting up
May 10 16:17:22 mail pdns[13982]: PowerDNS comes with ABSOLUTELY NO 
WARRANTY. This is free software, and you are we
lcome to redistribute it according to the terms of the GPL version 2.
May 10 16:17:22 mail pdns[13982]: Set effective group id to 408
May 10 16:17:22 mail pdns[13982]: Set effective user id to 103
May 10 16:17:22 mail pdns[13982]: Creating backend connection for TCP
May 10 16:17:22 mail pdns[13982]: Master/slave communicator launching
May 10 16:17:22 mail pdns[13982]: gsqlite3: connection to 
'/etc/powerdns/pdns.db' succesful
May 10 16:17:22 mail pdns[13982]: gsqlite3: connection to 
'/etc/powerdns/pdns.db' succesful
May 10 16:17:22 mail pdns[13982]: All slave domains are fresh
May 10 16:17:22 mail pdns[13982]: About to create 3 backend threads for UDP
May 10 16:17:22 mail pdns[13982]: gsqlite3: connection to 
'/etc/powerdns/pdns.db' succesful
May 10 16:17:22 mail pdns[13982]: gsqlite3: connection to 
'/etc/powerdns/pdns.db' succesful
May 10 16:17:23 mail pdns[13982]: gsqlite3: connection to 
'/etc/powerdns/pdns.db' succesful
May 10 16:17:23 mail pdns[13982]: Done launching threads, ready to 
distribute questions
May 10 16:17:27 mail pdns[13982]: Received NOTIFY for xyz.com from 
aaa.bbb.ccc.ddd for which we are not authoritative
May 10 16:17:27 mail pdns[13982]: Backend error: Database error trying to 
insert new slave 'xyz.com': Error while retrieving SQLite query results

======================================