Recovery Problem

[matuzalem]

Friends,
My zabbix (1.8.10) is not performing the action for recovery. When the server presents a problem (simple check or trigger), I get the notification PROBLEM but when the server returns, do not get the recovery. The log can not see the problem. This marked the flag message of recovery(in action). What should I do? any ideas?

Thank you!

[ssaju2012]

security forum, security system help

Security alarm is on of the most important thing in our modern life or also
it,s very much helpful.It's Very Important in our daily life.
i would like to know what hardware can i use or attach to my 3com 3040 adsl internet router to
block websites and to balance the internet load bandwith on web apps,
outlook pop imap emails etc.
security forum
security system help

[igorsh]

I have same problem on zabbix 1.8.7 and it begins only week ago.
Before 21 march everything works on same zabbix version, same database and same server.
I try to add in actions condition Trigger value = "PROBLEM" but it not help.
Then I try to clear table escalations in database (according to www.zabbix.com/forum/showthread.php?t=22382 )

[igorsh]

...and clearing table doesn't help too

[igorsh]

Today I update zabbix-server to 1.8.10 and it fixed generating of recovery messages

[igorsh]

Today I update zabbix-server to 1.8.10 and it fixed generating of recovery messages

and it not fixed problem, it was just short time without problem.
But today I find source of problem and fix it for sure.

[igorsh]

What it was in my case.
After some other problems (deadlocks, problem with database migration or zabbix-server updates) primary keys has been lost from table ids.
Without primary keys some duplicate entries was created in this table and 4 entries with nextid for table events.
When new events was created, ids was randomly taken from different duplicate entries. Because this randomness sometimes event for recovery has lesser id than event for problem and it looks like recovery was before problem, so action for recovery didn't generate.
I delete duplicate rows from table ids and recreate primary keys for this table.
Now for 4 hours I watch for events and recovery actions has been performed for all of them.