logging-log4net-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michael Schall <mike.sch...@gmail.com>
Subject Re: Experiencing locks while using AdoNetAppender
Date Wed, 19 Aug 2009 04:20:00 GMT
Not sure if this has changed, but I'm pretty sure there is a database  
lock on inserts/updates.  So only one insert at a time. You might try  
the BufferedForwardingAppender. It might serialize the inserts for you.

On Aug 18, 2009, at 8:36 PM, Ron Grabowski <rongrabowski@yahoo.com>  
wrote:

> I think that's how SQLite works. Have you tried writing to a  
> single .db file from multiple threads without using log4net?
>
> From: Patrick Kalkman <PKa@hoogendoorn.nl>
> To: log4net-user@logging.apache.org
> Sent: Tuesday, August 18, 2009 8:29:17 AM
> Subject: Experiencing locks while using AdoNetAppender
>
> Hi,
>
> I am using the AdoNetAppender for logging messages from multiple  
> application. All the applications log into one sqllite database.  
> Sometimes when a lot of information is logged I am 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.BeginTransaction( 
> )
> at log4net.Appender.AdoNetAppender.SendBuffer(LoggingEvent[] events)
>
> The default CommandTimeout in the AdoNetAppender on the IDbCommand  
> is 30 seconds, but I would like to influence this timeout in the  
> log4net configuration (file) so that I 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 I prefer  
> that to our application hanging for the full CommandTimeout waiting  
> for the database to become unlocked.
>
> Is it 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?
>
> Thanks in advance for any answers.
>
> Patrick
>
> **********************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

Mime
View raw message