997468 - Migration 759 can't be run

Status: RESOLVED FIXED

(addons.mozilla.org Graveyard :: Maintenance Scripts, defect, P1)

Description

[Yohan Boniface [:ybon]]

I got this pastebin from mat who got it from jason, but we have the idea: https://jason.pastebin.mozilla.org/4817671
@washort, as it seems you added this migration (https://github.com/mozilla/olympia/commit/ad7b8e4f84c787c20c0c34d874f8e3aa0d047963#diff-10), do you have any hint?

For the record:

    Running SQL migration 759:
    DROP TABLE prices;
    DROP TABLE price_currency;
    DROP TABLE addon_purchase;
    DROP TABLE addons_premium;
    DROP TABLE refunds;
    DROP TABLE addon_payment_data;
    DROP TABLE paypal_checkstatus;
     
    ALTER TABLE stats_contributions
        DROP COLUMN user,
        DROP COLUMN type,
        DROP COLUMN price_tier,
        DROP COLUMN related;
     
    Error: Had trouble running this: BEGIN;
    DROP TABLE prices;
    DROP TABLE price_currency;
    DROP TABLE addon_purchase;
    DROP TABLE addons_premium;
    DROP TABLE refunds;
    DROP TABLE addon_payment_data;
    DROP TABLE paypal_checkstatus;
     
    ALTER TABLE stats_contributions
        DROP COLUMN user,
        DROP COLUMN type,
        DROP COLUMN price_tier,
        DROP COLUMN related;
     
    UPDATE schema_version SET version = 759;
    COMMIT;
    stdout:
    stderr: ERROR 1217 (23000) at line 2: Cannot delete or update a parent row: a foreign key constraint fails
     
    returncode: 1

Comment 1

[Mathieu Pillard [:mat]]

This prevents olympia to be updated on dev.

Comment 2

[Allen Short [:ashort]]

https://github.com/mozilla/olympia/commit/5d7e025db72b4d5a2e2ffed892cc3b18efc44d71

Comment 3

[Allen Short [:ashort]]

evidently doesn't work on -dev. deleting for now, will readd later.

Comment 4

[Mathieu Agopian [:magopian]]

fixed in https://github.com/mozilla/olympia/commit/de787b06fac29d99945887b85b7f1984be834dba