Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Bitbucket installation issue

Getting error during installation of  bitbucket server

Bitbucket version: 6.10.0

MySQL version: 8.0.17

OS: CentOS Linux 8 (Core) Kernel: Linux 4.18.0-147.el8.x86_64

 

Error: The schema could not be created.

The schema could not be created.
	com.atlassian.stash.internal.db.DefaultDatabaseManager.createSchema(DefaultDatabaseManager.java:341)
	com.atlassian.stash.internal.db.DefaultDatabaseManager.prepareDatabase(DefaultDatabaseManager.java:191)
	com.atlassian.stash.internal.maintenance.SpringMaintenanceTaskFactory.setupTask(SpringMaintenanceTaskFactory.java:151)
	...
Error creating bean with name 'liquibasePrototype' defined in class path resource [stash-context.xml]: Invocation of init method failed; nested exception is liquibase.exception.MigrationFailedException: Migration failed for change set com/atlassian/caviar/db/changelog/r1_0/initial-schema.xml::initial-schema-03::mheemskerk:
     Reason: liquibase.exception.DatabaseException: REFERENCES command denied to user 'bitbucketuser'@'192.168.123.55' for table 'bitbucket.cwd_application' [Failed SQL: CREATE TABLE bitbucket.cwd_app_dir_mapping (id BIGINT NOT NULL, application_id BIGINT NOT NULL, directory_id BIGINT NOT NULL, allow_all CHARACTER(255) NOT NULL, list_index INT NULL, CONSTRAINT SYS_PK_10077 PRIMARY KEY (id), CONSTRAINT FK_APP_DIR_APP FOREIGN KEY (application_id) REFERENCES bitbucket.cwd_application(id), CONSTRAINT FK_APP_DIR_DIR FOREIGN KEY (directory_id) REFERENCES bitbucket.cwd_directory(id))]
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1778)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:593)
	org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:515)
	...
Migration failed for change set com/atlassian/caviar/db/changelog/r1_0/initial-schema.xml::initial-schema-03::mheemskerk:
     Reason: liquibase.exception.DatabaseException: REFERENCES command denied to user 'bitbucketuser'@'192.168.123.55' for table 'bitbucket.cwd_application' [Failed SQL: CREATE TABLE bitbucket.cwd_app_dir_mapping (id BIGINT NOT NULL, application_id BIGINT NOT NULL, directory_id BIGINT NOT NULL, allow_all CHARACTER(255) NOT NULL, list_index INT NULL, CONSTRAINT SYS_PK_10077 PRIMARY KEY (id), CONSTRAINT FK_APP_DIR_APP FOREIGN KEY (application_id) REFERENCES bitbucket.cwd_application(id), CONSTRAINT FK_APP_DIR_DIR FOREIGN KEY (directory_id) REFERENCES bitbucket.cwd_directory(id))]
	liquibase.changelog.ChangeSet.execute(ChangeSet.java:637)
	liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:53)
	liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:78)
	...
REFERENCES command denied to user 'bitbucketuser'@'192.168.123.55' for table 'bitbucket.cwd_application' [Failed SQL: CREATE TABLE bitbucket.cwd_app_dir_mapping (id BIGINT NOT NULL, application_id BIGINT NOT NULL, directory_id BIGINT NOT NULL, allow_all CHARACTER(255) NOT NULL, list_index INT NULL, CONSTRAINT SYS_PK_10077 PRIMARY KEY (id), CONSTRAINT FK_APP_DIR_APP FOREIGN KEY (application_id) REFERENCES bitbucket.cwd_application(id), CONSTRAINT FK_APP_DIR_DIR FOREIGN KEY (directory_id) REFERENCES bitbucket.cwd_directory(id))]
	liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:356)
	liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:57)
	liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:125)
	...
REFERENCES command denied to user 'bitbucketuser'@'192.168.123.55' for table 'bitbucket.cwd_application'
	com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
	com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
	com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
	...

0 answers

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
TAGS
Community showcase
Published in Bitbucket

Powering DevOps with Bitbucket Server & Data Center

Hi everyone, The Cloud team recently announced 12 new DevOps features that help developers ship better code, faster   ! While we’re all excited about the new improvements to Bitbucket ...

1,926 views 0 7
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you