Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Unable to access Alerts screen when there are millions of AlertEvents #9362

Closed
exalate-issue-sync bot opened this issue Nov 2, 2023 · 1 comment
Closed

Unable to access Alerts screen when there are millions of AlertEvents #9362

exalate-issue-sync bot opened this issue Nov 2, 2023 · 1 comment
Labels
project: APIM type: bug

Comments

@exalate-issue-sync
Copy link

exalate-issue-sync bot commented Nov 2, 2023 •
edited

Description

In an installation with millions of AlertEvents, accessing the API Alert screen is impossible as HTTP requests to fetch the data are super long or even end in timeout.

The issue comes from the DB requests to display the nb of alert events for the last 5 min, 1h, 1d, 1m. There are 4 non-optimize requests done sequentially and a missing index.
gaetanmaisse added a commit to gravitee-io/gravitee-api-management that referenced this issue Nov 2, 2023
@gaetanmaisse
fix: create a count method in AlertEvent repository and improve the w…
972ad9b 
…ay analytics are fetched in AlertService

https://gravitee.atlassian.net/browse/APIM-3190
gravitee-io/issues#9362
@gaetanmaisse gaetanmaisse mentioned this issue Nov 2, 2023
Merged
gaetanmaisse added a commit to gravitee-io/gravitee-api-management that referenced this issue Nov 3, 2023
@gaetanmaisse
fix: create a count method in AlertEvent repository and improve the w…
0583ec4 
…ay analytics are fetched in AlertService

https://gravitee.atlassian.net/browse/APIM-3190
gravitee-io/issues#9362
mergify bot pushed a commit to gravitee-io/gravitee-api-management that referenced this issue Nov 3, 2023
@gaetanmaisse @mergify
fix: create a count method in AlertEvent repository and improve the w…
7c2e84e 
…ay analytics are fetched in AlertService

https://gravitee.atlassian.net/browse/APIM-3190
gravitee-io/issues#9362
(cherry picked from commit 0583ec4)

# Conflicts:
#	gravitee-apim-repository/gravitee-apim-repository-mongodb/src/main/resources/scripts/create-index.js
mergify bot pushed a commit to gravitee-io/gravitee-api-management that referenced this issue Nov 3, 2023
@gaetanmaisse @mergify
fix: create a count method in AlertEvent repository and improve the w…
9747804 
…ay analytics are fetched in AlertService

https://gravitee.atlassian.net/browse/APIM-3190
gravitee-io/issues#9362
(cherry picked from commit 0583ec4)

# Conflicts:
#	gravitee-apim-repository/gravitee-apim-repository-mongodb/src/main/resources/scripts/create-index.js
mergify bot pushed a commit to gravitee-io/gravitee-api-management that referenced this issue Nov 3, 2023
@gaetanmaisse @mergify
fix: create a count method in AlertEvent repository and improve the w…
b51e44a 
…ay analytics are fetched in AlertService

https://gravitee.atlassian.net/browse/APIM-3190
gravitee-io/issues#9362
(cherry picked from commit 0583ec4)

# Conflicts:
#	gravitee-apim-repository/gravitee-apim-repository-mongodb/src/main/resources/scripts/create-index.js
mergify bot pushed a commit to gravitee-io/gravitee-api-management that referenced this issue Nov 3, 2023
@gaetanmaisse @mergify
fix: create a count method in AlertEvent repository and improve the w…
bf45485 
…ay analytics are fetched in AlertService

https://gravitee.atlassian.net/browse/APIM-3190
gravitee-io/issues#9362
(cherry picked from commit 0583ec4)

# Conflicts:
#	gravitee-apim-repository/gravitee-apim-repository-mongodb/src/main/resources/scripts/create-index.js
This was referenced Nov 3, 2023
Closed
Closed
Merged
gaetanmaisse added a commit to gravitee-io/gravitee-api-management that referenced this issue Nov 3, 2023
@gaetanmaisse
fix: create a count method in AlertEvent repository and improve the w…
549c382 
…ay analytics are fetched in AlertService

https://gravitee.atlassian.net/browse/APIM-3190
gravitee-io/issues#9362
(cherry picked from commit 0583ec4)

