PostHog / plugin-server

Service to process and save PostHog events, supporting JS/TS plugins at that
https://posthog.com
8 stars 5 forks source link

Repeated error in RDS logs #522

Closed joesaunderson closed 3 years ago

joesaunderson commented 3 years ago

In what situation are you experiencing subpar performance?

Our RDS logs are getting hammered by the same message every few seconds, not sure if this is a bug, or peformance related, but we're churning through logs and our metrics don't look great.

2021-07-30 11:00:06 UTC:10.0.10.6(54102):[9249]:ERROR: duplicate key value violates unique constraint "unique hash for each team"
2021-07-30 11:00:06 UTC:10.0.10.6(54102):[9249]:DETAIL: Key (team_id, hash)=(1, <HASH>) already exists.
2021-07-30 11:00:06 UTC:10.0.10.6(54102) [9249]:STATEMENT: INSERT INTO posthog_elementgroup (hash, team_id) VALUES ($1, $2) RETURNING *

How to reproduce

  1. Fire up a self hosted PostHog in AWS, on 1.27.0?

Environment

Additional context

N/A

Thank you for your performance issue report – we want PostHog to go supersonic!

joesaunderson commented 3 years ago

Looks like a duplicate of https://github.com/PostHog/posthog/issues/3878

Some extra context, this is spamming our logs and making it impossible to find actual issues.

macobo commented 3 years ago

cc @yakkomajuri worth adding to the backlog for plugin server or nooping? :)

yakkomajuri commented 3 years ago

Yeah I'll take a look at this!