You are viewing a plain text version of this content. The canonical link for it is here.
Posted to log4net-dev@logging.apache.org by "Chetan Appannagari (JIRA)" <ji...@apache.org> on 2011/03/16 17:28:29 UTC
[jira] Created: (LOG4NET-288) ADO.Net Appender is not writing all
the records to the table in a high load/user scenario.It stops writing to
the table untill i restart my app servers.Also sometimes, it drops few
records and writes the rest of the records.
ADO.Net Appender is not writing all the records to the table in a high load/user scenario.It stops writing to the table untill i restart my app servers.Also sometimes, it drops few records and writes the rest of the records.
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Key: LOG4NET-288
URL: https://issues.apache.org/jira/browse/LOG4NET-288
Project: Log4net
Issue Type: Bug
Components: Appenders
Affects Versions: 1.2.9
Environment: Windows 2008 server , IIS7.0 web site, Sql Server 2008 DB, ASP.net 2.0, .Net 3.0
Reporter: Chetan Appannagari
Priority: Blocker
We are using ADO.net appender to write audit records to the a table. Being an Audit table, all the actions performed by the user are recorded to this table along with the User's information like username,account information etc. In production environment we have close to 900-1000 users CONCURRENTLY accessing the system Monday - Sunday. Since every action of each user if tracked to Audit table, we have close to 50,000-200,000 records created every dya in this table.
The problem is, in between, the ADO.Net appender is not writing all the records to the table. It drops a few records and writes the rest. And sometimes(happenned 3-4 times in production), it just stops writing to the table, untill we restart the app servers( IISRESET command). So basically 2 problems.
Currently in PRODUCTION we haven't set reconnectOnError = "true" in the web.config file. We will be setting this in our next PROD build. Will this solve the 2nd Issue(just stops writing to table)?.
We will enable internal debugging in the config file as well in the next PROD build. Will this let us know the exact reason why we are having these issues?
Has this sort of problem been reported earlier?
This is a highly critical issue. If we do not get answers to these quickly we may have to look at other options, which i personally don't want to do.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (LOG4NET-288) ADO.Net Appender is not writing all
the records to the table in a high load/user scenario.It stops writing to
the table untill i restart my app servers.Also sometimes, it drops few
records and writes the rest of the records.
Posted by "Stefan Bodewig (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/LOG4NET-288?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Stefan Bodewig updated LOG4NET-288:
-----------------------------------
Fix Version/s: 1.2 Maintenance Release
I assume it is too late for you anyway.
You likely would have a better chance of getting responses from the user mailing list as way more people monitor the list (other users who may have encountered the same problem) than the issue tracker.
Have you tried 1.2.10 instead of 1.2.9?
> ADO.Net Appender is not writing all the records to the table in a high load/user scenario.It stops writing to the table untill i restart my app servers.Also sometimes, it drops few records and writes the rest of the records.
> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: LOG4NET-288
> URL: https://issues.apache.org/jira/browse/LOG4NET-288
> Project: Log4net
> Issue Type: Bug
> Components: Appenders
> Affects Versions: 1.2.9
> Environment: Windows 2008 server , IIS7.0 web site, Sql Server 2008 DB, ASP.net 2.0, .Net 3.0
> Reporter: Chetan Appannagari
> Priority: Blocker
> Fix For: 1.2 Maintenance Release
>
>
> We are using ADO.net appender to write audit records to the a table. Being an Audit table, all the actions performed by the user are recorded to this table along with the User's information like username,account information etc. In production environment we have close to 900-1000 users CONCURRENTLY accessing the system Monday - Sunday. Since every action of each user if tracked to Audit table, we have close to 50,000-200,000 records created every dya in this table.
> The problem is, in between, the ADO.Net appender is not writing all the records to the table. It drops a few records and writes the rest. And sometimes(happenned 3-4 times in production), it just stops writing to the table, untill we restart the app servers( IISRESET command). So basically 2 problems.
> Currently in PRODUCTION we haven't set reconnectOnError = "true" in the web.config file. We will be setting this in our next PROD build. Will this solve the 2nd Issue(just stops writing to table)?.
> We will enable internal debugging in the config file as well in the next PROD build. Will this let us know the exact reason why we are having these issues?
> Has this sort of problem been reported earlier?
> This is a highly critical issue. If we do not get answers to these quickly we may have to look at other options, which i personally don't want to do.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (LOG4NET-288) ADO.Net Appender is not writing
all the records to the table in a high load/user scenario.It stops writing
to the table untill i restart my app servers.Also sometimes, it drops few
records and writes the rest of the records.
Posted by "Tom Tang (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/LOG4NET-288?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13181065#comment-13181065 ]
Tom Tang commented on LOG4NET-288:
----------------------------------
By the system loading you described, you lost the records could be caused by SQL execution timeout.
Due to there's no way to extend the SqlCommand.ExecutionTimeout property in your code and its configuration, if the thread was blocked by any other logging thread more than 30 sec, it would get "SqlException:Execution timeout" and drop these message.
By that, your synchronized business code thread would be hanged by log4net till it got the exception returned.
So I don't suggest you to think the way how to extend the execution timeout.
Log4net is not a guarantee tool sot audit log the kind of serious usage, you better find the other tool or implement by your own.
"Log" is not as the same severity level as "Audit"
If your audit need to be 100% accurate, it will be to be involve a transaction scope, means the auditing failure shall cause your business logic rollback...That's much more than just a logging.
Best regards
> ADO.Net Appender is not writing all the records to the table in a high load/user scenario.It stops writing to the table untill i restart my app servers.Also sometimes, it drops few records and writes the rest of the records.
> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: LOG4NET-288
> URL: https://issues.apache.org/jira/browse/LOG4NET-288
> Project: Log4net
> Issue Type: Bug
> Components: Appenders
> Affects Versions: 1.2.9
> Environment: Windows 2008 server , IIS7.0 web site, Sql Server 2008 DB, ASP.net 2.0, .Net 3.0
> Reporter: Chetan Appannagari
> Priority: Blocker
> Fix For: 1.2 Maintenance Release
>
>
> We are using ADO.net appender to write audit records to the a table. Being an Audit table, all the actions performed by the user are recorded to this table along with the User's information like username,account information etc. In production environment we have close to 900-1000 users CONCURRENTLY accessing the system Monday - Sunday. Since every action of each user if tracked to Audit table, we have close to 50,000-200,000 records created every dya in this table.
> The problem is, in between, the ADO.Net appender is not writing all the records to the table. It drops a few records and writes the rest. And sometimes(happenned 3-4 times in production), it just stops writing to the table, untill we restart the app servers( IISRESET command). So basically 2 problems.
> Currently in PRODUCTION we haven't set reconnectOnError = "true" in the web.config file. We will be setting this in our next PROD build. Will this solve the 2nd Issue(just stops writing to table)?.
> We will enable internal debugging in the config file as well in the next PROD build. Will this let us know the exact reason why we are having these issues?
> Has this sort of problem been reported earlier?
> This is a highly critical issue. If we do not get answers to these quickly we may have to look at other options, which i personally don't want to do.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira