[ZBX-4141] database is down - duplicate entry Created: 2011 Sep 13  Updated: 2017 May 30  Resolved: 2011 Sep 13

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

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


 Description   

a history syncer process has stuck in a loop :

11431:20110913:105719.952 Database is down. Retrying in 10 seconds.
11431:20110913:105729.958 [Z3005] query failed: [1062] Duplicate entry '23099-1315738800' for key 1 [insert into trends (itemid,clock,num,value_min,value_avg,value_max) values (23099,1315738800,1,3.400000,3.400000,3.400000);]

 Comments   
Comment by Alexander Vladishev [ 2011 Sep 13 ]

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

Comment by dimir [ 2011 Sep 13 ]

(1) sasha, what do you think of my changes in 21639:

  • define 10 seconds to wait when DB is down
  • add helper function for transaction operation to get rid of duplicated code

Other than that your fix looks good.

<sasha> excellent changes! Please review my fix.

<dimir> The fix is good. As we agreed also renamed zbx_db_txn_operation() -> DBtxn_operation() . CLOSED

Comment by Alexander Vladishev [ 2011 Sep 14 ]

Fixed in version pre1.8.8, r21656.

Generated at Fri Apr 26 00:58:32 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.