[Unity-idm-discuss] PersistenceException on startup

[Shiraz M. <a....@fz...>]

Hi,

I am running v1.9.3. Whenever I (re)start the server, following error appears in the startup log file. However I am able to access the Web UI.


Sep 16, 2016 12:01:20 PM CEST: Starting UNITY Web Server
Sep 16, 2016 12:02:01 PM CEST: UNITY Server Started
Exception in thread "Thread-3" org.apache.ibatis.exceptions.PersistenceException:
### Error querying database.  Cause: org.h2.jdbc.JdbcSQLException: Table "EVENTS_QUEUE" not found; SQL statement:
SELECT * FROM EVENTS_QUEUE WHERE NEXT_PROCESSING < ? [42102-191]
### The error may exist in pl/edu/icm/unity/db/mapper-local/Events.xml
### The error may involve pl.edu.icm.unity.db.mapper.local.EventsMapper.selectEventsForProcessing
### The error occurred while executing a query
### SQL: SELECT * FROM EVENTS_QUEUE WHERE NEXT_PROCESSING < ?
### Cause: org.h2.jdbc.JdbcSQLException: Table "EVENTS_QUEUE" not found; SQL statement:
SELECT * FROM EVENTS_QUEUE WHERE NEXT_PROCESSING < ? [42102-191]
       at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
       at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:122)
       at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:113)
       at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:122)
       at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:64)
       at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:53)
       at com.sun.proxy.$Proxy97.selectEventsForProcessing(Unknown Source)
       at pl.edu.icm.unity.db.DBEvents.getEventsForProcessing(DBEvents.java:96)
       at pl.edu.icm.unity.engine.events.EventsProcessingThread.run(EventsProcessingThread.java:48)
Caused by: org.h2.jdbc.JdbcSQLException: Table "EVENTS_QUEUE" not found; SQL statement:
SELECT * FROM EVENTS_QUEUE WHERE NEXT_PROCESSING < ? [42102-191]
       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.command.Parser.readTableOrView(Parser.java:5349)
       at org.h2.command.Parser.readTableFilter(Parser.java:1245)
       at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1884)
       at org.h2.command.Parser.parseSelectSimple(Parser.java:2032)
       at org.h2.command.Parser.parseSelectSub(Parser.java:1878)
       at org.h2.command.Parser.parseSelectUnion(Parser.java:1699)
       at org.h2.command.Parser.parseSelect(Parser.java:1687)
       at org.h2.command.Parser.parsePrepared(Parser.java:443)
       at org.h2.command.Parser.parse(Parser.java:315)
       at org.h2.command.Parser.parse(Parser.java:287)
       at org.h2.command.Parser.prepareCommand(Parser.java:252)
       at org.h2.engine.Session.prepareLocal(Session.java:560)
       at org.h2.engine.Session.prepareCommand(Session.java:501)
       at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1188)
       at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:73)
       at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:276)
       at sun.reflect.GeneratedMethodAccessor22.invoke(Unknown Source)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
       at java.lang.reflect.Method.invoke(Method.java:498)
       at org.apache.ibatis.datasource.pooled.PooledConnection.invoke(PooledConnection.java:245)
       at com.sun.proxy.$Proxy28.prepareStatement(Unknown Source)
       at org.apache.ibatis.executor.statement.PreparedStatementHandler.instantiateStatement(PreparedStatementHandler.java:79)
       at org.apache.ibatis.executor.statement.BaseStatementHandler.prepare(BaseStatementHandler.java:88)
       at org.apache.ibatis.executor.statement.RoutingStatementHandler.prepare(RoutingStatementHandler.java:58)
       at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:76)
       at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:61)
       at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:303)
       at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:154)
       at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:102)
       at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:82)
       at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:120

Should I ignore this error?

Cheers,
Shiraz
--
Shiraz Memon
Federated Systems and Data
Jülich Supercomputing Centre (JSC)

Phone: +49 2461 61 6899
Fax:     +49 2461 61 6656


------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------
Forschungszentrum Juelich GmbH
52425 Juelich
Sitz der Gesellschaft: Juelich
Eingetragen im Handelsregister des Amtsgerichts Dueren Nr. HR B 3498
Vorsitzender des Aufsichtsrats: MinDir Dr. Karl Eugen Huthmacher
Geschaeftsfuehrung: Prof. Dr.-Ing. Wolfgang Marquardt (Vorsitzender),
Karsten Beneke (stellv. Vorsitzender), Prof. Dr.-Ing. Harald Bolt,
Prof. Dr. Sebastian M. Schmidt
------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------