Double quotes in the jdbc.user property makes certain pages inaccessible

XMLWordPrintable

    • Type: Bug
    • Resolution: Unresolved
    • Priority: Medium
    • None
    • Affects Version/s: 8.19.16
    • Component/s: Crowd, Database - Oracle
    • None
    • 1
    • Severity 3 - Minor

      Issue Summary

      If double quotes are mistakenly added to the jdbc.user property(for ex jdbc.user="BITBUCKET") in the bitbucket.properties file, Bitbucket will still be able to connect to Oracle after a restart. However, this causes an error to be thrown, and as a result, some pages or features may not be accessible.
       

      2026-01-09 12:25:16,443 INFO  [spring-startup]  c.a.s.internal.home.HomeLockAcquirer Successfully acquired lock on home directory /opt/home9.4.12
2026-01-09 12:26:18,867 INFO  [spring-startup]  c.a.s.internal.home.HomeLockAcquirer Successfully acquired lock on home directory /opt/home9.4.12/shared
2026-01-09 12:26:19,860 WARN  [spring-startup]  com.hazelcast.instance.impl.Node [172.50.0.1]:5701 [bitbucket] [5.4.1] No join method is enabled! Starting standalone.
2026-01-09 12:26:29,426 INFO  [spring-startup]  c.a.s.i.s.u.AbstractApplicationSecretUpgradeTask Starting upgrade task core-migrate-system-signing-passphrase
2026-01-09 12:26:29,596 INFO  [spring-startup]  c.a.s.i.s.u.AbstractApplicationSecretUpgradeTask Upgrade task core-migrate-system-signing-passphrase completed
2026-01-09 12:26:29,598 INFO  [spring-startup]  c.a.s.i.s.u.AbstractApplicationSecretUpgradeTask Starting upgrade task core-migrate-mail-password
2026-01-09 12:26:29,600 INFO  [spring-startup]  c.a.s.i.s.u.AbstractApplicationSecretUpgradeTask Upgrade task core-migrate-mail-password completed
2026-01-09 12:26:30,946 INFO  [spring-startup]  c.a.s.i.u.u.CreateSystemUserUpgradeTask Unable to create system service user as user with the same name already exists. The upgrade task wi
ll not be re-run, and the existing user will be used as the system service user.
2026-01-09 12:26:39,750 INFO  [spring-startup]  c.a.s.i.s.g.m.DefaultSidecarManager Sidecar started after 6261ms
2026-01-09 12:26:39,792 WARN  [spring-startup]  c.a.s.i.s.g.b.DefaultGitBinaryHelper The configured git executable, /usr/local/git2420/bin/git, does not exist or is not executable
2026-01-09 12:26:45,185 INFO  [spring-startup]  c.a.s.i.s.g.m.DefaultMeshSidebandRegistry Sidecar#0 (http://localhost:7777): Opening sideband channel
2026-01-09 12:26:47,254 WARN  [FelixStartLevel]  o.e.g.b.e.i.s.ExtenderConfiguration Gemini Blueprint extensions bundle not present, annotation processing disabled.
2026-01-09 12:26:54,784 INFO  [ThreadPoolAsyncTaskExecutor::Thread 24]  c.a.b.i.g.GpgSystemSigningKeyProvider Using signing key with fingerprint 1c9d6c1eb5d7bb0b9302904a1d4f91c2c5523d9e
2026-01-09 12:26:55,552 INFO  [ThreadPoolAsyncTaskExecutor::Thread 5]  c.a.b.p.b.l.j.MigrationCommandScheduledRunner Successfully registered migration command cleanup job bitbucket-migrat
ion-command-cleanup-job-key
2026-01-09 12:26:55,761 INFO  [ThreadPoolAsyncTaskExecutor::Thread 5]  c.a.b.p.b.m.MigrationServiceClient migration service migration url : https://api-private.atlassian.com/migrations/
2026-01-09 12:26:55,767 INFO  [ThreadPoolAsyncTaskExecutor::Thread 5]  c.a.b.p.b.m.MigrationServiceClient bitbucket migration service url : https://api-private.atlassian.com/migration/bit
bucket/
2026-01-09 12:26:55,768 INFO  [ThreadPoolAsyncTaskExecutor::Thread 5]  c.a.b.p.b.m.MigrationServiceClient analytics service url : https://api-private.atlassian.com/migration/analytics/bit
bucketMigration/
2026-01-09 12:26:59,230 ERROR [active-objects-init-0]  net.java.ao.sql Exception executing SQL update <CREATE TABLE "AO_C77861_AUDIT_ACTION_CACHE" (
    "ACTION" VARCHAR(255) NOT NULL,
    "ACTION_T_KEY" VARCHAR(255),
    "ID" NUMBER(11) NOT NULL,
    PRIMARY KEY("ID")
)>
java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object
 

      Steps to Reproduce

      1. Install Oracle 19c.
      2. Create a user in Oracle.
          
        CREATE USER bitbucket IDENTIFIED BY <password> DEFAULT TABLESPACE USERS QUOTA UNLIMITED ON USERS;
      1. Grant permission. 
        GRANT CREATE SESSION TO bitbucket;
GRANT CONNECT, RESOURCE TO bitbucket;
      1. Start Bitbucket with jdbc.user=BITBUCKET and see everything works normally.
      2. Shutdown Bitbucket, add double quotes jdbc.user=”BITBUCKET” and verify that it doesn’t throw any error while connecting to the database, and UI becomes accessible, even certain features like Settings page, websudo works but repos aren’t accesible.

      Expected Results

      Bitbucket should either fail to start or, if it does start, all features should function properly.

      Actual Results

      Certain pages, like the repository browse page, and features such as project or repository creation, become inaccessible.

      Workaround

      Delete the double quotes from the jdbc.user property in the bitbucket.properties file, then restart Bitbucket.

              Assignee:
              Unassigned
              Reporter:
              Aman Shrivastava
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated: