Bug 1342392
| Summary: | [upgrade] Exception in candlepin logs: javax.persistence.PersistenceException: unexpected error when rollbacking | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Product: | Red Hat Satellite | Reporter: | Sachin Ghai <sghai> | ||||||
| Component: | Content Management | Assignee: | Partha Aji <paji> | ||||||
| Status: | CLOSED ERRATA | QA Contact: | Sachin Ghai <sghai> | ||||||
| Severity: | high | Docs Contact: | |||||||
| Priority: | unspecified | ||||||||
| Version: | 6.2.0 | CC: | abalakht, bbuckingham, bcourt, ehelms, kdixon | ||||||
| Target Milestone: | Unspecified | Keywords: | Triaged | ||||||
| Target Release: | Unused | ||||||||
| Hardware: | Unspecified | ||||||||
| OS: | Unspecified | ||||||||
| Whiteboard: | |||||||||
| Fixed In Version: | katello-3.0.0-8 | 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: | |||||||||
| Bug Depends On: | |||||||||
| Bug Blocks: | 1335807 | ||||||||
| Attachments: |
|
||||||||
|
Description
Sachin Ghai
2016-06-03 07:33:50 UTC
Created attachment 1164360 [details]
Complete exception from candlepin logs
Created attachment 1164362 [details]
foreman-debug logs
Reproducible version: ----------------------- upgrade from sat6.1.9 -> sat6.2 GA snap14.1 on rhel7. Rpm version is 14.2 satellite-6.2.0-14.2.el7sat.noarch Hi Barnaby, can you take a look at the error Sachin observed in the Satellite 6.1.9 to 6.2 upgrade? Thanks! The most likely reason for this is that the DB went down while Candlepin was still running. Instead of blocking the error (as discussed in comment 1) the installer should make sure that Candlepin/tomcat has been stopped before stopping the database. Barnaby, thanks for the feedback. Looking at the code, this could indeed be the condition that we are hitting. While the installer does stop candlepin and then the database, it looks like the stopping of candlepin does not properly wait for shutdown prior to stopping postgresql. It looks like this is captured by http://projects.theforeman.org/issues/15146 and fixed upstream. Note for QE: reproducible with upgrade to sat6.2 with snap15.1 The reported issue is reproducible when performing upgrade from sat6.1.9 -> sat6.2 snap17 on rhel7 at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573) [quartz-2.2.1.jar:na] 2016-06-27 07:40:50,057 [thread=QuartzScheduler_Worker-6] [job=UnpauseJob-945b0203-be70-4b94-8437-6336b510bf7f, org=] ERROR org.candlepin.pinsetter.core.PinsetterJobListener - jobToBeExecuted encountered a problem. Usually means there was a problem storing the job status. Job will run. javax.persistence.PersistenceException: unexpected error when rollbacking at org.hibernate.ejb.TransactionImpl.rollback(TransactionImpl.java:109) ~[hibernate-entitymanager-4.2.5.Final.jar:4.2.5.Final] at com.google.inject.persist.jpa.JpaLocalTxnInterceptor.rollbackIfNecessary(JpaLocalTxnInterceptor.java:149) ~[guice-persist-3.0.jar:na] at com.google.inject.persist.jpa.JpaLocalTxnInterceptor.invoke(JpaLocalTxnInterceptor.java:70) ~[guice-persist-3.0.jar:na] at org.candlepin.pinsetter.core.PinsetterJobListener.updateJob(PinsetterJobListener.java:127) ~[PinsetterJobListener.class:na] at org.candlepin.pinsetter.core.PinsetterJobListener.updateJob(PinsetterJobListener.java:122) ~[PinsetterJobListener.class:na] at org.candlepin.pinsetter.core.PinsetterJobListener.jobToBeExecuted(PinsetterJobListener.java:72) ~[PinsetterJobListener.class:na] at org.quartz.core.QuartzScheduler.notifyJobListenersToBeExecuted(QuartzScheduler.java:1945) [quartz-2.2.1.jar:na] at org.quartz.core.JobRunShell.notifyListenersBeginning(JobRunShell.java:324) [quartz-2.2.1.jar:na] at org.quartz.core.JobRunShell.run(JobRunShell.java:173) [quartz-2.2.1.jar:na] at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573) [quartz-2.2.1.jar:na] Caused by: org.hibernate.TransactionException: rollback failed Upstream bug component is Content Management Sachin I am unable to reproduce this. Can you verify the occurrence of this error. Verified with sat6.2.z -> 6.3 snap29 upgrades. I don't see reported issue. Moreover, I tried a few different dbs and reported issue is not reproducible. Also, I tested same with 6.2 -> 6.2.13 snap2 upgrades. This issue is no longer reproducible. 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
|