-
Incident report
-
Resolution: Won't fix
-
Minor
-
None
-
1.8.13, 2.2.1
There are maintenance periods in the DB that cannot be found in the front end.
Unfortunately I cannot reproduce issue. The problem occurs when I wanted to create new maintenance period and I got error message: "Maintenance [ test ] already exists". There is no "test" in the maintenance periods list in the front end. I am logged in as "Zabbix Super Admin".
DB:
select * from maintenances; +---------------+-----------------------------------+------------------+--------------------------------------------------------------------------------------------+--------------+-------------+ | maintenanceid | name | maintenance_type | description | active_since | active_till | +---------------+-----------------------------------+------------------+--------------------------------------------------------------------------------------------+--------------+-------------+ | 528 | wylaczenie na czas akcji z db8 | 0 | | 1304328469 | 1304414869 | | 686 | migracja | 0 | | 1314227700 | 1314314100 | | 793 | Hosting Windows +LAN Szn - updaty | 0 | cykliczny maintenance dla update'ow + restartow maszyn na hostingu windows + LAN SZCZECIN | 1321346100 | 1356994740 | | 975 | sb02 php5 | 0 | | 1335741720 | 1430436120 | | 1028 | ZU-23220 | 0 | | 1340631420 | 1340717820 | | 1091 | test | 0 | | 1346417760 | 1346504160 | | 1115 | migracja DC | 0 | | 1349297100 | 1349469900 | +---------------+-----------------------------------+------------------+--------------------------------------------------------------------------------------------+--------------+-------------+
How can I remove this ghost maintenance periods, is it enough to delete it from `maintenances` table?