Bug 1469632
Summary: | Error when refreshing manifest - Runtime Error could not execute statement at com.mysql.jdbc.SQLError.createSQLException | ||||||
---|---|---|---|---|---|---|---|
Product: | Red Hat Satellite | Reporter: | Waldirio M Pinheiro <wpinheir> | ||||
Component: | Subscription Management | Assignee: | Justin Sherrill <jsherril> | ||||
Status: | CLOSED ERRATA | QA Contact: | Jitendra Yejare <jyejare> | ||||
Severity: | high | Docs Contact: | |||||
Priority: | unspecified | ||||||
Version: | 6.2.10 | CC: | abalakht, bbuckingham, bcourt, ehelms, jcallaha, jsherril, jyejare, mmccune, rbeyel | ||||
Target Milestone: | Unspecified | Keywords: | Triaged | ||||
Target Release: | Unused | ||||||
Hardware: | All | ||||||
OS: | All | ||||||
Whiteboard: | |||||||
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: | 2018-02-21 16:54:37 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
Waldirio M Pinheiro
2017-07-11 14:57:36 UTC
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. Created redmine issue http://projects.theforeman.org/issues/20308 from this bug Created attachment 1298556 [details]
Patch
Moving this bug to POST for triage into Satellite 6 since the upstream issue http://projects.theforeman.org/issues/20308 has been resolved. Moving this bug to POST for triage into Satellite 6 since the upstream issue http://projects.theforeman.org/issues/20308 has been resolved. Verified ! @Satellite 6.2.13 snap 2.0 @Satellite 6.3 snap 28 Observation: Sat 6.2: # hammer subscription refresh-manifest --organization='Default Organization' [.........................................................................................................................................................................................................] [100%] Sat 6.3: # hammer subscription refresh-manifest --organization='Default Organization' [..........................................................................................................................................................................................................] [100%] But in 6.3, I saw an error in /var/log/messages: Dec 11 08:49:33 localhost pulp: pulp.server.async.tasks:INFO: [f134de1f] Task failed : [f134de1f-c642-47ce-8aae-2adaaad555b1] Dec 11 08:49:33 localhost pulp: celery.worker.job:ERROR: (25721-57536) Task pulp.server.managers.repo.importer.update_importer_config[f134de1f-c642-47ce-8aae-2adaaad555b1] raised unexpected: OperationError(u"Could not save document (Cannot update 'config.depth' and 'config' at the same time)",) Dec 11 08:49:33 localhost pulp: celery.worker.job:ERROR: (25721-57536) Traceback (most recent call last): Dec 11 08:49:33 localhost pulp: celery.worker.job:ERROR: (25721-57536) File "/usr/lib/python2.7/site-packages/celery/app/trace.py", line 240, in trace_task Dec 11 08:49:33 localhost pulp: celery.worker.job:ERROR: (25721-57536) R = retval = fun(*args, **kwargs) Dec 11 08:49:33 localhost pulp: celery.worker.job:ERROR: (25721-57536) File "/usr/lib/python2.7/site-packages/pulp/server/async/tasks.py", line 527, in __call__ Dec 11 08:49:33 localhost pulp: celery.worker.job:ERROR: (25721-57536) return super(Task, self).__call__(*args, **kwargs) Dec 11 08:49:33 localhost pulp: celery.worker.job:ERROR: (25721-57536) File "/usr/lib/python2.7/site-packages/pulp/server/async/tasks.py", line 107, in __call__ Dec 11 08:49:33 localhost pulp: celery.worker.job:ERROR: (25721-57536) return super(PulpTask, self).__call__(*args, **kwargs) Dec 11 08:49:33 localhost pulp: celery.worker.job:ERROR: (25721-57536) File "/usr/lib/python2.7/site-packages/celery/app/trace.py", line 438, in __protected_call__ Dec 11 08:49:33 localhost pulp: celery.worker.job:ERROR: (25721-57536) return self.run(*args, **kwargs) Dec 11 08:49:33 localhost pulp: celery.worker.job:ERROR: (25721-57536) File "/usr/lib/python2.7/site-packages/pulp/server/controllers/importer.py", line 275, in update_importer_config Dec 11 08:49:33 localhost pulp: celery.worker.job:ERROR: (25721-57536) repo_importer.save() Dec 11 08:49:33 localhost pulp: celery.worker.job:ERROR: (25721-57536) File "/usr/lib/python2.7/site-packages/pulp/server/db/model/__init__.py", line 291, in save Dec 11 08:49:33 localhost pulp: celery.worker.job:ERROR: (25721-57536) super(Importer, self).save() Dec 11 08:49:33 localhost pulp: celery.worker.job:ERROR: (25721-57536) File "/usr/lib/python2.7/site-packages/mongoengine/document.py", line 398, in save Dec 11 08:49:33 localhost pulp: celery.worker.job:ERROR: (25721-57536) raise OperationError(message % unicode(err)) Dec 11 08:49:33 localhost pulp: celery.worker.job:ERROR: (25721-57536) OperationError: Could not save document (Cannot update 'config.depth' and 'config' at the same time) Dec 11 08:49:33 localhost pulp: celery.worker.job:INFO: Task pulp.server.async.tasks._release_resource[741676f9-28c8-4afd-8012-8d1fd0e2b30a] succeeded in 0.0119093290004s: None But this shouldnt block this bug from verifying as the error message in bug description is no more reproducible. Will raise new error for above error. Ok, So here is an update on what I said in last comment about the error : The error is repro on my setup only as its upgraded from sat 6.3 snap 27 to 28. So maybe something wrong with conf during the upgrade. Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA.
> >
> > For information on the advisory, and where to find the updated files, follow the link below.
> >
> > If the solution does not work for you, open a new bug report.
> >
> > https://access.redhat.com/errata/RHSA-2018:0336
|