Errors since PostgreSQL update
Hi Uwe, All three instances now have some errors in the journal, that probably has to do with the latest update. Please go through the journals and have a look.
Cheers
Example:
Mar 06 11:29:51 eng-whdp1 docker-compose[3551111]: productive-alert-1 | + database is already initialized, use --force TWICE to setup a fresh and empty database. YOU WILL LOOSE ALL EXISTING DATA !!!
Mar 06 11:29:52 eng-whdp1 docker-compose[3551111]: productive-alert-1 | ERROR: relation "for_shiny" already exists
Mar 06 11:29:52 eng-whdp1 docker-compose[3551111]: productive-postgis-1 | 2023-03-06 10:29:52.172 UTC [42] ERROR: relation "for_shiny" already exists
Mar 06 11:29:52 eng-whdp1 docker-compose[3551111]: productive-postgis-1 | 2023-03-06 10:29:52.172 UTC [42] STATEMENT: CREATE TABLE for_shiny
Mar 06 11:29:52 eng-whdp1 docker-compose[3551111]: productive-postgis-1 | (
Mar 06 11:29:52 eng-whdp1 docker-compose[3551111]: productive-postgis-1 | signal_id integer,
Mar 06 11:29:52 eng-whdp1 docker-compose[3551111]: productive-postgis-1 | signal_quality_id integer,
Mar 06 11:29:52 eng-whdp1 docker-compose[3551111]: productive-postgis-1 | timestamp timestamp NOT NULL,
Mar 06 11:29:52 eng-whdp1 docker-compose[3551111]: productive-postgis-1 | value double precision,
Mar 06 11:29:52 eng-whdp1 docker-compose[3551111]: productive-postgis-1 | unit varchar,
Mar 06 11:29:52 eng-whdp1 docker-compose[3551111]: productive-postgis-1 | variable_name varchar,
Mar 06 11:29:52 eng-whdp1 docker-compose[3551111]: productive-postgis-1 | source_type_name varchar,
Mar 06 11:29:52 eng-whdp1 docker-compose[3551111]: productive-postgis-1 | source_name varchar,
Mar 06 11:29:52 eng-whdp1 docker-compose[3551111]: productive-postgis-1 | site_name varchar
Mar 06 11:29:52 eng-whdp1 docker-compose[3551111]: productive-postgis-1 | );
Mar 06 11:29:52 eng-whdp1 docker-compose[3551111]: productive-postgis-1 | 2023-03-06 10:29:52.178 UTC [42] ERROR: table "for_shiny" is already a hypertable
Mar 06 11:29:52 eng-whdp1 docker-compose[3551111]: productive-postgis-1 | 2023-03-06 10:29:52.178 UTC [42] STATEMENT: SELECT create_hypertable('for_shiny', 'timestamp');
Mar 06 11:29:52 eng-whdp1 docker-compose[3551111]: productive-alert-1 | ERROR: table "for_shiny" is already a hypertable
Mar 06 11:29:52 eng-whdp1 docker-compose[3551111]: productive-postgis-1 | 2023-03-06 10:29:52.182 UTC [42] ERROR: relation "ix_for_shiny_variable_name" already exists
Mar 06 11:29:52 eng-whdp1 docker-compose[3551111]: productive-postgis-1 | 2023-03-06 10:29:52.182 UTC [42] STATEMENT: CREATE INDEX ix_for_shiny_variable_name ON for_shiny(variable_name);
Mar 06 11:29:52 eng-whdp1 docker-compose[3551111]: productive-alert-1 | ERROR: relation "ix_for_shiny_variable_name" already exists
Mar 06 11:29:52 eng-whdp1 docker-compose[3551111]: productive-postgis-1 | 2023-03-06 10:29:52.183 UTC [42] ERROR: relation "ix_for_shiny_site_name" already exists
Mar 06 11:29:52 eng-whdp1 docker-compose[3551111]: productive-postgis-1 | 2023-03-06 10:29:52.183 UTC [42] STATEMENT: CREATE INDEX ix_for_shiny_site_name ON for_shiny(site_name);
Mar 06 11:29:52 eng-whdp1 docker-compose[3551111]: productive-alert-1 | ERROR: relation "ix_for_shiny_site_name" already exists
Mar 06 11:29:52 eng-whdp1 docker-compose[3551111]: productive-postgis-1 | 2023-03-06 10:29:52.184 UTC [42] ERROR: relation "ix_for_shiny_signal_id" already exists
Mar 06 11:29:52 eng-whdp1 docker-compose[3551111]: productive-postgis-1 | 2023-03-06 10:29:52.184 UTC [42] STATEMENT: CREATE INDEX ix_for_shiny_signal_id ON for_shiny(signal_id);
Mar 06 11:29:52 eng-whdp1 docker-compose[3551111]: productive-alert-1 | create function
Mar 06 11:29:52 eng-whdp1 docker-compose[3551111]: productive-alert-1 | ERROR: relation "ix_for_shiny_signal_id" already exists
Mar 06 11:29:52 eng-whdp1 docker-compose[3551111]: productive-alert-1 | CREATE FUNCTION
Mar 06 11:29:52 eng-whdp1 docker-compose[3551111]: productive-alert-1 | create hypertable
Mar 06 11:29:52 eng-whdp1 docker-compose[3551111]: productive-postgis-1 | 2023-03-06 10:29:52.366 UTC [42] ERROR: constraint "signal_pkey" of relation "signal" does not exist
Mar 06 11:29:52 eng-whdp1 docker-compose[3551111]: productive-postgis-1 | 2023-03-06 10:29:52.366 UTC [42] STATEMENT: ALTER TABLE signal DROP CONSTRAINT signal_pkey CASCADE;
Mar 06 11:29:52 eng-whdp1 docker-compose[3551111]: productive-alert-1 | ERROR: constraint "signal_pkey" of relation "signal" does not exist
Mar 06 11:29:52 eng-whdp1 docker-compose[3551111]: productive-postgis-1 | 2023-03-06 10:29:52.366 UTC [42] ERROR: table "signal" is already a hypertable
Mar 06 11:29:52 eng-whdp1 docker-compose[3551111]: productive-postgis-1 | 2023-03-06 10:29:52.366 UTC [42] STATEMENT: SELECT create_hypertable('signal', 'timestamp');
Mar 06 11:29:52 eng-whdp1 docker-compose[3551111]: productive-alert-1 | ERROR: table "signal" is already a hypertable
Mar 06 11:29:52 eng-whdp1 docker-compose[3551111]: productive-alert-1 | set datapool_reader permissions
Mar 06 11:29:52 eng-whdp1 docker-compose[3551111]: productive-alert-1 | SET
General overview:
Mar 06 07:50:57 eaw-sdwh3 docker-compose[239956]: productive-postgis-1 | 2023-03-06 06:50:57.602 UTC [74393] ERROR: relation "parameter" does not exist at character 140
Mar 06 07:50:57 eaw-sdwh3 docker-compose[239956]: productive-postgis-1 | 2023-03-06 06:50:57.625 UTC [74395] ERROR: relation "parameter" does not exist at character 140
Mar 06 07:50:57 eaw-sdwh3 docker-compose[239956]: productive-postgis-1 | 2023-03-06 06:50:57.856 UTC [74395] ERROR: relation "parameter" does not exist at character 140
Mar 06 07:50:57 eaw-sdwh3 docker-compose[239956]: productive-postgis-1 | 2023-03-06 06:50:57.906 UTC [74393] ERROR: relation "parameter" does not exist at character 140
Mar 06 07:50:57 eaw-sdwh3 docker-compose[239956]: productive-postgis-1 | 2023-03-06 06:50:57.907 UTC [74395] ERROR: relation "parameter" does not exist at character 140
Mar 06 07:50:57 eaw-sdwh3 docker-compose[239956]: productive-postgis-1 | 2023-03-06 06:50:57.959 UTC [74393] ERROR: relation "parameter" does not exist at character 140
Mar 06 15:32:28 eaw-sdwh3 docker-compose[239956]: productive-postgis-1 | 2023-03-06 14:32:28.660 UTC [84840] ERROR: syntax error at or near "ORDER" at character 291
Mar 06 15:32:57 eaw-sdwh3 docker-compose[239956]: productive-postgis-1 | 2023-03-06 14:32:57.265 UTC [84850] ERROR: syntax error at or near "DESC" at character 321