[ https://issues.apache.org/jira/browse/LOG4NET-442?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Alessio Sanguineti updated LOG4NET-442: --------------------------------------- Description: Hello, in our .NET application using Log4Net to log on a Sql Server 2014 database, we have set the parameter "ReconnectOnError" to true in the LogConfig.xml. As a test, we have stopped sql server and then re-started it, but the logger didnot reconnect. We get the following log file: log4net: log4net assembly [log4net, Version=1.2.13.0, Culture=neutral, PublicKeyToken=1b44e1d426115821]. Loaded from [C:\Projects\SIdG\TranslationEngine\bin\Debug\log4net.dll]. (.NET Runtime [4.0.30319.18444] on Microsoft Windows NT 6.1.7601 Service Pack 1) log4net: defaultRepositoryType [log4net.Repository.Hierarchy.Hierarchy] log4net: Creating repository for assembly [TranslationEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null] log4net: Assembly [TranslationEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null] Loaded From [C:\Projects\SIdG\TranslationEngine\bin\Debug\TranslationEngine.exe] log4net: Assembly [TranslationEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null] does not have a RepositoryAttribute specified. log4net: Assembly [TranslationEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null] using repository [log4net-default-repository] and repository type [log4net.Repository.Hierarchy.Hierarchy] log4net: Creating repository [log4net-default-repository] using type [log4net.Repository.Hierarchy.Hierarchy] log4net: configuring repository [log4net-default-repository] using file [C:\Projects\SIdG\TranslationEngine\bin\Debug\/LogConfig.xml] watching for file updates log4net: configuring repository [log4net-default-repository] using file [C:\Projects\SIdG\TranslationEngine\bin\Debug\/LogConfig.xml] log4net: configuring repository [log4net-default-repository] using stream log4net: loading XML configuration log4net: Configuring Repository [log4net-default-repository] log4net: Configuration update mode [Merge]. log4net: Logger [root] Level string is [DEBUG]. log4net: Logger [root] level set to [name="DEBUG",value=30000]. log4net: Loading Appender [AdoNetAppender] type: [log4net.Appender.AdoNetAppender] log4net: Setting Property [BufferSize] to Int32 value [1] log4net: Setting Property [ReconnectOnError] to Boolean value [True] log4net: Setting Property [ConnectionType] to String value [System.Data.SqlClient.SqlConnection, System.Data, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089] log4net: Setting Property [ConnectionString] to String value [data source=HYLSRVSIDG;initial catalog=SIDG_Log_AS;integrated security=false;persist security info=True;User ID=sa;Password=***;connection timeout=10; ConnectRetryCount=50; ConnectRetryInterval =30] log4net: Setting Property [CommandText] to String value [INSERT INTO dbo.Log ([Message],[Level],[Thread],[Logger],[Exception],[Timestamp],[Operation_Instance],[Operation_ID]) VALUES (@message,@log_level, @thread, @logger, @exception,@log_date, @opinst, @opid)] log4net: Setting Property [ParameterName] to String value [@log_date] log4net: Setting Property [DbType] to DbType value [DateTime] log4net: Setting Property [Layout] to object [log4net.Layout.RawTimeStampLayout] log4net: Setting Collection Property [AddParameter] to object [log4net.Appender.AdoNetAppenderParameter] log4net: Setting Property [ParameterName] to String value [@thread] log4net: Setting Property [DbType] to DbType value [String] log4net: Setting Property [Size] to Int32 value [255] log4net: Converter [message] Option [] Format [min=-1,max=2147483647,leftAlign=False] log4net: Converter [newline] Option [] Format [min=-1,max=2147483647,leftAlign=False] log4net: Setting Property [ConversionPattern] to String value [%thread] log4net: Converter [thread] Option [] Format [min=-1,max=2147483647,leftAlign=False] log4net: Setting Property [Layout] to object [log4net.Layout.Layout2RawLayoutAdapter] log4net: Setting Collection Property [AddParameter] to object [log4net.Appender.AdoNetAppenderParameter] log4net: Setting Property [ParameterName] to String value [@log_level] log4net: Setting Property [DbType] to DbType value [String] log4net: Setting Property [Size] to Int32 value [50] log4net: Converter [message] Option [] Format [min=-1,max=2147483647,leftAlign=False] log4net: Converter [newline] Option [] Format [min=-1,max=2147483647,leftAlign=False] log4net: Setting Property [ConversionPattern] to String value [%level] log4net: Converter [level] Option [] Format [min=-1,max=2147483647,leftAlign=False] log4net: Setting Property [Layout] to object [log4net.Layout.Layout2RawLayoutAdapter] log4net: Setting Collection Property [AddParameter] to object [log4net.Appender.AdoNetAppenderParameter] log4net: Setting Property [ParameterName] to String value [@logger] log4net: Setting Property [DbType] to DbType value [String] log4net: Setting Property [Size] to Int32 value [255] log4net: Converter [message] Option [] Format [min=-1,max=2147483647,leftAlign=False] log4net: Converter [newline] Option [] Format [min=-1,max=2147483647,leftAlign=False] log4net: Setting Property [ConversionPattern] to String value [%logger] log4net: Converter [logger] Option [] Format [min=-1,max=2147483647,leftAlign=False] log4net: Setting Property [Layout] to object [log4net.Layout.Layout2RawLayoutAdapter] log4net: Setting Collection Property [AddParameter] to object [log4net.Appender.AdoNetAppenderParameter] log4net: Setting Property [ParameterName] to String value [@message] log4net: Setting Property [DbType] to DbType value [String] log4net: Setting Property [Size] to Int32 value [4000] log4net: Converter [message] Option [] Format [min=-1,max=2147483647,leftAlign=False] log4net: Converter [newline] Option [] Format [min=-1,max=2147483647,leftAlign=False] log4net: Setting Property [ConversionPattern] to String value [%message] log4net: Converter [message] Option [] Format [min=-1,max=2147483647,leftAlign=False] log4net: Setting Property [Layout] to object [log4net.Layout.Layout2RawLayoutAdapter] log4net: Setting Collection Property [AddParameter] to object [log4net.Appender.AdoNetAppenderParameter] log4net: Setting Property [ParameterName] to String value [@exception] log4net: Setting Property [DbType] to DbType value [String] log4net: Setting Property [Size] to Int32 value [4000] log4net: Setting Property [Layout] to object [log4net.Layout.Layout2RawLayoutAdapter] log4net: Setting Collection Property [AddParameter] to object [log4net.Appender.AdoNetAppenderParameter] log4net: Setting Property [ParameterName] to String value [@opinst] log4net: Setting Property [DbType] to DbType value [Int32] log4net: Setting Property [Key] to String value [OperationInstance] log4net: Setting Property [Layout] to object [log4net.Layout.RawPropertyLayout] log4net: Setting Collection Property [AddParameter] to object [log4net.Appender.AdoNetAppenderParameter] log4net: Setting Property [ParameterName] to String value [@opid] log4net: Setting Property [DbType] to DbType value [Int32] log4net: Setting Property [Key] to String value [OperationID] log4net: Setting Property [Layout] to object [log4net.Layout.RawPropertyLayout] log4net: Setting Collection Property [AddParameter] to object [log4net.Appender.AdoNetAppenderParameter] log4net: Created Appender [AdoNetAppender] log4net: Adding appender named [AdoNetAppender] to logger [root]. log4net: Hierarchy Threshold [] log4net: Shutdown called on Hierarchy [log4net-default-repository] log4net: log4net assembly [log4net, Version=1.2.13.0, Culture=neutral, PublicKeyToken=1b44e1d426115821]. Loaded from [C:\Projects\SIdG\TranslationEngine\bin\Debug\log4net.dll]. (.NET Runtime [4.0.30319.18444] on Microsoft Windows NT 6.1.7601 Service Pack 1) log4net: defaultRepositoryType [log4net.Repository.Hierarchy.Hierarchy] log4net: Creating repository for assembly [TranslationEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null] log4net: Assembly [TranslationEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null] Loaded From [C:\Projects\SIdG\TranslationEngine\bin\Debug\TranslationEngine.exe] log4net: Assembly [TranslationEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null] does not have a RepositoryAttribute specified. log4net: Assembly [TranslationEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null] using repository [log4net-default-repository] and repository type [log4net.Repository.Hierarchy.Hierarchy] log4net: Creating repository [log4net-default-repository] using type [log4net.Repository.Hierarchy.Hierarchy] log4net: configuring repository [log4net-default-repository] using file [C:\Projects\SIdG\TranslationEngine\bin\Debug\/LogConfig.xml] watching for file updates log4net: configuring repository [log4net-default-repository] using file [C:\Projects\SIdG\TranslationEngine\bin\Debug\/LogConfig.xml] log4net: configuring repository [log4net-default-repository] using stream log4net: loading XML configuration log4net: Configuring Repository [log4net-default-repository] log4net: Configuration update mode [Merge]. log4net: Logger [root] Level string is [DEBUG]. log4net: Logger [root] level set to [name="DEBUG",value=30000]. log4net: Loading Appender [AdoNetAppender] type: [log4net.Appender.AdoNetAppender] log4net: Setting Property [BufferSize] to Int32 value [1] log4net: Setting Property [ReconnectOnError] to Boolean value [True] log4net: Setting Property [ConnectionType] to String value [System.Data.SqlClient.SqlConnection, System.Data, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089] log4net: Setting Property [ConnectionString] to String value [data source=HYLSRVSIDG;initial catalog=SIDG_Log_AS;integrated security=false;persist security info=True;User ID=sa;Password=***;connection timeout=10] log4net: Setting Property [CommandText] to String value [INSERT INTO dbo.Log ([Message],[Level],[Thread],[Logger],[Exception],[Timestamp],[Operation_Instance],[Operation_ID]) VALUES (@message,@log_level, @thread, @logger, @exception,@log_date, @opinst, @opid)] log4net: Setting Property [ParameterName] to String value [@log_date] log4net: Setting Property [DbType] to DbType value [DateTime] log4net: Setting Property [Layout] to object [log4net.Layout.RawTimeStampLayout] log4net: Setting Collection Property [AddParameter] to object [log4net.Appender.AdoNetAppenderParameter] log4net: Setting Property [ParameterName] to String value [@thread] log4net: Setting Property [DbType] to DbType value [String] log4net: Setting Property [Size] to Int32 value [255] log4net: Converter [message] Option [] Format [min=-1,max=2147483647,leftAlign=False] log4net: Converter [newline] Option [] Format [min=-1,max=2147483647,leftAlign=False] log4net: Setting Property [ConversionPattern] to String value [%thread] log4net: Converter [thread] Option [] Format [min=-1,max=2147483647,leftAlign=False] log4net: Setting Property [Layout] to object [log4net.Layout.Layout2RawLayoutAdapter] log4net: Setting Collection Property [AddParameter] to object [log4net.Appender.AdoNetAppenderParameter] log4net: Setting Property [ParameterName] to String value [@log_level] log4net: Setting Property [DbType] to DbType value [String] log4net: Setting Property [Size] to Int32 value [50] log4net: Converter [message] Option [] Format [min=-1,max=2147483647,leftAlign=False] log4net: Converter [newline] Option [] Format [min=-1,max=2147483647,leftAlign=False] log4net: Setting Property [ConversionPattern] to String value [%level] log4net: Converter [level] Option [] Format [min=-1,max=2147483647,leftAlign=False] log4net: Setting Property [Layout] to object [log4net.Layout.Layout2RawLayoutAdapter] log4net: Setting Collection Property [AddParameter] to object [log4net.Appender.AdoNetAppenderParameter] log4net: Setting Property [ParameterName] to String value [@logger] log4net: Setting Property [DbType] to DbType value [String] log4net: Setting Property [Size] to Int32 value [255] log4net: Converter [message] Option [] Format [min=-1,max=2147483647,leftAlign=False] log4net: Converter [newline] Option [] Format [min=-1,max=2147483647,leftAlign=False] log4net: Setting Property [ConversionPattern] to String value [%logger] log4net: Converter [logger] Option [] Format [min=-1,max=2147483647,leftAlign=False] log4net: Setting Property [Layout] to object [log4net.Layout.Layout2RawLayoutAdapter] log4net: Setting Collection Property [AddParameter] to object [log4net.Appender.AdoNetAppenderParameter] log4net: Setting Property [ParameterName] to String value [@message] log4net: Setting Property [DbType] to DbType value [String] log4net: Setting Property [Size] to Int32 value [4000] log4net: Converter [message] Option [] Format [min=-1,max=2147483647,leftAlign=False] log4net: Converter [newline] Option [] Format [min=-1,max=2147483647,leftAlign=False] log4net: Setting Property [ConversionPattern] to String value [%message] log4net: Converter [message] Option [] Format [min=-1,max=2147483647,leftAlign=False] log4net: Setting Property [Layout] to object [log4net.Layout.Layout2RawLayoutAdapter] log4net: Setting Collection Property [AddParameter] to object [log4net.Appender.AdoNetAppenderParameter] log4net: Setting Property [ParameterName] to String value [@exception] log4net: Setting Property [DbType] to DbType value [String] log4net: Setting Property [Size] to Int32 value [4000] log4net: Setting Property [Layout] to object [log4net.Layout.Layout2RawLayoutAdapter] log4net: Setting Collection Property [AddParameter] to object [log4net.Appender.AdoNetAppenderParameter] log4net: Setting Property [ParameterName] to String value [@opinst] log4net: Setting Property [DbType] to DbType value [Int32] log4net: Setting Property [Key] to String value [OperationInstance] log4net: Setting Property [Layout] to object [log4net.Layout.RawPropertyLayout] log4net: Setting Collection Property [AddParameter] to object [log4net.Appender.AdoNetAppenderParameter] log4net: Setting Property [ParameterName] to String value [@opid] log4net: Setting Property [DbType] to DbType value [Int32] log4net: Setting Property [Key] to String value [OperationID] log4net: Setting Property [Layout] to object [log4net.Layout.RawPropertyLayout] log4net: Setting Collection Property [AddParameter] to object [log4net.Appender.AdoNetAppenderParameter] log4net: Created Appender [AdoNetAppender] log4net: Adding appender named [AdoNetAppender] to logger [root]. log4net: Hierarchy Threshold [] log4net:ERROR [AdoNetAppender] ErrorCode: GenericFailure. Exception while writing to database System.Data.SqlClient.SqlException (0x80131904): The connection is broken and recovery is not possible. The client driver attempted to recover the connection one or more times and all attempts failed. Increase the value of ConnectRetryCount to increase the number of recovery attempts. ---> System.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) ---> System.ComponentModel.Win32Exception (0x80004005): Access is denied at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, Boolean withFailover) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) at System.Data.ProviderBase.DbConnectionPool.ReplaceConnection(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlInternalConnectionTds.TryReplaceConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.OpenAsync(CancellationToken cancellationToken) --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Data.SqlClient.SqlConnection.<ReconnectAsync>d__0.MoveNext() ClientConnectionId:00000000-0000-0000-0000-000000000000 at System.Data.SqlClient.SqlConnection.<ReconnectAsync>d__0.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Data.SqlClient.AsyncHelper.WaitForCompletion(Task task, Int32 timeout, Action onTimeout, Boolean rethrowExceptions) at System.Data.SqlClient.SqlInternalConnectionTds.ExecuteTransactionYukon(TransactionRequest transactionRequest, String transactionName, IsolationLevel iso, SqlInternalTransaction internalTransaction, Boolean isDelegateControlRequest) at System.Data.SqlClient.SqlInternalConnectionTds.ExecuteTransaction(TransactionRequest transactionRequest, String name, IsolationLevel iso, SqlInternalTransaction internalTransaction, Boolean isDelegateControlRequest) at System.Data.SqlClient.SqlInternalConnection.BeginSqlTransaction(IsolationLevel iso, String transactionName, Boolean shouldReconnect) at System.Data.SqlClient.SqlConnection.BeginTransaction(IsolationLevel iso, String transactionName) at System.Data.SqlClient.SqlConnection.BeginDbTransaction(IsolationLevel isolationLevel) at System.Data.Common.DbConnection.System.Data.IDbConnection.BeginTransaction() at log4net.Appender.AdoNetAppender.SendBuffer(LoggingEvent[] events) ClientConnectionId:e902ccea-9b4d-4119-a119-8ef480e8dc64 Thank you. Regards was: Hello, in our .NET application using Log4Net to log on a Sql Server 2014 database, we have set the parameter "ReconnectOnError" to true in the LogConfig.xml. As a test, we have stopped sql server and then re-started it, but the logger did not reconnect. We get the following log file: log4net: log4net assembly [log4net, Version=1.2.13.0, Culture=neutral, PublicKeyToken=1b44e1d426115821]. Loaded from [C:\Projects\SIdG\TranslationEngine\bin\Debug\log4net.dll]. (.NET Runtime [4.0.30319.18444] on Microsoft Windows NT 6.1.7601 Service Pack 1) log4net: defaultRepositoryType [log4net.Repository.Hierarchy.Hierarchy] log4net: Creating repository for assembly [TranslationEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null] log4net: Assembly [TranslationEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null] Loaded From [C:\Projects\SIdG\TranslationEngine\bin\Debug\TranslationEngine.exe] log4net: Assembly [TranslationEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null] does not have a RepositoryAttribute specified. log4net: Assembly [TranslationEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null] using repository [log4net-default-repository] and repository type [log4net.Repository.Hierarchy.Hierarchy] log4net: Creating repository [log4net-default-repository] using type [log4net.Repository.Hierarchy.Hierarchy] log4net: configuring repository [log4net-default-repository] using file [C:\Projects\SIdG\TranslationEngine\bin\Debug\/LogConfig.xml] watching for file updates log4net: configuring repository [log4net-default-repository] using file [C:\Projects\SIdG\TranslationEngine\bin\Debug\/LogConfig.xml] log4net: configuring repository [log4net-default-repository] using stream log4net: loading XML configuration log4net: Configuring Repository [log4net-default-repository] log4net: Configuration update mode [Merge]. log4net: Logger [root] Level string is [DEBUG]. log4net: Logger [root] level set to [name="DEBUG",value=30000]. log4net: Loading Appender [AdoNetAppender] type: [log4net.Appender.AdoNetAppender] log4net: Setting Property [BufferSize] to Int32 value [1] log4net: Setting Property [ReconnectOnError] to Boolean value [True] log4net: Setting Property [ConnectionType] to String value [System.Data.SqlClient.SqlConnection, System.Data, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089] log4net: Setting Property [ConnectionString] to String value [data source=HYLSRVSIDG;initial catalog=SIDG_Log_AS;integrated security=false;persist security info=True;User ID=sa;Password=***;connection timeout=10; ConnectRetryCount=50; ConnectRetryInterval =30] log4net: Setting Property [CommandText] to String value [INSERT INTO dbo.Log ([Message],[Level],[Thread],[Logger],[Exception],[Timestamp],[Operation_Instance],[Operation_ID]) VALUES (@message,@log_level, @thread, @logger, @exception,@log_date, @opinst, @opid)] log4net: Setting Property [ParameterName] to String value [@log_date] log4net: Setting Property [DbType] to DbType value [DateTime] log4net: Setting Property [Layout] to object [log4net.Layout.RawTimeStampLayout] log4net: Setting Collection Property [AddParameter] to object [log4net.Appender.AdoNetAppenderParameter] log4net: Setting Property [ParameterName] to String value [@thread] log4net: Setting Property [DbType] to DbType value [String] log4net: Setting Property [Size] to Int32 value [255] log4net: Converter [message] Option [] Format [min=-1,max=2147483647,leftAlign=False] log4net: Converter [newline] Option [] Format [min=-1,max=2147483647,leftAlign=False] log4net: Setting Property [ConversionPattern] to String value [%thread] log4net: Converter [thread] Option [] Format [min=-1,max=2147483647,leftAlign=False] log4net: Setting Property [Layout] to object [log4net.Layout.Layout2RawLayoutAdapter] log4net: Setting Collection Property [AddParameter] to object [log4net.Appender.AdoNetAppenderParameter] log4net: Setting Property [ParameterName] to String value [@log_level] log4net: Setting Property [DbType] to DbType value [String] log4net: Setting Property [Size] to Int32 value [50] log4net: Converter [message] Option [] Format [min=-1,max=2147483647,leftAlign=False] log4net: Converter [newline] Option [] Format [min=-1,max=2147483647,leftAlign=False] log4net: Setting Property [ConversionPattern] to String value [%level] log4net: Converter [level] Option [] Format [min=-1,max=2147483647,leftAlign=False] log4net: Setting Property [Layout] to object [log4net.Layout.Layout2RawLayoutAdapter] log4net: Setting Collection Property [AddParameter] to object [log4net.Appender.AdoNetAppenderParameter] log4net: Setting Property [ParameterName] to String value [@logger] log4net: Setting Property [DbType] to DbType value [String] log4net: Setting Property [Size] to Int32 value [255] log4net: Converter [message] Option [] Format [min=-1,max=2147483647,leftAlign=False] log4net: Converter [newline] Option [] Format [min=-1,max=2147483647,leftAlign=False] log4net: Setting Property [ConversionPattern] to String value [%logger] log4net: Converter [logger] Option [] Format [min=-1,max=2147483647,leftAlign=False] log4net: Setting Property [Layout] to object [log4net.Layout.Layout2RawLayoutAdapter] log4net: Setting Collection Property [AddParameter] to object [log4net.Appender.AdoNetAppenderParameter] log4net: Setting Property [ParameterName] to String value [@message] log4net: Setting Property [DbType] to DbType value [String] log4net: Setting Property [Size] to Int32 value [4000] log4net: Converter [message] Option [] Format [min=-1,max=2147483647,leftAlign=False] log4net: Converter [newline] Option [] Format [min=-1,max=2147483647,leftAlign=False] log4net: Setting Property [ConversionPattern] to String value [%message] log4net: Converter [message] Option [] Format [min=-1,max=2147483647,leftAlign=False] log4net: Setting Property [Layout] to object [log4net.Layout.Layout2RawLayoutAdapter] log4net: Setting Collection Property [AddParameter] to object [log4net.Appender.AdoNetAppenderParameter] log4net: Setting Property [ParameterName] to String value [@exception] log4net: Setting Property [DbType] to DbType value [String] log4net: Setting Property [Size] to Int32 value [4000] log4net: Setting Property [Layout] to object [log4net.Layout.Layout2RawLayoutAdapter] log4net: Setting Collection Property [AddParameter] to object [log4net.Appender.AdoNetAppenderParameter] log4net: Setting Property [ParameterName] to String value [@opinst] log4net: Setting Property [DbType] to DbType value [Int32] log4net: Setting Property [Key] to String value [OperationInstance] log4net: Setting Property [Layout] to object [log4net.Layout.RawPropertyLayout] log4net: Setting Collection Property [AddParameter] to object [log4net.Appender.AdoNetAppenderParameter] log4net: Setting Property [ParameterName] to String value [@opid] log4net: Setting Property [DbType] to DbType value [Int32] log4net: Setting Property [Key] to String value [OperationID] log4net: Setting Property [Layout] to object [log4net.Layout.RawPropertyLayout] log4net: Setting Collection Property [AddParameter] to object [log4net.Appender.AdoNetAppenderParameter] log4net: Created Appender [AdoNetAppender] log4net: Adding appender named [AdoNetAppender] to logger [root]. log4net: Hierarchy Threshold [] log4net: Shutdown called on Hierarchy [log4net-default-repository] log4net: log4net assembly [log4net, Version=1.2.13.0, Culture=neutral, PublicKeyToken=1b44e1d426115821]. Loaded from [C:\Projects\SIdG\TranslationEngine\bin\Debug\log4net.dll]. (.NET Runtime [4.0.30319.18444] on Microsoft Windows NT 6.1.7601 Service Pack 1) log4net: defaultRepositoryType [log4net.Repository.Hierarchy.Hierarchy] log4net: Creating repository for assembly [TranslationEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null] log4net: Assembly [TranslationEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null] Loaded From [C:\Projects\SIdG\TranslationEngine\bin\Debug\TranslationEngine.exe] log4net: Assembly [TranslationEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null] does not have a RepositoryAttribute specified. log4net: Assembly [TranslationEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null] using repository [log4net-default-repository] and repository type [log4net.Repository.Hierarchy.Hierarchy] log4net: Creating repository [log4net-default-repository] using type [log4net.Repository.Hierarchy.Hierarchy] log4net: configuring repository [log4net-default-repository] using file [C:\Projects\SIdG\TranslationEngine\bin\Debug\/LogConfig.xml] watching for file updates log4net: configuring repository [log4net-default-repository] using file [C:\Projects\SIdG\TranslationEngine\bin\Debug\/LogConfig.xml] log4net: configuring repository [log4net-default-repository] using stream log4net: loading XML configuration log4net: Configuring Repository [log4net-default-repository] log4net: Configuration update mode [Merge]. log4net: Logger [root] Level string is [DEBUG]. log4net: Logger [root] level set to [name="DEBUG",value=30000]. log4net: Loading Appender [AdoNetAppender] type: [log4net.Appender.AdoNetAppender] log4net: Setting Property [BufferSize] to Int32 value [1] log4net: Setting Property [ReconnectOnError] to Boolean value [True] log4net: Setting Property [ConnectionType] to String value [System.Data.SqlClient.SqlConnection, System.Data, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089] log4net: Setting Property [ConnectionString] to String value [data source=HYLSRVSIDG;initial catalog=SIDG_Log_AS;integrated security=false;persist security info=True;User ID=sa;Password=***;connection timeout=10] log4net: Setting Property [CommandText] to String value [INSERT INTO dbo.Log ([Message],[Level],[Thread],[Logger],[Exception],[Timestamp],[Operation_Instance],[Operation_ID]) VALUES (@message,@log_level, @thread, @logger, @exception,@log_date, @opinst, @opid)] log4net: Setting Property [ParameterName] to String value [@log_date] log4net: Setting Property [DbType] to DbType value [DateTime] log4net: Setting Property [Layout] to object [log4net.Layout.RawTimeStampLayout] log4net: Setting Collection Property [AddParameter] to object [log4net.Appender.AdoNetAppenderParameter] log4net: Setting Property [ParameterName] to String value [@thread] log4net: Setting Property [DbType] to DbType value [String] log4net: Setting Property [Size] to Int32 value [255] log4net: Converter [message] Option [] Format [min=-1,max=2147483647,leftAlign=False] log4net: Converter [newline] Option [] Format [min=-1,max=2147483647,leftAlign=False] log4net: Setting Property [ConversionPattern] to String value [%thread] log4net: Converter [thread] Option [] Format [min=-1,max=2147483647,leftAlign=False] log4net: Setting Property [Layout] to object [log4net.Layout.Layout2RawLayoutAdapter] log4net: Setting Collection Property [AddParameter] to object [log4net.Appender.AdoNetAppenderParameter] log4net: Setting Property [ParameterName] to String value [@log_level] log4net: Setting Property [DbType] to DbType value [String] log4net: Setting Property [Size] to Int32 value [50] log4net: Converter [message] Option [] Format [min=-1,max=2147483647,leftAlign=False] log4net: Converter [newline] Option [] Format [min=-1,max=2147483647,leftAlign=False] log4net: Setting Property [ConversionPattern] to String value [%level] log4net: Converter [level] Option [] Format [min=-1,max=2147483647,leftAlign=False] log4net: Setting Property [Layout] to object [log4net.Layout.Layout2RawLayoutAdapter] log4net: Setting Collection Property [AddParameter] to object [log4net.Appender.AdoNetAppenderParameter] log4net: Setting Property [ParameterName] to String value [@logger] log4net: Setting Property [DbType] to DbType value [String] log4net: Setting Property [Size] to Int32 value [255] log4net: Converter [message] Option [] Format [min=-1,max=2147483647,leftAlign=False] log4net: Converter [newline] Option [] Format [min=-1,max=2147483647,leftAlign=False] log4net: Setting Property [ConversionPattern] to String value [%logger] log4net: Converter [logger] Option [] Format [min=-1,max=2147483647,leftAlign=False] log4net: Setting Property [Layout] to object [log4net.Layout.Layout2RawLayoutAdapter] log4net: Setting Collection Property [AddParameter] to object [log4net.Appender.AdoNetAppenderParameter] log4net: Setting Property [ParameterName] to String value [@message] log4net: Setting Property [DbType] to DbType value [String] log4net: Setting Property [Size] to Int32 value [4000] log4net: Converter [message] Option [] Format [min=-1,max=2147483647,leftAlign=False] log4net: Converter [newline] Option [] Format [min=-1,max=2147483647,leftAlign=False] log4net: Setting Property [ConversionPattern] to String value [%message] log4net: Converter [message] Option [] Format [min=-1,max=2147483647,leftAlign=False] log4net: Setting Property [Layout] to object [log4net.Layout.Layout2RawLayoutAdapter] log4net: Setting Collection Property [AddParameter] to object [log4net.Appender.AdoNetAppenderParameter] log4net: Setting Property [ParameterName] to String value [@exception] log4net: Setting Property [DbType] to DbType value [String] log4net: Setting Property [Size] to Int32 value [4000] log4net: Setting Property [Layout] to object [log4net.Layout.Layout2RawLayoutAdapter] log4net: Setting Collection Property [AddParameter] to object [log4net.Appender.AdoNetAppenderParameter] log4net: Setting Property [ParameterName] to String value [@opinst] log4net: Setting Property [DbType] to DbType value [Int32] log4net: Setting Property [Key] to String value [OperationInstance] log4net: Setting Property [Layout] to object [log4net.Layout.RawPropertyLayout] log4net: Setting Collection Property [AddParameter] to object [log4net.Appender.AdoNetAppenderParameter] log4net: Setting Property [ParameterName] to String value [@opid] log4net: Setting Property [DbType] to DbType value [Int32] log4net: Setting Property [Key] to String value [OperationID] log4net: Setting Property [Layout] to object [log4net.Layout.RawPropertyLayout] log4net: Setting Collection Property [AddParameter] to object [log4net.Appender.AdoNetAppenderParameter] log4net: Created Appender [AdoNetAppender] log4net: Adding appender named [AdoNetAppender] to logger [root]. log4net: Hierarchy Threshold [] log4net:ERROR [AdoNetAppender] ErrorCode: GenericFailure. Exception while writing to database System.Data.SqlClient.SqlException (0x80131904): The connection is broken and recovery is not possible. The client driver attempted to recover the connection one or more times and all attempts failed. Increase the value of ConnectRetryCount to increase the number of recovery attempts. ---> System.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) ---> System.ComponentModel.Win32Exception (0x80004005): Access is denied at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, Boolean withFailover) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) at System.Data.ProviderBase.DbConnectionPool.ReplaceConnection(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlInternalConnectionTds.TryReplaceConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.OpenAsync(CancellationToken cancellationToken) --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Data.SqlClient.SqlConnection.<ReconnectAsync>d__0.MoveNext() ClientConnectionId:00000000-0000-0000-0000-000000000000 at System.Data.SqlClient.SqlConnection.<ReconnectAsync>d__0.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Data.SqlClient.AsyncHelper.WaitForCompletion(Task task, Int32 timeout, Action onTimeout, Boolean rethrowExceptions) at System.Data.SqlClient.SqlInternalConnectionTds.ExecuteTransactionYukon(TransactionRequest transactionRequest, String transactionName, IsolationLevel iso, SqlInternalTransaction internalTransaction, Boolean isDelegateControlRequest) at System.Data.SqlClient.SqlInternalConnectionTds.ExecuteTransaction(TransactionRequest transactionRequest, String name, IsolationLevel iso, SqlInternalTransaction internalTransaction, Boolean isDelegateControlRequest) at System.Data.SqlClient.SqlInternalConnection.BeginSqlTransaction(IsolationLevel iso, String transactionName, Boolean shouldReconnect) at System.Data.SqlClient.SqlConnection.BeginTransaction(IsolationLevel iso, String transactionName) at System.Data.SqlClient.SqlConnection.BeginDbTransaction(IsolationLevel isolationLevel) at System.Data.Common.DbConnection.System.Data.IDbConnection.BeginTransaction() at log4net.Appender.AdoNetAppender.SendBuffer(LoggingEvent[] events) ClientConnectionId:e902ccea-9b4d-4119-a119-8ef480e8dc64 Thank you. Regards > ReconnectOnError > ----------------- > > Key: LOG4NET-442 > URL: https://issues.apache.org/jira/browse/LOG4NET-442 > Project: Log4net > Issue Type: Bug > Components: Builds > Affects Versions: 1.2.13 > Environment: Microsoft .NET 4.5 > Reporter: Alessio Sanguineti > > Hello, in our .NET application using Log4Net to log on a Sql Server 2014 > database, we have set the parameter "ReconnectOnError" to true in the > LogConfig.xml. As a test, we have stopped sql server and then re-started it, > but the logger didnot reconnect. We get the following log file: > log4net: log4net assembly [log4net, Version=1.2.13.0, Culture=neutral, > PublicKeyToken=1b44e1d426115821]. Loaded from > [C:\Projects\SIdG\TranslationEngine\bin\Debug\log4net.dll]. (.NET Runtime > [4.0.30319.18444] on Microsoft Windows NT 6.1.7601 Service Pack 1) > log4net: defaultRepositoryType [log4net.Repository.Hierarchy.Hierarchy] > log4net: Creating repository for assembly [TranslationEngine, > Version=1.0.0.0, Culture=neutral, PublicKeyToken=null] > log4net: Assembly [TranslationEngine, Version=1.0.0.0, Culture=neutral, > PublicKeyToken=null] Loaded From > [C:\Projects\SIdG\TranslationEngine\bin\Debug\TranslationEngine.exe] > log4net: Assembly [TranslationEngine, Version=1.0.0.0, Culture=neutral, > PublicKeyToken=null] does not have a RepositoryAttribute specified. > log4net: Assembly [TranslationEngine, Version=1.0.0.0, Culture=neutral, > PublicKeyToken=null] using repository [log4net-default-repository] and > repository type [log4net.Repository.Hierarchy.Hierarchy] > log4net: Creating repository [log4net-default-repository] using type > [log4net.Repository.Hierarchy.Hierarchy] > log4net: configuring repository [log4net-default-repository] using file > [C:\Projects\SIdG\TranslationEngine\bin\Debug\/LogConfig.xml] watching for > file updates > log4net: configuring repository [log4net-default-repository] using file > [C:\Projects\SIdG\TranslationEngine\bin\Debug\/LogConfig.xml] > log4net: configuring repository [log4net-default-repository] using stream > log4net: loading XML configuration > log4net: Configuring Repository [log4net-default-repository] > log4net: Configuration update mode [Merge]. > log4net: Logger [root] Level string is [DEBUG]. > log4net: Logger [root] level set to [name="DEBUG",value=30000]. > log4net: Loading Appender [AdoNetAppender] type: > [log4net.Appender.AdoNetAppender] > log4net: Setting Property [BufferSize] to Int32 value [1] > log4net: Setting Property [ReconnectOnError] to Boolean value [True] > log4net: Setting Property [ConnectionType] to String value > [System.Data.SqlClient.SqlConnection, System.Data, Version=1.0.3300.0, > Culture=neutral, PublicKeyToken=b77a5c561934e089] > log4net: Setting Property [ConnectionString] to String value [data > source=HYLSRVSIDG;initial catalog=SIDG_Log_AS;integrated > security=false;persist security info=True;User ID=sa;Password=***;connection > timeout=10; ConnectRetryCount=50; ConnectRetryInterval =30] > log4net: Setting Property [CommandText] to String value [INSERT INTO dbo.Log > ([Message],[Level],[Thread],[Logger],[Exception],[Timestamp],[Operation_Instance],[Operation_ID]) > VALUES (@message,@log_level, @thread, @logger, @exception,@log_date, > @opinst, @opid)] > log4net: Setting Property [ParameterName] to String value [@log_date] > log4net: Setting Property [DbType] to DbType value [DateTime] > log4net: Setting Property [Layout] to object > [log4net.Layout.RawTimeStampLayout] > log4net: Setting Collection Property [AddParameter] to object > [log4net.Appender.AdoNetAppenderParameter] > log4net: Setting Property [ParameterName] to String value [@thread] > log4net: Setting Property [DbType] to DbType value [String] > log4net: Setting Property [Size] to Int32 value [255] > log4net: Converter [message] Option [] Format > [min=-1,max=2147483647,leftAlign=False] > log4net: Converter [newline] Option [] Format > [min=-1,max=2147483647,leftAlign=False] > log4net: Setting Property [ConversionPattern] to String value [%thread] > log4net: Converter [thread] Option [] Format > [min=-1,max=2147483647,leftAlign=False] > log4net: Setting Property [Layout] to object > [log4net.Layout.Layout2RawLayoutAdapter] > log4net: Setting Collection Property [AddParameter] to object > [log4net.Appender.AdoNetAppenderParameter] > log4net: Setting Property [ParameterName] to String value [@log_level] > log4net: Setting Property [DbType] to DbType value [String] > log4net: Setting Property [Size] to Int32 value [50] > log4net: Converter [message] Option [] Format > [min=-1,max=2147483647,leftAlign=False] > log4net: Converter [newline] Option [] Format > [min=-1,max=2147483647,leftAlign=False] > log4net: Setting Property [ConversionPattern] to String value [%level] > log4net: Converter [level] Option [] Format > [min=-1,max=2147483647,leftAlign=False] > log4net: Setting Property [Layout] to object > [log4net.Layout.Layout2RawLayoutAdapter] > log4net: Setting Collection Property [AddParameter] to object > [log4net.Appender.AdoNetAppenderParameter] > log4net: Setting Property [ParameterName] to String value [@logger] > log4net: Setting Property [DbType] to DbType value [String] > log4net: Setting Property [Size] to Int32 value [255] > log4net: Converter [message] Option [] Format > [min=-1,max=2147483647,leftAlign=False] > log4net: Converter [newline] Option [] Format > [min=-1,max=2147483647,leftAlign=False] > log4net: Setting Property [ConversionPattern] to String value [%logger] > log4net: Converter [logger] Option [] Format > [min=-1,max=2147483647,leftAlign=False] > log4net: Setting Property [Layout] to object > [log4net.Layout.Layout2RawLayoutAdapter] > log4net: Setting Collection Property [AddParameter] to object > [log4net.Appender.AdoNetAppenderParameter] > log4net: Setting Property [ParameterName] to String value [@message] > log4net: Setting Property [DbType] to DbType value [String] > log4net: Setting Property [Size] to Int32 value [4000] > log4net: Converter [message] Option [] Format > [min=-1,max=2147483647,leftAlign=False] > log4net: Converter [newline] Option [] Format > [min=-1,max=2147483647,leftAlign=False] > log4net: Setting Property [ConversionPattern] to String value [%message] > log4net: Converter [message] Option [] Format > [min=-1,max=2147483647,leftAlign=False] > log4net: Setting Property [Layout] to object > [log4net.Layout.Layout2RawLayoutAdapter] > log4net: Setting Collection Property [AddParameter] to object > [log4net.Appender.AdoNetAppenderParameter] > log4net: Setting Property [ParameterName] to String value [@exception] > log4net: Setting Property [DbType] to DbType value [String] > log4net: Setting Property [Size] to Int32 value [4000] > log4net: Setting Property [Layout] to object > [log4net.Layout.Layout2RawLayoutAdapter] > log4net: Setting Collection Property [AddParameter] to object > [log4net.Appender.AdoNetAppenderParameter] > log4net: Setting Property [ParameterName] to String value [@opinst] > log4net: Setting Property [DbType] to DbType value [Int32] > log4net: Setting Property [Key] to String value [OperationInstance] > log4net: Setting Property [Layout] to object > [log4net.Layout.RawPropertyLayout] > log4net: Setting Collection Property [AddParameter] to object > [log4net.Appender.AdoNetAppenderParameter] > log4net: Setting Property [ParameterName] to String value [@opid] > log4net: Setting Property [DbType] to DbType value [Int32] > log4net: Setting Property [Key] to String value [OperationID] > log4net: Setting Property [Layout] to object > [log4net.Layout.RawPropertyLayout] > log4net: Setting Collection Property [AddParameter] to object > [log4net.Appender.AdoNetAppenderParameter] > log4net: Created Appender [AdoNetAppender] > log4net: Adding appender named [AdoNetAppender] to logger [root]. > log4net: Hierarchy Threshold [] > log4net: Shutdown called on Hierarchy [log4net-default-repository] > log4net: log4net assembly [log4net, Version=1.2.13.0, Culture=neutral, > PublicKeyToken=1b44e1d426115821]. Loaded from > [C:\Projects\SIdG\TranslationEngine\bin\Debug\log4net.dll]. (.NET Runtime > [4.0.30319.18444] on Microsoft Windows NT 6.1.7601 Service Pack 1) > log4net: defaultRepositoryType [log4net.Repository.Hierarchy.Hierarchy] > log4net: Creating repository for assembly [TranslationEngine, > Version=1.0.0.0, Culture=neutral, PublicKeyToken=null] > log4net: Assembly [TranslationEngine, Version=1.0.0.0, Culture=neutral, > PublicKeyToken=null] Loaded From > [C:\Projects\SIdG\TranslationEngine\bin\Debug\TranslationEngine.exe] > log4net: Assembly [TranslationEngine, Version=1.0.0.0, Culture=neutral, > PublicKeyToken=null] does not have a RepositoryAttribute specified. > log4net: Assembly [TranslationEngine, Version=1.0.0.0, Culture=neutral, > PublicKeyToken=null] using repository [log4net-default-repository] and > repository type [log4net.Repository.Hierarchy.Hierarchy] > log4net: Creating repository [log4net-default-repository] using type > [log4net.Repository.Hierarchy.Hierarchy] > log4net: configuring repository [log4net-default-repository] using file > [C:\Projects\SIdG\TranslationEngine\bin\Debug\/LogConfig.xml] watching for > file updates > log4net: configuring repository [log4net-default-repository] using file > [C:\Projects\SIdG\TranslationEngine\bin\Debug\/LogConfig.xml] > log4net: configuring repository [log4net-default-repository] using stream > log4net: loading XML configuration > log4net: Configuring Repository [log4net-default-repository] > log4net: Configuration update mode [Merge]. > log4net: Logger [root] Level string is [DEBUG]. > log4net: Logger [root] level set to [name="DEBUG",value=30000]. > log4net: Loading Appender [AdoNetAppender] type: > [log4net.Appender.AdoNetAppender] > log4net: Setting Property [BufferSize] to Int32 value [1] > log4net: Setting Property [ReconnectOnError] to Boolean value [True] > log4net: Setting Property [ConnectionType] to String value > [System.Data.SqlClient.SqlConnection, System.Data, Version=1.0.3300.0, > Culture=neutral, PublicKeyToken=b77a5c561934e089] > log4net: Setting Property [ConnectionString] to String value [data > source=HYLSRVSIDG;initial catalog=SIDG_Log_AS;integrated > security=false;persist security info=True;User ID=sa;Password=***;connection > timeout=10] > log4net: Setting Property [CommandText] to String value [INSERT INTO dbo.Log > ([Message],[Level],[Thread],[Logger],[Exception],[Timestamp],[Operation_Instance],[Operation_ID]) > VALUES (@message,@log_level, @thread, @logger, @exception,@log_date, > @opinst, @opid)] > log4net: Setting Property [ParameterName] to String value [@log_date] > log4net: Setting Property [DbType] to DbType value [DateTime] > log4net: Setting Property [Layout] to object > [log4net.Layout.RawTimeStampLayout] > log4net: Setting Collection Property [AddParameter] to object > [log4net.Appender.AdoNetAppenderParameter] > log4net: Setting Property [ParameterName] to String value [@thread] > log4net: Setting Property [DbType] to DbType value [String] > log4net: Setting Property [Size] to Int32 value [255] > log4net: Converter [message] Option [] Format > [min=-1,max=2147483647,leftAlign=False] > log4net: Converter [newline] Option [] Format > [min=-1,max=2147483647,leftAlign=False] > log4net: Setting Property [ConversionPattern] to String value [%thread] > log4net: Converter [thread] Option [] Format > [min=-1,max=2147483647,leftAlign=False] > log4net: Setting Property [Layout] to object > [log4net.Layout.Layout2RawLayoutAdapter] > log4net: Setting Collection Property [AddParameter] to object > [log4net.Appender.AdoNetAppenderParameter] > log4net: Setting Property [ParameterName] to String value [@log_level] > log4net: Setting Property [DbType] to DbType value [String] > log4net: Setting Property [Size] to Int32 value [50] > log4net: Converter [message] Option [] Format > [min=-1,max=2147483647,leftAlign=False] > log4net: Converter [newline] Option [] Format > [min=-1,max=2147483647,leftAlign=False] > log4net: Setting Property [ConversionPattern] to String value [%level] > log4net: Converter [level] Option [] Format > [min=-1,max=2147483647,leftAlign=False] > log4net: Setting Property [Layout] to object > [log4net.Layout.Layout2RawLayoutAdapter] > log4net: Setting Collection Property [AddParameter] to object > [log4net.Appender.AdoNetAppenderParameter] > log4net: Setting Property [ParameterName] to String value [@logger] > log4net: Setting Property [DbType] to DbType value [String] > log4net: Setting Property [Size] to Int32 value [255] > log4net: Converter [message] Option [] Format > [min=-1,max=2147483647,leftAlign=False] > log4net: Converter [newline] Option [] Format > [min=-1,max=2147483647,leftAlign=False] > log4net: Setting Property [ConversionPattern] to String value [%logger] > log4net: Converter [logger] Option [] Format > [min=-1,max=2147483647,leftAlign=False] > log4net: Setting Property [Layout] to object > [log4net.Layout.Layout2RawLayoutAdapter] > log4net: Setting Collection Property [AddParameter] to object > [log4net.Appender.AdoNetAppenderParameter] > log4net: Setting Property [ParameterName] to String value [@message] > log4net: Setting Property [DbType] to DbType value [String] > log4net: Setting Property [Size] to Int32 value [4000] > log4net: Converter [message] Option [] Format > [min=-1,max=2147483647,leftAlign=False] > log4net: Converter [newline] Option [] Format > [min=-1,max=2147483647,leftAlign=False] > log4net: Setting Property [ConversionPattern] to String value [%message] > log4net: Converter [message] Option [] Format > [min=-1,max=2147483647,leftAlign=False] > log4net: Setting Property [Layout] to object > [log4net.Layout.Layout2RawLayoutAdapter] > log4net: Setting Collection Property [AddParameter] to object > [log4net.Appender.AdoNetAppenderParameter] > log4net: Setting Property [ParameterName] to String value [@exception] > log4net: Setting Property [DbType] to DbType value [String] > log4net: Setting Property [Size] to Int32 value [4000] > log4net: Setting Property [Layout] to object > [log4net.Layout.Layout2RawLayoutAdapter] > log4net: Setting Collection Property [AddParameter] to object > [log4net.Appender.AdoNetAppenderParameter] > log4net: Setting Property [ParameterName] to String value [@opinst] > log4net: Setting Property [DbType] to DbType value [Int32] > log4net: Setting Property [Key] to String value [OperationInstance] > log4net: Setting Property [Layout] to object > [log4net.Layout.RawPropertyLayout] > log4net: Setting Collection Property [AddParameter] to object > [log4net.Appender.AdoNetAppenderParameter] > log4net: Setting Property [ParameterName] to String value [@opid] > log4net: Setting Property [DbType] to DbType value [Int32] > log4net: Setting Property [Key] to String value [OperationID] > log4net: Setting Property [Layout] to object > [log4net.Layout.RawPropertyLayout] > log4net: Setting Collection Property [AddParameter] to object > [log4net.Appender.AdoNetAppenderParameter] > log4net: Created Appender [AdoNetAppender] > log4net: Adding appender named [AdoNetAppender] to logger [root]. > log4net: Hierarchy Threshold [] > log4net:ERROR [AdoNetAppender] ErrorCode: GenericFailure. Exception while > writing to database > System.Data.SqlClient.SqlException (0x80131904): The connection is broken and > recovery is not possible. The client driver attempted to recover the > connection one or more times and all attempts failed. Increase the value of > ConnectRetryCount to increase the number of recovery attempts. ---> > System.Data.SqlClient.SqlException (0x80131904): A network-related or > instance-specific error occurred while establishing a connection to SQL > Server. The server was not found or was not accessible. Verify that the > instance name is correct and that SQL Server is configured to allow remote > connections. (provider: Named Pipes Provider, error: 40 - Could not open a > connection to SQL Server) ---> System.ComponentModel.Win32Exception > (0x80004005): Access is denied > at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException > exception, Boolean breakConnection, Action`1 wrapCloseInAction) > at > System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject > stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) > at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, > SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 > timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean > integratedSecurity, Boolean withFailover) > at > System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo > serverInfo, String newPassword, SecureString newSecurePassword, Boolean > ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover) > at > System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo > serverInfo, String newPassword, SecureString newSecurePassword, Boolean > redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential > credential, TimeoutTimer timeout) > at > System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer > timeout, SqlConnectionString connectionOptions, SqlCredential credential, > String newPassword, SecureString newSecurePassword, Boolean > redirectedUserInstance) > at > System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity > identity, SqlConnectionString connectionOptions, SqlCredential credential, > Object providerInfo, String newPassword, SecureString newSecurePassword, > Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, > SessionData reconnectSessionData) > at > System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions > options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, > DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions > userOptions) > at > System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool > pool, DbConnection owningObject, DbConnectionOptions options, > DbConnectionPoolKey poolKey, DbConnectionOptions userOptions) > at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection > owningObject, DbConnectionOptions userOptions, DbConnectionInternal > oldConnection) > at > System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection > owningObject, DbConnectionOptions userOptions, DbConnectionInternal > oldConnection) > at > System.Data.ProviderBase.DbConnectionPool.ReplaceConnection(DbConnection > owningObject, DbConnectionOptions userOptions, DbConnectionInternal > oldConnection) > at > System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection > owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions > userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& > connection) > at > System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection > outerConnection, DbConnectionFactory connectionFactory, > TaskCompletionSource`1 retry, DbConnectionOptions userOptions) > at > System.Data.SqlClient.SqlInternalConnectionTds.TryReplaceConnection(DbConnection > outerConnection, DbConnectionFactory connectionFactory, > TaskCompletionSource`1 retry, DbConnectionOptions userOptions) > at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 > retry) > at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 > retry) > at System.Data.SqlClient.SqlConnection.OpenAsync(CancellationToken > cancellationToken) > --- End of stack trace from previous location where exception was thrown --- > at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task > task) > at > System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task > task) > at System.Data.SqlClient.SqlConnection.<ReconnectAsync>d__0.MoveNext() > ClientConnectionId:00000000-0000-0000-0000-000000000000 > at System.Data.SqlClient.SqlConnection.<ReconnectAsync>d__0.MoveNext() > --- End of stack trace from previous location where exception was thrown --- > at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() > at System.Data.SqlClient.AsyncHelper.WaitForCompletion(Task task, Int32 > timeout, Action onTimeout, Boolean rethrowExceptions) > at > System.Data.SqlClient.SqlInternalConnectionTds.ExecuteTransactionYukon(TransactionRequest > transactionRequest, String transactionName, IsolationLevel iso, > SqlInternalTransaction internalTransaction, Boolean isDelegateControlRequest) > at > System.Data.SqlClient.SqlInternalConnectionTds.ExecuteTransaction(TransactionRequest > transactionRequest, String name, IsolationLevel iso, SqlInternalTransaction > internalTransaction, Boolean isDelegateControlRequest) > at > System.Data.SqlClient.SqlInternalConnection.BeginSqlTransaction(IsolationLevel > iso, String transactionName, Boolean shouldReconnect) > at System.Data.SqlClient.SqlConnection.BeginTransaction(IsolationLevel > iso, String transactionName) > at System.Data.SqlClient.SqlConnection.BeginDbTransaction(IsolationLevel > isolationLevel) > at > System.Data.Common.DbConnection.System.Data.IDbConnection.BeginTransaction() > at log4net.Appender.AdoNetAppender.SendBuffer(LoggingEvent[] events) > ClientConnectionId:e902ccea-9b4d-4119-a119-8ef480e8dc64 > Thank you. > Regards -- This message was sent by Atlassian JIRA (v6.3.4#6332)