Sign in to follow this  
feedbackers1

Getting Error Pinbot

Recommended Posts

heloo  sir ilya my pinbot get error this log message

#369 DAL error: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.h2.jdbc.JdbcSQLException: Referential integrity constraint violation: "FK_ACTIVITY_SCRAPEQUERY_ID: PUBLIC.ACTIVITY FOREIGN KEY(SCRAPEQUERY_ID) REFERENCES PUBLIC.SCRAPEQUERY(ID) (303)"; SQL statement:
DELETE FROM SCRAPEQUERY WHERE (ID = ?) [23503-193]
Error Code: 23503
Call: DELETE FROM SCRAPEQUERY WHERE (ID = ?)
    bind => [1 parameter bound]
Query: DeleteObjectQuery(AI.scraping.queries.ScrapeQuery@374c9a07)
---
exception stacktrace:
javax.persistence.RollbackException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.h2.jdbc.JdbcSQLException: Referential integrity constraint violation: "FK_ACTIVITY_SCRAPEQUERY_ID: PUBLIC.ACTIVITY FOREIGN KEY(SCRAPEQUERY_ID) REFERENCES PUBLIC.SCRAPEQUERY(ID) (303)"; SQL statement:
DELETE FROM SCRAPEQUERY WHERE (ID = ?) [23503-193]
Error Code: 23503
Call: DELETE FROM SCRAPEQUERY WHERE (ID = ?)
    bind => [1 parameter bound]
Query: DeleteObjectQuery(AI.scraping.queries.ScrapeQuery@374c9a07)
    at org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commit(EntityTransactionImpl.java:157)
    at DAL.Dal.deleteActivity(Dal.java:569)
    at domain.todo.QueueServices.remove(QueueServices.java:56)
    at Runnables.ProcessorRunnable.removeAndNotify(ProcessorRunnable.java:125)
    at Runnables.ProcessorRunnable.processSingle(ProcessorRunnable.java:98)
    at Runnables.ProcessorRunnable.processSafe(ProcessorRunnable.java:66)
    at Runnables.AutopilotRunnable.ScrapeAndProcess(AutopilotRunnable.java:101)
    at Runnables.AutopilotRunnable.__run(AutopilotRunnable.java:69)
    at Runnables.AbortRunnable.run(AbortRunnable.java:64)
    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.2.v20140319-9ad6abd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.h2.jdbc.JdbcSQLException: Referential integrity constraint violation: "FK_ACTIVITY_SCRAPEQUERY_ID: PUBLIC.ACTIVITY FOREIGN KEY(SCRAPEQUERY_ID) REFERENCES PUBLIC.SCRAPEQUERY(ID) (303)"; SQL statement:
DELETE FROM SCRAPEQUERY WHERE (ID = ?) [23503-193]
Error Code: 23503
Call: DELETE FROM SCRAPEQUERY WHERE (ID = ?)
    bind => [1 parameter bound]
Query: DeleteObjectQuery(AI.scraping.queries.ScrapeQuery@374c9a07)
    at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:331)
    at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:900)
    at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:962)
    at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:631)
    at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:558)
    at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2002)
    at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:298)
    at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:242)
    at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:228)
    at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.deleteObject(DatasourceCallQueryMechanism.java:210)
    at org.eclipse.persistence.internal.queries.StatementQueryMechanism.deleteObject(StatementQueryMechanism.java:104)
    at org.eclipse.persistence.queries.DeleteObjectQuery.executeDatabaseQuery(DeleteObjectQuery.java:218)
    at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:899)
    at org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:798)
    at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWorkObjectLevelModifyQuery(ObjectLevelModifyQuery.java:108)
    at org.eclipse.persistence.queries.DeleteObjectQuery.executeInUnitOfWorkObjectLevelModifyQuery(DeleteObjectQuery.java:119)
    at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWork(ObjectLevelModifyQuery.java:85)
    at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2896)
    at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1804)
    at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1786)
    at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1737)
    at org.eclipse.persistence.internal.sessions.CommitManager.deleteAllObjects(CommitManager.java:336)
    at org.eclipse.persistence.internal.sessions.CommitManager.deleteAllObjects(CommitManager.java:290)
    at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1444)
    at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithChangeSet(UnitOfWorkImpl.java:1531)
    at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitRootUnitOfWork(RepeatableWriteUnitOfWork.java:277)
    at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitAndResume(UnitOfWorkImpl.java:1169)
    at org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commit(EntityTransactionImpl.java:132)
    ... 13 more
Caused by: org.h2.jdbc.JdbcSQLException: Referential integrity constraint violation: "FK_ACTIVITY_SCRAPEQUERY_ID: PUBLIC.ACTIVITY FOREIGN KEY(SCRAPEQUERY_ID) REFERENCES PUBLIC.SCRAPEQUERY(ID) (303)"; SQL statement:
DELETE FROM SCRAPEQUERY WHERE (ID = ?) [23503-193]
    at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
    at org.h2.message.DbException.get(DbException.java:179)
    at org.h2.message.DbException.get(DbException.java:155)
    at org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:426)
    at org.h2.constraint.ConstraintReferential.checkRowRefTable(ConstraintReferential.java:443)
    at org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:318)
    at org.h2.table.Table.fireConstraints(Table.java:967)
    at org.h2.table.Table.fireAfterRow(Table.java:985)
    at org.h2.command.dml.Delete.update(Delete.java:101)
    at org.h2.command.CommandContainer.update(CommandContainer.java:98)
    at org.h2.command.Command.executeUpdate(Command.java:258)
    at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:160)
    at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:146)
    at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:890)
    ... 39 more
 

Share this post


Link to post
Share on other sites

That's a pretty ugly error.
I have no clue how that happened, but we can easily solve it.

The problem is that the database is partially corrupted.
It's advised to delete the "db" folder inside PinBotAI directory, and then when you launch PinBotAI, it will re-create a new database.

Warning: this will delete your account(s) and configurations.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this