PreciousStones

PreciousStones

269k Downloads

PS still crashing at shutdown.

gabekanegae opened this issue ยท 16 comments

commented

(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

commented

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.

commented

How many records do you have on the pstone_cuboids and pstone_fields tables?

commented

(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.

commented

Thanks, narrows it down.

commented

[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?

commented

Definitely a bug, there shouldn't be 45k dirty stones to save by shutdown time. I'll look into this.

commented

Can you share your config? You can remove the fields list. Need to see everything else.

commented

debug is off and I left one field. All the other (five) ones are the same, just with different block ID and radius.

http://pastebin.com/ta0563kd

Tell me if you need anything else.

commented

Did you use the enableall or disableall command by any chance?

commented

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.

commented

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.

commented

Too big for pastebin. Here, at Gist.

commented

Thanks.

commented

Do you need other plugins info aka full start log (aka full plugin list) or only stuff related to PS?

commented

Full start log, then just the PS stuff.

commented

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!