Issue #SCB2425 0-UNDECIDED

Activity report on

  *Defect SCB2425 - FOREIGN KEY error*
 
  Scarab Link: http://www.solitone.org/scarab/issues/id/SCB2425
  Module: Scarab


  Activity generated by  Dave Kent ([email protected])  at 11/07/2007 18:15



  ** Issue created **

-------------------------------------------------------------------------------
  *Attribute changes*
  - "Priority" set to "0-UNDECIDED"
  - "Database" set to "MySQL"
  - "Version" set to "0.21"
  - "Target milestone" set to "UNDECIDED"
  - "Summary" set to "FOREIGN KEY error"
  - "Status" set to "Unconfirmed"
  - "Short description" set to:
    "I'm trying to upgrade from version b20 to b21 Below is the error I receive when the database is being upgraded using the command 'ant migrate-from-b20'

[sql] Executing resource: C:\scarab\target\scarab\database\instance\sql\my
sql\upgrade\mysql-upgrade-1.0b20-1.0b21-3.sql
      [sql] Failed to execute:   CREATE TABLE SCARAB_ISSUE ( PRIMARY KEY(ISSUE_ID), FOREIGN KEY (MODULE_ID) REFERENCES SCARAB_MODULE (MODULE_ID), FOREIGN KEY (T
YPE_ID) REFERENCES SCARAB_ISSUE_TYPE (ISSUE_TYPE_ID), FOREIGN KEY (CREATED_TRANS
_ID) REFERENCES SCARAB_TRANSACTION (TRANSACTION_ID), INDEX IX_TYPE_MODULE (TYPE_ID, MODULE_ID), INDEX IX_COUNT_PREFIX (ID_COUNT, ID_PREFIX) ) SELECT i.ISSUE_ID, i.ID_PREFIX, i.ID_COUNT, i.ID_DOMAIN, i.TYPE_ID, i.MODULE_ID, i.CREATED_TRANS_ID, max(a.transaction_id) LAST_TRANS_ID, i.DELETED, i.MOVED FROM SCARAB_ISSUE_BACKUP_b20_b21 i LEFT OUTER JOIN SCARAB_ACTIVITY a ON (i.ISSUE_ID = a.ISSUE_ID) GROUP BY i.ISSUE_ID      
[sql] java.sql.SQLException: Can't create table '.\scarab\scarab_issue.frm' (errno: 150)"

-------------------------------------------------------------------------------