Hi Andrew, I've seen you submitted a Support ticket regarding this same issue and one of my colleagues already helped you out with it :)
If you need further assistance or have some questions, let us know and we'll be glad to help!
Cheers,
Ana
I have the same problem with the migration form integrated bitbucket database to Mysql , how did you solve thwe issue? thanks
Bitbucket
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.migrationTask(SpringMaintenanceTaskFactory.java:132) ... 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 liquibase/r3_10/upgrade.xml::STASH-5244-2::bturner: Reason: liquibase.exception.DatabaseException: You can't specify target table 'cwd_user' for update in FROM clause [Failed SQL: UPDATE bitbucket.cwd_user SET external_id = NULL WHERE id IN ( SELECT a.id FROM ( SELECT b.id FROM cwd_user b JOIN ( SELECT c.directory_id, c.external_id FROM cwd_user c GROUP BY c.directory_id, c.external_id HAVING COUNT(*) > 1 ) sq on b.directory_id = sq.directory_id AND b.external_id = sq.external_id ) a )]
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.