数据库迁移版本20210714173022在跳过部署后迁移步骤时失败

在启用了 SKIP_POST_DEPLOYMENT_MIGRATIONS 的第一个容器中更新到稳定版(v2.7.8)时遇到问题。
当在另一个容器中禁用跳过选项再次运行时,迁移任务 CorrectlyMoveAssignmentsFromCustomFieldsToATable 失败:

PG::NotNullViolation: ERROR:  null value in column "assigned_to_type"
of relation "assignments" violates not-null constraint

据我所见,升级任务 AddAssignedToTypeToAssignments(创建非空约束)不应在 CorrectlyMoveAssignmentsFromCustomFieldsToATable 完成之前执行。

作为临时解决方案,我执行了以下操作:

INSERT INTO assignments
(assigned_to_id, assigned_by_user_id, topic_id, created_at, updated_at,assigned_to_type)
SELECT
  assigned_to.value::integer,
  assigned_by.value::integer,
  assigned_by.topic_id,
  assigned_by.created_at,
  assigned_by.updated_at,
  'User'
FROM topic_custom_fields assigned_by
INNER JOIN topic_custom_fields assigned_to
ON assigned_to.topic_id = assigned_by.topic_id
WHERE assigned_by.name = 'assigned_by_id'
AND assigned_to.name = 'assigned_to_id'
ORDER BY assigned_by.created_at DESC
ON CONFLICT DO NOTHING;

INSERT INTO schema_migration_details
(version,
name,
hostname,
git_version,
rails_version,
duration,
direction,
created_at)
values(
'20210714173022',
'CorrectlyMoveAssignmentsFromCustomFieldsToATable',
'ce4fb45daf62',
'98b0621d538fa4e8a53e1e74127c24c384be9b58',
'6.1.3.2',
0,
'up',
'2021-09-28 15:20:00.123456'
);

INSERT INTO schema_migrations values('20210714173022');

之后,我成功重新构建了容器。

2 个赞

感谢您的调查,我们已通过以下 PR 修复了该迁移:

3 个赞

好快。谢谢 :slight_smile:

2 个赞