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]

GitHub | devagorilla | 3 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Unable to recover a corrupted database

    GitHub | 3 months ago | devagorilla
    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]
  2. 0

    4.2: Database migration seems to fail for non-empty database - Column "X21.ALLOW_WIKI_EDITING" not found

    GitHub | 10 months ago | uli-heller
    org.h2.jdbc.JdbcSQLException: Column "X21.ALLOW_WIKI_EDITING" not found; SQL statement: CREATE FORCE VIEW PUBLIC._1 AS 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 PUBLIC.REPOSITORY X21 [42122-192]
  3. 0

    Invalid SQL generated on inner query from GroupBy

    GitHub | 3 years ago | fzakaria
    PUBLIC.PRIMARY_KEY_5: "id" = X158."ideaId" _/ ON 1=1 WHERE (X158."voterId" = 21) AND ((X157."deleted" = FALSE) AND (X158."ideaId" = X157."id")) ORDER BY 9 DESC ) X141 WHERE X141.X148 = X106.X104 [42122-172]]]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    GitHub comment 56#11408039

    GitHub | 4 years ago | hbf
    org.h2.jdbc.JdbcSQLException: Syntax error in 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 "; expected "RIGHT, LEFT, 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]
  6. 0

    4.2: Crash after login

    GitHub | 10 months ago | st0rmchild
    org.h2.jdbc.JdbcSQLException: Column "X21.ALLOW_WIKI_EDITING" not found; SQL statement: CREATE FORCE VIEW PUBLIC._3 AS 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 PUBLIC.REPOSITORY X21 [42122-192]

  1. Andreas Häber 1 times, last 3 weeks ago
  2. kjhdofjosvs 1 times, last 3 months ago
1 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. 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()
  2. H2 Database Engine
    JdbcPreparedStatement.execute
    1. org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
    2. org.h2.message.DbException.get(DbException.java:168)
    3. org.h2.message.DbException.convert(DbException.java:295)
    4. org.h2.command.Command.executeQuery(Command.java:213)
    5. org.h2.jdbc.JdbcPreparedStatement.execute(JdbcPreparedStatement.java:195)
    5 frames