Text only | Text with Images

NetXMS Support Forum

English Support => Feature Requests => Topic started by: lindeamon on December 15, 2011, 09:42:49 AM

Title: Java Console - Event Monitor
Post by: lindeamon on December 15, 2011, 09:42:49 AM
hi,

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

Best regards,
Lindeamon
Title: Re: Java Console - Event Monitor
Post by: Victor Kirhenshtein on December 15, 2011, 11:15:57 AM
Added.

Best regards,
Victor
Title: Re: Java Console - Event Monitor
Post by: testos on December 15, 2011, 12:28:03 PM
Hi!
In legacy console Event Browser is also empty.

Best regards.
Title: Re: Java Console - Event Monitor
Post by: lindeamon on December 15, 2011, 01:06:45 PM
can't wait till next release.

Best Regards,
Lindeamon
Title: Re: Java Console - Event Monitor
Post by: lindeamon on December 18, 2011, 11:51:15 AM
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
Title: Re: Java Console - Event Monitor
Post by: Victor Kirhenshtein on December 19, 2011, 11:23:46 AM
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
Title: Re: Java Console - Event Monitor
Post by: lindeamon on December 19, 2011, 12:30:08 PM
can't wait till next release.

Best Regards,
Lindeamon
Title: Re: Java Console - Event Monitor
Post by: testos on December 20, 2011, 03:34:07 PM
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.
Title: Re: Java Console - Event Monitor
Post by: Victor Kirhenshtein on December 20, 2011, 03:57:25 PM
Hi!

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

Best regards,
Victor
Title: Re: Java Console - Event Monitor
Post by: testos on December 20, 2011, 04:03:36 PM
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.
Title: Re: Java Console - Event Monitor
Post by: testos on February 16, 2012, 10:33:32 PM
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
Title: Re: Java Console - Event Monitor
Post by: testos on March 13, 2012, 11:12:02 AM
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


Title: Re: Java Console - Event Monitor
Post by: testos on March 13, 2012, 11:25:50 AM

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.
Title: Re: Java Console - Event Monitor
Post by: testos on March 14, 2012, 09:13:07 AM
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
Title: Re: Java Console - Event Monitor
Post by: Victor Kirhenshtein on March 14, 2012, 10:20:16 AM
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
Title: Re: Java Console - Event Monitor
Post by: testos on March 14, 2012, 02:29:04 PM

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

QuoteDo you have MySQL server on same machine or on remote host?
The MySQL server is on same machine as the NetXMS server.

Best regards.
Text only | Text with Images