Creature GUID overflow

[Hortman]

Hi, I run a small 3.3.5 private server on win server 12, it's normally pretty stable but today it started crashing every few minutes and I tried looking online and the only thing I came up with was to delete every NPC over 10000000 which would wipe out half of my creatures db.

Thanks

[stoneharry]

GUID is the unique identifier for every creature. GUID is a uint64. This cannot be changed.

A unsigned integer of 64 bits has a maximum value of: 18,446,744,073,709,551,615; that is, hexadecimal 0xFFFFFFFFFFFFFFFF. According to google.

As long as your ID is lower than that, the GUID should not overflow which makes me question if the database fields are too small or the algorithm to calculate GUID is not perfect.

Either way your NPC's should not have ID's that high. I would rebuild the database index to change the ID's to ascending rather than jumping to such a high value.