[candlepin] postgresql-9.0-801.jdbc4.jar?

Jorick Astrego j.astrego at netbulae.eu
Mon Feb 16 09:34:41 UTC 2015


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

----------------

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.fedorahosted.org/pipermail/candlepin/attachments/20150216/b0a587e7/attachment.html>


More information about the candlepin mailing list