Search found 214 matches

by CBoekhuis
Thu Aug 20, 2020 2:51 pm
Forum: Nagios XI
Topic: SQL Error [nagiosxi] : ERROR: syntax error at or near
Replies: 17
Views: 2358

Re: SQL Error [nagiosxi] : ERROR: syntax error at or near

Hi, acties are done. After apply services return whitin short time with result. Also mysql process is not spinning as far i can see. cleaner.log still shows errors: ---------------------------------- Running callbacks: ---------------------------------- <p><pre>SQL Error [nagiosxi] : ERROR: syntax e...
by CBoekhuis
Thu Aug 20, 2020 9:47 am
Forum: Nagios XI
Topic: SQL Error [nagiosxi] : ERROR: syntax error at or near
Replies: 17
Views: 2358

Re: SQL Error [nagiosxi] : ERROR: syntax error at or near

Hi , aaply runs as usual. +/- 7-20 sec. After that the mysql process keeps running at 100-120 % for about +/- 5 minutes.
by CBoekhuis
Thu Aug 20, 2020 9:22 am
Forum: Nagios XI
Topic: SQL Error [nagiosxi] : ERROR: syntax error at or near
Replies: 17
Views: 2358

Re: SQL Error [nagiosxi] : ERROR: syntax error at or near

Hi, value changed from 128M ==> 1024M nagios1:nagios:/usr/local/nagiosxi/scripts> time ./reconfigure_nagios.sh --- reset_config_perms.sh ------------ > Setting script permissions > Setting CCM script permissions > Setting special script permissions > Setting special component script permissions > Se...
by CBoekhuis
Wed Aug 19, 2020 5:45 pm
Forum: Nagios XI
Topic: SQL Error [nagiosxi] : ERROR: syntax error at or near
Replies: 17
Views: 2358

Re: SQL Error [nagiosxi] : ERROR: syntax error at or near

OK. Is this issue also causing the high cpu consuming mysql process when applying configuration?
by CBoekhuis
Wed Aug 19, 2020 2:50 pm
Forum: Nagios XI
Topic: Service check very sloowly updated
Replies: 7
Views: 1032

Re: Service check very sloowly updated

PM with attachment send
by CBoekhuis
Wed Aug 19, 2020 9:45 am
Forum: Nagios XI
Topic: SQL Error [nagiosxi] : ERROR: syntax error at or near
Replies: 17
Views: 2358

Re: SQL Error [nagiosxi] : ERROR: syntax error at or near

nagios1_postgresql-Wed.log nagios1_postgresql-Wed.log nagios1:root:/var/lib> psql -V psql (PostgreSQL) 8.4.20 contains support for command-line editing nagios1:root:/var/lib> echo "\dt+;"|psql nagiosxi nagiosxi List of relations Schema | Name | Type | Owner | Size | Description --------+-...
by CBoekhuis
Tue Aug 18, 2020 5:12 pm
Forum: Nagios XI
Topic: SQL Error [nagiosxi] : ERROR: syntax error at or near
Replies: 17
Views: 2358

Re: SQL Error [nagiosxi] : ERROR: syntax error at or near

Porfile sended in PM.

This issue maybe related to our other open thread.
by CBoekhuis
Tue Aug 18, 2020 2:49 pm
Forum: Nagios XI
Topic: Service check very sloowly updated
Replies: 7
Views: 1032

Re: Service check very sloowly updated

Requested files send in PM's.

I've also posted another issue reguarding a SQL error . Maybe the issues are related
by CBoekhuis
Tue Aug 18, 2020 3:47 am
Forum: Nagios XI
Topic: SQL Error [nagiosxi] : ERROR: syntax error at or near
Replies: 17
Views: 2358

SQL Error [nagiosxi] : ERROR: syntax error at or near

We upgraded last vriday from 5.6.14 to 5.7.2 and got many issues. The service and host not showing up was fixed after a ticket, and i managed to resolve the "nagiosim.inc.php on line 491" messages , but we keep performance issues. While i was investigating nagiosxi poor performance that oc...
by CBoekhuis
Mon Aug 17, 2020 9:01 am
Forum: Nagios XI
Topic: Service check very sloowly updated
Replies: 7
Views: 1032

Service check very sloowly updated

After upgrade from 5.6.14 to 5.7.2 we see some unwanted behavior. Example : I've enabled a service check created a few weeks ago , end Apply configuration. The check showed up after minutes (normally a few seconds) and showed a Duration of 18xxx : 1-1-1970. Also running a manual Force check took 5-1...