tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Арсений Зинченко <setev...@gmail.com>
Subject Tomcat && log4j vs MySQL
Date Mon, 07 Apr 2014 10:18:23 GMT
Hi.

Question are not exactly about Tomcat - but I hope somebody can help with
it.

So - we have Tomcat running. Apllication in it use log4j to write logs.

log4j configured to use syslogd daemon and syslogd uses MySQL to store logs.

Problem is that when we have any error in log - it writes it with newlines
when "at" in trace added.

For example:

14-03-24 13:49:59,574+0200 > 1641034 ERROR [com***l]
(http-8443-Processor25:CN=setevoy, OU=Unknown, O=Unknown, L=Unknown,
ST=Unknown, C=Unknown:10.***.***.15) Error in finding user: 'CN=setevoy,
OU=Unknown, O=Unknown, L=Unknown, ST=Unknown, C=Unknown'
org.s***.EmptyResultDataAccessException: Incorrect result size: expected 1,
actual 0
        at org.***(***.java:1520)
        at com.***(***.java:288)
        at sun.***0(Native Method)

Then - in database table its added again with "newlines" fro every "at'
element and, as it new line, it's added it with new entry for every line.

So tables looks like (this other error trace, not from example above):

mysql> select ID,Message from SystemEvents order by ID desc limit
60;...| 258433 |     at java.lang.Thread.run(Thread.java:662)
                                                        | 258432 |
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
                      | 258431 |     at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
| 258430 |     at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:541)


Instead of add error entirely in one cell of table.

Could it be reconfigured someway?

Thanks.

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message