Ad Widget

Collapse

1.4.1 zabbix server log help

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • BusteR81
    Senior Member
    • Apr 2007
    • 150

    #1

    1.4.1 zabbix server log help

    3760:20070814:110701 Executing housekeeper

    3760:20070814:110748 Deleted 23840 records from history and trends

    3748:20070814:110819 Query failed: [insert into history_uint (clock,itemid,value) values (1187060847,18776,1990156288)] Lock wait timeout exceeded; try restarting transaction [1205]

    3749:20070814:110820 Query failed: [insert into history (clock,itemid,value) values (1187060848,18767,1.300000)] Lock wait timeout exceeded; try restarting transaction [1205]

    3750:20070814:110821 Query failed: [insert into history_uint (clock,itemid,value) values (1187060849,18778,3267698688)] Lock wait timeout exceeded; try restarting transaction [1205]

    Q) what does 3750:20070814:110821 Query failed: [insert into history_uint (clock,itemid,value) values (1187060849,18778,3267698688)] Lock wait timeout exceeded; try restarting transaction [1205] means ??

    Cheers
    Mysql CentOS
  • Alexei
    Founder, CEO
    Zabbix Certified Trainer
    Zabbix Certified SpecialistZabbix Certified Professional
    • Sep 2004
    • 5654

    #2
    ZABBIX housekeeper deleted records within a single transation. It is changed in pre 1.4.2. May I ask you to try pre 1.4.2?
    Alexei Vladishev
    Creator of Zabbix, Product manager
    New York | Tokyo | Riga
    My Twitter

    Comment

    Working...