Issue 11293
- Title
- Allow to specify database statement timeout on RPC calls
- Priority
- feature
- Status
- testing
- Nosy list
- nicoe, reviewbot
- Assigned to
- nicoe
- Keywords
- review
Created on 2022-03-02.16:15:42 by nicoe, last changed 2 months ago by reviewbot.
Messages
It could happen that a using a function field searcher numerous time on the search bar will result in a huge query that can take up to some hours and more importantly eat up all the memory and CPU dedicated to the database.
Thankfully postgres has an option available on the sessions: statement_timeout that allows to limit the time spent on each statement of the session.
The review implements this on the RPC level and adds it on search, search_count and on the global search.
I chose the delay somehow randomly.
| History | |||
|---|---|---|---|
| Date | User | Action | Args |
| 2022-09-24 12:16:31 | reviewbot | set | messages: + msg78290 |
| 2022-09-10 21:17:47 | reviewbot | set | messages: + msg77996 |
| 2022-07-07 10:46:08 | reviewbot | set | messages: + msg77289 |
| 2022-04-11 17:37:54 | reviewbot | set | messages: + msg75600 |
| 2022-03-30 16:33:44 | reviewbot | set | messages: + msg74856 |
| 2022-03-25 20:04:04 | reviewbot | set | messages: + msg74763 |
| 2022-03-14 19:38:23 | reviewbot | set | messages: + msg74546 |
| 2022-03-14 18:34:04 | reviewbot | set | messages: + msg74544 |
| 2022-03-02 16:41:28 | reviewbot | set | messages:
+ msg74393 nosy: + reviewbot |
| 2022-03-02 16:17:58 | nicoe | set | keyword:
+ review reviews: 366841002 |
Showing 10 items. Show all history (warning: this could be VERY long)