Database Connections kicking players
Issue #3
open
"It's looking like your database cannot be reached when the plugin needs to.
Is your sql server local or external? Do you get this error after the server has been running for some time? What are your database's settings for the connection pool (max connections / idle time / max life time etc).
I prefer issues to be reported here2 so that other people can easily find it in the future."
and yes i get it after the server has been running for awhile. http://pastebin.com/kwVdxxh5
external, 10000 max, idle is 600s
Comments (5)
-
-
repo owner
@FrostEffects There is experimental support for sqlite. Experimental as in I ported it over from the bukkit version but it has never been tested to work..
So feel free to test that out if you want to use sqlite (by configuring dbms-type to sqlite).
EDIT: Looking at the code for sqlite I don't think it's currently going to work. I will get that fixed right away. I'd like to get you up and running asap so if sqlite is the answer for you, then I can focus on that first and work on the mysql timeout issue later.
-
That would be a wonderful start atleast. Your plugin is ideally the backbone of my server and hooks into literally everything. I had sqlite on the server but it simply doesnt save nearly as often to keep data from rolling back if someone messes up and ends up crashing the server after its been online for several days. The other issue is once this data is lost we have to go back into each enjin and rerun/retag the commands to invite them back. (done with enjin so that it also adds groups to the player for hooking into other plugins like griefprevention for claim access, warp access, etc.)
-
repo owner
Alright, I haven't gotten sqlite to work yet because of some of its limitations. Its usage is "strongly discouraged" anyway so instead I have added support for h2.
Please try out Development Build 1.4.1-DEV-16 available on http://ci.direstone.com/.
Use these config settings:
- use-database: true
- dbms-type: h2
- database-name: <file name / location>
If you only use a name for the database-name (without a file path) the database is put relative to the plugin's config folder.
Let me know if this is a solution you can work with for now.
-
repo owner
- changed status to open
- Log in to comment
Is there anyway we can just get an update for sqlite where it saves to the db often? because Its killing my server pop everytime it trys making a connection and I'm unsure on what i need to change. I followed the steps on setting it up but still getting disconnects.