[SERVER-40805] Indicate the reason for replanning in the log file Created: 24/Apr/19  Updated: 29/Oct/23  Resolved: 06/Jan/20

Status: Closed
Project: Core Server
Component/s: Diagnostics, Querying
Affects Version/s: None
Fix Version/s: 4.2.6, 4.3.3, 4.0.19, 3.6.19

Type: Improvement Priority: Minor - P4
Reporter: Chris Harris Assignee: David Percy
Resolution: Fixed Votes: 2
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Backports
Depends
Documented
Related
Backwards Compatibility: Fully Compatible
Backport Requested:
v4.2, v4.0, v3.6
Sprint: Query 2019-11-04, Query 2019-11-18, Query 2019-12-16, Query 2019-12-30, Query 2020-01-13
Participants:

 Description   

As of the the query plan cache changes introduced in 3.0 via SERVER-15225, the database will monitor the performance of cached plans and can replan them if they are found to be less efficient than expected. Indication that this has occurred is present in the log file via the replanned:1 flag as of 3.2 via SERVER-18468. Replanning can also be triggered when the sort memory threshold is exceeded while using a cached plan.

The current replanned boolean flag recorded in the log file does not indicate which specific trigger caused the event. This can result in incorrect conclusions or additional steps to properly diagnose the situation.



 Comments   
Comment by Githook User [ 28/May/20 ]

Author:

{'name': 'David Percy', 'email': 'david.percy@mongodb.com', 'username': 'dpercy'}

Message: SERVER-40805 Indicate reason for replanning
Branch: v3.6
https://github.com/mongodb/mongo/commit/e3acf12767b9192e24a3b2bbd810e6b11a965ed6

Comment by Githook User [ 22/Apr/20 ]

Author:

{'name': 'David Percy', 'email': 'david.percy@mongodb.com', 'username': 'dpercy'}

Message: SERVER-40805 Indicate reason for replanning
Branch: v4.0
https://github.com/mongodb/mongo/commit/e5341d8f4f0b3f1a397ed3081ef01e80d395cbfb

Comment by Githook User [ 31/Mar/20 ]

Author:

{'name': 'David Percy', 'email': 'david.percy@mongodb.com', 'username': 'dpercy'}

Message: SERVER-40805 Indicate reason for replanning
Branch: v4.2
https://github.com/mongodb/mongo/commit/084ae4ef6a3d050ee8599d04d9bac3ed5b7369d9

Comment by Githook User [ 06/Jan/20 ]

Author:

{'name': 'David Percy', 'email': 'david.percy@mongodb.com', 'username': 'dpercy'}

Message: SERVER-40805 Indicate reason for replanning
Branch: master
https://github.com/mongodb/mongo/commit/d0671dc95e8144d5828343f7431715537945425b

Comment by Craig Homa [ 07/May/19 ]

We should also check if 4.2 fixes this.

Generated at Thu Feb 08 04:56:01 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.