Paste #15350: What happens when an SQL db is offline

Date: 2015/04/29 23:02:21 UTC-07:00
Type: Server Log

View Raw Paste Download This Paste
Copy Link 


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121



[01:41:55] [Server thread/INFO]: Nilsentience issued server command: /ex narrate <proc[SQLAPI_ListFlags].context[<player>]||null>
[01:41:55] [Server thread/INFO]:  Starting InstantQueue 'EXCOMMAND_ProductionStemDraw'... 
[01:41:55] [Server thread/INFO]:  Queue 'EXCOMMAND_ProductionStemDraw' Executing: NARRATE 
                   "<proc[SQLAPI_ListFlags].context[<player>]||null>" 
[01:41:55] [Server thread/INFO]: +- Executing dCommand: NARRATE/p@Nilsentience ---------+ 
[01:41:55] [Server thread/INFO]:  Filled tag <player> with 
                   'p@af5efd2a-f19b-47ef-a4bb-9c585108b3d4'. 
[01:41:55] [Server thread/INFO]:  Adding definition %owner% as 
                   p@af5efd2a-f19b-47ef-a4bb-9c585108b3d4 
[01:41:55] [Server thread/INFO]:  ERROR in script 'SQLMANAGER_CONNECTIONCHECK'! SQL Exception: 
                   Communications link failure

The last packet successfully 
                   received from the server was 28,004 milliseconds ago.  The 
                   last packet sent successfully to the server was 5 milliseconds 
                   ago. 
[01:41:55] [Server thread/INFO]:  ERROR! Internal exception was thrown! 
[01:41:55] [Server thread/WARN]: java.lang.reflect.InvocationTargetException
[01:41:55] [Server thread/WARN]:     at sun.reflect.GeneratedMethodAccessor29.invoke(Unknown Source)
[01:41:55] [Server thread/WARN]:     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[01:41:55] [Server thread/WARN]:     at java.lang.reflect.Method.invoke(Method.java:606)
[01:41:55] [Server thread/WARN]:     at net.aufdemrand.denizencore.tags.TagManager.fireEvent(TagManager.java:76)
[01:41:55] [Server thread/WARN]:     at net.aufdemrand.denizencore.tags.TagManager.readSingleTag(TagManager.java:243)
[01:41:55] [Server thread/WARN]:     at net.aufdemrand.denizencore.tags.TagManager.tag(TagManager.java:275)
[01:41:55] [Server thread/WARN]:     at net.aufdemrand.denizencore.scripts.commands.core.IfCommand$ArgComparer.tagme(IfCommand.java:165)
[01:41:55] [Server thread/WARN]:     at net.aufdemrand.denizencore.scripts.commands.core.IfCommand$ArgComparer.compare(IfCommand.java:181)
[01:41:55] [Server thread/WARN]:     at net.aufdemrand.denizencore.scripts.commands.core.IfCommand.execute(IfCommand.java:91)
[01:41:55] [Server thread/WARN]:     at net.aufdemrand.denizencore.scripts.commands.CommandExecuter.execute(CommandExecuter.java:235)
[01:41:55] [Server thread/WARN]:     at net.aufdemrand.denizencore.scripts.queues.ScriptEngine.revolve(ScriptEngine.java:51)
[01:41:55] [Server thread/WARN]:     at net.aufdemrand.denizencore.scripts.queues.ScriptQueue.revolve(ScriptQueue.java:660)
[01:41:55] [Server thread/WARN]:     at net.aufdemrand.denizencore.scripts.queues.core.InstantQueue.onStart(InstantQueue.java:53)
[01:41:55] [Server thread/WARN]:     at net.aufdemrand.denizencore.scripts.queues.ScriptQueue.start(ScriptQueue.java:519)
[01:41:55] [Server thread/WARN]:     at net.aufdemrand.denizencore.tags.core.ProcedureScriptTags.procedureTag(ProcedureScriptTags.java:188)
[01:41:55] [Server thread/WARN]:     at sun.reflect.GeneratedMethodAccessor20.invoke(Unknown Source)
[01:41:55] [Server thread/WARN]:     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[01:41:55] [Server thread/WARN]:     at java.lang.reflect.Method.invoke(Method.java:606)
[01:41:55] [Server thread/WARN]:     at net.aufdemrand.denizencore.tags.TagManager.fireEvent(TagManager.java:76)
[01:41:55] [Server thread/WARN]:     at net.aufdemrand.denizencore.tags.TagManager.readSingleTag(TagManager.java:243)
[01:41:55] [Server thread/WARN]:     at net.aufdemrand.denizencore.tags.TagManager.tag(TagManager.java:275)
[01:41:55] [Server thread/WARN]:     at net.aufdemrand.denizencore.scripts.commands.core.IfCommand$ArgComparer.tagme(IfCommand.java:165)
[01:41:55] [Server thread/WARN]:     at net.aufdemrand.denizencore.scripts.commands.core.IfCommand$ArgComparer.compare(IfCommand.java:181)
[01:41:55] [Server thread/WARN]:     at net.aufdemrand.denizencore.scripts.commands.core.IfCommand.execute(IfCommand.java:91)
[01:41:55] [Server thread/WARN]:     at net.aufdemrand.denizencore.scripts.commands.CommandExecuter.execute(CommandExecuter.java:235)
[01:41:55] [Server thread/WARN]:     at net.aufdemrand.denizencore.scripts.queues.ScriptEngine.revolve(ScriptEngine.java:51)
[01:41:55] [Server thread/WARN]:     at net.aufdemrand.denizencore.scripts.queues.ScriptQueue.revolve(ScriptQueue.java:660)
[01:41:55] [Server thread/WARN]:     at net.aufdemrand.denizencore.scripts.queues.core.InstantQueue.onStart(InstantQueue.java:53)
[01:41:55] [Server thread/WARN]:     at net.aufdemrand.denizencore.scripts.queues.ScriptQueue.start(ScriptQueue.java:519)
[01:41:55] [Server thread/WARN]:     at net.aufdemrand.denizencore.tags.core.ProcedureScriptTags.procedureTag(ProcedureScriptTags.java:188)
[01:41:55] [Server thread/WARN]:     at sun.reflect.GeneratedMethodAccessor20.invoke(Unknown Source)
[01:41:55] [Server thread/WARN]:     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[01:41:55] [Server thread/WARN]:     at java.lang.reflect.Method.invoke(Method.java:606)
[01:41:55] [Server thread/WARN]:     at net.aufdemrand.denizencore.tags.TagManager.fireEvent(TagManager.java:76)
[01:41:55] [Server thread/WARN]:     at net.aufdemrand.denizencore.tags.TagManager.readSingleTag(TagManager.java:243)
[01:41:55] [Server thread/WARN]:     at net.aufdemrand.denizencore.tags.TagManager.tag(TagManager.java:275)
[01:41:55] [Server thread/WARN]:     at net.aufdemrand.denizencore.tags.TagManager.fillArguments(TagManager.java:324)
[01:41:55] [Server thread/WARN]:     at net.aufdemrand.denizencore.scripts.commands.CommandExecuter.execute(CommandExecuter.java:204)
[01:41:55] [Server thread/WARN]:     at net.aufdemrand.denizencore.scripts.queues.ScriptEngine.revolve(ScriptEngine.java:51)
[01:41:55] [Server thread/WARN]:     at net.aufdemrand.denizencore.scripts.queues.ScriptQueue.revolve(ScriptQueue.java:660)
[01:41:55] [Server thread/WARN]:     at net.aufdemrand.denizencore.scripts.queues.core.InstantQueue.onStart(InstantQueue.java:53)
[01:41:55] [Server thread/WARN]:     at net.aufdemrand.denizencore.scripts.queues.ScriptQueue.start(ScriptQueue.java:519)
[01:41:55] [Server thread/WARN]:     at net.aufdemrand.denizen.Denizen.onCommand(Denizen.java:1018)
[01:41:55] [Server thread/WARN]:     at org.bukkit.command.PluginCommand.execute(PluginCommand.java:44)
[01:41:55] [Server thread/WARN]:     at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:141)
[01:41:55] [Server thread/WARN]:     at org.bukkit.craftbukkit.v1_8_R2.CraftServer.dispatchCommand(CraftServer.java:646)
[01:41:55] [Server thread/WARN]:     at net.minecraft.server.v1_8_R2.PlayerConnection.handleCommand(PlayerConnection.java:1139)
[01:41:55] [Server thread/WARN]:     at net.minecraft.server.v1_8_R2.PlayerConnection.a(PlayerConnection.java:974)
[01:41:55] [Server thread/WARN]:     at net.minecraft.server.v1_8_R2.PacketPlayInChat.a(PacketPlayInChat.java:45)
[01:41:55] [Server thread/WARN]:     at net.minecraft.server.v1_8_R2.PacketPlayInChat.a(PacketPlayInChat.java:1)
[01:41:55] [Server thread/WARN]:     at net.minecraft.server.v1_8_R2.PlayerConnectionUtils$1.run(SourceFile:13)
[01:41:55] [Server thread/WARN]:     at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
[01:41:55] [Server thread/WARN]:     at java.util.concurrent.FutureTask.run(FutureTask.java:262)
[01:41:55] [Server thread/WARN]:     at net.minecraft.server.v1_8_R2.SystemUtils.a(SourceFile:60)
[01:41:55] [Server thread/WARN]:     at net.minecraft.server.v1_8_R2.MinecraftServer.A(MinecraftServer.java:712)
[01:41:55] [Server thread/WARN]:     at net.minecraft.server.v1_8_R2.DedicatedServer.A(DedicatedServer.java:368)
[01:41:55] [Server thread/WARN]:     at net.minecraft.server.v1_8_R2.MinecraftServer.z(MinecraftServer.java:651)
[01:41:55] [Server thread/WARN]:     at net.minecraft.server.v1_8_R2.MinecraftServer.run(MinecraftServer.java:554)
[01:41:55] [Server thread/WARN]:     at java.lang.Thread.run(Thread.java:745)
[01:41:55] [Server thread/WARN]: Caused by: java.util.ConcurrentModificationException
[01:41:55] [Server thread/WARN]:     at java.util.HashMap$HashIterator.nextEntry(HashMap.java:922)
[01:41:55] [Server thread/WARN]:     at java.util.HashMap$EntryIterator.next(HashMap.java:962)
[01:41:55] [Server thread/WARN]:     at java.util.HashMap$EntryIterator.next(HashMap.java:960)
[01:41:55] [Server thread/WARN]:     at net.aufdemrand.denizen.tags.core.ServerTags.serverTag(ServerTags.java:482)
[01:41:55] [Server thread/WARN]:     ... 59 more
[01:41:55] [Server thread/INFO]:  ERROR in script 'SQLMANAGER_CONNECTIONCHECK'! Tag 
                   <server.list_sql_connections.contains[SQLAPI]> is invalid! 
