Ad Widget

Collapse

i have a problem with insert into history

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Shorty Guard
    Junior Member
    • Oct 2004
    • 12

    #1

    i have a problem with insert into history

    i changed timeout from 5 to 10 in zabbix_suckerd.conf, restart zabbix_suckerd and then had a log like:

    011719:20041021:133209 Query failed:Got error -1 from table handler [1030]
    011719:20041021:133210 Query::insert into history (clock,itemid,value) values (1098340330,17394,1838.506660)
    011719:20041021:133210 Query failed:Got error -1 from table handler [1030]
    011719:20041021:133210 Query::insert into history (clock,itemid,value) values (1098340330,17397,5.333330)
    011719:20041021:133210 Query failed:Got error -1 from table handler [1030]


    until restart it was all right
  • Alexei
    Founder, CEO
    Zabbix Certified Trainer
    Zabbix Certified SpecialistZabbix Certified Professional
    • Sep 2004
    • 5654

    #2
    It seems that you database is corrupted.

    Use "repair table <table>" statement to fix it.

    Proper system restart should never lead to problems with database corruption. You haven't pressed power-off button, have you?
    Alexei Vladishev
    Creator of Zabbix, Product manager
    New York | Tokyo | Riga
    My Twitter

    Comment

    • Shorty Guard
      Junior Member
      • Oct 2004
      • 12

      #3
      :-)

      THX, database was corrupted. Now, it's ok.

      P.S.
      i haven't pressed power-off button.

      P.P.S. Is there a way to make zabbix_agentd update configuration without restarting?

      Comment

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

        #4
        Originally posted by Shorty Guard
        Is there a way to make zabbix_agentd update configuration without restarting?
        No, it's no supported yet.
        Alexei Vladishev
        Creator of Zabbix, Product manager
        New York | Tokyo | Riga
        My Twitter

        Comment

        Working...