From 44d00065cfbd0f24d2fac631608a5aeaace648a7 Mon Sep 17 00:00:00 2001 From: Christopher Baines Date: Thu, 8 Apr 2021 20:34:11 +0100 Subject: Fix the foreign key constraint on setup_failure_missing_inputs It was broken in a previous migration. --- sqitch/pg/deploy/fix_setup_failure_missing_inputs.sql | 7 +++++++ sqitch/pg/revert/fix_setup_failure_missing_inputs.sql | 7 +++++++ sqitch/pg/verify/fix_setup_failure_missing_inputs.sql | 7 +++++++ sqitch/sqitch.plan | 1 + sqitch/sqlite/deploy/fix_setup_failure_missing_inputs.sql | 14 ++++++++++++++ sqitch/sqlite/revert/fix_setup_failure_missing_inputs.sql | 7 +++++++ sqitch/sqlite/verify/fix_setup_failure_missing_inputs.sql | 7 +++++++ 7 files changed, 50 insertions(+) create mode 100644 sqitch/pg/deploy/fix_setup_failure_missing_inputs.sql create mode 100644 sqitch/pg/revert/fix_setup_failure_missing_inputs.sql create mode 100644 sqitch/pg/verify/fix_setup_failure_missing_inputs.sql create mode 100644 sqitch/sqlite/deploy/fix_setup_failure_missing_inputs.sql create mode 100644 sqitch/sqlite/revert/fix_setup_failure_missing_inputs.sql create mode 100644 sqitch/sqlite/verify/fix_setup_failure_missing_inputs.sql diff --git a/sqitch/pg/deploy/fix_setup_failure_missing_inputs.sql b/sqitch/pg/deploy/fix_setup_failure_missing_inputs.sql new file mode 100644 index 0000000..47b89bb --- /dev/null +++ b/sqitch/pg/deploy/fix_setup_failure_missing_inputs.sql @@ -0,0 +1,7 @@ +-- Deploy guix-build-coordinator:fix_setup_failure_missing_inputs to pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/pg/revert/fix_setup_failure_missing_inputs.sql b/sqitch/pg/revert/fix_setup_failure_missing_inputs.sql new file mode 100644 index 0000000..d5f7003 --- /dev/null +++ b/sqitch/pg/revert/fix_setup_failure_missing_inputs.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:fix_setup_failure_missing_inputs from pg + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/pg/verify/fix_setup_failure_missing_inputs.sql b/sqitch/pg/verify/fix_setup_failure_missing_inputs.sql new file mode 100644 index 0000000..3f5263a --- /dev/null +++ b/sqitch/pg/verify/fix_setup_failure_missing_inputs.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:fix_setup_failure_missing_inputs on pg + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; diff --git a/sqitch/sqitch.plan b/sqitch/sqitch.plan index af81ea8..f9e28fd 100644 --- a/sqitch/sqitch.plan +++ b/sqitch/sqitch.plan @@ -31,3 +31,4 @@ add_dynamic_auth_tokens 2021-02-28T15:21:24Z Christopher Baines # Use numeric primary keys fix_allocated_builds 2021-03-30T08:19:18Z Christopher Baines # Fix allocated_builds fix_allocated_builds_attempt_2 2021-03-30T08:27:18Z Christopher Baines # Fix allocated_builds +fix_setup_failure_missing_inputs 2021-04-08T19:31:49Z Christopher Baines # Fix setup_failure_missing_inputs diff --git a/sqitch/sqlite/deploy/fix_setup_failure_missing_inputs.sql b/sqitch/sqlite/deploy/fix_setup_failure_missing_inputs.sql new file mode 100644 index 0000000..4997bde --- /dev/null +++ b/sqitch/sqlite/deploy/fix_setup_failure_missing_inputs.sql @@ -0,0 +1,14 @@ +-- Deploy guix-build-coordinator:fix_setup_failure_missing_inputs to sqlite + +BEGIN; + +DELETE FROM setup_failures WHERE failure_reason = 'setup_failure'; + +DROP TABLE setup_failure_missing_inputs; + +CREATE TABLE setup_failure_missing_inputs ( + setup_failure_id INTEGER NOT NULL REFERENCES setup_failures (id), + missing_input_store_path TEXT NOT NULL +); + +COMMIT; diff --git a/sqitch/sqlite/revert/fix_setup_failure_missing_inputs.sql b/sqitch/sqlite/revert/fix_setup_failure_missing_inputs.sql new file mode 100644 index 0000000..7470b2e --- /dev/null +++ b/sqitch/sqlite/revert/fix_setup_failure_missing_inputs.sql @@ -0,0 +1,7 @@ +-- Revert guix-build-coordinator:fix_setup_failure_missing_inputs from sqlite + +BEGIN; + +-- XXX Add DDLs here. + +COMMIT; diff --git a/sqitch/sqlite/verify/fix_setup_failure_missing_inputs.sql b/sqitch/sqlite/verify/fix_setup_failure_missing_inputs.sql new file mode 100644 index 0000000..b05aeea --- /dev/null +++ b/sqitch/sqlite/verify/fix_setup_failure_missing_inputs.sql @@ -0,0 +1,7 @@ +-- Verify guix-build-coordinator:fix_setup_failure_missing_inputs on sqlite + +BEGIN; + +-- XXX Add verifications here. + +ROLLBACK; -- cgit v1.2.3