[
https://issues.apache.org/jira/browse/LOG4J2-469?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13851890#comment-13851890
]
Ralph Goers commented on LOG4J2-469:
------------------------------------
In looking at the code I definitely see a problem, although not exactly what
you are are reporting. Once a failure occurs a boolean flag is set. The
failover appender will retry the primary appender periodically (the interval is
controlled by the retryInterval attribute which defaults to 60 seconds).
However, when the primary is again successful the flag is not reset. Instead,
every subsequent call is going to try the primary, discover it doesn't work (or
that it does) and then go to the failover via exception handling instead of
waiting for the next retry interval.
The problem you are experiencing is more than likely that the JDBC Appender may
not be attempting to reconnect after the connection database connection fails.
> FailoverAppender does not retry back for Primary target
> -------------------------------------------------------
>
> Key: LOG4J2-469
> URL: https://issues.apache.org/jira/browse/LOG4J2-469
> Project: Log4j 2
> Issue Type: Bug
> Components: Appenders
> Affects Versions: 2.0-beta9
> Environment: JBoss 6.1.1, Spring-MVC, Log4j2 beta-9, Windows 7,
> Eclipse Kelper
> Reporter: Indrajit Pingale
> Labels: features
>
> Hi,
> In my product, I am using log4j2 for logging onto MySQL database. For
> that I am using JDBC as Primary and RollingRandomAccessFile as Secondary
> Appender.
> It works well and logs goes to Secondary appender when Primary appender
> fails (due to MySQL connection lost). But when MySQL connection comes back,
> it does not logs back to MySQL until I restart the JBoss Server.
> Is this a expected behavior? Or I am missing something in configuration
> file.
> Following is the my log4j2.xml file.
> {code:xml}
> <?xml version="1.0" encoding="UTF-8"?>
> <Configuration status="error">
> <Appenders>
> <JDBC name="databaseAppender" tableName="system_log"
> ignoreExceptions="false" bufferSize="10">
> <DriverManager
> url="jdbc:mysql://localhost:3306/xxxid_db"
> username="root" password="xxxxxxwing" />
> <Column name="log_id" pattern="%x" />
> <Column name="log_dated" isEventTimestamp="true" />
> <Column name="log_logger" pattern="%logger" />
> <Column name="log_level" pattern="%level" />
> <Column name="log_message" pattern="%message" />
> <Column name="log_throwable" pattern="%ex{full}" />
> </JDBC>
> <RollingRandomAccessFile name="RollingRandomAccessFile"
> fileName="${sys:jboss.server.log.dir}/app.log"
> filePattern="${sys:jboss.server.log.dir}/$${date:yyyy-MM}/app-%d{MM-dd-yyyy}-%i.log.gz">
> <PatternLayout>
> <Pattern>%d %p %c{1.} [%t] %m%n</Pattern>
> </PatternLayout>
> <Policies>
> <TimeBasedTriggeringPolicy />
> <SizeBasedTriggeringPolicy size="250 MB" />
> </Policies>
> </RollingRandomAccessFile>
> <Failover name="Failover" primary="databaseAppender"
> ignoreExceptions="false">
> <Failovers>
> <AppenderRef ref="RollingRandomAccessFile" />
> </Failovers>
> </Failover>
> </Appenders>
> <Loggers>
> <Root level="warn">
> <AppenderRef ref="Failover" />
> </Root>
> </Loggers>
> </Configuration>
> {code}
> Thank You,
> Indrajit
--
This message was sent by Atlassian JIRA
(v6.1.4#6159)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
