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

Job	Run time
test / EventStore.Client.Streams/ubuntu-latest/net6.0/ci	8m 57s
test / EventStore.Client.PersistentSubscriptions/ubuntu-latest/net6.0/ci	7m 36s
test / EventStore.Client.Operations/ubuntu-latest/net6.0/ci	2m 29s
test / EventStore.Client.UserManagement/ubuntu-latest/net6.0/ci	3m 18s
test / EventStore.Client.ProjectionManagement/ubuntu-latest/net6.0/ci	2m 22s
test / EventStore.Client.Streams/ubuntu-latest/net7.0/ci	9m 33s
test / EventStore.Client.PersistentSubscriptions/ubuntu-latest/net7.0/ci	7m 0s
test / EventStore.Client.Operations/ubuntu-latest/net7.0/ci	2m 36s
test / EventStore.Client.UserManagement/ubuntu-latest/net7.0/ci	2m 40s
test / EventStore.Client.ProjectionManagement/ubuntu-latest/net7.0/ci	2m 58s
test / EventStore.Client.Streams/ubuntu-latest/net8.0/ci	9m 52s
test / EventStore.Client.PersistentSubscriptions/ubuntu-latest/net8.0/ci	9m 6s
test / EventStore.Client.Operations/ubuntu-latest/net8.0/ci	3m 55s
test / EventStore.Client.UserManagement/ubuntu-latest/net8.0/ci	2m 53s
test / EventStore.Client.ProjectionManagement/ubuntu-latest/net8.0/ci	1m 38s
	1h 16m 53s

Provide feedback