Ad Widget

Collapse

Zabbix-1.6.4 query failed

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • xs-
    Senior Member
    Zabbix Certified Specialist
    • Dec 2007
    • 393

    #1

    Zabbix-1.6.4 query failed

    Hi all,

    Zabbix-1.6.4
    Mysql-5.0
    Ubuntu-8.04TLS

    2 zabbix servers in DM mode (slave --> master)
    Master (receiving side) is sometimes showing the following query errors:

    17829:20090407:113612 [Z3005] Query failed: [1110] Column 'hostid' specified twice [insert into hosts_profiles_ext (hostid,hostid) values (100100000010032,100100000010032)]
    17829:20090407:113613 [Z3005] Query failed: [1110] Column 'hostid' specified twice [insert into hosts_profiles_ext (hostid,hostid) values (100100000010033,100100000010033)]
    17829:20090407:113613 [Z3005] Query failed: [1110] Column 'hostid' specified twice [insert into hosts_profiles_ext (hostid,hostid) values (100100000010728,100100000010728)]
    17829:20090407:113613 [Z3005] Query failed: [1110] Column 'hostid' specified twice [insert into hosts_profiles_ext (hostid,hostid) values (100100000010733,100100000010733)]
    17829:20090407:113614 [Z3005] Query failed: [1110] Column 'hostid' specified twice [insert into hosts_profiles_ext (hostid,hostid) values (100100000010741,100100000010741)]
    17829:20090407:113614 [Z3005] Query failed: [1110] Column 'hostid' specified twice [insert into hosts_profiles_ext (hostid,hostid) values (100100000010767,100100000010767)]
    17829:20090407:113615 [Z3005] Query failed: [1110] Column 'hostid' specified twice [insert into hosts_profiles_ext (hostid,hostid) values (100100000010768,100100000010768)]
    17829:20090407:113616 [Z3005] Query failed: [1110] Column 'hostid' specified twice [insert into hosts_profiles_ext (hostid,hostid) values (100100000010826,100100000010826)]
    17829:20090407:113616 [Z3005] Query failed: [1110] Column 'hostid' specified twice [insert into hosts_profiles_ext (hostid,hostid) values (100100000010827,100100000010827)]
    17829:20090407:113616 [Z3005] Query failed: [1110] Column 'hostid' specified twice [insert into hosts_profiles_ext (hostid,hostid) values (100100000010828,100100000010828)]
  • Alexei
    Founder, CEO
    Zabbix Certified Trainer
    Zabbix Certified SpecialistZabbix Certified Professional
    • Sep 2004
    • 5654

    #2
    Do both servers run 1.6.4?
    Alexei Vladishev
    Creator of Zabbix, Product manager
    New York | Tokyo | Riga
    My Twitter

    Comment

    • xs-
      Senior Member
      Zabbix Certified Specialist
      • Dec 2007
      • 393

      #3
      ouch, you got me there.
      i still need to upgrade the slave. Ill report my findings in a couple of hours.

      Comment

      • xs-
        Senior Member
        Zabbix Certified Specialist
        • Dec 2007
        • 393

        #4
        yes all servers are running exactly the same version

        Comment

        Working...