I've encountered some strange issues with graph prototypes lately.
I'm using Zabbix 4.0.24 at the moment andi see the following erros in the server log:
I've checked the prototypes and even exported the tempalte to ensure that the values are ok.
It seems however the ymin , ymax as well as the percent_left and percent_right values are inserted as "100,0" insted of "100.0" . Strangly however the prototypes of the template have the right values in the graphs table.
Can someone mybe give me a hint where the ssystem ist going wrong here.
A manual created graph shows no issues.
Kind regards
Jacob
I'm using Zabbix 4.0.24 at the moment andi see the following erros in the server log:
Code:
[FONT=monospace][COLOR=#000000]4743:20201113:111414.877 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: INSERT has more expressions than target columns [/COLOR]
LINE 1: ...0,000000,100,000000,0,0,0,1,0,0,000000,0,000000 ,0,null,0,nul...
^
[insert into graphs (graphid,name,width,height,yaxismin,yaxismax,show_ work_period,show_triggers,graphtype,show_legend,sh ow_3d,percent_left,percent_right,ymin_type,ymin_it emid,ymax_type,ymax_itemid,flags) values (7835,'Disk space usage /',600,340,0,000000,100,0000
00,0,0,0,1,0,0,000000,0,000000,0,null,0,null,4),(7 836,'Disk space usage /opt',600,340,0,000000,100,000000,0,0,0,1,0,0,00000 0,0,000000,0,null,0,null,4),(7837,'Disk space usage /var',600,340,0,000000,100,000000,0,0,0,1,0,0,00000 0,0,000000,0,null,0,null,4),(7838,'Dis
k space usage /home',600,340,0,000000,100,000000,0,0,0,1,0,0,0000 00,0,000000,0,null,0,null,4),(7839,'Disk space usage /srv',600,340,0,000000,100,000000,0,0,0,1,0,0,00000 0,0,000000,0,null,0,null,4);[/FONT]
It seems however the ymin , ymax as well as the percent_left and percent_right values are inserted as "100,0" insted of "100.0" . Strangly however the prototypes of the template have the right values in the graphs table.
Can someone mybe give me a hint where the ssystem ist going wrong here.
A manual created graph shows no issues.
Kind regards
Jacob