org.h2.jdbc.JdbcSQLException: General error: "java.lang.IllegalStateException: Reading from cache:nio:/home/ubuntu/csdata/data.mv.db failed; file length -1 read length 512 at 13514067138 [1.4.192/1]"; SQL statement: select x2.x3, x2.x4, x2.x5, x2.x6, x2.x7, x2.x8, x2.x9, x2.x10 from (select x11.x12 as x9, x11.x13 as x6, x11.x14 as x5, x11.x15 as x4, x11.x16 as x8, x11.x17 as x10, x11.x18 as x3, x11.x19 as x7 from (select x20."ACTIVITY_DATE" as x12, x20."ACTIVITY_TYPE" as x13, x20."ACTIVITY_USER_NAME" as x14, x20."REPOSITORY_NAME" as x15, x20."ADDITIONAL_INFO" as x16, x20."ACTIVITY_ID" as x17, x20."USER_NAME" as x18, x20."MESSAGE" as x19 from "ACTIVITY" x20) x11 inner join (select x21."UPDATED_DATE" as x22, x21."ALLOW_WIKI_EDITING" as x23, x21."EXTERNAL_ISSUES_URL" as x24, x21."PARENT_REPOSITORY_NAME" as x25, x21."EXTERNAL_WIKI_URL" as x26, x21."DEFAULT_BRANCH" as x27, x21."DESCRIPTION" as x28, x21."ORIGIN_REPOSITORY_NAME" as x29, x21."ORIGIN_USER_NAME" as x30, x21."PARENT_USER_NAME" as x31, x21."PRIVATE" as x32, x21."REPOSITORY_NAME" as x33, x21."USER_NAME" as x34, x21."ENABLE_WIKI" as x35, x21."ENABLE_ISSUES" as x36, x21."REGISTERED_DATE" as x37, x21."LAST_ACTIVITY_DATE" as x38 from "REPOSITORY" x21) x39 on (x11.x18 = x39.x34) and (x11.x15 = x39.x33) where (x39.x32 = ?) or (x39.x34 in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) order by x11.x17 desc limit 30) x2 [50000-192]


Solutions on the web

Solution icon of github
General error: "java.lang.IllegalStateException: Reading from cache:nio:/home/ubuntu/csdata/data.mv.db failed; file length -1 read length 512 at 13514067138 [1.4.192/1]"; SQL statement: select x2.x3, x2.x4, x2.x5, x2.x6, x2.x7, x2.x8, x2.x9, x2.x10

