We're using the AdoNetAppender for logging messages in our solution. Because of the use in multiple applications, we're experiencing exceptions like:
log4net:ERROR [AdoNetAppender] Exception while writing to database System.Data.SQLite.SQLiteException: The database file is locked database is locked at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt) at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt) at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery() at System.Data.SQLite.SQLiteTransaction..ctor(SQLiteConnection connection, Boolean deferredLock) at System.Data.SQLite.SQLiteConnection.BeginTransaction(Boolean deferredLock) at System.Data.SQLite.SQLiteConnection.BeginDbTransaction(IsolationLevel isolationLevel) at System.Data.Common.DbConnection.System.Data.IDbConnection.BeginTransacti on() at log4net.Appender.AdoNetAppender.SendBuffer(LoggingEvent[] events) The default CommandTimeout on the IDbCommand is 30 seconds, but we would like to influence this timeout in our log4net configuration (file) so that we can influence the timeout on the logging if the database is locked for a longer portion of time. Reducing the timeout may lead to events getting lost, but we prefer that to our application hanging for the full CommandTimeout waiting for the database to become unlocked. Would it be possible to configure the timeout using configuration, or would it be better to choose for a solution like deriving from the AdoNetAppender and add the functionality ourselfs. Thanks in advance, Martin Verboon Software Engineer Hoogendoorn Growth Management **********************DISCLAIMER********************** Deze E-mail is uitsluitend bestemd voor de geadresseerde(n). Verstrekking aan en gebruik door anderen is niet toegestaan. De Hoogendoorn Groep sluit iedere aansprakelijkheid uit die voortvloeit uit elektronische verzending. This E-mail is intended exclusively for the addressee(s), and may not be passed on to, or made available for use by any person other than the addressee(s). The Hoogendoorn Group rules out any and every liability resulting from any electronic transmission. ******************************************************* This message has been scanned by Network Associates' McAfee AntiVirus Technology
