Uploaded image for project: 'COmanage'
  1. COmanage
  2. CO-2704

PostgreSQL errors during database initialization

    XMLWordPrintable

Details

    Description

      During the database initialization with 4.3.0 RC2 PostgreSQL logs this:

      basic-auth-comanage-registry-database-1  | 2023-09-15 13:43:45.820 UTC [1] LOG:  starting PostgreSQL 14.9 (Debian 14.9-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
      basic-auth-comanage-registry-database-1  | 2023-09-15 13:43:45.821 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
      basic-auth-comanage-registry-database-1  | 2023-09-15 13:43:45.821 UTC [1] LOG:  listening on IPv6 address "::", port 5432
      basic-auth-comanage-registry-database-1  | 2023-09-15 13:43:45.823 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
      basic-auth-comanage-registry-database-1  | 2023-09-15 13:43:45.825 UTC [62] LOG:  database system was shut down at 2023-09-15 13:43:45 UTC
      basic-auth-comanage-registry-database-1  | 2023-09-15 13:43:45.829 UTC [1] LOG:  database system is ready to accept connections
      basic-auth-comanage-registry-database-1  | 2023-09-15 13:43:46.813 UTC [72] ERROR:  relation "cm_co_provisioning_targets" does not exist
      basic-auth-comanage-registry-database-1  | 2023-09-15 13:43:46.813 UTC [72] STATEMENT:  CREATE TABLE cm_co_provisioning_counts (
      basic-auth-comanage-registry-database-1  |     id SERIAL,
      basic-auth-comanage-registry-database-1  |     co_provisioning_target_id INTEGER NOT NULL REFERENCES cm_co_provisioning_targets(id),
      basic-auth-comanage-registry-database-1  |     co_job_id INTEGER REFERENCES cm_co_jobs(id),
      basic-auth-comanage-registry-database-1  |     provisioning_count INTEGER,
      basic-auth-comanage-registry-database-1  |     created TIMESTAMP,
      basic-auth-comanage-registry-database-1  |     modified TIMESTAMP,
      basic-auth-comanage-registry-database-1  |     co_provisioning_count_id INTEGER REFERENCES cm_co_provisioning_counts(id),
      basic-auth-comanage-registry-database-1  |     revision INTEGER,
      basic-auth-comanage-registry-database-1  |     deleted BOOLEAN,
      basic-auth-comanage-registry-database-1  |     actor_identifier VARCHAR(256),
      basic-auth-comanage-registry-database-1  |                      PRIMARY KEY (id)
      basic-auth-comanage-registry-database-1  |     )
      basic-auth-comanage-registry-database-1  | 2023-09-15 13:43:46.813 UTC [72] ERROR:  relation "cm_co_provisioning_counts" does not exist
      basic-auth-comanage-registry-database-1  | 2023-09-15 13:43:46.813 UTC [72] STATEMENT:  CREATE INDEX cm_co_provisioning_counts_i1 ON cm_co_provisioning_counts (co_provisioning_target_id)
      basic-auth-comanage-registry-database-1  | 2023-09-15 13:43:46.813 UTC [72] ERROR:  relation "cm_co_provisioning_counts" does not exist
      basic-auth-comanage-registry-database-1  | 2023-09-15 13:43:46.813 UTC [72] STATEMENT:  CREATE INDEX cm_co_provisioning_counts_i2 ON cm_co_provisioning_counts (co_provisioning_count_id)
      basic-auth-comanage-registry-database-1  | 2023-09-15 13:43:46.813 UTC [72] ERROR:  relation "cm_co_provisioning_counts" does not exist
      basic-auth-comanage-registry-database-1  | 2023-09-15 13:43:46.813 UTC [72] STATEMENT:  CREATE INDEX cm_co_provisioning_counts_i3 ON cm_co_provisioning_counts (co_job_id) 

      Attachments

        Activity

          People

            ioannis.e.igoumenos@at.internet2.edu Ioannis Eythymios Igoumenos (google.com)
            scott.koranda@at.internet2.edu Scott Koranda (uwm.edu/illinois.edu)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: