Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Bitbucket installation issue

Shrinivas SHARMA May 19, 2020

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
AUG Leaders

Atlassian Community Events