Back to bug 2135782
| Who | When | What | Removed | Added |
|---|---|---|---|---|
| Shriya Mulay | 2022-10-18 12:24:12 UTC | CC | nbecker | |
| Flags | needinfo?(nbecker) | |||
| Colum Gaynor | 2022-10-19 04:52:03 UTC | CC | cgaynor | |
| Flags | needinfo?(nbecker) | |||
| Ashish Singh | 2022-10-19 05:25:27 UTC | CC | assingh | |
| Flags | needinfo?(nbecker) | |||
| Pedro Ibáñez | 2022-10-19 05:44:59 UTC | CC | pibanezr | |
| Danny | 2022-10-20 10:58:06 UTC | CC | dzaken | |
| Edu Alcaniz | 2022-10-21 07:49:37 UTC | Priority | unspecified | high |
| CC | ealcaniz | |||
| Ashish Singh | 2022-10-23 04:47:18 UTC | Flags | needinfo?(nbecker) needinfo?(dzaken) | |
| Danny | 2022-10-23 09:46:48 UTC | Flags | needinfo?(dzaken) | needinfo?(assingh) |
| Ashish Singh | 2022-10-28 10:06:18 UTC | Flags | needinfo?(assingh) | needinfo?(dzaken) |
| Danny | 2022-10-31 12:48:45 UTC | Flags | needinfo?(dzaken) | needinfo?(assingh) |
| Shriya Mulay | 2022-11-01 03:41:33 UTC | Flags | needinfo?(dzaken) | |
| Colum Gaynor | 2022-11-01 11:03:00 UTC | Flags | needinfo?(etamir) | |
| Bill Zvonar | 2022-11-01 19:35:00 UTC | CC | bzvonar | |
| Sunil Kumar Acharya | 2022-11-02 03:27:35 UTC | Flags | needinfo?(nbecker) | |
| Eran Tamir | 2022-11-02 05:35:54 UTC | Flags | needinfo?(etamir) | needinfo?(dzaken) |
| Danny | 2022-11-02 15:42:17 UTC | Flags | needinfo?(dzaken) needinfo?(dzaken) | needinfo?(assingh) needinfo?(smulay) |
| Ashish Singh | 2022-11-02 16:26:13 UTC | Flags | needinfo?(assingh) needinfo?(assingh) | |
| Nimrod Becker | 2022-11-03 08:24:31 UTC | Flags | needinfo?(nbecker) needinfo?(nbecker) needinfo?(nbecker) needinfo?(nbecker) needinfo?(nbecker) | |
| daniel | 2022-11-04 14:13:25 UTC | CC | dmoessne | |
| Flags | needinfo?(nbecker) needinfo?(dzaken) | |||
| Danny | 2022-11-06 10:58:38 UTC | Status | NEW | POST |
| Link ID | Github noobaa/noobaa-core/pull/7099 | |||
| Colum Gaynor | 2022-11-07 06:53:07 UTC | Flags | needinfo?(nbecker) needinfo?(etamir) | |
| Nimrod Becker | 2022-11-07 07:38:38 UTC | Flags | needinfo?(nbecker) needinfo?(nbecker) | |
| Danny | 2022-11-07 08:48:57 UTC | CC | kramdoss | |
| Flags | needinfo?(dzaken) | needinfo?(kramdoss) | ||
| Danny | 2022-11-07 12:40:30 UTC | Flags | needinfo?(kramdoss) | |
| Colum Gaynor | 2022-11-09 06:35:53 UTC | Flags | needinfo?(nbecker) needinfo?(etamir) | |
| krishnaram Karthick | 2022-11-09 13:31:48 UTC | Flags | needinfo?(kramdoss) needinfo?(kramdoss) | |
| RHEL Program Management | 2022-11-09 13:31:58 UTC | Target Release | --- | ODF 4.12.0 |
| Bipin Kunal | 2022-11-10 07:14:48 UTC | Blocks | 2141555 | |
| Bipin Kunal | 2022-11-10 07:24:27 UTC | CC | bkunal | |
| Danny | 2022-11-10 07:38:09 UTC | Link ID | Github noobaa/noobaa-core/pull/7100 | |
| Status | POST | MODIFIED | ||
| Bipin Kunal | 2022-11-10 07:57:39 UTC | Summary | [GSS] Listing object takes long time | [Backport to 4.11] [GSS] Listing object takes long time |
| Rejy M Cyriac | 2022-11-10 14:17:15 UTC | QA Contact | belimele | kramdoss |
| Mudit Agarwal | 2022-11-11 14:04:25 UTC | Fixed In Version | 4.12.0-100 | |
| CC | muagarwa | |||
| Summary | [Backport to 4.11] [GSS] Listing object takes long time | [Backport to 4.12] [GSS] Listing object takes long time | ||
| Flags | needinfo?(smulay) needinfo?(etamir) needinfo?(nbecker) needinfo?(etamir) | needinfo?(nbecker) | ||
| Danny | 2022-11-13 10:28:53 UTC | Doc Text | After investigating the latest logs\stats we suspect the list performance degradation is related to this PR https://github.com/noobaa/noobaa-core/pull/7044. This change affects the DB queries in such a way that for every list Postgres performs a sort of all object mds. This PR was backported to 4.10 but not 4.8, so it can explain the difference between the versions. @assingh@redhat.com @smulay@redhat.com was ODF upgraded from 4.8 or is it a new installation of 4.10? In any case, I can build a new test image with a fix to this sort bug to confirm this suspicion. Cause: After some indexes changes, for some list queries, Postgres performs a sort of all object mds Consequence: When there is a big number of object mds, the list operation takes a long time and can also timeout on the client side. Fix: Changed the related DB queries such that the query will be based on the new indexes and avoid the need to sort the data. Result: Db queries are completed in a reasonable time and the list performance is improved | |
| Doc Type | If docs needed, set a value | Bug Fix | ||
| Danny | 2022-11-13 10:29:24 UTC | Doc Text | After investigating the latest logs\stats we suspect the list performance degradation is related to this PR https://github.com/noobaa/noobaa-core/pull/7044. This change affects the DB queries in such a way that for every list Postgres performs a sort of all object mds. This PR was backported to 4.10 but not 4.8, so it can explain the difference between the versions. @assingh@redhat.com @smulay@redhat.com was ODF upgraded from 4.8 or is it a new installation of 4.10? In any case, I can build a new test image with a fix to this sort bug to confirm this suspicion. Cause: After some indexes changes, for some list queries, Postgres performs a sort of all object mds Consequence: When there is a big number of object mds, the list operation takes a long time and can also timeout on the client side. Fix: Changed the related DB queries such that the query will be based on the new indexes and avoid the need to sort the data. Result: Db queries are completed in a reasonable time and the list performance is improved | Cause: After some indexes changes, for some list queries, Postgres performs a sort of all object mds Consequence: When there is a big number of object mds, the list operation takes a long time and can also timeout on the client side. Fix: Changed the related DB queries such that the query will be based on the new indexes and avoid the need to sort the data. Result: Db queries are completed in a reasonable time and the list performance is improved |
| Nimrod Becker | 2022-11-15 07:59:18 UTC | Fixed In Version | 4.12.0-100 | 4.12.0-111 |
| Status | MODIFIED | ON_QA | ||
| Einat G | 2022-11-15 13:59:29 UTC | CC | eglottma | |
| Harish NV Rao | 2022-11-22 08:18:42 UTC | QA Contact | kramdoss | pbyregow |
| CC | hnallurv | |||
| Parikshith | 2022-11-25 17:56:27 UTC | Status | ON_QA | VERIFIED |
| Red Hat Bugzilla | 2022-12-31 19:04:47 UTC | QA Contact | pbyregow | kramdoss |
| Red Hat Bugzilla | 2022-12-31 20:04:39 UTC | CC | hnallurv | |
| Red Hat Bugzilla | 2023-01-01 08:29:55 UTC | CC | bkunal | |
| Red Hat Bugzilla | 2023-01-01 08:32:48 UTC | QA Contact | kramdoss | |
| CC | kramdoss | |||
| Alasdair Kergon | 2023-01-04 04:45:43 UTC | QA Contact | pbyregow | |
| Alasdair Kergon | 2023-01-04 05:07:00 UTC | CC | kramdoss | |
| Alasdair Kergon | 2023-01-04 06:09:44 UTC | CC | bkunal | |
| Alasdair Kergon | 2023-01-04 06:45:51 UTC | CC | hnallurv | |
| Red Hat Bugzilla | 2023-01-31 22:26:15 UTC | CC | dzaken | |
| Red Hat Bugzilla | 2023-01-31 22:27:20 UTC | CC | nbecker | |
| Assignee | nbecker | nobody | ||
| Red Hat Bugzilla | 2023-01-31 22:28:10 UTC | CC | etamir | |
| Rejy M Cyriac | 2023-02-08 14:06:28 UTC | Status | VERIFIED | CLOSED |
| Resolution | --- | CURRENTRELEASE | ||
| Last Closed | 2023-02-08 14:06:28 UTC | |||
| Prasad Desala | 2023-02-10 07:50:28 UTC | CC | tdesala | |
| Link ID | Github red-hat-storage/ocs-ci/pull/6499 | |||
| Nimrod Becker | 2023-04-17 06:42:27 UTC | Flags | needinfo?(nbecker) | |
| CC | nbecker | |||
| Elad | 2023-08-09 16:49:53 UTC | CC | odf-bz-bot |
Back to bug 2135782