You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@rocketmq.apache.org by "Aias00 (via GitHub)" <gi...@apache.org> on 2026/08/16 14:49:36 UTC

[I] [Studio][Bug] Stabilize and cache persisted audit queries [rocketmq-dashboard]

Aias00 opened a new issue, #2269:
URL: https://github.com/apache/rocketmq-dashboard/issues/2269

   ## Problem
   
   The persisted audit page orders only by `operated_at`. The schema uses second-precision timestamps, so records written in the same second have no deterministic tie-breaker and may move across page boundaries.
   
   The filter-options endpoint also executes an unbounded grouped query across the entire audit table on every request. As audit retention grows, repeatedly opening the filter UI can issue expensive duplicate work.
   
   ## Expected behavior
   
   - Audit pages use a stable secondary order by primary key.
   - Filter options are cached briefly and invalidated when a new audit record is written.
   - The filter response remains complete for the configured retention window and does not change its API contract.
   
   ## Scope
   
   Track 1 audit-log persistence and query behavior.
   
   ## Acceptance criteria
   
   - Equal timestamps are ordered by descending ID.
   - Repeated filter-option reads reuse a bounded-TTL cache.
   - Saving an audit record invalidates the cache.
   - Focused repository tests cover ordering and cache invalidation.


-- 
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: commits-unsubscribe@rocketmq.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Re: [I] [Studio][Bug] Stabilize and cache persisted audit queries [rocketmq-dashboard]

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

   This issue has been automatically closed because there has been no activity for 7 days. If you believe this issue is still relevant, please reopen it with updated information.


-- 
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: commits-unsubscribe@rocketmq.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Re: [I] [Studio][Bug] Stabilize and cache persisted audit queries [rocketmq-dashboard]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] closed issue #2269: [Studio][Bug] Stabilize and cache persisted audit queries
URL: https://github.com/apache/rocketmq-dashboard/issues/2269


-- 
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: commits-unsubscribe@rocketmq.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Re: [I] [Studio][Bug] Stabilize and cache persisted audit queries [rocketmq-dashboard]

Posted by "RockteMQ-AI (via GitHub)" <gi...@apache.org>.
RockteMQ-AI commented on issue #2269:
URL: https://github.com/apache/rocketmq-dashboard/issues/2269#issuecomment-5308120594

   **Issue Evaluation**
   
   Category: `bug` | Status: **Confirmed**
   
   The reported issue has been verified against the current codebase.
   
   **Root Cause:** Persisted audit queries lack caching and stabilization, causing repeated expensive queries and inconsistent results.
   **Impact:** Performance and reliability of audit query functionality.
   **Severity:** Medium
   
   Adding caching and stabilization for persisted audit queries will improve both performance and consistency. An automated fix proposal can be generated. Reply `/approve` to proceed with PR generation.
   
   ---
   *Automated evaluation by github-manager-bot*
   


-- 
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: commits-unsubscribe@rocketmq.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org