[daisy] Error: Table JBPM_JOB does not exist
Lou Parisi
Lou.Parisi at photomask.com
Thu Mar 13 15:44:15 CET 2008
Does anyone have any information about this error? The daisy repository is
still failing and to the point where it is not reliable enough to use. The
repository service log shows the JVM was hung (attached below) and there was
a corresponding mysql error caused by an exception in ExpiredLockJanitor
(attached below). Please, any help appreciated.
The log entry for the ExpiredLockJanitor error:
-------------------------------------------
[ERROR ] <2008-03-13 04:33:47,346>
(org.outerj.daisy.repository.serverimpl.LocalRepositoryManager): Exception
occured in ExpiredLockJanitor.
com.mysql.jdbc.CommunicationsException: Communications link failure due to
underlying exception:
** BEGIN NESTED EXCEPTION **
java.io.EOFException
STACKTRACE:
java.io.EOFException
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1905)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2351)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2862)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:771)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3649)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1176)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2558)
at com.mysql.jdbc.Connection.<init>(Connection.java:1485)
at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at
org.outerj.daisy.jdbcutil.DriverLoader$DriverShim.connect(DriverLoader.java:77)
at
org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37)
at
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:771)
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95)
at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:544)
at
org.outerj.daisy.datasource.JdbcDataSource.getConnection(JdbcDataSource.java:130)
at sun.reflect.GeneratedMethodAccessor11.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
org.outerj.daisy.runtime.component.ComponentInvocationHandler.invoke(ComponentInvocationHandler.java:53)
at $Proxy4.getConnection(Unknown Source)
at
org.outerj.daisy.repository.serverimpl.LocalRepositoryManager$ExpiredLockJanitor.run(LocalRepositoryManager.java:351)
at java.lang.Thread.run(Thread.java:595)
** END NESTED EXCEPTION **
Last packet sent to the server was 23395 ms ago.
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2563)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2862)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:771)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3649)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1176)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2558)
at com.mysql.jdbc.Connection.<init>(Connection.java:1485)
at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at
org.outerj.daisy.jdbcutil.DriverLoader$DriverShim.connect(DriverLoader.java:77)
at
org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37)
at
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:771)
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95)
at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:544)
at
org.outerj.daisy.datasource.JdbcDataSource.getConnection(JdbcDataSource.java:130)
at sun.reflect.GeneratedMethodAccessor11.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
org.outerj.daisy.runtime.component.ComponentInvocationHandler.invoke(ComponentInvocationHandler.java:53)
at $Proxy4.getConnection(Unknown Source)
at
org.outerj.daisy.repository.serverimpl.LocalRepositoryManager$ExpiredLockJanitor.run(LocalRepositoryManager.java:351)
at java.lang.Thread.run(Thread.java:595)
[INFO ] <2008-03-13 13:53:16,977> (org.outerj.daisy.runtime.info):
Starting the Daisy repository server.
The log from the service container is here showing the JVM was hung:
-------------------------------------------------------------------
INFO | jvm 5 | 2008/03/12 20:11:50 | [WrapperSimpleAppMain] INFO
org.outerj.daisy.runtime.info - Runtime initialisation finished.
INFO | jvm 5 | 2008/03/12 20:11:50 | [WrapperSimpleAppMain] INFO
org.outerj.daisy.runtime.info - Daisy repository server started [March 12,
2008 8:11:50 PM GMT+00:00]
ERROR | wrapper | 2008/03/13 04:35:44 | JVM appears hung: Timed out
waiting for signal from JVM.
ERROR | wrapper | 2008/03/13 04:35:45 | JVM did not exit on request,
terminated
STATUS | wrapper | 2008/03/13 04:35:46 | JVM exited in response to signal
SIGKILL (9).
ERROR | wrapper | 2008/03/13 04:35:46 | Unable to start a JVM
STATUS | wrapper | 2008/03/13 04:35:47 | <-- Wrapper Stopped
STATUS | wrapper | 2008/03/13 13:53:13 | --> Wrapper Started as Daemon
STATUS | wrapper | 2008/03/13 13:53:13 | Launching a JVM...
INFO | jvm 1 | 2008/03/13 13:53:15 | Wrapper (Version 3.2.3)
http://wrapper.tanukisoftware.org
INFO | jvm 1 | 2008/03/13 13:53:15 | Copyright 1999-2006 Tanuki
Software, Inc. All Rights Reserved.
INFO | jvm 1 | 2008/03/13 13:53:15 |
INFO | jvm 1 | 2008/03/13 13:53:17 | [WrapperSimpleAppMain] INFO
org.outerj.daisy.runtime.info - Starting the Daisy repository server.
Lou Parisi wrote:
>
> I am running daisy 2.1 on Linux with MySQL for about 3 months. I have
> had the repository stop from time to time without known cause. The only
> thing I see in the daisy.log is an error for the table JBPM_JOB does not
> exist but when I check in mysql I can see the table. I don't know if
> this is causing my problem but would like to get rid of this error. I
> also don't know if this error has been occurring since we started using
> daisy or if it is new.
>
> Any help would be appreciated.
>
> [ERROR ] <2008-03-10 20:19:35,130>
> (org.hibernate.util.JDBCExceptionReporter): Table
> 'daisyrepository.JBPM_JOB' doesn't exist
> [ERROR ] <2008-03-10 20:19:35,131> (org.jbpm.db.JobSession):
> org.hibernate.exception.SQLGrammarException: could not execute query
> [ERROR ] <2008-03-10 20:19:35,131>
> (org.jbpm.job.executor.JobExecutorThread): exception in job executor
> thread. waiting 960000 milliseconds
>
> The mysql output and complete error message is shown below.
> -----------------------------------------------------------
>
> mysql> describe jbpm_job;
> +-------------------+--------------+------+-----+---------+-------------
> ---+
> | Field | Type | Null | Key | Default | Extra
> |
> +-------------------+--------------+------+-----+---------+-------------
> ---+
> | ID_ | bigint(20) | | PRI | NULL |
> auto_increment |
> | CLASS_ | char(1) | | | |
> |
> | VERSION_ | int(11) | | | 0 |
> |
> | DUEDATE_ | datetime | YES | | NULL |
> |
> | PROCESSINSTANCE_ | bigint(20) | YES | MUL | NULL |
> |
> | TOKEN_ | bigint(20) | YES | MUL | NULL |
> |
> | TASKINSTANCE_ | bigint(20) | YES | MUL | NULL |
> |
> | ISSUSPENDED_ | tinyint(1) | YES | | NULL |
> |
> | ISEXCLUSIVE_ | tinyint(1) | YES | | NULL |
> |
> | LOCKOWNER_ | varchar(255) | YES | | NULL |
> |
> | LOCKTIME_ | datetime | YES | | NULL |
> |
> | EXCEPTION_ | text | YES | | NULL |
> |
> | RETRIES_ | int(11) | YES | | NULL |
> |
> | NAME_ | varchar(255) | YES | | NULL |
> |
> | REPEAT_ | varchar(255) | YES | | NULL |
> |
> | TRANSITIONNAME_ | varchar(255) | YES | | NULL |
> |
> | ACTION_ | bigint(20) | YES | MUL | NULL |
> |
> | GRAPHELEMENTTYPE_ | varchar(255) | YES | | NULL |
> |
> | GRAPHELEMENT_ | bigint(20) | YES | | NULL |
> |
> | NODE_ | bigint(20) | YES | MUL | NULL |
> |
> +-------------------+--------------+------+-----+---------+-------------
> ---+
> 20 rows in set (0.00 sec)
>
> mysql> select * from jbpm_job;
> Empty set (0.00 sec)
>
> Complete error message:
> -------------------------
> [WARN ] <2008-03-10 20:19:35,130>
> (org.hibernate.util.JDBCExceptionReporter): SQL Error: 1146, SQLState:
> 42S02
> [ERROR ] <2008-03-10 20:19:35,130>
> (org.hibernate.util.JDBCExceptionReporter): Table
> 'daisyrepository.JBPM_JOB' doesn't exist
> [ERROR ] <2008-03-10 20:19:35,131> (org.jbpm.db.JobSession):
> org.hibernate.exception.SQLGrammarException: could not execute query
> [ERROR ] <2008-03-10 20:19:35,131>
> (org.jbpm.job.executor.JobExecutorThread): exception in job executor
> thread. waiting 960000 milliseconds
> org.jbpm.JbpmException: couldn't get acquirable jobs
> at
> org.jbpm.db.JobSession.getFirstAcquirableJob(JobSession.java:44)
> at
> org.jbpm.job.executor.JobExecutorThread.acquireJobs(JobExecutorThread.ja
> va:111)
> at
> org.jbpm.job.executor.JobExecutorThread.run(JobExecutorThread.java:56)
> at
> org.jbpm.job.executor.DaisyJobExecutorThread.run(DaisyJobExecutorThread.
> java:48)
> Caused by: org.hibernate.exception.SQLGrammarException: could not
> execute query
> at
> org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java
> :67)
> at
> org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.
> java:43)
> at org.hibernate.loader.Loader.doList(Loader.java:2214)
> at
> org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2095)
> at org.hibernate.loader.Loader.list(Loader.java:2090)
> at
> org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:388)
> at
> org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:
> 338)
> at
> org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:17
> 2)
> at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
> at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
> at
> org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java
> :804)
> at
> org.jbpm.db.JobSession.getFirstAcquirableJob(JobSession.java:40)
> ... 3 more
> Caused by: java.sql.SQLException: Table 'daisyrepository.JBPM_JOB'
> doesn't exist
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
> at com.mysql.jdbc.Connection.execSQL(Connection.java:2994)
> at
> com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:
> 936)
> at
> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:103
> 0)
> at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Delegat
> ingPreparedStatement.java:91)
> at
> org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186
> )
> at org.hibernate.loader.Loader.getResultSet(Loader.java:1778)
> at org.hibernate.loader.Loader.doQuery(Loader.java:662)
> at
> org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loade
> r.java:224)
> at org.hibernate.loader.Loader.doList(Loader.java:2211)
> ... 12 more
> _______________________________________________
> daisy community mailing list
> Professional Daisy support:
> http://outerthought.org/en/services/daisy/support.html
> mail to: daisy at lists.cocoondev.org
> list information: http://lists.cocoondev.org/mailman/listinfo/daisy
>
>
--
View this message in context: http://www.nabble.com/Error%3A-Table-JBPM_JOB-does-not-exist-tp15967006p16026322.html
Sent from the Daisy - General mailing list archive at Nabble.com.
More information about the daisy
mailing list