You are viewing a plain text version of this content. The canonical link for it is here.
Posted to log4net-user@logging.apache.org by shally chong <sh...@gmail.com> on 2010/07/28 07:51:44 UTC
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
RE: ADONetAppender not logging
Posted by Rob Prouse <Ro...@Ivara.com>.
Shally,
I think this might be an issue with the fact that you stop logging for long periods of time. MySQL will kill unused connections after a set period of time. Some firewalls also kill idle connections after a period of time. Log4net should probably handle this, but for now you need a workaround. I am not sure what the fix is, but you could try any of the following;
* add pooling=false to your connection string.
* Try pooling=true (I know that this is the opposite of the above, I just think that using a connection pool will behave differently than not, so you should try both)
* Set a timer in your application to log a ping type message to the database to keep the connection alive.
For more information, see,
http://www.opensubscriber.com/message/dotnet@lists.mysql.com/2463293.html
There is also several MySQL bugs that sound like they may be related to your problem. Their workaround is to use pooling=false.
http://bugs.mysql.com/bug.php?id=6634
Also, is there more information in the internal logs so that we can pinpoint the location of the exception and hopefully provide a fix?
Good luck,
Rob
From: shally chong [mailto:shally.chong@gmail.com]
Sent: Thursday, July 29, 2010 9:13 PM
To: Log4NET User
Subject: Re: ADONetAppender not logging
Hi Rob,
I notice that and I've included it in my configuration files.
I'm able to trap the mysql connection error with the internal logging file.
Exception: "an established connection was aborted by the software in your host machine" was thrown.
Regards,
Shally
On Thu, Jul 29, 2010 at 8:10 PM, Rob Prouse <ro...@prouse.org>> wrote:
Shally,
Looking at the code for AdoNetAppender, it will not log if the connection is lost and the reconnect fails. It will however output problems to its internal logging. I think your best option right now is to enable log4net's internal logging and see if it can help diagnose the problem.
See the section entitled "How do I enable log4net internal debugging?" near the bottom of the FAQ.
http://logging.apache.org/log4net/release/faq.html
Rob Prouse
From: shally chong [mailto:shally.chong@gmail.com<ma...@gmail.com>]
Sent: Wednesday, July 28, 2010 11:44 PM
To: Log4NET User
Subject: Re: ADONetAppender not logging
Hi Rob,
Yes, this happened after server rebooted.
There is no windows update or other software updates, where DC only performing san storage (which requires server reboot).
Server guy has checked on the server side and did not find any different on the server after rebooted.
Previously I suspect the symantec/ live update caused the appender not working. But later on, the symantec and all it's related component is disabled, and still the appender not able to capture log after data loading process resume.
Regards,
Shally
On Thu, Jul 29, 2010 at 11:06 AM, Rob Prouse <ro...@prouse.org>> wrote:
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<ma...@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 <Ro...@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.AdoNetAppender.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<ma...@gmail.com>]
Sent: Wednesday, July 28, 2010 1:52 AM
To: log4net-user@logging.apache.org<ma...@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
Re: ADONetAppender not logging
Posted by shally chong <sh...@gmail.com>.
Hi Rob,
I notice that and I've included it in my configuration files.
I'm able to trap the mysql connection error with the internal logging file.
Exception: "an established connection was aborted by the software in your
host machine" was thrown.
Regards,
Shally
On Thu, Jul 29, 2010 at 8:10 PM, Rob Prouse <ro...@prouse.org> wrote:
> Shally,
>
>
>
> Looking at the code for AdoNetAppender, it will not log if the connection
> is lost and the reconnect fails. It will however output problems to its
> internal logging. I think your best option right now is to enable log4net’s
> internal logging and see if it can help diagnose the problem.
>
>
>
> See the section entitled “How do I enable log4net internal debugging?” near
> the bottom of the FAQ.
>
>
>
> http://logging.apache.org/log4net/release/faq.html
>
>
>
> Rob Prouse
>
>
>
> *From:* shally chong [mailto:shally.chong@gmail.com]
> *Sent:* Wednesday, July 28, 2010 11:44 PM
>
> *To:* Log4NET User
> *Subject:* Re: ADONetAppender not logging
>
>
>
> Hi Rob,
>
> Yes, this happened after server rebooted.
> There is no windows update or other software updates, where DC only
> performing san storage (which requires server reboot).
> Server guy has checked on the server side and did not find any different on
> the server after rebooted.
> Previously I suspect the symantec/ live update caused the appender not
> working. But later on, the symantec and all it's related component is
> disabled, and still the appender not able to capture log after data loading
> process resume.
>
> Regards,
> Shally
>
> On Thu, Jul 29, 2010 at 11:06 AM, Rob Prouse <ro...@prouse.org> wrote:
>
> 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 <Ro...@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.AdoNetAppender.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
>
>
>
RE: ADONetAppender not logging
Posted by Rob Prouse <ro...@prouse.org>.
Shally,
Looking at the code for AdoNetAppender, it will not log if the connection is
lost and the reconnect fails. It will however output problems to its
internal logging. I think your best option right now is to enable log4net's
internal logging and see if it can help diagnose the problem.
See the section entitled "How do I enable log4net internal debugging?" near
the bottom of the FAQ.
http://logging.apache.org/log4net/release/faq.html
Rob Prouse
From: shally chong [mailto:shally.chong@gmail.com]
Sent: Wednesday, July 28, 2010 11:44 PM
To: Log4NET User
Subject: Re: ADONetAppender not logging
Hi Rob,
Yes, this happened after server rebooted.
There is no windows update or other software updates, where DC only
performing san storage (which requires server reboot).
Server guy has checked on the server side and did not find any different on
the server after rebooted.
Previously I suspect the symantec/ live update caused the appender not
working. But later on, the symantec and all it's related component is
disabled, and still the appender not able to capture log after data loading
process resume.
Regards,
Shally
On Thu, Jul 29, 2010 at 11:06 AM, Rob Prouse <ro...@prouse.org> wrote:
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 <Ro...@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
Re: ADONetAppender not logging
Posted by shally chong <sh...@gmail.com>.
Hi Rob,
Yes, this happened after server rebooted.
There is no windows update or other software updates, where DC only
performing san storage (which requires server reboot).
Server guy has checked on the server side and did not find any different on
the server after rebooted.
Previously I suspect the symantec/ live update caused the appender not
working. But later on, the symantec and all it's related component is
disabled, and still the appender not able to capture log after data loading
process resume.
Regards,
Shally
On Thu, Jul 29, 2010 at 11:06 AM, Rob Prouse <ro...@prouse.org> wrote:
> 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 <Ro...@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.AdoNetAppender.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
>
>
>
RE: ADONetAppender not logging
Posted by Rob Prouse <ro...@prouse.org>.
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 <Ro...@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
Re: ADONetAppender not logging
Posted by shally chong <sh...@gmail.com>.
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 <Ro...@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.AdoNetAppender.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
>
>
>
RE: ADONetAppender not logging
Posted by Rob Prouse <Ro...@Ivara.com>.
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.AdoNetAppender.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