-
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
- Launch Bitbucket using H2 database
- 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