playframework - IOExceptions with H2 database -
recentently ioexceptions play app uses h2 database. this:
caused by: java.io.ioexception: block not found in id [1, -68, 2, 2] [1.4.187/50] @ org.h2.mvstore.streamstore$stream.read(streamstore.java:466) ~[com.h2database.h2-1.4.187.jar:1.4.187] @ sun.nio.cs.streamdecoder.readbytes(streamdecoder.java:284) ~[na:1.8.0_40] @ sun.nio.cs.streamdecoder.implread(streamdecoder.java:326) ~[na:1.8.0_40] @ sun.nio.cs.streamdecoder.read(streamdecoder.java:178) ~[na:1.8.0_40] @ java.io.inputstreamreader.read(inputstreamreader.java:184) ~[na:1.8.0_40] @ java.io.bufferedreader.fill(bufferedreader.java:161) ~[na:1.8.0_40] @ java.io.bufferedreader.read1(bufferedreader.java:212) ~[na:1.8.0_40] @ java.io.bufferedreader.read(bufferedreader.java:286) ~[na:1.8.0_40] @ org.hibernate.type.descriptor.java.datahelper.extractstring(datahelper.java:88) ~[org.hibernate.hibernate-core-4.3.11.final.jar:4.3.11.final]
it might issue talking in https://groups.google.com/forum/#!topic/h2-database/myx5rh6cv-8 or https://groups.google.com/forum/#!topic/h2-database/gv5nu2subzm. here writes '1.4.186, 1.4.187 , 1.4.188 vulnerable versions.'. in play version (2.4.3) h2 version 1.4.187 used.
it seems happen sporadically , far not find reason when happened.
i wonder why there not more find in internet issue. unstable database seems quite important. set version latest 1.4.191 , closely monitor it. have had similar experiences h2 , play?
to answer original question. yes, had experience when using build .187.
i had following exception:
org.h2.jdbc.jdbcsqlexception: io exception: "java.io.ioexception: block not found in id [1, -109, 3, 1] [1.4.187/50]"; "lob: null table: -3 id: 7" [90031-187]
... similar stacktrace yours.
once moved build .192 problem went away completely. problem listed fixed in version 1.4.189 beta (2015-09-13) based on change logs:
http://www.h2database.com/html/changelog.html
so, move .192 , close our fingers doesn't happen again !!!
Comments
Post a Comment