Ad Widget

Collapse

Zabbix update 6.2.9 to 6.4 database error

Collapse
This topic has been answered.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Zbbixuser
    Member
    • Jun 2021
    • 45

    #1

    Zabbix update 6.2.9 to 6.4 database error

    Hi

    I am upgrading Zabbix from version 6.2.9 to 6.4 and I get an error while updating the Postgresql database:

    Code:
    ​​4640:20230329:092715.572 current database version (mandatory/optional): 06030063/06030063
    4640:20230329:092715.572 required mandatory version: 06040000
    4640:20230329:092715.572 starting automatic database upgrade
    4640:20230329:092715.574 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: column "name_upper" of relation "hosts" already exists
    [alter table hosts add name_upper varchar(128) default '' not null]
    4640:20230329:092715.574 database upgrade failed
    Can anyone help with this problem?
  • Answer selected by Zbbixuser at 02-05-2023, 16:42.
    Zbbixuser
    Member
    • Jun 2021
    • 45

    Помогло удаление колонок с помощью:
    ALTER TABLE hosts DROP COLUMN name_upper;
    ALTER TABLE items DROP COLUMN name_upper;

    Comment

    • Zbbixuser
      Member
      • Jun 2021
      • 45

      #2
      Помогло удаление колонок с помощью:
      ALTER TABLE hosts DROP COLUMN name_upper;
      ALTER TABLE items DROP COLUMN name_upper;

      Comment

      Working...