search

lenis0012 / LoginSecurity

Lightweight and secure user authentication for Bukkit Minecraft servers
https://www.spigotmc.org/resources/loginsecurity.19362/
Apache License 2.0
98 stars 84 forks source link

[21:51:13 WARN]: [LoginSecurity] Failed to set inventory id in profile [21:51:13 ERROR]: [LoginSecurity] Failed to save player location #323

Closed Herokibnn69 closed 6 months ago

Herokibnn69 commented 9 months ago

[21:50:04 ERROR]: [LoginSecurity] Failed to save player location

java.sql.SQLException: Failed set location id in profile

at com.lenis0012.bukkit.loginsecurity.database.LocationRepository.insertLoginLocationBlocking(LocationRepository.java:61) ~[LoginSecurity-3.2.1-Spigot.jar:?]

at com.lenis0012.bukkit.loginsecurity.database.LocationRepository.lambda$insertLoginLocation$0(LocationRepository.java:30) ~[LoginSecurity-3.2.1-Spigot.jar:?]

at org.bukkit.craftbukkit.v1_20_R1.scheduler.CraftTask.run(CraftTask.java:101) ~[paper-1.20.1.jar:git-Paper-36]

at org.bukkit.craftbukkit.v1_20_R1.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:57) ~[paper-1.20.1.jar:git-Paper-36]

at com.destroystokyo.paper.ServerSchedulerReportingWrapper.run(ServerSchedulerReportingWrapper.java:22) ~[paper-1.20.1.jar:?]

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) ~[?:?]

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) ~[?:?]

at java.lang.Thread.run(Thread.java:833) ~[?:?]

thetokicaa commented 8 months ago

i do have same problem

BeardBear33 commented 7 months ago

Me too...

tanatonaut commented 7 months ago

I have two types of errors. Mb it's a two different problems, but they start to appear in same time. Version of MCserver - paperMC 1.20.2 Plugin version - LoginSecurity-3.1.1-Spigot.jar Type of DB - mysql

[19:27:45 WARN]: [LoginSecurity] Failed to delete player login location java.sql.SQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (login.ls_players, CONSTRAINTfk_ls_players_location_idFOREIGN KEY (location_id) REFERENCESls_locations(id) ON DELETE RESTRICT ON UPDATE RESTRICT) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:118) ~[mysql-connector-j-8.1.0.jar:8.1.0] at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-j-8.1.0.jar:8.1.0] at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916) ~[mysql-connector-j-8.1.0.jar:8.1.0] at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1061) ~[mysql-connector-j-8.1.0.jar:8.1.0] at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1009) ~[mysql-connector-j-8.1.0.jar:8.1.0] at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1320) ~[mysql-connector-j-8.1.0.jar:8.1.0] at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:994) ~[mysql-connector-j-8.1.0.jar:8.1.0] at com.mysql.cj.jdbc.PreparedStatementWrapper.executeUpdate(PreparedStatementWrapper.java:596) ~[mysql-connector-j-8.1.0.jar:8.1.0] at com.lenis0012.bukkit.loginsecurity.database.LocationRepository.deleteBlocking(LocationRepository.java:104) ~[LoginSecurity-3.1.1-Spigot.jar:?] at com.lenis0012.bukkit.loginsecurity.database.LocationRepository.lambda$delete$2(LocationRepository.java:95) ~[LoginSecurity-3.1.1-Spigot.jar:?] at org.bukkit.craftbukkit.v1_20_R2.scheduler.CraftTask.run(CraftTask.java:101) ~[paper-1.20.2.jar:git-Paper-261] at org.bukkit.craftbukkit.v1_20_R2.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:57) ~[paper-1.20.2.jar:git-Paper-261] at com.destroystokyo.paper.ServerSchedulerReportingWrapper.run(ServerSchedulerReportingWrapper.java:22) ~[paper-1.20.2.jar:?] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) ~[?:?] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) ~[?:?] at java.lang.Thread.run(Thread.java:833) ~[?:?] [19:27:50 INFO]: Winfort lost connection: Disconnected

and

[17:05:49 INFO]: Michal1500cz joined the game [17:05:49 INFO]: Michal1500cz[/31.30.174.29:39780] logged in with entity id 78807 at ([world]0.0, 40.0, 0.0) [17:05:49 WARN]: [LoginSecurity] Failed to set inventory id in profile [17:05:49 ERROR]: [LoginSecurity] Failed to save player location java.sql.SQLException: Failed set location id in profile at com.lenis0012.bukkit.loginsecurity.database.LocationRepository.insertLoginLocationBlocking(LocationRepository.java:61) ~[LoginSecurity-3.1.1-Spigot.jar:?] at com.lenis0012.bukkit.loginsecurity.database.LocationRepository.lambda$insertLoginLocation$0(LocationRepository.java:30) ~[LoginSecurity-3.1.1-Spigot.jar:?] at org.bukkit.craftbukkit.v1_20_R2.scheduler.CraftTask.run(CraftTask.java:101) ~[paper-1.20.2.jar:git-Paper-261] at org.bukkit.craftbukkit.v1_20_R2.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:57) ~[paper-1.20.2.jar:git-Paper-261] at com.destroystokyo.paper.ServerSchedulerReportingWrapper.run(ServerSchedulerReportingWrapper.java:22) ~[paper-1.20.2.jar:?] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) ~[?:?] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) ~[?:?] at java.lang.Thread.run(Thread.java:833) ~[?:?]

alyldas commented 6 months ago

[11:48:15 WARN]: [LoginSecurity] Failed to set inventory id in profile [11:48:15 ERROR]: [LoginSecurity] Failed to save player location java.sql.SQLException: Failed set location id in profile at com.lenis0012.bukkit.loginsecurity.database.LocationRepository.insertLoginLocationBlocking(LocationRepository.java:61) ~[LoginSecurity-3.2.1-Spigot.jar:?] at com.lenis0012.bukkit.loginsecurity.database.LocationRepository.lambda$insertLoginLocation$0(LocationRepository.java:30) ~[LoginSecurity-3.2.1-Spigot.jar:?] at org.bukkit.craftbukkit.v1_20_R2.scheduler.CraftTask.run(CraftTask.java:101) ~[paper-1.20.2.jar:git-Paper-318] at org.bukkit.craftbukkit.v1_20_R2.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:57) ~[paper-1.20.2.jar:git-Paper-318] at com.destroystokyo.paper.ServerSchedulerReportingWrapper.run(ServerSchedulerReportingWrapper.java:22) ~[paper-1.20.2.jar:?] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144) ~[?:?] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642) ~[?:?] at java.lang.Thread.run(Thread.java:1583) ~[?:?]

lenis0012 commented 6 months ago

Sorry for the very late reply but this issue should be resolved now in the latest dev build