Bug 1259789

Summary: "Sync Incomplete" with duplicate key
Product: Red Hat Satellite Reporter: Thom Carlin <tcarlin>
Component: Content ManagementAssignee: Katello Bug Bin <katello-bugs>
Status: CLOSED DUPLICATE QA Contact: Katello QA List <katello-qa-list>
Severity: medium Docs Contact:
Priority: unspecified    
Version: 6.1.0CC: bbuckingham, jmatthew
Target Milestone: Unspecified   
Target Release: Unused   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
: 1260212 (view as bug list) Environment:
Last Closed: 2015-11-18 20:53:46 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:
Embargoed:
Bug Depends On:    
Bug Blocks: 1212602, 1260212    

Description Thom Carlin 2015-09-03 14:21:17 UTC
Description of problem:

During RHN content sync, receive "Sync Incomplete" with "PGError: ERROR:  duplicate key value violates unique constraint "index_operatingsystems_on_title"
DETAIL:  Key (title)=(RedHat 6.7) already exists.
: INSERT INTO "operatingsystems" ("created_at", "description", "hostgroups_count", "hosts_count", "major", "minor", "name", "nameindicator", "password_hash", "release_name", "title", "type", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13) RETURNING "id""

Version-Release number of selected component (if applicable):

6.1.1

How reproducible:

Intermittent

Steps to Reproduce:
1. Install RHCI 6.0 tech preview Anaconda (Sat 6 server)
2. subscription-manager/yum update (Sat 6 server)
3. fusor-installer
4. New deployment

Actual results:

"Sync Incomplete" on one or more repositories

Expected results:

Sync Complete

Additional info:

RHCI 6.0 tech preview

