Ad Widget

Collapse

Upgrade Error from 1.1.6 to 1.4.1

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • 753713
    Senior Member
    • Apr 2006
    • 137

    #1

    Upgrade Error from 1.1.6 to 1.4.1

    Hi,
    I cannot patch the mysql Database from Version 1.1.6 to 1.4.1

    ERROR:

    cat patch.sql |mysql zabbix -uroot -pXXXXXX
    ERROR 1050 (42S01) at line 16: Table 'actions_tmp' already exists

    Christian
    ______________________________
    Version : 2.0.x
    Server OS: Ubuntu 12.04
    Zabbix Servers: 12
    Monitored Windows Server: ~ 1000
    ______________________________
  • Alexei
    Founder, CEO
    Zabbix Certified Trainer
    Zabbix Certified SpecialistZabbix Certified Professional
    • Sep 2004
    • 5654

    #2
    Drop actions_tmp if you don't require it. It is not part of ZABBIX schema!
    Alexei Vladishev
    Creator of Zabbix, Product manager
    New York | Tokyo | Riga
    My Twitter

    Comment

    • 753713
      Senior Member
      • Apr 2006
      • 137

      #3
      hmm,

      after Drop actions_tmp the actions table, I become this errors:
      ERROR 1050 (42S01) at line 25: Table 'operations' already exists

      ERROR 1050 (42S01) at line 128: Table 'dchecks' already exists

      I´m drop the operetions and dcchecks Tables, this has no effect.

      Christian
      ______________________________
      Version : 2.0.x
      Server OS: Ubuntu 12.04
      Zabbix Servers: 12
      Monitored Windows Server: ~ 1000
      ______________________________

      Comment

      • Speedfight
        Member
        • May 2007
        • 67

        #4
        same problem here..

        i am upgrading from 1.4 to 1.4.1

        is there a solution for this problem?
        Last edited by Speedfight; 04-07-2007, 15:36.

        Comment

        • predatorz
          Senior Member
          • Mar 2007
          • 109

          #5
          Originally posted by Speedfight
          same problem here..

          i am upgrading from 1.4 to 1.4.1

          is there a solution for this problem?
          No need for upgrade of db from 1.4 to 1.4.1, just recompile zabbix and copy the frontends

          Comment

          • Speedfight
            Member
            • May 2007
            • 67

            #6
            owkej.

            Thnx

            Comment

            Working...