org.h2.jdbc.JdbcSQLException: Таблица "VERSIONS" не найдена|Table "VERSIONS" not found; SQL statement:|SELECT VERSION FROM VERSIONS WHERE MODULE_ID = ? [42102-192]

GitHub | aa3Eethi | 5 months ago
  1. 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]
  2. 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]
  3. 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:[]}]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 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:[]}]
  6. 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]
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

    Таблица "VERSIONS" не найдена|Table "VERSIONS" not found; SQL statement:|SELECT VERSION FROM VERSIONS WHERE MODULE_ID = ? [42102-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.command.Parser.readTableOrView(Parser.java:5388)
    5. org.h2.command.Parser.readTableFilter(Parser.java:1257)
    6. org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1896)
    7. org.h2.command.Parser.parseSelectSimple(Parser.java:2044)
    8. org.h2.command.Parser.parseSelectSub(Parser.java:1890)
    9. org.h2.command.Parser.parseSelectUnion(Parser.java:1711)
    10. org.h2.command.Parser.parseSelect(Parser.java:1699)
    11. org.h2.command.Parser.parsePrepared(Parser.java:445)
    12. org.h2.command.Parser.parse(Parser.java:317)
    13. org.h2.command.Parser.parse(Parser.java:289)
    14. org.h2.command.Parser.prepareCommand(Parser.java:254)
    15. org.h2.engine.Session.prepareLocal(Session.java:560)
    16. org.h2.engine.Session.prepareCommand(Session.java:501)
    17. org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1202)
    18. org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:73)
    19. org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:290)
    19 frames
  3. HikariCP-java6
    HikariProxyConnection.prepareStatement
    1. com.zaxxer.hikari.pool.ProxyConnection.prepareStatement(ProxyConnection.java:309)
    2. com.zaxxer.hikari.pool.HikariProxyConnection.prepareStatement(HikariProxyConnection.java)
    2 frames
  4. io.github.gitbucket
    JDBCVersionManager.getCurrentVersion
    1. io.github.gitbucket.solidbase.migration.MigrationUtils.selectStringFromDatabase(MigrationUtils.java:52)
    2. io.github.gitbucket.solidbase.manager.JDBCVersionManager.getCurrentVersion(JDBCVersionManager.java:38)
    2 frames
  5. gitbucket.core.servlet
    InitializeListener.gitbucket$core$servlet$InitializeListener$$$anonfun$1$adapted
    1. gitbucket.core.servlet.InitializeListener.gitbucket$core$servlet$InitializeListener$$$anonfun$1(InitializeListener.scala:77)
    2. gitbucket.core.servlet.InitializeListener.gitbucket$core$servlet$InitializeListener$$$anonfun$1$adapted(InitializeListener.scala:36)
    2 frames
  6. scala.slick.backend
    DatabaseComponent$DatabaseDef$$anonfun$withTransaction$1$$anonfun$apply$1.apply
    1. scala.slick.backend.DatabaseComponent$DatabaseDef$$anonfun$withTransaction$1$$anonfun$apply$1.apply(DatabaseComponent.scala:54)
    1 frame
  7. SLICK
    JdbcBackend$BaseSession.withTransaction
    1. scala.slick.jdbc.JdbcBackend$BaseSession.withTransaction(JdbcBackend.scala:426)
    1 frame
  8. scala.slick.backend
    DatabaseComponent$DatabaseDef$class.withSession
    1. scala.slick.backend.DatabaseComponent$DatabaseDef$$anonfun$withTransaction$1.apply(DatabaseComponent.scala:54)
    2. scala.slick.backend.DatabaseComponent$DatabaseDef$$anonfun$withTransaction$1.apply(DatabaseComponent.scala:54)
    3. scala.slick.backend.DatabaseComponent$DatabaseDef$class.withSession(DatabaseComponent.scala:34)
    3 frames
  9. SLICK
    JdbcBackend$DatabaseFactoryDef$$anon$3.withSession
    1. scala.slick.jdbc.JdbcBackend$DatabaseFactoryDef$$anon$3.withSession(JdbcBackend.scala:46)
    1 frame
  10. scala.slick.backend
    DatabaseComponent$DatabaseDef$class.withTransaction
    1. scala.slick.backend.DatabaseComponent$DatabaseDef$class.withTransaction(DatabaseComponent.scala:54)
    1 frame
  11. SLICK
    JdbcBackend$DatabaseFactoryDef$$anon$3.withTransaction
    1. scala.slick.jdbc.JdbcBackend$DatabaseFactoryDef$$anon$3.withTransaction(JdbcBackend.scala:46)
    1 frame
  12. gitbucket.core.servlet
    InitializeListener.contextInitialized
    1. gitbucket.core.servlet.InitializeListener.contextInitialized(InitializeListener.scala:36)
    1 frame
  13. Jetty
    AbstractLifeCycle.start
    1. org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:837)
    2. org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:533)
    3. org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:810)
    4. org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:345)
    5. org.eclipse.jetty.webapp.WebAppContext.startWebapp(WebAppContext.java:1404)
    6. org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1366)
    7. org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:772)
    8. org.eclipse.jetty.servlet.ServletContextHandler.doStart(ServletContextHandler.java:262)
    9. org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:520)
    10. org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
    11. org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:132)
    12. org.eclipse.jetty.server.Server.start(Server.java:411)
    13. org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:106)
    14. org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:61)
    15. org.eclipse.jetty.server.Server.doStart(Server.java:378)
    16. org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:68)
    16 frames
  14. Unknown
    JettyLauncher.main
    1. JettyLauncher.main(JettyLauncher.java:63)
    1 frame