Keep getting duplicate key value violates unique constraint from pgsql log

[jwjoel]

Describe the Bug

I am encountering a duplicate key value violates unique constraint error in the pgsql console 4-5 times per minute. My website receives 132k page views per day, and the frequency of this error seems to increase with higher traffic. The logs from Umami show no abnormalities.

Does this because of the race condition? Just wondering the potential impact of this issue. Thanks!

Database

PostgreSQL

Relevant log output

No response

Which Umami version are you using? (if relevant)

No response

Which browser are you using? (if relevant)

No response

How are you deploying your application? (if relevant)

Google Cloud Run

[andreacardelli]

Some here with both postgressql or mysql.

[mikecao]

It's a race condition issue with creating a session for a brand new visitor. We're considering moving this logic to the database so at least it won't clog up your logs.