Ad Widget

Collapse

Zabbix 7.0.0 alpha9 DB Version 6050175 – Compatible LTS Version on Docker?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • market21
    Junior Member
    • Dec 2023
    • 10

    #1

    Zabbix 7.0.0 alpha9 DB Version 6050175 – Compatible LTS Version on Docker?

    Good morning,

    I'm currently using Zabbix 7.0.0 alpha9, and my MySQL database (the zabbix schema) is at version 6050175.
    Does anyone know if there's an LTS version of Zabbix that's compatible with this database version?
    Preferably one that's available on Docker Hub.



    Click image for larger version

Name:	image.png
Views:	35
Size:	8.6 KB
ID:	503577

    Click image for larger version

Name:	image.png
Views:	75
Size:	39.6 KB
ID:	503576
  • cyber
    Senior Member
    Zabbix Certified SpecialistZabbix Certified Professional
    • Dec 2006
    • 4806

    #2
    Upgrading your server also includes patches to DB, so during first start (of any newer version) those are executed and your version numbers are updated. Going from alpha to LTS probably changes those numbers from 605.... to 7000...

    Comment

    • Observer365
      Junior Member
      • May 2025
      • 7

      #3
      Hello,
      I runed zabbix/zabbix-server-mysql:latest image with the same DB version as you have. The server started the upgrading the database but it failed on the middle way until I run:
      Code:
      mysql> set global log_bin_trust_function_creators = 1;
      for my database.
      After that DB updating continued and I got latest DB version.
      Click image for larger version

Name:	image.png
Views:	28
Size:	24.6 KB
ID:	503649
      Of course before upgrading it would be better to make DB backup.
      Attached Files

      Comment

      • market21
        Junior Member
        • Dec 2023
        • 10

        #4
        Thanks, I managed to solve it.

        Comment

        Working...