Viewing Authorized applications results in 500 error when using H2 database

XMLWordPrintable

    • Type: Bug
    • Resolution: Unresolved
    • Priority: Low
    • None
    • Affects Version/s: 10.2.3, 10.3.1
    • Component/s: User Profiles
    • None
    • 1
    • Severity 2 - Major

      Issue Summary

      When starting fresh Bitbucket instance using H2 database, I'm getting 500 error when attempting to see user's Authorized application.

      Steps to Reproduce

      1. Launch Bitbucket using H2 database
      2. Go to Manage account -> Authorized applications

      Expected Results

      See tabs with incoming and outgoing applications

      Actual Results

      The below exception is thrown in the atlassian-bitbucket.log file:

      2026-07-02 14:02:15,849 ERROR [http-nio-7990-exec-2] @9JCI36x842x93x0 1natbkl 0:0:0:0:0:0:0:1 "GET /mvc/error500 HTTP/1.1" c.a.s.i.web.ErrorPageController There was an unhandled exception loading [/bitbucket/plugins/servlet/oauth/users/access-tokens]
      com.atlassian.activeobjects.internal.ActiveObjectsInitException: bundle [com.atlassian.oauth.atlassian-oauth-service-provider-sal-plugin]
      	at com.atlassian.activeobjects.osgi.ActiveObjectsDelegate$1.lambda$load$0(ActiveObjectsDelegate.java:90)
      	at com.atlassian.sal.core.executor.ThreadLocalDelegateCallable.call(ThreadLocalDelegateCallable.java:38)
      	at java.base/java.util.concurrent.FutureTask.run$$$capture(FutureTask.java:317)
      	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java)
      	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
      	at java.base/java.lang.Thread.run(Thread.java:1583)
      	... 1 frame trimmed
      Caused by: com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library:
      Database:
      	- name:H2
      	- version:2.1.214 (2022-06-13)
      	- minor version:1
      	- major version:2
      Driver:
      	- name:H2 JDBC Driver
      	- version:2.1.214 (2022-06-13)
      
      org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement "CREATE TABLE AO_ECD6B3_OAUTH_SPTOKEN (\000a    ACCESS_TOKEN BOOLEAN,\000a    [*]AUTHORIZATION VARCHAR(32),\000a    CALLBACK CLOB,\000a    CONSUMER_KEY VARCHAR(255) NOT NULL,\000a    CREATION_TIME BIGINT DEFAULT 0,\000a    ID INT AUTO_INCREMENT NOT NULL,\000a    PROPERTIES CLOB,\000a    SESSION_CREATION_TIME BIGINT DEFAULT 0,\000a    SESSION_HANDLE VARCHAR(255),\000a    SESSION_LAST_RENEWAL_TIME BIGINT DEFAULT 0,\000a    SESSION_TIME_TO_LIVE BIGINT DEFAULT 0,\000a    TIME_TO_LIVE BIGINT DEFAULT 0,\000a    TOKEN VARCHAR(255) NOT NULL,\000a    TOKEN_SECRET CLOB NOT NULL,\000a    USER_NAME VARCHAR(255),\000a    VERIFIER CLOB,\000a    VERSION VARCHAR(32),\000a    PRIMARY KEY(ID),\000a    CONSTRAINT U_AO_ECD6B3_OAUTH_S1951068553 UNIQUE(TOKEN)\000a)"; expected "identifier"; SQL statement:
      CREATE TABLE AO_ECD6B3_OAUTH_SPTOKEN (
          ACCESS_TOKEN BOOLEAN,
          AUTHORIZATION VARCHAR(32),
          CALLBACK CLOB,
          CONSUMER_KEY VARCHAR(255) NOT NULL,
          CREATION_TIME BIGINT DEFAULT 0,
          ID INT AUTO_INCREMENT NOT NULL,
          PROPERTIES CLOB,
          SESSION_CREATION_TIME BIGINT DEFAULT 0,
          SESSION_HANDLE VARCHAR(255),
          SESSION_LAST_RENEWAL_TIME BIGINT DEFAULT 0,
          SESSION_TIME_TO_LIVE BIGINT DEFAULT 0,
          TIME_TO_LIVE BIGINT DEFAULT 0,
          TOKEN VARCHAR(255) NOT NULL,
          TOKEN_SECRET CLOB NOT NULL,
          USER_NAME VARCHAR(255),
          VERIFIER CLOB,
          VERSION VARCHAR(32),
          PRIMARY KEY(ID),
          CONSTRAINT U_AO_ECD6B3_OAUTH_S1951068553 UNIQUE(TOKEN)
      ) [42001-214]
      	at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.migrate(EntityManagedActiveObjects.java:55)
      	at com.atlassian.activeobjects.internal.AbstractActiveObjectsFactory.lambda$create$0(AbstractActiveObjectsFactory.java:84)
      	at com.atlassian.sal.core.transaction.HostContextTransactionTemplate$1.doInTransaction(HostContextTransactionTemplate.java:21) 

      Workaround

      Currently there is no known workaround for this behavior. A workaround will be added here when available

              Assignee:
              Unassigned
              Reporter:
              Stepan Tsymbal
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated: