Database alert not working

[ranjan0705]

I am using Zabbix 2.4.2.

I have a database alert setup and it was working properly from past many years. But suddenly it stopped working. I have checked the latest data screen, there I am getting value for this item but the alert is not showing up in the screen.
Rest of the alerts set up in the same database is working fine. I have restated the zabbix and orabbix services both but its not working.

Please help and let me know if any other information is needed.

[ranjan0705]

Please any help me to solve this problem.

[asteroidyorkton]

What do you see in Monitoring -> Events (Select your server in dropdown).
Select 1d or 3days

Does it show email has been sent in Actions? Any numbers? Or nothing? attach screenshot.

If nothing then means there was no action to send. Double check Configuration -> Actions (Triggers Dropdown menu), see if you're filtering this alert out ?

Also check Monitoring -> Triggers, see if it triggered first. Check Host -> Triggers see if any errors for its trigger.

Check also if the user who is not getting alert has permission to the Database host group in zabiix

[Semiadmin]

Hi! When you checked the latest data screen for this item, what you saw in column "last check"? Orabbix items are "zabbix trapper" items, and there is straight line instead of spaces on graf, if you haven't new data. If your data are outdated, check logs of Orabbix.

[tritsako]

Database alert not working

Hello,

you can also check if you are getting data from "Monitor / last data" from your items.

Costas

[ranjan0705]

Hi All,

Thanks for the reply. I will answer to everyone.

First I checked, monitoring -> Latest data. Here I chose server and checked the item. It was showing the data for past few days.

Then I checked, monitoring -> Triggers. I can see this trigger here.
I can't even see in monitoring-> events.
even in Configuration -> Actions, all looks fine, there is no filtering this alert out

Since mail is setup for this alert, I have received a mail on 5th July and also on 1st August.

below is the configuration used in trigger:
NAME:- Transactions have a status of queued for the last 30 mins -File Name={ITEM.LASTVALUE}
EXPRESSION:- {Template Oracle-OCXP:queued_status.str(none)}=0

Below is the configuration used in the props file:

queued_status.Query=select file_name||',' from tableA where processing_status='QUEUED' and Message_type not like 'MANDATE_INITIATION' and generation_type='IMPORT' and Create_Date > sysdate -1
queued_status.NoDataFound=none
queued_status.Period=5

Thanks

[ranjan0705]

Guys, sorry for delayed response.
Please help me to find out the issue.

Thanks

[yokesh]

Hello,
I have installed orabbix 1.2.3 to monitor Oracle 12.1 and i am using zabbix5.
i am getting the below details on orabbix.log file

2020-07-30 10:39:38,971 [pool-1-thread-3] DEBUG Orabbix - dbname orcl121 sending item waits_multiblock_read value 5261
2020-07-30 10:39:38,971 [pool-1-thread-3] DEBUG Orabbix - dbname orcl121 sending item waits_singleblock_read value 5143436
2020-07-30 10:39:38,971 [pool-1-thread-3] DEBUG Orabbix - dbname orcl121 sending item hitratio_trigger value 99.74508355594555118044640923252933760601
2020-07-30 10:39:38,971 [pool-1-thread-3] DEBUG Orabbix - dbname orcl121 sending item lio_block_changes value 128556344
2020-07-30 10:39:38,971 [pool-1-thread-3] DEBUG Orabbix - dbname orcl121 sending item lio_consistent_read value 2535723157
2020-07-30 10:39:38,971 [pool-1-thread-3] DEBUG Orabbix - dbname orcl121 sending item waits_other value 101904381
2020-07-30 10:39:38,971 [pool-1-thread-3] DEBUG Orabbix - dbname orcl121 sending item waits_sqlnet value 10057787
2020-07-30 10:39:38,971 [pool-1-thread-3] DEBUG Orabbix - dbname orcl121 sending item users_locked value none
2020-07-30 10:39:38,971 [pool-1-thread-3] DEBUG Orabbix - dbname orcl121 sending item uptime value 6772117

post this i am getting the below error on orabbix.log file.

2020-07-30 10:39:38,973 [pool-1-thread-3] WARN Orabbix - received unexpected response '' for key 'alive'
2020-07-30 10:39:38,973 [pool-1-thread-3] DEBUG Orabbix - sending <req><host>b3JjbDEyMQ==</host><key>T3JhYmJpeC5WZXJzaW9u</key><data>T3JhYmJpeCBWZXJzaW9uIDEuMi4zIA==</data></req>
2020-07-30 10:39:38,974 [pool-1-thread-3] DEBUG Orabbix - received
2020-07-30 10:39:38,974 [pool-1-thread-3] WARN Orabbix - received unexpected response '' for key 'Orabbix.Version'
2020-07-30 10:39:38,974 [pool-1-thread-3] DEBUG Orabbix - sending <req><host>b3JjbDEyMQ==</host><key>ZGF0ZXRpbWU=</key><data>MDctMzAtMjAyMCAxMDo0MToxNw==</data></req>
2020-07-30 10:39:38,974 [pool-1-thread-3] DEBUG Orabbix - received
2020-07-30 10:39:38,975 [pool-1-thread-3] WARN Orabbix - received unexpected response '' for key 'datetime'

can you kindly help ?