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.

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

sp_blitzlock: String or binary data would be truncated in table 'tempdb.dbo.#deadlock_owner_waiter #3206

Closed
johnkurtdk opened this issue Jan 2, 2023 · 1 comment · Fixed by #3227
Assignees

Comments

@johnkurtdk
Copy link

johnkurtdk commented Jan 2, 2023

When I run this command
[dbo].[sp_blitzlock] @databasename ='ssisdb'
I got this error
String or binary data would be truncated in table 'tempdb.dbo.#deadlock_owner_waiter
I think reason is that in linie 1174:
lock_type = N'OBJECT'
it create a column named 'lock_type' and is 6 long but in linie 1355 it try this
lock_type = N'ROWGROUP' (= 8 character)
so I think the solution can be

  1. linie 1174 is changed from lock_type = N'OBJECT' to lock_type = cast(N'OBJECT' as nvarchar(10))
  2. or linie 1355 is changed from lock_type = N'ROWGROUP' to lock_type = N'ROWGR.'
    I prefer option 1 :-)

I use : SELECT @Version = '8.12', @VersionDate = '20221213';

p.s I don't know anything about Git so I hope I have done it right

@BrentOzar
Copy link
Member

OK, I made the change, but I don't think that was actually what was causing the issue. On your machine, whenever you hit a bug like this, feel free to actually change the code to prove that it fixes the issue, just to be safe. I think the change is harmless, though, so I've made it. Cheers!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants