I am also getting this error on a workflow that was successfully running earlier.
PGS-220000 PostgreSQL error: ERROR: duplicate key value violates unique constraint "xtkworkflowtask_taskidentifier" DETAIL: Key (itaskidentifier, iworkflowid)=(177, 19286442) already exists.
I am using Adobe Campaign Standard.