2021-09-20 11:34:24 next-db01 postgres[61668]: [37-1] 2021-09-20 11:34:24.823 EDT [61668] evergreen@evergreen ERROR:  deadlock detected
2021-09-20 11:34:24 next-db01 postgres[61668]: [37-2] 2021-09-20 11:34:24.823 EDT [61668] evergreen@evergreen DETAIL:  Process 61668 waits for AccessExclusiveLock on relation 17067 of database 16385; blocked by process 60847.
2021-09-20 11:34:24 next-db01 postgres[61668]: [37-3] #011Process 60847 waits for AccessShareLock on relation 17164 of database 16385; blocked by process 61668.
2021-09-20 11:34:24 next-db01 postgres[61668]: [37-4] #011Process 61668: /*
2021-09-20 11:34:24 next-db01 postgres[61668]: [37-5] #011do $$ begin
2021-09-20 11:34:24 next-db01 postgres[61668]: [37-6] #011    assert (
2021-09-20 11:34:24 next-db01 postgres[61668]: [37-7] #011        select count(*)
2021-09-20 11:34:24 next-db01 postgres[61668]: [37-8] #011        from actor.XXXX_usr_message
2021-09-20 11:34:24 next-db01 postgres[61668]: [37-9] #011        where id not in (
2021-09-20 11:34:24 next-db01 postgres[61668]: [37-10] #011            select id from actor.usr_message
2021-09-20 11:34:24 next-db01 postgres[61668]: [37-11] #011        )
2021-09-20 11:34:24 next-db01 postgres[61668]: [37-12] #011    ) = 0, 'failed migrating to actor.usr_message';
2021-09-20 11:34:24 next-db01 postgres[61668]: [37-13] #011end; $$;
2021-09-20 11:34:24 next-db01 postgres[61668]: [37-14]
2021-09-20 11:34:24 next-db01 postgres[61668]: [37-15] #011do $$ begin
2021-09-20 11:34:24 next-db01 postgres[61668]: [37-16] #011    assert (
2021-09-20 11:34:24 next-db01 postgres[61668]: [37-17] #011        select count(*)
2021-09-20 11:34:24 next-db01 postgres[61668]: [37-18] #011        from actor.XXXX_usr_standing_penalty
2021-09-20 11:34:24 next-db01 postgres[61668]: [37-19] #011        where id not in (
2021-09-20 11:34:24 next-db01 postgres[61668]: [37-20] #011            select id from actor.usr_standing_penalty
2021-09-20 11:34:24 next-db01 postgres[61668]: [37-21] #011        )
2021-09-20 11:34:24 next-db01 postgres[61668]: [37-22] #011    ) = 0, 'failed migrating to actor.usr_standing_penalty';
2021-09-20 11:34:24 next-db01 postgres[61668]: [37-23] #011end; $$;
2021-09-20 11:34:24 next-db01 postgres[61668]: [37-24] #011*/
2021-09-20 11:34:24 next-db01 postgres[61668]: [37-25]
2021-09-20 11:34:24 next-db01 postgres[61668]: [37-26] #011ALTER TABLE actor.usr DROP COLUMN alert_message CASCADE;
2021-09-20 11:34:24 next-db01 postgres[61668]: [37-27] #011Process 60847: SELECT * FROM action.hold_retarget_permit_test( '111', '111', '12864022', '1695487', '1695487' ) AS "action.hold_retarget_permit_test" ;
2021-09-20 11:34:24 next-db01 postgres[61668]: [37-28] 2021-09-20 11:34:24.823 EDT [61668] evergreen@evergreen HINT:  See server log for query details.
2021-09-20 11:34:24 next-db01 postgres[61668]: [37-29] 2021-09-20 11:34:24.823 EDT [61668] evergreen@evergreen STATEMENT:  /*
2021-09-20 11:34:24 next-db01 postgres[61668]: [37-30] #011do $$ begin
2021-09-20 11:34:24 next-db01 postgres[61668]: [37-31] #011    assert (
2021-09-20 11:34:24 next-db01 postgres[61668]: [37-32] #011        select count(*)
2021-09-20 11:34:24 next-db01 postgres[61668]: [37-33] #011        from actor.XXXX_usr_message
2021-09-20 11:34:24 next-db01 postgres[61668]: [37-34] #011        where id not in (
2021-09-20 11:34:24 next-db01 postgres[61668]: [37-35] #011            select id from actor.usr_message
2021-09-20 11:34:24 next-db01 postgres[61668]: [37-36] #011        )
2021-09-20 11:34:24 next-db01 postgres[61668]: [37-37] #011    ) = 0, 'failed migrating to actor.usr_message';
2021-09-20 11:34:24 next-db01 postgres[61668]: [37-38] #011end; $$;
2021-09-20 11:34:24 next-db01 postgres[61668]: [37-39]
2021-09-20 11:34:24 next-db01 postgres[61668]: [37-40] #011do $$ begin
2021-09-20 11:34:24 next-db01 postgres[61668]: [37-41] #011    assert (
2021-09-20 11:34:24 next-db01 postgres[61668]: [37-42] #011        select count(*)
2021-09-20 11:34:24 next-db01 postgres[61668]: [37-43] #011        from actor.XXXX_usr_standing_penalty
2021-09-20 11:34:24 next-db01 postgres[61668]: [37-44] #011        where id not in (
2021-09-20 11:34:24 next-db01 postgres[61668]: [37-45] #011            select id from actor.usr_standing_penalty
2021-09-20 11:34:24 next-db01 postgres[61668]: [37-46] #011        )
2021-09-20 11:34:24 next-db01 postgres[61668]: [37-47] #011    ) = 0, 'failed migrating to actor.usr_standing_penalty';
2021-09-20 11:34:24 next-db01 postgres[61668]: [37-48] #011end; $$;
2021-09-20 11:34:24 next-db01 postgres[61668]: [37-49] #011*/
2021-09-20 11:34:24 next-db01 postgres[61668]: [37-50]
2021-09-20 11:34:24 next-db01 postgres[61668]: [37-51] #011ALTER TABLE actor.usr DROP COLUMN alert_message CASCADE;