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:10 UTC

[I] [BUG] — `mock_request_record.selectByQuery`: fetches `body`/`header`/`query` large columns + no pagination + no indexes [shenyu]

Aias00 opened a new issue, #6808:
URL: https://github.com/apache/shenyu/issues/6808

   - severity: Medium; files: `mappers/mock-request-record-sqlmap.xml:45-67`; service `MockRequestRecordServiceImpl.java:83-86` (no `@Pageable`)
   - description: `Base_Column_List` includes `body` (TEXT), `header`/`query`/`url` (varchar 1024) for a list query; `mock_request_record` has only PK (`schema.sql:134-147`); no index on `api_id`/`host`/`url`.
   - impact: Listing transfers the full request body for every row and scans the whole table per filter.
   - suggested_fix: Add `@Pageable`; add index on `api_id`; drop `body` from the list column list.
   - 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] — `mock_request_record.selectByQuery`: fetches `body`/`header`/`query` large columns + no pagination + no indexes [shenyu]

Posted by "Aias00 (via GitHub)" <gi...@apache.org>.
Aias00 closed issue #6808: [BUG] — `mock_request_record.selectByQuery`: fetches `body`/`header`/`query` large columns + no pagination + no indexes
URL: https://github.com/apache/shenyu/issues/6808


-- 
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] — `mock_request_record.selectByQuery`: fetches `body`/`header`/`query` large columns + no pagination + no indexes [shenyu]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #6808:
URL: https://github.com/apache/shenyu/issues/6808#issuecomment-5161323035

   👋 Hello @yuluo-yx
   
   A new issue has been opened by @Aias00:
   - **Title**: [BUG] — `mock_request_record.selectByQuery`: fetches `body`/`header`/`query` large columns + no pagination + no indexes
   - **Link**: https://github.com/apache/shenyu/issues/6808
   
   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