PS still crashing at shutdown.
gabekanegae opened this issue ยท 16 comments
(Check #812)
PreciousStones still crashes at /stop for me.
"Shutting Down: Saving all pending data..."
Then it timeouts.
I'm using latest from Jenkins, 494
Turn on show-debug-info in the config, then try it again. It should print out all SQL queries happening while it saves. That should give us a clue.
How many records do you have on the pstone_cuboids and pstone_fields tables?
(getting data from ~30h old .db)
pstone_cuboids is at ~45k (probably the 45950 that debug showed us)
pstone_fields is clean.
As mentioned in the other ticket,
Only the pstone_cuboids and pstone_players tables have data in it.
[Queue] processing 45950 pstone queries...
and countless
"UPDATE
pstone_cuboids
SET flags = '{"disabledFlags":["prevent-portal-enter","prevent-portal-destination"]}' WHERE x = -974 AND y = 21 AND z = -1413 AND world = 'world';"
Multicraft seems to be terminating the server after 35s of SQL updates. As I said in #812,
I tried to run it locally a couple months ago, and it disabled fine. For some reason it didn't/doesn't when ran at any host.
That might explain things a bit. Not sure what to do to fix it atm, but when run locally, it takes <5s to save everything. How much time is the update/saving supposed to take?
Definitely a bug, there shouldn't be 45k dirty stones to save by shutdown time. I'll look into this.
Can you share your config? You can remove the fields list. Need to see everything else.
debug is off and I left one field. All the other (five) ones are the same, just with different block ID and radius.
Tell me if you need anything else.
Like, ever? I've been using PS for more than 2 years with the same .db. I do not remember using it, but.. you know, 2 years and a lot of staff.
If you mean during the time between restarts, no, I didn't. The '45950 queries' one was the log for the server that was online for around 10 minutes.
That's what I needed to know. Thanks. Can you send me the entire debug output (with debug on) from server start to server shutdown/timeout? Removing any sensitive info/lines. Need to track down what happens.
Too big for pastebin. Here, at Gist.
Do you need other plugins info aka full start log (aka full plugin list) or only stuff related to PS?
Huh... http://pastebin.com/XTdmmyVH
Server and all other plugins are disabling fine now, at least PS is not crashing everything, just itself.
EDIT: Looks like that happened only once. I've started and stopped the server a couple times and PS is disabling totally as expected! Thanks!