Page MenuHomePhabricator

Limit postgres query execution time for Kartotherian role
Closed, ResolvedPublic

Description

Kartotherian Postgress role should have a query limit to prevent accidental overuse of the DB. Tilerator uses a different role, so tile generation won't be affected:

ALTER ROLE kartotherian SET statement_timeout = 10000;  -- 10 seconds should be enough, right?

Event Timeline

Restricted Application added subscribers: Zppix, Aklapper. · View Herald Transcript

Change 295548 had a related patch set uploaded (by Yurik):
Maps: Limit query exec time for kartotherian user

https://gerrit.wikimedia.org/r/295548

Change 295548 merged by Gehel:
Maps: Limit query exec time for kartotherian user

https://gerrit.wikimedia.org/r/295548

Yurik claimed this task.

Mentioned in SAL [2016-06-30T19:42:15Z] <gehel> activating statement timeout limitations for kartotherian on maps cluster codfw (T138422)