So I've got a deadlock issue I'm having trouble tracking down.
I have the deadlock tracking trace flag turned on, and this is the part I'm having trouble with:
KEY: 5:72057594325499904
From everything I've found, the layout of that item is supposed to be:
KEY: [Db_ID]:[Object_ID]:[Index_ID]
That 7205... number is way too large to be an object_id (those are all type int, and that number is a bigint).
Any idea what's going on?
Oh, and the line number part of the deadlock message leads me to believe the deadlock is happening in a comment. It says line 9, there's 20 lines of comment block at the top of the proc.
EDIT:
So I figured it out.
That's a partition_ID. You can cross-reference it to an object_id in sys.partitions.
It's the stupid sequencing thing this stupid vendor is using instead of using identities like any sane person.