@Thomas Mueller I'm facing the same error with 1.4.199. The db is corrupted and the Recover tool is not capable to solve the problem. I would really appreciate a fix because the DB is a result of long lasting analysis process. Could you please help me telling me what could be the best approach to avoid this condition? Thank you!
Il giorno mercoledì 17 ottobre 2018 19:36:36 UTC+2, Ayush Mathur ha scritto: > > Hi, > > Is there any update on this issue, we are facing same problem with H2 > version 1.4.196 ? It looks like some CTE NPE issues were resolved in > 1.4.197: https://github.com/h2database/h2database/issues/645 > > > On Thursday, January 4, 2018 at 10:18:58 AM UTC+2, gana joe wrote: >> >> in h2-1.4.196.jar ，I also got this problem . >> >> >> 2018-01-02 23:04:51 053 ->[RxCachedThreadScheduler-1]--[INFO >> ]--[Bus]--KnxRouter 上线,未曾上线设备 >> 2018-01-02 23:04:51 053 ->[RxCachedThreadScheduler-1]--[INFO >> ]--[Bus]--开始上线KNX设备 >> 2018-01-02 23:04:51 100 ->[RxCachedThreadScheduler-1]--[INFO >> ]--[Bus]--上线设备,physicalAddress = 5/1/1 ,mac = KX/5/1/1 ,channel = 1, type >> =COMMON LIGHT >> 2018-01-02 23:04:51 116 >> ->[RxCachedThreadScheduler-1]--[ERROR]--[Bus]--cusume event error >> java.lang.IllegalStateException: Could not build lazy iterator for class >> com.moorgen.knx.bridge.knx.data.KnxDataPoint >> at >> com.j256.ormlite.dao.LazyForeignCollection.closeableIterator(LazyForeignCollection.java:72) >> ~[KnxMoorgenBridge.jar:?] >> at >> com.j256.ormlite.dao.LazyForeignCollection.iterator(LazyForeignCollection.java:54) >> ~[KnxMoorgenBridge.jar:?] >> at >> com.j256.ormlite.dao.LazyForeignCollection.toArray(LazyForeignCollection.java:213) >> ~[KnxMoorgenBridge.jar:?] >> at java.util.ArrayList.<init>(Unknown Source) ~[?:1.8.0_144] >> at >> com.moorgen.knx.bridge.knx.data.KnxDevice.getDatapoints(KnxDevice.java:120) >> ~[KnxMoorgenBridge.jar:?] >> at com.moorgen.knx.bridge.bus.Bus.onlineKnxDevices(Bus.java:154) >> ~[KnxMoorgenBridge.jar:?] >> at >> com.moorgen.knx.bridge.bus.Bus.lambda$startMessageEventLoop$0(Bus.java:108) >> ~[KnxMoorgenBridge.jar:?] >> at >> io.reactivex.internal.subscribers.LambdaSubscriber.onNext(LambdaSubscriber.java:61) >> [KnxMoorgenBridge.jar:?] >> at >> io.reactivex.internal.operators.flowable.FlowableObserveOn$ObserveOnSubscriber.runAsync(FlowableObserveOn.java:399) >> [KnxMoorgenBridge.jar:?] >> at >> io.reactivex.internal.operators.flowable.FlowableObserveOn$BaseObserveOnSubscriber.run(FlowableObserveOn.java:175) >> [KnxMoorgenBridge.jar:?] >> at >> io.reactivex.internal.schedulers.ScheduledRunnable.run(ScheduledRunnable.java:59) >> [KnxMoorgenBridge.jar:?] >> at >> io.reactivex.internal.schedulers.ScheduledRunnable.call(ScheduledRunnable.java:51) >> [KnxMoorgenBridge.jar:?] >> at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.8.0_144] >> at >> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown >> Source) [?:1.8.0_144] >> at >> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown >> Source) [?:1.8.0_144] >> at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) >> [?:1.8.0_144] >> at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) >> [?:1.8.0_144] >> at java.lang.Thread.run(Unknown Source) [?:1.8.0_144] >> Caused by: java.sql.SQLException: Could not build prepared-query iterator >> for class com.moorgen.knx.bridge.knx.data.KnxDataPoint >> at >> com.j256.ormlite.misc.SqlExceptionUtil.create(SqlExceptionUtil.java:25) >> ~[KnxMoorgenBridge.jar:?] >> at >> com.j256.ormlite.dao.BaseDaoImpl.createIterator(BaseDaoImpl.java:1102) >> ~[KnxMoorgenBridge.jar:?] >> at com.j256.ormlite.dao.BaseDaoImpl.iterator(BaseDaoImpl.java:608) >> ~[KnxMoorgenBridge.jar:?] >> at >> com.j256.ormlite.dao.LazyForeignCollection.seperateIteratorThrow(LazyForeignCollection.java:309) >> ~[KnxMoorgenBridge.jar:?] >> at >> com.j256.ormlite.dao.LazyForeignCollection.iteratorThrow(LazyForeignCollection.java:83) >> ~[KnxMoorgenBridge.jar:?] >> at >> com.j256.ormlite.dao.LazyForeignCollection.closeableIterator(LazyForeignCollection.java:70) >> ~[KnxMoorgenBridge.jar:?] >> ... 17 more >> Caused by: org.h2.jdbc.JdbcSQLException: General error: >> "java.lang.IllegalStateException: Reading from >> nio:D:/KnxMoorgenBridge/KnxMoorgenBridge/2017_12_07/bin/devices.mv.db >> failed; file length 520192 read length 256 at 528630 [1.4.196/1]"; SQL >> statement: >> SELECT * FROM `knx_datapoints` WHERE `device_no` = ? [50000-196] >> at org.h2.engine.SessionRemote.done(SessionRemote.java:629) >> ~[KnxMoorgenBridge.jar:?] >> at org.h2.command.CommandRemote.executeQuery(CommandRemote.java:176) >> ~[KnxMoorgenBridge.jar:?] >> at >> org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:111) >> ~[KnxMoorgenBridge.jar:?] >> at >> com.j256.ormlite.jdbc.JdbcCompiledStatement.runQuery(JdbcCompiledStatement.java:63) >> ~[KnxMoorgenBridge.jar:?] >> at com.j256.ormlite.stmt.SelectIterator.<init>(SelectIterator.java:57) >> ~[KnxMoorgenBridge.jar:?] >> at >> com.j256.ormlite.stmt.StatementExecutor.buildIterator(StatementExecutor.java:247) >> ~[KnxMoorgenBridge.jar:?] >> at >> com.j256.ormlite.dao.BaseDaoImpl.createIterator(BaseDaoImpl.java:1098) >> ~[KnxMoorgenBridge.jar:?] >> at com.j256.ormlite.dao.BaseDaoImpl.iterator(BaseDaoImpl.java:608) >> ~[KnxMoorgenBridge.jar:?] >> at >> com.j256.ormlite.dao.LazyForeignCollection.seperateIteratorThrow(LazyForeignCollection.java:309) >> ~[KnxMoorgenBridge.jar:?] >> at >> com.j256.ormlite.dao.LazyForeignCollection.iteratorThrow(LazyForeignCollection.java:83) >> ~[KnxMoorgenBridge.jar:?] >> at >> com.j256.ormlite.dao.LazyForeignCollection.closeableIterator(LazyForeignCollection.java:70) >> ~[KnxMoorgenBridge.jar:?] >> >> -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/069ce203-eb75-407c-a174-8a313ec5a278%40googlegroups.com.
