Jira (PDB-5494) PuppetDB create multiple index if not exists

[Aurélien Le Clainche]

Aurélien Le Clainche created an issue

PuppetDB / PDB-5494 PuppetDB create multiple index if not exists Issue Type: Bug Affects Versions: PDB 6.9.1 Assignee: Unassigned Components: PuppetDB Created: 2022/05/03 1:06 AM Priority: Major Reporter: Aurélien Le Clainche Who found the bug? me Where was the bug found? System: linux RHEL 7 Operating system(s): RHEL 7 Puppet version: 6 Postgres: 12.9 What is malfunctioning? After a database server migration from server 1 to server 2 with the same version of postgres and OS, we noticed that there are a lot of logs on the database server:  // 2022-05-03 09:49:00 CEST [3127920]: user=puppetdb,db=puppetdb,app=PostgreSQL JDBC Driver,client=10.24.48.207 LOG:  execute <unnamed>: CREATE INDEX IF NOT EXISTS resource_events_status_idx_20220503Z ON resource_events_20220503Z USING btree (status) 2022-05-03 09:49:00 CEST [3127920]: user=puppetdb,db=puppetdb,app=PostgreSQL JDBC Driver,client=10.24.48.207 NOTICE:  relation "resource_events_status_idx_20220503z" already exists, skipping 2022-05-03 09:49:00 CEST [3127920]: user=puppetdb,db=puppetdb,app=PostgreSQL JDBC Driver,client=10.24.48.207 LOG:  execute <unnamed>: CREATE INDEX IF NOT EXISTS resource_events_timestamp_idx_20220503Z ON resource_events_20220503Z USING btree ("timestamp") 2022-05-03 09:49:00 CEST [3127920]: user=puppetdb,db=puppetdb,app=PostgreSQL JDBC Driver,client=10.24.48.207 NOTICE:  relation "resource_events_timestamp_idx_20220503z" already exists, skipping 2022-05-03 09:49:00 CEST [3127920]: user=puppetdb,db=puppetdb,app=PostgreSQL JDBC Driver,client=10.24.48.207 LOG:  execute <unnamed>: CREATE UNIQUE INDEX IF NOT EXISTS resource_events_hash_20220503Z ON resource_events_20220503Z (event_hash) 2022-05-03 09:49:00 CEST [3127920]: user=puppetdb,db=puppetdb,app=PostgreSQL JDBC Driver,client=10.24.48.207 NOTICE:  relation "resource_events_hash_20220503z" already exists, skipping 2022-05-03 09:49:00 CEST [3127920]: user=puppetdb,db=puppetdb,app=PostgreSQL JDBC Driver,client=10.24.48.207 LOG:  execute <unnamed>: CREATE TABLE IF NOT EXISTS resource_events_20220503Z ( CHECK ( "timestamp" >= TIMESTAMP WITH TIME ZONE '2022-05-03T00:00:00Z' AND "timestamp" < TIMESTAMP WITH TIME ZONE '2022-05-04T00:00:00Z' )) INHERITS (resource_events) 2022-05-03 09:49:00 CEST [3127920]: user=puppetdb,db=puppetdb,app=PostgreSQL JDBC Driver,client=10.24.48.207 NOTICE:  relation "resource_events_20220503z" already exists, skipping 2022-05-03 09:49:00 CEST [3127920]: user=puppetdb,db=puppetdb,app=PostgreSQL JDBC Driver,client=10.24.48.207 LOG:  execute <unnamed>: CREATE INDEX IF NOT EXISTS resource_events_containing_class_idx_20220503Z ON resource_events_20220503Z USING btree (containing_class) 2022-05-03 09:49:00 CEST [3127920]: user=puppetdb,db=puppetdb,app=PostgreSQL JDBC Driver,client=10.24.48.207 NOTICE:  relation "resource_events_containing_class_idx_20220503z" already exists, skipping 2022-05-03 09:49:00 CEST [3127920]: user=puppetdb,db=puppetdb,app=PostgreSQL JDBC Driver,client=10.24.48.207 LOG:  execute <unnamed>: CREATE INDEX IF NOT EXISTS resource_events_property_idx_20220503Z ON resource_events_20220503Z USING btree (property) 2022-05-03 09:49:00 CEST [3127920]: user=puppetdb,db=puppetdb,app=PostgreSQL JDBC Driver,client=10.24.48.207 NOTICE:  relation "resource_events_property_idx_20220503z" already exists, skipping 2022-05-03 09:49:00 CEST [3127920]: user=puppetdb,db=puppetdb,app=PostgreSQL JDBC Driver,client=10.24.48.207 LOG:  execute <unnamed>: CREATE INDEX IF NOT EXISTS resource_events_reports_id_idx_20220503Z ON resource_events_20220503Z USING btree (report_id) 2022-05-03 09:49:00 CEST [3127920]: user=puppetdb,db=puppetdb,app=PostgreSQL JDBC Driver,client=10.24.48.207 NOTICE:  relation "resource_events_reports_id_idx_20220503z" already exists, skipping 2022-05-03 09:49:00 CEST [3127920]: user=puppetdb,db=puppetdb,app=PostgreSQL JDBC Driver,client=10.24.48.207 LOG:  execute <unnamed>: CREATE INDEX IF NOT EXISTS resource_events_resource_timestamp_20220503Z ON resource_events_20220503Z USING btree (resource_type, resource_title, "timestamp") 2022-05-03 09:49:00 CEST [3127920]: user=puppetdb,db=puppetdb,app=PostgreSQL JDBC Driver,client=10.24.48.207 NOTICE:  relation "resource_events_resource_timestamp_20220503z" already exists, skipping 2022-05-03 09:49:00 CEST [3127920]: user=puppetdb,db=puppetdb,app=PostgreSQL JDBC Driver,client=10.24.48.207 LOG:  execute <unnamed>: CREATE INDEX IF NOT EXISTS resource_events_resource_title_idx_20220503Z ON resource_events_20220503Z USING btree (resource_title) 2022-05-03 09:49:00 CEST [3127920]: user=puppetdb,db=puppetdb,app=PostgreSQL JDBC Driver,client=10.24.48.207 NOTICE:  relation "resource_events_resource_title_idx_20220503z" already exists, skipping 2022-05-03 09:49:00 CEST [3127920]: user=puppetdb,db=puppetdb,app=PostgreSQL JDBC Driver,client=10.24.48.207 LOG:  execute <unnamed>: CREATE INDEX IF NOT EXISTS resource_events_status_for_corrective_change_idx_20220503Z ON resource_events_20220503Z USING btree (status) WHERE corrective_change 2022-05-03 09:49:00 CEST [3127920]: user=puppetdb,db=puppetdb,app=PostgreSQL JDBC Driver,client=10.24.48.207 NOTICE:  relation "resource_events_status_for_corrective_change_idx_20220503z" already exists, skipping 2022-05-03 09:49:00 CEST [3127920]: user=puppetdb,db=puppetdb,app=PostgreSQL JDBC Driver,client=10.24.48.207 LOG:  execute <unnamed>: CREATE INDEX IF NOT EXISTS resource_events_status_idx_20220503Z ON resource_events_20220503Z USING btree (status) 2022-05-03 09:49:00 CEST [3127920]: user=puppetdb,db=puppetdb,app=PostgreSQL JDBC Driver,client=10.24.48.207 NOTICE:  relation "resource_events_status_idx_20220503z" already exists, skipping 2022-05-03 09:49:00 CEST [3127920]: user=puppetdb,db=puppetdb,app=PostgreSQL JDBC Driver,client=10.24.48.207 LOG:  execute <unnamed>: CREATE INDEX IF NOT EXISTS resource_events_timestamp_idx_20220503Z ON resource_events_20220503Z USING btree ("timestamp") 2022-05-03 09:49:00 CEST [3127920]: user=puppetdb,db=puppetdb,app=PostgreSQL JDBC Driver,client=10.24.48.207 NOTICE:  relation "resource_events_timestamp_idx_20220503z" already exists, skipping 2022-05-03 09:49:00 CEST [3127920]: user=puppetdb,db=puppetdb,app=PostgreSQL JDBC Driver,client=10.24.48.207 LOG:  execute <unnamed>: CREATE UNIQUE INDEX IF NOT EXISTS resource_events_hash_20220503Z ON resource_events_20220503Z (event_hash) is the behavior normal? Thank Add Comment

This message was sent by Atlassian Jira (v8.20.2#820002-sha1:829506d)