in reference to the CUSTOM-ALERT DEADLOCK
written for repository SQL SERVER
This is for anyone needing it fixed for MySQL Aurora
code:
SELECT char(13) + char(10) +
'URL: SRVEFEVMDPA:8123/.../deadlockDetails.iwc' + CAST(DB_ID as CHAR) + '&dl_id=' + CAST(DB_ID as CHAR) + char(13) + char(10)
, 1
FROM (
SELECT #DBID# AS DB_ID, dl.*, dlo.name
FROM `smartx-dpa`.CON_DEADLOCK_#DBID# dl
LEFT OUTER JOIN `smartx-dpa`.CON_DEADLOCK_OBJ_#DBID# dlo ON (dl.ID = dlo.ID)
) dl
WHERE D > DATE_ADD(NOW(),INTERVAL -5 MINUTE);