I am facing a critical issue in high volume n8n workflow that’s disrupting our order from processing system :
We observed failures like workflow ls suddenly hang in running state for a long time and give this error of
[ postgresSQL Error: SQLSTATE[55P03] - could not obtaine lock on row in relation "oders "
I i checked n8n logs but it is only showing generic lock timeout
Secondly also simplified test workflow and problem still persist with just the Update Node
How can we immediately unlock the stuck workflow without restarting n8n and what is the proper way to handle row-level locking for high-throughput workflows