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]

GitHub | st0rmchild | 5 months ago
  1. 0

    4.2: Crash after login

    GitHub | 5 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]
  2. 0

    Column "X3.MODE" not found

    GitHub | 5 months ago | koooge
    org.h2.jdbc.JdbcSQLException: Column "X3.MODE" not found; SQL statement: CREATE FORCE VIEW PUBLIC._24 AS SELECT X3.UPDATED_DATE AS UPDATED_DATE, X3.DESCRIPTION AS DESCRIPTION, X3.ORIGIN_REPOSITORY_NAME AS ORIGIN_REPOSITORY_NAME, X3.ORIGIN_USER_NAME AS ORIGIN_USER_NAME, X3.MODE AS MODE, X3.TITLE AS TITLE, X3.REPOSITORY_NAME AS REPOSITORY_NAME, X3.USER_NAME AS USER_NAME, X3.REGISTERED_DATE AS REGISTERED_DATE FROM PUBLIC.GIST X3 WHERE (X3.MODE = ?1) OR (X3.USER_NAME = ?2) ORDER BY =X3.REGISTERED_DATE DESC LIMIT 10 [42122-192]
  3. 0

    http://localhost:8080/gitbucket -> HTTP ERROR: 503 just after fresh install

    GitHub | 5 months ago | aa3Eethi
    org.h2.jdbc.JdbcSQLException: Таблица "VERSIONS" не найдена|Table "VERSIONS" not found; SQL statement:|SELECT VERSION FROM VERSIONS WHERE MODULE_ID = ? [42102-192]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    examples/require.yml fails

    GitHub | 8 months ago | danielnorberg
    org.skife.jdbi.v2.exceptions.UnableToCreateStatementException: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "UPDATE TASKS SET UPDATED_AT = NOW(), STATE = ?, RETRY_AT = TIMESTAMPADD('SECOND', STATE_PARAMS = ?, ?,[*] NOW()) WHERE ID = ? AND STATE = ? "; expected "[, ::, *, /, %, +, -, ||, ~, !~, NOT, LIKE, REGEXP, IS, IN, BETWEEN, AND, OR, )"; SQL statement: update tasks set updated_at = now(), state = ?, retry_at = TIMESTAMPADD('SECOND', state_params = ?, ?, now()) where id = ? and state = ? [42001-191] [statement:"update tasks set updated_at = now(), state = :newState, retry_at = TIMESTAMPADD('SECOND', state_params = :stateParams, :retryInterval, now()) where id = :id and state = :oldState", located:"update tasks set updated_at = now(), state = :newState, retry_at = TIMESTAMPADD('SECOND', state_params = :stateParams, :retryInterval, now()) where id = :id and state = :oldState", rewritten:"update tasks set updated_at = now(), state = ?, retry_at = TIMESTAMPADD('SECOND', state_params = ?, ?, now()) where id = ? and state = ?", arguments:{ positional:{}, named:{}, finder:[]}]
  6. 0

    org.h2.jdbc.JdbcSQLException: Table "QUEUED_SHARED_TASK_LOCKS" not found

    GitHub | 8 months ago | komamitsu
    org.skife.jdbi.v2.exceptions.UnableToCreateStatementException: org.h2.jdbc.JdbcSQLException: Table "QUEUED_SHARED_TASK_LOCKS" not found; SQL statement: with recursive t (queue_id) as ((select queue_id from queued_shared_task_locks where hold_expire_time is null order by queue_id limit 1) union all select (select queue_id from queued_shared_task_locks where hold_expire_time is null and queue_id > t.queue_id order by queue_id limit 1) from t where t.queue_id is not null) select queue_id as id from t where queue_id is not null [42102-191] [statement:"with recursive t (queue_id) as ((select queue_id from queued_shared_task_locks where hold_expire_time is null order by queue_id limit 1) union all select (select queue_id from queued_shared_task_locks where hold_expire_time is null and queue_id > t.queue_id order by queue_id limit 1) from t where t.queue_id is not null) select queue_id as id from t where queue_id is not null", located:"with recursive t (queue_id) as ((select queue_id from queued_shared_task_locks where hold_expire_time is null order by queue_id limit 1) union all select (select queue_id from queued_shared_task_locks where hold_expire_time is null and queue_id > t.queue_id order by queue_id limit 1) from t where t.queue_id is not null) select queue_id as id from t where queue_id is not null", rewritten:"with recursive t (queue_id) as ((select queue_id from queued_shared_task_locks where hold_expire_time is null order by queue_id limit 1) union all select (select queue_id from queued_shared_task_locks where hold_expire_time is null and queue_id > t.queue_id order by queue_id limit 1) from t where t.queue_id is not null) select queue_id as id from t where queue_id is not null", arguments:{ positional:{}, named:{}, finder:[]}]
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

    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]

    at org.h2.message.DbException.getJdbcSQLException()
  2. H2 Database Engine
    JdbcConnection.prepareStatement
    1. org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
    2. org.h2.message.DbException.get(DbException.java:179)
    3. org.h2.message.DbException.get(DbException.java:155)
    4. org.h2.expression.ExpressionColumn.optimize(ExpressionColumn.java:147)
    5. org.h2.expression.Alias.optimize(Alias.java:51)
    6. org.h2.command.dml.Select.prepare(Select.java:852)
    7. org.h2.command.Parser.prepare(Parser.java:239)
    8. org.h2.engine.Session.prepare(Session.java:525)
    9. org.h2.engine.Session.prepare(Session.java:512)
    10. org.h2.table.TableView.compileViewQuery(TableView.java:105)
    11. org.h2.table.TableView.initColumnsAndTables(TableView.java:156)
    12. org.h2.table.TableView.init(TableView.java:98)
    13. org.h2.table.TableView.<init>(TableView.java:65)
    14. org.h2.table.TableView.createTempView(TableView.java:534)
    15. org.h2.command.Parser.readTableFilter(Parser.java:1192)
    16. org.h2.command.Parser.readJoin(Parser.java:1549)
    17. org.h2.command.Parser.parseJoinTableFilter(Parser.java:1941)
    18. org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1897)
    19. org.h2.command.Parser.parseSelectSimple(Parser.java:2044)
    20. org.h2.command.Parser.parseSelectSub(Parser.java:1890)
    21. org.h2.command.Parser.parseSelectUnion(Parser.java:1711)
    22. org.h2.command.Parser.readTableFilter(Parser.java:1181)
    23. org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1896)
    24. org.h2.command.Parser.parseSelectSimple(Parser.java:2044)
    25. org.h2.command.Parser.parseSelectSub(Parser.java:1890)
    26. org.h2.command.Parser.parseSelectUnion(Parser.java:1711)
    27. org.h2.command.Parser.parseSelect(Parser.java:1699)
    28. org.h2.command.Parser.parsePrepared(Parser.java:445)
    29. org.h2.command.Parser.parse(Parser.java:317)
    30. org.h2.command.Parser.parse(Parser.java:289)
    31. org.h2.command.Parser.prepareCommand(Parser.java:254)
    32. org.h2.engine.Session.prepareLocal(Session.java:560)
    33. org.h2.engine.Session.prepareCommand(Session.java:501)
    34. org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1202)
    35. org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:73)
    36. org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:679)
    36 frames
  3. HikariCP-java6
    HikariProxyConnection.prepareStatement
    1. com.zaxxer.hikari.pool.ProxyConnection.prepareStatement(ProxyConnection.java:323)
    2. com.zaxxer.hikari.pool.HikariProxyConnection.prepareStatement(HikariProxyConnection.java)
    2 frames
  4. SLICK
    StatementInvoker.list
    1. scala.slick.jdbc.JdbcBackend$SessionDef$class.prepareStatement(JdbcBackend.scala:152)
    2. scala.slick.jdbc.JdbcBackend$BaseSession.prepareStatement(JdbcBackend.scala:389)
    3. scala.slick.jdbc.StatementInvoker.results(StatementInvoker.scala:32)
    4. scala.slick.jdbc.StatementInvoker.iteratorTo(StatementInvoker.scala:22)
    5. scala.slick.jdbc.Invoker$class.foreach(Invoker.scala:64)
    6. scala.slick.jdbc.StatementInvoker.foreach(StatementInvoker.scala:16)
    7. scala.slick.jdbc.Invoker$class.build(Invoker.scala:47)
    8. scala.slick.jdbc.StatementInvoker.build(StatementInvoker.scala:16)
    9. scala.slick.jdbc.Invoker$class.list(Invoker.scala:39)
    10. scala.slick.jdbc.StatementInvoker.list(StatementInvoker.scala:16)
    10 frames
  5. gitbucket.core.service
    ActivityService$class.getRecentActivitiesByOwners
    1. gitbucket.core.service.ActivityService$class.getRecentActivitiesByOwners(ActivityService.scala:47)
    1 frame
  6. gitbucket.core.controller
    IndexControllerBase$class.gitbucket$core$controller$IndexControllerBase$class$$$anonfun$3
    1. gitbucket.core.controller.IndexController.getRecentActivitiesByOwners(IndexController.scala:13)
    2. gitbucket.core.controller.IndexControllerBase$class.gitbucket$core$controller$IndexControllerBase$class$$$anonfun$3(IndexController.scala:52)
    2 frames