Hi Nicholas > I made a gsqlite3 backend and added the supermaster records. > When the supermaster sends the notify to the sqlite3 superslave its > doesn't work - log below - ideas?
I'm almost sure that there are two conflicting connections where one is locking the tables while the other tries to execute an insert statement. The opendbx backend seems to have the same problem and I've written a patch to solve the problem (attached). I would be glad if you could do me a favour and test the opendbx backend with your SQLite database and the patch below and tell me if it works for you. Thank you very much Norbert -- OpenPGP public key http://www.linuxnetworks.de/norbert.pubkey.asc
Index: modules/opendbxbackend/odbxprivate.cc
===================================================================
--- modules/opendbxbackend/odbxprivate.cc (revision 1114)
+++ modules/opendbxbackend/odbxprivate.cc (working copy)
@@ -20,6 +20,13 @@
m_handle[type] = NULL;
}
+ if( type == WRITE && getArg( "backend" ) == "sqlite" )
+ {
+ L.log( m_myname + " Using same SQLite connection for reading and writeing to '" + hosts[odbx_host_index[READ]] + "'", Logger::Notice );
+ m_handle[WRITE] = m_handle[READ];
+ return true;
+ }
+
for( i = 0; i < hosts.size(); i++ )
{
h = ( idx + i ) % hosts.size();
signature.asc
Description: This is a digitally signed message part.
_______________________________________________ Pdns-users mailing list [email protected] http://mailman.powerdns.com/mailman/listinfo/pdns-users
