PreciousStones

PreciousStones

269k Downloads

Purging does not work.

selfservice0 opened this issue ยท 7 comments

commented

purge

Clip from my config

cleanup:
player-inactivity-purge-days: 15
snitch-unused-purge-days: 15
purge-banned-players: true

commented

I tried PreciousStones build #202 and still no purge.

commented

I am having this same issue, and its starting to become urgent, on a large server we have more than 5000 snitches in the overworld now and the load is going to soon be untenable.

Without a fix we will have to stop using precious stones and turn to an in house solution at no small amount of hardship for the transition.

I will be happy to help out however is needed, hell if you can just point us to whats broken I can have one of my own programmers solve the problem.

commented

I'll be looking into this over the weekend.

commented

I tried the dev build on my server. Didnt work. Im assuming its supposed to purge the inactive accounts on start up still. Didnt do it :(
Untitled
Using PreciousStones Dev Build #205

@ttk2 Use Truncate. Its a MySQL command that empties the table.
TRUNCATE tableName;

http://dev.mysql.com/doc/refman/5.0/en/truncate-table.html

commented

Is there a SQL command or something I can run to cull the database until a release build with this fix is ready? Its getting pretty clear that PreciouStones is having trouble handling the thousands of built up snitches on my server.

commented

Have you tried the latest dev builds? I put a fix not long ago, not tested tho.

commented

Now that the purging feature is fixed, all inactive players along with their fields will be removed from the db and your worlds upon server restart.

Hope you didn't truncate the player's table. That doesn't really do anything other than remove the "last seen" information from the inactive players. For PS to be able to remove all the fields those inactive players placed on the worlds, PS will need the inactive players along with the last seen dates to exist in the players table.