Bug 1131170
| Summary: | PG Error when synchronizing RHEL content | ||
|---|---|---|---|
| Product: | Red Hat Satellite | Reporter: | Og Maciel <omaciel> |
| Component: | Content Management | Assignee: | Ivan Necas <inecas> |
| Status: | CLOSED CURRENTRELEASE | QA Contact: | Og Maciel <omaciel> |
| Severity: | high | Docs Contact: | |
| Priority: | unspecified | ||
| Version: | 6.0.4 | CC: | bbuckingham, jhutar, jmontleo, sthirugn |
| Target Milestone: | Unspecified | Keywords: | Triaged |
| Target Release: | Unused | ||
| Hardware: | Unspecified | ||
| OS: | Unspecified | ||
| Whiteboard: | |||
| Fixed In Version: | Doc Type: | Bug Fix | |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2014-09-11 12:21:22 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: | 1120813 | ||
| Bug Blocks: | |||
Since this issue was entered in Red Hat Bugzilla, the release flag has been set to ? to ensure that it is properly evaluated for this release. *** Bug 1131439 has been marked as a duplicate of this bug. *** This issue is actually being addressed by the removal of the 'delayed jobs' process. The work for that is being tracked as part of bug 1120813. No additional work should be necessary for this one; however, since 1120813 is not specifically describing this problem, not closing it as a duplicate at this time. Jan, correct, this should have been aligned with 6.0.4. The issue raised by this bug should be addressed once the delayed jobs has been removed. The work to support that is being tracked with bug 1120813. VERIFIED: Browser: ===== * Firefox 31.0 (MacOS) Build: ==== * Satellite-6.0.4-RHEL-6-20140829.0 Packages: ====== * apr-util-ldap-1.3.9-3.el6_0.1.x86_64 * candlepin-0.9.23-1.el6_5.noarch * candlepin-common-1.0.1-1.el6_5.noarch * candlepin-scl-1-5.el6_4.noarch * candlepin-scl-quartz-2.1.5-5.el6_4.noarch * candlepin-scl-rhino-1.7R3-1.el6_4.noarch * candlepin-scl-runtime-1-5.el6_4.noarch * candlepin-selinux-0.9.23-1.el6_5.noarch * candlepin-tomcat6-0.9.23-1.el6_5.noarch * elasticsearch-0.90.10-6.el6sat.noarch * foreman-1.6.0.42-1.el6sat.noarch * foreman-compute-1.6.0.42-1.el6sat.noarch * foreman-gce-1.6.0.42-1.el6sat.noarch * foreman-libvirt-1.6.0.42-1.el6sat.noarch * foreman-ovirt-1.6.0.42-1.el6sat.noarch * foreman-postgresql-1.6.0.42-1.el6sat.noarch * foreman-proxy-1.6.0.30-1.el6sat.noarch * foreman-selinux-1.6.0.14-1.el6sat.noarch * foreman-vmware-1.6.0.42-1.el6sat.noarch * katello-1.5.0-30.el6sat.noarch * katello-ca-consumer-cloud-qe-10.idmqe.lab.eng.bos.redhat.com-1.0-1.noarch * katello-certs-tools-1.5.6-1.el6sat.noarch * katello-default-ca-1.0-1.noarch * katello-installer-0.0.64-1.el6sat.noarch * katello-server-ca-1.0-1.noarch * openldap-2.4.23-32.el6_4.1.x86_64 * pulp-katello-0.3-4.el6sat.noarch * pulp-nodes-common-2.4.1-0.5.rc1.el6sat.noarch * pulp-nodes-parent-2.4.1-0.5.rc1.el6sat.noarch * pulp-puppet-plugins-2.4.1-0.5.rc1.el6sat.noarch * pulp-puppet-tools-2.4.1-0.5.rc1.el6sat.noarch * pulp-rpm-plugins-2.4.1-0.6.beta.el6sat.noarch * pulp-selinux-2.4.1-0.5.rc1.el6sat.noarch * pulp-server-2.4.1-0.5.rc1.el6sat.noarch * python-ldap-2.3.10-1.el6.x86_64 * ruby193-rubygem-net-ldap-0.3.1-3.el6sat.noarch * ruby193-rubygem-runcible-1.1.0-2.el6sat.noarch * rubygem-hammer_cli-0.1.1-12.el6sat.noarch * rubygem-hammer_cli_foreman-0.1.1-16.el6sat.noarch * rubygem-hammer_cli_foreman_tasks-0.0.3-3.el6sat.noarch * rubygem-hammer_cli_import-0.10.2-1.2.el6sat.noarch * rubygem-hammer_cli_katello-0.0.4-14.el6sat.noarch Browser: ===== * Firefox 31.0 (MacOS) Build: ==== * Satellite/Satellite-6.0.4-RHEL-7-20140829.0 Packages: ====== * candlepin-0.9.23-1.el7.noarch * candlepin-common-1.0.1-1.el7.noarch * candlepin-guice-3.0-2_redhat_1.el7.noarch * candlepin-scl-1-5.el7.noarch * candlepin-scl-quartz-2.1.5-6.el7.noarch * candlepin-scl-rhino-1.7R3-3.el7.noarch * candlepin-scl-runtime-1-5.el7.noarch * candlepin-selinux-0.9.23-1.el7.noarch * candlepin-tomcat-0.9.23-1.el7.noarch * elasticsearch-0.90.10-6.el7sat.noarch * foreman-1.6.0.42-1.el7sat.noarch * foreman-compute-1.6.0.42-1.el7sat.noarch * foreman-gce-1.6.0.42-1.el7sat.noarch * foreman-libvirt-1.6.0.42-1.el7sat.noarch * foreman-ovirt-1.6.0.42-1.el7sat.noarch * foreman-postgresql-1.6.0.42-1.el7sat.noarch * foreman-proxy-1.6.0.30-1.el7sat.noarch * foreman-selinux-1.6.0.14-1.el7sat.noarch * foreman-vmware-1.6.0.42-1.el7sat.noarch * katello-1.5.0-30.el7sat.noarch * katello-certs-tools-1.5.6-1.el7sat.noarch * katello-default-ca-1.0-1.noarch * katello-installer-0.0.64-1.el7sat.noarch * katello-server-ca-1.0-1.noarch * openldap-2.4.39-3.el7.x86_64 * pulp-katello-0.3-4.el7sat.noarch * pulp-nodes-common-2.4.1-0.5.rc1.el7sat.noarch * pulp-nodes-parent-2.4.1-0.5.rc1.el7sat.noarch * pulp-puppet-plugins-2.4.1-0.5.rc1.el7sat.noarch * pulp-puppet-tools-2.4.1-0.5.rc1.el7sat.noarch * pulp-rpm-plugins-2.4.1-0.6.beta.el7sat.noarch * pulp-selinux-2.4.1-0.5.rc1.el7sat.noarch * pulp-server-2.4.1-0.5.rc1.el7sat.noarch * python-ldap-2.4.6-6.el7.x86_64 * ruby193-rubygem-net-ldap-0.3.1-3.el7sat.noarch * ruby193-rubygem-runcible-1.1.0-2.el7sat.noarch * rubygem-hammer_cli-0.1.1-12.el7sat.noarch * rubygem-hammer_cli_foreman-0.1.1-16.el7sat.noarch * rubygem-hammer_cli_foreman_tasks-0.0.3-3.el7sat.noarch * rubygem-hammer_cli_import-0.10.2-1.2.el7sat.noarch * rubygem-hammer_cli_katello-0.0.4-14.el7sat.noarch This was delivered with Satellite 6.0 which was released on 10 September 2014. |
Description of problem: While synchronizing RHEL content from the web UI, I saw the following error: PGError: ERROR: null value in column "user_id" violates not-null constraint As far as the web UI goes, the synchronization process is underway and seems to be working just fine, so I'm wondering what would have caused it... See the entire error here: http://pastebin.test.redhat.com/228570 Version-Release number of selected component (if applicable): Browser: -------- * Firefox 31.0 Mac OS OS: --- * RHEL 7Server x86_64 Build: ------ * Satellite-6.0.4-RHEL-7-20140813.2 Packages: --------- * candlepin-0.9.23-1.el7.noarch * candlepin-common-1.0.1-1.el7.noarch * candlepin-guice-3.0-2_redhat_1.el7.noarch * candlepin-scl-1-5.el7.noarch * candlepin-scl-quartz-2.1.5-6.el7.noarch * candlepin-scl-rhino-1.7R3-3.el7.noarch * candlepin-scl-runtime-1-5.el7.noarch * candlepin-selinux-0.9.23-1.el7.noarch * candlepin-tomcat-0.9.23-1.el7.noarch * elasticsearch-0.90.10-4.el7sat.noarch * foreman-1.6.0.40-1.el7sat.noarch * foreman-compute-1.6.0.40-1.el7sat.noarch * foreman-gce-1.6.0.40-1.el7sat.noarch * foreman-libvirt-1.6.0.40-1.el7sat.noarch * foreman-ovirt-1.6.0.40-1.el7sat.noarch * foreman-postgresql-1.6.0.40-1.el7sat.noarch * foreman-proxy-1.6.0.27-1.el7sat.noarch * foreman-selinux-1.6.0.6-1.el7sat.noarch * foreman-vmware-1.6.0.40-1.el7sat.noarch * katello-1.5.0-28.el7sat.noarch * katello-ca-1.0-1.noarch * katello-certs-tools-1.5.6-1.el7sat.noarch * katello-installer-0.0.59-1.el7sat.noarch * openldap-2.4.39-3.el7.x86_64 * pulp-katello-0.3-3.el7sat.noarch * pulp-nodes-common-2.4.0-0.30.beta.el7sat.noarch * pulp-nodes-parent-2.4.0-0.30.beta.el7sat.noarch * pulp-puppet-plugins-2.4.0-0.30.beta.el7sat.noarch * pulp-puppet-tools-2.4.0-0.30.beta.el7sat.noarch * pulp-rpm-plugins-2.4.0-0.30.beta.el7sat.noarch * pulp-selinux-2.4.0-0.30.beta.el7sat.noarch * pulp-server-2.4.0-0.30.beta.el7sat.noarch * python-ldap-2.4.6-6.el7.x86_64 * ruby193-rubygem-net-ldap-0.3.1-3.el7sat.noarch * ruby193-rubygem-runcible-1.1.0-2.el7sat.noarch * rubygem-hammer_cli-0.1.1-11.el7sat.noarch * rubygem-hammer_cli_foreman-0.1.1-15.el7sat.noarch * rubygem-hammer_cli_foreman_tasks-0.0.3-3.el7sat.noarch * rubygem-hammer_cli_katello-0.0.4-12.el7sat.noarch How reproducible: Steps to Reproduce: 1. Not sure if this is important, but make sure to use RHEL 7Server as your host 2. Import a valid manifest 3. Enable 'Red Hat Enterprise Linux 5 Server RPMs i386 5Server' and synchronize it from the UI, while watching /var/log/foreman/delayed_job.log Actual results: Though you see a traceback scroll through /var/log/foreman/delayed_job.log the UI continues with the sync process (though there's no progressbar) Expected results: Additional info: