Unintended Item Duplicate?

[ermanherman]

Hi there,

Today i just think about to investigate if any duplication may occur either intended by players or by system saving glitch.

Surprisingly i found there is duplication and from my conclusion it's unintended by players, since the item duplicate with same unique_id persists in players account without their acknowledge.

Here i do how to trace the duplicate item with unique_id

SELECT unique_id, account_id, nameid, refine
FROM storage 
GROUP BY unique_id
HAVING COUNT( * ) >=2

I tested on both my servers, 1 using kinda old hercules about 1 year ago version, and another one with at least 1 month old of hercules version.

Please check this guys and thanks.

Just some extra info the server running with about 300 players avarage.

[ermanherman]

UPDATE:

Server not crash, just few hour from my checking there were found about 4407 duplicated uniqe_id items found and it rising to 4413 in STORAGE without clue...

[ermanherman]

UPDATE:

Im tracking latest duplicated unique_item and talk to one of effected char. He said he just store the item and dont realize that item he stored become 2 in quantity although he store it 1.

[ermanherman]

@4144 @dastgir @Jedzkie @Michieru

[dastgirp]

What was that item? Item Id? Was the item bounded? He stored in guild storage or account storage?

[ermanherman]

Some screenshot.

[ermanherman]

@dastgir mostly equipment. I cant check stack-able item due it dont have unique_id

[MishimaHaruna]

Do you know if the server show any error message while running? (mostly interested in the ones tagged as [Error] or [SQL]).

Just to make sure, do you have more than one map-server connected to the same char-server?

[ermanherman]

@MishimaHaruna no error sir, im running single map-server.

[ermanherman]

@dastgir look like bound item not affected.

further investigation duplicated item found more in storage rather then inventory. Maybe STORAGE system having problem?

[kyeme]

I've experienced this, I'm just not sure if this was a Duplicate Item or there is some bug on UID. I've already sent this matter to @MishimaHaruna but he haven't read my message yet (I've sent a private message last June 2015, so this bug does exist for a long time already.)

[ermanherman]

I belive this lead to item duplicate after i dig it deeper. It just happens without noone knows.

[ermanherman]

Thanks for fast action! :)