Duplicate entries in skillcooldown when logging into an autotrader

[vstumpf]

• rAthena Hash: 9348ea4

• Client Date: 20200401 (any)

• Server Mode: Any

• Description of Issue:
  • Result: DB error:

[SQL]: DB error - Duplicate entry '150000-10010' for key 'PRIMARY'
[Debug]: at char_mapif.cpp:519 - INSERT INTO `skillcooldown` (`account_id`, `char_id`, `skill`, `tick`) VALUES 
  ('2000000','150000','10010','245670'), ('2000000','150000','10011','245670'),
  ('2000000','150000','10012','245670'), ('2000000','150000','10013','245670')

• Expected Result: No Error

• How to Reproduce: Be a guildmaster. Don't need any guild skills allocated. Start vending and @autotrade. When you try to log the character in again, the login "fails", since the character is connected. This is intended. When it kicks the autotrading character, the skill cooldowns are saved again, resulting in this error.

• Modifications that may affect results: None

[reunite-ro]

I got this error too during/if map server crash happen (while having autotraders ingame).

[RagnaWay]

Just to confirm that in the most recent arA this error still remains.

[RadianFord]

I just confirmed this one on a latest version.

[tony891254]

[SQL]: DB error - Duplicate entry '150003-10010' for key 'PRIMARY' [Debug]: at char_mapif.cpp:521 - INSERT INTO skillcooldown same

[Daraen1]

any issue ?

[thanna]

I encountered the same error, double checked everything with the latest git. I think this error still exist. I can reproduced it via the given steps above.