We have a running installation in our Kubernetes cluster, using the unofficial Helm chart. We are seeing some very high memory usage at times by the sentry.web workers, and we are wondering if there is something we can do to troubleshoot. We see it spiking to 10-11GB at times. Clicking around in t…

Yep! I think this is a different issue, though. Should I post about it here or should I start a new post?

I think we can continue here if the title aligns :slight_smile:

@dginther You mentioned having a lot of rows in your sentry_environmentproject table here: Extremely large initial download. Login takes 1+ minutes. What is this? - #7 by dginther Just for some context, you have over 10x rows that we have in our production system. I’m wondering if you’re using envi…

Yes, we have production, staging, dev, and a couple others, but for some reason, they are not unique in the database, so we have ~27 million ‘production’ environments. Would love to figure out what the schema needs to looks like for those to be unique, similar to how we had to do for the other table…

There should be a unique on your Environment table on (organization_id, name). If that is not in place, then you’ll likely have similar issues to the previous thread. Fixing this is a lot more complex. For each organization_id, name combo, you’ll need to select the min(id) as the Environment you wa…

Also, as a separate followup once you finish solving these immediate issues, I’d recommend you make a fresh install of a separate Sentry instance, dump the schema, and compare it to your existing Sentry install schema.

Figured I should ask, but would you be willing to take a look at the schema dump of our database to possibly help us move forward. I posted in the other thread started by dginther, but I have no knowledge of how this install got to where it is. Whatever happened occurred prior to my involvement he…

@mleclerc001 Unfortunately I don’t have time to look at a dump of your schema. I think your best option here is to use a schema comparision tool, dump the schema of your production database and compare it to the schema from a fresh sentry install. Then at least you can determine if any other indexes…

No worries @wedamija , figured it couldn’t hurt to ask. I was able to fix our environment issue using a similar method to the other thread we had open. Fortunately it was only our environmentproject table that was missing the index and not the environment table itself. Cleaning out the duplicates …

Memory usage of web workers

On-Premise

BYK July 26, 2021, 10:13am 2

Sorry we didn’t see this earlier. I guess this is now at least being looked into with Extremely large initial download. Login takes 1+ minutes. What is this? - #16 by wedamija ?

Topic		Replies	Views
Extremely large initial download. Login takes 1+ minutes. What is this? On-Premise	20	3210	September 1, 2021
Sentry performances and cleanup On-Premise	7	7317	August 30, 2018
Sentry consuming all CPU	3	5235	November 29, 2019
Large backlog of events.process_event and events.save_event On-Premise	8	3424	October 26, 2020
How to clear backlog and monitor it On-Premise	20	14906	January 14, 2021

Memory usage of web workers

Related topics