Ad Widget

Collapse

Zabbix Upgrade on Ubuntu 16.04.6 LTS from 4.2.8 to 5.0 LTS

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • vai
    Junior Member
    • Jan 2020
    • 12
    #1

    Zabbix Upgrade on Ubuntu 16.04.6 LTS from 4.2.8 to 5.0 LTS

    Hello,

    I would like to upgrade Zabbix Server from 4.2.8 to 5.0 LTS.

    Zabbix server 4.2.8 is running on Ubuntu 16.04.6. And In order to upgrade to 5.0 LTS, we need to upgrade OS to Ubuntu 18.04. However if we upgrade OS then it removes existing Zabbix Server 4.2.8.

    Can you please help me to address the issue in upgrading Zabbix server without loosing data?

    I have tested Zabbix DB backup & restore from 4.2.8 to 5.0 but it does not shows all the data in GUI.

    Thank you.
    Tags: upgrade instructions
    • Atsushi
      Senior Member
      • Aug 2013
      • 2028
      #2
      I have tested Zabbix DB backup & restore from 4.2.8 to 5.0 but it does not shows all the data in GUI.
      Did you start the new version of Zabbix server daemon after the restore and confirm that the database upgrade process completed successfully? If you get any error message, please tell me what it is.

        Comment

        • vai
          Junior Member
          • Jan 2020
          • 12
          #3
          Hello,

          I started the new version of Zabbix after restore and accessed the frontend.

          Please see below error messages which I encountered while performing the restore. Which are mainly related to DB dependencies.

          But I am keen to know how can we upgrade without DB restore?


          ERROR 1005 (HY000) at line 3: Can't create table `zabbixdb`.`httpstep_field` (errno: 150 "Foreign key constraint is incorrectly formed") + mysql zabbixdb
          ERROR 1005 (HY000) at line 3: Can't create table `zabbixdb`.`httpstepitem` (errno: 150 "Foreign key constraint is incorrectly formed") + mysql zabbixdb
          ERROR 1005 (HY000) at line 3: Can't create table `zabbixdb`.`httpstep` (errno: 150 "Foreign key constraint is incorrectly formed")+ mysql zabbixdb
          ERROR 1005 (HY000) at line 3: Can't create table `zabbixdb`.`httptest_field` (errno: 150 "Foreign key constraint is incorrectly formed") + mysql zabbixdb
          ERROR 1005 (HY000) at line 3: Can't create table `zabbixdb`.`httptestitem` (errno: 150 "Foreign key constraint is incorrectly formed") + mysql zabbixdb
          ERROR 1005 (HY000) at line 3: Can't create table `zabbixdb`.`httptest` (errno: 150 "Foreign key constraint is incorrectly formed")

            Comment

            • Atsushi
              Senior Member
              • Aug 2013
              • 2028
              #4
              What was the specific procedure for backing up and restoring? Did you restore only the old database to an empty database in the new environment?

                Comment

                • vai
                  Junior Member
                  • Jan 2020
                  • 12
                  #5
                  We restored the using mysqldump and we restored old database to an empty database.

                    Comment

                    Previous template Next
                    Working...