Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

usp_AdaptiveIndexDefrag: incorrect duplicate objectId/objectName logged in tbl_AdaptiveIndexDefrag_log #288

Open
miksh7 opened this issue Nov 29, 2022 · 0 comments
Open

usp_AdaptiveIndexDefrag: incorrect duplicate objectId/objectName logged in tbl_AdaptiveIndexDefrag_log #288

miksh7 opened this issue Nov 29, 2022 · 0 comments

Comments

@miksh7
Copy link

miksh7 commented Nov 29, 2022

usp_AdaptiveIndexDefrag logs incorrect duplicate objectId/objectName in tbl_AdaptiveIndexDefrag_log during stats update, however corresponding records in tbl_AdaptiveIndexDefrag_Working are fine.
It seems code fails to update @objectName / @objectId variables and inserts the values from the previous object. Usually, it happens when sproc starts updating msdb stats.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@miksh7