I think i fixed the problem. I just ended up just doing the oracle -> postgresql conversion again. It appears taskomatic is working now.
On Fri, Jul 26, 2013 at 11:45 PM, AJ Kertis <[email protected]> wrote: > 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
