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.
