Backend stuck in tirigger.c:afterTriggerInvokeEvents forever

I have a DO block that has a couple of inserts (copying large amounts
of data from staging tables) that I am passing to the server using
JDBC,

When I execute the inserts independently, they work fine. But when I
submit them as part of the do block, the backend goes into
trigger.c:afterTriggerInvokeEvents and never returns. This happens
after the second insert starts running.

I have tried this in version 11.7 and 12.2 (on both Linux and Windows).

I grabbed the source from git and did a Linux build (REL_12_STABLE)
and can see that the method in question just keeps looping through
'chunks' and 'events'. I disabled the user triggers on the table in
question and the 'events' seem to be various foreign key references
and other constraints.

I bumped the log level up to debug5 and can see rows in the first
table getting inserted. Sometimes I see a few rows for the second
table and sometimes I don't. After that there are no additional log
entries from the backend process. I have let the process run overnight
(the inserts take about 12 minutes to complete when run
independently).

Any tips about how to go about debugging this would be appreciated. I
am struggling to see exactly what the events are so maybe so
suggestions on the best place to add some logging?

Here is the DO block:

DO
$$
BEGIN
PERFORM XeP_set_identifier('xi_batch_user');

alter table xe_patient_visit disable trigger USER;
alter table xe_auth disable trigger USER;

RAISE NOTICE '% : inserting visits...', clock_timestamp();

INSERT INTO
xe_patient_visit
(
createtstamp,
creationuser,
modifiedtstamp,
modifieduser,
active,
visitid,
sourcesystem,
status,
visittypeid,
ipid,
accountid,
ivid
)
SELECT (now() AT TIME ZONE 'utc') AS createtstamp,
'xi_batch_user' AS creationuser,
(now() AT TIME ZONE 'utc') AS modifiedtstamp,
'xi_batch_user' AS modifieduser,
'y' AS active,
authorizationid AS visitid,
'staging' AS sourcesystem,
a.status,
'AUTH' AS visittypeid,
p.ipid,
e.accountid,
nextval('seq_xe_patient_visit') AS ivid
FROM (SELECT authorizationid,
memberid,
CASE
WHEN authorizationstatus = 'Fully Approved'
THEN 'AUTH_APPROVED'
WHEN authorizationstatus = 'Partially
Approved' THEN 'AUTH_REDUCED'
WHEN authorizationstatus = 'Voided' THEN
'AUTH_COMPLETED'
WHEN authorizationstatus = 'Incomplete' THEN
'AUTH_PEND'
WHEN authorizationstatus = 'Pending Decision'
THEN 'AUTH_PEND'
WHEN authorizationstatus = 'Denied' THEN
'AUTH_DENIED' END

AS status,
row_number() OVER (PARTITION BY authorizationid
ORDER BY authorizationid) AS rownum
FROM staging."authorization") a
JOIN xe_patient p ON p.patientid = a.memberid
JOIN xe_enterprise_data e ON e.accountid =
p.accountid AND e.enterpriseid = 'staging'
WHERE rownum = 1
ON CONFLICT (accountid, visitid)
DO NOTHING;

RAISE NOTICE '% : inserting auths...', clock_timestamp();
INSERT INTO
xe_auth
(
createtstamp,
creationuser,
modifiedtstamp,
modifieduser,
active,
accountid,
receiveddate,
authnum,
authtypeid,
authsubtypeid,
umurgencyid,
ivid
)
SELECT (now() AT TIME ZONE 'utc') AS createtstamp,
'xi_batch_user' AS creationuser,
(now() AT TIME ZONE 'utc') AS modifiedtstamp,
'xi_batch_user' AS modifieduser,
'y' AS active,
ed.accountid,
receiveddate,
authnum,
a.authtypeid,
at.authtypeid,
umurgencyid,
ivid
FROM (
SELECT cast(receiveddate AS timestamp) AS receiveddate,
authorizationid AS authnum,
CASE
WHEN authorizationcategory = 'Inpatient'
THEN 'AUTH_IPA'
ELSE 'AUTH_SVC' END AS authtypeid,
authorizationtype,
CASE
WHEN authorizationurgency = 'ROUTINE' THEN 'STD'
WHEN authorizationurgency = 'EXPEDITED' THEN 'EXP'
END
AS umurgencyid
FROM staging."authorization"
) a
JOIN xe_patient_visit v ON v.visitid = a.authnum
JOIN xe_enterprise_data ed ON ed.accountid =
v.accountid AND ed.enterpriseid = 'staging'
JOIN xe_auth_type at ON at.name = a.authorizationtype
ON CONFLICT (authnum, accountid)
DO NOTHING;

END
$$