Bug 1469632 - Error when refreshing manifest - Runtime Error could not execute statement at com.mysql.jdbc.SQLError.createSQLException
Error when refreshing manifest - Runtime Error could not execute statement at...
Status: ON_QA
Product: Red Hat Satellite 6
Classification: Red Hat
Component: Subscription Management (Show other bugs)
6.2.10
All All
unspecified Severity high (vote)
: GA
: --
Assigned To: Justin Sherrill
Katello QA List
: Triaged
Depends On:
Blocks:
  Show dependency treegraph
 
Reported: 2017-07-11 10:57 EDT by Waldirio M Pinheiro
Modified: 2017-08-21 08:27 EDT (History)
6 users (show)

See Also:
Fixed In Version: tfm-rubygem-katello-3.4.4
Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of:
Environment:
Last Closed:
Type: Bug
Regression: ---
Mount Type: ---
Documentation: ---
CRM:
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---


Attachments (Terms of Use)
Patch (2.74 KB, application/mbox)
2017-07-14 13:32 EDT, Justin Sherrill
no flags Details


External Trackers
Tracker ID Priority Status Summary Last Updated
Foreman Issue Tracker 20308 None None None 2017-07-14 12:42 EDT

  None (edit)
Description Waldirio M Pinheiro 2017-07-11 10:57:36 EDT
Description of problem:
When customer try to refresh the manifest, receive error below

# hammer subscription refresh-manifest --organization=<org name>
[....................................................................................................................................................................................................................................] [100%]
Error: Runtime Error could not execute statement at com.mysql.jdbc.SQLError.createSQLException:1,078
# 


Version-Release number of selected component (if applicable):
Sat 6.2.10 / candlepin-0.9.54.21-1.el6.noarch

How reproducible:
100% on reproducer *in house*

Steps to Reproduce:
1. Execute command 
   hammer subscription refresh-manifest --organization=<org name>
2.
3.

Actual results:
Error: Runtime Error could not execute statement at com.mysql.jdbc.SQLError.createSQLException:1,078

Expected results:
Subscription refreshed.

Additional info:
Comment 6 Barnaby Court 2017-07-11 14:47:41 EDT
This error was caused because 2 concurrent calls were made to the hosted CP export endpoint. The first completed successfully and the 2nd failed due to a lock-wait while the first was executing. Katello should not be allowing 2 exports from hosted for a single organization at a time.
Comment 10 Justin Sherrill 2017-07-14 12:42:01 EDT
Created redmine issue http://projects.theforeman.org/issues/20308 from this bug
Comment 11 Justin Sherrill 2017-07-14 13:32 EDT
Created attachment 1298556 [details]
Patch
Comment 15 pm-sat@redhat.com 2017-07-28 14:16:01 EDT
Moving this bug to POST for triage into Satellite 6 since the upstream issue http://projects.theforeman.org/issues/20308 has been resolved.
Comment 16 pm-sat@redhat.com 2017-08-03 18:19:07 EDT
Moving this bug to POST for triage into Satellite 6 since the upstream issue http://projects.theforeman.org/issues/20308 has been resolved.

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