Bug #41439 logs being duplicated to stdout/catalina.out (without rotation)
Submitted: 12 Dec 2008 16:54 Modified: 14 Jan 2009 15:51
Reporter: Josh Sled
Status: Closed
Category:Monitoring: Web Severity:S3 (Non-critical)
Version:2.0.0.7122 OS:Any
Assigned to: Keith Russell Target Version:2.0 maint release

[12 Dec 2008 16:54] Josh Sled
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.
[12 Dec 2008 18:24] Josh Sled
taking assignment
[12 Dec 2008 18:57] Josh Sled
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.
[12 Dec 2008 20:09] Keith Russell
The src/log4j.properties file will be modified as directed during the installer build.
[17 Dec 2008 23:18] Keith Russell
Patch applied in versions => 2.0.2.7126.
[18 Dec 2008 18:27] Marcos Palacios
Verified fixed in build 2.0.2.7126.
[14 Jan 2009 15:51] Tony Bedford
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.
[14 Jan 2009 15:55] Tony Bedford
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.