sul-dlss / purl-fetcher

An HTTP API for querying and updating PURLs
0 stars 1 forks source link

Migration error on deploy to stage #726

Closed jcoyne closed 4 months ago

jcoyne commented 4 months ago
      01 StandardError: An error has occurred, all later migrations canceled: (StandardError)
      01 
      01 Column `parent_id` on table `constituent_memberships` does not match column `id` on `purls`, which has type `int(11)`. To resolve this issue, change the type of the `parent_id` column on `constituent_memberships` to be :integer. (For example `t.integer :parent_id`).
      01 Original message: Mysql2::Error: Can't create table `purl-fetcher`.`constituent_memberships` (errno: 150 "Foreign key constraint is incorrectly formed")

https://sul-ci-prod.stanford.edu/blue/rest/organizations/jenkins/pipelines/SUL-DLSS/pipelines/purl-fetcher/branches/main/runs/135/nodes/17/steps/23/log/?start=0

I believe this is https://github.com/rails/rails/issues/30806