<html>
  <head>

    <meta http-equiv="content-type" content="text/html; charset=utf-8">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    Hi,<br>
    <br>
    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.<br>
    <br>
    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.<br>
    <br>
    <br>
    <blockquote>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.<br>
      javax.persistence.PersistenceException: unexpected error when
      rollbacking<br>
          at
      org.hibernate.ejb.TransactionImpl.rollback(TransactionImpl.java:109)
      ~[hibernate-entitymanager-4.2.5.Final.jar:4.2.5.Final]<br>
          at
      com.google.inject.persist.jpa.JpaLocalTxnInterceptor.rollbackIfNecessary(JpaLocalTxnInterceptor.java:149)

      ~[guice-persist-3.0.jar:na]<br>
          at
      com.google.inject.persist.jpa.JpaLocalTxnInterceptor.invoke(JpaLocalTxnInterceptor.java:70)
      ~[guice-persist-3.0.jar:na]<br>
          at
      org.candlepin.pinsetter.core.PinsetterJobListener.updateJob(PinsetterJobListener.java:127)

      ~[PinsetterJobListener.class:na]<br>
          at
      org.candlepin.pinsetter.core.PinsetterJobListener.updateJob(PinsetterJobListener.java:122)

      ~[PinsetterJobListener.class:na]<br>
          at
      org.candlepin.pinsetter.core.PinsetterJobListener.jobToBeExecuted(PinsetterJobListener.java:72)

      ~[PinsetterJobListener.class:na]<br>
          at
      org.quartz.core.QuartzScheduler.notifyJobListenersToBeExecuted(QuartzScheduler.java:1897)
      [quartz-2.1.5.jar:na]<br>
          at
      org.quartz.core.JobRunShell.notifyListenersBeginning(JobRunShell.java:345)
      [quartz-2.1.5.jar:na]<br>
          at org.quartz.core.JobRunShell.run(JobRunShell.java:180)
      [quartz-2.1.5.jar:na]<br>
          at
      org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557)
      [quartz-2.1.5.jar:na]<br>
      Caused by: org.hibernate.TransactionException: rollback failed<br>
          at
      org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:215)

      ~[hibernate-core-4.2.5.Final.jar:4.2.5.Final]<br>
          at
      org.hibernate.ejb.TransactionImpl.rollback(TransactionImpl.java:106)
      ~[hibernate-entitymanager-4.2.5.Final.jar:4.2.5.Final]<br>
          ... 9 common frames omitted<br>
      Caused by: org.hibernate.TransactionException: unable to rollback
      against JDBC connection<br>
          at
      org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:167)

      ~[hibernate-core-4.2.5.Final.jar:4.2.5.Final]<br>
          at
      org.hibernate.engine.transaction.spi.AbstractTransactionImpl.rollback(AbstractTransactionImpl.java:209)

      ~[hibernate-core-4.2.5.Final.jar:4.2.5.Final]<br>
          ... 10 common frames omitted<br>
      Caused by: org.postgresql.util.PSQLException: This connection has
      been closed.<br>
          at
      org.postgresql.jdbc2.AbstractJdbc2Connection.checkClosed(AbstractJdbc2Connection.java:714)

      ~[<b>postgresql-9.0-801.jdbc4.jar</b>:na]<br>
          at
      org.postgresql.jdbc2.AbstractJdbc2Connection.rollback(AbstractJdbc2Connection.java:731)

      ~[<b>postgresql-9.0-801.jdbc4</b>.jar:na]<br>
          at
      com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProxyConnection.java:855)
      ~[c3p0-0.9.1.2.jar:0.9.1.2]<br>
          at
      org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doRollback(JdbcTransaction.java:163)

      ~[hibernate-core-4.2.5.Final.jar:4.2.5.Final]<br>
          ... 11 common frames omitted<br>
      2015-02-15 21:48:35,028
      [job=UnpauseJob-0951cd75-3250-4c00-beee-d33477e047f1, org=] ERROR
      org.candlepin.pinsetter.tasks.UnpauseJob - Cannot execute query: <br>
      org.hibernate.exception.JDBCConnectionException: could not inspect
      JDBC autocommit mode<br>
          at
      org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:132)

      ~[hibernate-core-4.2.5.Final.jar:4.2.5.Final]<br>
          at
      org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)

      ~[hibernate-core-4.2.5.Final.jar:4.2.5.Final]<br>
          at
      org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)

      ~[hibernate-core-4.2.5.Final.jar:4.2.5.Final]<br>
          at
      org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)

      ~[hibernate-core-4.2.5.Final.jar:4.2.5.Final]<br>
          at
      org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.isAutoCommit(LogicalConnectionImpl.java:311)

      ~[hibernate-core-4.2.5.Final.jar:4.2.5.Final]<br>
          at
      org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl.afterNonTransactionalQuery(TransactionCoordinatorImpl.java:195)


      ~[hibernate-core-4.2.5.Final.jar:4.2.5.Final]<br>
          at
      org.hibernate.internal.SessionImpl.afterOperation(SessionImpl.java:600)
      ~[hibernate-core-4.2.5.Final.jar:4.2.5.Final]<br>
          at
      org.hibernate.internal.SessionImpl.list(SessionImpl.java:1670)
      ~[hibernate-core-4.2.5.Final.jar:4.2.5.Final]<br>
          at
      org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:374)
      ~[hibernate-core-4.2.5.Final.jar:4.2.5.Final]<br>
          at
      org.candlepin.model.JobCurator.findWaitingJobs(JobCurator.java:137)
      ~[JobCurator.class:na]<br>
          at
      org.candlepin.pinsetter.tasks.UnpauseJob.toExecute(UnpauseJob.java:59)
      ~[UnpauseJob.class:na]<br>
          at
      org.candlepin.pinsetter.tasks.KingpinJob.execute(KingpinJob.java:81)
      [KingpinJob.class:na]<br>
          at
      org.candlepin.pinsetter.core.GuiceJobFactory$JobScopeDecorator.execute(GuiceJobFactory.java:93)

      [GuiceJobFactory$JobScopeDecorator.class:na]<br>
          at org.quartz.core.JobRunShell.run(JobRunShell.java:213)
      [quartz-2.1.5.jar:na]<br>
          at
      org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557)
      [quartz-2.1.5.jar:na]<br>
      Caused by: org.postgresql.util.PSQLException: This connection has
      been closed.<br>
          at
      org.postgresql.jdbc2.AbstractJdbc2Connection.checkClosed(AbstractJdbc2Connection.java:714)

      ~[postgresql-9.0-801.jdbc4.jar:na]<br>
          at
      org.postgresql.jdbc2.AbstractJdbc2Connection.getAutoCommit(AbstractJdbc2Connection.java:680)

      ~[postgresql-9.0-801.jdbc4.jar:na]<br>
          at
      com.mchange.v2.c3p0.impl.NewProxyConnection.getAutoCommit(NewProxyConnection.java:985)
      ~[c3p0-0.9.1.2.jar:0.9.1.2]<br>
          at
      org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.isAutoCommit(LogicalConnectionImpl.java:308)

      ~[hibernate-core-4.2.5.Final.jar:4.2.5.Final]<br>
          ... 10 common frames omitted</blockquote>
    <br>
  <BR />
<BR />
<b style="color:#604c78"></b><br><span style="color:#604c78;"><font color="000000"><span style="mso-fareast-language:en-gb;" lang="NL">Met vriendelijke groet, With kind regards,<br><br></span>Jorick Astrego</font></span><b style="color:#604c78"><br><br>Netbulae Virtualization Experts </b><br><hr style="border:none;border-top:1px solid #ccc;"><table style="width: 522px"><tbody><tr><td style="width: 130px;font-size: 10px">Tel:  053 20 30 270</td>    <td style="width: 130px;font-size: 10px">info@netbulae.eu</td>    <td style="width: 130px;font-size: 10px">Staalsteden 4-3A</td>    <td style="width: 130px;font-size: 10px">KvK 08198180</td></tr><tr>    <td style="width: 130px;font-size: 10px">Fax: 053 20 30 271</td>    <td style="width: 130px;font-size: 10px">www.netbulae.eu</td>    <td style="width: 130px;font-size: 10px">7547 TA Enschede</td>    <td style="width: 130px;font-size: 10px">BTW NL821234584B01</td></tr></tbody></table><br><hr style="border:none;border-top:1px solid #ccc;"><BR />
</body>
</html>