Java Console - Event Monitor

[victor]

Hi!

Done it. It is where the power of Eclipse platform lies - contributing same extensions to different part of UI is very easy and sometimes takes just few minutes.

Best regards,
Victor

[lindeamon]

can't wait till next release.

Best Regards,
Lindeamon

[testos]

Hi!

My log file is filled with this message:

[20-Dec-2011 00:00:06] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[20-Dec-2011 00:00:06] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[20-Dec-2011 00:00:33] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[20-Dec-2011 00:00:33] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[20-Dec-2011 03:00:25] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away

Is this related to event log empty?

Best regards.

[victor]

Hi!

Yes, this is the reason why event log is empty. Do you get these errors all the time?

Best regards,
Victor

[testos]

Hi Victor.

No, it comes as burst and then pass hours without recurrence

[20-Dec-2011 00:00:06] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[20-Dec-2011 00:00:33] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[20-Dec-2011 00:00:33] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[20-Dec-2011 03:00:25] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[20-Dec-2011 09:57:31] Client session closed due to communication error (Connection reset by peer)
[20-Dec-2011 12:46:06] Thread "Syncer Thread" does not respond to watchdog thread
[20-Dec-2011 13:15:20] Client session closed due to communication error (Connection reset by peer)

Best regards.

[testos]

This problem persist in 1.1.10 version.

[15-Feb-2012 23:01:04] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[15-Feb-2012 23:01:04] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[15-Feb-2012 23:01:04] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[15-Feb-2012 23:01:04] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[16-Feb-2012 00:00:43] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[16-Feb-2012 00:00:58] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[16-Feb-2012 00:00:58] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[16-Feb-2012 00:00:58] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[16-Feb-2012 00:17:04] Client session closed due to communication error (No route to host)
[16-Feb-2012 18:52:08] Client session closed due to communication error (Connection reset by peer)
[16-Feb-2012 19:00:35] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[16-Feb-2012 19:00:37] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[16-Feb-2012 19:00:37] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[16-Feb-2012 19:00:39] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[16-Feb-2012 19:00:41] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[16-Feb-2012 19:00:44] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[16-Feb-2012 19:00:45] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[16-Feb-2012 19:00:45] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[16-Feb-2012 19:00:46] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[16-Feb-2012 19:00:47] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[16-Feb-2012 19:00:48] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[16-Feb-2012 19:00:49] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[16-Feb-2012 19:00:54] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[16-Feb-2012 19:00:56] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[16-Feb-2012 19:00:56] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[16-Feb-2012 19:00:57] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[16-Feb-2012 19:00:59] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[16-Feb-2012 19:01:01] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[16-Feb-2012 19:01:01] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[16-Feb-2012 19:01:01] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[16-Feb-2012 19:01:02] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[16-Feb-2012 19:01:04] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[16-Feb-2012 19:01:04] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[16-Feb-2012 19:01:05] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away

[testos]

Hi.

I had to restart the server because it did not allow new client connections. This is already a serious problem that should be resolved.

Best regards.

[13-Mar-2012 01:00:48] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[13-Mar-2012 01:00:48] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[13-Mar-2012 01:00:48] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[13-Mar-2012 01:00:48] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[13-Mar-2012 05:00:12] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[13-Mar-2012 06:00:39] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[13-Mar-2012 06:00:39] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away

[13-Mar-2012 09:53:18] Log file opened
[13-Mar-2012 09:53:18] Platform subagent "/usr/local/lib/libnsm_linux.so" successfully loaded
[13-Mar-2012 09:53:18] Database driver "/usr/local/lib/libnxddr_mysql.so" loaded and initialized successfully
[13-Mar-2012 09:53:18] Network device driver "CATALYST-2900XL" loaded successfully
[13-Mar-2012 09:53:18] Network device driver "ERS8000" loaded successfully
[13-Mar-2012 09:53:18] Network device driver "BAYSTACK" loaded successfully
[13-Mar-2012 09:53:18] Network device driver "NETSCREEN" loaded successfully
[13-Mar-2012 09:53:18] Network device driver "CATALYST-GENERIC" loaded successfully
[13-Mar-2012 09:53:38] Failed to compile script for service check object 22045 "PlantillaServicio": Error in line 1: syntax error, unexpected $end
[13-Mar-2012 09:53:38] NetXMS Server started
[13-Mar-2012 09:53:38] Listening for client connections on TCP socket 0.0.0.0:4701

[testos]

In my linux box, I set max_allowed_packet parameter in my.conf from 100M (not bad) to 300M and restarted mysqld. I would say if this solves it.

Best regards.

[testos]

It seems that has not helped. Does anyone get this error?
It is curious that usually occur in exact hours (03:00, 04:00, etc.)

[13-Mar-2012 10:47:19] NetXMS Server started
[13-Mar-2012 10:47:19] Listening for client connections on TCP socket 0.0.0.0:4701
[13-Mar-2012 14:24:32] Client session closed due to communication error (Connection reset by peer)
[13-Mar-2012 20:04:08] Client session closed due to communication error (Network is unreachable)
[14-Mar-2012 04:00:06] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[14-Mar-2012 04:00:06] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[14-Mar-2012 06:00:10] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[14-Mar-2012 06:00:10] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away
[14-Mar-2012 06:00:10] SQL query failed (Query = "INSERT INTO event_log (event_id,event_code,event_timestamp,event_source,event_severity,event_message,root_event_id,user_tag) VALUES (?,?,?,?,?,?,?,?)"): MySQL server has gone away

[victor]

From the error it seems that connection between NetXMS server and MySQL server is broken for some reason. There are many possible reasons for that. The fact that problem occurs on exact hours may point to some scheduled task, which broke communication with MySQL server in some way. Do you have MySQL server on same machine or on remote host?

Best regards,
Victor

[testos]

The fact that problem occurs on exact hours may point to some scheduled task, which broke communication with MySQL server in some way

All the users's crontab are empty. No system log error message at this time. No mysql log error message at this time.

Do you have MySQL server on same machine or on remote host?

The MySQL server is on same machine as the NetXMS server.

Best regards.