Maintenance deleted, Hosts still in State "In Maintenance"

[ira]

Hello all,

I use Zabbix 1.8.5 on Debian Squeeze.
I created a maintenace window for 2 hours. But then I didn't need it and I deleted the maintenance.
My Problem ist, that now after the maintenance window should be over the machines are still in the State "In Maintenance" and I can't get them to state "Monitored".

I looked in the DB, but still don't habe any idea, how to get rid off the maintenance... Please help!
In Table hosts there are values from the deleted maintenance, for exmaple maintenanceid 17 and maintenance_status 1.
Should I simply change them to 0?

Greetings
Ira

[ira]

Hello all,

In Table hosts there are values from the deleted maintenance, for exmaple maintenanceid 17 and maintenance_status 1.
Should I simply change them to 0?

Well for the folks with the same problem, I found that the deleted maintenance id is 17. Then made the following statement:
update hosts set maintenanceid=0, maintenance_status=0, maintenance_from=0 where maintenanceid=17;

It looks like that the problem is solved. If somebody hat a better solution, pls telle me.

Greetings
Ira

[qix]

Ira,

This sounds like a bug to me...could you go to https://support.zabbix.com and file a bug report (if this wasn't done yet).

Thanks!

[ira]

Hi,
I created a report:

https://support.zabbix.com/browse/ZBX-4227

Have a nice day!
Ira

[simon123]

Same over here

Hi,
I created a report:

https://support.zabbix.com/browse/ZBX-4227

Have a nice day!
Ira

Had a same issue over here, also fixed it with some mysql queries.
The status of your report indicates an issue status of "wontfix". Does this mean this is default behaviour for Zabbix???

Or is the solution, restarting the timer process of your zabbix server?

[qix]

See https://support.zabbix.com/browse/ZBX-4233

(Thanks Richlv)