[Spacewalk-list] Spacewalk and Taskomatic Problem
Paul Robert Marino
prmarino1 at gmail.com
Tue Jul 30 15:28:44 UTC 2013
This is a known backwards compatibility issue that can be fixed with a
flag on the PostgreSQL config.
the option you need to look at is backslash_quote
Also one more thing if you are running spacewalk on an EL based
variant and using PostgreSQL 9.x on your database server you need to
update the JDBC driver on the server running spacewalk to the
appropriate version.
for example
"
-rw-r--r--. 1 root root 545470 Jan 14 2013
/usr/share/java/postgresql91-jdbc-9.1.903.jar
lrwxrwxrwx. 1 root root 29 Jan 28 2013
/usr/share/java/postgresql91-jdbc.jar -> postgresql91-jdbc-9.1.903.jar
lrwxrwxrwx. 1 root root 37 Jan 28 19:35
/usr/share/java/postgresql-jdbc2ee.jar ->
/usr/share/java/postgresql91-jdbc.jar
lrwxrwxrwx. 1 root root 37 Jan 28 19:34
/usr/share/java/postgresql-jdbc2.jar ->
/usr/share/java/postgresql91-jdbc.jar
lrwxrwxrwx. 1 root root 37 Jan 28 19:35
/usr/share/java/postgresql-jdbc3.jar ->
/usr/share/java/postgresql91-jdbc.jar
-rw-r--r--. 1 root root 401775 May 20 2012
/usr/share/java/postgresql-jdbc-8.4.701.jar
lrwxrwxrwx. 1 root root 37 Jan 28 19:36
/usr/share/java/postgresql-jdbc.jar ->
/usr/share/java/postgresql91-jdbc.jar
"
On Thu, Jul 25, 2013 at 4:57 PM, AJ Kertis <akertis at gmail.com> wrote:
> I just keep seeing this over and over:
>
> WARNING: nonstandard use of \\ in a string literal at character 1247
> HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
> WARNING: nonstandard use of \\ in a string literal at character 99
> HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
> WARNING: nonstandard use of \\ in a string literal at character 1247
> HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
> WARNING: nonstandard use of \\ in a string literal at character 99
> HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
> WARNING: nonstandard use of \\ in a string literal at character 1247
> HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
>
>
>
>
> On Thu, Jul 25, 2013 at 3:46 PM, Paul Robert Marino <prmarino1 at gmail.com>
> wrote:
>>
>> It sounds like PostgreSQL is choking on the transactions for some reason.
>> Look at the logs for PostgreSQL depending on your configuration they are
>> usually located in /var/lib/pgsql/data/pg_log/ they are usually named by the
>> day of the week.
>>
>>
>>
>>
>> -- Sent from my HP Pre3
>>
>> ________________________________
>> On Jul 25, 2013 15:40, AJ Kertis <akertis at gmail.com> wrote:
>>
>> I'm using Spacewalk with Postgres and recently migrated from Oracle to
>> Postgres. I noticed recently since 6/6 the task schedules aren't running
>> correctly. I tried to run channel-repodata and get this error in the
>> taskomatic logs:
>>
>> INFO | jvm 1 | 2013/07/25 15:26:00 | Jul 25, 2013 3:26:00 PM
>> com.mchange.v2.c3p0.impl.NewPooledConnection handleThrowable
>> INFO | jvm 1 | 2013/07/25 15:26:00 | WARNING: [c3p0] A
>> PooledConnection that has already signalled a Connection error is still in
>> use!
>> INFO | jvm 1 | 2013/07/25 15:26:00 | Jul 25, 2013 3:26:00 PM
>> com.mchange.v2.c3p0.impl.NewPooledConnection handleThrowable
>> INFO | jvm 1 | 2013/07/25 15:26:00 | WARNING: [c3p0] Another error
>> has occurred [ org.postgresql.util.PSQLException: ERROR: current transaction
>> is aborted, commands ignored until end of transaction block ] which will not
>> be reported to listeners!
>> INFO | jvm 1 | 2013/07/25 15:26:00 |
>> org.postgresql.util.PSQLException: ERROR: current transaction is aborted,
>> commands ignored until end of transaction block
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:50)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.doQuery(Loader.java:674)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.doList(Loader.java:2220)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.list(Loader.java:2099)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:182)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:158)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.redhat.rhn.taskomatic.TaskoFactory.lookupScheduleById(TaskoFactory.java:334)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.redhat.rhn.taskomatic.TaskoJob.execute(TaskoJob.java:103)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.quartz.core.JobRunShell.run(JobRunShell.java:214)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | 2013-07-25 15:26:00,013
>> [DefaultQuartzScheduler_Worker-7] WARN
>> org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState: 25P02
>> INFO | jvm 1 | 2013/07/25 15:26:00 | 2013-07-25 15:26:00,013
>> [DefaultQuartzScheduler_Worker-7] ERROR
>> org.hibernate.util.JDBCExceptionReporter - ERROR: current transaction is
>> aborted, commands ignored until end of transaction block
>> INFO | jvm 1 | 2013/07/25 15:26:00 | 2013-07-25 15:26:00,013
>> [DefaultQuartzScheduler_Worker-7] ERROR org.quartz.core.JobRunShell - Job
>> DEFAULT.errata-queue-default threw an unhandled Exception:
>> INFO | jvm 1 | 2013/07/25 15:26:00 |
>> com.redhat.rhn.common.hibernate.HibernateRuntimeException: Executing query
>> TaskoSchedule.lookupById with params {schedule_id=2} failed
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:188)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:158)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.redhat.rhn.taskomatic.TaskoFactory.lookupScheduleById(TaskoFactory.java:334)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.redhat.rhn.taskomatic.TaskoJob.execute(TaskoJob.java:103)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.quartz.core.JobRunShell.run(JobRunShell.java:214)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | Caused by:
>> org.hibernate.exception.GenericJDBCException: could not execute query
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.doList(Loader.java:2223)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.list(Loader.java:2099)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:182)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | ... 5 more
>> INFO | jvm 1 | 2013/07/25 15:26:00 | Caused by:
>> org.postgresql.util.PSQLException: ERROR: current transaction is aborted,
>> commands ignored until end of transaction block
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:50)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.doQuery(Loader.java:674)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.doList(Loader.java:2220)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | ... 14 more
>> INFO | jvm 1 | 2013/07/25 15:26:00 | 2013-07-25 15:26:00,013
>> [DefaultQuartzScheduler_Worker-7] ERROR org.quartz.core.ErrorLogger - Job
>> (DEFAULT.errata-queue-default threw an exception.
>> INFO | jvm 1 | 2013/07/25 15:26:00 | org.quartz.SchedulerException:
>> Job threw an unhandled exception. [See nested exception:
>> com.redhat.rhn.common.hibernate.HibernateRuntimeException: Executing query
>> TaskoSchedule.lookupById with params {schedule_id=2} failed]
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.quartz.core.JobRunShell.run(JobRunShell.java:225)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | Caused by:
>> com.redhat.rhn.common.hibernate.HibernateRuntimeException: Executing query
>> TaskoSchedule.lookupById with params {schedule_id=2} failed
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:188)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:158)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.redhat.rhn.taskomatic.TaskoFactory.lookupScheduleById(TaskoFactory.java:334)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.redhat.rhn.taskomatic.TaskoJob.execute(TaskoJob.java:103)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.quartz.core.JobRunShell.run(JobRunShell.java:214)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | ... 1 more
>> INFO | jvm 1 | 2013/07/25 15:26:00 | Caused by:
>> org.hibernate.exception.GenericJDBCException: could not execute query
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.doList(Loader.java:2223)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.list(Loader.java:2099)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:182)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | ... 5 more
>> INFO | jvm 1 | 2013/07/25 15:26:00 | Caused by:
>> org.postgresql.util.PSQLException: ERROR: current transaction is aborted,
>> commands ignored until end of transaction block
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:50)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.doQuery(Loader.java:674)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.doList(Loader.java:2220)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | ... 14 more
>> INFO | jvm 1 | 2013/07/25 15:26:00 | Jul 25, 2013 3:26:00 PM
>> com.mchange.v2.c3p0.impl.NewPooledConnection handleThrowable
>> INFO | jvm 1 | 2013/07/25 15:26:00 | WARNING: [c3p0] A
>> PooledConnection that has already signalled a Connection error is still in
>> use!
>> INFO | jvm 1 | 2013/07/25 15:26:00 | Jul 25, 2013 3:26:00 PM
>> com.mchange.v2.c3p0.impl.NewPooledConnection handleThrowable
>> INFO | jvm 1 | 2013/07/25 15:26:00 | WARNING: [c3p0] Another error
>> has occurred [ org.postgresql.util.PSQLException: ERROR: current transaction
>> is aborted, commands ignored until end of transaction block ] which will not
>> be reported to listeners!
>> INFO | jvm 1 | 2013/07/25 15:26:00 |
>> org.postgresql.util.PSQLException: ERROR: current transaction is aborted,
>> commands ignored until end of transaction block
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:50)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.doQuery(Loader.java:674)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.doList(Loader.java:2220)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.list(Loader.java:2099)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:182)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:158)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.redhat.rhn.taskomatic.TaskoFactory.lookupScheduleById(TaskoFactory.java:334)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.redhat.rhn.taskomatic.TaskoJob.execute(TaskoJob.java:103)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.quartz.core.JobRunShell.run(JobRunShell.java:214)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | 2013-07-25 15:26:00,029
>> [DefaultQuartzScheduler_Worker-8] WARN
>> org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState: 25P02
>> INFO | jvm 1 | 2013/07/25 15:26:00 | 2013-07-25 15:26:00,029
>> [DefaultQuartzScheduler_Worker-8] ERROR
>> org.hibernate.util.JDBCExceptionReporter - ERROR: current transaction is
>> aborted, commands ignored until end of transaction block
>> INFO | jvm 1 | 2013/07/25 15:26:00 | 2013-07-25 15:26:00,029
>> [DefaultQuartzScheduler_Worker-8] ERROR org.quartz.core.JobRunShell - Job
>> DEFAULT.cobbler-sync-default threw an unhandled Exception:
>> INFO | jvm 1 | 2013/07/25 15:26:00 |
>> com.redhat.rhn.common.hibernate.HibernateRuntimeException: Executing query
>> TaskoSchedule.lookupById with params {schedule_id=3} failed
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:188)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:158)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.redhat.rhn.taskomatic.TaskoFactory.lookupScheduleById(TaskoFactory.java:334)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.redhat.rhn.taskomatic.TaskoJob.execute(TaskoJob.java:103)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.quartz.core.JobRunShell.run(JobRunShell.java:214)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | Caused by:
>> org.hibernate.exception.GenericJDBCException: could not execute query
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.doList(Loader.java:2223)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.list(Loader.java:2099)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:182)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | ... 5 more
>> INFO | jvm 1 | 2013/07/25 15:26:00 | Caused by:
>> org.postgresql.util.PSQLException: ERROR: current transaction is aborted,
>> commands ignored until end of transaction block
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:50)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.doQuery(Loader.java:674)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.doList(Loader.java:2220)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | ... 14 more
>> INFO | jvm 1 | 2013/07/25 15:26:00 | 2013-07-25 15:26:00,030
>> [DefaultQuartzScheduler_Worker-8] ERROR org.quartz.core.ErrorLogger - Job
>> (DEFAULT.cobbler-sync-default threw an exception.
>> INFO | jvm 1 | 2013/07/25 15:26:00 | org.quartz.SchedulerException:
>> Job threw an unhandled exception. [See nested exception:
>> com.redhat.rhn.common.hibernate.HibernateRuntimeException: Executing query
>> TaskoSchedule.lookupById with params {schedule_id=3} failed]
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.quartz.core.JobRunShell.run(JobRunShell.java:225)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | Caused by:
>> com.redhat.rhn.common.hibernate.HibernateRuntimeException: Executing query
>> TaskoSchedule.lookupById with params {schedule_id=3} failed
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:188)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:158)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.redhat.rhn.taskomatic.TaskoFactory.lookupScheduleById(TaskoFactory.java:334)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.redhat.rhn.taskomatic.TaskoJob.execute(TaskoJob.java:103)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.quartz.core.JobRunShell.run(JobRunShell.java:214)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | ... 1 more
>> INFO | jvm 1 | 2013/07/25 15:26:00 | Caused by:
>> org.hibernate.exception.GenericJDBCException: could not execute query
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.doList(Loader.java:2223)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.list(Loader.java:2099)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:182)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | ... 5 more
>> INFO | jvm 1 | 2013/07/25 15:26:00 | Caused by:
>> org.postgresql.util.PSQLException: ERROR: current transaction is aborted,
>> commands ignored until end of transaction block
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:50)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.doQuery(Loader.java:674)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.doList(Loader.java:2220)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | ... 14 more
>> INFO | jvm 1 | 2013/07/25 15:26:00 | Jul 25, 2013 3:26:00 PM
>> com.mchange.v2.c3p0.impl.NewPooledConnection handleThrowable
>> INFO | jvm 1 | 2013/07/25 15:26:00 | WARNING: [c3p0] A
>> PooledConnection that has already signalled a Connection error is still in
>> use!
>> INFO | jvm 1 | 2013/07/25 15:26:00 | Jul 25, 2013 3:26:00 PM
>> com.mchange.v2.c3p0.impl.NewPooledConnection handleThrowable
>> INFO | jvm 1 | 2013/07/25 15:26:00 | WARNING: [c3p0] Another error
>> has occurred [ org.postgresql.util.PSQLException: ERROR: current transaction
>> is aborted, commands ignored until end of transaction block ] which will not
>> be reported to listeners!
>> INFO | jvm 1 | 2013/07/25 15:26:00 |
>> org.postgresql.util.PSQLException: ERROR: current transaction is aborted,
>> commands ignored until end of transaction block
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:50)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.doQuery(Loader.java:674)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.doList(Loader.java:2220)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.list(Loader.java:2099)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:182)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:158)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.redhat.rhn.taskomatic.TaskoFactory.lookupScheduleById(TaskoFactory.java:334)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.redhat.rhn.taskomatic.TaskoJob.execute(TaskoJob.java:103)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.quartz.core.JobRunShell.run(JobRunShell.java:214)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | 2013-07-25 15:26:00,041
>> [DefaultQuartzScheduler_Worker-9] WARN
>> org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState: 25P02
>> INFO | jvm 1 | 2013/07/25 15:26:00 | 2013-07-25 15:26:00,041
>> [DefaultQuartzScheduler_Worker-9] ERROR
>> org.hibernate.util.JDBCExceptionReporter - ERROR: current transaction is
>> aborted, commands ignored until end of transaction block
>> INFO | jvm 1 | 2013/07/25 15:26:00 | 2013-07-25 15:26:00,041
>> [DefaultQuartzScheduler_Worker-9] ERROR org.quartz.core.JobRunShell - Job
>> DEFAULT.channel-repodata-default threw an unhandled Exception:
>> INFO | jvm 1 | 2013/07/25 15:26:00 |
>> com.redhat.rhn.common.hibernate.HibernateRuntimeException: Executing query
>> TaskoSchedule.lookupById with params {schedule_id=4} failed
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:188)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:158)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.redhat.rhn.taskomatic.TaskoFactory.lookupScheduleById(TaskoFactory.java:334)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.redhat.rhn.taskomatic.TaskoJob.execute(TaskoJob.java:103)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.quartz.core.JobRunShell.run(JobRunShell.java:214)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | Caused by:
>> org.hibernate.exception.GenericJDBCException: could not execute query
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.doList(Loader.java:2223)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.list(Loader.java:2099)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:182)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | ... 5 more
>> INFO | jvm 1 | 2013/07/25 15:26:00 | Caused by:
>> org.postgresql.util.PSQLException: ERROR: current transaction is aborted,
>> commands ignored until end of transaction block
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:50)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.doQuery(Loader.java:674)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.doList(Loader.java:2220)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | ... 14 more
>> INFO | jvm 1 | 2013/07/25 15:26:00 | 2013-07-25 15:26:00,041
>> [DefaultQuartzScheduler_Worker-9] ERROR org.quartz.core.ErrorLogger - Job
>> (DEFAULT.channel-repodata-default threw an exception.
>> INFO | jvm 1 | 2013/07/25 15:26:00 | org.quartz.SchedulerException:
>> Job threw an unhandled exception. [See nested exception:
>> com.redhat.rhn.common.hibernate.HibernateRuntimeException: Executing query
>> TaskoSchedule.lookupById with params {schedule_id=4} failed]
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.quartz.core.JobRunShell.run(JobRunShell.java:225)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | Caused by:
>> com.redhat.rhn.common.hibernate.HibernateRuntimeException: Executing query
>> TaskoSchedule.lookupById with params {schedule_id=4} failed
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:188)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:158)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.redhat.rhn.taskomatic.TaskoFactory.lookupScheduleById(TaskoFactory.java:334)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.redhat.rhn.taskomatic.TaskoJob.execute(TaskoJob.java:103)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.quartz.core.JobRunShell.run(JobRunShell.java:214)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | ... 1 more
>> INFO | jvm 1 | 2013/07/25 15:26:00 | Caused by:
>> org.hibernate.exception.GenericJDBCException: could not execute query
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.doList(Loader.java:2223)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.list(Loader.java:2099)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:182)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | ... 5 more
>> INFO | jvm 1 | 2013/07/25 15:26:00 | Caused by:
>> org.postgresql.util.PSQLException: ERROR: current transaction is aborted,
>> commands ignored until end of transaction block
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:50)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.doQuery(Loader.java:674)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.doList(Loader.java:2220)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | ... 14 more
>> INFO | jvm 1 | 2013/07/25 15:26:00 | Jul 25, 2013 3:26:00 PM
>> com.mchange.v2.c3p0.impl.NewPooledConnection handleThrowable
>> INFO | jvm 1 | 2013/07/25 15:26:00 | WARNING: [c3p0] A
>> PooledConnection that has already signalled a Connection error is still in
>> use!
>> INFO | jvm 1 | 2013/07/25 15:26:00 | Jul 25, 2013 3:26:00 PM
>> com.mchange.v2.c3p0.impl.NewPooledConnection handleThrowable
>> INFO | jvm 1 | 2013/07/25 15:26:00 | WARNING: [c3p0] Another error
>> has occurred [ org.postgresql.util.PSQLException: ERROR: current transaction
>> is aborted, commands ignored until end of transaction block ] which will not
>> be reported to listeners!
>> INFO | jvm 1 | 2013/07/25 15:26:00 |
>> org.postgresql.util.PSQLException: ERROR: current transaction is aborted,
>> commands ignored until end of transaction block
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:50)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.doQuery(Loader.java:674)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.doList(Loader.java:2220)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.list(Loader.java:2099)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:182)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:158)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.redhat.rhn.taskomatic.TaskoFactory.lookupScheduleById(TaskoFactory.java:334)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.redhat.rhn.taskomatic.TaskoJob.execute(TaskoJob.java:103)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.quartz.core.JobRunShell.run(JobRunShell.java:214)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | 2013-07-25 15:26:00,052
>> [DefaultQuartzScheduler_Worker-2] WARN
>> org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState: 25P02
>> INFO | jvm 1 | 2013/07/25 15:26:00 | 2013-07-25 15:26:00,052
>> [DefaultQuartzScheduler_Worker-2] ERROR
>> org.hibernate.util.JDBCExceptionReporter - ERROR: current transaction is
>> aborted, commands ignored until end of transaction block
>> INFO | jvm 1 | 2013/07/25 15:26:00 | 2013-07-25 15:26:00,052
>> [DefaultQuartzScheduler_Worker-2] ERROR org.quartz.core.JobRunShell - Job
>> DEFAULT.sync-probe-default threw an unhandled Exception:
>> INFO | jvm 1 | 2013/07/25 15:26:00 |
>> com.redhat.rhn.common.hibernate.HibernateRuntimeException: Executing query
>> TaskoSchedule.lookupById with params {schedule_id=1} failed
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:188)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:158)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.redhat.rhn.taskomatic.TaskoFactory.lookupScheduleById(TaskoFactory.java:334)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.redhat.rhn.taskomatic.TaskoJob.execute(TaskoJob.java:103)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.quartz.core.JobRunShell.run(JobRunShell.java:214)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | Caused by:
>> org.hibernate.exception.GenericJDBCException: could not execute query
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.doList(Loader.java:2223)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.list(Loader.java:2099)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:182)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | ... 5 more
>> INFO | jvm 1 | 2013/07/25 15:26:00 | Caused by:
>> org.postgresql.util.PSQLException: ERROR: current transaction is aborted,
>> commands ignored until end of transaction block
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:50)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.doQuery(Loader.java:674)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.doList(Loader.java:2220)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | ... 14 more
>> INFO | jvm 1 | 2013/07/25 15:26:00 | 2013-07-25 15:26:00,052
>> [DefaultQuartzScheduler_Worker-2] ERROR org.quartz.core.ErrorLogger - Job
>> (DEFAULT.sync-probe-default threw an exception.
>> INFO | jvm 1 | 2013/07/25 15:26:00 | org.quartz.SchedulerException:
>> Job threw an unhandled exception. [See nested exception:
>> com.redhat.rhn.common.hibernate.HibernateRuntimeException: Executing query
>> TaskoSchedule.lookupById with params {schedule_id=1} failed]
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.quartz.core.JobRunShell.run(JobRunShell.java:225)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | Caused by:
>> com.redhat.rhn.common.hibernate.HibernateRuntimeException: Executing query
>> TaskoSchedule.lookupById with params {schedule_id=1} failed
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:188)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:158)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.redhat.rhn.taskomatic.TaskoFactory.lookupScheduleById(TaskoFactory.java:334)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.redhat.rhn.taskomatic.TaskoJob.execute(TaskoJob.java:103)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.quartz.core.JobRunShell.run(JobRunShell.java:214)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | ... 1 more
>> INFO | jvm 1 | 2013/07/25 15:26:00 | Caused by:
>> org.hibernate.exception.GenericJDBCException: could not execute query
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.doList(Loader.java:2223)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.list(Loader.java:2099)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:182)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | ... 5 more
>> INFO | jvm 1 | 2013/07/25 15:26:00 | Caused by:
>> org.postgresql.util.PSQLException: ERROR: current transaction is aborted,
>> commands ignored until end of transaction block
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:50)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.doQuery(Loader.java:674)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | at
>> org.hibernate.loader.Loader.doList(Loader.java:2220)
>> INFO | jvm 1 | 2013/07/25 15:26:00 | ... 14 more
>>
>> _______________________________________________
>> Spacewalk-list mailing list
>> Spacewalk-list at redhat.com
>> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
>
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
More information about the Spacewalk-list
mailing list