DEV-125 - Fix partial append on error append to stream #1095

Job	Run time
test / EventStore.Client.Streams/ubuntu-latest/net6.0/ci	9m 45s
test / EventStore.Client.PersistentSubscriptions/ubuntu-latest/net6.0/ci	8m 19s
test / EventStore.Client.Operations/ubuntu-latest/net6.0/ci	2m 42s
test / EventStore.Client.UserManagement/ubuntu-latest/net6.0/ci	2m 46s
test / EventStore.Client.ProjectionManagement/ubuntu-latest/net6.0/ci	1m 27s
test / EventStore.Client.Streams/ubuntu-latest/net7.0/ci	9m 30s
test / EventStore.Client.PersistentSubscriptions/ubuntu-latest/net7.0/ci	6m 48s
test / EventStore.Client.Operations/ubuntu-latest/net7.0/ci	2m 12s
test / EventStore.Client.UserManagement/ubuntu-latest/net7.0/ci	2m 33s
test / EventStore.Client.ProjectionManagement/ubuntu-latest/net7.0/ci	1m 28s
test / EventStore.Client.Streams/ubuntu-latest/net8.0/ci	9m 34s
test / EventStore.Client.PersistentSubscriptions/ubuntu-latest/net8.0/ci	6m 49s
test / EventStore.Client.Operations/ubuntu-latest/net8.0/ci	2m 24s
test / EventStore.Client.UserManagement/ubuntu-latest/net8.0/ci	2m 43s
test / EventStore.Client.ProjectionManagement/ubuntu-latest/net8.0/ci	1m 30s
	1h 10m 30s

Provide feedback