Bug 1376270

Summary: postgresql errors after installing sat 6.2.1 instance
Product: Red Hat Satellite Reporter: Reartes Guillermo <greartes>
Component: UpgradesAssignee: satellite6-bugs <satellite6-bugs>
Status: CLOSED CURRENTRELEASE QA Contact: Katello QA List <katello-qa-list>
Severity: low Docs Contact:
Priority: medium    
Version: 6.2.0CC: jcallaha
Target Milestone: UnspecifiedKeywords: Triaged
Target Release: Unused   
Hardware: x86_64   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2018-03-29 18:54:47 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Attachments:
Description Flags
foreman-debug
none
sos-report none

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.