Ad Widget

Collapse

DB Upgrade error from 5.4 to 6.0 beta1

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • markfree
    Senior Member
    • Apr 2019
    • 868

    #1

    DB Upgrade error from 5.4 to 6.0 beta1

    While trying to upgrade Zabbix 5.4 to 6.0 beta1 using sources in a Debian 11 enviroment with local MariaDB 10.5.12, I got the following frontend error:
    Database error
    The Zabbix database version does not match current requirements. Your database version: 5050114. Required version: 5040000. Please contact your system administrator.
    Checking Zabbix log, I see that the database upgrade was successful.
    Code:
    26958:20220102:212154.720 completed 97% of database upgrade
    26958:20220102:212154.758 completed 98% of database upgrade
    26958:20220102:212154.792 completed 99% of database upgrade
    26958:20220102:212154.823 completed 100% of database upgrade
    26958:20220102:212154.824 database upgrade fully completed
    26958:20220102:212154.825 database could be upgraded to use primary keys in history tables
    27022:20220102:212154.840 starting HA manager
    27022:20220102:212154.861 HA manager started in active mode
    26958:20220102:212154.942 server #0 started [main process]
    (...)
    Also, Zabbix "dbversion" table shows what I think is the correct version.
    Code:
    mysql> select * from dbversion;
    +-------------+-----------+----------+
    | dbversionid | mandatory | optional |
    +-------------+-----------+----------+
    | 1 | 5050114 | 5050114 |
    +-------------+-----------+----------+
    Maybe the frontend was not updated correctly.

    Any ideas on why is that?
  • dimir
    Zabbix developer
    • Apr 2011
    • 1080

    #2
    You need to also upgrade the frontend.

    Comment

    • markfree
      Senior Member
      • Apr 2019
      • 868

      #3
      According to the new Zabbix 6 doc, "The minimum required PHP version is 7.2.5".

      My current PHP is newer than that.
      Code:
      $ php -v
      PHP 7.4.25 (cli) (built: Oct 23 2021 21:53:50) ( NTS )
      According to log, the database was upgraded successfuly.

      For version 6.0, I found no specific instructions to upgrade the frontend.

      Is there a new frontend procedure that was not documented yet?

      Comment


      • Atsushi
        Atsushi commented
        Editing a comment
        Check the version of zabbix-frontend-php installed.

      • markfree
        markfree commented
        Editing a comment
        Atsushi, there is no "zabbix-frontend-php" package since itsĀ a sources installation.
    • dimir
      Zabbix developer
      • Apr 2011
      • 1080

      #4
      Whatever you do, however you install, Zabbix server and Zabbix frontend will only work on the database of the same Zabbix version.

      Comment

      • markfree
        Senior Member
        • Apr 2019
        • 868

        #5
        Originally posted by dimir
        Whatever you do, however you install, Zabbix server and Zabbix frontend will only work on the database of the same Zabbix version.
        I understand that.
        Both the frontend and Zabbix server are using the same DB.
        What I don't understand is why the frontend does not see the correct version.
        Last edited by markfree; 07-01-2022, 18:44.

        Comment

        • dimir
          Zabbix developer
          • Apr 2011
          • 1080

          #6
          They both report current version 5050114. Looks the same to me.

          Comment

          • markfree
            Senior Member
            • Apr 2019
            • 868

            #7
            Originally posted by dimir
            They both report current version 5050114. Looks the same to me.
            The frontend doesn't seem to know that, as mentioned above.
            Click image for larger version

Name:	frontend_error.png
Views:	3127
Size:	9.8 KB
ID:	437861

            Comment

            • markfree
              Senior Member
              • Apr 2019
              • 868

              #8
              Only now I've noticed that, after upgrading from 5.4 to 6.0, "zabbix_server.conf" file was not updated during compilation.

              After manually copying Server and Agent configuration files, frontend started working correctly.

              I'm not sure this is to be expected when updating from sources...
              Last edited by markfree; 08-01-2022, 02:17.

              Comment

              Working...