java.lang.RuntimeException

org.h2.jdbc.JdbcSQLException: IO Exception: "java.io.IOException: Stream Closed"; "/root/nxt/nxt_test_db/nxt.h2.db"; SQL statement: SELECT * FROM account WHERE id = ?  AND latest = TRUE LIMIT 1 [90031-192]

Solutions on the web18638

  • via nxtforum.org by Unknown author, 10 months ago
    org.h2.jdbc.JdbcSQLException: IO Exception: "java.io.IOException: Stream Closed"; "/root/nxt/nxt_test_db/nxt.h2.db"; SQL statement: SELECT * FROM account WHERE id = ?  AND latest = TRUE LIMIT 1 [90031-192]
  • java.lang.RuntimeException: org.h2.jdbc.JdbcSQLException: IO Exception: "java.io.IOException: org.h2.jdbc.JdbcSQLException: IO Exception: ""Missing lob: 5"" [90028-157]"; "lob: null table: -1 id: 5" [90031-157]
  • via Google Groups by Chris, 1 year ago
    File ID mismatch got=0 expected=43 pos=910 true org.h2.store.DiskFile:Z:\users\ChrisK\db1\mddb.data.db blockCount: 0; SQL statement: select top 30 type,dir_time,location_id,partition from fs_dirs where location_id = 1 order by dir_time [50000-112]
  • Stack trace

    • java.lang.RuntimeException: org.h2.jdbc.JdbcSQLException: IO Exception: "java.io.IOException: Stream Closed"; "/root
    • xt
    • xt_test_db
    • xt.h2.db"; SQL statement: SELECT * FROM account WHERE id = ?  AND latest = TRUE LIMIT 1 [90031-192] at nxt.db.EntityDbTable.get(EntityDbTable.java:103) at nxt.db.EntityDbTable.get(EntityDbTable.java:87) at nxt.Account.getAccount(Account.java:817) at nxt.peer.PeerImpl.getWeight(PeerImpl.java:302) at nxt.peer.Peers.lambda$getPublicPeers$11(Peers.java:1043) at nxt.peer.Peers.getPeers(Peers.java:816) at nxt.peer.Peers.getPeers(Peers.java:810) at nxt.peer.Peers.getPublicPeers(Peers.java:1042) at nxt.BlockchainProcessorImpl$1.downloadPeer(BlockchainProcessorImpl.java:221) at nxt.BlockchainProcessorImpl$1.run(BlockchainProcessorImpl.java:190) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: org.h2.jdbc.JdbcSQLException: IO Exception: "java.io.IOException: Stream Closed"; "/root
    • xt
    • xt_test_db
    • xt.h2.db"; SQL statement: SELECT * FROM account WHERE id = ?  AND latest = TRUE LIMIT 1 [90031-192] at org.h2.message.DbException.getJdbcSQLException(DbException.java:345) at org.h2.message.DbException.get(DbException.java:168) at org.h2.message.DbException.convertIOException(DbException.java:330) at org.h2.store.FileStore.seek(FileStore.java:297) at org.h2.store.PageStore.readPage(PageStore.java:1324) at org.h2.store.PageStore.getPage(PageStore.java:749) at org.h2.index.PageBtreeIndex.getPage(PageBtreeIndex.java:149) at org.h2.index.PageBtreeIndex.find(PageBtreeIndex.java:182) at org.h2.index.PageBtreeIndex.find(PageBtreeIndex.java:174) at org.h2.index.BaseIndex.find(BaseIndex.java:128) at org.h2.index.MultiVersionIndex.find(MultiVersionIndex.java:78) at org.h2.index.IndexCursor.find(IndexCursor.java:169) at org.h2.table.TableFilter.next(TableFilter.java:466) at org.h2.command.dml.Select.queryFlat(Select.java:541) at org.h2.command.dml.Select.queryWithoutCache(Select.java:654) at org.h2.command.dml.Query.query(Query.java:341) at org.h2.command.dml.Query.query(Query.java:309) at org.h2.command.dml.Query.query(Query.java:36) at org.h2.command.CommandContainer.query(CommandContainer.java:110) at org.h2.command.Command.executeQuery(Command.java:201) at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:110) at nxt.db.FilteredPreparedStatement.executeQuery(FilteredPreparedStatement.java:59) at nxt.db.TransactionalDb$DbPreparedStatement.executeQuery(TransactionalDb.java:316) at nxt.db.EntityDbTable.get(EntityDbTable.java:163) at nxt.db.EntityDbTable.get(EntityDbTable.java:101) ... 16 more Caused by: java.io.IOException: Stream Closed at java.io.RandomAccessFile.seek0(Native Method) at java.io.RandomAccessFile.seek(RandomAccessFile.java:557) at org.h2.store.fs.FileDisk.position(FilePathDisk.java:477) at org.h2.store.FileStore.seek(FileStore.java:293) ... 37 more

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 1 year ago
    12 times, 8 months ago
    175 times, 10 months ago
    Unknown user
    Once, 10 months ago
    208 times, 11 months ago
    8 more bugmates