akka / akka-persistence-r2dbc

https://doc.akka.io/docs/akka-persistence-r2dbc/current/index.html
Other
24 stars 17 forks source link

migration broken for updated state #552

Closed sebastian-alfers closed 2 months ago

sebastian-alfers commented 3 months ago

The current logic for storing and updating Durable State decides based on revision=1 to INSERT, otherwise to UPDATE.

This logic works for a production application but not for a migration where the state could come already with an updated revision which would cause an UPDATE query on the new table - which fails since there is no state to update.