How to fix SharePoint 2013 Designer list workflows on pages libraries that automatically get cancelled with HTTP 500 exception

What?

List workflows that are built using SharePoint 2013 Designer on pages libraries in SharePoint 2013 get cancelled automatically with internal status "Cancelled" as shown below: