diff options
| author | href <href@random.sh> | 2019-01-21 13:10:48 +0100 |
|---|---|---|
| committer | href <href@random.sh> | 2019-01-23 11:26:37 +0100 |
| commit | 465fb4327dab5eccdb8b88d6da5670007bd7110e (patch) | |
| tree | 4ef9a354e817d71f191677f6d13e5ef3d31c8cc3 | |
| parent | 973c9eed18b2e69c6dd43eacaa040cfeabc772bc (diff) | |
| download | pleroma-465fb4327dab5eccdb8b88d6da5670007bd7110e.tar.gz | |
Lock activities/users table during flake migration.
| -rw-r--r-- | priv/repo/migrations/20181218172826_users_and_activities_flake_id.exs | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/priv/repo/migrations/20181218172826_users_and_activities_flake_id.exs b/priv/repo/migrations/20181218172826_users_and_activities_flake_id.exs index 6e5dfaa77..39d45f7e8 100644 --- a/priv/repo/migrations/20181218172826_users_and_activities_flake_id.exs +++ b/priv/repo/migrations/20181218172826_users_and_activities_flake_id.exs @@ -15,6 +15,10 @@ defmodule Pleroma.Repo.Migrations.UsersAndActivitiesFlakeId do #execute "update activities set external_id = CAST( LPAD( TO_HEX(id), 32, '0' ) AS uuid);" #execute "update users set external_id = CAST( LPAD( TO_HEX(id), 32, '0' ) AS uuid);" + # Lock both tables to avoid a running server to meddling with our transaction + execute "LOCK TABLE activities;" + execute "LOCK TABLE users;" + execute "ALTER TABLE activities DROP CONSTRAINT activities_pkey CASCADE;" execute "ALTER TABLE users DROP CONSTRAINT users_pkey CASCADE;" |