Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Tôi không biết lỗi gì, nhưng nó có thể bị lỗi SQL #61

Open
MeoNguOfficial opened this issue Dec 21, 2024 · 0 comments
Open

Comments

@MeoNguOfficial
Copy link

Chi tiết lỗi:
[02:32:42 WARN]: [DotMan] Plugin DotMan v1.6 generated an exception while executing task 6618
org.h2.jdbc.JdbcSQLIntegrityConstraintViolationException: Unique index or primary key violation: "PUBLIC.PRIMARY_KEY_4 ON PUBLIC.dotman_player_info(uuid) VALUES ( /* 81 */ '6785753d-b369-3537-9216-b8c0e396416e' )"; SQL statement:
MERGE INTO "dotman_player_info" AS target
USING (
VALUES (?, ?, ?)
) AS source ("uuid", "name", "last_updated")
ON target."uuid" = source."uuid"
WHEN MATCHED THEN
UPDATE SET
target."name" = source."name",
target."last_updated" = source."last_updated"
WHEN NOT MATCHED THEN
INSERT ("uuid", "name", "last_updated")
VALUES (source."uuid", source."name", source."last_updated") [23505-214]
at MineVNLib.jar/org.h2.message.DbException.getJdbcSQLException(DbException.java:508) ~[MineVNLib.jar:?]
at MineVNLib.jar/org.h2.message.DbException.getJdbcSQLException(DbException.java:477) ~[MineVNLib.jar:?]
at MineVNLib.jar/org.h2.message.DbException.get(DbException.java:223) ~[MineVNLib.jar:?]
at MineVNLib.jar/org.h2.message.DbException.get(DbException.java:199) ~[MineVNLib.jar:?]
at MineVNLib.jar/org.h2.index.Index.getDuplicateKeyException(Index.java:525) ~[MineVNLib.jar:?]
at MineVNLib.jar/org.h2.mvstore.db.MVSecondaryIndex.checkUnique(MVSecondaryIndex.java:223) ~[MineVNLib.jar:?]
at MineVNLib.jar/org.h2.mvstore.db.MVSecondaryIndex.add(MVSecondaryIndex.java:184) ~[MineVNLib.jar:?]
at MineVNLib.jar/org.h2.mvstore.db.MVTable.addRow(MVTable.java:519) ~[MineVNLib.jar:?]
at MineVNLib.jar/org.h2.command.dml.MergeUsing$WhenNotMatched.merge(MergeUsing.java:509) ~[MineVNLib.jar:?]
at MineVNLib.jar/org.h2.command.dml.MergeUsing.merge(MergeUsing.java:154) ~[MineVNLib.jar:?]
at MineVNLib.jar/org.h2.command.dml.MergeUsing.update(MergeUsing.java:135) ~[MineVNLib.jar:?]
at MineVNLib.jar/org.h2.command.dml.DataChangeStatement.update(DataChangeStatement.java:74) ~[MineVNLib.jar:?]
at MineVNLib.jar/org.h2.command.CommandContainer.update(CommandContainer.java:169) ~[MineVNLib.jar:?]
at MineVNLib.jar/org.h2.command.Command.executeUpdate(Command.java:252) ~[MineVNLib.jar:?]
at MineVNLib.jar/org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:209) ~[MineVNLib.jar:?]
at MineVNLib.jar/org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:169) ~[MineVNLib.jar:?]
at MineVNLib.jar/net.minevn.libs.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61) ~[MineVNLib.jar:?]
at MineVNLib.jar/net.minevn.libs.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java) ~[MineVNLib.jar:?]
at DotMan.jar/net.minevn.dotman.database.PlayerInfoDAO.updateData$lambda$0(PlayerInfoDAO.kt:21) ~[DotMan.jar:?]
at MineVNLib.jar/net.minevn.libs.db.DataAccess.statement(DataAccess.kt:31) ~[MineVNLib.jar:?]
at MineVNLib.jar/net.minevn.libs.db.DataAccess.statement(DataAccess.kt:17) ~[MineVNLib.jar:?]
at DotMan.jar/net.minevn.dotman.database.PlayerInfoDAO.updateData(PlayerInfoDAO.kt:16) ~[DotMan.jar:?]
at DotMan.jar/net.minevn.dotman.DotManListener.updateUUID$lambda$0(DotManListener.kt:16) ~[DotMan.jar:?]
at org.bukkit.craftbukkit.scheduler.CraftTask.run(CraftTask.java:78) ~[leaf-1.21.1.jar:1.21.1-DEV-88579f1]
at org.bukkit.craftbukkit.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:57) ~[leaf-1.21.1.jar:1.21.1-DEV-88579f1]
at com.destroystokyo.paper.ServerSchedulerReportingWrapper.run(ServerSchedulerReportingWrapper.java:22) ~[leaf-1.21.1.jar:?]
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144) ~[?:?]
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642) ~[?:?]
at java.base/java.lang.VirtualThread.run(VirtualThread.java:309) ~[?:?]

Bản đang dùng: v1.6 free version
Mong tìm cách khắc phục ạ
Cảm ơn tác giả đã đọc

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant