Bug 953965

Summary: Creating Repositories via repo discovery fails
Product: Red Hat Satellite Reporter: sthirugn <sthirugn>
Component: WebUIAssignee: Justin Sherrill <jsherril>
Status: CLOSED CURRENTRELEASE QA Contact: Og Maciel <omaciel>
Severity: high Docs Contact:
Priority: unspecified    
Version: NightlyCC: mmccune, omaciel
Target Milestone: UnspecifiedKeywords: 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: 2013-07-18 21:19:19 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:
Attachments:
Description Flags
SQL exception on creating repositories none

Description sthirugn@redhat.com 2013-04-19 17:28:07 UTC
Created attachment 737703 [details]
SQL exception on creating repositories

Description of problem:
Creating Repositories via repo discovery fails

Version-Release number of selected component (if applicable):
* candlepin-0.8.3-1.el6.noarch
* candlepin-selinux-0.8.3-1.el6.noarch
* candlepin-tomcat6-0.8.3-1.el6.noarch
* elasticsearch-0.19.9-7.el6.noarch
* katello-1.4.1-1.git.122.0cefe14.el6.noarch
* katello-all-1.4.1-1.git.122.0cefe14.el6.noarch
* katello-candlepin-cert-key-pair-1.0-1.noarch
* katello-certs-tools-1.4.1-1.el6.noarch
* katello-cli-1.4.1-1.git.21.1e2ff04.el6.noarch
* katello-cli-common-1.4.1-1.git.21.1e2ff04.el6.noarch
* katello-common-1.4.1-1.git.122.0cefe14.el6.noarch
* katello-configure-1.4.1-1.git.111.f7f9fea.el6.noarch
* katello-glue-candlepin-1.4.1-1.git.122.0cefe14.el6.noarch
* katello-glue-elasticsearch-1.4.1-1.git.122.0cefe14.el6.noarch
* katello-glue-pulp-1.4.1-1.git.122.0cefe14.el6.noarch
* Katello-Katello-Installation-ConfigureRepos-1.7-3.noarch
* Katello-Katello-Installation-KatelloNightly-1.0-10.noarch
* Katello-Katello-Installation-RegisterRHNClassic-1.1-3.noarch
* Katello-Katello-Sanity-ImportKeys-1.2-1.noarch
* katello-qpid-broker-key-pair-1.0-1.noarch
* katello-qpid-client-key-pair-1.0-1.noarch
* katello-repos-1.4.1-1.el6.noarch
* katello-selinux-1.4.1-1.el6.noarch
* pulp-rpm-plugins-2.1.1-0.6.beta.el6.noarch
* pulp-selinux-2.1.1-0.1.beta.el6.noarch
* pulp-server-2.1.1-0.1.beta.el6.noarch

How reproducible:
Always

Steps to Reproduce:
1.Create a Provider
2.Select the Provider -> Repository Discovery
3.Enter the URL and click Discover
4.Once the URLs are discovered, select few and click 'Create Within Product'
5.Select New Product and enter New Product Name
6.Leave the default Repository names as is and click 'Create Repositories'

  
Actual results:
1. User notification shows that the product is created but it is also followed by a SQL exception (see screenshot)
2. Go back to the Products & Repositories tab.  Note that the product is created but the corresponding Repo is not

Expected results:
The product and the repository successfully created with no errors

Additional info:

Comment 1 Mike McCune 2013-04-19 21:28:50 UTC
Can you re-test this on the Nightly post 4/20?  this was fixed in PR:

https://github.com/Katello/katello/pull/2011

Comment 2 Og Maciel 2013-05-28 21:31:23 UTC
Verified:
* apr-util-ldap-1.3.9-3.el6_0.1.x86_64
* candlepin-0.8.9-1.el6_4.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.8.9-1.el6_4.noarch
* candlepin-tomcat6-0.8.9-1.el6_4.noarch
* elasticsearch-0.19.9-8.el6sat.noarch
* foreman-1.1.10002-40.noarch
* foreman-installer-puppet-concat-0-2.d776701.el6sat.noarch
* foreman-installer-puppet-dhcp-0-5.3a4a13c.el6sat.noarch
* foreman-installer-puppet-dns-0-7.fcae203.el6sat.noarch
* foreman-installer-puppet-foreman-0-6.568c5c4.el6sat.noarch
* foreman-installer-puppet-foreman_proxy-0-8.bd1e35d.el6sat.noarch
* foreman-installer-puppet-puppet-0-3.ab46748.el6sat.noarch
* foreman-installer-puppet-tftp-0-5.ea6c5e5.el6sat.noarch
* foreman-installer-puppet-xinetd-0-50a267b8.git.0.44aca6a.el6sat.noarch
* foreman-postgresql-1.1.10002-40.noarch
* foreman-proxy-1.1.10001-1.el6sat.noarch
* foreman-proxy-installer-1.0.1-7.f5ae2cd.el6sat.noarch
* katello-1.4.2-7.el6sat.noarch
* katello-all-1.4.2-7.el6sat.noarch
* katello-candlepin-cert-key-pair-1.0-1.noarch
* katello-certs-tools-1.4.2-2.el6sat.noarch
* katello-cli-1.4.2-6.el6sat.noarch
* katello-cli-common-1.4.2-6.el6sat.noarch
* katello-common-1.4.2-7.el6sat.noarch
* katello-configure-1.4.3-10.el6sat.noarch
* katello-configure-foreman-1.4.3-10.el6sat.noarch
* katello-foreman-all-1.4.2-7.el6sat.noarch
* katello-glue-candlepin-1.4.2-7.el6sat.noarch
* katello-glue-elasticsearch-1.4.2-7.el6sat.noarch
* katello-glue-pulp-1.4.2-7.el6sat.noarch
* katello-qpid-broker-key-pair-1.0-1.noarch
* katello-qpid-client-key-pair-1.0-1.noarch
* katello-selinux-1.4.3-3.el6sat.noarch
* openldap-2.4.23-31.el6.x86_64
* pulp-rpm-plugins-2.1.1-1.el6sat.noarch
* pulp-selinux-2.1.1-1.el6sat.noarch
* pulp-server-2.1.1-1.el6sat.noarch
* python-ldap-2.3.10-1.el6.x86_64
* ruby193-rubygem-ldap_fluff-0.1.7-3.el6sat.noarch
* ruby193-rubygem-net-ldap-0.2.2-7.el6_4.noarch
* signo-0.0.12-1.el6sat.noarch
* signo-katello-0.0.12-1.el6sat.noarch

Comment 4 Mike McCune 2013-07-18 21:19:19 UTC
mass move to CLOSED:CURRENTRELEASE since MDP1 has been released.