Comment 1 Thom Carlin 2015-09-03 14:23:27 UTC
Packages Altered:
    Updated     bind-32:9.9.4-18.el7_1.3.x86_64                             @anaconda/6.0
    Update           32:9.9.4-18.el7_1.5.x86_64                             @rhel-7-server-rpms
    Updated     bind-libs-32:9.9.4-18.el7_1.3.x86_64                        @anaconda/6.0
    Update                32:9.9.4-18.el7_1.5.x86_64                        @rhel-7-server-rpms
    Updated     bind-libs-lite-32:9.9.4-18.el7_1.3.x86_64                   @anaconda/6.0
    Update                     32:9.9.4-18.el7_1.5.x86_64                   @rhel-7-server-rpms
    Updated     bind-license-32:9.9.4-18.el7_1.3.noarch                     @anaconda/6.0
    Update                   32:9.9.4-18.el7_1.5.noarch                     @rhel-7-server-rpms
    Updated     bind-utils-32:9.9.4-18.el7_1.3.x86_64                       @anaconda/6.0
    Update                 32:9.9.4-18.el7_1.5.x86_64                       @rhel-7-server-rpms
    Updated     foreman-1.7.2.33-1.el7sat.noarch                            @anaconda/6.0
    Update              1.7.2.34-1.el7sat.noarch                            @rhel-7-server-satellite-6.1-rpms
    Updated     foreman-compute-1.7.2.33-1.el7sat.noarch                    @anaconda/6.0
    Update                      1.7.2.34-1.el7sat.noarch                    @rhel-7-server-satellite-6.1-rpms
    Updated     foreman-debug-1.7.2.33-1.el7sat.noarch                      @anaconda/6.0
    Update                    1.7.2.34-1.el7sat.noarch                      @rhel-7-server-satellite-6.1-rpms
    Updated     foreman-gce-1.7.2.33-1.el7sat.noarch                        @anaconda/6.0
    Update                  1.7.2.34-1.el7sat.noarch                        @rhel-7-server-satellite-6.1-rpms
    Updated     foreman-libvirt-1.7.2.33-1.el7sat.noarch                    @anaconda/6.0
    Update                      1.7.2.34-1.el7sat.noarch                    @rhel-7-server-satellite-6.1-rpms
    Updated     foreman-ovirt-1.7.2.33-1.el7sat.noarch                      @anaconda/6.0
    Update                    1.7.2.34-1.el7sat.noarch                      @rhel-7-server-satellite-6.1-rpms
    Updated     foreman-postgresql-1.7.2.33-1.el7sat.noarch                 @anaconda/6.0
    Update                         1.7.2.34-1.el7sat.noarch                 @rhel-7-server-satellite-6.1-rpms
    Updated     foreman-vmware-1.7.2.33-1.el7sat.noarch                     @anaconda/6.0
    Update                     1.7.2.34-1.el7sat.noarch                     @rhel-7-server-satellite-6.1-rpms
    Updated     gdk-pixbuf2-2.28.2-4.el7.x86_64                             @anaconda/6.0
    Update                  2.28.2-5.el7_1.x86_64                           @rhel-7-server-rpms
    Updated     ipxe-bootimgs-20130517-6.gitc4bce43.el7.noarch              @anaconda/6.0
    Update                    20130517-7.1fm.gitc4bce43.el7sat.noarch       @rhel-7-server-satellite-6.1-rpms
    Updated     katello-2.2.0.14-1.el7sat.noarch                            @anaconda/6.0
    Update              2.2.0.15-1.el7sat.noarch                            @rhel-7-server-satellite-6.1-rpms
    Updated     katello-common-2.2.0.14-1.el7sat.noarch                     @anaconda/6.0
    Update                     2.2.0.15-1.el7sat.noarch                     @rhel-7-server-satellite-6.1-rpms
    Updated     katello-debug-2.2.0.14-1.el7sat.noarch                      @anaconda/6.0
    Update                    2.2.0.15-1.el7sat.noarch                      @rhel-7-server-satellite-6.1-rpms
    Updated     katello-service-2.2.0.14-1.el7sat.noarch                    @anaconda/6.0
    Update                      2.2.0.15-1.el7sat.noarch                    @rhel-7-server-satellite-6.1-rpms
    Updated     libreport-filesystem-2.1.11-22.el7_1.x86_64                 @anaconda/6.0
    Update                           2.1.11-23.el7_1.x86_64                 @rhel-7-server-rpms
    Updated     libvirt-client-1.2.8-16.el7_1.1.x86_64                      @anaconda/6.0
    Update                     1.2.8-16.el7_1.3.x86_64                      @rhel-7-server-rpms
    Updated     libvirt-devel-1.2.8-16.el7_1.1.x86_64                       @anaconda/6.0
    Update                    1.2.8-16.el7_1.3.x86_64                       @rhel-7-server-rpms
    Updated     libvirt-docs-1.2.8-16.el7_1.1.x86_64                        @anaconda/6.0
    Update                   1.2.8-16.el7_1.3.x86_64                        @rhel-7-server-rpms
    Updated     nss-softokn-3.16.2.3-11.el7_1.x86_64                        @anaconda/6.0
    Update                  3.16.2.3-13.el7_1.x86_64                        @rhel-7-server-rpms
    Updated     nss-softokn-freebl-3.16.2.3-11.el7_1.x86_64                 @anaconda/6.0
    Update                         3.16.2.3-13.el7_1.x86_64                 @rhel-7-server-rpms
    Dep-Install python-chardet-2.2.1-1.el7_1.noarch                         @rhel-7-server-rpms
    Updated     python-requests-2.4.3-1.el7sat.noarch                       @anaconda/6.0
    Update                      2.6.0-1.el7_1.noarch                        @rhel-7-server-rpms
    Dep-Install python-urllib3-1.10.2-2.el7_1.noarch                        @rhel-7-server-rpms
    Updated     ruby193-rubygem-foreman-redhat_access-0.2.1-1.el7sat.noarch @anaconda/6.0
    Update                                            0.2.3-1.el7sat.noarch @rhel-7-server-satellite-6.1-rpms
    Updated     ruby193-rubygem-katello-2.2.0.65-1.1.el7.noarch             @anaconda/6.0
    Update                              2.2.0.66-1.el7sat.noarch            @rhel-7-server-satellite-6.1-rpms
    Updated     selinux-policy-3.13.1-23.el7_1.13.noarch                    @anaconda/6.0
    Update                     3.13.1-23.el7_1.17.noarch                    @rhel-7-server-rpms
    Updated     selinux-policy-targeted-3.13.1-23.el7_1.13.noarch           @anaconda/6.0
    Update                              3.13.1-23.el7_1.17.noarch           @rhel-7-server-rpms
    Updated     xerces-j2-2.11.0-17.el7.noarch                              @anaconda/6.0
    Update                2.11.0-17.el7_0.noarch                            @rhel-7-server-rpms
history info

Comment 5 Brad Buckingham 2015-11-18 20:53:46 UTC
Closing this one as a duplicate of bug 1208618, which was recently delivered in 6.1.3.  Please do reopen, if the issue is observed again.

*** This bug has been marked as a duplicate of bug 1208618 ***