Extreme Lag

[Adondriel]

My server is experiencing extreme lag when someone sells. (not sure about buy) 1-4 seconds of lag each time.

I love the plugin either way, because nothing else does this anymore!! Thank you so much!(where is the donate button?)

[dkabot]

Everything in those commands involves around database usage, so it's an inherent issue. I would imagine there's some lag in the DB setup.

Anytime I've used it in testing it's near instant.

[Adondriel]

Is there a way to set it up to use mysql and not sqlite?

[dkabot]

Indeed there is! It uses bukkit persistence for the database, so you need to configure the database in bukkit.yml. See http://wiki.bukkit.org/Bukkit.yml#database for more information.

[Adondriel]

I did, it gave me errors saying the the id didn't have a default value

[dkabot]

Odd, I don't recall that when I did testing on MySQL. I'll have to get another rig of that and test it some more.

The ID should auto increment though, so I don't see why it's not...

[Adondriel]

knowing me i probably did something wrong. Ill test it later.

[Adondriel]

why does the server startup always freeze at:

17:39:45 [INFO] DataSourcePool [DkabotShop] autoCommit[false] transIsolation[SERIALIZABLE] min[2] max[20] 17:39:45 [INFO] SubClassFactory parent ClassLoader [org.bukkit.plugin.java.PluginClassLoader] ????

[dkabot]

That's generated by bukkit persistence (well, avaje ebean) as far as I can tell.

[Adondriel]

Is there a way to fix it freezing?

[dkabot]

I don't know enough about what's going on here to be able to say, really.

[Adondriel]

dang... I've had it happen with a different plugin once...

[Adondriel]

here is the entire thing until it gets to the freeze:

182 recipes 27 achievements 17:39:43 [INFO] Starting minecraft server version 1.2.5 17:39:43 [INFO] Loading properties 17:39:43 [INFO] Starting Minecraft server on :25565 17:39:43 [INFO] This server is running CraftBukkit version git-Bukkit-1.2.5-R1.0-b2149jnks (MC: 1.2.5) (Implementing API version 1.2.5-R1.0) 17:39:43 [INFO] Starting Minequery server on :25567 17:39:45 [INFO] DataSourcePool [DkabotShop] autoCommit[false] transIsolation[SERIALIZABLE] min[2] max[20] 17:39:45 [INFO] SubClassFactory parent ClassLoader [org.bukkit.plugin.java.PluginClassLoader]

[dkabot]

Sounds like an issue with the implementation of persistence and/or the database server then.

[Adondriel]

it is using sqlite... how is that an issue?

[dkabot]

sqlite should work fine with default settings, just (or so I've heard) it is less efficient for larger databases.

[Adondriel]

hmmm.. would my bukkit.yml help?

database: username: root isolation: SERIALIZABLE driver: org.sqlite.JDBC password: **** url: jdbc:sqlite:plugins/DkabotShop/DkabotShop.db

[dkabot]

That's a pretty big issue you have there. "url: jdbc:sqlite:plugins/DkabotShop/DkabotShop.db" tells it to use this database for EVERYTHING. When it's the sqlite rig, it's intended that all of them have their own db. The default for url is "url: jdbc:sqlite:{DIR}{NAME}.db"

The rest looks fine, though I'm not sure why you have a changed user/pass for sqlite.

[Adondriel]

the userpass was for when i was testing mysql

[Adondriel]

do i replace the {dir}{name}?

[dkabot]

No, leave it as-is. The server automatically replaces them

[dkabot]

Considering no developments on the issue have been made and apparently it's not only in this plugin the issue happens, I am closing this. Open a new issue if need be.