Resolve "task handler stopped working because postgres connection was marked as broken"

Closes #1981 (closed), #1976 (closed), #1972 (closed), #1982 (closed)