[ZBX-2282] Failed query for Oracle "dublicate column name" Created: 2010 Apr 06  Updated: 2023 Nov 08  Resolved: 2010 May 10

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Server (S)
Affects Version/s: 1.8.4
Fix Version/s: 1.8.3

Type: Incident report Priority: Major
Reporter: Alexey Pustovalov Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Oracle 10g2, trunk zabbix_server


 Description   

26046:20100405:222915.420 [Z3005] Query failed: [-1] ORA-06550: line 2, column 47:
PL/SQL: ORA-00957: duplicate column name
ORA-06550: line 2, column 1:
PL/SQL: SQL Statement ignored
[begin
update hosts set available=0,snmp_available=0,snmp_available=0,error='',snmp_error='',ipmi_error='' where hostid=28408;
end;
]

 Comments   
Comment by Alexey Pustovalov [ 2010 Apr 21 ]

in src/zabbix_server/trapper/proxyhosts.c:

if (SUCCEED == zbx_json_value_by_name(&jp_row, ZBX_PROTO_TAG_SNMP_AVAILABLE, tmp, sizeof(tmp)))

{ zbx_snprintf_alloc(&sql, &sql_alloc, &sql_offset, 32, "snmp_available=%d,", atoi(tmp)); no_data = 0; }

if (SUCCEED == zbx_json_value_by_name(&jp_row, ZBX_PROTO_TAG_IPMI_AVAILABLE, tmp, sizeof(tmp)))
{ zbx_snprintf_alloc(&sql, &sql_alloc, &sql_offset, 32, "snmp_available=%d,", atoi(tmp)); no_data = 0; }

dublicate snmp_available.

Comment by Alexander Vladishev [ 2010 May 10 ]

Fixed in version pre1.8.3, r11874

Generated at Fri Apr 19 06:40:35 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.