Hi,
Having some problems on Centos 7 with Katello 2.1 and foreman 1.7.2, I
will redeploy on Centos 6 but I was inspecting the logs and found
references to postgresql-9.0-801.jdbc4.
Any reason this version is used? It's about 4 years old and the server
packages are currently 9.2 on Centos 7. For postgresql 9.2 this jdbc
version is unsupported.
2015-02-15 21:48:35,023
[job=UnpauseJob-0951cd75-3250-4c00-beee-d33477e047f1, 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:1897)
[quartz-2.1.5.jar:na]
at
org.quartz.core.JobRunShell.notifyListenersBeginning(JobRunShell.java:345)
[quartz-2.1.5.jar:na]
at org.quartz.core.JobRunShell.run(JobRunShell.java:180)
[quartz-2.1.5.jar:na]
at
org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557)
[quartz-2.1.5.jar:na]
Caused by: org.hibernate.TransactionException: rollback failed
at
org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:215)
~[hibernate-core-4.2.5.Final.jar:4.2.5.Final]
at
org.hibernate.ejb.TransactionImpl.rollback(TransactionImpl.java:106)
~[hibernate-entitymanager-4.2.5.Final.jar:4.2.5.Final]
... 9 common frames omitted
Caused by: org.hibernate.TransactionException: unable to rollback
against JDBC connection
at
org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:167)
~[hibernate-core-4.2.5.Final.jar:4.2.5.Final]
at
org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:209)
~[hibernate-core-4.2.5.Final.jar:4.2.5.Final]
... 10 common frames omitted
Caused by: org.postgresql.util.PSQLException: This connection has
been closed.
at
org.postgresql.jdbc2.AbstractJdbc2Connection.checkClosed(AbstractJdbc2Connection.java:714)
~[*postgresql-9.0-801.jdbc4.jar*:na]
at
org.postgresql.jdbc2.AbstractJdbc2Connection.rollback(AbstractJdbc2Connection.java:731)
~[*postgresql-9.0-801.jdbc4*.jar:na]
at
com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProxyConnection.java:855)
~[c3p0-0.9.1.2.jar:0.9.1.2]
at
org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:163)
~[hibernate-core-4.2.5.Final.jar:4.2.5.Final]
... 11 common frames omitted
2015-02-15 21:48:35,028
[job=UnpauseJob-0951cd75-3250-4c00-beee-d33477e047f1, org=] ERROR
org.candlepin.pinsetter.tasks.UnpauseJob - Cannot execute query:
org.hibernate.exception.JDBCConnectionException: could not inspect
JDBC autocommit mode
at
org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:132)
~[hibernate-core-4.2.5.Final.jar:4.2.5.Final]
at
org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
~[hibernate-core-4.2.5.Final.jar:4.2.5.Final]
at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
~[hibernate-core-4.2.5.Final.jar:4.2.5.Final]
at
org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
~[hibernate-core-4.2.5.Final.jar:4.2.5.Final]
at
org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.isAutoCommit(LogicalConnectionImpl.java:311)
~[hibernate-core-4.2.5.Final.jar:4.2.5.Final]
at
org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl.afterNonTransactionalQuery(TransactionCoordinatorImpl.java:195)
~[hibernate-core-4.2.5.Final.jar:4.2.5.Final]
at
org.hibernate.internal.SessionImpl.afterOperation(SessionImpl.java:600)
~[hibernate-core-4.2.5.Final.jar:4.2.5.Final]
at
org.hibernate.internal.SessionImpl.list(SessionImpl.java:1670)
~[hibernate-core-4.2.5.Final.jar:4.2.5.Final]
at
org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:374)
~[hibernate-core-4.2.5.Final.jar:4.2.5.Final]
at
org.candlepin.model.JobCurator.findWaitingJobs(JobCurator.java:137)
~[JobCurator.class:na]
at
org.candlepin.pinsetter.tasks.UnpauseJob.toExecute(UnpauseJob.java:59)
~[UnpauseJob.class:na]
at
org.candlepin.pinsetter.tasks.KingpinJob.execute(KingpinJob.java:81)
[KingpinJob.class:na]
at
org.candlepin.pinsetter.core.GuiceJobFactory$JobScopeDecorator.execute(GuiceJobFactory.java:93)
[GuiceJobFactory$JobScopeDecorator.class:na]
at org.quartz.core.JobRunShell.run(JobRunShell.java:213)
[quartz-2.1.5.jar:na]
at
org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557)
[quartz-2.1.5.jar:na]
Caused by: org.postgresql.util.PSQLException: This connection has
been closed.
at
org.postgresql.jdbc2.AbstractJdbc2Connection.checkClosed(AbstractJdbc2Connection.java:714)
~[postgresql-9.0-801.jdbc4.jar:na]
at
org.postgresql.jdbc2.AbstractJdbc2Connection.getAutoCommit(AbstractJdbc2Connection.java:680)
~[postgresql-9.0-801.jdbc4.jar:na]
at
com.mchange.v2.c3p0.impl.NewProxyConnection.getAutoCommit(NewProxyConnection.java:985)
~[c3p0-0.9.1.2.jar:0.9.1.2]
at
org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.isAutoCommit(LogicalConnectionImpl.java:308)
~[hibernate-core-4.2.5.Final.jar:4.2.5.Final]
... 10 common frames omitted
Met vriendelijke groet, With kind regards,
Jorick Astrego
Netbulae Virtualization Experts
----------------
Tel: 053 20 30 270 info(a)netbulae.eu Staalsteden 4-3A KvK 08198180
Fax: 053 20 30 271 www.netbulae.eu 7547 TA Enschede BTW NL821234584B01
----------------
