[Spacewalk-list] Spacewalk and Taskomatic Problem
AJ Kertis
akertis at gmail.com
Fri Jul 26 14:40:13 UTC 2013
I have tried restarting postgres and rebooting the server. I ran a tail and
this all i see when i try to run the channel-repodata task in the
taskomatic log.
INFO | jvm 3 | 2013/07/26 10:38:27 | Jul 26, 2013 10:38:27 AM
com.mchange.v2.c3p0.impl.NewPooledConnection handleThrowable
INFO | jvm 3 | 2013/07/26 10:38:27 | WARNING: [c3p0] A
PooledConnection that has already signalled a Connection error is still in
use!
INFO | jvm 3 | 2013/07/26 10:38:27 | Jul 26, 2013 10:38:27 AM
com.mchange.v2.c3p0.impl.NewPooledConnection handleThrowable
INFO | jvm 3 | 2013/07/26 10:38:27 | WARNING: [c3p0] Another error has
occurred [ org.postgresql.util.PSQLException: An I/O error occured while
sending to the backend. ] which will not be reported to listeners!
INFO | jvm 3 | 2013/07/26 10:38:27 |
org.postgresql.util.PSQLException: An I/O error occured while sending to
the backend.
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:214)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:50)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.hibernate.loader.Loader.doQuery(Loader.java:674)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.hibernate.loader.Loader.doList(Loader.java:2220)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.hibernate.loader.Loader.list(Loader.java:2099)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:182)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:158)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
com.redhat.rhn.taskomatic.TaskoFactory.lookupScheduleById(TaskoFactory.java:334)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
com.redhat.rhn.taskomatic.TaskoJob.execute(TaskoJob.java:103)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.quartz.core.JobRunShell.run(JobRunShell.java:214)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)
INFO | jvm 3 | 2013/07/26 10:38:27 | Caused by:
java.net.SocketException: Broken pipe
INFO | jvm 3 | 2013/07/26 10:38:27 | at
java.net.SocketOutputStream.socketWrite0(Native Method)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:109)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
java.net.SocketOutputStream.write(SocketOutputStream.java:153)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
java.io.BufferedOutputStream.write(BufferedOutputStream.java:95)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.postgresql.core.PGStream.SendChar(PGStream.java:169)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.postgresql.core.v3.QueryExecutorImpl.sendParse(QueryExecutorImpl.java:756)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.postgresql.core.v3.QueryExecutorImpl.sendOneQuery(QueryExecutorImpl.java:1034)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.postgresql.core.v3.QueryExecutorImpl.sendQuery(QueryExecutorImpl.java:640)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:186)
INFO | jvm 3 | 2013/07/26 10:38:27 | ... 23 more
INFO | jvm 3 | 2013/07/26 10:38:27 | 2013-07-26 10:38:27,465
[DefaultQuartzScheduler_Worker-1] WARN
org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState: 08006
INFO | jvm 3 | 2013/07/26 10:38:27 | 2013-07-26 10:38:27,465
[DefaultQuartzScheduler_Worker-1] ERROR
org.hibernate.util.JDBCExceptionReporter - An I/O error occured while
sending to the backend.
INFO | jvm 3 | 2013/07/26 10:38:27 | 2013-07-26 10:38:27,465
[DefaultQuartzScheduler_Worker-1] ERROR org.quartz.core.JobRunShell - Job
DEFAULT.single-channel-repodata-bunch-15 threw an unhandled Exception:
INFO | jvm 3 | 2013/07/26 10:38:27 |
com.redhat.rhn.common.hibernate.HibernateRuntimeException: Executing query
TaskoSchedule.lookupById with params {schedule_id=357} failed
INFO | jvm 3 | 2013/07/26 10:38:27 | at
com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:188)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:158)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
com.redhat.rhn.taskomatic.TaskoFactory.lookupScheduleById(TaskoFactory.java:334)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
com.redhat.rhn.taskomatic.TaskoJob.execute(TaskoJob.java:103)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.quartz.core.JobRunShell.run(JobRunShell.java:214)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)
INFO | jvm 3 | 2013/07/26 10:38:27 | Caused by:
org.hibernate.exception.JDBCConnectionException: could not execute query
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:74)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.hibernate.loader.Loader.doList(Loader.java:2223)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.hibernate.loader.Loader.list(Loader.java:2099)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:182)
INFO | jvm 3 | 2013/07/26 10:38:27 | ... 5 more
INFO | jvm 3 | 2013/07/26 10:38:27 | Caused by:
org.postgresql.util.PSQLException: An I/O error occured while sending to
the backend.
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:214)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:50)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.hibernate.loader.Loader.doQuery(Loader.java:674)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.hibernate.loader.Loader.doList(Loader.java:2220)
INFO | jvm 3 | 2013/07/26 10:38:27 | ... 14 more
INFO | jvm 3 | 2013/07/26 10:38:27 | Caused by:
java.net.SocketException: Broken pipe
INFO | jvm 3 | 2013/07/26 10:38:27 | at
java.net.SocketOutputStream.socketWrite0(Native Method)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:109)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
java.net.SocketOutputStream.write(SocketOutputStream.java:153)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
java.io.BufferedOutputStream.write(BufferedOutputStream.java:95)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.postgresql.core.PGStream.SendChar(PGStream.java:169)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.postgresql.core.v3.QueryExecutorImpl.sendParse(QueryExecutorImpl.java:756)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.postgresql.core.v3.QueryExecutorImpl.sendOneQuery(QueryExecutorImpl.java:1034)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.postgresql.core.v3.QueryExecutorImpl.sendQuery(QueryExecutorImpl.java:640)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:186)
INFO | jvm 3 | 2013/07/26 10:38:27 | ... 23 more
INFO | jvm 3 | 2013/07/26 10:38:27 | 2013-07-26 10:38:27,465
[DefaultQuartzScheduler_Worker-1] ERROR org.quartz.core.ErrorLogger - Job
(DEFAULT.single-channel-repodata-bunch-15 threw an exception.
INFO | jvm 3 | 2013/07/26 10:38:27 | 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=357} failed]
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.quartz.core.JobRunShell.run(JobRunShell.java:225)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)
INFO | jvm 3 | 2013/07/26 10:38:27 | Caused by:
com.redhat.rhn.common.hibernate.HibernateRuntimeException: Executing query
TaskoSchedule.lookupById with params {schedule_id=357} failed
INFO | jvm 3 | 2013/07/26 10:38:27 | at
com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:188)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:158)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
com.redhat.rhn.taskomatic.TaskoFactory.lookupScheduleById(TaskoFactory.java:334)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
com.redhat.rhn.taskomatic.TaskoJob.execute(TaskoJob.java:103)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.quartz.core.JobRunShell.run(JobRunShell.java:214)
INFO | jvm 3 | 2013/07/26 10:38:27 | ... 1 more
INFO | jvm 3 | 2013/07/26 10:38:27 | Caused by:
org.hibernate.exception.JDBCConnectionException: could not execute query
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:74)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.hibernate.loader.Loader.doList(Loader.java:2223)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.hibernate.loader.Loader.list(Loader.java:2099)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:182)
INFO | jvm 3 | 2013/07/26 10:38:27 | ... 5 more
INFO | jvm 3 | 2013/07/26 10:38:27 | Caused by:
org.postgresql.util.PSQLException: An I/O error occured while sending to
the backend.
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:214)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:50)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.hibernate.loader.Loader.doQuery(Loader.java:674)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.hibernate.loader.Loader.doList(Loader.java:2220)
INFO | jvm 3 | 2013/07/26 10:38:27 | ... 14 more
INFO | jvm 3 | 2013/07/26 10:38:27 | Caused by:
java.net.SocketException: Broken pipe
INFO | jvm 3 | 2013/07/26 10:38:27 | at
java.net.SocketOutputStream.socketWrite0(Native Method)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:109)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
java.net.SocketOutputStream.write(SocketOutputStream.java:153)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
java.io.BufferedOutputStream.write(BufferedOutputStream.java:95)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.postgresql.core.PGStream.SendChar(PGStream.java:169)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.postgresql.core.v3.QueryExecutorImpl.sendParse(QueryExecutorImpl.java:756)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.postgresql.core.v3.QueryExecutorImpl.sendOneQuery(QueryExecutorImpl.java:1034)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.postgresql.core.v3.QueryExecutorImpl.sendQuery(QueryExecutorImpl.java:640)
INFO | jvm 3 | 2013/07/26 10:38:27 | at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:186)
INFO | jvm 3 | 2013/07/26 10:38:27 | ... 23 more
On Fri, Jul 26, 2013 at 3:23 AM, Tomas Lestach <tlestach at redhat.com> wrote:
> Hello,
>
> > WARNING: nonstandard use of \\ in a string literal at character 1247
> > HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
>
> This is just a warning, nothing serious.
>
> > org.postgresql.util.PSQLException: ERROR: current transaction is
> > aborted, commands ignored until end of transaction block
>
> If an error occurs during a PG transaction, e.g. an exception is thrown,
> PG expects the code to rollback the transaction. Until it is rollbacked
> no other transaction gets executed, but this error is displayed.
>
> You may want to restart your postgresql DB, so the transaction gets ended.
> After the restart taskomatic shall work again as expected.
>
> If you would find in your taskomatic log when the error occurred at the
> first time,
> or rather what error happened right before the first "current transaction
> is aborted"
> occurrence, it would help us to identify and fix the issue.
>
>
> Regards,
> --
> Tomas Lestach
> Red Hat Satellite Engineering, Red Hat
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20130726/b8ccf2e4/attachment.htm>
More information about the Spacewalk-list
mailing list