Hi Community, I receive locking failure on pg_advisory_lock, I do deadlock condition and receive following: - - - ERROR: deadlock detected SQL state: 40P01 Detail: Process 240828 waits for ExclusiveLock on advisory lock [ *1167570,16820923,3422556162,1*]; blocked by process 243637. Process 243637 waits for ExclusiveLock on advisory lock [ *1167570,16820923,3422556161,1*]; blocked by process 240828. - - - I do from Tx1: select pg_advisory_lock(72245317596090369); select pg_advisory_lock(72245317596090370); and from Tx2: select pg_advisory_lock(72245317596090370); select pg_advisory_lock(72245317596090369);
where long key is following: 72245317596090369-> HEX 0x0100*AABBCC001001* where 1st byte (highest significance "0x01") is namespace masked with MAC Address " *AABBCC001001*", but in error i see 4 numbers - what is their meaning? I deducted that 2nd ( *16820923* .) HEX 0x100AABB, 1st half of long key) and 3rd is ( *3422556161* -> HEX 0xCC001001, 2nd half of long key) but what are 1st ( *1167570* ) and 4th (*1*) numbers? <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=icon> Virus-free. www.avast.com <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=link> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
