External script timing out (Zabbix 3.4)

[lpossamai]

Hi all,

I've got a Zabbix Server and a Zabbix Proxy (which is in another country). They both connect to each other via a Site-to-Site VPN.
I am monitoring my Oracle DB in the same country as my Zabbix Proxy by running a couple of scripts. I am running the scripts against my Master and Standby Oracle DB

Monitoring my Oracle Master DB with: au_check_replication_master.sh
Monitoring my Oracle Slave DB with: au_check_replication_slave.sh

The problem is that I am getting same

error: Timeout while executing a shell script

errors, and that only happens for the Standby DB, not for the master.

A couple more information:

Note:

 db2:archivelog_gap

is a calculated item using both

db2:au_check_replication_slave.sh

and

db2:au_check_replication_master.sh

From my Zabbix Server logs:

22820:20180627:165641.375 value:0 state:1 error:'Cannot evaluate expression: "Cannot evaluate function "db2:archivelog_gap.min(10m)": item is not supported.".' lastchange:0
22850:20180627:165653.539 item [db2:au_check_replication_slave.sh] error: Timeout while executing a shell script.
22830:20180627:165653.681 item "db2:au_check_replication_slave.sh" became not supported: Timeout while executing a shell script.

From my Zabbix Proxy:
I don't see any errors, even increasing the Level Log.

From my Oracle Slave DB:
I don't see any errors on the Zabbix Agent.

What could be causing the Script to timeout? Where do I begin to investigate this?
Thanks in advance!

[kernbug]

Hi all,

What could be causing the Script to timeout? Where do I begin to investigate this?
Thanks in advance!

Hi
How long does it take to accomplish the task on slave server? You can adjust timeout in the Zabbix Agent configuration file.

[lpossamai]

Hi
How long does it take to accomplish the task on slave server? You can adjust timeout in the Zabbix Agent configuration file.

umm... it was the default (3 sec)... I've increased it.. will monitor. Cheers!

[lpossamai]

Hi
How long does it take to accomplish the task on slave server? You can adjust timeout in the Zabbix Agent configuration file.

Hi... Still getting the same error... Increased the timeout to 1 minute and it did not help... Any other ideas?
Cheers

[kernbug]

Hi... Still getting the same error... Increased the timeout to 1 minute and it did not help... Any other ideas?
Cheers

Check execution time of the script from the zabbix user with sudo.

[lpossamai]

Check execution time of the script from the zabbix user with sudo.

That Oracle DB server was up for 5 years straight.. I have rebooted it now.. Will monitor... it was indeed taking sometime to connect to the Oracle Listener. Will update this post soon.

[lpossamai]

An UPDATE here:

I rebooted the Oracle DB server, which I was running the script against to, and it looks like it has fixed the problem... The server was up for 5 years and maybe there was some issue there... I think this is fixed now. No more errors. Thanks for all the help!

[elisawise]

An UPDATE here:

I rebooted the Oracle DB server, which I was running the script against to, and it looks like it has fixed the problem... The server was up for 5 years and maybe there was some issue there... I think this is fixed now. No more errors. Thanks for all the help!

I've increased it.. will monitor. geometry dash

[topiktcom]

An UPDATE here:

I rebooted the Oracle DB server, which I was running the script against to, and it looks like it has fixed the problem... The server was up for 5 years and maybe there was some issue there... I think this is fixed now. No more errors. Thanks for all the help!

Well this worked for me too. Thanks for sharing the solution.