2023-01-04 09:30:59.698 CET [14691]LOG: starting PostgreSQL 14.6 on x86_64-suse-linux-gnu, compiled by gcc (SUSE Linux) 7.5.0, 64-bit 2023-01-04 09:30:59.700 CET [14691]LOG: listening on IPv4 address "127.0.0.1", port 5432 2023-01-04 09:30:59.727 CET [14691]LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" 2023-01-04 09:30:59.743 CET [14691]LOG: listening on Unix socket "/tmp/.s.PGSQL.5432" 2023-01-04 09:30:59.759 CET [14693]LOG: database system was shut down at 2023-01-04 09:24:00 CET 2023-01-04 09:30:59.836 CET [14691]LOG: database system is ready to accept connections 2023-01-04 09:31:00.359 CET postgres postgres [14841]ERROR: role "zabbix" already exists 2023-01-04 09:31:00.359 CET postgres postgres [14841]STATEMENT: CREATE ROLE zabbix NOSUPERUSER NOCREATEDB NOCREATEROLE INHERIT LOGIN; 2023-01-04 09:31:00.513 CET postgres postgres [14885]ERROR: database "zabbix" already exists 2023-01-04 09:31:00.513 CET postgres postgres [14885]STATEMENT: CREATE DATABASE zabbix OWNER zabbix ENCODING 'Unicode' TEMPLATE template0; 2023-01-04 09:31:00.963 CET zabbix zabbix [14928]ERROR: relation "role" already exists 2023-01-04 09:31:00.963 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE role ( roleid bigint NOT NULL, name varchar(255) DEFAULT '' NOT NULL, type integer DEFAULT '0' NOT NULL, readonly integer DEFAULT '0' NOT NULL, PRIMARY KEY (roleid) ); 2023-01-04 09:31:00.976 CET zabbix zabbix [14928]ERROR: relation "role_1" already exists 2023-01-04 09:31:00.976 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX role_1 ON role (name); 2023-01-04 09:31:00.976 CET zabbix zabbix [14928]ERROR: relation "users" already exists 2023-01-04 09:31:00.976 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE users ( userid bigint NOT NULL, username varchar(100) DEFAULT '' NOT NULL, name varchar(100) DEFAULT '' NOT NULL, surname varchar(100) DEFAULT '' NOT NULL, passwd varchar(60) DEFAULT '' NOT NULL, url varchar(2048) DEFAULT '' NOT NULL, autologin integer DEFAULT '0' NOT NULL, autologout varchar(32) DEFAULT '15m' NOT NULL, lang varchar(7) DEFAULT 'default' NOT NULL, refresh varchar(32) DEFAULT '30s' NOT NULL, theme varchar(128) DEFAULT 'default' NOT NULL, attempt_failed integer DEFAULT 0 NOT NULL, attempt_ip varchar(39) DEFAULT '' NOT NULL, attempt_clock integer DEFAULT 0 NOT NULL, rows_per_page integer DEFAULT 50 NOT NULL, timezone varchar(50) DEFAULT 'default' NOT NULL, roleid bigint NOT NULL, PRIMARY KEY (userid) ); 2023-01-04 09:31:00.977 CET zabbix zabbix [14928]ERROR: relation "users_1" already exists 2023-01-04 09:31:00.977 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX users_1 ON users (username); 2023-01-04 09:31:00.977 CET zabbix zabbix [14928]ERROR: relation "maintenances" already exists 2023-01-04 09:31:00.977 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE maintenances ( maintenanceid bigint NOT NULL, name varchar(128) DEFAULT '' NOT NULL, maintenance_type integer DEFAULT '0' NOT NULL, description text DEFAULT '' NOT NULL, active_since integer DEFAULT '0' NOT NULL, active_till integer DEFAULT '0' NOT NULL, tags_evaltype integer DEFAULT '0' NOT NULL, PRIMARY KEY (maintenanceid) ); 2023-01-04 09:31:00.978 CET zabbix zabbix [14928]ERROR: relation "maintenances_1" already exists 2023-01-04 09:31:00.978 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX maintenances_1 ON maintenances (active_since,active_till); 2023-01-04 09:31:00.978 CET zabbix zabbix [14928]ERROR: relation "maintenances_2" already exists 2023-01-04 09:31:00.978 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX maintenances_2 ON maintenances (name); 2023-01-04 09:31:00.978 CET zabbix zabbix [14928]ERROR: relation "hosts" already exists 2023-01-04 09:31:00.978 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE hosts ( hostid bigint NOT NULL, proxy_hostid bigint NULL, host varchar(128) DEFAULT '' NOT NULL, status integer DEFAULT '0' NOT NULL, ipmi_authtype integer DEFAULT '-1' NOT NULL, ipmi_privilege integer DEFAULT '2' NOT NULL, ipmi_username varchar(16) DEFAULT '' NOT NULL, ipmi_password varchar(20) DEFAULT '' NOT NULL, maintenanceid bigint NULL, maintenance_status integer DEFAULT '0' NOT NULL, maintenance_type integer DEFAULT '0' NOT NULL, maintenance_from integer DEFAULT '0' NOT NULL, name varchar(128) DEFAULT '' NOT NULL, flags integer DEFAULT '0' NOT NULL, templateid bigint NULL, description text DEFAULT '' NOT NULL, tls_connect integer DEFAULT '1' NOT NULL, tls_accept integer DEFAULT '1' NOT NULL, tls_issuer varchar(1024) DEFAULT '' NOT NULL, tls_subject varchar(1024) DEFAULT '' NOT NULL, tls_psk_identity varchar(128) DEFAULT '' NOT NULL, tls_psk varchar(512) DEFAULT '' NOT NULL, proxy_address varchar(255) DEFAULT '' NOT NULL, auto_compress integer DEFAULT '1' NOT NULL, discover integer DEFAULT '0' NOT NULL, custom_interfaces integer DEFAULT '0' NOT NULL, uuid varchar(32) DEFAULT '' NOT NULL, name_upper varchar(128) DEFAULT '' NOT NULL, PRIMARY KEY (hostid) ); 2023-01-04 09:31:00.978 CET zabbix zabbix [14928]ERROR: relation "hosts_1" already exists 2023-01-04 09:31:00.978 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX hosts_1 ON hosts (host); 2023-01-04 09:31:00.978 CET zabbix zabbix [14928]ERROR: relation "hosts_2" already exists 2023-01-04 09:31:00.978 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX hosts_2 ON hosts (status); 2023-01-04 09:31:00.979 CET zabbix zabbix [14928]ERROR: relation "hosts_3" already exists 2023-01-04 09:31:00.979 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX hosts_3 ON hosts (proxy_hostid); 2023-01-04 09:31:00.979 CET zabbix zabbix [14928]ERROR: relation "hosts_4" already exists 2023-01-04 09:31:00.979 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX hosts_4 ON hosts (name); 2023-01-04 09:31:00.979 CET zabbix zabbix [14928]ERROR: relation "hosts_5" already exists 2023-01-04 09:31:00.979 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX hosts_5 ON hosts (maintenanceid); 2023-01-04 09:31:00.979 CET zabbix zabbix [14928]ERROR: column "name_upper" does not exist 2023-01-04 09:31:00.979 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX hosts_6 ON hosts (name_upper); 2023-01-04 09:31:00.979 CET zabbix zabbix [14928]ERROR: relation "hstgrp" already exists 2023-01-04 09:31:00.979 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE hstgrp ( groupid bigint NOT NULL, name varchar(255) DEFAULT '' NOT NULL, flags integer DEFAULT '0' NOT NULL, uuid varchar(32) DEFAULT '' NOT NULL, type integer DEFAULT '0' NOT NULL, PRIMARY KEY (groupid) ); 2023-01-04 09:31:00.979 CET zabbix zabbix [14928]ERROR: relation "hstgrp_1" already exists 2023-01-04 09:31:00.979 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX hstgrp_1 ON hstgrp (type,name); 2023-01-04 09:31:00.979 CET zabbix zabbix [14928]ERROR: relation "group_prototype" already exists 2023-01-04 09:31:00.979 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE group_prototype ( group_prototypeid bigint NOT NULL, hostid bigint NOT NULL, name varchar(255) DEFAULT '' NOT NULL, groupid bigint NULL, templateid bigint NULL, PRIMARY KEY (group_prototypeid) ); 2023-01-04 09:31:00.980 CET zabbix zabbix [14928]ERROR: relation "group_prototype_1" already exists 2023-01-04 09:31:00.980 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX group_prototype_1 ON group_prototype (hostid); 2023-01-04 09:31:00.980 CET zabbix zabbix [14928]ERROR: relation "group_discovery" already exists 2023-01-04 09:31:00.980 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE group_discovery ( groupid bigint NOT NULL, parent_group_prototypeid bigint NOT NULL, name varchar(255) DEFAULT '' NOT NULL, lastcheck integer DEFAULT '0' NOT NULL, ts_delete integer DEFAULT '0' NOT NULL, PRIMARY KEY (groupid) ); 2023-01-04 09:31:00.980 CET zabbix zabbix [14928]ERROR: relation "drules" already exists 2023-01-04 09:31:00.980 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE drules ( druleid bigint NOT NULL, proxy_hostid bigint NULL, name varchar(255) DEFAULT '' NOT NULL, iprange varchar(2048) DEFAULT '' NOT NULL, delay varchar(255) DEFAULT '1h' NOT NULL, nextcheck integer DEFAULT '0' NOT NULL, status integer DEFAULT '0' NOT NULL, PRIMARY KEY (druleid) ); 2023-01-04 09:31:00.980 CET zabbix zabbix [14928]ERROR: relation "drules_1" already exists 2023-01-04 09:31:00.980 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX drules_1 ON drules (proxy_hostid); 2023-01-04 09:31:00.981 CET zabbix zabbix [14928]ERROR: relation "drules_2" already exists 2023-01-04 09:31:00.981 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX drules_2 ON drules (name); 2023-01-04 09:31:00.981 CET zabbix zabbix [14928]ERROR: relation "dchecks" already exists 2023-01-04 09:31:00.981 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE dchecks ( dcheckid bigint NOT NULL, druleid bigint NOT NULL, type integer DEFAULT '0' NOT NULL, key_ varchar(2048) DEFAULT '' NOT NULL, snmp_community varchar(255) DEFAULT '' NOT NULL, ports varchar(255) DEFAULT '0' NOT NULL, snmpv3_securityname varchar(64) DEFAULT '' NOT NULL, snmpv3_securitylevel integer DEFAULT '0' NOT NULL, snmpv3_authpassphrase varchar(64) DEFAULT '' NOT NULL, snmpv3_privpassphrase varchar(64) DEFAULT '' NOT NULL, uniq integer DEFAULT '0' NOT NULL, snmpv3_authprotocol integer DEFAULT '0' NOT NULL, snmpv3_privprotocol integer DEFAULT '0' NOT NULL, snmpv3_contextname varchar(255) DEFAULT '' NOT NULL, host_source integer DEFAULT '1' NOT NULL, name_source integer DEFAULT '0' NOT NULL, PRIMARY KEY (dcheckid) ); 2023-01-04 09:31:00.981 CET zabbix zabbix [14928]ERROR: relation "dchecks_1" already exists 2023-01-04 09:31:00.981 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX dchecks_1 ON dchecks (druleid,host_source,name_source); 2023-01-04 09:31:00.981 CET zabbix zabbix [14928]ERROR: relation "httptest" already exists 2023-01-04 09:31:00.981 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE httptest ( httptestid bigint NOT NULL, name varchar(64) DEFAULT '' NOT NULL, nextcheck integer DEFAULT '0' NOT NULL, delay varchar(255) DEFAULT '1m' NOT NULL, status integer DEFAULT '0' NOT NULL, agent varchar(255) DEFAULT 'Zabbix' NOT NULL, authentication integer DEFAULT '0' NOT NULL, http_user varchar(64) DEFAULT '' NOT NULL, http_password varchar(64) DEFAULT '' NOT NULL, hostid bigint NOT NULL, templateid bigint NULL, http_proxy varchar(255) DEFAULT '' NOT NULL, retries integer DEFAULT '1' NOT NULL, ssl_cert_file varchar(255) DEFAULT '' NOT NULL, ssl_key_file varchar(255) DEFAULT '' NOT NULL, ssl_key_password varchar(64) DEFAULT '' NOT NULL, verify_peer integer DEFAULT '0' NOT NULL, verify_host integer DEFAULT '0' NOT NULL, uuid varchar(32) DEFAULT '' NOT NULL, PRIMARY KEY (httptestid) ); 2023-01-04 09:31:00.981 CET zabbix zabbix [14928]ERROR: relation "httptest_2" already exists 2023-01-04 09:31:00.981 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX httptest_2 ON httptest (hostid,name); 2023-01-04 09:31:00.981 CET zabbix zabbix [14928]ERROR: relation "httptest_3" already exists 2023-01-04 09:31:00.981 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX httptest_3 ON httptest (status); 2023-01-04 09:31:00.982 CET zabbix zabbix [14928]ERROR: relation "httptest_4" already exists 2023-01-04 09:31:00.982 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX httptest_4 ON httptest (templateid); 2023-01-04 09:31:00.982 CET zabbix zabbix [14928]ERROR: relation "httpstep" already exists 2023-01-04 09:31:00.982 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE httpstep ( httpstepid bigint NOT NULL, httptestid bigint NOT NULL, name varchar(64) DEFAULT '' NOT NULL, no integer DEFAULT '0' NOT NULL, url varchar(2048) DEFAULT '' NOT NULL, timeout varchar(255) DEFAULT '15s' NOT NULL, posts text DEFAULT '' NOT NULL, required varchar(255) DEFAULT '' NOT NULL, status_codes varchar(255) DEFAULT '' NOT NULL, follow_redirects integer DEFAULT '1' NOT NULL, retrieve_mode integer DEFAULT '0' NOT NULL, post_type integer DEFAULT '0' NOT NULL, PRIMARY KEY (httpstepid) ); 2023-01-04 09:31:00.982 CET zabbix zabbix [14928]ERROR: relation "httpstep_1" already exists 2023-01-04 09:31:00.982 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX httpstep_1 ON httpstep (httptestid); 2023-01-04 09:31:00.982 CET zabbix zabbix [14928]ERROR: relation "interface" already exists 2023-01-04 09:31:00.982 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE interface ( interfaceid bigint NOT NULL, hostid bigint NOT NULL, main integer DEFAULT '0' NOT NULL, type integer DEFAULT '1' NOT NULL, useip integer DEFAULT '1' NOT NULL, ip varchar(64) DEFAULT '127.0.0.1' NOT NULL, dns varchar(255) DEFAULT '' NOT NULL, port varchar(64) DEFAULT '10050' NOT NULL, available integer DEFAULT '0' NOT NULL, error varchar(2048) DEFAULT '' NOT NULL, errors_from integer DEFAULT '0' NOT NULL, disable_until integer DEFAULT '0' NOT NULL, PRIMARY KEY (interfaceid) ); 2023-01-04 09:31:00.982 CET zabbix zabbix [14928]ERROR: relation "interface_1" already exists 2023-01-04 09:31:00.982 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX interface_1 ON interface (hostid,type); 2023-01-04 09:31:00.983 CET zabbix zabbix [14928]ERROR: relation "interface_2" already exists 2023-01-04 09:31:00.983 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX interface_2 ON interface (ip,dns); 2023-01-04 09:31:00.983 CET zabbix zabbix [14928]ERROR: relation "interface_3" already exists 2023-01-04 09:31:00.983 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX interface_3 ON interface (available); 2023-01-04 09:31:00.983 CET zabbix zabbix [14928]ERROR: relation "valuemap" already exists 2023-01-04 09:31:00.983 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE valuemap ( valuemapid bigint NOT NULL, hostid bigint NOT NULL, name varchar(64) DEFAULT '' NOT NULL, uuid varchar(32) DEFAULT '' NOT NULL, PRIMARY KEY (valuemapid) ); 2023-01-04 09:31:00.983 CET zabbix zabbix [14928]ERROR: relation "valuemap_1" already exists 2023-01-04 09:31:00.983 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX valuemap_1 ON valuemap (hostid,name); 2023-01-04 09:31:00.983 CET zabbix zabbix [14928]ERROR: relation "items" already exists 2023-01-04 09:31:00.983 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE items ( itemid bigint NOT NULL, type integer DEFAULT '0' NOT NULL, snmp_oid varchar(512) DEFAULT '' NOT NULL, hostid bigint NOT NULL, name varchar(255) DEFAULT '' NOT NULL, key_ varchar(2048) DEFAULT '' NOT NULL, delay varchar(1024) DEFAULT '0' NOT NULL, history varchar(255) DEFAULT '90d' NOT NULL, trends varchar(255) DEFAULT '365d' NOT NULL, status integer DEFAULT '0' NOT NULL, value_type integer DEFAULT '0' NOT NULL, trapper_hosts varchar(255) DEFAULT '' NOT NULL, units varchar(255) DEFAULT '' NOT NULL, formula varchar(255) DEFAULT '' NOT NULL, logtimefmt varchar(64) DEFAULT '' NOT NULL, templateid bigint NULL, valuemapid bigint NULL, params text DEFAULT '' NOT NULL, ipmi_sensor varchar(128) DEFAULT '' NOT NULL, authtype integer DEFAULT '0' NOT NULL, username varchar(64) DEFAULT '' NOT NULL, password varchar(64) DEFAULT '' NOT NULL, publickey varchar(64) DEFAULT '' NOT NULL, privatekey varchar(64) DEFAULT '' NOT NULL, flags integer DEFAULT '0' NOT NULL, interfaceid bigint NULL, description text DEFAULT '' NOT NULL, inventory_link integer DEFAULT '0' NOT NULL, lifetime varchar(255) DEFAULT '30d' NOT NULL, evaltype integer DEFAULT '0' NOT NULL, jmx_endpoint varchar(255) DEFAULT '' NOT NULL, master_itemid bigint NULL, timeout varchar(255) DEFAULT '3s' NOT NULL, url varchar(2048) DEFAULT '' NOT NULL, query_fields varchar(2048) DEFAULT '' NOT NULL, posts text DEFAULT '' NOT NULL, status_codes varchar(255) DEFAULT '200' NOT NULL, follow_redirects integer DEFAULT '1' NOT NULL, post_type integer DEFAULT '0' NOT NULL, http_proxy varchar(255) DEFAULT '' NOT NULL, headers text DEFAULT '' NOT NULL, retrieve_mode integer DEFAULT '0' NOT NULL, request_method integer DEFAULT '0' NOT NULL, output_format integer DEFAULT '0' NOT NULL, ssl_cert_file varchar(255) DEFAULT '' NOT NULL, ssl_key_file varchar(255) DEFAULT '' NOT NULL, ssl_key_password varchar(64) DEFAULT '' NOT NULL, verify_peer integer DEFAULT '0' NOT NULL, verify_host integer DEFAULT '0' NOT NULL, allow_traps integer DEFAULT '0' NOT NULL, discover integer DEFAULT '0' NOT NULL, uuid varchar(32) DEFAULT '' NOT NULL, name_upper varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (itemid) ); 2023-01-04 09:31:00.984 CET zabbix zabbix [14928]ERROR: relation "items_1" already exists 2023-01-04 09:31:00.984 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX items_1 ON items (hostid,key_); 2023-01-04 09:31:00.984 CET zabbix zabbix [14928]ERROR: relation "items_3" already exists 2023-01-04 09:31:00.984 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX items_3 ON items (status); 2023-01-04 09:31:00.984 CET zabbix zabbix [14928]ERROR: relation "items_4" already exists 2023-01-04 09:31:00.984 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX items_4 ON items (templateid); 2023-01-04 09:31:00.984 CET zabbix zabbix [14928]ERROR: relation "items_5" already exists 2023-01-04 09:31:00.984 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX items_5 ON items (valuemapid); 2023-01-04 09:31:00.984 CET zabbix zabbix [14928]ERROR: relation "items_6" already exists 2023-01-04 09:31:00.984 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX items_6 ON items (interfaceid); 2023-01-04 09:31:00.984 CET zabbix zabbix [14928]ERROR: relation "items_7" already exists 2023-01-04 09:31:00.984 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX items_7 ON items (master_itemid); 2023-01-04 09:31:00.984 CET zabbix zabbix [14928]ERROR: relation "items_8" already exists 2023-01-04 09:31:00.984 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX items_8 ON items (key_); 2023-01-04 09:31:00.985 CET zabbix zabbix [14928]ERROR: column "name_upper" does not exist 2023-01-04 09:31:00.985 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX items_9 ON items (hostid,name_upper); 2023-01-04 09:31:00.985 CET zabbix zabbix [14928]ERROR: relation "httpstepitem" already exists 2023-01-04 09:31:00.985 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE httpstepitem ( httpstepitemid bigint NOT NULL, httpstepid bigint NOT NULL, itemid bigint NOT NULL, type integer DEFAULT '0' NOT NULL, PRIMARY KEY (httpstepitemid) ); 2023-01-04 09:31:00.985 CET zabbix zabbix [14928]ERROR: relation "httpstepitem_1" already exists 2023-01-04 09:31:00.985 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX httpstepitem_1 ON httpstepitem (httpstepid,itemid); 2023-01-04 09:31:00.985 CET zabbix zabbix [14928]ERROR: relation "httpstepitem_2" already exists 2023-01-04 09:31:00.985 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX httpstepitem_2 ON httpstepitem (itemid); 2023-01-04 09:31:00.985 CET zabbix zabbix [14928]ERROR: relation "httptestitem" already exists 2023-01-04 09:31:00.985 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE httptestitem ( httptestitemid bigint NOT NULL, httptestid bigint NOT NULL, itemid bigint NOT NULL, type integer DEFAULT '0' NOT NULL, PRIMARY KEY (httptestitemid) ); 2023-01-04 09:31:00.985 CET zabbix zabbix [14928]ERROR: relation "httptestitem_1" already exists 2023-01-04 09:31:00.985 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX httptestitem_1 ON httptestitem (httptestid,itemid); 2023-01-04 09:31:00.985 CET zabbix zabbix [14928]ERROR: relation "httptestitem_2" already exists 2023-01-04 09:31:00.985 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX httptestitem_2 ON httptestitem (itemid); 2023-01-04 09:31:00.986 CET zabbix zabbix [14928]ERROR: relation "media_type" already exists 2023-01-04 09:31:00.986 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE media_type ( mediatypeid bigint NOT NULL, type integer DEFAULT '0' NOT NULL, name varchar(100) DEFAULT '' NOT NULL, smtp_server varchar(255) DEFAULT '' NOT NULL, smtp_helo varchar(255) DEFAULT '' NOT NULL, smtp_email varchar(255) DEFAULT '' NOT NULL, exec_path varchar(255) DEFAULT '' NOT NULL, gsm_modem varchar(255) DEFAULT '' NOT NULL, username varchar(255) DEFAULT '' NOT NULL, passwd varchar(255) DEFAULT '' NOT NULL, status integer DEFAULT '0' NOT NULL, smtp_port integer DEFAULT '25' NOT NULL, smtp_security integer DEFAULT '0' NOT NULL, smtp_verify_peer integer DEFAULT '0' NOT NULL, smtp_verify_host integer DEFAULT '0' NOT NULL, smtp_authentication integer DEFAULT '0' NOT NULL, exec_params varchar(255) DEFAULT '' NOT NULL, maxsessions integer DEFAULT '1' NOT NULL, maxattempts integer DEFAULT '3' NOT NULL, attempt_interval varchar(32) DEFAULT '10s' NOT NULL, content_type integer DEFAULT '1' NOT NULL, script text DEFAULT '' NOT NULL, timeout varchar(32) DEFAULT '30s' NOT NULL, process_tags integer DEFAULT '0' NOT NULL, show_event_menu integer DEFAULT '0' NOT NULL, event_menu_url varchar(2048) DEFAULT '' NOT NULL, event_menu_name varchar(255) DEFAULT '' NOT NULL, description text DEFAULT '' NOT NULL, PRIMARY KEY (mediatypeid) ); 2023-01-04 09:31:00.986 CET zabbix zabbix [14928]ERROR: relation "media_type_1" already exists 2023-01-04 09:31:00.986 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX media_type_1 ON media_type (name); 2023-01-04 09:31:00.986 CET zabbix zabbix [14928]ERROR: relation "media_type_param" already exists 2023-01-04 09:31:00.986 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE media_type_param ( mediatype_paramid bigint NOT NULL, mediatypeid bigint NOT NULL, name varchar(255) DEFAULT '' NOT NULL, value varchar(2048) DEFAULT '' NOT NULL, PRIMARY KEY (mediatype_paramid) ); 2023-01-04 09:31:00.986 CET zabbix zabbix [14928]ERROR: relation "media_type_param_1" already exists 2023-01-04 09:31:00.986 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX media_type_param_1 ON media_type_param (mediatypeid); 2023-01-04 09:31:00.986 CET zabbix zabbix [14928]ERROR: relation "media_type_message" already exists 2023-01-04 09:31:00.986 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE media_type_message ( mediatype_messageid bigint NOT NULL, mediatypeid bigint NOT NULL, eventsource integer NOT NULL, recovery integer NOT NULL, subject varchar(255) DEFAULT '' NOT NULL, message text DEFAULT '' NOT NULL, PRIMARY KEY (mediatype_messageid) ); 2023-01-04 09:31:00.986 CET zabbix zabbix [14928]ERROR: relation "media_type_message_1" already exists 2023-01-04 09:31:00.986 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX media_type_message_1 ON media_type_message (mediatypeid,eventsource,recovery); 2023-01-04 09:31:00.986 CET zabbix zabbix [14928]ERROR: relation "usrgrp" already exists 2023-01-04 09:31:00.986 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE usrgrp ( usrgrpid bigint NOT NULL, name varchar(64) DEFAULT '' NOT NULL, gui_access integer DEFAULT '0' NOT NULL, users_status integer DEFAULT '0' NOT NULL, debug_mode integer DEFAULT '0' NOT NULL, userdirectoryid bigint DEFAULT NULL NULL, PRIMARY KEY (usrgrpid) ); 2023-01-04 09:31:00.987 CET zabbix zabbix [14928]ERROR: relation "usrgrp_1" already exists 2023-01-04 09:31:00.987 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX usrgrp_1 ON usrgrp (name); 2023-01-04 09:31:00.987 CET zabbix zabbix [14928]ERROR: relation "usrgrp_2" already exists 2023-01-04 09:31:00.987 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX usrgrp_2 ON usrgrp (userdirectoryid); 2023-01-04 09:31:00.987 CET zabbix zabbix [14928]ERROR: relation "users_groups" already exists 2023-01-04 09:31:00.987 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE users_groups ( id bigint NOT NULL, usrgrpid bigint NOT NULL, userid bigint NOT NULL, PRIMARY KEY (id) ); 2023-01-04 09:31:00.987 CET zabbix zabbix [14928]ERROR: relation "users_groups_1" already exists 2023-01-04 09:31:00.987 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX users_groups_1 ON users_groups (usrgrpid,userid); 2023-01-04 09:31:00.987 CET zabbix zabbix [14928]ERROR: relation "users_groups_2" already exists 2023-01-04 09:31:00.987 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX users_groups_2 ON users_groups (userid); 2023-01-04 09:31:00.987 CET zabbix zabbix [14928]ERROR: relation "scripts" already exists 2023-01-04 09:31:00.987 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE scripts ( scriptid bigint NOT NULL, name varchar(255) DEFAULT '' NOT NULL, command text DEFAULT '' NOT NULL, host_access integer DEFAULT '2' NOT NULL, usrgrpid bigint NULL, groupid bigint NULL, description text DEFAULT '' NOT NULL, confirmation varchar(255) DEFAULT '' NOT NULL, type integer DEFAULT '5' NOT NULL, execute_on integer DEFAULT '2' NOT NULL, timeout varchar(32) DEFAULT '30s' NOT NULL, scope integer DEFAULT '1' NOT NULL, port varchar(64) DEFAULT '' NOT NULL, authtype integer DEFAULT '0' NOT NULL, username varchar(64) DEFAULT '' NOT NULL, password varchar(64) DEFAULT '' NOT NULL, publickey varchar(64) DEFAULT '' NOT NULL, privatekey varchar(64) DEFAULT '' NOT NULL, menu_path varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (scriptid) ); 2023-01-04 09:31:00.988 CET zabbix zabbix [14928]ERROR: relation "scripts_1" already exists 2023-01-04 09:31:00.988 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX scripts_1 ON scripts (usrgrpid); 2023-01-04 09:31:00.988 CET zabbix zabbix [14928]ERROR: relation "scripts_2" already exists 2023-01-04 09:31:00.988 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX scripts_2 ON scripts (groupid); 2023-01-04 09:31:00.988 CET zabbix zabbix [14928]ERROR: relation "scripts_3" already exists 2023-01-04 09:31:00.988 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX scripts_3 ON scripts (name); 2023-01-04 09:31:00.988 CET zabbix zabbix [14928]ERROR: relation "script_param" already exists 2023-01-04 09:31:00.988 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE script_param ( script_paramid bigint NOT NULL, scriptid bigint NOT NULL, name varchar(255) DEFAULT '' NOT NULL, value varchar(2048) DEFAULT '' NOT NULL, PRIMARY KEY (script_paramid) ); 2023-01-04 09:31:00.988 CET zabbix zabbix [14928]ERROR: relation "script_param_1" already exists 2023-01-04 09:31:00.988 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX script_param_1 ON script_param (scriptid,name); 2023-01-04 09:31:00.988 CET zabbix zabbix [14928]ERROR: relation "actions" already exists 2023-01-04 09:31:00.988 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE actions ( actionid bigint NOT NULL, name varchar(255) DEFAULT '' NOT NULL, eventsource integer DEFAULT '0' NOT NULL, evaltype integer DEFAULT '0' NOT NULL, status integer DEFAULT '0' NOT NULL, esc_period varchar(255) DEFAULT '1h' NOT NULL, formula varchar(1024) DEFAULT '' NOT NULL, pause_suppressed integer DEFAULT '1' NOT NULL, notify_if_canceled integer DEFAULT '1' NOT NULL, PRIMARY KEY (actionid) ); 2023-01-04 09:31:00.989 CET zabbix zabbix [14928]ERROR: relation "actions_1" already exists 2023-01-04 09:31:00.989 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX actions_1 ON actions (eventsource,status); 2023-01-04 09:31:00.989 CET zabbix zabbix [14928]ERROR: relation "actions_2" already exists 2023-01-04 09:31:00.989 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX actions_2 ON actions (name); 2023-01-04 09:31:00.989 CET zabbix zabbix [14928]ERROR: relation "operations" already exists 2023-01-04 09:31:00.989 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE operations ( operationid bigint NOT NULL, actionid bigint NOT NULL, operationtype integer DEFAULT '0' NOT NULL, esc_period varchar(255) DEFAULT '0' NOT NULL, esc_step_from integer DEFAULT '1' NOT NULL, esc_step_to integer DEFAULT '1' NOT NULL, evaltype integer DEFAULT '0' NOT NULL, recovery integer DEFAULT '0' NOT NULL, PRIMARY KEY (operationid) ); 2023-01-04 09:31:00.989 CET zabbix zabbix [14928]ERROR: relation "operations_1" already exists 2023-01-04 09:31:00.989 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX operations_1 ON operations (actionid); 2023-01-04 09:31:00.990 CET zabbix zabbix [14928]ERROR: relation "opmessage" already exists 2023-01-04 09:31:00.990 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE opmessage ( operationid bigint NOT NULL, default_msg integer DEFAULT '1' NOT NULL, subject varchar(255) DEFAULT '' NOT NULL, message text DEFAULT '' NOT NULL, mediatypeid bigint NULL, PRIMARY KEY (operationid) ); 2023-01-04 09:31:00.990 CET zabbix zabbix [14928]ERROR: relation "opmessage_1" already exists 2023-01-04 09:31:00.990 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX opmessage_1 ON opmessage (mediatypeid); 2023-01-04 09:31:00.990 CET zabbix zabbix [14928]ERROR: relation "opmessage_grp" already exists 2023-01-04 09:31:00.990 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE opmessage_grp ( opmessage_grpid bigint NOT NULL, operationid bigint NOT NULL, usrgrpid bigint NOT NULL, PRIMARY KEY (opmessage_grpid) ); 2023-01-04 09:31:00.991 CET zabbix zabbix [14928]ERROR: relation "opmessage_grp_1" already exists 2023-01-04 09:31:00.991 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX opmessage_grp_1 ON opmessage_grp (operationid,usrgrpid); 2023-01-04 09:31:00.991 CET zabbix zabbix [14928]ERROR: relation "opmessage_grp_2" already exists 2023-01-04 09:31:00.991 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX opmessage_grp_2 ON opmessage_grp (usrgrpid); 2023-01-04 09:31:00.991 CET zabbix zabbix [14928]ERROR: relation "opmessage_usr" already exists 2023-01-04 09:31:00.991 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE opmessage_usr ( opmessage_usrid bigint NOT NULL, operationid bigint NOT NULL, userid bigint NOT NULL, PRIMARY KEY (opmessage_usrid) ); 2023-01-04 09:31:00.991 CET zabbix zabbix [14928]ERROR: relation "opmessage_usr_1" already exists 2023-01-04 09:31:00.991 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX opmessage_usr_1 ON opmessage_usr (operationid,userid); 2023-01-04 09:31:00.991 CET zabbix zabbix [14928]ERROR: relation "opmessage_usr_2" already exists 2023-01-04 09:31:00.991 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX opmessage_usr_2 ON opmessage_usr (userid); 2023-01-04 09:31:00.991 CET zabbix zabbix [14928]ERROR: relation "opcommand" already exists 2023-01-04 09:31:00.991 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE opcommand ( operationid bigint NOT NULL, scriptid bigint NOT NULL, PRIMARY KEY (operationid) ); 2023-01-04 09:31:00.991 CET zabbix zabbix [14928]ERROR: relation "opcommand_1" already exists 2023-01-04 09:31:00.991 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX opcommand_1 ON opcommand (scriptid); 2023-01-04 09:31:00.991 CET zabbix zabbix [14928]ERROR: relation "opcommand_hst" already exists 2023-01-04 09:31:00.991 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE opcommand_hst ( opcommand_hstid bigint NOT NULL, operationid bigint NOT NULL, hostid bigint NULL, PRIMARY KEY (opcommand_hstid) ); 2023-01-04 09:31:00.992 CET zabbix zabbix [14928]ERROR: relation "opcommand_hst_1" already exists 2023-01-04 09:31:00.992 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX opcommand_hst_1 ON opcommand_hst (operationid); 2023-01-04 09:31:00.992 CET zabbix zabbix [14928]ERROR: relation "opcommand_hst_2" already exists 2023-01-04 09:31:00.992 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX opcommand_hst_2 ON opcommand_hst (hostid); 2023-01-04 09:31:00.992 CET zabbix zabbix [14928]ERROR: relation "opcommand_grp" already exists 2023-01-04 09:31:00.992 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE opcommand_grp ( opcommand_grpid bigint NOT NULL, operationid bigint NOT NULL, groupid bigint NOT NULL, PRIMARY KEY (opcommand_grpid) ); 2023-01-04 09:31:00.992 CET zabbix zabbix [14928]ERROR: relation "opcommand_grp_1" already exists 2023-01-04 09:31:00.992 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX opcommand_grp_1 ON opcommand_grp (operationid); 2023-01-04 09:31:00.992 CET zabbix zabbix [14928]ERROR: relation "opcommand_grp_2" already exists 2023-01-04 09:31:00.992 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX opcommand_grp_2 ON opcommand_grp (groupid); 2023-01-04 09:31:00.992 CET zabbix zabbix [14928]ERROR: relation "opgroup" already exists 2023-01-04 09:31:00.992 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE opgroup ( opgroupid bigint NOT NULL, operationid bigint NOT NULL, groupid bigint NOT NULL, PRIMARY KEY (opgroupid) ); 2023-01-04 09:31:00.992 CET zabbix zabbix [14928]ERROR: relation "opgroup_1" already exists 2023-01-04 09:31:00.992 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX opgroup_1 ON opgroup (operationid,groupid); 2023-01-04 09:31:00.992 CET zabbix zabbix [14928]ERROR: relation "opgroup_2" already exists 2023-01-04 09:31:00.992 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX opgroup_2 ON opgroup (groupid); 2023-01-04 09:31:00.992 CET zabbix zabbix [14928]ERROR: relation "optemplate" already exists 2023-01-04 09:31:00.992 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE optemplate ( optemplateid bigint NOT NULL, operationid bigint NOT NULL, templateid bigint NOT NULL, PRIMARY KEY (optemplateid) ); 2023-01-04 09:31:00.993 CET zabbix zabbix [14928]ERROR: relation "optemplate_1" already exists 2023-01-04 09:31:00.993 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX optemplate_1 ON optemplate (operationid,templateid); 2023-01-04 09:31:00.993 CET zabbix zabbix [14928]ERROR: relation "optemplate_2" already exists 2023-01-04 09:31:00.993 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX optemplate_2 ON optemplate (templateid); 2023-01-04 09:31:00.993 CET zabbix zabbix [14928]ERROR: relation "opconditions" already exists 2023-01-04 09:31:00.993 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE opconditions ( opconditionid bigint NOT NULL, operationid bigint NOT NULL, conditiontype integer DEFAULT '0' NOT NULL, operator integer DEFAULT '0' NOT NULL, value varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (opconditionid) ); 2023-01-04 09:31:00.993 CET zabbix zabbix [14928]ERROR: relation "opconditions_1" already exists 2023-01-04 09:31:00.993 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX opconditions_1 ON opconditions (operationid); 2023-01-04 09:31:00.993 CET zabbix zabbix [14928]ERROR: relation "conditions" already exists 2023-01-04 09:31:00.993 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE conditions ( conditionid bigint NOT NULL, actionid bigint NOT NULL, conditiontype integer DEFAULT '0' NOT NULL, operator integer DEFAULT '0' NOT NULL, value varchar(255) DEFAULT '' NOT NULL, value2 varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (conditionid) ); 2023-01-04 09:31:00.993 CET zabbix zabbix [14928]ERROR: relation "conditions_1" already exists 2023-01-04 09:31:00.993 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX conditions_1 ON conditions (actionid); 2023-01-04 09:31:00.994 CET zabbix zabbix [14928]ERROR: relation "config" already exists 2023-01-04 09:31:00.994 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE config ( configid bigint NOT NULL, work_period varchar(255) DEFAULT '1-5,09:00-18:00' NOT NULL, alert_usrgrpid bigint NULL, default_theme varchar(128) DEFAULT 'blue-theme' NOT NULL, authentication_type integer DEFAULT '0' NOT NULL, discovery_groupid bigint NOT NULL, max_in_table integer DEFAULT '50' NOT NULL, search_limit integer DEFAULT '1000' NOT NULL, severity_color_0 varchar(6) DEFAULT '97AAB3' NOT NULL, severity_color_1 varchar(6) DEFAULT '7499FF' NOT NULL, severity_color_2 varchar(6) DEFAULT 'FFC859' NOT NULL, severity_color_3 varchar(6) DEFAULT 'FFA059' NOT NULL, severity_color_4 varchar(6) DEFAULT 'E97659' NOT NULL, severity_color_5 varchar(6) DEFAULT 'E45959' NOT NULL, severity_name_0 varchar(32) DEFAULT 'Not classified' NOT NULL, severity_name_1 varchar(32) DEFAULT 'Information' NOT NULL, severity_name_2 varchar(32) DEFAULT 'Warning' NOT NULL, severity_name_3 varchar(32) DEFAULT 'Average' NOT NULL, severity_name_4 varchar(32) DEFAULT 'High' NOT NULL, severity_name_5 varchar(32) DEFAULT 'Disaster' NOT NULL, ok_period varchar(32) DEFAULT '5m' NOT NULL, blink_period varchar(32) DEFAULT '2m' NOT NULL, problem_unack_color varchar(6) DEFAULT 'CC0000' NOT NULL, problem_ack_color varchar(6) DEFAULT 'CC0000' NOT NULL, ok_unack_color varchar(6) DEFAULT '009900' NOT NULL, ok_ack_color varchar(6) DEFAULT '009900' NOT NULL, problem_unack_style integer DEFAULT '1' NOT NULL, problem_ack_style integer DEFAULT '1' NOT NULL, ok_unack_style integer DEFAULT '1' NOT NULL, ok_ack_style integer DEFAULT '1' NOT NULL, snmptrap_logging integer DEFAULT '1' NOT NULL, server_check_interval integer DEFAULT '10' NOT NULL, hk_events_mode integer DEFAULT '1' NOT NULL, hk_events_trigger varchar(32) DEFAULT '365d' NOT NULL, hk_events_internal varchar(32) DEFAULT '1d' NOT NULL, hk_events_discovery varchar(32) DEFAULT '1d' NOT NULL, hk_events_autoreg varchar(32) DEFAULT '1d' NOT NULL, hk_services_mode integer DEFAULT '1' NOT NULL, hk_services varchar(32) DEFAULT '365d' NOT NULL, hk_audit_mode integer DEFAULT '1' NOT NULL, hk_audit varchar(32) DEFAULT '365d' NOT NULL, hk_sessions_mode integer DEFAULT '1' NOT NULL, hk_sessions varchar(32) DEFAULT '365d' NOT NULL, hk_history_mode integer DEFAULT '1' NOT NULL, hk_history_global integer DEFAULT '0' NOT NULL, hk_history varchar(32) DEFAULT '90d' NOT NULL, hk_trends_mode integer DEFAULT '1' NOT NULL, hk_trends_global integer DEFAULT '0' NOT NULL, hk_trends varchar(32) DEFAULT '365d' NOT NULL, default_inventory_mode integer DEFAULT '-1' NOT NULL, custom_color integer DEFAULT '0' NOT NULL, http_auth_enabled integer DEFAULT '0' NOT NULL, http_login_form integer DEFAULT '0' NOT NULL, http_strip_domains varchar(2048) DEFAULT '' NOT NULL, http_case_sensitive integer DEFAULT '1' NOT NULL, ldap_configured integer DEFAULT '0' NOT NULL, ldap_case_sensitive integer DEFAULT '1' NOT NULL, db_extension varchar(32) DEFAULT '' NOT NULL, autoreg_tls_accept integer DEFAULT '1' NOT NULL, compression_status integer DEFAULT '0' NOT NULL, compress_older varchar(32) DEFAULT '7d' NOT NULL, instanceid varchar(32) DEFAULT '' NOT NULL, saml_auth_enabled integer DEFAULT '0' NOT NULL, saml_idp_entityid varchar(1024) DEFAULT '' NOT NULL, saml_sso_url varchar(2048) DEFAULT '' NOT NULL, saml_slo_url varchar(2048) DEFAULT '' NOT NULL, saml_username_attribute varchar(128) DEFAULT '' NOT NULL, saml_sp_entityid varchar(1024) DEFAULT '' NOT NULL, saml_nameid_format varchar(2048) DEFAULT '' NOT NULL, saml_sign_messages integer DEFAULT '0' NOT NULL, saml_sign_assertions integer DEFAULT '0' NOT NULL, saml_sign_authn_requests integer DEFAULT '0' NOT NULL, saml_sign_logout_requests integer DEFAULT '0' NOT NULL, saml_sign_logout_responses integer DEFAULT '0' NOT NULL, saml_encrypt_nameid integer DEFAULT '0' NOT NULL, saml_encrypt_assertions integer DEFAULT '0' NOT NULL, saml_case_sensitive integer DEFAULT '0' NOT NULL, default_lang varchar(5) DEFAULT 'en_US' NOT NULL, default_timezone varchar(50) DEFAULT 'system' NOT NULL, login_attempts integer DEFAULT '5' NOT NULL, login_block varchar(32) DEFAULT '30s' NOT NULL, show_technical_errors integer DEFAULT '0' NOT NULL, validate_uri_schemes integer DEFAULT '1' NOT NULL, uri_valid_schemes varchar(255) DEFAULT 'http,https,ftp,file,mailto,tel,ssh' NOT NULL, x_frame_options varchar(255) DEFAULT 'SAMEORIGIN' NOT NULL, iframe_sandboxing_enabled integer DEFAULT '1' NOT NULL, iframe_sandboxing_exceptions varchar(255) DEFAULT '' NOT NULL, max_overview_table_size integer DEFAULT '50' NOT NULL, history_period varchar(32) DEFAULT '24h' NOT NULL, period_default varchar(32) DEFAULT '1h' NOT NULL, max_period varchar(32) DEFAULT '2y' NOT NULL, socket_timeout varchar(32) DEFAULT '3s' NOT NULL, connect_timeout varchar(32) DEFAULT '3s' NOT NULL, media_type_test_timeout varchar(32) DEFAULT '65s' NOT NULL, script_timeout varchar(32) DEFAULT '60s' NOT NULL, item_test_timeout varchar(32) DEFAULT '60s' NOT NULL, session_key varchar(32) DEFAULT '' NOT NULL, url varchar(255) DEFAULT '' NOT NULL, report_test_timeout varchar(32) DEFAULT '60s' NOT NULL, dbversion_status text DEFAULT '' NOT NULL, hk_events_service varchar(32) DEFAULT '1d' NOT NULL, passwd_min_length integer DEFAULT '8' NOT NULL, passwd_check_rules integer DEFAULT '8' NOT NULL, auditlog_enabled integer DEFAULT '1' NOT NULL, ha_failover_delay varchar(32) DEFAULT '1m' NOT NULL, geomaps_tile_provider varchar(255) DEFAULT '' NOT NULL, geomaps_tile_url varchar(1024) DEFAULT '' NOT NULL, geomaps_max_zoom integer DEFAULT '0' NOT NULL, geomaps_attribution varchar(1024) DEFAULT '' NOT NULL, vault_provider integer DEFAULT '0' NOT NULL, ldap_userdirectoryid bigint DEFAULT NULL NULL, PRIMARY KEY (configid) ); 2023-01-04 09:31:00.995 CET zabbix zabbix [14928]ERROR: relation "config_1" already exists 2023-01-04 09:31:00.995 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX config_1 ON config (alert_usrgrpid); 2023-01-04 09:31:00.995 CET zabbix zabbix [14928]ERROR: relation "config_2" already exists 2023-01-04 09:31:00.995 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX config_2 ON config (discovery_groupid); 2023-01-04 09:31:00.995 CET zabbix zabbix [14928]ERROR: relation "config_3" already exists 2023-01-04 09:31:00.995 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX config_3 ON config (ldap_userdirectoryid); 2023-01-04 09:31:00.995 CET zabbix zabbix [14928]ERROR: relation "triggers" already exists 2023-01-04 09:31:00.995 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE triggers ( triggerid bigint NOT NULL, expression varchar(2048) DEFAULT '' NOT NULL, description varchar(255) DEFAULT '' NOT NULL, url varchar(255) DEFAULT '' NOT NULL, status integer DEFAULT '0' NOT NULL, value integer DEFAULT '0' NOT NULL, priority integer DEFAULT '0' NOT NULL, lastchange integer DEFAULT '0' NOT NULL, comments text DEFAULT '' NOT NULL, error varchar(2048) DEFAULT '' NOT NULL, templateid bigint NULL, type integer DEFAULT '0' NOT NULL, state integer DEFAULT '0' NOT NULL, flags integer DEFAULT '0' NOT NULL, recovery_mode integer DEFAULT '0' NOT NULL, recovery_expression varchar(2048) DEFAULT '' NOT NULL, correlation_mode integer DEFAULT '0' NOT NULL, correlation_tag varchar(255) DEFAULT '' NOT NULL, manual_close integer DEFAULT '0' NOT NULL, opdata varchar(255) DEFAULT '' NOT NULL, discover integer DEFAULT '0' NOT NULL, event_name varchar(2048) DEFAULT '' NOT NULL, uuid varchar(32) DEFAULT '' NOT NULL, PRIMARY KEY (triggerid) ); 2023-01-04 09:31:00.995 CET zabbix zabbix [14928]ERROR: relation "triggers_1" already exists 2023-01-04 09:31:00.995 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX triggers_1 ON triggers (status); 2023-01-04 09:31:00.996 CET zabbix zabbix [14928]ERROR: relation "triggers_2" already exists 2023-01-04 09:31:00.996 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX triggers_2 ON triggers (value,lastchange); 2023-01-04 09:31:00.996 CET zabbix zabbix [14928]ERROR: relation "triggers_3" already exists 2023-01-04 09:31:00.996 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX triggers_3 ON triggers (templateid); 2023-01-04 09:31:00.996 CET zabbix zabbix [14928]ERROR: relation "trigger_depends" already exists 2023-01-04 09:31:00.996 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE trigger_depends ( triggerdepid bigint NOT NULL, triggerid_down bigint NOT NULL, triggerid_up bigint NOT NULL, PRIMARY KEY (triggerdepid) ); 2023-01-04 09:31:00.996 CET zabbix zabbix [14928]ERROR: relation "trigger_depends_1" already exists 2023-01-04 09:31:00.996 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX trigger_depends_1 ON trigger_depends (triggerid_down,triggerid_up); 2023-01-04 09:31:00.996 CET zabbix zabbix [14928]ERROR: relation "trigger_depends_2" already exists 2023-01-04 09:31:00.996 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX trigger_depends_2 ON trigger_depends (triggerid_up); 2023-01-04 09:31:00.996 CET zabbix zabbix [14928]ERROR: relation "functions" already exists 2023-01-04 09:31:00.996 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE functions ( functionid bigint NOT NULL, itemid bigint NOT NULL, triggerid bigint NOT NULL, name varchar(12) DEFAULT '' NOT NULL, parameter varchar(255) DEFAULT '0' NOT NULL, PRIMARY KEY (functionid) ); 2023-01-04 09:31:00.996 CET zabbix zabbix [14928]ERROR: relation "functions_1" already exists 2023-01-04 09:31:00.996 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX functions_1 ON functions (triggerid); 2023-01-04 09:31:00.997 CET zabbix zabbix [14928]ERROR: relation "functions_2" already exists 2023-01-04 09:31:00.997 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX functions_2 ON functions (itemid,name,parameter); 2023-01-04 09:31:01.001 CET zabbix zabbix [14928]ERROR: relation "graphs" already exists 2023-01-04 09:31:01.001 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE graphs ( graphid bigint NOT NULL, name varchar(128) DEFAULT '' NOT NULL, width integer DEFAULT '900' NOT NULL, height integer DEFAULT '200' NOT NULL, yaxismin DOUBLE PRECISION DEFAULT '0' NOT NULL, yaxismax DOUBLE PRECISION DEFAULT '100' NOT NULL, templateid bigint NULL, show_work_period integer DEFAULT '1' NOT NULL, show_triggers integer DEFAULT '1' NOT NULL, graphtype integer DEFAULT '0' NOT NULL, show_legend integer DEFAULT '1' NOT NULL, show_3d integer DEFAULT '0' NOT NULL, percent_left DOUBLE PRECISION DEFAULT '0' NOT NULL, percent_right DOUBLE PRECISION DEFAULT '0' NOT NULL, ymin_type integer DEFAULT '0' NOT NULL, ymax_type integer DEFAULT '0' NOT NULL, ymin_itemid bigint NULL, ymax_itemid bigint NULL, flags integer DEFAULT '0' NOT NULL, discover integer DEFAULT '0' NOT NULL, uuid varchar(32) DEFAULT '' NOT NULL, PRIMARY KEY (graphid) ); 2023-01-04 09:31:01.001 CET zabbix zabbix [14928]ERROR: relation "graphs_1" already exists 2023-01-04 09:31:01.001 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX graphs_1 ON graphs (name); 2023-01-04 09:31:01.001 CET zabbix zabbix [14928]ERROR: relation "graphs_2" already exists 2023-01-04 09:31:01.001 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX graphs_2 ON graphs (templateid); 2023-01-04 09:31:01.001 CET zabbix zabbix [14928]ERROR: relation "graphs_3" already exists 2023-01-04 09:31:01.001 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX graphs_3 ON graphs (ymin_itemid); 2023-01-04 09:31:01.001 CET zabbix zabbix [14928]ERROR: relation "graphs_4" already exists 2023-01-04 09:31:01.001 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX graphs_4 ON graphs (ymax_itemid); 2023-01-04 09:31:01.001 CET zabbix zabbix [14928]ERROR: relation "graphs_items" already exists 2023-01-04 09:31:01.001 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE graphs_items ( gitemid bigint NOT NULL, graphid bigint NOT NULL, itemid bigint NOT NULL, drawtype integer DEFAULT '0' NOT NULL, sortorder integer DEFAULT '0' NOT NULL, color varchar(6) DEFAULT '009600' NOT NULL, yaxisside integer DEFAULT '0' NOT NULL, calc_fnc integer DEFAULT '2' NOT NULL, type integer DEFAULT '0' NOT NULL, PRIMARY KEY (gitemid) ); 2023-01-04 09:31:01.002 CET zabbix zabbix [14928]ERROR: relation "graphs_items_1" already exists 2023-01-04 09:31:01.002 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX graphs_items_1 ON graphs_items (itemid); 2023-01-04 09:31:01.002 CET zabbix zabbix [14928]ERROR: relation "graphs_items_2" already exists 2023-01-04 09:31:01.002 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX graphs_items_2 ON graphs_items (graphid); 2023-01-04 09:31:01.002 CET zabbix zabbix [14928]ERROR: relation "graph_theme" already exists 2023-01-04 09:31:01.002 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE graph_theme ( graphthemeid bigint NOT NULL, theme varchar(64) DEFAULT '' NOT NULL, backgroundcolor varchar(6) DEFAULT '' NOT NULL, graphcolor varchar(6) DEFAULT '' NOT NULL, gridcolor varchar(6) DEFAULT '' NOT NULL, maingridcolor varchar(6) DEFAULT '' NOT NULL, gridbordercolor varchar(6) DEFAULT '' NOT NULL, textcolor varchar(6) DEFAULT '' NOT NULL, highlightcolor varchar(6) DEFAULT '' NOT NULL, leftpercentilecolor varchar(6) DEFAULT '' NOT NULL, rightpercentilecolor varchar(6) DEFAULT '' NOT NULL, nonworktimecolor varchar(6) DEFAULT '' NOT NULL, colorpalette varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (graphthemeid) ); 2023-01-04 09:31:01.002 CET zabbix zabbix [14928]ERROR: relation "graph_theme_1" already exists 2023-01-04 09:31:01.002 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX graph_theme_1 ON graph_theme (theme); 2023-01-04 09:31:01.002 CET zabbix zabbix [14928]ERROR: relation "globalmacro" already exists 2023-01-04 09:31:01.002 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE globalmacro ( globalmacroid bigint NOT NULL, macro varchar(255) DEFAULT '' NOT NULL, value varchar(2048) DEFAULT '' NOT NULL, description text DEFAULT '' NOT NULL, type integer DEFAULT '0' NOT NULL, PRIMARY KEY (globalmacroid) ); 2023-01-04 09:31:01.002 CET zabbix zabbix [14928]ERROR: relation "globalmacro_1" already exists 2023-01-04 09:31:01.002 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX globalmacro_1 ON globalmacro (macro); 2023-01-04 09:31:01.002 CET zabbix zabbix [14928]ERROR: relation "hostmacro" already exists 2023-01-04 09:31:01.002 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE hostmacro ( hostmacroid bigint NOT NULL, hostid bigint NOT NULL, macro varchar(255) DEFAULT '' NOT NULL, value varchar(2048) DEFAULT '' NOT NULL, description text DEFAULT '' NOT NULL, type integer DEFAULT '0' NOT NULL, automatic integer DEFAULT '0' NOT NULL, PRIMARY KEY (hostmacroid) ); 2023-01-04 09:31:01.003 CET zabbix zabbix [14928]ERROR: relation "hostmacro_1" already exists 2023-01-04 09:31:01.003 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX hostmacro_1 ON hostmacro (hostid,macro); 2023-01-04 09:31:01.003 CET zabbix zabbix [14928]ERROR: relation "hosts_groups" already exists 2023-01-04 09:31:01.003 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE hosts_groups ( hostgroupid bigint NOT NULL, hostid bigint NOT NULL, groupid bigint NOT NULL, PRIMARY KEY (hostgroupid) ); 2023-01-04 09:31:01.003 CET zabbix zabbix [14928]ERROR: relation "hosts_groups_1" already exists 2023-01-04 09:31:01.003 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX hosts_groups_1 ON hosts_groups (hostid,groupid); 2023-01-04 09:31:01.003 CET zabbix zabbix [14928]ERROR: relation "hosts_groups_2" already exists 2023-01-04 09:31:01.003 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX hosts_groups_2 ON hosts_groups (groupid); 2023-01-04 09:31:01.003 CET zabbix zabbix [14928]ERROR: relation "hosts_templates" already exists 2023-01-04 09:31:01.003 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE hosts_templates ( hosttemplateid bigint NOT NULL, hostid bigint NOT NULL, templateid bigint NOT NULL, link_type integer DEFAULT '0' NOT NULL, PRIMARY KEY (hosttemplateid) ); 2023-01-04 09:31:01.003 CET zabbix zabbix [14928]ERROR: relation "hosts_templates_1" already exists 2023-01-04 09:31:01.003 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX hosts_templates_1 ON hosts_templates (hostid,templateid); 2023-01-04 09:31:01.003 CET zabbix zabbix [14928]ERROR: relation "hosts_templates_2" already exists 2023-01-04 09:31:01.003 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX hosts_templates_2 ON hosts_templates (templateid); 2023-01-04 09:31:01.004 CET zabbix zabbix [14928]ERROR: relation "valuemap_mapping" already exists 2023-01-04 09:31:01.004 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE valuemap_mapping ( valuemap_mappingid bigint NOT NULL, valuemapid bigint NOT NULL, value varchar(64) DEFAULT '' NOT NULL, newvalue varchar(64) DEFAULT '' NOT NULL, type integer DEFAULT '0' NOT NULL, sortorder integer DEFAULT '0' NOT NULL, PRIMARY KEY (valuemap_mappingid) ); 2023-01-04 09:31:01.004 CET zabbix zabbix [14928]ERROR: relation "valuemap_mapping_1" already exists 2023-01-04 09:31:01.004 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX valuemap_mapping_1 ON valuemap_mapping (valuemapid,value,type); 2023-01-04 09:31:01.004 CET zabbix zabbix [14928]ERROR: relation "media" already exists 2023-01-04 09:31:01.004 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE media ( mediaid bigint NOT NULL, userid bigint NOT NULL, mediatypeid bigint NOT NULL, sendto varchar(1024) DEFAULT '' NOT NULL, active integer DEFAULT '0' NOT NULL, severity integer DEFAULT '63' NOT NULL, period varchar(1024) DEFAULT '1-7,00:00-24:00' NOT NULL, PRIMARY KEY (mediaid) ); 2023-01-04 09:31:01.004 CET zabbix zabbix [14928]ERROR: relation "media_1" already exists 2023-01-04 09:31:01.004 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX media_1 ON media (userid); 2023-01-04 09:31:01.004 CET zabbix zabbix [14928]ERROR: relation "media_2" already exists 2023-01-04 09:31:01.004 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX media_2 ON media (mediatypeid); 2023-01-04 09:31:01.004 CET zabbix zabbix [14928]ERROR: relation "rights" already exists 2023-01-04 09:31:01.004 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE rights ( rightid bigint NOT NULL, groupid bigint NOT NULL, permission integer DEFAULT '0' NOT NULL, id bigint NOT NULL, PRIMARY KEY (rightid) ); 2023-01-04 09:31:01.004 CET zabbix zabbix [14928]ERROR: relation "rights_1" already exists 2023-01-04 09:31:01.004 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX rights_1 ON rights (groupid); 2023-01-04 09:31:01.005 CET zabbix zabbix [14928]ERROR: relation "rights_2" already exists 2023-01-04 09:31:01.005 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX rights_2 ON rights (id); 2023-01-04 09:31:01.005 CET zabbix zabbix [14928]ERROR: relation "services" already exists 2023-01-04 09:31:01.005 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE services ( serviceid bigint NOT NULL, name varchar(128) DEFAULT '' NOT NULL, status integer DEFAULT '-1' NOT NULL, algorithm integer DEFAULT '0' NOT NULL, sortorder integer DEFAULT '0' NOT NULL, weight integer DEFAULT '0' NOT NULL, propagation_rule integer DEFAULT '0' NOT NULL, propagation_value integer DEFAULT '0' NOT NULL, description text DEFAULT '' NOT NULL, uuid varchar(32) DEFAULT '' NOT NULL, created_at integer DEFAULT '0' NOT NULL, PRIMARY KEY (serviceid) ); 2023-01-04 09:31:01.005 CET zabbix zabbix [14928]ERROR: relation "services_links" already exists 2023-01-04 09:31:01.005 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE services_links ( linkid bigint NOT NULL, serviceupid bigint NOT NULL, servicedownid bigint NOT NULL, PRIMARY KEY (linkid) ); 2023-01-04 09:31:01.005 CET zabbix zabbix [14928]ERROR: relation "services_links_1" already exists 2023-01-04 09:31:01.005 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX services_links_1 ON services_links (servicedownid); 2023-01-04 09:31:01.005 CET zabbix zabbix [14928]ERROR: relation "services_links_2" already exists 2023-01-04 09:31:01.005 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX services_links_2 ON services_links (serviceupid,servicedownid); 2023-01-04 09:31:01.005 CET zabbix zabbix [14928]ERROR: relation "icon_map" already exists 2023-01-04 09:31:01.005 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE icon_map ( iconmapid bigint NOT NULL, name varchar(64) DEFAULT '' NOT NULL, default_iconid bigint NOT NULL, PRIMARY KEY (iconmapid) ); 2023-01-04 09:31:01.005 CET zabbix zabbix [14928]ERROR: relation "icon_map_1" already exists 2023-01-04 09:31:01.005 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX icon_map_1 ON icon_map (name); 2023-01-04 09:31:01.006 CET zabbix zabbix [14928]ERROR: relation "icon_map_2" already exists 2023-01-04 09:31:01.006 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX icon_map_2 ON icon_map (default_iconid); 2023-01-04 09:31:01.006 CET zabbix zabbix [14928]ERROR: relation "icon_mapping" already exists 2023-01-04 09:31:01.006 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE icon_mapping ( iconmappingid bigint NOT NULL, iconmapid bigint NOT NULL, iconid bigint NOT NULL, inventory_link integer DEFAULT '0' NOT NULL, expression varchar(64) DEFAULT '' NOT NULL, sortorder integer DEFAULT '0' NOT NULL, PRIMARY KEY (iconmappingid) ); 2023-01-04 09:31:01.006 CET zabbix zabbix [14928]ERROR: relation "icon_mapping_1" already exists 2023-01-04 09:31:01.006 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX icon_mapping_1 ON icon_mapping (iconmapid); 2023-01-04 09:31:01.006 CET zabbix zabbix [14928]ERROR: relation "icon_mapping_2" already exists 2023-01-04 09:31:01.006 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX icon_mapping_2 ON icon_mapping (iconid); 2023-01-04 09:31:01.006 CET zabbix zabbix [14928]ERROR: relation "sysmaps" already exists 2023-01-04 09:31:01.006 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE sysmaps ( sysmapid bigint NOT NULL, name varchar(128) DEFAULT '' NOT NULL, width integer DEFAULT '600' NOT NULL, height integer DEFAULT '400' NOT NULL, backgroundid bigint NULL, label_type integer DEFAULT '2' NOT NULL, label_location integer DEFAULT '0' NOT NULL, highlight integer DEFAULT '1' NOT NULL, expandproblem integer DEFAULT '1' NOT NULL, markelements integer DEFAULT '0' NOT NULL, show_unack integer DEFAULT '0' NOT NULL, grid_size integer DEFAULT '50' NOT NULL, grid_show integer DEFAULT '1' NOT NULL, grid_align integer DEFAULT '1' NOT NULL, label_format integer DEFAULT '0' NOT NULL, label_type_host integer DEFAULT '2' NOT NULL, label_type_hostgroup integer DEFAULT '2' NOT NULL, label_type_trigger integer DEFAULT '2' NOT NULL, label_type_map integer DEFAULT '2' NOT NULL, label_type_image integer DEFAULT '2' NOT NULL, label_string_host varchar(255) DEFAULT '' NOT NULL, label_string_hostgroup varchar(255) DEFAULT '' NOT NULL, label_string_trigger varchar(255) DEFAULT '' NOT NULL, label_string_map varchar(255) DEFAULT '' NOT NULL, label_string_image varchar(255) DEFAULT '' NOT NULL, iconmapid bigint NULL, expand_macros integer DEFAULT '0' NOT NULL, severity_min integer DEFAULT '0' NOT NULL, userid bigint NOT NULL, private integer DEFAULT '1' NOT NULL, show_suppressed integer DEFAULT '0' NOT NULL, PRIMARY KEY (sysmapid) ); 2023-01-04 09:31:01.006 CET zabbix zabbix [14928]ERROR: relation "sysmaps_1" already exists 2023-01-04 09:31:01.006 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX sysmaps_1 ON sysmaps (name); 2023-01-04 09:31:01.006 CET zabbix zabbix [14928]ERROR: relation "sysmaps_2" already exists 2023-01-04 09:31:01.006 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX sysmaps_2 ON sysmaps (backgroundid); 2023-01-04 09:31:01.007 CET zabbix zabbix [14928]ERROR: relation "sysmaps_3" already exists 2023-01-04 09:31:01.007 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX sysmaps_3 ON sysmaps (iconmapid); 2023-01-04 09:31:01.007 CET zabbix zabbix [14928]ERROR: relation "sysmaps_elements" already exists 2023-01-04 09:31:01.007 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE sysmaps_elements ( selementid bigint NOT NULL, sysmapid bigint NOT NULL, elementid bigint DEFAULT '0' NOT NULL, elementtype integer DEFAULT '0' NOT NULL, iconid_off bigint NULL, iconid_on bigint NULL, label varchar(2048) DEFAULT '' NOT NULL, label_location integer DEFAULT '-1' NOT NULL, x integer DEFAULT '0' NOT NULL, y integer DEFAULT '0' NOT NULL, iconid_disabled bigint NULL, iconid_maintenance bigint NULL, elementsubtype integer DEFAULT '0' NOT NULL, areatype integer DEFAULT '0' NOT NULL, width integer DEFAULT '200' NOT NULL, height integer DEFAULT '200' NOT NULL, viewtype integer DEFAULT '0' NOT NULL, use_iconmap integer DEFAULT '1' NOT NULL, evaltype integer DEFAULT '0' NOT NULL, PRIMARY KEY (selementid) ); 2023-01-04 09:31:01.007 CET zabbix zabbix [14928]ERROR: relation "sysmaps_elements_1" already exists 2023-01-04 09:31:01.007 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX sysmaps_elements_1 ON sysmaps_elements (sysmapid); 2023-01-04 09:31:01.007 CET zabbix zabbix [14928]ERROR: relation "sysmaps_elements_2" already exists 2023-01-04 09:31:01.007 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX sysmaps_elements_2 ON sysmaps_elements (iconid_off); 2023-01-04 09:31:01.007 CET zabbix zabbix [14928]ERROR: relation "sysmaps_elements_3" already exists 2023-01-04 09:31:01.007 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX sysmaps_elements_3 ON sysmaps_elements (iconid_on); 2023-01-04 09:31:01.007 CET zabbix zabbix [14928]ERROR: relation "sysmaps_elements_4" already exists 2023-01-04 09:31:01.007 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX sysmaps_elements_4 ON sysmaps_elements (iconid_disabled); 2023-01-04 09:31:01.008 CET zabbix zabbix [14928]ERROR: relation "sysmaps_elements_5" already exists 2023-01-04 09:31:01.008 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX sysmaps_elements_5 ON sysmaps_elements (iconid_maintenance); 2023-01-04 09:31:01.008 CET zabbix zabbix [14928]ERROR: relation "sysmaps_links" already exists 2023-01-04 09:31:01.008 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE sysmaps_links ( linkid bigint NOT NULL, sysmapid bigint NOT NULL, selementid1 bigint NOT NULL, selementid2 bigint NOT NULL, drawtype integer DEFAULT '0' NOT NULL, color varchar(6) DEFAULT '000000' NOT NULL, label varchar(2048) DEFAULT '' NOT NULL, PRIMARY KEY (linkid) ); 2023-01-04 09:31:01.008 CET zabbix zabbix [14928]ERROR: relation "sysmaps_links_1" already exists 2023-01-04 09:31:01.008 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX sysmaps_links_1 ON sysmaps_links (sysmapid); 2023-01-04 09:31:01.008 CET zabbix zabbix [14928]ERROR: relation "sysmaps_links_2" already exists 2023-01-04 09:31:01.008 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX sysmaps_links_2 ON sysmaps_links (selementid1); 2023-01-04 09:31:01.009 CET zabbix zabbix [14928]ERROR: relation "sysmaps_links_3" already exists 2023-01-04 09:31:01.009 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX sysmaps_links_3 ON sysmaps_links (selementid2); 2023-01-04 09:31:01.009 CET zabbix zabbix [14928]ERROR: relation "sysmaps_link_triggers" already exists 2023-01-04 09:31:01.009 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE sysmaps_link_triggers ( linktriggerid bigint NOT NULL, linkid bigint NOT NULL, triggerid bigint NOT NULL, drawtype integer DEFAULT '0' NOT NULL, color varchar(6) DEFAULT '000000' NOT NULL, PRIMARY KEY (linktriggerid) ); 2023-01-04 09:31:01.013 CET zabbix zabbix [14928]ERROR: relation "sysmaps_link_triggers_1" already exists 2023-01-04 09:31:01.013 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX sysmaps_link_triggers_1 ON sysmaps_link_triggers (linkid,triggerid); 2023-01-04 09:31:01.013 CET zabbix zabbix [14928]ERROR: relation "sysmaps_link_triggers_2" already exists 2023-01-04 09:31:01.013 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX sysmaps_link_triggers_2 ON sysmaps_link_triggers (triggerid); 2023-01-04 09:31:01.013 CET zabbix zabbix [14928]ERROR: relation "sysmap_element_url" already exists 2023-01-04 09:31:01.013 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE sysmap_element_url ( sysmapelementurlid bigint NOT NULL, selementid bigint NOT NULL, name varchar(255) NOT NULL, url varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (sysmapelementurlid) ); 2023-01-04 09:31:01.014 CET zabbix zabbix [14928]ERROR: relation "sysmap_element_url_1" already exists 2023-01-04 09:31:01.014 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX sysmap_element_url_1 ON sysmap_element_url (selementid,name); 2023-01-04 09:31:01.014 CET zabbix zabbix [14928]ERROR: relation "sysmap_url" already exists 2023-01-04 09:31:01.014 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE sysmap_url ( sysmapurlid bigint NOT NULL, sysmapid bigint NOT NULL, name varchar(255) NOT NULL, url varchar(255) DEFAULT '' NOT NULL, elementtype integer DEFAULT '0' NOT NULL, PRIMARY KEY (sysmapurlid) ); 2023-01-04 09:31:01.014 CET zabbix zabbix [14928]ERROR: relation "sysmap_url_1" already exists 2023-01-04 09:31:01.014 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX sysmap_url_1 ON sysmap_url (sysmapid,name); 2023-01-04 09:31:01.014 CET zabbix zabbix [14928]ERROR: relation "sysmap_user" already exists 2023-01-04 09:31:01.014 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE sysmap_user ( sysmapuserid bigint NOT NULL, sysmapid bigint NOT NULL, userid bigint NOT NULL, permission integer DEFAULT '2' NOT NULL, PRIMARY KEY (sysmapuserid) ); 2023-01-04 09:31:01.015 CET zabbix zabbix [14928]ERROR: relation "sysmap_user_1" already exists 2023-01-04 09:31:01.015 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX sysmap_user_1 ON sysmap_user (sysmapid,userid); 2023-01-04 09:31:01.015 CET zabbix zabbix [14928]ERROR: relation "sysmap_usrgrp" already exists 2023-01-04 09:31:01.015 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE sysmap_usrgrp ( sysmapusrgrpid bigint NOT NULL, sysmapid bigint NOT NULL, usrgrpid bigint NOT NULL, permission integer DEFAULT '2' NOT NULL, PRIMARY KEY (sysmapusrgrpid) ); 2023-01-04 09:31:01.015 CET zabbix zabbix [14928]ERROR: relation "sysmap_usrgrp_1" already exists 2023-01-04 09:31:01.015 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX sysmap_usrgrp_1 ON sysmap_usrgrp (sysmapid,usrgrpid); 2023-01-04 09:31:01.015 CET zabbix zabbix [14928]ERROR: relation "maintenances_hosts" already exists 2023-01-04 09:31:01.015 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE maintenances_hosts ( maintenance_hostid bigint NOT NULL, maintenanceid bigint NOT NULL, hostid bigint NOT NULL, PRIMARY KEY (maintenance_hostid) ); 2023-01-04 09:31:01.016 CET zabbix zabbix [14928]ERROR: relation "maintenances_hosts_1" already exists 2023-01-04 09:31:01.016 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX maintenances_hosts_1 ON maintenances_hosts (maintenanceid,hostid); 2023-01-04 09:31:01.016 CET zabbix zabbix [14928]ERROR: relation "maintenances_hosts_2" already exists 2023-01-04 09:31:01.016 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX maintenances_hosts_2 ON maintenances_hosts (hostid); 2023-01-04 09:31:01.016 CET zabbix zabbix [14928]ERROR: relation "maintenances_groups" already exists 2023-01-04 09:31:01.016 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE maintenances_groups ( maintenance_groupid bigint NOT NULL, maintenanceid bigint NOT NULL, groupid bigint NOT NULL, PRIMARY KEY (maintenance_groupid) ); 2023-01-04 09:31:01.016 CET zabbix zabbix [14928]ERROR: relation "maintenances_groups_1" already exists 2023-01-04 09:31:01.016 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX maintenances_groups_1 ON maintenances_groups (maintenanceid,groupid); 2023-01-04 09:31:01.016 CET zabbix zabbix [14928]ERROR: relation "maintenances_groups_2" already exists 2023-01-04 09:31:01.016 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX maintenances_groups_2 ON maintenances_groups (groupid); 2023-01-04 09:31:01.017 CET zabbix zabbix [14928]ERROR: relation "timeperiods" already exists 2023-01-04 09:31:01.017 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE timeperiods ( timeperiodid bigint NOT NULL, timeperiod_type integer DEFAULT '0' NOT NULL, every integer DEFAULT '1' NOT NULL, month integer DEFAULT '0' NOT NULL, dayofweek integer DEFAULT '0' NOT NULL, day integer DEFAULT '0' NOT NULL, start_time integer DEFAULT '0' NOT NULL, period integer DEFAULT '0' NOT NULL, start_date integer DEFAULT '0' NOT NULL, PRIMARY KEY (timeperiodid) ); 2023-01-04 09:31:01.017 CET zabbix zabbix [14928]ERROR: relation "maintenances_windows" already exists 2023-01-04 09:31:01.017 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE maintenances_windows ( maintenance_timeperiodid bigint NOT NULL, maintenanceid bigint NOT NULL, timeperiodid bigint NOT NULL, PRIMARY KEY (maintenance_timeperiodid) ); 2023-01-04 09:31:01.017 CET zabbix zabbix [14928]ERROR: relation "maintenances_windows_1" already exists 2023-01-04 09:31:01.017 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX maintenances_windows_1 ON maintenances_windows (maintenanceid,timeperiodid); 2023-01-04 09:31:01.017 CET zabbix zabbix [14928]ERROR: relation "maintenances_windows_2" already exists 2023-01-04 09:31:01.017 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX maintenances_windows_2 ON maintenances_windows (timeperiodid); 2023-01-04 09:31:01.017 CET zabbix zabbix [14928]ERROR: relation "regexps" already exists 2023-01-04 09:31:01.017 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE regexps ( regexpid bigint NOT NULL, name varchar(128) DEFAULT '' NOT NULL, test_string text DEFAULT '' NOT NULL, PRIMARY KEY (regexpid) ); 2023-01-04 09:31:01.017 CET zabbix zabbix [14928]ERROR: relation "regexps_1" already exists 2023-01-04 09:31:01.017 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX regexps_1 ON regexps (name); 2023-01-04 09:31:01.017 CET zabbix zabbix [14928]ERROR: relation "expressions" already exists 2023-01-04 09:31:01.017 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE expressions ( expressionid bigint NOT NULL, regexpid bigint NOT NULL, expression varchar(255) DEFAULT '' NOT NULL, expression_type integer DEFAULT '0' NOT NULL, exp_delimiter varchar(1) DEFAULT '' NOT NULL, case_sensitive integer DEFAULT '0' NOT NULL, PRIMARY KEY (expressionid) ); 2023-01-04 09:31:01.018 CET zabbix zabbix [14928]ERROR: relation "expressions_1" already exists 2023-01-04 09:31:01.018 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX expressions_1 ON expressions (regexpid); 2023-01-04 09:31:01.018 CET zabbix zabbix [14928]ERROR: relation "ids" already exists 2023-01-04 09:31:01.018 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE ids ( table_name varchar(64) DEFAULT '' NOT NULL, field_name varchar(64) DEFAULT '' NOT NULL, nextid bigint NOT NULL, PRIMARY KEY (table_name,field_name) ); 2023-01-04 09:31:01.018 CET zabbix zabbix [14928]ERROR: relation "alerts" already exists 2023-01-04 09:31:01.018 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE alerts ( alertid bigint NOT NULL, actionid bigint NOT NULL, eventid bigint NOT NULL, userid bigint NULL, clock integer DEFAULT '0' NOT NULL, mediatypeid bigint NULL, sendto varchar(1024) DEFAULT '' NOT NULL, subject varchar(255) DEFAULT '' NOT NULL, message text DEFAULT '' NOT NULL, status integer DEFAULT '0' NOT NULL, retries integer DEFAULT '0' NOT NULL, error varchar(2048) DEFAULT '' NOT NULL, esc_step integer DEFAULT '0' NOT NULL, alerttype integer DEFAULT '0' NOT NULL, p_eventid bigint NULL, acknowledgeid bigint NULL, parameters text DEFAULT '{}' NOT NULL, PRIMARY KEY (alertid) ); 2023-01-04 09:31:01.018 CET zabbix zabbix [14928]ERROR: relation "alerts_1" already exists 2023-01-04 09:31:01.018 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX alerts_1 ON alerts (actionid); 2023-01-04 09:31:01.018 CET zabbix zabbix [14928]ERROR: relation "alerts_2" already exists 2023-01-04 09:31:01.018 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX alerts_2 ON alerts (clock); 2023-01-04 09:31:01.018 CET zabbix zabbix [14928]ERROR: relation "alerts_3" already exists 2023-01-04 09:31:01.018 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX alerts_3 ON alerts (eventid); 2023-01-04 09:31:01.018 CET zabbix zabbix [14928]ERROR: relation "alerts_4" already exists 2023-01-04 09:31:01.018 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX alerts_4 ON alerts (status); 2023-01-04 09:31:01.019 CET zabbix zabbix [14928]ERROR: relation "alerts_5" already exists 2023-01-04 09:31:01.019 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX alerts_5 ON alerts (mediatypeid); 2023-01-04 09:31:01.019 CET zabbix zabbix [14928]ERROR: relation "alerts_6" already exists 2023-01-04 09:31:01.019 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX alerts_6 ON alerts (userid); 2023-01-04 09:31:01.019 CET zabbix zabbix [14928]ERROR: relation "alerts_7" already exists 2023-01-04 09:31:01.019 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX alerts_7 ON alerts (p_eventid); 2023-01-04 09:31:01.019 CET zabbix zabbix [14928]ERROR: relation "alerts_8" already exists 2023-01-04 09:31:01.019 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX alerts_8 ON alerts (acknowledgeid); 2023-01-04 09:31:01.019 CET zabbix zabbix [14928]ERROR: relation "history" already exists 2023-01-04 09:31:01.019 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE history ( itemid bigint NOT NULL, clock integer DEFAULT '0' NOT NULL, value DOUBLE PRECISION DEFAULT '0.0000' NOT NULL, ns integer DEFAULT '0' NOT NULL, PRIMARY KEY (itemid,clock,ns) ); 2023-01-04 09:31:01.019 CET zabbix zabbix [14928]ERROR: relation "history_uint" already exists 2023-01-04 09:31:01.019 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE history_uint ( itemid bigint NOT NULL, clock integer DEFAULT '0' NOT NULL, value numeric(20) DEFAULT '0' NOT NULL, ns integer DEFAULT '0' NOT NULL, PRIMARY KEY (itemid,clock,ns) ); 2023-01-04 09:31:01.019 CET zabbix zabbix [14928]ERROR: relation "history_str" already exists 2023-01-04 09:31:01.019 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE history_str ( itemid bigint NOT NULL, clock integer DEFAULT '0' NOT NULL, value varchar(255) DEFAULT '' NOT NULL, ns integer DEFAULT '0' NOT NULL, PRIMARY KEY (itemid,clock,ns) ); 2023-01-04 09:31:01.019 CET zabbix zabbix [14928]ERROR: relation "history_log" already exists 2023-01-04 09:31:01.019 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE history_log ( itemid bigint NOT NULL, clock integer DEFAULT '0' NOT NULL, timestamp integer DEFAULT '0' NOT NULL, source varchar(64) DEFAULT '' NOT NULL, severity integer DEFAULT '0' NOT NULL, value text DEFAULT '' NOT NULL, logeventid integer DEFAULT '0' NOT NULL, ns integer DEFAULT '0' NOT NULL, PRIMARY KEY (itemid,clock,ns) ); 2023-01-04 09:31:01.020 CET zabbix zabbix [14928]ERROR: relation "history_text" already exists 2023-01-04 09:31:01.020 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE history_text ( itemid bigint NOT NULL, clock integer DEFAULT '0' NOT NULL, value text DEFAULT '' NOT NULL, ns integer DEFAULT '0' NOT NULL, PRIMARY KEY (itemid,clock,ns) ); 2023-01-04 09:31:01.041 CET zabbix zabbix [14928]ERROR: relation "proxy_history" already exists 2023-01-04 09:31:01.041 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE proxy_history ( id bigserial NOT NULL, itemid bigint NOT NULL, clock integer DEFAULT '0' NOT NULL, timestamp integer DEFAULT '0' NOT NULL, source varchar(64) DEFAULT '' NOT NULL, severity integer DEFAULT '0' NOT NULL, value text DEFAULT '' NOT NULL, logeventid integer DEFAULT '0' NOT NULL, ns integer DEFAULT '0' NOT NULL, state integer DEFAULT '0' NOT NULL, lastlogsize numeric(20) DEFAULT '0' NOT NULL, mtime integer DEFAULT '0' NOT NULL, flags integer DEFAULT '0' NOT NULL, write_clock integer DEFAULT '0' NOT NULL, PRIMARY KEY (id) ); 2023-01-04 09:31:01.045 CET zabbix zabbix [14928]ERROR: relation "proxy_history_1" already exists 2023-01-04 09:31:01.045 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX proxy_history_1 ON proxy_history (clock); 2023-01-04 09:31:01.046 CET zabbix zabbix [14928]ERROR: relation "proxy_dhistory" already exists 2023-01-04 09:31:01.046 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE proxy_dhistory ( id bigserial NOT NULL, clock integer DEFAULT '0' NOT NULL, druleid bigint NOT NULL, ip varchar(39) DEFAULT '' NOT NULL, port integer DEFAULT '0' NOT NULL, value varchar(255) DEFAULT '' NOT NULL, status integer DEFAULT '0' NOT NULL, dcheckid bigint NULL, dns varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (id) ); 2023-01-04 09:31:01.047 CET zabbix zabbix [14928]ERROR: relation "proxy_dhistory_1" already exists 2023-01-04 09:31:01.047 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX proxy_dhistory_1 ON proxy_dhistory (clock); 2023-01-04 09:31:01.047 CET zabbix zabbix [14928]ERROR: relation "proxy_dhistory_2" already exists 2023-01-04 09:31:01.047 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX proxy_dhistory_2 ON proxy_dhistory (druleid); 2023-01-04 09:31:01.047 CET zabbix zabbix [14928]ERROR: relation "events" already exists 2023-01-04 09:31:01.047 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE events ( eventid bigint NOT NULL, source integer DEFAULT '0' NOT NULL, object integer DEFAULT '0' NOT NULL, objectid bigint DEFAULT '0' NOT NULL, clock integer DEFAULT '0' NOT NULL, value integer DEFAULT '0' NOT NULL, acknowledged integer DEFAULT '0' NOT NULL, ns integer DEFAULT '0' NOT NULL, name varchar(2048) DEFAULT '' NOT NULL, severity integer DEFAULT '0' NOT NULL, PRIMARY KEY (eventid) ); 2023-01-04 09:31:01.048 CET zabbix zabbix [14928]ERROR: relation "events_1" already exists 2023-01-04 09:31:01.048 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX events_1 ON events (source,object,objectid,clock); 2023-01-04 09:31:01.048 CET zabbix zabbix [14928]ERROR: relation "events_2" already exists 2023-01-04 09:31:01.048 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX events_2 ON events (source,object,clock); 2023-01-04 09:31:01.048 CET zabbix zabbix [14928]ERROR: relation "trends" already exists 2023-01-04 09:31:01.048 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE trends ( itemid bigint NOT NULL, clock integer DEFAULT '0' NOT NULL, num integer DEFAULT '0' NOT NULL, value_min DOUBLE PRECISION DEFAULT '0.0000' NOT NULL, value_avg DOUBLE PRECISION DEFAULT '0.0000' NOT NULL, value_max DOUBLE PRECISION DEFAULT '0.0000' NOT NULL, PRIMARY KEY (itemid,clock) ); 2023-01-04 09:31:01.048 CET zabbix zabbix [14928]ERROR: relation "trends_uint" already exists 2023-01-04 09:31:01.048 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE trends_uint ( itemid bigint NOT NULL, clock integer DEFAULT '0' NOT NULL, num integer DEFAULT '0' NOT NULL, value_min numeric(20) DEFAULT '0' NOT NULL, value_avg numeric(20) DEFAULT '0' NOT NULL, value_max numeric(20) DEFAULT '0' NOT NULL, PRIMARY KEY (itemid,clock) ); 2023-01-04 09:31:01.049 CET zabbix zabbix [14928]ERROR: relation "acknowledges" already exists 2023-01-04 09:31:01.049 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE acknowledges ( acknowledgeid bigint NOT NULL, userid bigint NOT NULL, eventid bigint NOT NULL, clock integer DEFAULT '0' NOT NULL, message varchar(2048) DEFAULT '' NOT NULL, action integer DEFAULT '0' NOT NULL, old_severity integer DEFAULT '0' NOT NULL, new_severity integer DEFAULT '0' NOT NULL, suppress_until integer DEFAULT '0' NOT NULL, PRIMARY KEY (acknowledgeid) ); 2023-01-04 09:31:01.053 CET zabbix zabbix [14928]ERROR: relation "acknowledges_1" already exists 2023-01-04 09:31:01.053 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX acknowledges_1 ON acknowledges (userid); 2023-01-04 09:31:01.053 CET zabbix zabbix [14928]ERROR: relation "acknowledges_2" already exists 2023-01-04 09:31:01.053 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX acknowledges_2 ON acknowledges (eventid); 2023-01-04 09:31:01.054 CET zabbix zabbix [14928]ERROR: relation "acknowledges_3" already exists 2023-01-04 09:31:01.054 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX acknowledges_3 ON acknowledges (clock); 2023-01-04 09:31:01.057 CET zabbix zabbix [14928]ERROR: relation "auditlog" already exists 2023-01-04 09:31:01.057 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE auditlog ( auditid varchar(25) NOT NULL, userid bigint NULL, username varchar(100) DEFAULT '' NOT NULL, clock integer DEFAULT '0' NOT NULL, ip varchar(39) DEFAULT '' NOT NULL, action integer DEFAULT '0' NOT NULL, resourcetype integer DEFAULT '0' NOT NULL, resourceid bigint NULL, resource_cuid varchar(25) NULL, resourcename varchar(255) DEFAULT '' NOT NULL, recordsetid varchar(25) NOT NULL, details text DEFAULT '' NOT NULL, PRIMARY KEY (auditid) ); 2023-01-04 09:31:01.058 CET zabbix zabbix [14928]ERROR: relation "auditlog_1" already exists 2023-01-04 09:31:01.058 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX auditlog_1 ON auditlog (userid,clock); 2023-01-04 09:31:01.058 CET zabbix zabbix [14928]ERROR: relation "auditlog_2" already exists 2023-01-04 09:31:01.058 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX auditlog_2 ON auditlog (clock); 2023-01-04 09:31:01.059 CET zabbix zabbix [14928]ERROR: relation "auditlog_3" already exists 2023-01-04 09:31:01.059 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX auditlog_3 ON auditlog (resourcetype,resourceid); 2023-01-04 09:31:01.059 CET zabbix zabbix [14928]ERROR: relation "service_alarms" already exists 2023-01-04 09:31:01.059 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE service_alarms ( servicealarmid bigint NOT NULL, serviceid bigint NOT NULL, clock integer DEFAULT '0' NOT NULL, value integer DEFAULT '-1' NOT NULL, PRIMARY KEY (servicealarmid) ); 2023-01-04 09:31:01.059 CET zabbix zabbix [14928]ERROR: relation "service_alarms_1" already exists 2023-01-04 09:31:01.059 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX service_alarms_1 ON service_alarms (serviceid,clock); 2023-01-04 09:31:01.059 CET zabbix zabbix [14928]ERROR: relation "service_alarms_2" already exists 2023-01-04 09:31:01.059 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX service_alarms_2 ON service_alarms (clock); 2023-01-04 09:31:01.059 CET zabbix zabbix [14928]ERROR: relation "autoreg_host" already exists 2023-01-04 09:31:01.059 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE autoreg_host ( autoreg_hostid bigint NOT NULL, proxy_hostid bigint NULL, host varchar(128) DEFAULT '' NOT NULL, listen_ip varchar(39) DEFAULT '' NOT NULL, listen_port integer DEFAULT '0' NOT NULL, listen_dns varchar(255) DEFAULT '' NOT NULL, host_metadata varchar(255) DEFAULT '' NOT NULL, flags integer DEFAULT '0' NOT NULL, tls_accepted integer DEFAULT '1' NOT NULL, PRIMARY KEY (autoreg_hostid) ); 2023-01-04 09:31:01.059 CET zabbix zabbix [14928]ERROR: relation "autoreg_host_1" already exists 2023-01-04 09:31:01.059 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX autoreg_host_1 ON autoreg_host (host); 2023-01-04 09:31:01.060 CET zabbix zabbix [14928]ERROR: relation "autoreg_host_2" already exists 2023-01-04 09:31:01.060 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX autoreg_host_2 ON autoreg_host (proxy_hostid); 2023-01-04 09:31:01.060 CET zabbix zabbix [14928]ERROR: relation "proxy_autoreg_host" already exists 2023-01-04 09:31:01.060 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE proxy_autoreg_host ( id bigserial NOT NULL, clock integer DEFAULT '0' NOT NULL, host varchar(128) DEFAULT '' NOT NULL, listen_ip varchar(39) DEFAULT '' NOT NULL, listen_port integer DEFAULT '0' NOT NULL, listen_dns varchar(255) DEFAULT '' NOT NULL, host_metadata varchar(255) DEFAULT '' NOT NULL, flags integer DEFAULT '0' NOT NULL, tls_accepted integer DEFAULT '1' NOT NULL, PRIMARY KEY (id) ); 2023-01-04 09:31:01.061 CET zabbix zabbix [14928]ERROR: relation "proxy_autoreg_host_1" already exists 2023-01-04 09:31:01.061 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX proxy_autoreg_host_1 ON proxy_autoreg_host (clock); 2023-01-04 09:31:01.062 CET zabbix zabbix [14928]ERROR: relation "dhosts" already exists 2023-01-04 09:31:01.062 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE dhosts ( dhostid bigint NOT NULL, druleid bigint NOT NULL, status integer DEFAULT '0' NOT NULL, lastup integer DEFAULT '0' NOT NULL, lastdown integer DEFAULT '0' NOT NULL, PRIMARY KEY (dhostid) ); 2023-01-04 09:31:01.062 CET zabbix zabbix [14928]ERROR: relation "dhosts_1" already exists 2023-01-04 09:31:01.062 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX dhosts_1 ON dhosts (druleid); 2023-01-04 09:31:01.062 CET zabbix zabbix [14928]ERROR: relation "dservices" already exists 2023-01-04 09:31:01.062 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE dservices ( dserviceid bigint NOT NULL, dhostid bigint NOT NULL, value varchar(255) DEFAULT '' NOT NULL, port integer DEFAULT '0' NOT NULL, status integer DEFAULT '0' NOT NULL, lastup integer DEFAULT '0' NOT NULL, lastdown integer DEFAULT '0' NOT NULL, dcheckid bigint NOT NULL, ip varchar(39) DEFAULT '' NOT NULL, dns varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (dserviceid) ); 2023-01-04 09:31:01.062 CET zabbix zabbix [14928]ERROR: relation "dservices_1" already exists 2023-01-04 09:31:01.062 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX dservices_1 ON dservices (dcheckid,ip,port); 2023-01-04 09:31:01.062 CET zabbix zabbix [14928]ERROR: relation "dservices_2" already exists 2023-01-04 09:31:01.062 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX dservices_2 ON dservices (dhostid); 2023-01-04 09:31:01.062 CET zabbix zabbix [14928]ERROR: relation "escalations" already exists 2023-01-04 09:31:01.062 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE escalations ( escalationid bigint NOT NULL, actionid bigint NOT NULL, triggerid bigint NULL, eventid bigint NULL, r_eventid bigint NULL, nextcheck integer DEFAULT '0' NOT NULL, esc_step integer DEFAULT '0' NOT NULL, status integer DEFAULT '0' NOT NULL, itemid bigint NULL, acknowledgeid bigint NULL, servicealarmid bigint NULL, serviceid bigint NULL, PRIMARY KEY (escalationid) ); 2023-01-04 09:31:01.062 CET zabbix zabbix [14928]ERROR: relation "escalations_1" already exists 2023-01-04 09:31:01.062 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX escalations_1 ON escalations (triggerid,itemid,serviceid,escalationid); 2023-01-04 09:31:01.063 CET zabbix zabbix [14928]ERROR: relation "escalations_2" already exists 2023-01-04 09:31:01.063 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX escalations_2 ON escalations (eventid); 2023-01-04 09:31:01.063 CET zabbix zabbix [14928]ERROR: relation "escalations_3" already exists 2023-01-04 09:31:01.063 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX escalations_3 ON escalations (nextcheck); 2023-01-04 09:31:01.063 CET zabbix zabbix [14928]ERROR: relation "globalvars" already exists 2023-01-04 09:31:01.063 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE globalvars ( globalvarid bigint NOT NULL, snmp_lastsize numeric(20) DEFAULT '0' NOT NULL, PRIMARY KEY (globalvarid) ); 2023-01-04 09:31:01.063 CET zabbix zabbix [14928]ERROR: relation "graph_discovery" already exists 2023-01-04 09:31:01.063 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE graph_discovery ( graphid bigint NOT NULL, parent_graphid bigint NOT NULL, lastcheck integer DEFAULT '0' NOT NULL, ts_delete integer DEFAULT '0' NOT NULL, PRIMARY KEY (graphid) ); 2023-01-04 09:31:01.063 CET zabbix zabbix [14928]ERROR: relation "graph_discovery_1" already exists 2023-01-04 09:31:01.063 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX graph_discovery_1 ON graph_discovery (parent_graphid); 2023-01-04 09:31:01.064 CET zabbix zabbix [14928]ERROR: relation "host_inventory" already exists 2023-01-04 09:31:01.064 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE host_inventory ( hostid bigint NOT NULL, inventory_mode integer DEFAULT '0' NOT NULL, type varchar(64) DEFAULT '' NOT NULL, type_full varchar(64) DEFAULT '' NOT NULL, name varchar(128) DEFAULT '' NOT NULL, alias varchar(128) DEFAULT '' NOT NULL, os varchar(128) DEFAULT '' NOT NULL, os_full varchar(255) DEFAULT '' NOT NULL, os_short varchar(128) DEFAULT '' NOT NULL, serialno_a varchar(64) DEFAULT '' NOT NULL, serialno_b varchar(64) DEFAULT '' NOT NULL, tag varchar(64) DEFAULT '' NOT NULL, asset_tag varchar(64) DEFAULT '' NOT NULL, macaddress_a varchar(64) DEFAULT '' NOT NULL, macaddress_b varchar(64) DEFAULT '' NOT NULL, hardware varchar(255) DEFAULT '' NOT NULL, hardware_full text DEFAULT '' NOT NULL, software varchar(255) DEFAULT '' NOT NULL, software_full text DEFAULT '' NOT NULL, software_app_a varchar(64) DEFAULT '' NOT NULL, software_app_b varchar(64) DEFAULT '' NOT NULL, software_app_c varchar(64) DEFAULT '' NOT NULL, software_app_d varchar(64) DEFAULT '' NOT NULL, software_app_e varchar(64) DEFAULT '' NOT NULL, contact text DEFAULT '' NOT NULL, location text DEFAULT '' NOT NULL, location_lat varchar(16) DEFAULT '' NOT NULL, location_lon varchar(16) DEFAULT '' NOT NULL, notes text DEFAULT '' NOT NULL, chassis varchar(64) DEFAULT '' NOT NULL, model varchar(64) DEFAULT '' NOT NULL, hw_arch varchar(32) DEFAULT '' NOT NULL, vendor varchar(64) DEFAULT '' NOT NULL, contract_number varchar(64) DEFAULT '' NOT NULL, installer_name varchar(64) DEFAULT '' NOT NULL, deployment_status varchar(64) DEFAULT '' NOT NULL, url_a varchar(255) DEFAULT '' NOT NULL, url_b varchar(255) DEFAULT '' NOT NULL, url_c varchar(255) DEFAULT '' NOT NULL, host_networks text DEFAULT '' NOT NULL, host_netmask varchar(39) DEFAULT '' NOT NULL, host_router varchar(39) DEFAULT '' NOT NULL, oob_ip varchar(39) DEFAULT '' NOT NULL, oob_netmask varchar(39) DEFAULT '' NOT NULL, oob_router varchar(39) DEFAULT '' NOT NULL, date_hw_purchase varchar(64) DEFAULT '' NOT NULL, date_hw_install varchar(64) DEFAULT '' NOT NULL, date_hw_expiry varchar(64) DEFAULT '' NOT NULL, date_hw_decomm varchar(64) DEFAULT '' NOT NULL, site_address_a varchar(128) DEFAULT '' NOT NULL, site_address_b varchar(128) DEFAULT '' NOT NULL, site_address_c varchar(128) DEFAULT '' NOT NULL, site_city varchar(128) DEFAULT '' NOT NULL, site_state varchar(64) DEFAULT '' NOT NULL, site_country varchar(64) DEFAULT '' NOT NULL, site_zip varchar(64) DEFAULT '' NOT NULL, site_rack varchar(128) DEFAULT '' NOT NULL, site_notes text DEFAULT '' NOT NULL, poc_1_name varchar(128) DEFAULT '' NOT NULL, poc_1_email varchar(128) DEFAULT '' NOT NULL, poc_1_phone_a varchar(64) DEFAULT '' NOT NULL, poc_1_phone_b varchar(64) DEFAULT '' NOT NULL, poc_1_cell varchar(64) DEFAULT '' NOT NULL, poc_1_screen varchar(64) DEFAULT '' NOT NULL, poc_1_notes text DEFAULT '' NOT NULL, poc_2_name varchar(128) DEFAULT '' NOT NULL, poc_2_email varchar(128) DEFAULT '' NOT NULL, poc_2_phone_a varchar(64) DEFAULT '' NOT NULL, poc_2_phone_b varchar(64) DEFAULT '' NOT NULL, poc_2_cell varchar(64) DEFAULT '' NOT NULL, poc_2_screen varchar(64) DEFAULT '' NOT NULL, poc_2_notes text DEFAULT '' NOT NULL, PRIMARY KEY (hostid) ); 2023-01-04 09:31:01.064 CET zabbix zabbix [14928]ERROR: relation "housekeeper" already exists 2023-01-04 09:31:01.064 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE housekeeper ( housekeeperid bigint NOT NULL, tablename varchar(64) DEFAULT '' NOT NULL, field varchar(64) DEFAULT '' NOT NULL, value bigint NOT NULL, PRIMARY KEY (housekeeperid) ); 2023-01-04 09:31:01.064 CET zabbix zabbix [14928]ERROR: relation "images" already exists 2023-01-04 09:31:01.064 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE images ( imageid bigint NOT NULL, imagetype integer DEFAULT '0' NOT NULL, name varchar(64) DEFAULT '0' NOT NULL, image bytea DEFAULT '' NOT NULL, PRIMARY KEY (imageid) ); 2023-01-04 09:31:01.064 CET zabbix zabbix [14928]ERROR: relation "images_1" already exists 2023-01-04 09:31:01.064 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX images_1 ON images (name); 2023-01-04 09:31:01.064 CET zabbix zabbix [14928]ERROR: relation "item_discovery" already exists 2023-01-04 09:31:01.064 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE item_discovery ( itemdiscoveryid bigint NOT NULL, itemid bigint NOT NULL, parent_itemid bigint NOT NULL, key_ varchar(2048) DEFAULT '' NOT NULL, lastcheck integer DEFAULT '0' NOT NULL, ts_delete integer DEFAULT '0' NOT NULL, PRIMARY KEY (itemdiscoveryid) ); 2023-01-04 09:31:01.064 CET zabbix zabbix [14928]ERROR: relation "item_discovery_1" already exists 2023-01-04 09:31:01.064 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX item_discovery_1 ON item_discovery (itemid,parent_itemid); 2023-01-04 09:31:01.065 CET zabbix zabbix [14928]ERROR: relation "item_discovery_2" already exists 2023-01-04 09:31:01.065 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX item_discovery_2 ON item_discovery (parent_itemid); 2023-01-04 09:31:01.065 CET zabbix zabbix [14928]ERROR: relation "host_discovery" already exists 2023-01-04 09:31:01.065 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE host_discovery ( hostid bigint NOT NULL, parent_hostid bigint NULL, parent_itemid bigint NULL, host varchar(128) DEFAULT '' NOT NULL, lastcheck integer DEFAULT '0' NOT NULL, ts_delete integer DEFAULT '0' NOT NULL, PRIMARY KEY (hostid) ); 2023-01-04 09:31:01.065 CET zabbix zabbix [14928]ERROR: relation "interface_discovery" already exists 2023-01-04 09:31:01.065 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE interface_discovery ( interfaceid bigint NOT NULL, parent_interfaceid bigint NOT NULL, PRIMARY KEY (interfaceid) ); 2023-01-04 09:31:01.065 CET zabbix zabbix [14928]ERROR: relation "profiles" already exists 2023-01-04 09:31:01.065 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE profiles ( profileid bigint NOT NULL, userid bigint NOT NULL, idx varchar(96) DEFAULT '' NOT NULL, idx2 bigint DEFAULT '0' NOT NULL, value_id bigint DEFAULT '0' NOT NULL, value_int integer DEFAULT '0' NOT NULL, value_str text DEFAULT '' NOT NULL, source varchar(96) DEFAULT '' NOT NULL, type integer DEFAULT '0' NOT NULL, PRIMARY KEY (profileid) ); 2023-01-04 09:31:01.065 CET zabbix zabbix [14928]ERROR: relation "profiles_1" already exists 2023-01-04 09:31:01.065 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX profiles_1 ON profiles (userid,idx,idx2); 2023-01-04 09:31:01.065 CET zabbix zabbix [14928]ERROR: relation "profiles_2" already exists 2023-01-04 09:31:01.065 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX profiles_2 ON profiles (userid,profileid); 2023-01-04 09:31:01.065 CET zabbix zabbix [14928]ERROR: relation "sessions" already exists 2023-01-04 09:31:01.065 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE sessions ( sessionid varchar(32) DEFAULT '' NOT NULL, userid bigint NOT NULL, lastaccess integer DEFAULT '0' NOT NULL, status integer DEFAULT '0' NOT NULL, PRIMARY KEY (sessionid) ); 2023-01-04 09:31:01.066 CET zabbix zabbix [14928]ERROR: relation "sessions_1" already exists 2023-01-04 09:31:01.066 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX sessions_1 ON sessions (userid,status,lastaccess); 2023-01-04 09:31:01.066 CET zabbix zabbix [14928]ERROR: relation "trigger_discovery" already exists 2023-01-04 09:31:01.066 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE trigger_discovery ( triggerid bigint NOT NULL, parent_triggerid bigint NOT NULL, lastcheck integer DEFAULT '0' NOT NULL, ts_delete integer DEFAULT '0' NOT NULL, PRIMARY KEY (triggerid) ); 2023-01-04 09:31:01.066 CET zabbix zabbix [14928]ERROR: relation "trigger_discovery_1" already exists 2023-01-04 09:31:01.066 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX trigger_discovery_1 ON trigger_discovery (parent_triggerid); 2023-01-04 09:31:01.066 CET zabbix zabbix [14928]ERROR: relation "item_condition" already exists 2023-01-04 09:31:01.066 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE item_condition ( item_conditionid bigint NOT NULL, itemid bigint NOT NULL, operator integer DEFAULT '8' NOT NULL, macro varchar(64) DEFAULT '' NOT NULL, value varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (item_conditionid) ); 2023-01-04 09:31:01.066 CET zabbix zabbix [14928]ERROR: relation "item_condition_1" already exists 2023-01-04 09:31:01.066 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX item_condition_1 ON item_condition (itemid); 2023-01-04 09:31:01.066 CET zabbix zabbix [14928]ERROR: relation "item_rtdata" already exists 2023-01-04 09:31:01.066 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE item_rtdata ( itemid bigint NOT NULL, lastlogsize numeric(20) DEFAULT '0' NOT NULL, state integer DEFAULT '0' NOT NULL, mtime integer DEFAULT '0' NOT NULL, error varchar(2048) DEFAULT '' NOT NULL, PRIMARY KEY (itemid) ); 2023-01-04 09:31:01.066 CET zabbix zabbix [14928]ERROR: relation "opinventory" already exists 2023-01-04 09:31:01.066 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE opinventory ( operationid bigint NOT NULL, inventory_mode integer DEFAULT '0' NOT NULL, PRIMARY KEY (operationid) ); 2023-01-04 09:31:01.067 CET zabbix zabbix [14928]ERROR: relation "trigger_tag" already exists 2023-01-04 09:31:01.067 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE trigger_tag ( triggertagid bigint NOT NULL, triggerid bigint NOT NULL, tag varchar(255) DEFAULT '' NOT NULL, value varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (triggertagid) ); 2023-01-04 09:31:01.067 CET zabbix zabbix [14928]ERROR: relation "trigger_tag_1" already exists 2023-01-04 09:31:01.067 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX trigger_tag_1 ON trigger_tag (triggerid); 2023-01-04 09:31:01.067 CET zabbix zabbix [14928]ERROR: relation "event_tag" already exists 2023-01-04 09:31:01.067 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE event_tag ( eventtagid bigint NOT NULL, eventid bigint NOT NULL, tag varchar(255) DEFAULT '' NOT NULL, value varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (eventtagid) ); 2023-01-04 09:31:01.067 CET zabbix zabbix [14928]ERROR: relation "event_tag_1" already exists 2023-01-04 09:31:01.067 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX event_tag_1 ON event_tag (eventid); 2023-01-04 09:31:01.067 CET zabbix zabbix [14928]ERROR: relation "problem" already exists 2023-01-04 09:31:01.067 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE problem ( eventid bigint NOT NULL, source integer DEFAULT '0' NOT NULL, object integer DEFAULT '0' NOT NULL, objectid bigint DEFAULT '0' NOT NULL, clock integer DEFAULT '0' NOT NULL, ns integer DEFAULT '0' NOT NULL, r_eventid bigint NULL, r_clock integer DEFAULT '0' NOT NULL, r_ns integer DEFAULT '0' NOT NULL, correlationid bigint NULL, userid bigint NULL, name varchar(2048) DEFAULT '' NOT NULL, acknowledged integer DEFAULT '0' NOT NULL, severity integer DEFAULT '0' NOT NULL, PRIMARY KEY (eventid) ); 2023-01-04 09:31:01.067 CET zabbix zabbix [14928]ERROR: relation "problem_1" already exists 2023-01-04 09:31:01.067 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX problem_1 ON problem (source,object,objectid); 2023-01-04 09:31:01.068 CET zabbix zabbix [14928]ERROR: relation "problem_2" already exists 2023-01-04 09:31:01.068 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX problem_2 ON problem (r_clock); 2023-01-04 09:31:01.068 CET zabbix zabbix [14928]ERROR: relation "problem_3" already exists 2023-01-04 09:31:01.068 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX problem_3 ON problem (r_eventid); 2023-01-04 09:31:01.068 CET zabbix zabbix [14928]ERROR: relation "problem_tag" already exists 2023-01-04 09:31:01.068 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE problem_tag ( problemtagid bigint NOT NULL, eventid bigint NOT NULL, tag varchar(255) DEFAULT '' NOT NULL, value varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (problemtagid) ); 2023-01-04 09:31:01.068 CET zabbix zabbix [14928]ERROR: relation "problem_tag_1" already exists 2023-01-04 09:31:01.068 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX problem_tag_1 ON problem_tag (eventid,tag,value); 2023-01-04 09:31:01.068 CET zabbix zabbix [14928]ERROR: relation "tag_filter" already exists 2023-01-04 09:31:01.068 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE tag_filter ( tag_filterid bigint NOT NULL, usrgrpid bigint NOT NULL, groupid bigint NOT NULL, tag varchar(255) DEFAULT '' NOT NULL, value varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (tag_filterid) ); 2023-01-04 09:31:01.068 CET zabbix zabbix [14928]ERROR: relation "event_recovery" already exists 2023-01-04 09:31:01.068 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE event_recovery ( eventid bigint NOT NULL, r_eventid bigint NOT NULL, c_eventid bigint NULL, correlationid bigint NULL, userid bigint NULL, PRIMARY KEY (eventid) ); 2023-01-04 09:31:01.068 CET zabbix zabbix [14928]ERROR: relation "event_recovery_1" already exists 2023-01-04 09:31:01.068 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX event_recovery_1 ON event_recovery (r_eventid); 2023-01-04 09:31:01.068 CET zabbix zabbix [14928]ERROR: relation "event_recovery_2" already exists 2023-01-04 09:31:01.068 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX event_recovery_2 ON event_recovery (c_eventid); 2023-01-04 09:31:01.069 CET zabbix zabbix [14928]ERROR: relation "correlation" already exists 2023-01-04 09:31:01.069 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE correlation ( correlationid bigint NOT NULL, name varchar(255) DEFAULT '' NOT NULL, description text DEFAULT '' NOT NULL, evaltype integer DEFAULT '0' NOT NULL, status integer DEFAULT '0' NOT NULL, formula varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (correlationid) ); 2023-01-04 09:31:01.069 CET zabbix zabbix [14928]ERROR: relation "correlation_1" already exists 2023-01-04 09:31:01.069 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX correlation_1 ON correlation (status); 2023-01-04 09:31:01.069 CET zabbix zabbix [14928]ERROR: relation "correlation_2" already exists 2023-01-04 09:31:01.069 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX correlation_2 ON correlation (name); 2023-01-04 09:31:01.069 CET zabbix zabbix [14928]ERROR: relation "corr_condition" already exists 2023-01-04 09:31:01.069 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE corr_condition ( corr_conditionid bigint NOT NULL, correlationid bigint NOT NULL, type integer DEFAULT '0' NOT NULL, PRIMARY KEY (corr_conditionid) ); 2023-01-04 09:31:01.069 CET zabbix zabbix [14928]ERROR: relation "corr_condition_1" already exists 2023-01-04 09:31:01.069 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX corr_condition_1 ON corr_condition (correlationid); 2023-01-04 09:31:01.069 CET zabbix zabbix [14928]ERROR: relation "corr_condition_tag" already exists 2023-01-04 09:31:01.069 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE corr_condition_tag ( corr_conditionid bigint NOT NULL, tag varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (corr_conditionid) ); 2023-01-04 09:31:01.069 CET zabbix zabbix [14928]ERROR: relation "corr_condition_group" already exists 2023-01-04 09:31:01.069 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE corr_condition_group ( corr_conditionid bigint NOT NULL, operator integer DEFAULT '0' NOT NULL, groupid bigint NOT NULL, PRIMARY KEY (corr_conditionid) ); 2023-01-04 09:31:01.069 CET zabbix zabbix [14928]ERROR: relation "corr_condition_group_1" already exists 2023-01-04 09:31:01.069 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX corr_condition_group_1 ON corr_condition_group (groupid); 2023-01-04 09:31:01.070 CET zabbix zabbix [14928]ERROR: relation "corr_condition_tagpair" already exists 2023-01-04 09:31:01.070 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE corr_condition_tagpair ( corr_conditionid bigint NOT NULL, oldtag varchar(255) DEFAULT '' NOT NULL, newtag varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (corr_conditionid) ); 2023-01-04 09:31:01.070 CET zabbix zabbix [14928]ERROR: relation "corr_condition_tagvalue" already exists 2023-01-04 09:31:01.070 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE corr_condition_tagvalue ( corr_conditionid bigint NOT NULL, tag varchar(255) DEFAULT '' NOT NULL, operator integer DEFAULT '0' NOT NULL, value varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (corr_conditionid) ); 2023-01-04 09:31:01.070 CET zabbix zabbix [14928]ERROR: relation "corr_operation" already exists 2023-01-04 09:31:01.070 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE corr_operation ( corr_operationid bigint NOT NULL, correlationid bigint NOT NULL, type integer DEFAULT '0' NOT NULL, PRIMARY KEY (corr_operationid) ); 2023-01-04 09:31:01.070 CET zabbix zabbix [14928]ERROR: relation "corr_operation_1" already exists 2023-01-04 09:31:01.070 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX corr_operation_1 ON corr_operation (correlationid); 2023-01-04 09:31:01.070 CET zabbix zabbix [14928]ERROR: relation "task" already exists 2023-01-04 09:31:01.070 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE task ( taskid bigint NOT NULL, type integer NOT NULL, status integer DEFAULT '0' NOT NULL, clock integer DEFAULT '0' NOT NULL, ttl integer DEFAULT '0' NOT NULL, proxy_hostid bigint NULL, PRIMARY KEY (taskid) ); 2023-01-04 09:31:01.070 CET zabbix zabbix [14928]ERROR: relation "task_1" already exists 2023-01-04 09:31:01.070 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX task_1 ON task (status,proxy_hostid); 2023-01-04 09:31:01.070 CET zabbix zabbix [14928]ERROR: relation "task_close_problem" already exists 2023-01-04 09:31:01.070 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE task_close_problem ( taskid bigint NOT NULL, acknowledgeid bigint NOT NULL, PRIMARY KEY (taskid) ); 2023-01-04 09:31:01.071 CET zabbix zabbix [14928]ERROR: relation "item_preproc" already exists 2023-01-04 09:31:01.071 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE item_preproc ( item_preprocid bigint NOT NULL, itemid bigint NOT NULL, step integer DEFAULT '0' NOT NULL, type integer DEFAULT '0' NOT NULL, params text DEFAULT '' NOT NULL, error_handler integer DEFAULT '0' NOT NULL, error_handler_params varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (item_preprocid) ); 2023-01-04 09:31:01.071 CET zabbix zabbix [14928]ERROR: relation "item_preproc_1" already exists 2023-01-04 09:31:01.071 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX item_preproc_1 ON item_preproc (itemid,step); 2023-01-04 09:31:01.071 CET zabbix zabbix [14928]ERROR: relation "task_remote_command" already exists 2023-01-04 09:31:01.071 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE task_remote_command ( taskid bigint NOT NULL, command_type integer DEFAULT '0' NOT NULL, execute_on integer DEFAULT '0' NOT NULL, port integer DEFAULT '0' NOT NULL, authtype integer DEFAULT '0' NOT NULL, username varchar(64) DEFAULT '' NOT NULL, password varchar(64) DEFAULT '' NOT NULL, publickey varchar(64) DEFAULT '' NOT NULL, privatekey varchar(64) DEFAULT '' NOT NULL, command text DEFAULT '' NOT NULL, alertid bigint NULL, parent_taskid bigint NOT NULL, hostid bigint NOT NULL, PRIMARY KEY (taskid) ); 2023-01-04 09:31:01.071 CET zabbix zabbix [14928]ERROR: relation "task_remote_command_result" already exists 2023-01-04 09:31:01.071 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE task_remote_command_result ( taskid bigint NOT NULL, status integer DEFAULT '0' NOT NULL, parent_taskid bigint NOT NULL, info text DEFAULT '' NOT NULL, PRIMARY KEY (taskid) ); 2023-01-04 09:31:01.071 CET zabbix zabbix [14928]ERROR: relation "task_data" already exists 2023-01-04 09:31:01.071 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE task_data ( taskid bigint NOT NULL, type integer DEFAULT '0' NOT NULL, data text DEFAULT '' NOT NULL, parent_taskid bigint NULL, PRIMARY KEY (taskid) ); 2023-01-04 09:31:01.071 CET zabbix zabbix [14928]ERROR: relation "task_result" already exists 2023-01-04 09:31:01.071 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE task_result ( taskid bigint NOT NULL, status integer DEFAULT '0' NOT NULL, parent_taskid bigint NOT NULL, info text DEFAULT '' NOT NULL, PRIMARY KEY (taskid) ); 2023-01-04 09:31:01.071 CET zabbix zabbix [14928]ERROR: relation "task_result_1" already exists 2023-01-04 09:31:01.071 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX task_result_1 ON task_result (parent_taskid); 2023-01-04 09:31:01.071 CET zabbix zabbix [14928]ERROR: relation "task_acknowledge" already exists 2023-01-04 09:31:01.071 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE task_acknowledge ( taskid bigint NOT NULL, acknowledgeid bigint NOT NULL, PRIMARY KEY (taskid) ); 2023-01-04 09:31:01.072 CET zabbix zabbix [14928]ERROR: relation "sysmap_shape" already exists 2023-01-04 09:31:01.072 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE sysmap_shape ( sysmap_shapeid bigint NOT NULL, sysmapid bigint NOT NULL, type integer DEFAULT '0' NOT NULL, x integer DEFAULT '0' NOT NULL, y integer DEFAULT '0' NOT NULL, width integer DEFAULT '200' NOT NULL, height integer DEFAULT '200' NOT NULL, text text DEFAULT '' NOT NULL, font integer DEFAULT '9' NOT NULL, font_size integer DEFAULT '11' NOT NULL, font_color varchar(6) DEFAULT '000000' NOT NULL, text_halign integer DEFAULT '0' NOT NULL, text_valign integer DEFAULT '0' NOT NULL, border_type integer DEFAULT '0' NOT NULL, border_width integer DEFAULT '1' NOT NULL, border_color varchar(6) DEFAULT '000000' NOT NULL, background_color varchar(6) DEFAULT '' NOT NULL, zindex integer DEFAULT '0' NOT NULL, PRIMARY KEY (sysmap_shapeid) ); 2023-01-04 09:31:01.072 CET zabbix zabbix [14928]ERROR: relation "sysmap_shape_1" already exists 2023-01-04 09:31:01.072 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX sysmap_shape_1 ON sysmap_shape (sysmapid); 2023-01-04 09:31:01.072 CET zabbix zabbix [14928]ERROR: relation "sysmap_element_trigger" already exists 2023-01-04 09:31:01.072 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE sysmap_element_trigger ( selement_triggerid bigint NOT NULL, selementid bigint NOT NULL, triggerid bigint NOT NULL, PRIMARY KEY (selement_triggerid) ); 2023-01-04 09:31:01.072 CET zabbix zabbix [14928]ERROR: relation "sysmap_element_trigger_1" already exists 2023-01-04 09:31:01.072 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX sysmap_element_trigger_1 ON sysmap_element_trigger (selementid,triggerid); 2023-01-04 09:31:01.072 CET zabbix zabbix [14928]ERROR: relation "httptest_field" already exists 2023-01-04 09:31:01.072 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE httptest_field ( httptest_fieldid bigint NOT NULL, httptestid bigint NOT NULL, type integer DEFAULT '0' NOT NULL, name varchar(255) DEFAULT '' NOT NULL, value text DEFAULT '' NOT NULL, PRIMARY KEY (httptest_fieldid) ); 2023-01-04 09:31:01.073 CET zabbix zabbix [14928]ERROR: relation "httptest_field_1" already exists 2023-01-04 09:31:01.073 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX httptest_field_1 ON httptest_field (httptestid); 2023-01-04 09:31:01.073 CET zabbix zabbix [14928]ERROR: relation "httpstep_field" already exists 2023-01-04 09:31:01.073 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE httpstep_field ( httpstep_fieldid bigint NOT NULL, httpstepid bigint NOT NULL, type integer DEFAULT '0' NOT NULL, name varchar(255) DEFAULT '' NOT NULL, value text DEFAULT '' NOT NULL, PRIMARY KEY (httpstep_fieldid) ); 2023-01-04 09:31:01.073 CET zabbix zabbix [14928]ERROR: relation "httpstep_field_1" already exists 2023-01-04 09:31:01.073 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX httpstep_field_1 ON httpstep_field (httpstepid); 2023-01-04 09:31:01.073 CET zabbix zabbix [14928]ERROR: relation "dashboard" already exists 2023-01-04 09:31:01.073 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE dashboard ( dashboardid bigint NOT NULL, name varchar(255) NOT NULL, userid bigint NULL, private integer DEFAULT '1' NOT NULL, templateid bigint NULL, display_period integer DEFAULT '30' NOT NULL, auto_start integer DEFAULT '1' NOT NULL, uuid varchar(32) DEFAULT '' NOT NULL, PRIMARY KEY (dashboardid) ); 2023-01-04 09:31:01.077 CET zabbix zabbix [14928]ERROR: relation "dashboard_1" already exists 2023-01-04 09:31:01.077 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX dashboard_1 ON dashboard (userid); 2023-01-04 09:31:01.078 CET zabbix zabbix [14928]ERROR: relation "dashboard_2" already exists 2023-01-04 09:31:01.078 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX dashboard_2 ON dashboard (templateid); 2023-01-04 09:31:01.078 CET zabbix zabbix [14928]ERROR: relation "dashboard_user" already exists 2023-01-04 09:31:01.078 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE dashboard_user ( dashboard_userid bigint NOT NULL, dashboardid bigint NOT NULL, userid bigint NOT NULL, permission integer DEFAULT '2' NOT NULL, PRIMARY KEY (dashboard_userid) ); 2023-01-04 09:31:01.078 CET zabbix zabbix [14928]ERROR: relation "dashboard_user_1" already exists 2023-01-04 09:31:01.078 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX dashboard_user_1 ON dashboard_user (dashboardid,userid); 2023-01-04 09:31:01.078 CET zabbix zabbix [14928]ERROR: relation "dashboard_usrgrp" already exists 2023-01-04 09:31:01.078 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE dashboard_usrgrp ( dashboard_usrgrpid bigint NOT NULL, dashboardid bigint NOT NULL, usrgrpid bigint NOT NULL, permission integer DEFAULT '2' NOT NULL, PRIMARY KEY (dashboard_usrgrpid) ); 2023-01-04 09:31:01.078 CET zabbix zabbix [14928]ERROR: relation "dashboard_usrgrp_1" already exists 2023-01-04 09:31:01.078 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX dashboard_usrgrp_1 ON dashboard_usrgrp (dashboardid,usrgrpid); 2023-01-04 09:31:01.078 CET zabbix zabbix [14928]ERROR: relation "dashboard_page" already exists 2023-01-04 09:31:01.078 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE dashboard_page ( dashboard_pageid bigint NOT NULL, dashboardid bigint NOT NULL, name varchar(255) DEFAULT '' NOT NULL, display_period integer DEFAULT '0' NOT NULL, sortorder integer DEFAULT '0' NOT NULL, PRIMARY KEY (dashboard_pageid) ); 2023-01-04 09:31:01.079 CET zabbix zabbix [14928]ERROR: relation "dashboard_page_1" already exists 2023-01-04 09:31:01.079 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX dashboard_page_1 ON dashboard_page (dashboardid); 2023-01-04 09:31:01.079 CET zabbix zabbix [14928]ERROR: relation "widget" already exists 2023-01-04 09:31:01.079 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE widget ( widgetid bigint NOT NULL, type varchar(255) DEFAULT '' NOT NULL, name varchar(255) DEFAULT '' NOT NULL, x integer DEFAULT '0' NOT NULL, y integer DEFAULT '0' NOT NULL, width integer DEFAULT '1' NOT NULL, height integer DEFAULT '2' NOT NULL, view_mode integer DEFAULT '0' NOT NULL, dashboard_pageid bigint NOT NULL, PRIMARY KEY (widgetid) ); 2023-01-04 09:31:01.079 CET zabbix zabbix [14928]ERROR: relation "widget_1" already exists 2023-01-04 09:31:01.079 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX widget_1 ON widget (dashboard_pageid); 2023-01-04 09:31:01.079 CET zabbix zabbix [14928]ERROR: relation "widget_field" already exists 2023-01-04 09:31:01.079 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE widget_field ( widget_fieldid bigint NOT NULL, widgetid bigint NOT NULL, type integer DEFAULT '0' NOT NULL, name varchar(255) DEFAULT '' NOT NULL, value_int integer DEFAULT '0' NOT NULL, value_str varchar(255) DEFAULT '' NOT NULL, value_groupid bigint NULL, value_hostid bigint NULL, value_itemid bigint NULL, value_graphid bigint NULL, value_sysmapid bigint NULL, value_serviceid bigint NULL, value_slaid bigint NULL, PRIMARY KEY (widget_fieldid) ); 2023-01-04 09:31:01.079 CET zabbix zabbix [14928]ERROR: relation "widget_field_1" already exists 2023-01-04 09:31:01.079 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX widget_field_1 ON widget_field (widgetid); 2023-01-04 09:31:01.080 CET zabbix zabbix [14928]ERROR: relation "widget_field_2" already exists 2023-01-04 09:31:01.080 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX widget_field_2 ON widget_field (value_groupid); 2023-01-04 09:31:01.080 CET zabbix zabbix [14928]ERROR: relation "widget_field_3" already exists 2023-01-04 09:31:01.080 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX widget_field_3 ON widget_field (value_hostid); 2023-01-04 09:31:01.080 CET zabbix zabbix [14928]ERROR: relation "widget_field_4" already exists 2023-01-04 09:31:01.080 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX widget_field_4 ON widget_field (value_itemid); 2023-01-04 09:31:01.080 CET zabbix zabbix [14928]ERROR: relation "widget_field_5" already exists 2023-01-04 09:31:01.080 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX widget_field_5 ON widget_field (value_graphid); 2023-01-04 09:31:01.081 CET zabbix zabbix [14928]ERROR: relation "widget_field_6" already exists 2023-01-04 09:31:01.081 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX widget_field_6 ON widget_field (value_sysmapid); 2023-01-04 09:31:01.081 CET zabbix zabbix [14928]ERROR: relation "widget_field_7" already exists 2023-01-04 09:31:01.081 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX widget_field_7 ON widget_field (value_serviceid); 2023-01-04 09:31:01.081 CET zabbix zabbix [14928]ERROR: relation "widget_field_8" already exists 2023-01-04 09:31:01.081 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX widget_field_8 ON widget_field (value_slaid); 2023-01-04 09:31:01.081 CET zabbix zabbix [14928]ERROR: relation "task_check_now" already exists 2023-01-04 09:31:01.081 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE task_check_now ( taskid bigint NOT NULL, itemid bigint NOT NULL, PRIMARY KEY (taskid) ); 2023-01-04 09:31:01.081 CET zabbix zabbix [14928]ERROR: relation "event_suppress" already exists 2023-01-04 09:31:01.081 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE event_suppress ( event_suppressid bigint NOT NULL, eventid bigint NOT NULL, maintenanceid bigint NULL, suppress_until integer DEFAULT '0' NOT NULL, userid bigint NULL, PRIMARY KEY (event_suppressid) ); 2023-01-04 09:31:01.081 CET zabbix zabbix [14928]ERROR: relation "event_suppress_1" already exists 2023-01-04 09:31:01.081 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX event_suppress_1 ON event_suppress (eventid,maintenanceid); 2023-01-04 09:31:01.081 CET zabbix zabbix [14928]ERROR: relation "event_suppress_2" already exists 2023-01-04 09:31:01.081 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX event_suppress_2 ON event_suppress (suppress_until); 2023-01-04 09:31:01.081 CET zabbix zabbix [14928]ERROR: relation "event_suppress_3" already exists 2023-01-04 09:31:01.081 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX event_suppress_3 ON event_suppress (maintenanceid); 2023-01-04 09:31:01.082 CET zabbix zabbix [14928]ERROR: relation "maintenance_tag" already exists 2023-01-04 09:31:01.082 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE maintenance_tag ( maintenancetagid bigint NOT NULL, maintenanceid bigint NOT NULL, tag varchar(255) DEFAULT '' NOT NULL, operator integer DEFAULT '2' NOT NULL, value varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (maintenancetagid) ); 2023-01-04 09:31:01.082 CET zabbix zabbix [14928]ERROR: relation "maintenance_tag_1" already exists 2023-01-04 09:31:01.082 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX maintenance_tag_1 ON maintenance_tag (maintenanceid); 2023-01-04 09:31:01.082 CET zabbix zabbix [14928]ERROR: relation "lld_macro_path" already exists 2023-01-04 09:31:01.082 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE lld_macro_path ( lld_macro_pathid bigint NOT NULL, itemid bigint NOT NULL, lld_macro varchar(255) DEFAULT '' NOT NULL, path varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (lld_macro_pathid) ); 2023-01-04 09:31:01.082 CET zabbix zabbix [14928]ERROR: relation "lld_macro_path_1" already exists 2023-01-04 09:31:01.082 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX lld_macro_path_1 ON lld_macro_path (itemid,lld_macro); 2023-01-04 09:31:01.082 CET zabbix zabbix [14928]ERROR: relation "host_tag" already exists 2023-01-04 09:31:01.082 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE host_tag ( hosttagid bigint NOT NULL, hostid bigint NOT NULL, tag varchar(255) DEFAULT '' NOT NULL, value varchar(255) DEFAULT '' NOT NULL, automatic integer DEFAULT '0' NOT NULL, PRIMARY KEY (hosttagid) ); 2023-01-04 09:31:01.082 CET zabbix zabbix [14928]ERROR: relation "host_tag_1" already exists 2023-01-04 09:31:01.082 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX host_tag_1 ON host_tag (hostid); 2023-01-04 09:31:01.082 CET zabbix zabbix [14928]ERROR: relation "config_autoreg_tls" already exists 2023-01-04 09:31:01.082 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE config_autoreg_tls ( autoreg_tlsid bigint NOT NULL, tls_psk_identity varchar(128) DEFAULT '' NOT NULL, tls_psk varchar(512) DEFAULT '' NOT NULL, PRIMARY KEY (autoreg_tlsid) ); 2023-01-04 09:31:01.083 CET zabbix zabbix [14928]ERROR: relation "config_autoreg_tls_1" already exists 2023-01-04 09:31:01.083 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX config_autoreg_tls_1 ON config_autoreg_tls (tls_psk_identity); 2023-01-04 09:31:01.083 CET zabbix zabbix [14928]ERROR: relation "module" already exists 2023-01-04 09:31:01.083 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE module ( moduleid bigint NOT NULL, id varchar(255) DEFAULT '' NOT NULL, relative_path varchar(255) DEFAULT '' NOT NULL, status integer DEFAULT '0' NOT NULL, config text DEFAULT '' NOT NULL, PRIMARY KEY (moduleid) ); 2023-01-04 09:31:01.083 CET zabbix zabbix [14928]ERROR: relation "interface_snmp" already exists 2023-01-04 09:31:01.083 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE interface_snmp ( interfaceid bigint NOT NULL, version integer DEFAULT '2' NOT NULL, bulk integer DEFAULT '1' NOT NULL, community varchar(64) DEFAULT '' NOT NULL, securityname varchar(64) DEFAULT '' NOT NULL, securitylevel integer DEFAULT '0' NOT NULL, authpassphrase varchar(64) DEFAULT '' NOT NULL, privpassphrase varchar(64) DEFAULT '' NOT NULL, authprotocol integer DEFAULT '0' NOT NULL, privprotocol integer DEFAULT '0' NOT NULL, contextname varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (interfaceid) ); 2023-01-04 09:31:01.083 CET zabbix zabbix [14928]ERROR: relation "lld_override" already exists 2023-01-04 09:31:01.083 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE lld_override ( lld_overrideid bigint NOT NULL, itemid bigint NOT NULL, name varchar(255) DEFAULT '' NOT NULL, step integer DEFAULT '0' NOT NULL, evaltype integer DEFAULT '0' NOT NULL, formula varchar(255) DEFAULT '' NOT NULL, stop integer DEFAULT '0' NOT NULL, PRIMARY KEY (lld_overrideid) ); 2023-01-04 09:31:01.083 CET zabbix zabbix [14928]ERROR: relation "lld_override_1" already exists 2023-01-04 09:31:01.083 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX lld_override_1 ON lld_override (itemid,name); 2023-01-04 09:31:01.083 CET zabbix zabbix [14928]ERROR: relation "lld_override_condition" already exists 2023-01-04 09:31:01.083 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE lld_override_condition ( lld_override_conditionid bigint NOT NULL, lld_overrideid bigint NOT NULL, operator integer DEFAULT '8' NOT NULL, macro varchar(64) DEFAULT '' NOT NULL, value varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (lld_override_conditionid) ); 2023-01-04 09:31:01.083 CET zabbix zabbix [14928]ERROR: relation "lld_override_condition_1" already exists 2023-01-04 09:31:01.083 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX lld_override_condition_1 ON lld_override_condition (lld_overrideid); 2023-01-04 09:31:01.084 CET zabbix zabbix [14928]ERROR: relation "lld_override_operation" already exists 2023-01-04 09:31:01.084 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE lld_override_operation ( lld_override_operationid bigint NOT NULL, lld_overrideid bigint NOT NULL, operationobject integer DEFAULT '0' NOT NULL, operator integer DEFAULT '0' NOT NULL, value varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (lld_override_operationid) ); 2023-01-04 09:31:01.084 CET zabbix zabbix [14928]ERROR: relation "lld_override_operation_1" already exists 2023-01-04 09:31:01.084 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX lld_override_operation_1 ON lld_override_operation (lld_overrideid); 2023-01-04 09:31:01.084 CET zabbix zabbix [14928]ERROR: relation "lld_override_opstatus" already exists 2023-01-04 09:31:01.084 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE lld_override_opstatus ( lld_override_operationid bigint NOT NULL, status integer DEFAULT '0' NOT NULL, PRIMARY KEY (lld_override_operationid) ); 2023-01-04 09:31:01.084 CET zabbix zabbix [14928]ERROR: relation "lld_override_opdiscover" already exists 2023-01-04 09:31:01.084 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE lld_override_opdiscover ( lld_override_operationid bigint NOT NULL, discover integer DEFAULT '0' NOT NULL, PRIMARY KEY (lld_override_operationid) ); 2023-01-04 09:31:01.084 CET zabbix zabbix [14928]ERROR: relation "lld_override_opperiod" already exists 2023-01-04 09:31:01.084 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE lld_override_opperiod ( lld_override_operationid bigint NOT NULL, delay varchar(1024) DEFAULT '0' NOT NULL, PRIMARY KEY (lld_override_operationid) ); 2023-01-04 09:31:01.084 CET zabbix zabbix [14928]ERROR: relation "lld_override_ophistory" already exists 2023-01-04 09:31:01.084 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE lld_override_ophistory ( lld_override_operationid bigint NOT NULL, history varchar(255) DEFAULT '90d' NOT NULL, PRIMARY KEY (lld_override_operationid) ); 2023-01-04 09:31:01.084 CET zabbix zabbix [14928]ERROR: relation "lld_override_optrends" already exists 2023-01-04 09:31:01.084 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE lld_override_optrends ( lld_override_operationid bigint NOT NULL, trends varchar(255) DEFAULT '365d' NOT NULL, PRIMARY KEY (lld_override_operationid) ); 2023-01-04 09:31:01.084 CET zabbix zabbix [14928]ERROR: relation "lld_override_opseverity" already exists 2023-01-04 09:31:01.084 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE lld_override_opseverity ( lld_override_operationid bigint NOT NULL, severity integer DEFAULT '0' NOT NULL, PRIMARY KEY (lld_override_operationid) ); 2023-01-04 09:31:01.085 CET zabbix zabbix [14928]ERROR: relation "lld_override_optag" already exists 2023-01-04 09:31:01.085 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE lld_override_optag ( lld_override_optagid bigint NOT NULL, lld_override_operationid bigint NOT NULL, tag varchar(255) DEFAULT '' NOT NULL, value varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (lld_override_optagid) ); 2023-01-04 09:31:01.085 CET zabbix zabbix [14928]ERROR: relation "lld_override_optag_1" already exists 2023-01-04 09:31:01.085 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX lld_override_optag_1 ON lld_override_optag (lld_override_operationid); 2023-01-04 09:31:01.085 CET zabbix zabbix [14928]ERROR: relation "lld_override_optemplate" already exists 2023-01-04 09:31:01.085 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE lld_override_optemplate ( lld_override_optemplateid bigint NOT NULL, lld_override_operationid bigint NOT NULL, templateid bigint NOT NULL, PRIMARY KEY (lld_override_optemplateid) ); 2023-01-04 09:31:01.085 CET zabbix zabbix [14928]ERROR: relation "lld_override_optemplate_1" already exists 2023-01-04 09:31:01.085 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX lld_override_optemplate_1 ON lld_override_optemplate (lld_override_operationid,templateid); 2023-01-04 09:31:01.085 CET zabbix zabbix [14928]ERROR: relation "lld_override_optemplate_2" already exists 2023-01-04 09:31:01.085 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX lld_override_optemplate_2 ON lld_override_optemplate (templateid); 2023-01-04 09:31:01.085 CET zabbix zabbix [14928]ERROR: relation "lld_override_opinventory" already exists 2023-01-04 09:31:01.085 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE lld_override_opinventory ( lld_override_operationid bigint NOT NULL, inventory_mode integer DEFAULT '0' NOT NULL, PRIMARY KEY (lld_override_operationid) ); 2023-01-04 09:31:01.085 CET zabbix zabbix [14928]ERROR: relation "trigger_queue" already exists 2023-01-04 09:31:01.085 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE trigger_queue ( trigger_queueid bigint NOT NULL, objectid bigint NOT NULL, type integer DEFAULT '0' NOT NULL, clock integer DEFAULT '0' NOT NULL, ns integer DEFAULT '0' NOT NULL, PRIMARY KEY (trigger_queueid) ); 2023-01-04 09:31:01.085 CET zabbix zabbix [14928]ERROR: relation "item_parameter" already exists 2023-01-04 09:31:01.085 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE item_parameter ( item_parameterid bigint NOT NULL, itemid bigint NOT NULL, name varchar(255) DEFAULT '' NOT NULL, value varchar(2048) DEFAULT '' NOT NULL, PRIMARY KEY (item_parameterid) ); 2023-01-04 09:31:01.086 CET zabbix zabbix [14928]ERROR: relation "item_parameter_1" already exists 2023-01-04 09:31:01.086 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX item_parameter_1 ON item_parameter (itemid); 2023-01-04 09:31:01.086 CET zabbix zabbix [14928]ERROR: relation "role_rule" already exists 2023-01-04 09:31:01.086 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE role_rule ( role_ruleid bigint NOT NULL, roleid bigint NOT NULL, type integer DEFAULT '0' NOT NULL, name varchar(255) DEFAULT '' NOT NULL, value_int integer DEFAULT '0' NOT NULL, value_str varchar(255) DEFAULT '' NOT NULL, value_moduleid bigint NULL, value_serviceid bigint NULL, PRIMARY KEY (role_ruleid) ); 2023-01-04 09:31:01.086 CET zabbix zabbix [14928]ERROR: relation "role_rule_1" already exists 2023-01-04 09:31:01.086 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX role_rule_1 ON role_rule (roleid); 2023-01-04 09:31:01.086 CET zabbix zabbix [14928]ERROR: relation "role_rule_2" already exists 2023-01-04 09:31:01.086 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX role_rule_2 ON role_rule (value_moduleid); 2023-01-04 09:31:01.086 CET zabbix zabbix [14928]ERROR: relation "role_rule_3" already exists 2023-01-04 09:31:01.086 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX role_rule_3 ON role_rule (value_serviceid); 2023-01-04 09:31:01.086 CET zabbix zabbix [14928]ERROR: relation "token" already exists 2023-01-04 09:31:01.086 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE token ( tokenid bigint NOT NULL, name varchar(64) DEFAULT '' NOT NULL, description text DEFAULT '' NOT NULL, userid bigint NOT NULL, token varchar(128) NULL, lastaccess integer DEFAULT '0' NOT NULL, status integer DEFAULT '0' NOT NULL, expires_at integer DEFAULT '0' NOT NULL, created_at integer DEFAULT '0' NOT NULL, creator_userid bigint NULL, PRIMARY KEY (tokenid) ); 2023-01-04 09:31:01.086 CET zabbix zabbix [14928]ERROR: relation "token_1" already exists 2023-01-04 09:31:01.086 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX token_1 ON token (name); 2023-01-04 09:31:01.087 CET zabbix zabbix [14928]ERROR: relation "token_2" already exists 2023-01-04 09:31:01.087 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX token_2 ON token (userid,name); 2023-01-04 09:31:01.087 CET zabbix zabbix [14928]ERROR: relation "token_3" already exists 2023-01-04 09:31:01.087 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX token_3 ON token (token); 2023-01-04 09:31:01.087 CET zabbix zabbix [14928]ERROR: relation "token_4" already exists 2023-01-04 09:31:01.087 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX token_4 ON token (creator_userid); 2023-01-04 09:31:01.087 CET zabbix zabbix [14928]ERROR: relation "item_tag" already exists 2023-01-04 09:31:01.087 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE item_tag ( itemtagid bigint NOT NULL, itemid bigint NOT NULL, tag varchar(255) DEFAULT '' NOT NULL, value varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (itemtagid) ); 2023-01-04 09:31:01.087 CET zabbix zabbix [14928]ERROR: relation "item_tag_1" already exists 2023-01-04 09:31:01.087 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX item_tag_1 ON item_tag (itemid); 2023-01-04 09:31:01.087 CET zabbix zabbix [14928]ERROR: relation "httptest_tag" already exists 2023-01-04 09:31:01.087 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE httptest_tag ( httptesttagid bigint NOT NULL, httptestid bigint NOT NULL, tag varchar(255) DEFAULT '' NOT NULL, value varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (httptesttagid) ); 2023-01-04 09:31:01.087 CET zabbix zabbix [14928]ERROR: relation "httptest_tag_1" already exists 2023-01-04 09:31:01.087 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX httptest_tag_1 ON httptest_tag (httptestid); 2023-01-04 09:31:01.087 CET zabbix zabbix [14928]ERROR: relation "sysmaps_element_tag" already exists 2023-01-04 09:31:01.087 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE sysmaps_element_tag ( selementtagid bigint NOT NULL, selementid bigint NOT NULL, tag varchar(255) DEFAULT '' NOT NULL, value varchar(255) DEFAULT '' NOT NULL, operator integer DEFAULT '0' NOT NULL, PRIMARY KEY (selementtagid) ); 2023-01-04 09:31:01.088 CET zabbix zabbix [14928]ERROR: relation "sysmaps_element_tag_1" already exists 2023-01-04 09:31:01.088 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX sysmaps_element_tag_1 ON sysmaps_element_tag (selementid); 2023-01-04 09:31:01.088 CET zabbix zabbix [14928]ERROR: relation "report" already exists 2023-01-04 09:31:01.088 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE report ( reportid bigint NOT NULL, userid bigint NOT NULL, name varchar(255) DEFAULT '' NOT NULL, description varchar(2048) DEFAULT '' NOT NULL, status integer DEFAULT '0' NOT NULL, dashboardid bigint NOT NULL, period integer DEFAULT '0' NOT NULL, cycle integer DEFAULT '0' NOT NULL, weekdays integer DEFAULT '0' NOT NULL, start_time integer DEFAULT '0' NOT NULL, active_since integer DEFAULT '0' NOT NULL, active_till integer DEFAULT '0' NOT NULL, state integer DEFAULT '0' NOT NULL, lastsent integer DEFAULT '0' NOT NULL, info varchar(2048) DEFAULT '' NOT NULL, PRIMARY KEY (reportid) ); 2023-01-04 09:31:01.088 CET zabbix zabbix [14928]ERROR: relation "report_1" already exists 2023-01-04 09:31:01.088 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX report_1 ON report (name); 2023-01-04 09:31:01.088 CET zabbix zabbix [14928]ERROR: relation "report_param" already exists 2023-01-04 09:31:01.088 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE report_param ( reportparamid bigint NOT NULL, reportid bigint NOT NULL, name varchar(255) DEFAULT '' NOT NULL, value text DEFAULT '' NOT NULL, PRIMARY KEY (reportparamid) ); 2023-01-04 09:31:01.088 CET zabbix zabbix [14928]ERROR: relation "report_param_1" already exists 2023-01-04 09:31:01.088 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX report_param_1 ON report_param (reportid); 2023-01-04 09:31:01.088 CET zabbix zabbix [14928]ERROR: relation "report_user" already exists 2023-01-04 09:31:01.088 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE report_user ( reportuserid bigint NOT NULL, reportid bigint NOT NULL, userid bigint NOT NULL, exclude integer DEFAULT '0' NOT NULL, access_userid bigint NULL, PRIMARY KEY (reportuserid) ); 2023-01-04 09:31:01.088 CET zabbix zabbix [14928]ERROR: relation "report_user_1" already exists 2023-01-04 09:31:01.088 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX report_user_1 ON report_user (reportid); 2023-01-04 09:31:01.089 CET zabbix zabbix [14928]ERROR: relation "report_usrgrp" already exists 2023-01-04 09:31:01.089 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE report_usrgrp ( reportusrgrpid bigint NOT NULL, reportid bigint NOT NULL, usrgrpid bigint NOT NULL, access_userid bigint NULL, PRIMARY KEY (reportusrgrpid) ); 2023-01-04 09:31:01.089 CET zabbix zabbix [14928]ERROR: relation "report_usrgrp_1" already exists 2023-01-04 09:31:01.089 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX report_usrgrp_1 ON report_usrgrp (reportid); 2023-01-04 09:31:01.089 CET zabbix zabbix [14928]ERROR: relation "service_problem_tag" already exists 2023-01-04 09:31:01.089 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE service_problem_tag ( service_problem_tagid bigint NOT NULL, serviceid bigint NOT NULL, tag varchar(255) DEFAULT '' NOT NULL, operator integer DEFAULT '0' NOT NULL, value varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (service_problem_tagid) ); 2023-01-04 09:31:01.089 CET zabbix zabbix [14928]ERROR: relation "service_problem_tag_1" already exists 2023-01-04 09:31:01.089 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX service_problem_tag_1 ON service_problem_tag (serviceid); 2023-01-04 09:31:01.089 CET zabbix zabbix [14928]ERROR: relation "service_problem" already exists 2023-01-04 09:31:01.089 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE service_problem ( service_problemid bigint NOT NULL, eventid bigint NOT NULL, serviceid bigint NOT NULL, severity integer DEFAULT '0' NOT NULL, PRIMARY KEY (service_problemid) ); 2023-01-04 09:31:01.089 CET zabbix zabbix [14928]ERROR: relation "service_problem_1" already exists 2023-01-04 09:31:01.089 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX service_problem_1 ON service_problem (eventid); 2023-01-04 09:31:01.089 CET zabbix zabbix [14928]ERROR: relation "service_problem_2" already exists 2023-01-04 09:31:01.089 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX service_problem_2 ON service_problem (serviceid); 2023-01-04 09:31:01.090 CET zabbix zabbix [14928]ERROR: relation "service_tag" already exists 2023-01-04 09:31:01.090 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE service_tag ( servicetagid bigint NOT NULL, serviceid bigint NOT NULL, tag varchar(255) DEFAULT '' NOT NULL, value varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (servicetagid) ); 2023-01-04 09:31:01.090 CET zabbix zabbix [14928]ERROR: relation "service_tag_1" already exists 2023-01-04 09:31:01.090 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX service_tag_1 ON service_tag (serviceid); 2023-01-04 09:31:01.090 CET zabbix zabbix [14928]ERROR: relation "service_status_rule" already exists 2023-01-04 09:31:01.090 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE service_status_rule ( service_status_ruleid bigint NOT NULL, serviceid bigint NOT NULL, type integer DEFAULT '0' NOT NULL, limit_value integer DEFAULT '0' NOT NULL, limit_status integer DEFAULT '0' NOT NULL, new_status integer DEFAULT '0' NOT NULL, PRIMARY KEY (service_status_ruleid) ); 2023-01-04 09:31:01.090 CET zabbix zabbix [14928]ERROR: relation "service_status_rule_1" already exists 2023-01-04 09:31:01.090 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX service_status_rule_1 ON service_status_rule (serviceid); 2023-01-04 09:31:01.090 CET zabbix zabbix [14928]ERROR: relation "ha_node" already exists 2023-01-04 09:31:01.090 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE ha_node ( ha_nodeid varchar(25) NOT NULL, name varchar(255) DEFAULT '' NOT NULL, address varchar(255) DEFAULT '' NOT NULL, port integer DEFAULT '10051' NOT NULL, lastaccess integer DEFAULT '0' NOT NULL, status integer DEFAULT '0' NOT NULL, ha_sessionid varchar(25) DEFAULT '' NOT NULL, PRIMARY KEY (ha_nodeid) ); 2023-01-04 09:31:01.090 CET zabbix zabbix [14928]ERROR: relation "ha_node_1" already exists 2023-01-04 09:31:01.090 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX ha_node_1 ON ha_node (name); 2023-01-04 09:31:01.090 CET zabbix zabbix [14928]ERROR: relation "ha_node_2" already exists 2023-01-04 09:31:01.090 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX ha_node_2 ON ha_node (status,lastaccess); 2023-01-04 09:31:01.091 CET zabbix zabbix [14928]ERROR: relation "sla" already exists 2023-01-04 09:31:01.091 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE sla ( slaid bigint NOT NULL, name varchar(255) DEFAULT '' NOT NULL, period integer DEFAULT '0' NOT NULL, slo DOUBLE PRECISION DEFAULT '99.9' NOT NULL, effective_date integer DEFAULT '0' NOT NULL, timezone varchar(50) DEFAULT 'UTC' NOT NULL, status integer DEFAULT '1' NOT NULL, description text DEFAULT '' NOT NULL, PRIMARY KEY (slaid) ); 2023-01-04 09:31:01.091 CET zabbix zabbix [14928]ERROR: relation "sla_1" already exists 2023-01-04 09:31:01.091 CET zabbix zabbix [14928]STATEMENT: CREATE UNIQUE INDEX sla_1 ON sla (name); 2023-01-04 09:31:01.091 CET zabbix zabbix [14928]ERROR: relation "sla_schedule" already exists 2023-01-04 09:31:01.091 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE sla_schedule ( sla_scheduleid bigint NOT NULL, slaid bigint NOT NULL, period_from integer DEFAULT '0' NOT NULL, period_to integer DEFAULT '0' NOT NULL, PRIMARY KEY (sla_scheduleid) ); 2023-01-04 09:31:01.091 CET zabbix zabbix [14928]ERROR: relation "sla_schedule_1" already exists 2023-01-04 09:31:01.091 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX sla_schedule_1 ON sla_schedule (slaid); 2023-01-04 09:31:01.091 CET zabbix zabbix [14928]ERROR: relation "sla_excluded_downtime" already exists 2023-01-04 09:31:01.091 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE sla_excluded_downtime ( sla_excluded_downtimeid bigint NOT NULL, slaid bigint NOT NULL, name varchar(255) DEFAULT '' NOT NULL, period_from integer DEFAULT '0' NOT NULL, period_to integer DEFAULT '0' NOT NULL, PRIMARY KEY (sla_excluded_downtimeid) ); 2023-01-04 09:31:01.091 CET zabbix zabbix [14928]ERROR: relation "sla_excluded_downtime_1" already exists 2023-01-04 09:31:01.091 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX sla_excluded_downtime_1 ON sla_excluded_downtime (slaid); 2023-01-04 09:31:01.091 CET zabbix zabbix [14928]ERROR: relation "sla_service_tag" already exists 2023-01-04 09:31:01.091 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE sla_service_tag ( sla_service_tagid bigint NOT NULL, slaid bigint NOT NULL, tag varchar(255) DEFAULT '' NOT NULL, operator integer DEFAULT '0' NOT NULL, value varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (sla_service_tagid) ); 2023-01-04 09:31:01.091 CET zabbix zabbix [14928]ERROR: relation "sla_service_tag_1" already exists 2023-01-04 09:31:01.091 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX sla_service_tag_1 ON sla_service_tag (slaid); 2023-01-04 09:31:01.092 CET zabbix zabbix [14928]ERROR: relation "host_rtdata" already exists 2023-01-04 09:31:01.092 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE host_rtdata ( hostid bigint NOT NULL, active_available integer DEFAULT '0' NOT NULL, lastaccess integer DEFAULT '0' NOT NULL, PRIMARY KEY (hostid) ); 2023-01-04 09:31:01.092 CET zabbix zabbix [14928]ERROR: relation "userdirectory" already exists 2023-01-04 09:31:01.092 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE userdirectory ( userdirectoryid bigint NOT NULL, name varchar(128) DEFAULT '' NOT NULL, description text DEFAULT '' NOT NULL, host varchar(255) DEFAULT '' NOT NULL, port integer DEFAULT '389' NOT NULL, base_dn varchar(255) DEFAULT '' NOT NULL, bind_dn varchar(255) DEFAULT '' NOT NULL, bind_password varchar(128) DEFAULT '' NOT NULL, search_attribute varchar(128) DEFAULT '' NOT NULL, start_tls integer DEFAULT '0' NOT NULL, search_filter varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (userdirectoryid) ); 2023-01-04 09:31:01.092 CET zabbix zabbix [14928]ERROR: relation "changelog" already exists 2023-01-04 09:31:01.092 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE changelog ( changelogid bigserial NOT NULL, object integer DEFAULT '0' NOT NULL, objectid bigint NOT NULL, operation integer DEFAULT '0' NOT NULL, clock integer DEFAULT '0' NOT NULL, PRIMARY KEY (changelogid) ); 2023-01-04 09:31:01.094 CET zabbix zabbix [14928]ERROR: relation "changelog_1" already exists 2023-01-04 09:31:01.094 CET zabbix zabbix [14928]STATEMENT: CREATE INDEX changelog_1 ON changelog (clock); 2023-01-04 09:31:01.098 CET zabbix zabbix [14928]ERROR: relation "dbversion" already exists 2023-01-04 09:31:01.098 CET zabbix zabbix [14928]STATEMENT: CREATE TABLE dbversion ( dbversionid bigint NOT NULL, mandatory integer DEFAULT '0' NOT NULL, optional integer DEFAULT '0' NOT NULL, PRIMARY KEY (dbversionid) ); 2023-01-04 09:31:01.104 CET zabbix zabbix [14928]ERROR: duplicate key value violates unique constraint "dbversion_pkey" 2023-01-04 09:31:01.104 CET zabbix zabbix [14928]DETAIL: Key (dbversionid)=(1) already exists. 2023-01-04 09:31:01.104 CET zabbix zabbix [14928]STATEMENT: INSERT INTO dbversion VALUES ('1','6020000','6020013'); 2023-01-04 09:31:01.116 CET zabbix zabbix [14928]ERROR: trigger "hosts_insert" for relation "hosts" already exists 2023-01-04 09:31:01.116 CET zabbix zabbix [14928]STATEMENT: create trigger hosts_insert after insert on hosts for each row execute procedure changelog_hosts_insert(); 2023-01-04 09:31:01.117 CET zabbix zabbix [14928]ERROR: trigger "hosts_update" for relation "hosts" already exists 2023-01-04 09:31:01.117 CET zabbix zabbix [14928]STATEMENT: create trigger hosts_update after update on hosts for each row execute procedure changelog_hosts_update(); 2023-01-04 09:31:01.119 CET zabbix zabbix [14928]ERROR: trigger "hosts_delete" for relation "hosts" already exists 2023-01-04 09:31:01.119 CET zabbix zabbix [14928]STATEMENT: create trigger hosts_delete before delete on hosts for each row execute procedure changelog_hosts_delete(); 2023-01-04 09:31:01.127 CET zabbix zabbix [14928]ERROR: trigger "items_insert" for relation "items" already exists 2023-01-04 09:31:01.127 CET zabbix zabbix [14928]STATEMENT: create trigger items_insert after insert on items for each row execute procedure changelog_items_insert(); 2023-01-04 09:31:01.129 CET zabbix zabbix [14928]ERROR: trigger "items_update" for relation "items" already exists 2023-01-04 09:31:01.129 CET zabbix zabbix [14928]STATEMENT: create trigger items_update after update on items for each row execute procedure changelog_items_update(); 2023-01-04 09:31:01.131 CET zabbix zabbix [14928]ERROR: trigger "items_delete" for relation "items" already exists 2023-01-04 09:31:01.131 CET zabbix zabbix [14928]STATEMENT: create trigger items_delete before delete on items for each row execute procedure changelog_items_delete(); 2023-01-04 09:31:01.151 CET zabbix zabbix [14928]ERROR: trigger "triggers_insert" for relation "triggers" already exists 2023-01-04 09:31:01.151 CET zabbix zabbix [14928]STATEMENT: create trigger triggers_insert after insert on triggers for each row execute procedure changelog_triggers_insert(); 2023-01-04 09:31:01.153 CET zabbix zabbix [14928]ERROR: trigger "triggers_update" for relation "triggers" already exists 2023-01-04 09:31:01.153 CET zabbix zabbix [14928]STATEMENT: create trigger triggers_update after update on triggers for each row execute procedure changelog_triggers_update(); 2023-01-04 09:31:01.155 CET zabbix zabbix [14928]ERROR: trigger "triggers_delete" for relation "triggers" already exists 2023-01-04 09:31:01.155 CET zabbix zabbix [14928]STATEMENT: create trigger triggers_delete before delete on triggers for each row execute procedure changelog_triggers_delete(); 2023-01-04 09:31:01.156 CET zabbix zabbix [14928]ERROR: trigger "functions_insert" for relation "functions" already exists 2023-01-04 09:31:01.156 CET zabbix zabbix [14928]STATEMENT: create trigger functions_insert after insert on functions for each row execute procedure changelog_functions_insert(); 2023-01-04 09:31:01.158 CET zabbix zabbix [14928]ERROR: trigger "functions_update" for relation "functions" already exists 2023-01-04 09:31:01.158 CET zabbix zabbix [14928]STATEMENT: create trigger functions_update after update on functions for each row execute procedure changelog_functions_update(); 2023-01-04 09:31:01.160 CET zabbix zabbix [14928]ERROR: trigger "functions_delete" for relation "functions" already exists 2023-01-04 09:31:01.160 CET zabbix zabbix [14928]STATEMENT: create trigger functions_delete before delete on functions for each row execute procedure changelog_functions_delete(); 2023-01-04 09:31:01.163 CET zabbix zabbix [14928]ERROR: trigger "trigger_tag_insert" for relation "trigger_tag" already exists 2023-01-04 09:31:01.163 CET zabbix zabbix [14928]STATEMENT: create trigger trigger_tag_insert after insert on trigger_tag for each row execute procedure changelog_trigger_tag_insert(); 2023-01-04 09:31:01.164 CET zabbix zabbix [14928]ERROR: trigger "trigger_tag_update" for relation "trigger_tag" already exists 2023-01-04 09:31:01.164 CET zabbix zabbix [14928]STATEMENT: create trigger trigger_tag_update after update on trigger_tag for each row execute procedure changelog_trigger_tag_update(); 2023-01-04 09:31:01.165 CET zabbix zabbix [14928]ERROR: trigger "trigger_tag_delete" for relation "trigger_tag" already exists 2023-01-04 09:31:01.165 CET zabbix zabbix [14928]STATEMENT: create trigger trigger_tag_delete before delete on trigger_tag for each row execute procedure changelog_trigger_tag_delete(); 2023-01-04 09:31:01.167 CET zabbix zabbix [14928]ERROR: trigger "item_preproc_insert" for relation "item_preproc" already exists 2023-01-04 09:31:01.167 CET zabbix zabbix [14928]STATEMENT: create trigger item_preproc_insert after insert on item_preproc for each row execute procedure changelog_item_preproc_insert(); 2023-01-04 09:31:01.168 CET zabbix zabbix [14928]ERROR: trigger "item_preproc_update" for relation "item_preproc" already exists 2023-01-04 09:31:01.168 CET zabbix zabbix [14928]STATEMENT: create trigger item_preproc_update after update on item_preproc for each row execute procedure changelog_item_preproc_update(); 2023-01-04 09:31:01.170 CET zabbix zabbix [14928]ERROR: trigger "item_preproc_delete" for relation "item_preproc" already exists 2023-01-04 09:31:01.170 CET zabbix zabbix [14928]STATEMENT: create trigger item_preproc_delete before delete on item_preproc for each row execute procedure changelog_item_preproc_delete(); 2023-01-04 09:31:01.172 CET zabbix zabbix [14928]ERROR: trigger "host_tag_insert" for relation "host_tag" already exists 2023-01-04 09:31:01.172 CET zabbix zabbix [14928]STATEMENT: create trigger host_tag_insert after insert on host_tag for each row execute procedure changelog_host_tag_insert(); 2023-01-04 09:31:01.173 CET zabbix zabbix [14928]ERROR: trigger "host_tag_update" for relation "host_tag" already exists 2023-01-04 09:31:01.173 CET zabbix zabbix [14928]STATEMENT: create trigger host_tag_update after update on host_tag for each row execute procedure changelog_host_tag_update(); 2023-01-04 09:31:01.175 CET zabbix zabbix [14928]ERROR: trigger "host_tag_delete" for relation "host_tag" already exists 2023-01-04 09:31:01.175 CET zabbix zabbix [14928]STATEMENT: create trigger host_tag_delete before delete on host_tag for each row execute procedure changelog_host_tag_delete(); 2023-01-04 09:31:01.177 CET zabbix zabbix [14928]ERROR: trigger "item_tag_insert" for relation "item_tag" already exists 2023-01-04 09:31:01.177 CET zabbix zabbix [14928]STATEMENT: create trigger item_tag_insert after insert on item_tag for each row execute procedure changelog_item_tag_insert(); 2023-01-04 09:31:01.178 CET zabbix zabbix [14928]ERROR: trigger "item_tag_update" for relation "item_tag" already exists 2023-01-04 09:31:01.178 CET zabbix zabbix [14928]STATEMENT: create trigger item_tag_update after update on item_tag for each row execute procedure changelog_item_tag_update(); 2023-01-04 09:31:01.179 CET zabbix zabbix [14928]ERROR: trigger "item_tag_delete" for relation "item_tag" already exists 2023-01-04 09:31:01.179 CET zabbix zabbix [14928]STATEMENT: create trigger item_tag_delete before delete on item_tag for each row execute procedure changelog_item_tag_delete(); 2023-01-04 09:31:01.181 CET zabbix zabbix [14928]ERROR: constraint "c_users_1" for relation "users" already exists 2023-01-04 09:31:01.181 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY users ADD CONSTRAINT c_users_1 FOREIGN KEY (roleid) REFERENCES role (roleid) ON DELETE CASCADE; 2023-01-04 09:31:01.181 CET zabbix zabbix [14928]ERROR: constraint "c_hosts_1" for relation "hosts" already exists 2023-01-04 09:31:01.181 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY hosts ADD CONSTRAINT c_hosts_1 FOREIGN KEY (proxy_hostid) REFERENCES hosts (hostid); 2023-01-04 09:31:01.182 CET zabbix zabbix [14928]ERROR: constraint "c_hosts_2" for relation "hosts" already exists 2023-01-04 09:31:01.182 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY hosts ADD CONSTRAINT c_hosts_2 FOREIGN KEY (maintenanceid) REFERENCES maintenances (maintenanceid); 2023-01-04 09:31:01.182 CET zabbix zabbix [14928]ERROR: constraint "c_hosts_3" for relation "hosts" already exists 2023-01-04 09:31:01.182 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY hosts ADD CONSTRAINT c_hosts_3 FOREIGN KEY (templateid) REFERENCES hosts (hostid); 2023-01-04 09:31:01.182 CET zabbix zabbix [14928]ERROR: constraint "c_group_prototype_1" for relation "group_prototype" already exists 2023-01-04 09:31:01.182 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY group_prototype ADD CONSTRAINT c_group_prototype_1 FOREIGN KEY (hostid) REFERENCES hosts (hostid) ON DELETE CASCADE; 2023-01-04 09:31:01.183 CET zabbix zabbix [14928]ERROR: constraint "c_group_prototype_2" for relation "group_prototype" already exists 2023-01-04 09:31:01.183 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY group_prototype ADD CONSTRAINT c_group_prototype_2 FOREIGN KEY (groupid) REFERENCES hstgrp (groupid); 2023-01-04 09:31:01.183 CET zabbix zabbix [14928]ERROR: constraint "c_group_prototype_3" for relation "group_prototype" already exists 2023-01-04 09:31:01.183 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY group_prototype ADD CONSTRAINT c_group_prototype_3 FOREIGN KEY (templateid) REFERENCES group_prototype (group_prototypeid) ON DELETE CASCADE; 2023-01-04 09:31:01.183 CET zabbix zabbix [14928]ERROR: constraint "c_group_discovery_1" for relation "group_discovery" already exists 2023-01-04 09:31:01.183 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY group_discovery ADD CONSTRAINT c_group_discovery_1 FOREIGN KEY (groupid) REFERENCES hstgrp (groupid) ON DELETE CASCADE; 2023-01-04 09:31:01.183 CET zabbix zabbix [14928]ERROR: constraint "c_group_discovery_2" for relation "group_discovery" already exists 2023-01-04 09:31:01.183 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY group_discovery ADD CONSTRAINT c_group_discovery_2 FOREIGN KEY (parent_group_prototypeid) REFERENCES group_prototype (group_prototypeid); 2023-01-04 09:31:01.183 CET zabbix zabbix [14928]ERROR: constraint "c_drules_1" for relation "drules" already exists 2023-01-04 09:31:01.183 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY drules ADD CONSTRAINT c_drules_1 FOREIGN KEY (proxy_hostid) REFERENCES hosts (hostid); 2023-01-04 09:31:01.183 CET zabbix zabbix [14928]ERROR: constraint "c_dchecks_1" for relation "dchecks" already exists 2023-01-04 09:31:01.183 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY dchecks ADD CONSTRAINT c_dchecks_1 FOREIGN KEY (druleid) REFERENCES drules (druleid) ON DELETE CASCADE; 2023-01-04 09:31:01.183 CET zabbix zabbix [14928]ERROR: constraint "c_httptest_2" for relation "httptest" already exists 2023-01-04 09:31:01.183 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY httptest ADD CONSTRAINT c_httptest_2 FOREIGN KEY (hostid) REFERENCES hosts (hostid) ON DELETE CASCADE; 2023-01-04 09:31:01.183 CET zabbix zabbix [14928]ERROR: constraint "c_httptest_3" for relation "httptest" already exists 2023-01-04 09:31:01.183 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY httptest ADD CONSTRAINT c_httptest_3 FOREIGN KEY (templateid) REFERENCES httptest (httptestid) ON DELETE CASCADE; 2023-01-04 09:31:01.183 CET zabbix zabbix [14928]ERROR: constraint "c_httpstep_1" for relation "httpstep" already exists 2023-01-04 09:31:01.183 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY httpstep ADD CONSTRAINT c_httpstep_1 FOREIGN KEY (httptestid) REFERENCES httptest (httptestid) ON DELETE CASCADE; 2023-01-04 09:31:01.184 CET zabbix zabbix [14928]ERROR: constraint "c_interface_1" for relation "interface" already exists 2023-01-04 09:31:01.184 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY interface ADD CONSTRAINT c_interface_1 FOREIGN KEY (hostid) REFERENCES hosts (hostid) ON DELETE CASCADE; 2023-01-04 09:31:01.184 CET zabbix zabbix [14928]ERROR: constraint "c_valuemap_1" for relation "valuemap" already exists 2023-01-04 09:31:01.184 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY valuemap ADD CONSTRAINT c_valuemap_1 FOREIGN KEY (hostid) REFERENCES hosts (hostid) ON DELETE CASCADE; 2023-01-04 09:31:01.184 CET zabbix zabbix [14928]ERROR: constraint "c_items_1" for relation "items" already exists 2023-01-04 09:31:01.184 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY items ADD CONSTRAINT c_items_1 FOREIGN KEY (hostid) REFERENCES hosts (hostid); 2023-01-04 09:31:01.184 CET zabbix zabbix [14928]ERROR: constraint "c_items_2" for relation "items" already exists 2023-01-04 09:31:01.184 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY items ADD CONSTRAINT c_items_2 FOREIGN KEY (templateid) REFERENCES items (itemid); 2023-01-04 09:31:01.184 CET zabbix zabbix [14928]ERROR: constraint "c_items_3" for relation "items" already exists 2023-01-04 09:31:01.184 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY items ADD CONSTRAINT c_items_3 FOREIGN KEY (valuemapid) REFERENCES valuemap (valuemapid); 2023-01-04 09:31:01.184 CET zabbix zabbix [14928]ERROR: constraint "c_items_4" for relation "items" already exists 2023-01-04 09:31:01.184 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY items ADD CONSTRAINT c_items_4 FOREIGN KEY (interfaceid) REFERENCES interface (interfaceid); 2023-01-04 09:31:01.184 CET zabbix zabbix [14928]ERROR: constraint "c_items_5" for relation "items" already exists 2023-01-04 09:31:01.184 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY items ADD CONSTRAINT c_items_5 FOREIGN KEY (master_itemid) REFERENCES items (itemid); 2023-01-04 09:31:01.184 CET zabbix zabbix [14928]ERROR: constraint "c_httpstepitem_1" for relation "httpstepitem" already exists 2023-01-04 09:31:01.184 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY httpstepitem ADD CONSTRAINT c_httpstepitem_1 FOREIGN KEY (httpstepid) REFERENCES httpstep (httpstepid) ON DELETE CASCADE; 2023-01-04 09:31:01.184 CET zabbix zabbix [14928]ERROR: constraint "c_httpstepitem_2" for relation "httpstepitem" already exists 2023-01-04 09:31:01.184 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY httpstepitem ADD CONSTRAINT c_httpstepitem_2 FOREIGN KEY (itemid) REFERENCES items (itemid) ON DELETE CASCADE; 2023-01-04 09:31:01.185 CET zabbix zabbix [14928]ERROR: constraint "c_httptestitem_1" for relation "httptestitem" already exists 2023-01-04 09:31:01.185 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY httptestitem ADD CONSTRAINT c_httptestitem_1 FOREIGN KEY (httptestid) REFERENCES httptest (httptestid) ON DELETE CASCADE; 2023-01-04 09:31:01.185 CET zabbix zabbix [14928]ERROR: constraint "c_httptestitem_2" for relation "httptestitem" already exists 2023-01-04 09:31:01.185 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY httptestitem ADD CONSTRAINT c_httptestitem_2 FOREIGN KEY (itemid) REFERENCES items (itemid) ON DELETE CASCADE; 2023-01-04 09:31:01.185 CET zabbix zabbix [14928]ERROR: constraint "c_media_type_param_1" for relation "media_type_param" already exists 2023-01-04 09:31:01.185 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY media_type_param ADD CONSTRAINT c_media_type_param_1 FOREIGN KEY (mediatypeid) REFERENCES media_type (mediatypeid) ON DELETE CASCADE; 2023-01-04 09:31:01.185 CET zabbix zabbix [14928]ERROR: constraint "c_media_type_message_1" for relation "media_type_message" already exists 2023-01-04 09:31:01.185 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY media_type_message ADD CONSTRAINT c_media_type_message_1 FOREIGN KEY (mediatypeid) REFERENCES media_type (mediatypeid) ON DELETE CASCADE; 2023-01-04 09:31:01.185 CET zabbix zabbix [14928]ERROR: constraint "c_usrgrp_2" for relation "usrgrp" already exists 2023-01-04 09:31:01.185 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY usrgrp ADD CONSTRAINT c_usrgrp_2 FOREIGN KEY (userdirectoryid) REFERENCES userdirectory (userdirectoryid); 2023-01-04 09:31:01.185 CET zabbix zabbix [14928]ERROR: constraint "c_users_groups_1" for relation "users_groups" already exists 2023-01-04 09:31:01.185 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY users_groups ADD CONSTRAINT c_users_groups_1 FOREIGN KEY (usrgrpid) REFERENCES usrgrp (usrgrpid) ON DELETE CASCADE; 2023-01-04 09:31:01.185 CET zabbix zabbix [14928]ERROR: constraint "c_users_groups_2" for relation "users_groups" already exists 2023-01-04 09:31:01.185 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY users_groups ADD CONSTRAINT c_users_groups_2 FOREIGN KEY (userid) REFERENCES users (userid) ON DELETE CASCADE; 2023-01-04 09:31:01.185 CET zabbix zabbix [14928]ERROR: constraint "c_scripts_1" for relation "scripts" already exists 2023-01-04 09:31:01.185 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY scripts ADD CONSTRAINT c_scripts_1 FOREIGN KEY (usrgrpid) REFERENCES usrgrp (usrgrpid); 2023-01-04 09:31:01.185 CET zabbix zabbix [14928]ERROR: constraint "c_scripts_2" for relation "scripts" already exists 2023-01-04 09:31:01.185 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY scripts ADD CONSTRAINT c_scripts_2 FOREIGN KEY (groupid) REFERENCES hstgrp (groupid); 2023-01-04 09:31:01.185 CET zabbix zabbix [14928]ERROR: constraint "c_script_param_1" for relation "script_param" already exists 2023-01-04 09:31:01.185 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY script_param ADD CONSTRAINT c_script_param_1 FOREIGN KEY (scriptid) REFERENCES scripts (scriptid) ON DELETE CASCADE; 2023-01-04 09:31:01.185 CET zabbix zabbix [14928]ERROR: constraint "c_operations_1" for relation "operations" already exists 2023-01-04 09:31:01.185 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY operations ADD CONSTRAINT c_operations_1 FOREIGN KEY (actionid) REFERENCES actions (actionid) ON DELETE CASCADE; 2023-01-04 09:31:01.186 CET zabbix zabbix [14928]ERROR: constraint "c_opmessage_1" for relation "opmessage" already exists 2023-01-04 09:31:01.186 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY opmessage ADD CONSTRAINT c_opmessage_1 FOREIGN KEY (operationid) REFERENCES operations (operationid) ON DELETE CASCADE; 2023-01-04 09:31:01.186 CET zabbix zabbix [14928]ERROR: constraint "c_opmessage_2" for relation "opmessage" already exists 2023-01-04 09:31:01.186 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY opmessage ADD CONSTRAINT c_opmessage_2 FOREIGN KEY (mediatypeid) REFERENCES media_type (mediatypeid); 2023-01-04 09:31:01.186 CET zabbix zabbix [14928]ERROR: constraint "c_opmessage_grp_1" for relation "opmessage_grp" already exists 2023-01-04 09:31:01.186 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY opmessage_grp ADD CONSTRAINT c_opmessage_grp_1 FOREIGN KEY (operationid) REFERENCES operations (operationid) ON DELETE CASCADE; 2023-01-04 09:31:01.186 CET zabbix zabbix [14928]ERROR: constraint "c_opmessage_grp_2" for relation "opmessage_grp" already exists 2023-01-04 09:31:01.186 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY opmessage_grp ADD CONSTRAINT c_opmessage_grp_2 FOREIGN KEY (usrgrpid) REFERENCES usrgrp (usrgrpid); 2023-01-04 09:31:01.186 CET zabbix zabbix [14928]ERROR: constraint "c_opmessage_usr_1" for relation "opmessage_usr" already exists 2023-01-04 09:31:01.186 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY opmessage_usr ADD CONSTRAINT c_opmessage_usr_1 FOREIGN KEY (operationid) REFERENCES operations (operationid) ON DELETE CASCADE; 2023-01-04 09:31:01.186 CET zabbix zabbix [14928]ERROR: constraint "c_opmessage_usr_2" for relation "opmessage_usr" already exists 2023-01-04 09:31:01.186 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY opmessage_usr ADD CONSTRAINT c_opmessage_usr_2 FOREIGN KEY (userid) REFERENCES users (userid); 2023-01-04 09:31:01.186 CET zabbix zabbix [14928]ERROR: constraint "c_opcommand_1" for relation "opcommand" already exists 2023-01-04 09:31:01.186 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY opcommand ADD CONSTRAINT c_opcommand_1 FOREIGN KEY (operationid) REFERENCES operations (operationid) ON DELETE CASCADE; 2023-01-04 09:31:01.186 CET zabbix zabbix [14928]ERROR: constraint "c_opcommand_2" for relation "opcommand" already exists 2023-01-04 09:31:01.186 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY opcommand ADD CONSTRAINT c_opcommand_2 FOREIGN KEY (scriptid) REFERENCES scripts (scriptid); 2023-01-04 09:31:01.186 CET zabbix zabbix [14928]ERROR: constraint "c_opcommand_hst_1" for relation "opcommand_hst" already exists 2023-01-04 09:31:01.186 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY opcommand_hst ADD CONSTRAINT c_opcommand_hst_1 FOREIGN KEY (operationid) REFERENCES operations (operationid) ON DELETE CASCADE; 2023-01-04 09:31:01.186 CET zabbix zabbix [14928]ERROR: constraint "c_opcommand_hst_2" for relation "opcommand_hst" already exists 2023-01-04 09:31:01.186 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY opcommand_hst ADD CONSTRAINT c_opcommand_hst_2 FOREIGN KEY (hostid) REFERENCES hosts (hostid); 2023-01-04 09:31:01.186 CET zabbix zabbix [14928]ERROR: constraint "c_opcommand_grp_1" for relation "opcommand_grp" already exists 2023-01-04 09:31:01.186 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY opcommand_grp ADD CONSTRAINT c_opcommand_grp_1 FOREIGN KEY (operationid) REFERENCES operations (operationid) ON DELETE CASCADE; 2023-01-04 09:31:01.187 CET zabbix zabbix [14928]ERROR: constraint "c_opcommand_grp_2" for relation "opcommand_grp" already exists 2023-01-04 09:31:01.187 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY opcommand_grp ADD CONSTRAINT c_opcommand_grp_2 FOREIGN KEY (groupid) REFERENCES hstgrp (groupid); 2023-01-04 09:31:01.187 CET zabbix zabbix [14928]ERROR: constraint "c_opgroup_1" for relation "opgroup" already exists 2023-01-04 09:31:01.187 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY opgroup ADD CONSTRAINT c_opgroup_1 FOREIGN KEY (operationid) REFERENCES operations (operationid) ON DELETE CASCADE; 2023-01-04 09:31:01.187 CET zabbix zabbix [14928]ERROR: constraint "c_opgroup_2" for relation "opgroup" already exists 2023-01-04 09:31:01.187 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY opgroup ADD CONSTRAINT c_opgroup_2 FOREIGN KEY (groupid) REFERENCES hstgrp (groupid); 2023-01-04 09:31:01.187 CET zabbix zabbix [14928]ERROR: constraint "c_optemplate_1" for relation "optemplate" already exists 2023-01-04 09:31:01.187 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY optemplate ADD CONSTRAINT c_optemplate_1 FOREIGN KEY (operationid) REFERENCES operations (operationid) ON DELETE CASCADE; 2023-01-04 09:31:01.187 CET zabbix zabbix [14928]ERROR: constraint "c_optemplate_2" for relation "optemplate" already exists 2023-01-04 09:31:01.187 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY optemplate ADD CONSTRAINT c_optemplate_2 FOREIGN KEY (templateid) REFERENCES hosts (hostid); 2023-01-04 09:31:01.187 CET zabbix zabbix [14928]ERROR: constraint "c_opconditions_1" for relation "opconditions" already exists 2023-01-04 09:31:01.187 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY opconditions ADD CONSTRAINT c_opconditions_1 FOREIGN KEY (operationid) REFERENCES operations (operationid) ON DELETE CASCADE; 2023-01-04 09:31:01.187 CET zabbix zabbix [14928]ERROR: constraint "c_conditions_1" for relation "conditions" already exists 2023-01-04 09:31:01.187 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY conditions ADD CONSTRAINT c_conditions_1 FOREIGN KEY (actionid) REFERENCES actions (actionid) ON DELETE CASCADE; 2023-01-04 09:31:01.187 CET zabbix zabbix [14928]ERROR: constraint "c_config_1" for relation "config" already exists 2023-01-04 09:31:01.187 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY config ADD CONSTRAINT c_config_1 FOREIGN KEY (alert_usrgrpid) REFERENCES usrgrp (usrgrpid); 2023-01-04 09:31:01.187 CET zabbix zabbix [14928]ERROR: constraint "c_config_2" for relation "config" already exists 2023-01-04 09:31:01.187 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY config ADD CONSTRAINT c_config_2 FOREIGN KEY (discovery_groupid) REFERENCES hstgrp (groupid); 2023-01-04 09:31:01.188 CET zabbix zabbix [14928]ERROR: constraint "c_config_3" for relation "config" already exists 2023-01-04 09:31:01.188 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY config ADD CONSTRAINT c_config_3 FOREIGN KEY (ldap_userdirectoryid) REFERENCES userdirectory (userdirectoryid); 2023-01-04 09:31:01.188 CET zabbix zabbix [14928]ERROR: constraint "c_triggers_1" for relation "triggers" already exists 2023-01-04 09:31:01.188 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY triggers ADD CONSTRAINT c_triggers_1 FOREIGN KEY (templateid) REFERENCES triggers (triggerid); 2023-01-04 09:31:01.191 CET zabbix zabbix [14928]ERROR: constraint "c_trigger_depends_1" for relation "trigger_depends" already exists 2023-01-04 09:31:01.191 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY trigger_depends ADD CONSTRAINT c_trigger_depends_1 FOREIGN KEY (triggerid_down) REFERENCES triggers (triggerid) ON DELETE CASCADE; 2023-01-04 09:31:01.191 CET zabbix zabbix [14928]ERROR: constraint "c_trigger_depends_2" for relation "trigger_depends" already exists 2023-01-04 09:31:01.191 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY trigger_depends ADD CONSTRAINT c_trigger_depends_2 FOREIGN KEY (triggerid_up) REFERENCES triggers (triggerid) ON DELETE CASCADE; 2023-01-04 09:31:01.192 CET zabbix zabbix [14928]ERROR: constraint "c_functions_1" for relation "functions" already exists 2023-01-04 09:31:01.192 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY functions ADD CONSTRAINT c_functions_1 FOREIGN KEY (itemid) REFERENCES items (itemid); 2023-01-04 09:31:01.193 CET zabbix zabbix [14928]ERROR: constraint "c_functions_2" for relation "functions" already exists 2023-01-04 09:31:01.193 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY functions ADD CONSTRAINT c_functions_2 FOREIGN KEY (triggerid) REFERENCES triggers (triggerid); 2023-01-04 09:31:01.194 CET zabbix zabbix [14928]ERROR: constraint "c_graphs_1" for relation "graphs" already exists 2023-01-04 09:31:01.194 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY graphs ADD CONSTRAINT c_graphs_1 FOREIGN KEY (templateid) REFERENCES graphs (graphid) ON DELETE CASCADE; 2023-01-04 09:31:01.194 CET zabbix zabbix [14928]ERROR: constraint "c_graphs_2" for relation "graphs" already exists 2023-01-04 09:31:01.194 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY graphs ADD CONSTRAINT c_graphs_2 FOREIGN KEY (ymin_itemid) REFERENCES items (itemid); 2023-01-04 09:31:01.194 CET zabbix zabbix [14928]ERROR: constraint "c_graphs_3" for relation "graphs" already exists 2023-01-04 09:31:01.194 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY graphs ADD CONSTRAINT c_graphs_3 FOREIGN KEY (ymax_itemid) REFERENCES items (itemid); 2023-01-04 09:31:01.194 CET zabbix zabbix [14928]ERROR: constraint "c_graphs_items_1" for relation "graphs_items" already exists 2023-01-04 09:31:01.194 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY graphs_items ADD CONSTRAINT c_graphs_items_1 FOREIGN KEY (graphid) REFERENCES graphs (graphid) ON DELETE CASCADE; 2023-01-04 09:31:01.194 CET zabbix zabbix [14928]ERROR: constraint "c_graphs_items_2" for relation "graphs_items" already exists 2023-01-04 09:31:01.194 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY graphs_items ADD CONSTRAINT c_graphs_items_2 FOREIGN KEY (itemid) REFERENCES items (itemid) ON DELETE CASCADE; 2023-01-04 09:31:01.198 CET zabbix zabbix [14928]ERROR: constraint "c_hostmacro_1" for relation "hostmacro" already exists 2023-01-04 09:31:01.198 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY hostmacro ADD CONSTRAINT c_hostmacro_1 FOREIGN KEY (hostid) REFERENCES hosts (hostid) ON DELETE CASCADE; 2023-01-04 09:31:01.198 CET zabbix zabbix [14928]ERROR: constraint "c_hosts_groups_1" for relation "hosts_groups" already exists 2023-01-04 09:31:01.198 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY hosts_groups ADD CONSTRAINT c_hosts_groups_1 FOREIGN KEY (hostid) REFERENCES hosts (hostid) ON DELETE CASCADE; 2023-01-04 09:31:01.199 CET zabbix zabbix [14928]ERROR: constraint "c_hosts_groups_2" for relation "hosts_groups" already exists 2023-01-04 09:31:01.199 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY hosts_groups ADD CONSTRAINT c_hosts_groups_2 FOREIGN KEY (groupid) REFERENCES hstgrp (groupid) ON DELETE CASCADE; 2023-01-04 09:31:01.199 CET zabbix zabbix [14928]ERROR: constraint "c_hosts_templates_1" for relation "hosts_templates" already exists 2023-01-04 09:31:01.199 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY hosts_templates ADD CONSTRAINT c_hosts_templates_1 FOREIGN KEY (hostid) REFERENCES hosts (hostid) ON DELETE CASCADE; 2023-01-04 09:31:01.199 CET zabbix zabbix [14928]ERROR: constraint "c_hosts_templates_2" for relation "hosts_templates" already exists 2023-01-04 09:31:01.199 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY hosts_templates ADD CONSTRAINT c_hosts_templates_2 FOREIGN KEY (templateid) REFERENCES hosts (hostid) ON DELETE CASCADE; 2023-01-04 09:31:01.199 CET zabbix zabbix [14928]ERROR: constraint "c_valuemap_mapping_1" for relation "valuemap_mapping" already exists 2023-01-04 09:31:01.199 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY valuemap_mapping ADD CONSTRAINT c_valuemap_mapping_1 FOREIGN KEY (valuemapid) REFERENCES valuemap (valuemapid) ON DELETE CASCADE; 2023-01-04 09:31:01.199 CET zabbix zabbix [14928]ERROR: constraint "c_media_1" for relation "media" already exists 2023-01-04 09:31:01.199 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY media ADD CONSTRAINT c_media_1 FOREIGN KEY (userid) REFERENCES users (userid) ON DELETE CASCADE; 2023-01-04 09:31:01.199 CET zabbix zabbix [14928]ERROR: constraint "c_media_2" for relation "media" already exists 2023-01-04 09:31:01.199 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY media ADD CONSTRAINT c_media_2 FOREIGN KEY (mediatypeid) REFERENCES media_type (mediatypeid) ON DELETE CASCADE; 2023-01-04 09:31:01.199 CET zabbix zabbix [14928]ERROR: constraint "c_rights_1" for relation "rights" already exists 2023-01-04 09:31:01.199 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY rights ADD CONSTRAINT c_rights_1 FOREIGN KEY (groupid) REFERENCES usrgrp (usrgrpid) ON DELETE CASCADE; 2023-01-04 09:31:01.199 CET zabbix zabbix [14928]ERROR: constraint "c_rights_2" for relation "rights" already exists 2023-01-04 09:31:01.199 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY rights ADD CONSTRAINT c_rights_2 FOREIGN KEY (id) REFERENCES hstgrp (groupid) ON DELETE CASCADE; 2023-01-04 09:31:01.199 CET zabbix zabbix [14928]ERROR: constraint "c_services_links_1" for relation "services_links" already exists 2023-01-04 09:31:01.199 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY services_links ADD CONSTRAINT c_services_links_1 FOREIGN KEY (serviceupid) REFERENCES services (serviceid) ON DELETE CASCADE; 2023-01-04 09:31:01.199 CET zabbix zabbix [14928]ERROR: constraint "c_services_links_2" for relation "services_links" already exists 2023-01-04 09:31:01.199 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY services_links ADD CONSTRAINT c_services_links_2 FOREIGN KEY (servicedownid) REFERENCES services (serviceid) ON DELETE CASCADE; 2023-01-04 09:31:01.199 CET zabbix zabbix [14928]ERROR: constraint "c_icon_map_1" for relation "icon_map" already exists 2023-01-04 09:31:01.199 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY icon_map ADD CONSTRAINT c_icon_map_1 FOREIGN KEY (default_iconid) REFERENCES images (imageid); 2023-01-04 09:31:01.200 CET zabbix zabbix [14928]ERROR: constraint "c_icon_mapping_1" for relation "icon_mapping" already exists 2023-01-04 09:31:01.200 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY icon_mapping ADD CONSTRAINT c_icon_mapping_1 FOREIGN KEY (iconmapid) REFERENCES icon_map (iconmapid) ON DELETE CASCADE; 2023-01-04 09:31:01.200 CET zabbix zabbix [14928]ERROR: constraint "c_icon_mapping_2" for relation "icon_mapping" already exists 2023-01-04 09:31:01.200 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY icon_mapping ADD CONSTRAINT c_icon_mapping_2 FOREIGN KEY (iconid) REFERENCES images (imageid); 2023-01-04 09:31:01.200 CET zabbix zabbix [14928]ERROR: constraint "c_sysmaps_1" for relation "sysmaps" already exists 2023-01-04 09:31:01.200 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY sysmaps ADD CONSTRAINT c_sysmaps_1 FOREIGN KEY (backgroundid) REFERENCES images (imageid); 2023-01-04 09:31:01.200 CET zabbix zabbix [14928]ERROR: constraint "c_sysmaps_2" for relation "sysmaps" already exists 2023-01-04 09:31:01.200 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY sysmaps ADD CONSTRAINT c_sysmaps_2 FOREIGN KEY (iconmapid) REFERENCES icon_map (iconmapid); 2023-01-04 09:31:01.200 CET zabbix zabbix [14928]ERROR: constraint "c_sysmaps_3" for relation "sysmaps" already exists 2023-01-04 09:31:01.200 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY sysmaps ADD CONSTRAINT c_sysmaps_3 FOREIGN KEY (userid) REFERENCES users (userid); 2023-01-04 09:31:01.200 CET zabbix zabbix [14928]ERROR: constraint "c_sysmaps_elements_1" for relation "sysmaps_elements" already exists 2023-01-04 09:31:01.200 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY sysmaps_elements ADD CONSTRAINT c_sysmaps_elements_1 FOREIGN KEY (sysmapid) REFERENCES sysmaps (sysmapid) ON DELETE CASCADE; 2023-01-04 09:31:01.200 CET zabbix zabbix [14928]ERROR: constraint "c_sysmaps_elements_2" for relation "sysmaps_elements" already exists 2023-01-04 09:31:01.200 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY sysmaps_elements ADD CONSTRAINT c_sysmaps_elements_2 FOREIGN KEY (iconid_off) REFERENCES images (imageid); 2023-01-04 09:31:01.200 CET zabbix zabbix [14928]ERROR: constraint "c_sysmaps_elements_3" for relation "sysmaps_elements" already exists 2023-01-04 09:31:01.200 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY sysmaps_elements ADD CONSTRAINT c_sysmaps_elements_3 FOREIGN KEY (iconid_on) REFERENCES images (imageid); 2023-01-04 09:31:01.200 CET zabbix zabbix [14928]ERROR: constraint "c_sysmaps_elements_4" for relation "sysmaps_elements" already exists 2023-01-04 09:31:01.200 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY sysmaps_elements ADD CONSTRAINT c_sysmaps_elements_4 FOREIGN KEY (iconid_disabled) REFERENCES images (imageid); 2023-01-04 09:31:01.201 CET zabbix zabbix [14928]ERROR: constraint "c_sysmaps_elements_5" for relation "sysmaps_elements" already exists 2023-01-04 09:31:01.201 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY sysmaps_elements ADD CONSTRAINT c_sysmaps_elements_5 FOREIGN KEY (iconid_maintenance) REFERENCES images (imageid); 2023-01-04 09:31:01.201 CET zabbix zabbix [14928]ERROR: constraint "c_sysmaps_links_1" for relation "sysmaps_links" already exists 2023-01-04 09:31:01.201 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY sysmaps_links ADD CONSTRAINT c_sysmaps_links_1 FOREIGN KEY (sysmapid) REFERENCES sysmaps (sysmapid) ON DELETE CASCADE; 2023-01-04 09:31:01.201 CET zabbix zabbix [14928]ERROR: constraint "c_sysmaps_links_2" for relation "sysmaps_links" already exists 2023-01-04 09:31:01.201 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY sysmaps_links ADD CONSTRAINT c_sysmaps_links_2 FOREIGN KEY (selementid1) REFERENCES sysmaps_elements (selementid) ON DELETE CASCADE; 2023-01-04 09:31:01.201 CET zabbix zabbix [14928]ERROR: constraint "c_sysmaps_links_3" for relation "sysmaps_links" already exists 2023-01-04 09:31:01.201 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY sysmaps_links ADD CONSTRAINT c_sysmaps_links_3 FOREIGN KEY (selementid2) REFERENCES sysmaps_elements (selementid) ON DELETE CASCADE; 2023-01-04 09:31:01.201 CET zabbix zabbix [14928]ERROR: constraint "c_sysmaps_link_triggers_1" for relation "sysmaps_link_triggers" already exists 2023-01-04 09:31:01.201 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY sysmaps_link_triggers ADD CONSTRAINT c_sysmaps_link_triggers_1 FOREIGN KEY (linkid) REFERENCES sysmaps_links (linkid) ON DELETE CASCADE; 2023-01-04 09:31:01.201 CET zabbix zabbix [14928]ERROR: constraint "c_sysmaps_link_triggers_2" for relation "sysmaps_link_triggers" already exists 2023-01-04 09:31:01.201 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY sysmaps_link_triggers ADD CONSTRAINT c_sysmaps_link_triggers_2 FOREIGN KEY (triggerid) REFERENCES triggers (triggerid) ON DELETE CASCADE; 2023-01-04 09:31:01.201 CET zabbix zabbix [14928]ERROR: constraint "c_sysmap_element_url_1" for relation "sysmap_element_url" already exists 2023-01-04 09:31:01.201 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY sysmap_element_url ADD CONSTRAINT c_sysmap_element_url_1 FOREIGN KEY (selementid) REFERENCES sysmaps_elements (selementid) ON DELETE CASCADE; 2023-01-04 09:31:01.202 CET zabbix zabbix [14928]ERROR: constraint "c_sysmap_url_1" for relation "sysmap_url" already exists 2023-01-04 09:31:01.202 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY sysmap_url ADD CONSTRAINT c_sysmap_url_1 FOREIGN KEY (sysmapid) REFERENCES sysmaps (sysmapid) ON DELETE CASCADE; 2023-01-04 09:31:01.202 CET zabbix zabbix [14928]ERROR: constraint "c_sysmap_user_1" for relation "sysmap_user" already exists 2023-01-04 09:31:01.202 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY sysmap_user ADD CONSTRAINT c_sysmap_user_1 FOREIGN KEY (sysmapid) REFERENCES sysmaps (sysmapid) ON DELETE CASCADE; 2023-01-04 09:31:01.202 CET zabbix zabbix [14928]ERROR: constraint "c_sysmap_user_2" for relation "sysmap_user" already exists 2023-01-04 09:31:01.202 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY sysmap_user ADD CONSTRAINT c_sysmap_user_2 FOREIGN KEY (userid) REFERENCES users (userid) ON DELETE CASCADE; 2023-01-04 09:31:01.202 CET zabbix zabbix [14928]ERROR: constraint "c_sysmap_usrgrp_1" for relation "sysmap_usrgrp" already exists 2023-01-04 09:31:01.202 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY sysmap_usrgrp ADD CONSTRAINT c_sysmap_usrgrp_1 FOREIGN KEY (sysmapid) REFERENCES sysmaps (sysmapid) ON DELETE CASCADE; 2023-01-04 09:31:01.202 CET zabbix zabbix [14928]ERROR: constraint "c_sysmap_usrgrp_2" for relation "sysmap_usrgrp" already exists 2023-01-04 09:31:01.202 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY sysmap_usrgrp ADD CONSTRAINT c_sysmap_usrgrp_2 FOREIGN KEY (usrgrpid) REFERENCES usrgrp (usrgrpid) ON DELETE CASCADE; 2023-01-04 09:31:01.202 CET zabbix zabbix [14928]ERROR: constraint "c_maintenances_hosts_1" for relation "maintenances_hosts" already exists 2023-01-04 09:31:01.202 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY maintenances_hosts ADD CONSTRAINT c_maintenances_hosts_1 FOREIGN KEY (maintenanceid) REFERENCES maintenances (maintenanceid) ON DELETE CASCADE; 2023-01-04 09:31:01.202 CET zabbix zabbix [14928]ERROR: constraint "c_maintenances_hosts_2" for relation "maintenances_hosts" already exists 2023-01-04 09:31:01.202 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY maintenances_hosts ADD CONSTRAINT c_maintenances_hosts_2 FOREIGN KEY (hostid) REFERENCES hosts (hostid) ON DELETE CASCADE; 2023-01-04 09:31:01.202 CET zabbix zabbix [14928]ERROR: constraint "c_maintenances_groups_1" for relation "maintenances_groups" already exists 2023-01-04 09:31:01.202 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY maintenances_groups ADD CONSTRAINT c_maintenances_groups_1 FOREIGN KEY (maintenanceid) REFERENCES maintenances (maintenanceid) ON DELETE CASCADE; 2023-01-04 09:31:01.203 CET zabbix zabbix [14928]ERROR: constraint "c_maintenances_groups_2" for relation "maintenances_groups" already exists 2023-01-04 09:31:01.203 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY maintenances_groups ADD CONSTRAINT c_maintenances_groups_2 FOREIGN KEY (groupid) REFERENCES hstgrp (groupid) ON DELETE CASCADE; 2023-01-04 09:31:01.203 CET zabbix zabbix [14928]ERROR: constraint "c_maintenances_windows_1" for relation "maintenances_windows" already exists 2023-01-04 09:31:01.203 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY maintenances_windows ADD CONSTRAINT c_maintenances_windows_1 FOREIGN KEY (maintenanceid) REFERENCES maintenances (maintenanceid) ON DELETE CASCADE; 2023-01-04 09:31:01.203 CET zabbix zabbix [14928]ERROR: constraint "c_maintenances_windows_2" for relation "maintenances_windows" already exists 2023-01-04 09:31:01.203 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY maintenances_windows ADD CONSTRAINT c_maintenances_windows_2 FOREIGN KEY (timeperiodid) REFERENCES timeperiods (timeperiodid) ON DELETE CASCADE; 2023-01-04 09:31:01.203 CET zabbix zabbix [14928]ERROR: constraint "c_expressions_1" for relation "expressions" already exists 2023-01-04 09:31:01.203 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY expressions ADD CONSTRAINT c_expressions_1 FOREIGN KEY (regexpid) REFERENCES regexps (regexpid) ON DELETE CASCADE; 2023-01-04 09:31:01.203 CET zabbix zabbix [14928]ERROR: constraint "c_alerts_1" for relation "alerts" already exists 2023-01-04 09:31:01.203 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY alerts ADD CONSTRAINT c_alerts_1 FOREIGN KEY (actionid) REFERENCES actions (actionid) ON DELETE CASCADE; 2023-01-04 09:31:01.203 CET zabbix zabbix [14928]ERROR: constraint "c_alerts_2" for relation "alerts" already exists 2023-01-04 09:31:01.203 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY alerts ADD CONSTRAINT c_alerts_2 FOREIGN KEY (eventid) REFERENCES events (eventid) ON DELETE CASCADE; 2023-01-04 09:31:01.203 CET zabbix zabbix [14928]ERROR: constraint "c_alerts_3" for relation "alerts" already exists 2023-01-04 09:31:01.203 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY alerts ADD CONSTRAINT c_alerts_3 FOREIGN KEY (userid) REFERENCES users (userid) ON DELETE CASCADE; 2023-01-04 09:31:01.203 CET zabbix zabbix [14928]ERROR: constraint "c_alerts_4" for relation "alerts" already exists 2023-01-04 09:31:01.203 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY alerts ADD CONSTRAINT c_alerts_4 FOREIGN KEY (mediatypeid) REFERENCES media_type (mediatypeid) ON DELETE CASCADE; 2023-01-04 09:31:01.204 CET zabbix zabbix [14928]ERROR: constraint "c_alerts_5" for relation "alerts" already exists 2023-01-04 09:31:01.204 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY alerts ADD CONSTRAINT c_alerts_5 FOREIGN KEY (p_eventid) REFERENCES events (eventid) ON DELETE CASCADE; 2023-01-04 09:31:01.204 CET zabbix zabbix [14928]ERROR: constraint "c_alerts_6" for relation "alerts" already exists 2023-01-04 09:31:01.204 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY alerts ADD CONSTRAINT c_alerts_6 FOREIGN KEY (acknowledgeid) REFERENCES acknowledges (acknowledgeid) ON DELETE CASCADE; 2023-01-04 09:31:01.204 CET zabbix zabbix [14928]ERROR: constraint "c_acknowledges_1" for relation "acknowledges" already exists 2023-01-04 09:31:01.204 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY acknowledges ADD CONSTRAINT c_acknowledges_1 FOREIGN KEY (userid) REFERENCES users (userid) ON DELETE CASCADE; 2023-01-04 09:31:01.204 CET zabbix zabbix [14928]ERROR: constraint "c_acknowledges_2" for relation "acknowledges" already exists 2023-01-04 09:31:01.204 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY acknowledges ADD CONSTRAINT c_acknowledges_2 FOREIGN KEY (eventid) REFERENCES events (eventid) ON DELETE CASCADE; 2023-01-04 09:31:01.204 CET zabbix zabbix [14928]ERROR: constraint "c_service_alarms_1" for relation "service_alarms" already exists 2023-01-04 09:31:01.204 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY service_alarms ADD CONSTRAINT c_service_alarms_1 FOREIGN KEY (serviceid) REFERENCES services (serviceid) ON DELETE CASCADE; 2023-01-04 09:31:01.204 CET zabbix zabbix [14928]ERROR: constraint "c_autoreg_host_1" for relation "autoreg_host" already exists 2023-01-04 09:31:01.204 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY autoreg_host ADD CONSTRAINT c_autoreg_host_1 FOREIGN KEY (proxy_hostid) REFERENCES hosts (hostid) ON DELETE CASCADE; 2023-01-04 09:31:01.204 CET zabbix zabbix [14928]ERROR: constraint "c_dhosts_1" for relation "dhosts" already exists 2023-01-04 09:31:01.204 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY dhosts ADD CONSTRAINT c_dhosts_1 FOREIGN KEY (druleid) REFERENCES drules (druleid) ON DELETE CASCADE; 2023-01-04 09:31:01.204 CET zabbix zabbix [14928]ERROR: constraint "c_dservices_1" for relation "dservices" already exists 2023-01-04 09:31:01.204 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY dservices ADD CONSTRAINT c_dservices_1 FOREIGN KEY (dhostid) REFERENCES dhosts (dhostid) ON DELETE CASCADE; 2023-01-04 09:31:01.205 CET zabbix zabbix [14928]ERROR: constraint "c_dservices_2" for relation "dservices" already exists 2023-01-04 09:31:01.205 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY dservices ADD CONSTRAINT c_dservices_2 FOREIGN KEY (dcheckid) REFERENCES dchecks (dcheckid) ON DELETE CASCADE; 2023-01-04 09:31:01.205 CET zabbix zabbix [14928]ERROR: constraint "c_graph_discovery_1" for relation "graph_discovery" already exists 2023-01-04 09:31:01.205 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY graph_discovery ADD CONSTRAINT c_graph_discovery_1 FOREIGN KEY (graphid) REFERENCES graphs (graphid) ON DELETE CASCADE; 2023-01-04 09:31:01.205 CET zabbix zabbix [14928]ERROR: constraint "c_graph_discovery_2" for relation "graph_discovery" already exists 2023-01-04 09:31:01.205 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY graph_discovery ADD CONSTRAINT c_graph_discovery_2 FOREIGN KEY (parent_graphid) REFERENCES graphs (graphid); 2023-01-04 09:31:01.205 CET zabbix zabbix [14928]ERROR: constraint "c_host_inventory_1" for relation "host_inventory" already exists 2023-01-04 09:31:01.205 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY host_inventory ADD CONSTRAINT c_host_inventory_1 FOREIGN KEY (hostid) REFERENCES hosts (hostid) ON DELETE CASCADE; 2023-01-04 09:31:01.205 CET zabbix zabbix [14928]ERROR: constraint "c_item_discovery_1" for relation "item_discovery" already exists 2023-01-04 09:31:01.205 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY item_discovery ADD CONSTRAINT c_item_discovery_1 FOREIGN KEY (itemid) REFERENCES items (itemid) ON DELETE CASCADE; 2023-01-04 09:31:01.205 CET zabbix zabbix [14928]ERROR: constraint "c_item_discovery_2" for relation "item_discovery" already exists 2023-01-04 09:31:01.205 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY item_discovery ADD CONSTRAINT c_item_discovery_2 FOREIGN KEY (parent_itemid) REFERENCES items (itemid) ON DELETE CASCADE; 2023-01-04 09:31:01.206 CET zabbix zabbix [14928]ERROR: constraint "c_host_discovery_1" for relation "host_discovery" already exists 2023-01-04 09:31:01.206 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY host_discovery ADD CONSTRAINT c_host_discovery_1 FOREIGN KEY (hostid) REFERENCES hosts (hostid) ON DELETE CASCADE; 2023-01-04 09:31:01.206 CET zabbix zabbix [14928]ERROR: constraint "c_host_discovery_2" for relation "host_discovery" already exists 2023-01-04 09:31:01.206 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY host_discovery ADD CONSTRAINT c_host_discovery_2 FOREIGN KEY (parent_hostid) REFERENCES hosts (hostid); 2023-01-04 09:31:01.206 CET zabbix zabbix [14928]ERROR: constraint "c_host_discovery_3" for relation "host_discovery" already exists 2023-01-04 09:31:01.206 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY host_discovery ADD CONSTRAINT c_host_discovery_3 FOREIGN KEY (parent_itemid) REFERENCES items (itemid); 2023-01-04 09:31:01.206 CET zabbix zabbix [14928]ERROR: constraint "c_interface_discovery_1" for relation "interface_discovery" already exists 2023-01-04 09:31:01.206 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY interface_discovery ADD CONSTRAINT c_interface_discovery_1 FOREIGN KEY (interfaceid) REFERENCES interface (interfaceid) ON DELETE CASCADE; 2023-01-04 09:31:01.206 CET zabbix zabbix [14928]ERROR: constraint "c_interface_discovery_2" for relation "interface_discovery" already exists 2023-01-04 09:31:01.206 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY interface_discovery ADD CONSTRAINT c_interface_discovery_2 FOREIGN KEY (parent_interfaceid) REFERENCES interface (interfaceid) ON DELETE CASCADE; 2023-01-04 09:31:01.206 CET zabbix zabbix [14928]ERROR: constraint "c_profiles_1" for relation "profiles" already exists 2023-01-04 09:31:01.206 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY profiles ADD CONSTRAINT c_profiles_1 FOREIGN KEY (userid) REFERENCES users (userid) ON DELETE CASCADE; 2023-01-04 09:31:01.206 CET zabbix zabbix [14928]ERROR: constraint "c_sessions_1" for relation "sessions" already exists 2023-01-04 09:31:01.206 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY sessions ADD CONSTRAINT c_sessions_1 FOREIGN KEY (userid) REFERENCES users (userid) ON DELETE CASCADE; 2023-01-04 09:31:01.207 CET zabbix zabbix [14928]ERROR: constraint "c_trigger_discovery_1" for relation "trigger_discovery" already exists 2023-01-04 09:31:01.207 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY trigger_discovery ADD CONSTRAINT c_trigger_discovery_1 FOREIGN KEY (triggerid) REFERENCES triggers (triggerid) ON DELETE CASCADE; 2023-01-04 09:31:01.207 CET zabbix zabbix [14928]ERROR: constraint "c_trigger_discovery_2" for relation "trigger_discovery" already exists 2023-01-04 09:31:01.207 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY trigger_discovery ADD CONSTRAINT c_trigger_discovery_2 FOREIGN KEY (parent_triggerid) REFERENCES triggers (triggerid); 2023-01-04 09:31:01.207 CET zabbix zabbix [14928]ERROR: constraint "c_item_condition_1" for relation "item_condition" already exists 2023-01-04 09:31:01.207 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY item_condition ADD CONSTRAINT c_item_condition_1 FOREIGN KEY (itemid) REFERENCES items (itemid) ON DELETE CASCADE; 2023-01-04 09:31:01.207 CET zabbix zabbix [14928]ERROR: constraint "c_item_rtdata_1" for relation "item_rtdata" already exists 2023-01-04 09:31:01.207 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY item_rtdata ADD CONSTRAINT c_item_rtdata_1 FOREIGN KEY (itemid) REFERENCES items (itemid) ON DELETE CASCADE; 2023-01-04 09:31:01.207 CET zabbix zabbix [14928]ERROR: constraint "c_opinventory_1" for relation "opinventory" already exists 2023-01-04 09:31:01.207 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY opinventory ADD CONSTRAINT c_opinventory_1 FOREIGN KEY (operationid) REFERENCES operations (operationid) ON DELETE CASCADE; 2023-01-04 09:31:01.207 CET zabbix zabbix [14928]ERROR: constraint "c_trigger_tag_1" for relation "trigger_tag" already exists 2023-01-04 09:31:01.207 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY trigger_tag ADD CONSTRAINT c_trigger_tag_1 FOREIGN KEY (triggerid) REFERENCES triggers (triggerid); 2023-01-04 09:31:01.208 CET zabbix zabbix [14928]ERROR: constraint "c_event_tag_1" for relation "event_tag" already exists 2023-01-04 09:31:01.208 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY event_tag ADD CONSTRAINT c_event_tag_1 FOREIGN KEY (eventid) REFERENCES events (eventid) ON DELETE CASCADE; 2023-01-04 09:31:01.208 CET zabbix zabbix [14928]ERROR: constraint "c_problem_1" for relation "problem" already exists 2023-01-04 09:31:01.208 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY problem ADD CONSTRAINT c_problem_1 FOREIGN KEY (eventid) REFERENCES events (eventid) ON DELETE CASCADE; 2023-01-04 09:31:01.208 CET zabbix zabbix [14928]ERROR: constraint "c_problem_2" for relation "problem" already exists 2023-01-04 09:31:01.208 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY problem ADD CONSTRAINT c_problem_2 FOREIGN KEY (r_eventid) REFERENCES events (eventid) ON DELETE CASCADE; 2023-01-04 09:31:01.208 CET zabbix zabbix [14928]ERROR: constraint "c_problem_tag_1" for relation "problem_tag" already exists 2023-01-04 09:31:01.208 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY problem_tag ADD CONSTRAINT c_problem_tag_1 FOREIGN KEY (eventid) REFERENCES problem (eventid) ON DELETE CASCADE; 2023-01-04 09:31:01.208 CET zabbix zabbix [14928]ERROR: constraint "c_tag_filter_1" for relation "tag_filter" already exists 2023-01-04 09:31:01.208 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY tag_filter ADD CONSTRAINT c_tag_filter_1 FOREIGN KEY (usrgrpid) REFERENCES usrgrp (usrgrpid) ON DELETE CASCADE; 2023-01-04 09:31:01.208 CET zabbix zabbix [14928]ERROR: constraint "c_tag_filter_2" for relation "tag_filter" already exists 2023-01-04 09:31:01.208 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY tag_filter ADD CONSTRAINT c_tag_filter_2 FOREIGN KEY (groupid) REFERENCES hstgrp (groupid) ON DELETE CASCADE; 2023-01-04 09:31:01.209 CET zabbix zabbix [14928]ERROR: constraint "c_event_recovery_1" for relation "event_recovery" already exists 2023-01-04 09:31:01.209 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY event_recovery ADD CONSTRAINT c_event_recovery_1 FOREIGN KEY (eventid) REFERENCES events (eventid) ON DELETE CASCADE; 2023-01-04 09:31:01.209 CET zabbix zabbix [14928]ERROR: constraint "c_event_recovery_2" for relation "event_recovery" already exists 2023-01-04 09:31:01.209 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY event_recovery ADD CONSTRAINT c_event_recovery_2 FOREIGN KEY (r_eventid) REFERENCES events (eventid) ON DELETE CASCADE; 2023-01-04 09:31:01.209 CET zabbix zabbix [14928]ERROR: constraint "c_event_recovery_3" for relation "event_recovery" already exists 2023-01-04 09:31:01.209 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY event_recovery ADD CONSTRAINT c_event_recovery_3 FOREIGN KEY (c_eventid) REFERENCES events (eventid) ON DELETE CASCADE; 2023-01-04 09:31:01.209 CET zabbix zabbix [14928]ERROR: constraint "c_corr_condition_1" for relation "corr_condition" already exists 2023-01-04 09:31:01.209 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY corr_condition ADD CONSTRAINT c_corr_condition_1 FOREIGN KEY (correlationid) REFERENCES correlation (correlationid) ON DELETE CASCADE; 2023-01-04 09:31:01.209 CET zabbix zabbix [14928]ERROR: constraint "c_corr_condition_tag_1" for relation "corr_condition_tag" already exists 2023-01-04 09:31:01.209 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY corr_condition_tag ADD CONSTRAINT c_corr_condition_tag_1 FOREIGN KEY (corr_conditionid) REFERENCES corr_condition (corr_conditionid) ON DELETE CASCADE; 2023-01-04 09:31:01.209 CET zabbix zabbix [14928]ERROR: constraint "c_corr_condition_group_1" for relation "corr_condition_group" already exists 2023-01-04 09:31:01.209 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY corr_condition_group ADD CONSTRAINT c_corr_condition_group_1 FOREIGN KEY (corr_conditionid) REFERENCES corr_condition (corr_conditionid) ON DELETE CASCADE; 2023-01-04 09:31:01.209 CET zabbix zabbix [14928]ERROR: constraint "c_corr_condition_group_2" for relation "corr_condition_group" already exists 2023-01-04 09:31:01.209 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY corr_condition_group ADD CONSTRAINT c_corr_condition_group_2 FOREIGN KEY (groupid) REFERENCES hstgrp (groupid); 2023-01-04 09:31:01.209 CET zabbix zabbix [14928]ERROR: constraint "c_corr_condition_tagpair_1" for relation "corr_condition_tagpair" already exists 2023-01-04 09:31:01.209 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY corr_condition_tagpair ADD CONSTRAINT c_corr_condition_tagpair_1 FOREIGN KEY (corr_conditionid) REFERENCES corr_condition (corr_conditionid) ON DELETE CASCADE; 2023-01-04 09:31:01.210 CET zabbix zabbix [14928]ERROR: constraint "c_corr_condition_tagvalue_1" for relation "corr_condition_tagvalue" already exists 2023-01-04 09:31:01.210 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY corr_condition_tagvalue ADD CONSTRAINT c_corr_condition_tagvalue_1 FOREIGN KEY (corr_conditionid) REFERENCES corr_condition (corr_conditionid) ON DELETE CASCADE; 2023-01-04 09:31:01.210 CET zabbix zabbix [14928]ERROR: constraint "c_corr_operation_1" for relation "corr_operation" already exists 2023-01-04 09:31:01.210 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY corr_operation ADD CONSTRAINT c_corr_operation_1 FOREIGN KEY (correlationid) REFERENCES correlation (correlationid) ON DELETE CASCADE; 2023-01-04 09:31:01.210 CET zabbix zabbix [14928]ERROR: constraint "c_task_1" for relation "task" already exists 2023-01-04 09:31:01.210 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY task ADD CONSTRAINT c_task_1 FOREIGN KEY (proxy_hostid) REFERENCES hosts (hostid) ON DELETE CASCADE; 2023-01-04 09:31:01.210 CET zabbix zabbix [14928]ERROR: constraint "c_task_close_problem_1" for relation "task_close_problem" already exists 2023-01-04 09:31:01.210 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY task_close_problem ADD CONSTRAINT c_task_close_problem_1 FOREIGN KEY (taskid) REFERENCES task (taskid) ON DELETE CASCADE; 2023-01-04 09:31:01.210 CET zabbix zabbix [14928]ERROR: constraint "c_item_preproc_1" for relation "item_preproc" already exists 2023-01-04 09:31:01.210 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY item_preproc ADD CONSTRAINT c_item_preproc_1 FOREIGN KEY (itemid) REFERENCES items (itemid); 2023-01-04 09:31:01.210 CET zabbix zabbix [14928]ERROR: constraint "c_task_remote_command_1" for relation "task_remote_command" already exists 2023-01-04 09:31:01.210 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY task_remote_command ADD CONSTRAINT c_task_remote_command_1 FOREIGN KEY (taskid) REFERENCES task (taskid) ON DELETE CASCADE; 2023-01-04 09:31:01.211 CET zabbix zabbix [14928]ERROR: constraint "c_task_remote_command_result_1" for relation "task_remote_command_result" already exists 2023-01-04 09:31:01.211 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY task_remote_command_result ADD CONSTRAINT c_task_remote_command_result_1 FOREIGN KEY (taskid) REFERENCES task (taskid) ON DELETE CASCADE; 2023-01-04 09:31:01.211 CET zabbix zabbix [14928]ERROR: constraint "c_task_data_1" for relation "task_data" already exists 2023-01-04 09:31:01.211 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY task_data ADD CONSTRAINT c_task_data_1 FOREIGN KEY (taskid) REFERENCES task (taskid) ON DELETE CASCADE; 2023-01-04 09:31:01.211 CET zabbix zabbix [14928]ERROR: constraint "c_task_result_1" for relation "task_result" already exists 2023-01-04 09:31:01.211 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY task_result ADD CONSTRAINT c_task_result_1 FOREIGN KEY (taskid) REFERENCES task (taskid) ON DELETE CASCADE; 2023-01-04 09:31:01.211 CET zabbix zabbix [14928]ERROR: constraint "c_task_acknowledge_1" for relation "task_acknowledge" already exists 2023-01-04 09:31:01.211 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY task_acknowledge ADD CONSTRAINT c_task_acknowledge_1 FOREIGN KEY (taskid) REFERENCES task (taskid) ON DELETE CASCADE; 2023-01-04 09:31:01.211 CET zabbix zabbix [14928]ERROR: constraint "c_sysmap_shape_1" for relation "sysmap_shape" already exists 2023-01-04 09:31:01.211 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY sysmap_shape ADD CONSTRAINT c_sysmap_shape_1 FOREIGN KEY (sysmapid) REFERENCES sysmaps (sysmapid) ON DELETE CASCADE; 2023-01-04 09:31:01.211 CET zabbix zabbix [14928]ERROR: constraint "c_sysmap_element_trigger_1" for relation "sysmap_element_trigger" already exists 2023-01-04 09:31:01.211 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY sysmap_element_trigger ADD CONSTRAINT c_sysmap_element_trigger_1 FOREIGN KEY (selementid) REFERENCES sysmaps_elements (selementid) ON DELETE CASCADE; 2023-01-04 09:31:01.211 CET zabbix zabbix [14928]ERROR: constraint "c_sysmap_element_trigger_2" for relation "sysmap_element_trigger" already exists 2023-01-04 09:31:01.211 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY sysmap_element_trigger ADD CONSTRAINT c_sysmap_element_trigger_2 FOREIGN KEY (triggerid) REFERENCES triggers (triggerid) ON DELETE CASCADE; 2023-01-04 09:31:01.211 CET zabbix zabbix [14928]ERROR: constraint "c_httptest_field_1" for relation "httptest_field" already exists 2023-01-04 09:31:01.211 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY httptest_field ADD CONSTRAINT c_httptest_field_1 FOREIGN KEY (httptestid) REFERENCES httptest (httptestid) ON DELETE CASCADE; 2023-01-04 09:31:01.212 CET zabbix zabbix [14928]ERROR: constraint "c_httpstep_field_1" for relation "httpstep_field" already exists 2023-01-04 09:31:01.212 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY httpstep_field ADD CONSTRAINT c_httpstep_field_1 FOREIGN KEY (httpstepid) REFERENCES httpstep (httpstepid) ON DELETE CASCADE; 2023-01-04 09:31:01.212 CET zabbix zabbix [14928]ERROR: constraint "c_dashboard_1" for relation "dashboard" already exists 2023-01-04 09:31:01.212 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY dashboard ADD CONSTRAINT c_dashboard_1 FOREIGN KEY (userid) REFERENCES users (userid); 2023-01-04 09:31:01.212 CET zabbix zabbix [14928]ERROR: constraint "c_dashboard_2" for relation "dashboard" already exists 2023-01-04 09:31:01.212 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY dashboard ADD CONSTRAINT c_dashboard_2 FOREIGN KEY (templateid) REFERENCES hosts (hostid) ON DELETE CASCADE; 2023-01-04 09:31:01.212 CET zabbix zabbix [14928]ERROR: constraint "c_dashboard_user_1" for relation "dashboard_user" already exists 2023-01-04 09:31:01.212 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY dashboard_user ADD CONSTRAINT c_dashboard_user_1 FOREIGN KEY (dashboardid) REFERENCES dashboard (dashboardid) ON DELETE CASCADE; 2023-01-04 09:31:01.212 CET zabbix zabbix [14928]ERROR: constraint "c_dashboard_user_2" for relation "dashboard_user" already exists 2023-01-04 09:31:01.212 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY dashboard_user ADD CONSTRAINT c_dashboard_user_2 FOREIGN KEY (userid) REFERENCES users (userid) ON DELETE CASCADE; 2023-01-04 09:31:01.212 CET zabbix zabbix [14928]ERROR: constraint "c_dashboard_usrgrp_1" for relation "dashboard_usrgrp" already exists 2023-01-04 09:31:01.212 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY dashboard_usrgrp ADD CONSTRAINT c_dashboard_usrgrp_1 FOREIGN KEY (dashboardid) REFERENCES dashboard (dashboardid) ON DELETE CASCADE; 2023-01-04 09:31:01.212 CET zabbix zabbix [14928]ERROR: constraint "c_dashboard_usrgrp_2" for relation "dashboard_usrgrp" already exists 2023-01-04 09:31:01.212 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY dashboard_usrgrp ADD CONSTRAINT c_dashboard_usrgrp_2 FOREIGN KEY (usrgrpid) REFERENCES usrgrp (usrgrpid) ON DELETE CASCADE; 2023-01-04 09:31:01.212 CET zabbix zabbix [14928]ERROR: constraint "c_dashboard_page_1" for relation "dashboard_page" already exists 2023-01-04 09:31:01.212 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY dashboard_page ADD CONSTRAINT c_dashboard_page_1 FOREIGN KEY (dashboardid) REFERENCES dashboard (dashboardid) ON DELETE CASCADE; 2023-01-04 09:31:01.213 CET zabbix zabbix [14928]ERROR: constraint "c_widget_1" for relation "widget" already exists 2023-01-04 09:31:01.213 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY widget ADD CONSTRAINT c_widget_1 FOREIGN KEY (dashboard_pageid) REFERENCES dashboard_page (dashboard_pageid) ON DELETE CASCADE; 2023-01-04 09:31:01.213 CET zabbix zabbix [14928]ERROR: constraint "c_widget_field_1" for relation "widget_field" already exists 2023-01-04 09:31:01.213 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY widget_field ADD CONSTRAINT c_widget_field_1 FOREIGN KEY (widgetid) REFERENCES widget (widgetid) ON DELETE CASCADE; 2023-01-04 09:31:01.213 CET zabbix zabbix [14928]ERROR: constraint "c_widget_field_2" for relation "widget_field" already exists 2023-01-04 09:31:01.213 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY widget_field ADD CONSTRAINT c_widget_field_2 FOREIGN KEY (value_groupid) REFERENCES hstgrp (groupid) ON DELETE CASCADE; 2023-01-04 09:31:01.213 CET zabbix zabbix [14928]ERROR: constraint "c_widget_field_3" for relation "widget_field" already exists 2023-01-04 09:31:01.213 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY widget_field ADD CONSTRAINT c_widget_field_3 FOREIGN KEY (value_hostid) REFERENCES hosts (hostid) ON DELETE CASCADE; 2023-01-04 09:31:01.213 CET zabbix zabbix [14928]ERROR: constraint "c_widget_field_4" for relation "widget_field" already exists 2023-01-04 09:31:01.213 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY widget_field ADD CONSTRAINT c_widget_field_4 FOREIGN KEY (value_itemid) REFERENCES items (itemid) ON DELETE CASCADE; 2023-01-04 09:31:01.213 CET zabbix zabbix [14928]ERROR: constraint "c_widget_field_5" for relation "widget_field" already exists 2023-01-04 09:31:01.213 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY widget_field ADD CONSTRAINT c_widget_field_5 FOREIGN KEY (value_graphid) REFERENCES graphs (graphid) ON DELETE CASCADE; 2023-01-04 09:31:01.213 CET zabbix zabbix [14928]ERROR: constraint "c_widget_field_6" for relation "widget_field" already exists 2023-01-04 09:31:01.213 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY widget_field ADD CONSTRAINT c_widget_field_6 FOREIGN KEY (value_sysmapid) REFERENCES sysmaps (sysmapid) ON DELETE CASCADE; 2023-01-04 09:31:01.213 CET zabbix zabbix [14928]ERROR: constraint "c_widget_field_7" for relation "widget_field" already exists 2023-01-04 09:31:01.213 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY widget_field ADD CONSTRAINT c_widget_field_7 FOREIGN KEY (value_serviceid) REFERENCES services (serviceid) ON DELETE CASCADE; 2023-01-04 09:31:01.214 CET zabbix zabbix [14928]ERROR: constraint "c_widget_field_8" for relation "widget_field" already exists 2023-01-04 09:31:01.214 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY widget_field ADD CONSTRAINT c_widget_field_8 FOREIGN KEY (value_slaid) REFERENCES sla (slaid) ON DELETE CASCADE; 2023-01-04 09:31:01.214 CET zabbix zabbix [14928]ERROR: constraint "c_task_check_now_1" for relation "task_check_now" already exists 2023-01-04 09:31:01.214 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY task_check_now ADD CONSTRAINT c_task_check_now_1 FOREIGN KEY (taskid) REFERENCES task (taskid) ON DELETE CASCADE; 2023-01-04 09:31:01.214 CET zabbix zabbix [14928]ERROR: constraint "c_event_suppress_1" for relation "event_suppress" already exists 2023-01-04 09:31:01.214 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY event_suppress ADD CONSTRAINT c_event_suppress_1 FOREIGN KEY (eventid) REFERENCES events (eventid) ON DELETE CASCADE; 2023-01-04 09:31:01.214 CET zabbix zabbix [14928]ERROR: constraint "c_event_suppress_2" for relation "event_suppress" already exists 2023-01-04 09:31:01.214 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY event_suppress ADD CONSTRAINT c_event_suppress_2 FOREIGN KEY (maintenanceid) REFERENCES maintenances (maintenanceid) ON DELETE CASCADE; 2023-01-04 09:31:01.214 CET zabbix zabbix [14928]ERROR: constraint "c_event_suppress_3" for relation "event_suppress" already exists 2023-01-04 09:31:01.214 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY event_suppress ADD CONSTRAINT c_event_suppress_3 FOREIGN KEY (userid) REFERENCES users (userid) ON DELETE CASCADE; 2023-01-04 09:31:01.214 CET zabbix zabbix [14928]ERROR: constraint "c_maintenance_tag_1" for relation "maintenance_tag" already exists 2023-01-04 09:31:01.214 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY maintenance_tag ADD CONSTRAINT c_maintenance_tag_1 FOREIGN KEY (maintenanceid) REFERENCES maintenances (maintenanceid) ON DELETE CASCADE; 2023-01-04 09:31:01.214 CET zabbix zabbix [14928]ERROR: constraint "c_lld_macro_path_1" for relation "lld_macro_path" already exists 2023-01-04 09:31:01.214 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY lld_macro_path ADD CONSTRAINT c_lld_macro_path_1 FOREIGN KEY (itemid) REFERENCES items (itemid) ON DELETE CASCADE; 2023-01-04 09:31:01.214 CET zabbix zabbix [14928]ERROR: constraint "c_host_tag_1" for relation "host_tag" already exists 2023-01-04 09:31:01.214 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY host_tag ADD CONSTRAINT c_host_tag_1 FOREIGN KEY (hostid) REFERENCES hosts (hostid); 2023-01-04 09:31:01.214 CET zabbix zabbix [14928]ERROR: constraint "c_interface_snmp_1" for relation "interface_snmp" already exists 2023-01-04 09:31:01.214 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY interface_snmp ADD CONSTRAINT c_interface_snmp_1 FOREIGN KEY (interfaceid) REFERENCES interface (interfaceid) ON DELETE CASCADE; 2023-01-04 09:31:01.214 CET zabbix zabbix [14928]ERROR: constraint "c_lld_override_1" for relation "lld_override" already exists 2023-01-04 09:31:01.214 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY lld_override ADD CONSTRAINT c_lld_override_1 FOREIGN KEY (itemid) REFERENCES items (itemid) ON DELETE CASCADE; 2023-01-04 09:31:01.215 CET zabbix zabbix [14928]ERROR: constraint "c_lld_override_condition_1" for relation "lld_override_condition" already exists 2023-01-04 09:31:01.215 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY lld_override_condition ADD CONSTRAINT c_lld_override_condition_1 FOREIGN KEY (lld_overrideid) REFERENCES lld_override (lld_overrideid) ON DELETE CASCADE; 2023-01-04 09:31:01.215 CET zabbix zabbix [14928]ERROR: constraint "c_lld_override_operation_1" for relation "lld_override_operation" already exists 2023-01-04 09:31:01.215 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY lld_override_operation ADD CONSTRAINT c_lld_override_operation_1 FOREIGN KEY (lld_overrideid) REFERENCES lld_override (lld_overrideid) ON DELETE CASCADE; 2023-01-04 09:31:01.215 CET zabbix zabbix [14928]ERROR: constraint "c_lld_override_opstatus_1" for relation "lld_override_opstatus" already exists 2023-01-04 09:31:01.215 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY lld_override_opstatus ADD CONSTRAINT c_lld_override_opstatus_1 FOREIGN KEY (lld_override_operationid) REFERENCES lld_override_operation (lld_override_operationid) ON DELETE CASCADE; 2023-01-04 09:31:01.215 CET zabbix zabbix [14928]ERROR: constraint "c_lld_override_opdiscover_1" for relation "lld_override_opdiscover" already exists 2023-01-04 09:31:01.215 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY lld_override_opdiscover ADD CONSTRAINT c_lld_override_opdiscover_1 FOREIGN KEY (lld_override_operationid) REFERENCES lld_override_operation (lld_override_operationid) ON DELETE CASCADE; 2023-01-04 09:31:01.215 CET zabbix zabbix [14928]ERROR: constraint "c_lld_override_opperiod_1" for relation "lld_override_opperiod" already exists 2023-01-04 09:31:01.215 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY lld_override_opperiod ADD CONSTRAINT c_lld_override_opperiod_1 FOREIGN KEY (lld_override_operationid) REFERENCES lld_override_operation (lld_override_operationid) ON DELETE CASCADE; 2023-01-04 09:31:01.215 CET zabbix zabbix [14928]ERROR: constraint "c_lld_override_ophistory_1" for relation "lld_override_ophistory" already exists 2023-01-04 09:31:01.215 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY lld_override_ophistory ADD CONSTRAINT c_lld_override_ophistory_1 FOREIGN KEY (lld_override_operationid) REFERENCES lld_override_operation (lld_override_operationid) ON DELETE CASCADE; 2023-01-04 09:31:01.215 CET zabbix zabbix [14928]ERROR: constraint "c_lld_override_optrends_1" for relation "lld_override_optrends" already exists 2023-01-04 09:31:01.215 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY lld_override_optrends ADD CONSTRAINT c_lld_override_optrends_1 FOREIGN KEY (lld_override_operationid) REFERENCES lld_override_operation (lld_override_operationid) ON DELETE CASCADE; 2023-01-04 09:31:01.215 CET zabbix zabbix [14928]ERROR: constraint "c_lld_override_opseverity_1" for relation "lld_override_opseverity" already exists 2023-01-04 09:31:01.215 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY lld_override_opseverity ADD CONSTRAINT c_lld_override_opseverity_1 FOREIGN KEY (lld_override_operationid) REFERENCES lld_override_operation (lld_override_operationid) ON DELETE CASCADE; 2023-01-04 09:31:01.215 CET zabbix zabbix [14928]ERROR: constraint "c_lld_override_optag_1" for relation "lld_override_optag" already exists 2023-01-04 09:31:01.215 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY lld_override_optag ADD CONSTRAINT c_lld_override_optag_1 FOREIGN KEY (lld_override_operationid) REFERENCES lld_override_operation (lld_override_operationid) ON DELETE CASCADE; 2023-01-04 09:31:01.216 CET zabbix zabbix [14928]ERROR: constraint "c_lld_override_optemplate_1" for relation "lld_override_optemplate" already exists 2023-01-04 09:31:01.216 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY lld_override_optemplate ADD CONSTRAINT c_lld_override_optemplate_1 FOREIGN KEY (lld_override_operationid) REFERENCES lld_override_operation (lld_override_operationid) ON DELETE CASCADE; 2023-01-04 09:31:01.216 CET zabbix zabbix [14928]ERROR: constraint "c_lld_override_optemplate_2" for relation "lld_override_optemplate" already exists 2023-01-04 09:31:01.216 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY lld_override_optemplate ADD CONSTRAINT c_lld_override_optemplate_2 FOREIGN KEY (templateid) REFERENCES hosts (hostid); 2023-01-04 09:31:01.216 CET zabbix zabbix [14928]ERROR: constraint "c_lld_override_opinventory_1" for relation "lld_override_opinventory" already exists 2023-01-04 09:31:01.216 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY lld_override_opinventory ADD CONSTRAINT c_lld_override_opinventory_1 FOREIGN KEY (lld_override_operationid) REFERENCES lld_override_operation (lld_override_operationid) ON DELETE CASCADE; 2023-01-04 09:31:01.216 CET zabbix zabbix [14928]ERROR: constraint "c_item_parameter_1" for relation "item_parameter" already exists 2023-01-04 09:31:01.216 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY item_parameter ADD CONSTRAINT c_item_parameter_1 FOREIGN KEY (itemid) REFERENCES items (itemid) ON DELETE CASCADE; 2023-01-04 09:31:01.216 CET zabbix zabbix [14928]ERROR: constraint "c_role_rule_1" for relation "role_rule" already exists 2023-01-04 09:31:01.216 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY role_rule ADD CONSTRAINT c_role_rule_1 FOREIGN KEY (roleid) REFERENCES role (roleid) ON DELETE CASCADE; 2023-01-04 09:31:01.216 CET zabbix zabbix [14928]ERROR: constraint "c_role_rule_2" for relation "role_rule" already exists 2023-01-04 09:31:01.216 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY role_rule ADD CONSTRAINT c_role_rule_2 FOREIGN KEY (value_moduleid) REFERENCES module (moduleid) ON DELETE CASCADE; 2023-01-04 09:31:01.216 CET zabbix zabbix [14928]ERROR: constraint "c_role_rule_3" for relation "role_rule" already exists 2023-01-04 09:31:01.216 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY role_rule ADD CONSTRAINT c_role_rule_3 FOREIGN KEY (value_serviceid) REFERENCES services (serviceid) ON DELETE CASCADE; 2023-01-04 09:31:01.216 CET zabbix zabbix [14928]ERROR: constraint "c_token_1" for relation "token" already exists 2023-01-04 09:31:01.216 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY token ADD CONSTRAINT c_token_1 FOREIGN KEY (userid) REFERENCES users (userid) ON DELETE CASCADE; 2023-01-04 09:31:01.216 CET zabbix zabbix [14928]ERROR: constraint "c_token_2" for relation "token" already exists 2023-01-04 09:31:01.216 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY token ADD CONSTRAINT c_token_2 FOREIGN KEY (creator_userid) REFERENCES users (userid); 2023-01-04 09:31:01.216 CET zabbix zabbix [14928]ERROR: constraint "c_item_tag_1" for relation "item_tag" already exists 2023-01-04 09:31:01.216 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY item_tag ADD CONSTRAINT c_item_tag_1 FOREIGN KEY (itemid) REFERENCES items (itemid); 2023-01-04 09:31:01.217 CET zabbix zabbix [14928]ERROR: constraint "c_httptest_tag_1" for relation "httptest_tag" already exists 2023-01-04 09:31:01.217 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY httptest_tag ADD CONSTRAINT c_httptest_tag_1 FOREIGN KEY (httptestid) REFERENCES httptest (httptestid) ON DELETE CASCADE; 2023-01-04 09:31:01.217 CET zabbix zabbix [14928]ERROR: constraint "c_sysmaps_element_tag_1" for relation "sysmaps_element_tag" already exists 2023-01-04 09:31:01.217 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY sysmaps_element_tag ADD CONSTRAINT c_sysmaps_element_tag_1 FOREIGN KEY (selementid) REFERENCES sysmaps_elements (selementid) ON DELETE CASCADE; 2023-01-04 09:31:01.217 CET zabbix zabbix [14928]ERROR: constraint "c_report_1" for relation "report" already exists 2023-01-04 09:31:01.217 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY report ADD CONSTRAINT c_report_1 FOREIGN KEY (userid) REFERENCES users (userid) ON DELETE CASCADE; 2023-01-04 09:31:01.217 CET zabbix zabbix [14928]ERROR: constraint "c_report_2" for relation "report" already exists 2023-01-04 09:31:01.217 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY report ADD CONSTRAINT c_report_2 FOREIGN KEY (dashboardid) REFERENCES dashboard (dashboardid) ON DELETE CASCADE; 2023-01-04 09:31:01.217 CET zabbix zabbix [14928]ERROR: constraint "c_report_param_1" for relation "report_param" already exists 2023-01-04 09:31:01.217 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY report_param ADD CONSTRAINT c_report_param_1 FOREIGN KEY (reportid) REFERENCES report (reportid) ON DELETE CASCADE; 2023-01-04 09:31:01.217 CET zabbix zabbix [14928]ERROR: constraint "c_report_user_1" for relation "report_user" already exists 2023-01-04 09:31:01.217 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY report_user ADD CONSTRAINT c_report_user_1 FOREIGN KEY (reportid) REFERENCES report (reportid) ON DELETE CASCADE; 2023-01-04 09:31:01.217 CET zabbix zabbix [14928]ERROR: constraint "c_report_user_2" for relation "report_user" already exists 2023-01-04 09:31:01.217 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY report_user ADD CONSTRAINT c_report_user_2 FOREIGN KEY (userid) REFERENCES users (userid) ON DELETE CASCADE; 2023-01-04 09:31:01.217 CET zabbix zabbix [14928]ERROR: constraint "c_report_user_3" for relation "report_user" already exists 2023-01-04 09:31:01.217 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY report_user ADD CONSTRAINT c_report_user_3 FOREIGN KEY (access_userid) REFERENCES users (userid); 2023-01-04 09:31:01.217 CET zabbix zabbix [14928]ERROR: constraint "c_report_usrgrp_1" for relation "report_usrgrp" already exists 2023-01-04 09:31:01.217 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY report_usrgrp ADD CONSTRAINT c_report_usrgrp_1 FOREIGN KEY (reportid) REFERENCES report (reportid) ON DELETE CASCADE; 2023-01-04 09:31:01.217 CET zabbix zabbix [14928]ERROR: constraint "c_report_usrgrp_2" for relation "report_usrgrp" already exists 2023-01-04 09:31:01.217 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY report_usrgrp ADD CONSTRAINT c_report_usrgrp_2 FOREIGN KEY (usrgrpid) REFERENCES usrgrp (usrgrpid) ON DELETE CASCADE; 2023-01-04 09:31:01.218 CET zabbix zabbix [14928]ERROR: constraint "c_report_usrgrp_3" for relation "report_usrgrp" already exists 2023-01-04 09:31:01.218 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY report_usrgrp ADD CONSTRAINT c_report_usrgrp_3 FOREIGN KEY (access_userid) REFERENCES users (userid); 2023-01-04 09:31:01.218 CET zabbix zabbix [14928]ERROR: constraint "c_service_problem_tag_1" for relation "service_problem_tag" already exists 2023-01-04 09:31:01.218 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY service_problem_tag ADD CONSTRAINT c_service_problem_tag_1 FOREIGN KEY (serviceid) REFERENCES services (serviceid) ON DELETE CASCADE; 2023-01-04 09:31:01.218 CET zabbix zabbix [14928]ERROR: constraint "c_service_problem_1" for relation "service_problem" already exists 2023-01-04 09:31:01.218 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY service_problem ADD CONSTRAINT c_service_problem_1 FOREIGN KEY (eventid) REFERENCES problem (eventid) ON DELETE CASCADE; 2023-01-04 09:31:01.218 CET zabbix zabbix [14928]ERROR: constraint "c_service_problem_2" for relation "service_problem" already exists 2023-01-04 09:31:01.218 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY service_problem ADD CONSTRAINT c_service_problem_2 FOREIGN KEY (serviceid) REFERENCES services (serviceid) ON DELETE CASCADE; 2023-01-04 09:31:01.218 CET zabbix zabbix [14928]ERROR: constraint "c_service_tag_1" for relation "service_tag" already exists 2023-01-04 09:31:01.218 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY service_tag ADD CONSTRAINT c_service_tag_1 FOREIGN KEY (serviceid) REFERENCES services (serviceid) ON DELETE CASCADE; 2023-01-04 09:31:01.218 CET zabbix zabbix [14928]ERROR: constraint "c_service_status_rule_1" for relation "service_status_rule" already exists 2023-01-04 09:31:01.218 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY service_status_rule ADD CONSTRAINT c_service_status_rule_1 FOREIGN KEY (serviceid) REFERENCES services (serviceid) ON DELETE CASCADE; 2023-01-04 09:31:01.218 CET zabbix zabbix [14928]ERROR: constraint "c_sla_schedule_1" for relation "sla_schedule" already exists 2023-01-04 09:31:01.218 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY sla_schedule ADD CONSTRAINT c_sla_schedule_1 FOREIGN KEY (slaid) REFERENCES sla (slaid) ON DELETE CASCADE; 2023-01-04 09:31:01.218 CET zabbix zabbix [14928]ERROR: constraint "c_sla_excluded_downtime_1" for relation "sla_excluded_downtime" already exists 2023-01-04 09:31:01.218 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY sla_excluded_downtime ADD CONSTRAINT c_sla_excluded_downtime_1 FOREIGN KEY (slaid) REFERENCES sla (slaid) ON DELETE CASCADE; 2023-01-04 09:31:01.218 CET zabbix zabbix [14928]ERROR: constraint "c_sla_service_tag_1" for relation "sla_service_tag" already exists 2023-01-04 09:31:01.218 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY sla_service_tag ADD CONSTRAINT c_sla_service_tag_1 FOREIGN KEY (slaid) REFERENCES sla (slaid) ON DELETE CASCADE; 2023-01-04 09:31:01.218 CET zabbix zabbix [14928]ERROR: constraint "c_host_rtdata_1" for relation "host_rtdata" already exists 2023-01-04 09:31:01.218 CET zabbix zabbix [14928]STATEMENT: ALTER TABLE ONLY host_rtdata ADD CONSTRAINT c_host_rtdata_1 FOREIGN KEY (hostid) REFERENCES hosts (hostid) ON DELETE CASCADE; 2023-01-04 09:34:47.799 CET [14691]LOG: received fast shutdown request 2023-01-04 09:34:47.803 CET [14691]LOG: aborting any active transactions 2023-01-04 09:34:47.804 CET [14691]LOG: background worker "logical replication launcher" (PID 14699) exited with exit code 1 2023-01-04 09:34:47.844 CET [14694]LOG: shutting down 2023-01-04 09:34:48.238 CET [14691]LOG: database system is shut down