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

Restore PostgresSQL backup(production) on test enviroment

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Commercial support required
    • Icon: Trivial Trivial
    • None
    • 6.4.13
    • Server (S)
    • None

      Steps to reproduce:

      1. Changes in configuration  -  backup postgresql database(ver. 16.1) from docker container and restore database on postgresql server side (centos 9)

      Result:
      After restore Zabbix Server is not working, in the file log we observe "ERROR: current transaction is aborted, commands ignored until end of transaction block "

      See screenshot - image-2024-05-20-13-17-12-792.png

      But in log file postgres we observe :"2024-05-20 13:09:50.806 EEST [411648] ERROR:  current transaction is aborted, commands ignored until end of transaction block
      2024-05-20 13:09:50.806 EEST [411648] STATEMENT:  INSERT INTO valuemap_mapping (valuemap_mappingid,valuemapid,value,newvalue,type,sortorder) values ('13699','679','242','x86Laps','0','241');
      "

      See screnshot "image-2024-05-20-13-19-32-634.png"

      During the restore in the postgres logs, no errors were detected
      Version Zabbix Server : 6.4.10

      Version Zabbix Frontend : 6.4.10

      Version PostgreSQL in docker and server side : 16.1

      Mention: All zabbix components run in the container.

            zabbix.support Zabbix Support Team
            ecauca Eduard Cauca
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved:

                Estimated:
                Original Estimate - 40h
                40h
                Remaining:
                Remaining Estimate - 40h
                40h
                Logged:
                Time Spent - Not Specified
                Not Specified