NetXMS Support Forum

hi,

in the current event monitor {v1.1.7} the "Event" Field is missing in oppose to the old console.

Best regards,
Lindeamon

Added.

Best regards,
Victor

Hi!
In legacy console Event Browser is also empty.

Best regards.

can't wait till next release.

Best Regards,
Lindeamon

hi victor,

in the old console i was able to invoke the "tools" menu from the event itself, when it will be applied to the java console ?

Best Regards,
Lindeamon

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

can't wait till next release.

Best Regards,
Lindeamon

Hi!

My log file is filled with this message:

Quote[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.

Hi!

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

Best regards,
Victor

Hi Victor.

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

Quote[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.

This problem persist in 1.1.10 version.

Quote[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

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.

Quote[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

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.

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.)

Quote[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

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