Btcpayserver: Adding comment on wallet transactions causes 500 error

[ghost]

Describe the problem/bug
I updated to the latest release. Now when I try to comment on a transaction in a wallet, it gives error 500.
Strangely, if you try to add a Label first and then a comment, it works fine.

Your environment

• Version of BTCPay Server: latest
• Deployment method: Lunanode

Logs (if applicable)
Basic logs can be found in Server Settings > Logs.

To Reproduce
Steps to reproduce the behavior:

1. Go to Wallets->Transactions
2. Click on Speech Bubble and write something
3. Click on Save Comment
4. See error 500 as bellow

Expected behavior
Should save the comment?

Actual behavior
Produced error 500

Screenshots/Links

Additional context
If you try to add a Label first and then a comment, it works fine.

[bolatovumar]

Looks like an Entity Framework issue again. I looked into it but I can't figure it out as I don't know EF well enough. And now I can't even repro it since adding a label once to any transaction seems to fix it.

The error that gets thrown is exactly the same as this one: https://stackoverflow.com/questions/43359631/entity-framework-core-error-postgres-violates-foreign-key-constraint

[britttttk]

I'm able to reproduce this issue as well.

[NicolasDorier]

on it