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

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
Posted in Bitbucket

How do you use the Bitbucket-Jira integration? How does it help your team?

Hey everyone, over the past year, we've added several new features on how you can use Bitbucket and Jira together. We'd love to know how you'll are using the integration and how it's helping your t...

170 views 0 2
Join discussion

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