Uploaded image for project: 'OpenIDM'
  1. OpenIDM
  2. OPENIDM-14375

embedded postgres error messages while starting IC on Windows

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Cannot Reproduce
    • Affects Version/s: 7.0.0
    • Fix Version/s: None
    • Labels:
    • Environment:
      "7.0.0-SNAPSHOT" (build: 20200207191351, revision: f4d2702) jenkins-OpenIDM-build-master-1626
      IC3.0.2-SNAPSHOT (build: 20200128204525, revision: 45ee164)

      Windows platform
    • Target Version/s:
    • Story Points:
      2
    • Sprint:
      2020.03 - IDM, 2020.04 - IDM

      Description

      There are some errors in postgres console output.

      2020-02-14 07:42:45.959 CET [16436] LOG:  listening on IPv6 address "::1", port 5433
      2020-02-14 07:42:45.959 CET [16436] LOG:  listening on IPv4 address "127.0.0.1", port 5433
      2020-02-14 07:42:45.999 CET [8256] LOG:  database system was shut down at 2020-02-14 07:42:32 CET
      2020-02-14 07:42:46.022 CET [16436] LOG:  database system is ready to accept connections
      2020-02-14 07:42:48.224 CET [8684] ERROR:  role "openidm" already exists
      2020-02-14 07:42:48.224 CET [8684] STATEMENT:  create user openidm with password 'openidm';
      2020-02-14 07:42:48.225 CET [8684] ERROR:  new encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII)
      2020-02-14 07:42:48.225 CET [8684] HINT:  Use the same encoding as in the template database, or use template0 as template.
      2020-02-14 07:42:48.225 CET [8684] STATEMENT:  create database openidm encoding 'utf8' owner openidm;
      2020-02-14 07:43:03.963 CET [1528] ERROR:  duplicate key value violates unique constraint "idx_schedulerobjects_object"
      2020-02-14 07:43:03.963 CET [1528] DETAIL:  Key (objecttypes_id, objectid)=(6, scheduler-service-group) already exists.
      2020-02-14 07:43:03.963 CET [1528] STATEMENT:  INSERT INTO openidm.schedulerobjects (objecttypes_id, fullobject, objectid, rev) VALUES ($1,$2::json,$3,$4)
                                                                                                                             RETURNING *
      2020-02-14 07:43:03.992 CET [1528] ERROR:  duplicate key value violates unique constraint "idx_schedulerobjects_object"
      2020-02-14 07:43:03.992 CET [1528] DETAIL:  Key (objecttypes_id, objectid)=(6, scheduler-service-group) already exists.
      2020-02-14 07:43:03.992 CET [1528] STATEMENT:  INSERT INTO openidm.schedulerobjects (objecttypes_id, fullobject, objectid, rev) VALUES ($1,$2::json,$3,$4)
                                                                                                                             RETURNING *
      2020-02-14 07:43:04.012 CET [1528] ERROR:  duplicate key value violates unique constraint "idx_schedulerobjects_object"
      2020-02-14 07:43:04.012 CET [1528] DETAIL:  Key (objecttypes_id, objectid)=(6, scheduler-service-group) already exists.
      2020-02-14 07:43:04.012 CET [1528] STATEMENT:  INSERT INTO openidm.schedulerobjects (objecttypes_id, fullobject, objectid, rev) VALUES ($1,$2::json,$3,$4)
                                                                                                                             RETURNING *
      2020-02-14 07:43:04.032 CET [1528] ERROR:  duplicate key value violates unique constraint "idx_schedulerobjects_object"
      2020-02-14 07:43:04.032 CET [1528] DETAIL:  Key (objecttypes_id, objectid)=(6, scheduler-service-group) already exists.
      2020-02-14 07:43:04.032 CET [1528] STATEMENT:  INSERT INTO openidm.schedulerobjects (objecttypes_id, fullobject, objectid, rev) VALUES ($1,$2::json,$3,$4)
                                                                                                                             RETURNING *
      2020-02-14 07:43:04.048 CET [1528] ERROR:  duplicate key value violates unique constraint "idx_schedulerobjects_object"
      2020-02-14 07:43:04.048 CET [1528] DETAIL:  Key (objecttypes_id, objectid)=(6, scheduler-service-group) already exists.
      2020-02-14 07:43:04.048 CET [1528] STATEMENT:  INSERT INTO openidm.schedulerobjects (objecttypes_id, fullobject, objectid, rev) VALUES ($1,$2::json,$3,$4)
                                                                                                                             RETURNING *
      
      

      On the other hand it does not seem to have effect on IC.

        Attachments

          Activity

            People

            • Assignee:
              alin Alin Brici
              Reporter:
              petr.cvancar Petr Cvancar
              QA Assignee:
              Petr Cvancar
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: