Solved Skellet MySQL conncection closed error

  • Welcome to skUnity!

    Welcome to skUnity! This is a forum where members of the Skript community can communicate and interact. Skript Resource Creators can post their Resources for all to see and use.

    If you haven't done so already, feel free to join our official Discord server to expand your level of interaction with the comminuty!

    Now, what are you waiting for? Join the community now!

  • LOOKING FOR A VERSION OF SKRIPT?

    You can always check out skUnity Downloads for downloads and any other information about Skript!

Status
Not open for further replies.

MachisCZ

Member
Jan 26, 2017
23
1
3
28
Hello guys, how i can solve closing of mysql connection?
i am getting this error after script works some hours:
code_language.skript:
[15:56:50] [pool-49-thread-2/INFO]: MySQL Query:
[15:56:50] [pool-49-thread-2/INFO]: Command: SELECT * FROM levelodmeny WHERE `uuid` = '54a76c1a-
fe3f-3d3b-a7a1-6a04b187414d'
[15:56:50] [pool-49-thread-2/INFO]: Error: No operations allowed after connection closed.
[15:56:50] [Server thread/ERROR]: #!#!
[15:56:50] [Server thread/ERROR]: #!#! [Skript] Severe Error:
[15:56:50] [Server thread/ERROR]: #!#!
[15:56:50] [Server thread/ERROR]: #!#! If you're developing an add-on for Skript this likely mea
ns that you have done something wrong.
[15:56:50] [Server thread/ERROR]: #!#! If you're a server admin however please go to https://git
hub.com/bensku/Skript/issues/
[15:56:50] [Server thread/ERROR]: #!#! and check whether this error has already been reported.
[15:56:50] [Server thread/ERROR]: #!#! If not please create a new ticket with a meaningful title
, copy & paste this whole error into it (or use paste service),
[15:56:50] [Server thread/ERROR]: #!#! and describe what you did before it happened and/or what
you think caused the error.
[15:56:50] [Server thread/ERROR]: #!#! If you think that it's a trigger that's causing the error
 please post the trigger as well.
[15:56:50] [Server thread/ERROR]: #!#! By following this guide fixing the error should be easy a
nd done fast.
[15:56:50] [Server thread/ERROR]: #!#!
[15:56:50] [Server thread/ERROR]: #!#! Stack trace:
[15:56:50] [Server thread/ERROR]: #!#! java.lang.NullPointerException
[15:56:50] [Server thread/ERROR]: #!#!     at com.gmail.thelimeglass.MySQL.ExprMySQLQueryString.
get(ExprMySQLQueryString.java:45)
[15:56:50] [Server thread/ERROR]: #!#!     at com.gmail.thelimeglass.MySQL.ExprMySQLQueryString.
get(ExprMySQLQueryString.java:1)
[15:56:50] [Server thread/ERROR]: #!#!     at ch.njol.skript.lang.util.SimpleExpression.getArray
(SimpleExpression.java:105)
[15:56:50] [Server thread/ERROR]: #!#!     at ch.njol.skript.effects.EffChange.execute(EffChange
.java:270)
[15:56:50] [Server thread/ERROR]: #!#!     at ch.njol.skript.lang.Effect.run(Effect.java:54)
[15:56:50] [Server thread/ERROR]: #!#!     at ch.njol.skript.lang.TriggerItem.walk(TriggerItem.j
ava:65)
[15:56:50] [Server thread/ERROR]: #!#!     at ch.njol.skript.lang.TriggerItem.walk(TriggerItem.j
ava:93)
[15:56:50] [Server thread/ERROR]: #!#!     at com.w00tmast3r.skquery.elements.effects.EffOptionT
hread$1.run(EffOptionThread.java:43)
[15:56:50] [Server thread/ERROR]: #!#!     at org.bukkit.craftbukkit.v1_11_R1.scheduler.CraftTas
k.run(CraftTask.java:58)
[15:56:50] [Server thread/ERROR]: #!#!     at org.bukkit.craftbukkit.v1_11_R1.scheduler.CraftSch
eduler.mainThreadHeartbeat(CraftScheduler.java:356)
[15:56:50] [Server thread/ERROR]: #!#!     at net.minecraft.server.v1_11_R1.MinecraftServer.D(Mi
necraftServer.java:829)
[15:56:50] [Server thread/ERROR]: #!#!     at net.minecraft.server.v1_11_R1.DedicatedServer.D(De
dicatedServer.java:403)
[15:56:50] [Server thread/ERROR]: #!#!     at net.minecraft.server.v1_11_R1.MinecraftServer.C(Mi
necraftServer.java:763)
[15:56:50] [Server thread/ERROR]: #!#!     at net.minecraft.server.v1_11_R1.MinecraftServer.run(
MinecraftServer.java:661)
[15:56:50] [Server thread/ERROR]: #!#!     at java.lang.Thread.run(Thread.java:748)
[15:56:50] [Server thread/ERROR]: #!#!
[15:56:50] [Server thread/ERROR]: #!#! Version Information:
[15:56:50] [Server thread/ERROR]: #!#!   Skript: 2.2-dev25
[15:56:50] [Server thread/ERROR]: #!#!   Bukkit: 1.11.2-R0.1-SNAPSHOT
[15:56:50] [Server thread/ERROR]: #!#!   Minecraft: 1.11.2
[15:56:50] [Server thread/ERROR]: #!#!   Java: 1.8.0_131 (Java HotSpot(TM) 64-Bit Server VM 25.1
31-b11)
[15:56:50] [Server thread/ERROR]: #!#!   OS: Linux amd64 4.4.0-78-generic
[15:56:50] [Server thread/ERROR]: #!#!
[15:56:50] [Server thread/ERROR]: #!#! Running CraftBukkit: false
[15:56:50] [Server thread/ERROR]: #!#!
[15:56:50] [Server thread/ERROR]: #!#! Current node: null
[15:56:50] [Server thread/ERROR]: #!#! Current item: set {_name::*}(as java.lang.Object) to [ske
llett] mysql string %string% (in|from|of) %resultset%
[15:56:50] [Server thread/ERROR]: #!#!
[15:56:50] [Server thread/ERROR]: #!#! Thread: Server thread
[15:56:50] [Server thread/ERROR]: #!#!
[15:56:50] [Server thread/ERROR]: #!#! End of Error.
[15:56:50] [Server thread/ERROR]: #!#!
When i reload this script again its starts working for some time again.
Thanks
[doublepost=1497881879,1497881817][/doublepost]@LimeGlass PS: my connection to MySQL is on load event.
 
Hello,

You need to reconnect every hours or every 30 minutes to MySQL to have a continuous connection to the database :emoji_wink: because when you don't do a query, the connection go to "sleep mode" and disconnect with the MC server :emoji_wink:
 
Status
Not open for further replies.