Database f_insertNewItemInventory error, deleting non-duplicate entries

General discussion about Life is Feudal: Your Own, The main section and backbone of the forums.

CaptZimecki
 
Posts: 1
Joined: 14 Jun 2017, 03:09

Database f_insertNewItemInventory error, deleting non-duplicate entries

Post by CaptZimecki » 02 Jun 2019, 07:15

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.

[url]https://gyazo.com/c8101d85d8861a70ada76ad261f870e7
[/url]
Image
This is the test i did where the time between objects being put away was ~60ms
[url]https://gyazo.com/639daa06b9bfaade873992f81168ad8b
[/url]
Image
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 helpme@lifeisfeudal.com tech support

Thanks for the help

Return to General Discussion