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

template update error

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Duplicate
    • Icon: Trivial Trivial
    • None
    • 6.4.0, 6.4.1rc1
    • Frontend (F)
    • None
    • debian11 postgresql13 zabbix 6.4.1rc1

      I'm trying to update the old ClickHouse by HTTP clickhouse template to the new one downloaded from https://github.com/zabbix/zabbix/blob/release/6.4/templates/db/clickhouse_http/template_db_clickhouse_http.yaml - frontend gives this error

      pg_query(): Query failed: ERROR: duplicate key value violates unique constraint "dashboard_page_pkey"
      ПОДРОБНОСТИ: Key (dashboard_pageid)=(63) already exists. [zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerPopupImport->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CConfiguration->import() → CConfigurationImport->import() → CConfigurationImport->processTemplateDashboards() → CTemplateDashboardImporter->import() → CTemplateDashboard->create() → CDashboardGeneral->updatePages() → DB::insert() → DB::insertBatch() → DBexecute() → pg_query() in include/db.inc.php:373]
      Error in query [INSERT INTO dashboard_page (dashboard_pageid,dashboardid,name,display_period,sortorder) VALUES ('63','93','Main','0','0'),('64','93','Replicas','0','1')] [ERROR: duplicate key value violates unique constraint "dashboard_page_pkey"
      ПОДРОБНОСТИ: Key (dashboard_pageid)=(63) already exists.]
      Ошибка при выполнении SQL запроса "INSERT INTO dashboard_page (dashboard_pageid,dashboardid,name,display_period,sortorder) VALUES ('63','93','Main','0','0'),('64','93','Replicas','0','1')".

            zabbix.support Zabbix Support Team
            zmdpc Vladimir
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: