Recently i have been facing with many errors in which the temp blob database file cannot be read, and read error exception thrown. Below is stack trace of one of them:
org.h2.jdbc.JdbcSQLException: IO Exception: "java.io.IOException: Read error"; "<Application directory>/databasename.36690fa35b70dfb5.237919.temp.db" [90031-169] at org.h2.message.DbException.getJdbcSQLException(DbException.java:329) at org.h2.message.DbException.get(DbException.java:158) at org.h2.message.DbException.convertIOException(DbException.java:315) at org.h2.store.FileStore.readFully(FileStore.java:278) at org.h2.result.ResultDiskBuffer.readRow(ResultDiskBuffer.java:194) at org.h2.result.ResultDiskBuffer.nextSorted(ResultDiskBuffer.java:231) at org.h2.result.ResultDiskBuffer.next(ResultDiskBuffer.java:209) at org.h2.result.LocalResult.next(LocalResult.java:229) at org.h2.jdbc.JdbcResultSet.nextRow(JdbcResultSet.java:3002) at org.h2.jdbc.JdbcResultSet.next(JdbcResultSet.java:124)
In additional to my database, i don't explicitly specify any configuration except putting the LOCK_TIMEOUT=5000 to my connection URL, at the time my database file size is ~600MB, and my application runs on Windows OS.
What can be the possible cause for the above error?