Uploaded image for project: 'Repository'
  1. Repository
  2. REPO-3515

Deployment: PostgreSQL issues ERROR messages to Docker output

    Details

    • Bug Priority:
      Category 1
    • Work Funnel:
      Feature
    • Sprint:
      Repo Deploy Sprint 31
    • Story Points:
      8
    • Work Funnel End:
      2018-05
    • Template:

      Description

      Acceptance Criteria:

      • PostgreSQL should not issue ERROR output to docker logs for constraint violations, which can be legitimately used to prevent duplication of data.
      postgres_1               | 2018-04-30 17:28:50.256 UTC [78] ERROR:  duplicate key value violates unique constraint "idx_alf_props_crc"
      postgres_1               | 2018-04-30 17:28:50.256 UTC [78] DETAIL:  Key (string_end_lower, string_crc)=(.shard_state, 3883392281) already exists.
      postgres_1               | 2018-04-30 17:28:50.256 UTC [78] STATEMENT:  insert into alf_prop_string_value (id, string_value, string_end_lower, string_crc) 
      postgres_1               | 	        values ($1, $2, $3, $4)
      postgres_1               | 2018-04-30 17:28:50.260 UTC [78] ERROR:  current transaction is aborted, commands ignored until end of transaction block
      postgres_1               | 2018-04-30 17:28:50.260 UTC [78] STATEMENT:  select
      postgres_1               | 	            id
      postgres_1               | 	        from
      postgres_1               | 	            alf_prop_string_value
      postgres_1               | 	        where
      postgres_1               | 	            string_end_lower = $1 and
      postgres_1               | 	            string_crc = $2
      

        Attachments

          Structure

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                dhulley Derek Hulley [X] (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Structure Helper Panel