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.
ERROR: relation "pxt_id_seq" does not exist
LINE 1: select pg_catalog.setval('pxt_id_seq', 8581, false);
Does this mean anything bad?
On Jul 26, 2013, at 10:40 AM, AJ Kertis wrote:
> 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 <[email protected]> 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
> [email protected]
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
_______________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list
