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 <r...@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.ch...@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 <r...@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.ch...@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.pro...@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.ch...@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 > > >
