Project

General

Profile

Idea #4445

Idea to prevent long queries from GUI/API

Added by Randy Reitz over 6 years ago. Updated over 6 years ago.

Status:
New
Priority:
Normal
Assignee:
-
Start date:
07/29/2013
Due date:
% Done:

0%

Estimated time:
Duration:

Description

based on this:
http://stackoverflow.com/questions/5421776/how-can-i-limit-database-query-time-during-web-requests

1) create Linux accounts for ncis_gui and ncis_api
2) use these accounts to own the WSGI processes (rather than account ncis)
3) In postgres account, run a cron job to look for
long connections for these accounts and kill the backend if found.

History

#1 Updated by Randy Reitz over 6 years ago

  • Subject changed from Idea to prevent log queries from GUI/API to Idea to prevent long queries from GUI/API


Also available in: Atom PDF