So ive been running a server in YO and recently we've been 64/64 for about 12 hours out of the day for the past 2 weeks. A consequence of this is that there have been multiple bugs popping up here and there, most notably the one ill detail down below.

Ive done extensive testing and figured out more or less whats happening:

When 2 objects that are assigned featureIDs (horses, BPs, potions, and regionals) are created / put away at nearly the same time (ive tested it down to around 80ms which ill show in the logs below) they are assigned the same featureID

This then causes the DB to delete the 2nd object due to it being a duplicate entry

For example, we had 2 horses be put away at the exact same time (this is how i tested it). The first horse went into the players inventory as expected. The 2nd horse however dropped in a bag that was 0/10000. upon looking in the log this is what happened.

https://gyazo.com/c8101d85d8861a70ada76ad261f870e7

This is the test i did where the time between objects being put away was ~60ms
https://gyazo.com/639daa06b9bfaade873992f81168ad8b
charID=854 and charID=1737 were the testers, their timestamps are 01:11:25.483 and 01:11:25.540 respectively

this is the primary error DB error #1062: Duplicate entry '24169' for key 'UNQ_FeatureID'.

Now this has happened to anything that has a featureID, ive had players lose regional doors, building kits, and boards. Along with this they've lost potions and blueprints in rare cases as well

ive also posted this on the lif forums and sent an email, just covering all bases to try and get this resolved if anyone knows how to fix this

Thanks