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@netbulae.eu Staalsteden 4-3A KvK 08198180
Fax: 053 20 30 271 www.netbulae.eu 7547 TA Enschede BTW NL821234584B01