Spigot PlayerSQL 2.12.3

Synchronize data between servers.

  1. add player location pls.
     
  2. Any reason you should override player's location while it jump server?
     
  3. i create a sectors on my server
     
  4. Hello,

    One of the players on my server has noticed a few inventory issues the last few days (items duplicating or going missing when moving between servers) and I noticed this when I was going through my server logs (unsure if it's related):

    Code (Text):
    [13:14:43 ERROR]: FATAL: DataSourcePool [PlayerSQL] is down!!!
    com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

    The last packet successfully received from the server was 30,009 milliseconds ago.  The last packet sent successfully to the server was 6 milliseconds ago.
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_131]
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[?:1.8.0_131]
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.8.0_131]
        at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[?:1.8.0_131]
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[server.jar:git-Spigot-7754231-94b0980]
        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:989) ~[server.jar:git-Spigot-7754231-94b0980]
        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3559) ~[server.jar:git-Spigot-7754231-94b0980]
        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3459) ~[server.jar:git-Spigot-7754231-94b0980]
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3900) ~[server.jar:git-Spigot-7754231-94b0980]
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527) ~[server.jar:git-Spigot-7754231-94b0980]
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680) ~[server.jar:git-Spigot-7754231-94b0980]
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2483) ~[server.jar:git-Spigot-7754231-94b0980]
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2441) ~[server.jar:git-Spigot-7754231-94b0980]
        at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1381) ~[server.jar:git-Spigot-7754231-94b0980]
        at com.avaje.ebeaninternal.server.lib.sql.DataSourcePool.testConnection(DataSourcePool.java:492) [ebean-2.8.1.jar:?]
        at com.avaje.ebeaninternal.server.lib.sql.DataSourcePool.checkDataSource(DataSourcePool.java:359) [ebean-2.8.1.jar:?]
        at com.avaje.ebeaninternal.server.lib.sql.DataSourceManager.checkDataSource(DataSourceManager.java:235) [ebean-2.8.1.jar:?]
        at com.avaje.ebeaninternal.server.lib.sql.DataSourceManager.access$100(DataSourceManager.java:38) [ebean-2.8.1.jar:?]
        at com.avaje.ebeaninternal.server.lib.sql.DataSourceManager$Checker.run(DataSourceManager.java:247) [ebean-2.8.1.jar:?]
        at com.avaje.ebeaninternal.server.lib.BackgroundThread$Runner.runJobs(BackgroundThread.java:206) [ebean-2.8.1.jar:?]
        at com.avaje.ebeaninternal.server.lib.BackgroundThread$Runner.run(BackgroundThread.java:170) [ebean-2.8.1.jar:?]
        at java.lang.Thread.run(Thread.java:748) [?:1.8.0_131]
    Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
        at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3011) ~[server.jar:git-Spigot-7754231-94b0980]
        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3469) ~[server.jar:git-Spigot-7754231-94b0980]
        ... 15 more
    [13:14:43 INFO]: Reseting DataSourcePool [PlayerSQL] min:1 max:8 free:0 busy:1 waiting:0 highWaterMark:1 waitCount:0 hitCount:78
    [13:14:43 INFO]: Busy Connections:
    name[PlayerSQL.0] startTime[1508087683315] stmt[null] createdBy[null]

    [13:14:43 INFO]: Closing Connection[PlayerSQL.0] psReuse[15] psCreate[4] psSize[4]
    [13:14:43 ERROR]: Closing Connection[PlayerSQL.0] that is already closed?
    /home/minecraft-3/.control/start.sh: line 6: 18640 Killed                  java -Xmx${MEMORY}m -Dfml.queryResult=confirm -Dfile.encoding=UTF-8 -jar server.jar
    I think it happened either during or caused a server crash.
     
  5. There is a problem with the synchronisation of potion effect, when an effect is applied on a player, if he switch server, it comes back over and over. There isn't any console error
     
  6. Seems database link failure. I cannot reproduce this issue on my test network.
     
  7. caoli5288 updated PlayerSQL with a new update entry:

    Update to 2.8b1

    Read the rest of this update entry...
     
  8. make it so that their rank can be synchronized?
     
  9. You mean EXP Level? Or do you mean Permission Ranks? Use MySQL in combination with Luckperms for example.
     
  10. I get this fancy error on another server while it works on another...

    Code (Text):
    [05:55:16] [Server thread/INFO]: [PlayerSQL] Enabling PlayerSQL v2.8-SNAPSHOT
    [05:55:16] [Server thread/INFO]: [PlayerSQL] Bukkit v1_12_R1
    [05:55:16] [Server thread/INFO]: [PlayerSQL] Item util build-in
    [05:55:16] [Server thread/INFO]: [PlayerSQL] ORM lib load okay!
    [05:55:16] [Server thread/ERROR]: Error occurred while enabling PlayerSQL v2.8-SNAPSHOT (Is it up to date?)
    java.lang.NoClassDefFoundError: com/avaje/ebean/config/dbplatform/SQLitePlatform
        at com.mengcraft.playersql.lib.simpleorm.EbeanManager.build(EbeanManager.java:39) ~[?:?]
        at com.mengcraft.playersql.lib.simpleorm.EbeanManager.getHandler(EbeanManager.java:25) ~[?:?]
        at com.mengcraft.playersql.PluginMain.onEnable(PluginMain.java:42) ~[?:?]
        at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:264) ~[patched_1.12.2.jar:git-Paper-1375]
        at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:316) [patched_1.12.2.jar:git-Paper-1375]
        at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:405) [patched_1.12.2.jar:git-Paper-1375]
        at org.bukkit.craftbukkit.v1_12_R1.CraftServer.enablePlugin(CraftServer.java:395) [patched_1.12.2.jar:git-Paper-1375]
        at org.bukkit.craftbukkit.v1_12_R1.CraftServer.enablePlugins(CraftServer.java:344) [patched_1.12.2.jar:git-Paper-1375]
        at net.minecraft.server.v1_12_R1.MinecraftServer.t(MinecraftServer.java:442) [patched_1.12.2.jar:git-Paper-1375]
        at net.minecraft.server.v1_12_R1.MinecraftServer.l(MinecraftServer.java:403) [patched_1.12.2.jar:git-Paper-1375]
        at net.minecraft.server.v1_12_R1.MinecraftServer.a(MinecraftServer.java:341) [patched_1.12.2.jar:git-Paper-1375]
        at net.minecraft.server.v1_12_R1.DedicatedServer.init(DedicatedServer.java:292) [patched_1.12.2.jar:git-Paper-1375]
        at net.minecraft.server.v1_12_R1.MinecraftServer.run(MinecraftServer.java:616) [patched_1.12.2.jar:git-Paper-1375]
        at java.lang.Thread.run(Thread.java:745) [?:1.8.0_111]
    Caused by: java.lang.ClassNotFoundException: com.avaje.ebean.config.dbplatform.SQLitePlatform
        at java.net.URLClassLoader.findClass(URLClassLoader.java:381) ~[?:1.8.0_111]
        at org.bukkit.plugin.java.PluginClassLoader.findClass(PluginClassLoader.java:156) ~[patched_1.12.2.jar:git-Paper-1375]
        at org.bukkit.plugin.java.PluginClassLoader.findClass(PluginClassLoader.java:104) ~[patched_1.12.2.jar:git-Paper-1375]
        at java.lang.ClassLoader.loadClass(ClassLoader.java:424) ~[?:1.8.0_111]
        at java.lang.ClassLoader.loadClass(ClassLoader.java:357) ~[?:1.8.0_111]
        ... 14 more
     
  11. Archangel

    Supporter

    Are the Spigot versions the same on both servers?
     
  12. Yep. Are all working from one Symlink. @petomka fixed it for me. It seems it was wrong compiled? Not it works without any errors.
     
  13. Hi, after configuration i cant connect to any of my Servers.
    The Mainserver is stabil and i can connect without error.
    Whats happen ? I have also installed BungeeBridge, is that a Problem ?
     
  14. [17:05:49 ERROR]: [PlayerSQL] com.mengcraft.playersql.PluginException: Player 0c4f51ba-1e8c-3130-9ac0-1692acb5e8dc not found
    com.mengcraft.playersql.PluginException: Player 0c4f51ba-1e8c-3130-9ac0-1692acb5e8dc not found
    at com.mengcraft.playersql.UserManager.pend(UserManager.java:172) ~[?:?]
    at com.mengcraft.playersql.UserManager.lambda$addFetched$0(UserManager.java:49) ~[?:?]
    at org.bukkit.craftbukkit.v1_12_R1.scheduler.CraftTask.run(CraftTask.java:71) [spigot-1.12xyx.jar:git-Spigot-596221b-9a1fc1e]
    at org.bukkit.craftbukkit.v1_12_R1.scheduler.CraftScheduler.mainThreadHeartbeat(CraftScheduler.java:353) [spigot-1.12xyx.jar:git-Spigot-596221b-9a1fc1e]
    at net.minecraft.server.v1_12_R1.MinecraftServer.D(MinecraftServer.java:738) [spigot-1.12xyx.jar:git-Spigot-596221b-9a1fc1e]
    at net.minecraft.server.v1_12_R1.DedicatedServer.D(DedicatedServer.java:405) [spigot-1.12xyx.jar:git-Spigot-596221b-9a1fc1e]
    at net.minecraft.server.v1_12_R1.MinecraftServer.C(MinecraftServer.java:678) [spigot-1.12xyx.jar:git-Spigot-596221b-9a1fc1e]
    at net.minecraft.server.v1_12_R1.MinecraftServer.run(MinecraftServer.java:576) [spigot-1.12xyx.jar:git-Spigot-596221b-9a1fc1e]
    at java.lang.Thread.run(Thread.java:748) [?:1.8.0_171]
     
  15. It shown that player quit before data fetched. You can simply just ignore it.