Solution icon of github
General error: "java.lang.IllegalStateException: Unsynchronized metadata read [1.4.180/3]"; SQL statement: select x2.x3, x2.x4, x2.x5, x2.x6, x2.x7, x2.x8, x2.x9, x2.x10 from (select x11.x12 as x9, x11.x13 as x6, x11.x14 as x5, x11.x15 as x4, x11

Solution icon of github
via GitHub by dodgex
, 1 year ago
General error: "java.lang.ArrayIndexOutOfBoundsException: 2048"; SQL statement: select x2.x3, x2.x4, x2.x5, x2.x6, x2.x7, x2.x8, x2.x9, x2.x10 from (select x11.x12 as x9, x11.x13 as x6, x11.x14 as x5, x11.x15 as x4, x11.x16 as x8, x11.x17 as x10

Solution icon of github
General error: "java.lang.ArrayIndexOutOfBoundsException: 6"; SQL statement: select x2.x3, x2.x4, x2.x5, x2.x6, x2.x7, x2.x8, x2.x9, x2.x10 from (select x11.x12 as x9, x11.x13 as x6, x11.x14 as x5, x11.x15 as x4, x11.x16 as x8, x11.x17 as x10, x11

Solution icon of github
via GitHub by st0rmchild
, 1 year ago
.EXTERNAL_WIKI_URL AS X26, X21.DEFAULT_BRANCH AS X27, X21.DESCRIPTION AS X28, X21.ORIGIN_REPOSITORY_NAME AS X29, X21.ORIGIN_USER_NAME AS X30, X21.PARENT_USER_NAME AS X31, X21.PRIVATE AS X32, X21.REPOSITORY_NAME AS X33, X21

Solution icon of github
.EXTERNAL_WIKI_URL AS X26, X21.DEFAULT_BRANCH AS X27, X21.DESCRIPTION AS X28, X21.ORIGIN_REPOSITORY_NAME AS X29, X21.ORIGIN_USER_NAME AS X30, X21.PARENT_USER_NAME AS X31, X21.PRIVATE AS X32, X21.REPOSITORY_NAME AS X33, X21

Solution icon of googlegroups
via Google Groups by Björn Herzig, 1 year ago
Column "X2.COL1" not found; SQL statement: CREATE FORCE VIEW PUBLIC._0 AS SELECT X2.COL1 AS X6, X2.COL4 AS X4, X2.COL5 AS X5 FROM SYSTEM_RANGE(1, 1) [42122-166]

Solution icon of web
Column "X2.COL1" not found; SQL statement: CREATE FORCE VIEW PUBLIC._0 AS SELECT      X2.COL1 AS X6,      X2.COL4 AS X4,      X2.COL5 AS X5 FROM SYSTEM_RANGE(1, 1) [42122-166]

Solution icon of github
Syntax error in SQL statement "SELECT X2.""a"", X2.""b"", X3.""a"", X3.""b"" FROM (SELECT X4.""a"" AS ""a"", X4.""b"" AS ""b"" FROM ""t2"" X4) X2 FULL OUTER[*] JOIN (SELECT X5.""a"" AS ""a"", X5.""b"" AS ""b"" FROM ""t2"" X5) X3 "; SQL statement

Solution icon of github
via GitHub by hbf
, 1 year ago
, FULL, INNER, JOIN, CROSS, NATURAL, ,, SELECT"; SQL statement: select x2.x3 from (select x4."COF_NAME" as x3 from "SUPPLIERS" x5, "COFFEES" x4 where (x5."SUP_ID" < 100) and (x4."SUP_ID" = x5."SUP_ID") union select from "COFFEES" x6) x2 [42001-166]

Stack trace

org.h2.jdbc.JdbcSQLException: General error: "java.lang.IllegalStateException: Reading from cache:nio:/home/ubuntu/csdata/data.mv.db failed; file length -1 read length 512 at 13514067138 [1.4.192/1]"; SQL statement:
select x2.x3, x2.x4, x2.x5, x2.x6, x2.x7, x2.x8, x2.x9, x2.x10 from (select x11.x12 as x9, x11.x13 as x6, x11.x14 as x5, x11.x15 as x4, x11.x16 as x8, x11.x17 as x10, x11.x18 as x3, x11.x19 as x7 from (select x20."ACTIVITY_DATE" as x12, x20."ACTIVITY_TYPE" as x13, x20."ACTIVITY_USER_NAME" as x14, x20."REPOSITORY_NAME" as x15, x20."ADDITIONAL_INFO" as x16, x20."ACTIVITY_ID" as x17, x20."USER_NAME" as x18, x20."MESSAGE" as x19 from "ACTIVITY" x20) x11 inner join (select x21."UPDATED_DATE" as x22, x21."ALLOW_WIKI_EDITING" as x23, x21."EXTERNAL_ISSUES_URL" as x24, x21."PARENT_REPOSITORY_NAME" as x25, x21."EXTERNAL_WIKI_URL" as x26, x21."DEFAULT_BRANCH" as x27, x21."DESCRIPTION" as x28, x21."ORIGIN_REPOSITORY_NAME" as x29, x21."ORIGIN_USER_NAME" as x30, x21."PARENT_USER_NAME" as x31, x21."PRIVATE" as x32, x21."REPOSITORY_NAME" as x33, x21."USER_NAME" as x34, x21."ENABLE_WIKI" as x35, x21."ENABLE_ISSUES" as x36, x21."REGISTERED_DATE" as x37, x21."LAST_ACTIVITY_DATE" as x38 from "REPOSITORY" x21) x39 on (x11.x18 = x39.x34) and (x11.x15 = x39.x33) where (x39.x32 = ?) or (x39.x34 in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) order by x11.x17 desc limit 30) x2 [50000-192]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
	at org.h2.message.DbException.get(DbException.java:168)
	at org.h2.message.DbException.convert(DbException.java:295)
	at org.h2.command.Command.executeQuery(Command.java:213)
	at org.h2.jdbc.JdbcPreparedStatement.execute(JdbcPreparedStatement.java:195)

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

Samebug visitor profile picture
Unknown user
Once, 1 week ago
Samebug visitor profile picture
Unknown user
Once, 4 weeks ago
4 times, 9 months ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
4 times, 3 days ago
148 more bugmates