<div dir="ltr">I think i fixed the problem. I just ended up just doing the oracle -> postgresql conversion again. It appears taskomatic is working now. </div><div class="gmail_extra"><br><br><div class="gmail_quote">On Fri, Jul 26, 2013 at 11:45 PM, AJ Kertis <span dir="ltr"><<a href="mailto:akertis@gmail.com" target="_blank">akertis@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word">I still have the oracle db and i tried to restore the oracle to the postgres db using the piping example on the wiki. I noticed I got this error at the beginning. <div>
<br></div><div><div>ERROR: relation "pxt_id_seq" does not exist</div><div>LINE 1: select pg_catalog.setval('pxt_id_seq', 8581, false);</div><div><br></div><div>Does this mean anything bad?</div><div><div class="h5">
<div><br></div><div><br></div><div><div>On Jul 26, 2013, at 10:40 AM, AJ Kertis wrote:</div><br><blockquote type="cite"><div dir="ltr">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. <div>
<br></div><div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | Jul 26, 2013 10:38:27 AM com.mchange.v2.c3p0.impl.NewPooledConnection handleThrowable</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | WARNING: [c3p0] A PooledConnection that has already signalled a Connection error is still in use!</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | Jul 26, 2013 10:38:27 AM com.mchange.v2.c3p0.impl.NewPooledConnection handleThrowable</div>
<div>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!</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | org.postgresql.util.PSQLException: An I/O error occured while sending to the backend.</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:214)</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258)</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:50)</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.hibernate.loader.Loader.doQuery(Loader.java:674)</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.hibernate.loader.Loader.doList(Loader.java:2220)</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.hibernate.loader.Loader.list(Loader.java:2099)</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811)</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:182)</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:158)</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at com.redhat.rhn.taskomatic.TaskoFactory.lookupScheduleById(TaskoFactory.java:334)</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at com.redhat.rhn.taskomatic.TaskoJob.execute(TaskoJob.java:103)</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.quartz.core.JobRunShell.run(JobRunShell.java:214)</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | Caused by: java.net.SocketException: Broken pipe</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at java.net.SocketOutputStream.socketWrite0(Native Method)</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:109)</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at java.net.SocketOutputStream.write(SocketOutputStream.java:153)</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82)</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at java.io.BufferedOutputStream.write(BufferedOutputStream.java:95)</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.postgresql.core.PGStream.SendChar(PGStream.java:169)</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.postgresql.core.v3.QueryExecutorImpl.sendParse(QueryExecutorImpl.java:756)</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.postgresql.core.v3.QueryExecutorImpl.sendOneQuery(QueryExecutorImpl.java:1034)</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.postgresql.core.v3.QueryExecutorImpl.sendQuery(QueryExecutorImpl.java:640)</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:186)</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>... 23 more</div><div>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</div>
<div>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.</div><div>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: </div>
<div>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</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:188)</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:158)</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at com.redhat.rhn.taskomatic.TaskoFactory.lookupScheduleById(TaskoFactory.java:334)</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at com.redhat.rhn.taskomatic.TaskoJob.execute(TaskoJob.java:103)</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.quartz.core.JobRunShell.run(JobRunShell.java:214)</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | Caused by: org.hibernate.exception.JDBCConnectionException: could not execute query</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:74)</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.hibernate.loader.Loader.doList(Loader.java:2223)</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.hibernate.loader.Loader.list(Loader.java:2099)</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811)</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:182)</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>... 5 more</div><div>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.</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:214)</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258)</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:50)</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.hibernate.loader.Loader.doQuery(Loader.java:674)</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.hibernate.loader.Loader.doList(Loader.java:2220)</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>... 14 more</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | Caused by: java.net.SocketException: Broken pipe</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at java.net.SocketOutputStream.socketWrite0(Native Method)</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:109)</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at java.net.SocketOutputStream.write(SocketOutputStream.java:153)</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82)</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at java.io.BufferedOutputStream.write(BufferedOutputStream.java:95)</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.postgresql.core.PGStream.SendChar(PGStream.java:169)</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.postgresql.core.v3.QueryExecutorImpl.sendParse(QueryExecutorImpl.java:756)</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.postgresql.core.v3.QueryExecutorImpl.sendOneQuery(QueryExecutorImpl.java:1034)</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.postgresql.core.v3.QueryExecutorImpl.sendQuery(QueryExecutorImpl.java:640)</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:186)</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>... 23 more</div>
<div>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.</div><div>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]</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.quartz.core.JobRunShell.run(JobRunShell.java:225)</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)</div>
<div>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</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:188)</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:158)</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at com.redhat.rhn.taskomatic.TaskoFactory.lookupScheduleById(TaskoFactory.java:334)</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at com.redhat.rhn.taskomatic.TaskoJob.execute(TaskoJob.java:103)</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.quartz.core.JobRunShell.run(JobRunShell.java:214)</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>... 1 more</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | Caused by: org.hibernate.exception.JDBCConnectionException: could not execute query</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:74)</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.hibernate.loader.Loader.doList(Loader.java:2223)</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.hibernate.loader.Loader.list(Loader.java:2099)</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811)</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at com.redhat.rhn.common.hibernate.HibernateFactory.lookupObjectByNamedQuery(HibernateFactory.java:182)</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>... 5 more</div><div>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.</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:214)</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258)</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:50)</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.hibernate.loader.Loader.doQuery(Loader.java:674)</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.hibernate.loader.Loader.doList(Loader.java:2220)</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>... 14 more</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | Caused by: java.net.SocketException: Broken pipe</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at java.net.SocketOutputStream.socketWrite0(Native Method)</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:109)</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at java.net.SocketOutputStream.write(SocketOutputStream.java:153)</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82)</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at java.io.BufferedOutputStream.write(BufferedOutputStream.java:95)</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.postgresql.core.PGStream.SendChar(PGStream.java:169)</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.postgresql.core.v3.QueryExecutorImpl.sendParse(QueryExecutorImpl.java:756)</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.postgresql.core.v3.QueryExecutorImpl.sendOneQuery(QueryExecutorImpl.java:1034)</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.postgresql.core.v3.QueryExecutorImpl.sendQuery(QueryExecutorImpl.java:640)</div>
<div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:186)</div><div>INFO | jvm 3 | 2013/07/26 10:38:27 | <span style="white-space:pre-wrap"> </span>... 23 more</div>
</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Fri, Jul 26, 2013 at 3:23 AM, Tomas Lestach <span dir="ltr"><<a href="mailto:tlestach@redhat.com" target="_blank">tlestach@redhat.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hello,<br>
<div><br>
> WARNING: nonstandard use of \\ in a string literal at character 1247<br>
> HINT: Use the escape string syntax for backslashes, e.g., E'\\'.<br>
<br>
</div>This is just a warning, nothing serious.<br>
<div><br>
> org.postgresql.util.PSQLException: ERROR: current transaction is<br>
> aborted, commands ignored until end of transaction block<br>
<br>
</div>If an error occurs during a PG transaction, e.g. an exception is thrown,<br>
PG expects the code to rollback the transaction. Until it is rollbacked<br>
no other transaction gets executed, but this error is displayed.<br>
<br>
You may want to restart your postgresql DB, so the transaction gets ended. After the restart taskomatic shall work again as expected.<br>
<br>
If you would find in your taskomatic log when the error occurred at the first time,<br>
or rather what error happened right before the first "current transaction is aborted"<br>
occurrence, it would help us to identify and fix the issue.<br>
<br>
<br>
Regards,<br>
--<br>
Tomas Lestach<br>
Red Hat Satellite Engineering, Red Hat<br>
<div><div><br>
_______________________________________________<br>
Spacewalk-list mailing list<br>
<a href="mailto:Spacewalk-list@redhat.com" target="_blank">Spacewalk-list@redhat.com</a><br>
<a href="https://www.redhat.com/mailman/listinfo/spacewalk-list" target="_blank">https://www.redhat.com/mailman/listinfo/spacewalk-list</a><br>
</div></div></blockquote></div><br></div>
</blockquote></div><br></div></div></div></div></blockquote></div><br></div>