# Conflicts:
#	gravitee-apim-repository/gravitee-apim-repository-mongodb/src/main/resources/scripts/create-index.js
gaetanmaisse added a commit to gravitee-io/gravitee-api-management that referenced this issue Nov 3, 2023
@gaetanmaisse
fix: create a count method in AlertEvent repository and improve the w…
dffe669 
…ay analytics are fetched in AlertService

https://gravitee.atlassian.net/browse/APIM-3190
gravitee-io/issues#9362
(cherry picked from commit 0583ec4)

# Conflicts:
#	gravitee-apim-repository/gravitee-apim-repository-mongodb/src/main/resources/scripts/create-index.js
gaetanmaisse added a commit to gravitee-io/gravitee-api-management that referenced this issue Nov 3, 2023
@gaetanmaisse
fix: create a count method in AlertEvent repository and improve the w…
9ec293e 
…ay analytics are fetched in AlertService

https://gravitee.atlassian.net/browse/APIM-3190
gravitee-io/issues#9362
(cherry picked from commit 0583ec4)

# Conflicts:
#	gravitee-apim-repository/gravitee-apim-repository-mongodb/src/main/resources/scripts/create-index.js
gaetanmaisse added a commit to gravitee-io/gravitee-api-management that referenced this issue Nov 3, 2023
@gaetanmaisse
fix: create a count method in AlertEvent repository and improve the w…
09127fa 
…ay analytics are fetched in AlertService

https://gravitee.atlassian.net/browse/APIM-3190
gravitee-io/issues#9362
(cherry picked from commit 0583ec4)

# Conflicts:
#	gravitee-apim-repository/gravitee-apim-repository-mongodb/src/main/resources/scripts/create-index.js
mergify bot pushed a commit to gravitee-io/gravitee-api-management that referenced this issue Nov 3, 2023
@gaetanmaisse @mergify
fix: create a count method in AlertEvent repository and improve the w…
0a1a8f4 
…ay analytics are fetched in AlertService

https://gravitee.atlassian.net/browse/APIM-3190
gravitee-io/issues#9362
(cherry picked from commit 0583ec4)

# Conflicts:
#	gravitee-apim-repository/gravitee-apim-repository-mongodb/src/main/resources/scripts/create-index.js
(cherry picked from commit 09127fa)
mergify bot pushed a commit to gravitee-io/gravitee-api-management that referenced this issue Nov 3, 2023
@gaetanmaisse @mergify
fix: create a count method in AlertEvent repository and improve the w…
d0c8191 
…ay analytics are fetched in AlertService

https://gravitee.atlassian.net/browse/APIM-3190
gravitee-io/issues#9362
(cherry picked from commit 0583ec4)

# Conflicts:
#	gravitee-apim-repository/gravitee-apim-repository-mongodb/src/main/resources/scripts/create-index.js
(cherry picked from commit 09127fa)
This was referenced Nov 3, 2023
Merged
Merged
gaetanmaisse added a commit to gravitee-io/gravitee-api-management that referenced this issue Nov 3, 2023
@gaetanmaisse
fix: create a count method in AlertEvent repository and improve the w…
f234cc0 
…ay analytics are fetched in AlertService

https://gravitee.atlassian.net/browse/APIM-3190
gravitee-io/issues#9362
(cherry picked from commit 0583ec4)

# Conflicts:
#	gravitee-apim-repository/gravitee-apim-repository-mongodb/src/main/resources/scripts/create-index.js
(cherry picked from commit 09127fa)
gaetanmaisse added a commit to gravitee-io/gravitee-api-management that referenced this issue Nov 3, 2023
@gaetanmaisse
fix: create a count method in AlertEvent repository and improve the w…
656989c 
…ay analytics are fetched in AlertService

https://gravitee.atlassian.net/browse/APIM-3190
gravitee-io/issues#9362
(cherry picked from commit 0583ec4)

# Conflicts:
#	gravitee-apim-repository/gravitee-apim-repository-mongodb/src/main/resources/scripts/create-index.js
(cherry picked from commit 09127fa)
@exalate-issue-sync Exalate Issue Sync
Copy link
Author

This issue will be fixed in versions 4.0.12, 3.20.23, 4.2.0, 4.1.3

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
project: APIM type: bug
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
0 participants