diff options
| author | Roman Chvanikov <chvanikoff@pm.me> | 2020-05-13 19:56:40 +0300 |
|---|---|---|
| committer | Roman Chvanikov <chvanikoff@pm.me> | 2020-05-13 19:56:40 +0300 |
| commit | 8a383707ae143ba47fa1ba68da20bc6bec425126 (patch) | |
| tree | f05d4fd3ea7b52de7a37a2e625de18ba6af14b90 /priv/repo/migrations | |
| parent | f3f8ed9e19f1ab8863141ba8b31773c54f4771fb (diff) | |
| parent | da550be066a15108ceef7874c3b2549c049a7f88 (diff) | |
| download | pleroma-8a383707ae143ba47fa1ba68da20bc6bec425126.tar.gz pleroma-8a383707ae143ba47fa1ba68da20bc6bec425126.zip | |
Merge develop
Diffstat (limited to 'priv/repo/migrations')
| -rw-r--r-- | priv/repo/migrations/20200415181818_update_markers.exs | 12 | ||||
| -rw-r--r-- | priv/repo/migrations/20200428221338_insert_skeletons_for_deleted_users.exs | 2 |
2 files changed, 9 insertions, 5 deletions
diff --git a/priv/repo/migrations/20200415181818_update_markers.exs b/priv/repo/migrations/20200415181818_update_markers.exs index 976363565..bb9d8e860 100644 --- a/priv/repo/migrations/20200415181818_update_markers.exs +++ b/priv/repo/migrations/20200415181818_update_markers.exs @@ -32,9 +32,13 @@ defmodule Pleroma.Repo.Migrations.UpdateMarkers do |> Map.put_new(:updated_at, now) end) - Repo.insert_all("markers", markers_attrs, - on_conflict: {:replace, [:last_read_id]}, - conflict_target: [:user_id, :timeline] - ) + markers_attrs + |> Enum.chunk_every(1000) + |> Enum.each(fn markers_attrs_chunked -> + Repo.insert_all("markers", markers_attrs_chunked, + on_conflict: {:replace, [:last_read_id]}, + conflict_target: [:user_id, :timeline] + ) + end) end end diff --git a/priv/repo/migrations/20200428221338_insert_skeletons_for_deleted_users.exs b/priv/repo/migrations/20200428221338_insert_skeletons_for_deleted_users.exs index 11d9a70ba..2adc38186 100644 --- a/priv/repo/migrations/20200428221338_insert_skeletons_for_deleted_users.exs +++ b/priv/repo/migrations/20200428221338_insert_skeletons_for_deleted_users.exs @@ -30,7 +30,7 @@ defmodule Pleroma.Repo.Migrations.InsertSkeletonsForDeletedUsers do Repo, "select distinct unnest(nonexistent_locals.recipients) from activities, lateral (select array_agg(recipient) as recipients from unnest(activities.recipients) as recipient where recipient similar to '#{ instance_uri - }/users/[A-Za-z0-9]*' and not(recipient in (select ap_id from users where local = true))) nonexistent_locals;", + }/users/[A-Za-z0-9]*' and not(recipient in (select ap_id from users))) nonexistent_locals;", [], timeout: :infinity ) |
