Implement thread safety in eventstorage service module

While working on #4384 (closed) I have come across several peculiar issues that have led me to conclusion, that something is amiss in the implementation of eventstorage service and generally with implementation of event database access from Flask application directly via psycopg2.

I have found out that it is indeed not implemented in thread-safe manner.

assigned to @Jan_Mach

By Jan Mach on 2024-12-26T14:06:52

added C-Dev-DB Done 0% P4 S-New T-Bug labels

changed milestone to %2.6

Back Relation 'relates' from: 4384

Relation 'blocks' to: 7565

Relation 'blocks' to: 7590

Relation Relates - Bug 4384 Possibility of DoS by repeating long query

By Jan Mach on 2020-01-14T09:32:32

Let's solve by configuration+doc - if using Apache, use process based MPM, if WSGI, configure no threading.

If lack of threading bites us in the future, we'll go for more thorough solution.

By Pavel Kácha on 2020-01-16T09:37:19

changed milestone to %2.7

changed milestone to %2.8

changed milestone to %Backlog

changed milestone to %Future

unassigned @Jan_Mach

By Pavel Kácha on 2024-12-26T14:19:56

Relation Blocks - Bug 7590 /api/events/search sometimes crashes with TypeError: Expected 22 arguments, got 23

By Rajmund Hruška on 2022-06-09T13:08:29

So, the configuration was changed on mentat-hub. The only thing to do is to write some information to the documentation, right?

By Rajmund Hruška on 2022-06-09T13:10:48

added S-In Progress label and removed S-New label

changed milestone to %2.10

Relation Blocks - Bug 7565 Timeline falls flat on certain query

By Rajmund Hruška on 2022-06-09T13:11:33

Rajmund Hruska wrote in https://gitlab.cesnet.cz/709/migrace/homeproj/mentat-project-05/mentat-ng/-/issues/6191#note_199707:

So, the configuration was changed on mentat-hub. The only thing to do is to write some information to the documentation, right?

Right. And maybe explicitly fix this in our ansible roles (sigh).

By Pavel Kácha on 2022-06-10T06:22:05

And cuz I'm dork, I did set up mpm_worker instead of mpm_prefork. Sigh, corrected, let's watch it further.

By Pavel Kácha on 2022-06-28T11:22:04

assigned to @ph

By Pavel Kácha on 2024-12-26T14:19:57

Applied in changeset mentat-ng|538b7943.

By Pavel Kácha on 2022-08-02T07:59:42

added Done 100% S-Resolved labels and removed Done 0% S-In Progress labels

added S-Closed label and removed S-Resolved label

closed

marked this issue as related to #4384 (closed)

By Pavel Kácha on 2024-12-26T14:16:58

mentioned in issue #4384 (closed)

By Jan Mach on 2024-12-26T14:17:05