ReportPortal database becomes unstable and reporting almost fully stops except for small launches with approximately 1 test inside when the test_item.path field is exceeded the allowable "ltree" field type indexing limit (path length>=120 approximately, recursive nesting of the nested steps).
REINDEX INDEX pathgistidx and path_idx aren't helped.
The problem was fixed in service-api
module of version 5.10.0
(product release 23.2), where the maximum number of nested elements were programmatically limited.
After deletion of the data with long paths, and reindexing both indexes (pathgistidx and path_idx), the database becomes stable and ReportPortal is working properly.
{ "nvd_published_at": "2023-10-09T14:15:10Z", "cwe_ids": [ "CWE-770" ], "severity": "MODERATE", "github_reviewed": true, "github_reviewed_at": "2023-10-10T18:28:11Z" }