Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-23903

Database replication error

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Fixed
    • Icon: Trivial Trivial
    • None
    • None
    • None
    • None

      Specifications:
      Zabbix server version: 6.0.23
      Zabbix Database version: 6.0.23
      Database vendor (version): Mysql (8.0.33)

      Description:
      We are in the process of replicating the Zabbix database to reduce available storage. We utilize Amazon RDS with MySQL for the Zabbix application. To transfer the data, we performed a full dump of the 'DDL' of the database, and then populated the target database using AWS DMS.

      Although the migration was successful, with all data and objects correctly replicated to the target database, we are facing issues related to the database version and communication with the database instance.

      The application fails to start due to these issues. Even when the database is updated to a version compatible with the application version, the application still attempts internal updates, resulting in the mentioned errors.

      Steps to reproduce:

      1. Alter parameter group set log_bin_trust_function_creator=1 and row_format=ROW 
      2. Dump DDL from source database
      3. Data insertion in target database via AWS DMS
      4. Change DNS from source to target 
      5. Alter parameter group set log_bin_trust_function_creator=0 and row_format=MIXED
      6. Start zabbix-server service 

      Result:
      zabbix_server.log
      Current database version (mandatory/optional): 06000000/06000043
      Required mandatory version: 06000000
      Unable to read the database instance ID.

        1. count_itens_and_hosts.png
          34 kB
          Igor Luiz Oliveira
        2. selinux.png
          2 kB
          Igor Luiz Oliveira
        3. zabbix_server_conf_DB-1.png
          9 kB
          Igor Luiz Oliveira
        4. image-2024-01-04-14-53-35-175.png
          27 kB
          Igor Luiz Oliveira
        5. zabbix_server_conf_DB.png
          9 kB
          Igor Luiz Oliveira

            aigars.kadikis Aigars Kadikis
            igor.oliveira Igor Luiz Oliveira
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: