C6 Offiline shop

[caioconc]

When putting something up for sale it presents an error and going out repeatedly at one time or another doesn't work.
In my analysis there is something related to deleting the character from the table and inserting it again.

Code: [Select]

OfflineTraderTable: Error while saving offline trader: 268487564 java.sql.SQLIntegrityConstraintViolationException: (conn=39999) Duplicate entry '268487564' for key 'character_offline_trade.PRIMARY'
[13/09 00:33:06] OfflineTraderTable: Error while saving offline trader: 268487564 java.sql.SQLIntegrityConstraintViolationException: (conn=40022) Duplicate entry '268487564' for key 'character_offline_trade.PRIMARY'

[jujihara]

I think there is a bug with offline trade; IDs are duplicated because I manually change the last digit, and it works. Perhaps a correction is needed.

[jujihara]

OfflineTraderTable: Error while saving offline trader: 268478403 java.sql.SQLIntegrityConstraintViolationException: (conn=11824) Duplicate entry '268478403' for key 'PRIMARY'
[21/10 00:15:33] PlayerVariables: Couldn't update variables for: 268478403
java.sql.BatchUpdateException: (conn=11824) Interrupted awaiting response
        at org.mariadb.jdbc.MariaDbStatement.executeBatchExceptionEpilogue(MariaDbStatement.java:327)
        at org.mariadb.jdbc.ClientSidePreparedStatement.executeBatch(ClientSidePreparedStatement.java:299)
        at org.l2jmobius.gameserver.model.variables.PlayerVariables.storeMe(PlayerVariables.java:114)
        at org.l2jmobius.gameserver.model.actor.Player.deleteMe(Player.java:13136)
        at org.l2jmobius.gameserver.network.GameClient$CleanupTask.run(GameClient.java:516)
        at org.l2jmobius.commons.threads.RunnableWrapper.run(RunnableWrapper.java:35)
        at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
        at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
        at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:304)
        at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
        at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
        at java.base/java.lang.Thread.run(Thread.java:833)
Caused by: java.sql.SQLTransientConnectionException: (conn=11824) Interrupted awaiting response
        at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:79)
        at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:158)
        at org.mariadb.jdbc.MariaDbStatement.executeBatchExceptionEpilogue(MariaDbStatement.java:323)
        ... 11 more
Caused by: java.sql.SQLException: Interrupted awaiting response
        at org.mariadb.jdbc.internal.protocol.AbstractMultiSend.executeBatchStandard(AbstractMultiSend.java:299)
        at org.mariadb.jdbc.internal.protocol.AbstractMultiSend.executeBatch(AbstractMultiSend.java:206)
        at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchMulti(AbstractQueryProtocol.java:704)
        at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeBatchClient(AbstractQueryProtocol.java:426)
        at org.mariadb.jdbc.ClientSidePreparedStatement.executeInternalBatch(ClientSidePreparedStatement.java:368)
        at org.mariadb.jdbc.ClientSidePreparedStatement.executeBatch(ClientSidePreparedStatement.java:294)
        ... 10 more
Caused by: java.lang.InterruptedException
        at java.base/java.util.concurrent.FutureTask.awaitDone(FutureTask.java:418)
        at java.base/java.util.concurrent.FutureTask.get(FutureTask.java:190)
        at org.mariadb.jdbc.internal.protocol.AbstractMultiSend.executeBatchStandard(AbstractMultiSend.java:284)
        ... 15 more