Ad Widget

Collapse

Mysql DB upgrade Error from 1.1.x to 1.4

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ralphmyers
    Junior Member
    • Mar 2007
    • 5

    #1

    Mysql DB upgrade Error from 1.1.x to 1.4

    When I attempt to upgrade the zabbix DB to 1.4 I get the following error:
    ERROR 1062 (23000) at line 125: Duplicate entry '1' for key 1

    I am most likely not patching the db correctly so if someone has the command to do so that would be great. Here is the command that I have been using:
    cat patch.sql |mysql zabbix -u [USERNAME] -p

    The user has full access to the database, so I dont think its a permissions issue.

    Thanks
    R.Myers
  • Alexei
    Founder, CEO
    Zabbix Certified Trainer
    Zabbix Certified SpecialistZabbix Certified Professional
    • Sep 2004
    • 5654

    #2
    It seems that you have more than one record in table 'config'. This shouldn't happen. You may safely leave only one record in the table and re-run upgrade script.
    Alexei Vladishev
    Creator of Zabbix, Product manager
    New York | Tokyo | Riga
    My Twitter

    Comment

    • ralphmyers
      Junior Member
      • Mar 2007
      • 5

      #3
      That did it. Thanks!

      Comment

      Working...