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