https://community.splunk.com/t5/Getting-Data-In/ERROR-SQLitePersistentStorageImpl-on-Indexer-every-minute/m-p/86663#M18002 <P>Hello,</P> <P>On my primary Indexer (~10GB / Day) I got the following errors, almost exactly every minute:</P> <P>10-05-2011 07:21:49.539 -0400 ERROR FSChangeMonitor - Exception thrown in update(2) - continuing</P> <P>10-05-2011 07:21:49.539 -0400 ERROR SQLitePersistentStorageImpl - Error executing: select primarykey, value from keyvaluepairs_t where secondary1 = ?1 Msg=database is locked</P> <P>Any idea?</P> Wed, 05 Oct 2011 11:30:11 GMT gcollini 2011-10-05T11:30:11Z https://community.splunk.com/t5/Getting-Data-In/ERROR-SQLitePersistentStorageImpl-on-Indexer-every-minute/m-p/86663#M18002 <P>Hello,</P> <P>On my primary Indexer (~10GB / Day) I got the following errors, almost exactly every minute:</P> <P>10-05-2011 07:21:49.539 -0400 ERROR FSChangeMonitor - Exception thrown in update(2) - continuing</P> <P>10-05-2011 07:21:49.539 -0400 ERROR SQLitePersistentStorageImpl - Error executing: select primarykey, value from keyvaluepairs_t where secondary1 = ?1 Msg=database is locked</P> <P>Any idea?</P> Wed, 05 Oct 2011 11:30:11 GMT https://community.splunk.com/t5/Getting-Data-In/ERROR-SQLitePersistentStorageImpl-on-Indexer-every-minute/m-p/86663#M18002 gcollini 2011-10-05T11:30:11Z https://community.splunk.com/t5/Getting-Data-In/ERROR-SQLitePersistentStorageImpl-on-Indexer-every-minute/m-p/86664#M18003 <P>It looks like there is a lock on the database. Did you try to restart your splunk instance? Is it possible that you've got another sql lite tool accessing these files? </P> Wed, 05 Oct 2011 20:47:38 GMT https://community.splunk.com/t5/Getting-Data-In/ERROR-SQLitePersistentStorageImpl-on-Indexer-every-minute/m-p/86664#M18003 jbsplunk 2011-10-05T20:47:38Z https://community.splunk.com/t5/Getting-Data-In/ERROR-SQLitePersistentStorageImpl-on-Indexer-every-minute/m-p/86665#M18004 <P>Restarted multiple time, I believe I got only 1 instance running (2 processes)</P> Sun, 16 Oct 2011 09:23:36 GMT https://community.splunk.com/t5/Getting-Data-In/ERROR-SQLitePersistentStorageImpl-on-Indexer-every-minute/m-p/86665#M18004 gcollini 2011-10-16T09:23:36Z