logging-log4net-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rob Prouse" <...@prouse.org>
Subject RE: ADONetAppender not logging
Date Thu, 29 Jul 2010 03:06:15 GMT
Shally,

 

You say that this started happening after the server rebooted, correct?

 

Why was the server rebooted? Were there any Windows updates or other
software updates that required the reboot? Since it was working before the
reboot, we need to figure out what changed on the server to cause the
failure. There may be a bug in the AdoNetAppender, but whatever changed on
the server probably caused the bug to appear, so knowing what changed will
help us track down the problem.

 

My first thoughts are an update to the .NET runtime, or to the MySQL server.

 

Rob Prouse

 

From: shally chong [mailto:shally.chong@gmail.com] 
Sent: Wednesday, July 28, 2010 9:29 PM
To: Log4NET User
Subject: Re: ADONetAppender not logging

 

Hi Rob,

Yes, I included the ReconnectOnError clause in my configuration and the log
is obtained. 
Any idea why the connection issue happened after the server reboot?

All these while, I did not face such problem.

Thanks,
Shally

On Wed, Jul 28, 2010 at 9:29 PM, Rob Prouse <Rob.Prouse@ivara.com> wrote:

Shally,

 

In your configuration for the AdoNetAppender, do you have ReconnectOnError
set to true? It defaults to false and is not in the example configuration.

 

http://logging.apache.org/log4net/release/sdk/log4net.Appender.AdoNetAppende
r.ReconnectOnError.html

 

If not, add the following line to the appender and see if it helps.

 

<reconnectOnError value="true">

 

Hope this works for you,

 

Rob Prouse

 

From: shally chong [mailto:shally.chong@gmail.com] 
Sent: Wednesday, July 28, 2010 1:52 AM


To: log4net-user@logging.apache.org

Subject: Fwd: ADONetAppender not logging

 

 

Hi,

I encountered a problem with ADONetAppender in production server after the
DC perform restart for that server.
I have a .net c# window application where it will do some data loading into
mysql server. After the data loading completed or any exception thrown
during the data loading process, log4net will capture the error and store
into mysql table as well. There will be no file loading from 2am - 6am,
where during this time, there will be no log captured into mysql. Initially,
after the file loaded into server at 6am, the log4net will start capturing
log again. All these while, the log4net is able to capture log after the
data loading process resume. But after the server being restarted, there is
no more log captured into mysql after data loading process resume. And I
have to manually restart the window services (the window application running
as window services) daily to obtain the log again. 
I've tried to modify the log4net to capture log into flat file, and it's
working fine (all logs are captured after data loading process resume). 

Please take note that the data loading process is working fine and data are
inserted into mysql server correctly. The only not working is ADONetAppender
is not capturing any logs after data loading process resume.

Please advise.

Thanks,
Shally

 


Mime
View raw message