Uploaded image for project: 'Bitbucket Data Center'
  1. Bitbucket Data Center
  2. BSERV-2699

Cannot initialize Oracle schema

    XMLWordPrintable

Details

    Description

      During Stash 1.3.0-beta2 installation I get such error:

      The schema could not be created.
      	com.atlassian.stash.internal.migration.DefaultMigrationService.createSchema(DefaultMigrationService.java:572)
      	com.atlassian.stash.internal.migration.DefaultMigrationService.startMigration(DefaultMigrationService.java:933)
      	com.atlassian.stash.internal.migration.DefaultMigrationService.setup(DefaultMigrationService.java:212)
      	...
      Migration failed for change set liquibase/r1_3/m01.xml::STASHDEV-1023-11::bturner:
           Reason: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE GITPILOTTMP.sta_diff_comment_anchor ADD CONSTRAINT fk_sta_diff_comment_comment FOREIGN KEY (comment_id) REFERENCES GITPILOTTMP.sta_comment (id) ON DELETE CASCADE: ORA-00604: error occurred at recursive SQL level 1
      ORA-20000: For GoldenGate, delete cascade constraints must be deferrable
      ORA-06512: at line 64
      :
                Caused By: Error executing SQL ALTER TABLE GITPILOTTMP.sta_diff_comment_anchor ADD CONSTRAINT fk_sta_diff_comment_comment FOREIGN KEY (comment_id) REFERENCES GITPILOTTMP.sta_comment (id) ON DELETE CASCADE: ORA-00604: error occurred at recursive SQL level 1
      ORA-20000: For GoldenGate, delete cascade constraints must be deferrable
      ORA-06512: at line 64
      :
                Caused By: ORA-00604: error occurred at recursive SQL level 1
      ORA-20000: For GoldenGate, delete cascade constraints must be deferrable
      ORA-06512: at line 64
      
      	liquibase.changelog.ChangeSet.execute(ChangeSet.java:347)
      	liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27)
      	liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
      	...
      Error executing SQL ALTER TABLE GITPILOTTMP.sta_diff_comment_anchor ADD CONSTRAINT fk_sta_diff_comment_comment FOREIGN KEY (comment_id) REFERENCES GITPILOTTMP.sta_comment (id) ON DELETE CASCADE: ORA-00604: error occurred at recursive SQL level 1
      ORA-20000: For GoldenGate, delete cascade constraints must be deferrable
      ORA-06512: at line 64
      
      	liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
      	liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
      	liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091)
      	...
      ORA-00604: error occurred at recursive SQL level 1
      ORA-20000: For GoldenGate, delete cascade constraints must be deferrable
      ORA-06512: at line 64
      
      	oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
      	oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
      	oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
      
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              3e793c65704f Wojciech Olearczyk
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: