[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. |