[LOG4J2-469] FailoverAppender does not retry back for Primary target

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.0-beta9
• Fix Version/s: 2.0-rc2
• Component/s: Appenders
• Labels: features

Environment

JBoss 6.1.1, Spring-MVC, Log4j2 beta-9, Windows 7, Eclipse Kelper

• Assignee: Ralph Goers
• Reporter: Indrajit Pingale
• Created: 18/Dec/13 10:14
• Updated: 12/May/14 06:23
• Resolved: 12/May/14 06:23

Description

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.

    <?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>

Thank You,
Indrajit

Issue Links

• is related to: LOG4J2-407 JDBCAppender cannot recover from loss of database connectivity