[01:41:55] [Server thread/INFO]: SQLAPI: Database Offline!
[01:41:55] [Server thread/INFO]: SQLManager: Restarting SQLAPI system...
[01:41:55] [Server thread/INFO]: SQLManager: Stopping SQLAPI Heartbeat...
[01:41:55] [Server thread/INFO]: SQLManager: System disabled...
[01:41:55] [Server thread/INFO]: SQLAPI: Unloading config.yml file...
[01:41:55] [Server thread/INFO]: SQLAPI: System disabled...
[01:41:55] [Server thread/INFO]: SQLAPI: Loading system config files...
[01:41:55] [Server thread/INFO]: SQLAPI: System config files Loaded!
[01:41:55] [Server thread/INFO]: SQLManager: Requisite data found!
[01:41:55] [Server thread/INFO]: SQLManager: Loading connection data...
[01:41:55] [Server thread/INFO]: SQLManager: Attempting to connect to server...
[01:41:55] [Server thread/INFO]:  Filled tag 
                   <proc[SQLAPI_ListFlags].context[p@af5efd2a-f19b-47ef-a4bb-9c585108b3d4]||null> 
                   with 'SQLAPI OFFLINE'. 
[01:41:55] [Server thread/INFO]: +> Executing 'NARRATE': Narrating='SQLAPI OFFLINE'  
                   Targets='[p@Nilsentience]' 
[01:41:55] [Server thread/INFO]:  Completing queue 'EXCOMMAND_ProductionStemDraw' in 27ms. 
[01:41:56] [Server thread/INFO]: SQLManager: Successfully connected to server!
[01:41:56] [Server thread/INFO]: SQLManager: SQLAPI database found...
[01:41:56] [Server thread/INFO]:  ERROR in script 'SQLMANAGER_CONNECTIONCHECK'! Not connected 
                   to server with ID 'SQLAPI'! 
[01:41:56] [Server thread/INFO]: SQLManager: Attempting to connect to the SQLAPI database...
[01:41:57] [Server thread/INFO]: SQLManager: Connected to the SQLAPI database!
[01:41:57] [Server thread/INFO]: SQLManager: Initializing tables...
[01:41:57] [Server thread/INFO]: SQLManager: dsqlapi_playersqlflags table found...
[01:41:57] [Server thread/INFO]: SQLManager: dsqlapi_entitysqlflags table found...
[01:41:57] [Server thread/INFO]: SQLManager: dsqlapi_serversqlflags table found...
[01:41:57] [Server thread/INFO]: SQLManager: dsqlapi_npcsqlflags table found...
[01:41:57] [Server thread/INFO]: SQLManager: SQLAPI database loaded!
[01:41:57] [Server thread/INFO]: SQLManager: Starting SQLAPI Connection Heartbeat...
[01:41:57] [Server thread/INFO]: SQLManager: Processing Offline Queue for SQLAPI...
[01:41:57] [Server thread/INFO]: SQLManager: SQLAPI Now Online!
[01:41:57] [Server thread/INFO]: SQLManager: Reloading SQLManager cache.yml...
[01:41:57] [Server thread/INFO]: SQLManager: cache.yml Loaded!
[01:41:57] [Server thread/INFO]: SQLAPI: System loaded!