You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shenyu.apache.org by "Aias00 (via GitHub)" <gi...@apache.org> on 2026/08/03 01:14:14 UTC
[I] [BUG] — `alert_receiver.selectAll`: full cross-namespace scan loaded per alert dispatch [shenyu]
Aias00 opened a new issue, #6810:
URL: https://github.com/apache/shenyu/issues/6810
- severity: Low-Medium; files: `mappers/alert-receiver-sqlmap.xml:58-62` (and `Base_Column_List:53-56`, which omits `namespace_id`)
- description: `select * from alert_receiver` with no `WHERE`; `alert_receiver` has only PK. Every alert-dispatch evaluation loads all receivers (with ~20 varchar columns) into memory and matches `labels`/`levels`/`match_all` in Java.
- impact: Cost grows linearly with receiver count on every alert evaluation.
- suggested_fix: Push label/level matching into SQL with indexed columns or a join table; at minimum index `namespace_id` and filter by namespace when dispatching.
- confidence: High
---
_Identified during the 2026-08-02 deep re-scan; full list in [`docs/scan2-2026-08-02/06-medium-tiers.md`](docs/scan2-2026-08-02/06-medium-tiers.md)._
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shenyu.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [BUG] — `alert_receiver.selectAll`: full cross-namespace scan loaded per alert dispatch [shenyu]
Posted by "Aias00 (via GitHub)" <gi...@apache.org>.
Aias00 closed issue #6810: [BUG] — `alert_receiver.selectAll`: full cross-namespace scan loaded per alert dispatch
URL: https://github.com/apache/shenyu/issues/6810
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shenyu.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [BUG] — `alert_receiver.selectAll`: full cross-namespace scan loaded per alert dispatch [shenyu]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #6810:
URL: https://github.com/apache/shenyu/issues/6810#issuecomment-5161323604
👋 Hello @yuluo-yx
A new issue has been opened by @Aias00:
- **Title**: [BUG] — `alert_receiver.selectAll`: full cross-namespace scan loaded per alert dispatch
- **Link**: https://github.com/apache/shenyu/issues/6810
Please review when you have time. Thank you! 🙏
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shenyu.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org