Bug 1376270 - postgresql errors after installing sat 6.2.1 instance
Summary: postgresql errors after installing sat 6.2.1 instance
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Red Hat Satellite
Classification: Red Hat
Component: Upgrades
Version: 6.2.0
Hardware: x86_64
OS: Linux
medium
low vote
Target Milestone: Unspecified
Assignee: satellite6-bugs
QA Contact: Katello QA List
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2016-09-15 00:56 UTC by Reartes Guillermo
Modified: 2019-09-26 14:02 UTC (History)
1 user (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2018-03-29 18:54:47 UTC
Target Upstream Version:


Attachments (Terms of Use)
foreman-debug (886.44 KB, application/x-xz)
2016-09-15 00:56 UTC, Reartes Guillermo
no flags Details
sos-report (7.19 MB, application/x-xz)
2016-09-15 00:57 UTC, Reartes Guillermo
no flags Details

Description Reartes Guillermo 2016-09-15 00:56:18 UTC
Created attachment 1201052 [details]
foreman-debug

Description of problem:

I noticed some errors in the postgresql logs after installing a Sat6 instance.


Version-Release number of selected component (if applicable):
Sat 6.2.1 using RHEL7

How reproducible:


Steps to Reproduce:
1.  install satellite 6.2.1


Actual results:
errors in /var/lib/pgsql/data/pg_log*

ART ERROR:  no existe la relación «settings» en carácter 323
2016-09-10 00:40:52 ART SENTENCIA:                SELECT a.attname, format_type(a.atttypid, a.atttypmod),
                             pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod
                        FROM pg_attribute a LEFT JOIN pg_attrdef d
                          ON a.attrelid = d.adrelid AND a.attnum = d.adnum
                       WHERE a.attrelid = '"settings"'::regclass
                         AND a.attnum > 0 AND NOT a.attisdropped
                       ORDER BY a.attnum
        
2016-09-10 00:56:03 ART ERROR:  llave duplicada viola restricción de unicidad «dynflow_coordinator_records_pkey»

some other errors are logged alter.

Expected results:
no database errors

Additional info:
the sat6 instance (it is a testing instance) appears to work. i has only one host, so i cannot be sure yet.

Additional Info:
Sat is 6.2.1, but only 6.2.0 "version" is selectable in bugzilla.

Comment 1 Reartes Guillermo 2016-09-15 00:57:43 UTC
Created attachment 1201055 [details]
sos-report

Comment 5 jcallaha 2018-03-29 18:54:47 UTC
I've not seen anything similar to this in a long time. This may have been environmental. 
Closing, as I'm unable to reproduce on our current releases.


Note You need to log in before you can comment on or make changes to this bug.