[daisy] Error: Table JBPM_JOB does not exist

[Parisi, Lou]

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