Break the connection when sync cancellation fails

[vonzshik]

Closes #3187

It's a little bit on an experimental side so feel free to judge 😃

[roji]

@vonzshik thanks for all the answers, everything looks good from my side - but let's unify the tests to reduce duplication/complexity.