[MAGNOLIA-8726] Setting magnolia.jcr.query.logging.thresholdMs might result in invalid queries Created: 30/Jan/23  Updated: 09/May/23  Resolved: 07/Feb/23

Status: Closed
Project: Magnolia
Component/s: None
Affects Version/s: 6.2.28
Fix Version/s: 6.3.0, 6.2.29

Type: Bug Priority: High
Reporter: Sergio Marino Assignee: Roman Kovařík
Resolution: Fixed Votes: 0
Labels: None
Σ Remaining Estimate: Not Specified Remaining Estimate: Not Specified
Σ Time Spent: Not Specified Time Spent: Not Specified
Σ Original Estimate: Not Specified Original Estimate: Not Specified

Issue Links:
causality
caused by MAGNOLIA-8503 Ability to log JCR queries Closed
relation
Sub-Tasks:
Key
Summary
Type
Status
Assignee
MAGNOLIA-8729 Implementation Sub-task Completed Roman Kovařík  
MAGNOLIA-8730 Rw Sub-task Completed Rabie Hayoun  
MAGNOLIA-8731 Preint QA Sub-task Completed Daniel Alonso  
MAGNOLIA-8732 QA (6.2) Sub-task Completed Adam Siska  
MAGNOLIA-8743 Provide patch to customer Sub-task Completed Roman Kovařík  
MAGNOLIA-8744 Test the patch Sub-task Closed  
Template:
Acceptance criteria:
Empty
Task DoD:
[X]* Doc/release notes changes? Comment present?
[X]* Downstream builds green?
[X]* Solution information and context easily available?
[X]* Tests
[X]* FixVersion filled and not yet released
[ ]  Architecture Decision Record (ADR)
Bug DoR:
[X]* Steps to reproduce, expected, and actual results filled
[X]* Affected version filled
Release notes required:
Yes
Date of First Response:
Epic Link: Nucleus Regular Maintenance
Sprint: Nucleus 29
Story Points: 2
Team: Nucleus
Work Started:

 Description   

Steps to reproduce

  1.  Setup DXCore 6.2.28 with workflow
    in magnolia.properties enable "Log JCR queries":
    > magnolia.jcr.query.logging.thresholdMs = 250
  2.  start mgnl, create a task
  3.  open tasks app

.. Logs, screenshots, gifs...

Expected results

Tasks app shows list of tasks

.. Justify non-trivial expectations with a link to a doc or a relevant discussion.

Actual results

Tasks app is displayed empty

Workaround

Remove 'magnolia.jcr.query.logging.thresholdMs = 250' from magnolia.properties and use only if needed and tasks app is not needed

Development notes

The way things are behaving, I think other queries might be affected as well.

Probably caused by https://jira.magnolia-cms.com/browse/MAGNOLIA-8503



 Comments   
Comment by Roman Kovařík [ 30/Jan/23 ]

Discovery:

Comment by Roman Kovařík [ 30/Jan/23 ]

6.2.28 Release notes update: https://git.magnolia-cms.com/projects/DOCUMENTATION/repos/product-docs/pull-requests/1396/overview cc abrooks 

Generated at Mon Feb 12 04:35:15 CET 2024 using Jira 9.4.2#940002-sha1:46d1a51de284217efdcb32434eab47a99af2938b.