[ZBX-5791] auto registration failed with oracle error Created: 2012 Nov 02  Updated: 2017 May 30  Resolved: 2012 Nov 05

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Server (S)
Affects Version/s: 2.0.2
Fix Version/s: 2.0.4rc1, 2.1.0

Type: Incident report Priority: Major
Reporter: matthias zeilinger Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: autoregistration, oracle, server
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

zabbix server 2.0.2, agent 1.4.6, oracle db 11.2


 Description   

during the auto registration of a host with add host to group operation i get a error in the server log:
1895:20121102:124654.802 [Z3005] query failed: [-1] ORA-06550: line 4, column 1:
PLS-00103: Encountered the symbol "INSERT" [begin
insert into hosts_groups (hostgroupid,hostid,groupid) values (271,10217,8);
end;
insert into hosts_groups (hostgroupid,hostid,groupid) values (272,10217,14);
end;
]

the host won´t add to the configured groups
only the add host operation works and zabbix server adds host to discovered hosts group

 Comments   
Comment by matthias zeilinger [ 2012 Nov 02 ]

update:
it works if i add the host only to one group.
adding to multiple groups doesn´t work

Comment by matthias zeilinger [ 2012 Nov 02 ]

another update:
it works also if i define 2 seperate autoregistrations.
one for each host group

this issue can be set to a lower priority

Comment by Alexander Vladishev [ 2012 Nov 05 ]

Fixed in the development branch svn://svn.zabbix.com/branches/dev/ZBX-5791

Comment by dimir [ 2012 Nov 12 ]

Successfully tested! The problem was that transaction was ended inside the loop where insert queries were created. The fix is put transaction-closing tag outside loop.

Comment by Alexander Vladishev [ 2012 Nov 13 ]

Fixed in pre-2.0.4 r31398 and pre-2.1.0 (trunk) r31399.

Generated at Thu May 09 01:46:56 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.