[ZBX-8700] Frontend can pass empty itemids array to get_min_itemclock_by_itemid function Created: 2014 Sep 02 Updated: 2017 May 30 Resolved: 2014 Sep 05 |
|
| Status: | Closed |
| Project: | ZABBIX BUGS AND ISSUES |
| Component/s: | Frontend (F) |
| Affects Version/s: | 2.2.6 |
| Fix Version/s: | 2.2.7rc1, 2.4.0rc1 |
| Type: | Incident report | Priority: | Major |
| Reporter: | Alexey Pustovalov | Assignee: | Unassigned |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | query | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||
| Description |
|
Sometimes Zabbix can generate queries like: STATEMENT: SELECT i.itemid,i.value_type FROM items i WHERE ERROR: syntax error at end of input at character 49 STATEMENT: SELECT i.itemid,i.value_type FROM items i WHERE ERROR: syntax error at end of input at character 49 STATEMENT: SELECT i.itemid,i.value_type FROM items i WHERE ERROR: syntax error at end of input at character 49 It can happen in get_min_itemclock_by_itemid function. |
| Comments |
| Comment by Oleg Egorov (Inactive) [ 2014 Sep 03 ] |
|
(1) No string changes asaveljevs CLOSED. |
| Comment by Oleg Egorov (Inactive) [ 2014 Sep 04 ] |
|
FIXED IN svn://svn.zabbix.com/branches/dev/ZBX-8700 r48753 |
| Comment by Aleksandrs Saveljevs [ 2014 Sep 04 ] |
|
It seems that the problem manifests itself only in case a Web scenario does not have any steps, or a step does not have associated items. So it should not happen under normal conditions. However, there is still a bug that $itemIds array only contains item IDs for the Web scenario step that was processed last, rather than all Web scenario items. This is what will be fixed under this issue. |
| Comment by Aleksandrs Saveljevs [ 2014 Sep 04 ] |
|
(2) It should probably be fixed for 2.0, too. oleg.egorov RESOLVED IN r48792 asaveljevs CLOSED |
| Comment by Oleg Egorov (Inactive) [ 2014 Sep 05 ] |
|
Reproduce this SQL error possible if with API remove web steps from web scenario asaveljevs So API does not validate the case where a Web scenario would be left without the steps? |
| Comment by Oleg Egorov (Inactive) [ 2014 Sep 15 ] |
|
FIXED IN 2.0.14rc1 r48975, Changes for 2.2.7rc1 rr48976, 2.4.1rc1 r48980, 2.5.0 r48981 |