xml_cdr service stalled

[PrettyBrutalXperience-Guy]

Helloworld,

After reports of missing CDR (on 5.4) I restarted the xml_cdr service and it appeared to backfill, with the exception that the button to play recordings was missing from the backfiled records. This may be unique to my situation i move recordings to archive nightly, but in case it may help someone else or myself in the future the following is what helped restore play/download buttons for the recordings:

UPDATE v_xml_cdr c
SET
record_path = COALESCE(
j.json->'variables'->>'record_path',
j.json->'callflow'->0->'variables'->>'record_path',
j.json->'callflow'->0->'application'->'variables'->>'record_path'
),
record_name = COALESCE(
j.json->'variables'->>'record_name',
j.json->'callflow'->0->'variables'->>'record_name',
j.json->'callflow'->0->'application'->'variables'->>'record_name'
)
FROM v_xml_cdr_json j
WHERE c.xml_cdr_uuid = j.xml_cdr_uuid
AND (
c.record_path IS NULL OR c.record_path = '' OR
c.record_name IS NULL OR c.record_name = ''
);

Then a query to update record_path to point to the archive location instead of the original.