[ZBX-5919] Autocommit is enabled for execute/select queries on Oracle database Created: 2012 Nov 30 Updated: 2017 May 30 Resolved: 2012 Dec 10 |
|
Status: | Closed |
Project: | ZABBIX BUGS AND ISSUES |
Component/s: | Server (S) |
Affects Version/s: | 2.0.4rc1, 2.1.0 |
Fix Version/s: | 2.0.5rc1, 2.1.0 |
Type: | Incident report | Priority: | Critical |
Reporter: | Alexey Pustovalov | Assignee: | Unassigned |
Resolution: | Fixed | Votes: | 0 |
Labels: | oracle | ||
Remaining Estimate: | Not Specified | ||
Time Spent: | Not Specified | ||
Original Estimate: | Not Specified |
Issue Links: |
|
Description |
We should not do autocommit for select/execute queries which in a transaction. |
Comments |
Comment by Alexey Pustovalov [ 2012 Nov 30 ] |
Sometimes Zabbix has not time to increment events.eventid counter in ids table because History syncers processes have concurrent statements to ids table (events.eventid row). |
Comment by Alexander Vladishev [ 2012 Dec 10 ] |
Fixed in the development branch svn://svn.zabbix.com/branches/dev/ZBX-5919 |
Comment by Alexander Vladishev [ 2012 Dec 10 ] |
Fixed in versions pre-2.0.5 r32017 and pre-2.1.0 (trunk) r32018. |