Bohan Jiang
1de4b2d688
fix(migrations): make 164_attachment_task_id idempotent to self-heal #5307 renumber drift ( #5324 )
...
#5307 renamed 161_attachment_task_id -> 164 (and 162_..._index -> 165) to
resolve a prefix collision. schema_migrations keys on the full stem, so any DB
that applied the migration under its old 161 number does not have "164" in the
ledger and the runner re-applies the renamed file. The bare `ADD COLUMN task_id`
then aborts with 42701 ("column already exists"), blocking every later
migration — this is exactly what crashed the dev deploy of main (bf288349f ) at
container startup, before it ever reached 166_project_dates.
Add `IF NOT EXISTS` so the re-run is a harmless no-op on already-migrated DBs
(dev/staging/prod) with no manual schema_migrations surgery, while staying
identical on a fresh DB. Sibling 165 already uses CREATE INDEX ... IF NOT EXISTS
for the same reason; this brings 164 in line. The down file already uses
DROP COLUMN IF EXISTS.
Verified on a throwaway DB reproducing the dev drift (forget 164/165 in the
ledger, keep the column+index): old file reproduces the 42701 crash, the fixed
file self-heals and completes. Migration lint + concurrent migrate tests pass.
Refs #5307
Co-authored-by: J <j@multica.ai >
Co-authored-by: multica-agent <github@multica.ai >
2026-07-13 15:33:52 +08:00
..
2026-05-09 15:07:57 +08:00
2026-05-09 15:07:57 +08:00
2026-05-09 14:39:10 +08:00
2026-05-09 14:39:10 +08:00
2026-05-12 13:49:03 +08:00
2026-05-12 13:49:03 +08:00
2026-05-09 15:07:57 +08:00
2026-05-09 15:07:57 +08:00
2026-05-11 14:39:35 +08:00
2026-05-11 14:39:35 +08:00
2026-05-11 14:39:35 +08:00
2026-05-11 14:39:35 +08:00
2026-05-12 10:57:54 +08:00
2026-05-12 10:57:54 +08:00
2026-05-11 22:53:07 +08:00
2026-05-11 22:53:07 +08:00
2026-05-13 18:46:20 +08:00
2026-05-13 18:46:20 +08:00
2026-05-13 12:51:16 +08:00
2026-05-13 12:51:16 +08:00
2026-05-13 18:46:20 +08:00
2026-05-13 18:46:20 +08:00
2026-05-13 18:46:20 +08:00
2026-05-13 18:46:20 +08:00
2026-05-13 18:46:20 +08:00
2026-05-13 18:46:20 +08:00
2026-05-13 18:46:20 +08:00
2026-05-13 18:46:20 +08:00
2026-05-14 14:07:26 +08:00
2026-05-14 14:07:26 +08:00
2026-05-14 15:23:36 +02:00
2026-05-14 15:23:36 +02:00
2026-05-18 12:17:39 +08:00
2026-05-18 12:17:39 +08:00
2026-05-17 15:01:38 +08:00
2026-05-17 15:01:38 +08:00
2026-05-16 21:26:30 +02:00
2026-05-16 21:26:30 +02:00
2026-05-16 21:26:30 +02:00
2026-05-16 21:26:30 +02:00
2026-05-18 14:59:40 +08:00
2026-05-18 14:59:40 +08:00
2026-05-19 05:35:18 +02:00
2026-05-19 05:35:18 +02:00
2026-05-20 12:30:10 +08:00
2026-05-20 12:30:10 +08:00
2026-05-19 18:37:48 +02:00
2026-05-19 18:37:48 +02:00
2026-05-20 05:30:13 +02:00
2026-05-20 05:30:13 +02:00
2026-06-17 09:24:15 +02:00
2026-06-17 17:53:43 +08:00
2026-05-19 19:51:28 +02:00
2026-05-19 19:51:28 +02:00
2026-05-20 15:37:23 +08:00
2026-05-20 15:37:23 +08:00
2026-05-22 13:22:36 +08:00
2026-05-22 13:22:36 +08:00
2026-05-21 19:00:26 +08:00
2026-05-21 19:00:26 +08:00
2026-05-21 15:33:47 +08:00
2026-05-21 15:33:47 +08:00
2026-05-21 15:33:47 +08:00
2026-05-21 15:33:47 +08:00
2026-05-21 15:33:47 +08:00
2026-05-21 15:33:47 +08:00
2026-05-21 15:33:47 +08:00
2026-05-21 16:26:42 +08:00
2026-05-21 15:33:47 +08:00
2026-05-21 15:33:47 +08:00
2026-05-21 16:35:45 +08:00
2026-05-21 16:35:45 +08:00
2026-05-22 12:26:56 +08:00
2026-05-22 12:26:56 +08:00
2026-05-22 14:51:43 +08:00
2026-05-22 14:51:43 +08:00
2026-05-25 18:42:48 +08:00
2026-05-25 18:42:48 +08:00
2026-05-27 13:44:31 +08:00
2026-05-27 13:44:31 +08:00
2026-05-26 17:00:01 +08:00
2026-05-26 17:00:01 +08:00
2026-05-26 16:45:46 +08:00
2026-05-26 16:45:46 +08:00
2026-06-03 19:12:14 +08:00
2026-06-03 19:12:14 +08:00
2026-05-27 15:47:36 +08:00
2026-05-27 15:47:36 +08:00
2026-06-03 19:12:14 +08:00
2026-06-03 19:12:14 +08:00
2026-06-01 16:48:05 +02:00
2026-06-01 16:48:05 +02:00
2026-06-03 14:34:01 +08:00
2026-06-03 14:34:01 +08:00
2026-06-03 19:12:14 +08:00
2026-06-03 19:12:14 +08:00
2026-06-03 19:12:14 +08:00
2026-06-03 19:12:14 +08:00
2026-06-05 13:46:26 +08:00
2026-06-05 13:46:26 +08:00
2026-06-04 11:21:51 +08:00
2026-06-04 11:21:51 +08:00
2026-06-04 11:21:51 +08:00
2026-06-04 11:21:51 +08:00
2026-06-05 16:03:13 +08:00
2026-06-05 16:03:13 +08:00
2026-06-08 19:29:57 +08:00
2026-06-09 19:59:20 +08:00
2026-06-09 19:59:20 +08:00
2026-06-09 19:59:20 +08:00
2026-06-12 15:53:55 +08:00
2026-06-12 15:53:55 +08:00
2026-06-18 13:33:14 +08:00
2026-06-18 13:33:14 +08:00
2026-06-17 15:18:44 +02:00
2026-06-18 13:33:14 +08:00
2026-06-17 12:26:25 +08:00
2026-06-17 12:26:25 +08:00
2026-06-17 11:32:55 +08:00
2026-06-17 11:32:55 +08:00
2026-06-17 18:23:46 +08:00
2026-06-17 18:23:46 +08:00
2026-06-22 13:34:40 +08:00
2026-06-22 13:34:40 +08:00
2026-06-23 13:17:13 +08:00
2026-06-23 13:17:13 +08:00
2026-06-23 00:14:42 +08:00
2026-06-23 00:14:42 +08:00
2026-06-24 12:01:10 +08:00
2026-06-24 12:01:10 +08:00
2026-06-24 12:46:20 +08:00
2026-06-24 18:18:06 +08:00
2026-06-23 16:19:16 +08:00
2026-06-23 16:19:16 +08:00
2026-06-23 16:19:16 +08:00
2026-06-23 16:19:16 +08:00
2026-06-24 15:15:42 +08:00
2026-06-24 15:15:42 +08:00
2026-07-05 13:30:18 +08:00
2026-07-05 13:30:18 +08:00
2026-06-26 16:01:33 +08:00
2026-06-26 16:01:33 +08:00
2026-07-03 14:18:43 +08:00
2026-07-03 14:18:43 +08:00
2026-07-03 14:18:43 +08:00
2026-07-03 14:18:43 +08:00
2026-06-30 12:29:11 +08:00
2026-06-30 12:29:11 +08:00
2026-06-30 12:24:57 +08:00
2026-06-30 12:24:57 +08:00
2026-07-03 14:18:43 +08:00
2026-07-03 14:18:43 +08:00
2026-07-03 14:18:43 +08:00
2026-07-03 14:18:43 +08:00
2026-07-01 15:20:22 +08:00
2026-07-01 15:20:22 +08:00
2026-07-03 14:18:43 +08:00
2026-07-03 14:18:43 +08:00
2026-07-02 17:21:50 +08:00
2026-07-02 17:21:50 +08:00
2026-07-04 23:16:01 +08:00
2026-07-04 23:16:01 +08:00
2026-07-06 19:06:53 +08:00
2026-07-06 19:06:53 +08:00
2026-07-06 15:03:17 +08:00
2026-07-06 15:03:17 +08:00
2026-07-06 19:06:53 +08:00
2026-07-06 19:06:53 +08:00
2026-07-06 19:06:53 +08:00
2026-07-06 19:06:53 +08:00
2026-07-06 19:06:53 +08:00
2026-07-06 19:06:53 +08:00
2026-07-06 19:06:53 +08:00
2026-07-06 19:06:53 +08:00
2026-07-06 19:06:53 +08:00
2026-07-06 19:06:53 +08:00
2026-07-06 19:06:53 +08:00
2026-07-06 19:06:53 +08:00
2026-07-07 13:20:30 +08:00
2026-07-07 13:20:30 +08:00
2026-07-07 13:20:30 +08:00
2026-07-07 13:20:30 +08:00
2026-07-08 16:00:17 +08:00
2026-07-08 16:00:17 +08:00
2026-07-09 15:10:09 +08:00
2026-07-09 15:10:09 +08:00
2026-07-09 17:59:19 +08:00
2026-07-09 17:59:19 +08:00
2026-07-09 17:59:19 +08:00
2026-07-09 17:59:19 +08:00
2026-07-09 17:59:19 +08:00
2026-07-09 17:59:19 +08:00
2026-07-09 17:59:19 +08:00
2026-07-09 17:59:19 +08:00
2026-07-09 17:59:19 +08:00
2026-07-09 17:59:19 +08:00
2026-07-09 17:59:19 +08:00
2026-07-09 17:59:19 +08:00
2026-07-09 17:59:19 +08:00
2026-07-09 17:59:19 +08:00
2026-07-10 14:10:10 +08:00
2026-07-10 14:10:10 +08:00
2026-07-10 16:22:42 +08:00
2026-07-10 16:22:42 +08:00
2026-07-10 16:22:42 +08:00
2026-07-10 16:22:42 +08:00
2026-07-10 16:22:42 +08:00
2026-07-10 16:22:42 +08:00
2026-07-12 02:53:17 +08:00
2026-07-12 02:53:17 +08:00
2026-07-12 03:46:08 +08:00
2026-07-12 03:46:08 +08:00
2026-07-12 15:40:10 +08:00
2026-07-12 15:40:10 +08:00
2026-07-13 11:09:50 +08:00
2026-07-13 15:33:52 +08:00
2026-07-13 11:09:50 +08:00
2026-07-13 11:09:50 +08:00
2026-07-13 13:22:02 +08:00
2026-07-13 13:22:02 +08:00