[daisy] Error: Table JBPM_JOB does not exist
Karel Vervaeke
karel at outerthought.org
Thu Mar 13 16:01:04 CET 2008
Are you running mysql on the same server as the repository?
Perhaps there might be something in the mysql logs.
Regards,
Karel
On Thu, 2008-03-13 at 07:44 -0700, Lou Parisi wrote:
> 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
> >
> >
>
More information about the daisy
mailing list