Dropping sql connection

Question

Dropping sql connection

krustymk opened this issue 9 years ago · 16 comments

krustymk commented 9 years ago

23:26:03
SQLDataStorage.executeQuery
SQLException: Communications link failure
Console

18/06/2016 23:26:03

23:26:03
The last packet successfully received from the server was 121,022 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago.
INFO

18/06/2016 23:26:03

23:26:03
SQLState: 08S01
VendorError: 0
Content-Type = application/java-archive
Content-Disposition = null
Content-Length = 469363

Database is on the same machine (dedicated box)
Autorank reports all setup correctly

Other sql plugins, no errors and working correctly
McMMMO no faults
Stats no faults
Core no faults

Staartvin · Answer 1 · 2016-06-29T13:45:22.000Z

Did you check that your MySQL database allows connection from third-party applications? (Autorank in this case)

krustymk · Answer 2 · 2016-06-29T16:57:42.000Z

If you had read to the end of the post you'd see the answer to that question

Staartvin · Answer 3 · 2016-06-29T16:59:14.000Z

Could you pass the console.log?

krustymk · Answer 4 · 2016-07-02T20:13:02.000Z

http://pastebin.com/pKDGWC6Y

krustymk · Answer 5 · 2016-07-02T20:15:57.000Z

Please remember, all plugins have been updated (at least several times) and spigot many times since 1.8 something
Dedicated box has been completely reinstalled since i first reported this also

Staartvin · Answer 6 · 2016-07-02T20:32:47.000Z

Could you try a different database, just to test if Autorank gives errors at that one? It doesn't have to have data in it.

krustymk · Answer 7 · 2016-07-03T05:11:25.000Z

still the same with a new database

krustymk · Answer 8 · 2016-07-03T06:44:39.000Z

07/03/2016 07:40:24
07:40:24SQLState: 08S01
VendorError: 0
SQLDataStorage.execute
SQLException: No operations allowed after statement closed.
SQLState: S1009
VendorError: 0
07:42:24SQLDataStorage.executeQuery
SQLException: Communications link failure
Console 07/03/2016 07:42:24
07:42:24The last packet successfully received from the server was 119,002 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago.
INFO 07/03/2016 07:42:24
07:42:24SQLState: 08S01
VendorError: 0
SQLDataStorage.execute
SQLException: No operations allowed after statement closed.
SQLState: S1009
VendorError: 0

just over and over

Staartvin · Answer 9 · 2016-07-04T11:23:33.000Z

I'm investigating this issue.

Staartvin · Answer 10 · 2016-07-04T11:51:41.000Z

Could you try this dev build and see if you still get the SQL error: http://62.131.38.74:8080/job/Autorank/531/

krustymk · Answer 11 · 2016-07-04T18:42:55.000Z

still the same unfortuantly

Staartvin · Answer 12 · 2016-07-05T09:12:22.000Z

Could you run /version autorank and give me your server log?

krustymk · Answer 13 · 2016-07-05T09:33:07.000Z

its a log from the restart at 4am till the command
http://pastebin.com/8Xb0xie6

Staartvin · Answer 14 · 2016-07-05T09:36:19.000Z

Hmm, it seems like you have both Autorank.jar and Autorank-3.7.5-Dev-531.jar installed. Could you remove both of them and download this one: https://www.spigotmc.org/resources/autorank.3239/update?update=102166 ?

krustymk · Answer 15 · 2016-07-05T23:36:44.000Z

Done as you asked
Still the same

Staartvin · Answer 16 · 2016-07-06T09:20:34.000Z

I'm not sure what's wrong then. Could you add me on Skype? (Staartvin)

Share to