Hello,

i started a map refresh today and it was aborted with the message: The process crashed.

The Job ID is: 17096

Here still the last log entries:

2018-11-19 12:53:38 | Cleared a total of 1639 objects from movable_objects table.
2018-11-19 12:53:38 | Cleared a total of 14 containers from working_containers table.
2018-11-19 12:53:38 | +++ END CLEARING MOVABLE OBJECTS +++
2018-11-19 12:53:38 | +++ START CLEARING UNMOVABLE OBJECTS +++
2018-11-19 12:53:38 | 00.0 % | Unmovable object 0 of 7200 processed. 0 objects have been deleted.
2018-11-19 12:53:39 | 13.9 % | Unmovable object 1000 of 7200 processed. 0 objects have been deleted.
2018-11-19 12:53:39 | 27.8 % | Unmovable object 2000 of 7200 processed. 0 objects have been deleted.
2018-11-19 12:53:39 | 41.7 % | Unmovable object 3000 of 7200 processed. 0 objects have been deleted.
2018-11-19 12:53:39 | Fatal Exception
2018-11-19 12:53:39 | exception 'Exception' with message 'A MySQL query failed!
Error 1451: Cannot delete or update a parent row: a foreign key constraint fails (`lif_1`.`unmovable_objects_claims`, CONSTRAINT `FK_unmovable_objects_claims_unmovable_objects` FOREIGN KEY (`UnmovableObjectID`) REFERENCES `unmovable_objects` (`ID`))' in /var/www/terratool_shared/mysql.class.php:255
Stack trace:
#0 /var/www/terratool_shared/mysql.class.php(159): MySQL->handle_error('query', 'DELETE FROM unm...')
#1 /var/www/terratool_shared/mysql.class.php(104): MySQL->query_rs('DELETE FROM unm...')
#2 /var/www/terratool_worker/lib/libs.inc.php(490): MySQL->query('DELETE FROM unm...')
#3 /var/www/terratool_worker/lib/libs.inc.php(386): OperationsManager->flushObjQueue()
#4 /var/www/terratool_worker/refresh.php(541): OperationsManager->deleteObject(2, 19627)
#5 /var/www/terratool_worker/index.php(162): require_once('/var/www/terrat...')
#6 {main}
2018-11-19 12:53:39 | The process crashed.

I hope there's a simple solution to that.

Thank you for your help.

MfG Michl

Hi,
I've seen these issues in the logfile already. I'll have a fix ready tomorrow.
It happens only if unmovable objects (buildings) that are owned by guild claims are being deleted. So if you could refrain on that, in the meantime, it should still work.

Okay,
so it's not my fault right now

I thank you for your help.

MfG Michl

would you let me know here when you fixed one?

Thank you very much

Greetings Michl

sure

It should be working now. Please try again.

Okay, I'll test it soon.
I'll let you know.

Thanks for your effort.

Greetings to Jonathan

Greetings Michl

so I may report that as far as everything went well.

but one thing has happened, set bridges with your bridges tool have been removed.
The Adminlands are still there.

But nevertheless a big thank you for your fast fix.

Greetings Michl

I don't know if you have a solution for that,

if this message is spammed in the console then the ping ingame under Alt+N will go up a lot. Do you know why or if there is a solution?
Here is a log section
https://pastebin.com/4SAscRrd

Greetings Michl

it just means that your server (or database) is too slow to keep up with the things happening in the game.
not related to any mod or script.

try to reboot the machine if you can.