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.
This is the test i did where the time between objects being put away was ~60ms
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
Is there any fix to this?
Ive also sent an email with logs to the firstname.lastname@example.org tech support
Thanks for the help