org.h2.jdbc.JdbcSQLException

If you like a tip written by other Samebug users, mark is as helpful! Marks help our algorithm provide you better solutions and also help other users.
tip

Check if you're not creating unused SQL entities, as it might cause this exception.


rafaelrafael

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

  • h2 truncate may fail
    via GitHub by ben-manes
    ,
  • Clock crashed
    via GitHub by phxql
    ,
  • Database deadlock
    via GitHub by phxql
    ,
  • iBatis issues when running new version of archetypes
    via by Gabriele Columbro,
  • Stuck in evolutions loop
    via by v6ak,
    • 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)

    Users with the same issue

    kjhdofjosvskjhdofjosvs
    4 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    tvrmsmithtvrmsmith
    2 times, last one,
    guizmaiiguizmaii
    34 times, last one,
    batwalrus76batwalrus76
    4 times, last one,
    143 more bugmates