Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[BUG] Akka.Persistence.PostgreSql does not support writerUUID field #149

Open
Aaronontheweb opened this issue Jun 16, 2022 · 0 comments
Open

Comments

@Aaronontheweb
Copy link
Member

Version Information
Version of Akka.NET? 1.4.35
Which Akka.NET Modules? Akka.Persistence.PostgreSql

Describe the bug

Related: akkadotnet/akka.net#3811

Since Akka.Persistrence.PostgreSql does its own thing with serialization, the writerUUID column was never added to it. Thus we don't have an easy way of debugging scenarios where multiple nodes are all attempting to write to the same entity. I have this exact problem with a user right now where it appears as though multiple separate users are competing for the same journal entries for the same entity.

To fix this, we're going to need to either:

  1. Update the DDL and table schema - adding a new field.
  2. Change the serialization system for Akka.Persistence.PostgreSql to include this data and avoid a schema migration.

cc @to11mtm should we just ditch this and go with Linq2Db? I'm starting to get that impression.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant