[ZBX-2441] Incorrect handling of begin/commit/rollback statements if SQL server becomes unavailable Created: 2010 May 19  Updated: 2017 May 30  Resolved: 2010 Jun 17

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Proxy (P), Server (S)
Affects Version/s: 1.8.2
Fix Version/s: 1.8.3

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


 Description   

begin/commit/rollback statements ignored if SQL server becomes unavailable

27268:20100519:030022.105 [Z3005] Query failed: [2006] MySQL server has gone away [begin;]
27268:20100519:030022.105 [Z3005] Query failed: [2006] MySQL server has gone away [update hosts set error='Get value from agent failed: *** C
annot connect to [192.168.0.155]:15001 [Interrupted system call]',disable_until=1274227282 where hostid=10017]
27268:20100519:030022.105 Database is down. Retrying in 10 seconds

 Comments   
Comment by Alexander Vladishev [ 2010 May 26 ]

Fixed in ver. pre1.8.3, r12260.

Comment by Alexander Vladishev [ 2010 Jun 17 ]

Crash detected, when using SQLite3 DB engine:

31052:20100617:145553.796 server #15 started [Discoverer. SNMP:YES]
13562:20100617:145556.225 ERROR: nested transaction detected. Please report it to Zabbix Team.
assertion "0" failed: file "db.c", line 411, function "zbx_db_begin"
19653:20100617:145556.229 One child process died (PID:0,exitcode/signal:0). Exiting ...
7332:20100617:145556.229 Got signal [signal:15(SIGTERM),sender_pid:0,sender_uid:0,reason:0]. Exiting ...
30591:20100617:145556.234 Got signal [signal:15(SIGTERM),sender_pid:0,sender_uid:0,reason:0]. Exiting ...
17331:20100617:145556.235 Got signal [signal:15(SIGTERM),sender_pid:0,sender_uid:0,reason:0]. Exiting ...
2667:20100617:145556.243 Got signal [signal:15(SIGTERM),sender_pid:0,sender_uid:0,reason:0]. Exiting ...
14013:20100617:145556.247 Got signal [signal:15(SIGTERM),sender_pid:0,sender_uid:0,reason:0]. Exiting ...
900:20100617:145556.252 Got signal [signal:15(SIGTERM),sender_pid:0,sender_uid:0,reason:0]. Exiting ...
18853:20100617:145556.257 Got signal [signal:15(SIGTERM),sender_pid:0,sender_uid:0,reason:0]. Exiting ...
23083:20100617:145556.262 Got signal [signal:15(SIGTERM),sender_pid:0,sender_uid:0,reason:0]. Exiting ...
2165:20100617:145556.267 Got signal [signal:15(SIGTERM),sender_pid:0,sender_uid:0,reason:0]. Exiting ...
29320:20100617:145556.272 Got signal [signal:15(SIGTERM),sender_pid:0,sender_uid:0,reason:0]. Exiting ...

Comment by Alexander Vladishev [ 2010 Jun 17 ]

Fixed in ver. pre1.8.3, revision 12875

Generated at Sun Apr 05 03:27:59 EEST 2026 using Jira 10.3.18#10030018-sha1:5642e4ad348b6c2a83ebdba689d04763a2393cab.