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

Popular posts from this blog

ios - RestKit 0.20 — CoreData: error: Failed to call designated initializer on NSManagedObject class (again) -

java - Digest auth with Spring Security using javaconfig -

laravel - PDOException in Connector.php line 55: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: YES) -