MySQL Bugs: #41439: logs being duplicated to stdout/catalina.out (without rotation)

Bug #41439	logs being duplicated to stdout/catalina.out (without rotation)
Submitted:	12 Dec 2008 15:54	Modified:	14 Jan 2009 14:51
Reporter:	Josh Sled	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Enterprise Monitor: Web	Severity:	S3 (Non-critical)
Version:	2.0.0.7122	OS:	Any
Assigned to:	Keith Russell	CPU Architecture:	Any

Description:
We still have the console/stdout appender in the log4j config, which means all the mem server logs are duplicated to catalina's stdout, and thus catalina.out, which is a bit wasteful, but more important because that file is not rotated or managed.

How to repeat:
start mem; wait; see catalina.out fill up.

Suggested fix:
remove console appender from release build.  Suggest 2.0-targeting.

taking assignment

Assigning over to keith.  I made this change locally, but it's not the right place to do it (cause we'll need to un-make it for any local development/changes on the 2.0 branch) … this is properly a build-time change.

As for the change, it should be as such:
----8<----
--- src/log4j.properties	2008-11-25 00:35:23 +0000
+++ src/log4j.properties	2008-12-12 17:55:20 +0000
@@ -1,4 +1,4 @@
-log4j.rootLogger = WARN, file, stdout
+log4j.rootLogger = WARN, file
 
 log4j.logger.com.mysql = INFO
---->8----

Remove the 'stdout' appender from the rootLogger, bob's your uncle.

The src/log4j.properties file will be modified as directed during the installer build.

Patch applied in versions => 2.0.2.7126.

Verified fixed in build 2.0.2.7126.

An entry was added to the 2.0 changelog:

When creating new multiple user accounts, the first attempt worked fine. However, following attempts to create new users did not show the Query Analyzer Options in the Create User popup until the role field was changed.

Apologies. Copy and paste error. The changelog entry reads:

The console/stdout appender remained in the log4j configuration, which meant that all the MySQL Enterprise Monitor server logs were duplicated to Catalina's stdout, and thus catalina.out, which was wasteful, especially as that file was not rotated or managed.