move all in cursor query by rdsadmin blocking complete postgres RDS

0

Now and then I experience a performance/stability problem on our postgres RDS, which seems to be caused by a query from the ***rdsadmin ***user, on the ***rdsadmin ***database. The query in question is "move all in "query-cursor_1", and it has the effect to basically block all other operations on the RDS instance (on any database). Usually it takes around 3 minutes to complete, and then the system recovers. However, I have also seen instances where this query triggers an OOM error by postmaster (resulting in aborting all other queries currently running + a restart of the database system). I would like to understand what this query actually does, and why it is executed by the rdsadmin user (and at which moments it is executed).

3 Risposte
0

I don't have a solution but would like to report the exact same problem happening on a db.m7g.xlarge db at my company. There was little to no activity on the part of applications at the time that this happened, and we are suspecting that it happened many times before as we've witnessed OOM in logs before but thought our applications were at fault. We're opening up support tickets to enquire and hopefully prevent this from happening again.

Cyril
con risposta 5 mesi fa
0

Guys,

Our team member found out the root-cause for this. Enabling "Performance insights" is causing the issue... lol... Just disable it and you wont have this problem. But yeah, you lose the ability to inspect query related issues.....

Ideally - If you can ask AWS to run this query during lean times, I think it would be helpful. But I dont know if thats possible.

con risposta 2 mesi fa
0

Hi,

thanks for the information, we do have performance insights enabled on our instance so it could explain indeed. However looking at the usefulness of this feature, I guess we'll need to live with this (occasional) issue for now .. hopefully AWS can address this at some point in time if enough users complain.

Wkr, Bert

con risposta 2 mesi fa

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande