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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
