[ZBX-7849] Can't update Action: Maintenance action condition value must be empty. Created: 2014 Feb 20  Updated: 2017 May 30  Resolved: 2014 Mar 06

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F), Server (S)
Affects Version/s: 2.2.2
Fix Version/s: 2.2.3rc1, 2.3.0

Type: Incident report Priority: Major
Reporter: Anton Samets Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: action, maintenance
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: PNG File Screen Shot 2014-02-20 at 23.24.54.png    

 Description   

I've tried to update some actions, adding more conditions, but right now I've got:
ERROR: Cannot add action condition
Maintenance action condition value must be empty.

Usual things for actions - using condition
Label Name Action
(A) Maintenance status not in maintenance

But right now frontend doesn't allow me to update action.

 Comments   
Comment by Ivo Kurzemnieks [ 2014 Feb 21 ]

Anton, have to upgraded ZABBIX from version 2.0.x to 2.2.x?
Seems like only way to reproduce the problem.
You can simply try to execute the following SQL: 

UPDATE conditions SET value='' WHERE conditiontype=16;
Comment by Anton Samets [ 2014 Feb 21 ]

Yes, we are upgraded to 2.2 from 2.0.
So, should I run this query on DB server?

Comment by Anton Samets [ 2014 Feb 21 ]

Yes, it solved the issue, thank you.
Is any notice was in documentation or release notes?

Comment by Ivo Kurzemnieks [ 2014 Feb 21 ]

It was decided not to make any additional patches, since table structure does not change and only incorrect data is beeing manipulated.
In version 2.0:

  • creating action with default conditions and with 'maintenance status', database saved empty value as it should.
  • there was a bug when removing existing table row 'maintenance status' and adding new row 'maintenance status', the value was made '0'. Which was wrong. But since 2.0 had no 'maintenance status' field validation it was not considered a bug.

Some time later we added 'maintenance status' field validation and now it doesn't accept previously created '0' values in that field. There should've been empty values for 'maintenance status' and so there's nothing really to add for documentation and release notes.

Comment by Anton Samets [ 2014 Feb 21 ]

Ok, thank you for information, I should believe that this issue can probably help another persons.

Comment by richlv [ 2014 Mar 03 ]

(1) "there was a bug when removing existing table row 'maintenance status' and adding new row 'maintenance status', the value was made '0'" - can you please point at the issue where this was handled ? we might have to at least document this in the troubleshooting section...

<richlv> so apparently... latest 2.0 code still writes invalid data (zeroes) in the database. after upgrade to 2.2, this results in errors.
let's add a dbpatch for this (i'm fine with not fixing the issue in 2.0, bet dbpatch is needed definitely)

Comment by Pavels Jelisejevs (Inactive) [ 2014 Mar 06 ]

This is caused by the fix made in ZBX-6808.

Comment by Pavels Jelisejevs (Inactive) [ 2014 Mar 06 ]

RESOLVED for:

  • 2.2 in svn://svn.zabbix.com/branches/dev/ZBX-7849
  • 2.3.0 in svn://svn.zabbix.com/branches/dev/ZBX-7849-trunk

sasha Successfully tested! CLOSED

Comment by Pavels Jelisejevs (Inactive) [ 2014 Mar 10 ]

Fixed in 2.2.3rc1 r43317 and 2.3.0 r43321.

CLOSED.

Generated at Fri Apr 26 13:24:36 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.