Server crashing on start-up after transfering DB [DEVS PLS HELP]

General discussion about Life is Feudal: Your Own, The main section and backbone of the forums.

Elusiven
Beta Tester
 
Posts: 55
Joined: 02 Mar 2015, 14:46

Server crashing on start-up after transfering DB [DEVS PLS HELP]

Post by Elusiven » 04 Dec 2015, 21:58

I tried to transfer my DB. I use mysql.exe for that. (I'm not using heidi sql because the file is more than 200mb)

Example:

mysql -h localhost -u [mysqlusername]
Enter password: [your pass]
use database_name
source dump.sql

It transfered all the data and tables but after i try to launch my server I get this error "Mutex can't be locked too long, it's possible a deadlock."

And in console it pops up with some terrain and geo data errors.


Any ideas anyone?? I've been doing DB transfers before and never had this problem.
Last edited by Elusiven on 05 Dec 2015, 15:10, edited 1 time in total.
Head Administrator of medievalkingdoms.eu

PVP server with elements of RP with factions, trading and kingdoms system. Join us for great fun:).
Image


Elusiven
Beta Tester
 
Posts: 55
Joined: 02 Mar 2015, 14:46

Re: Server crashing on start-up after transfering DB

Post by Elusiven » 04 Dec 2015, 23:36

These errors:


ERRR 2015-12-04 23:30:53.178 {02} <createWorld> ### CmChangeStore::setLastChangeID() - new version of geo is not matched to version of current changes for terid=444 (db=31656, curr=31648)
ERRR 2015-12-04 23:30:53.251 {02} <createWorld> ### CmChangeStore::_loadDbChanges() - can't set last version
ERRR 2015-12-04 23:30:53.287 {02} <createWorld> ### CmChangeStore::init() - can't read all patches from db(terid=444)
ERRR 2015-12-04 23:30:53.362 {02} <createWorld> ### CmPatcher::attachTerrain() - can't init CmChangeStore class. terID=444
INFO 2015-12-04 23:30:53.434 {02} <createWorld> ### CmPatcher::detachTerrain(444) -- removing previous store!
ERRR 2015-12-04 23:30:53.471 {02} <createWorld> ### TerrainDeformer::_attachTerrain() - can't register terrain#444 within patcher
ERRR 2015-12-04 23:30:53.547 {02} <createWorld> ### Fatal: Can't init terrain list (mirror path=""). Terminating.
ERRR 2015-12-04 23:30:53.619 {03} <[shutdownRequest]quit> #### Quit requested!!!
ERRR 2015-12-04 23:30:53.655 {03} <[shutdownRequest]quit> #### Shutting down!!!
ECHO 2015-12-04 23:30:53.691 {05} <destroyWorld> ###### *** ENDING MISSION
ERRR 2015-12-04 23:30:53.728 {05} <destroyWorld> ###### endGame: No game running!
WARN 2015-12-04 23:30:54.023 {05} <onServerDestroyed> ###### BtWorld::~BtWorld()
Head Administrator of medievalkingdoms.eu

PVP server with elements of RP with factions, trading and kingdoms system. Join us for great fun:).
Image


Elusiven
Beta Tester
 
Posts: 55
Joined: 02 Mar 2015, 14:46

Re: Server crashing on start-up after transfering DB

Post by Elusiven » 05 Dec 2015, 13:40

Alright, i fixed the issue my self, but it's very very BAD.

To fix this you need to manually change the forest/geo id versions in the database to the ones that are in the errors. It seems to work and server starts up after that.

I'm just wondering why that happens with bigger databases.... Anyone from LIF team care to answer?
Head Administrator of medievalkingdoms.eu

PVP server with elements of RP with factions, trading and kingdoms system. Join us for great fun:).
Image

User avatar
JamieKG
 
Posts: 16
Joined: 30 Dec 2015, 17:14
Location: England

Re: Server crashing on start-up after transfering DB [DEVS PLS HELP]

Post by JamieKG » 17 Jan 2016, 16:39

I have just had the same problem when trying to move the Database to a test server im not sure what is going on is there other data storage that the server uses other then sql ?
Eternal Gamer
Direct connect: lif.eternal-gamer.com:28000
Image


AdminVoxel
 
Posts: 1
Joined: 06 Jul 2016, 11:11

Re: Server crashing on start-up after transfering DB [DEVS PLS HELP]

Post by AdminVoxel » 06 Jul 2016, 11:15

Hi :)

I come post a solution with small explication, little english.

check this first error:

ERRR 2015-12-04 23:30:53.178 {02} <createWorld> ### CmChangeStore::setLastChangeID() - new version of geo is not matched to version of current changes for terid=444 (db=31656, curr=31648)

In my case, i,m a server migration. after that, sames prblms with my DB.
i came back on my old server, Updated my server, and repushed it on my new server.
Bug solved easyly :)

Kiss all


Suty138
 
Posts: 6
Joined: 23 Sep 2017, 12:41

Re: Server crashing on start-up after transfering DB

Post by Suty138 » 29 Sep 2017, 21:30

Elusiven wrote:....manually change the forest/geo id versions in the database to the ones that are in the errors.


can someone explain this to me step by step. i have the same problem here, but can´t fix it :cry:


this is the error i get

ERRR 2017-09-29 23:10:30.302 {02} <createWorld> [0] [line #6497] CmChangeStore::setLastChangeID() - new version of geo is not matched to version of current changes for terid=442 (db=1, curr=221)

so there do i have to change what?


Suty138
 
Posts: 6
Joined: 23 Sep 2017, 12:41

Re: Server crashing on start-up after transfering DB [DEVS PLS HELP]

Post by Suty138 » 02 Oct 2017, 09:27

ok found the right table, but now i get the following error message:

RN 2017-10-02 11:24:29.010 {02} <createWorld> [0] DB::RS(1 ms) SELECT `ForestVersion` FROM `terrain_blocks` WHERE `ID`=442
WARN 2017-10-02 11:24:29.231 {02} <createWorld> [0] DB::RS(221 ms) SELECT `Version`, `Action`, `GeoDataID`, `SubcellMask`, `TreeType`, `TreeHealth`, `TreePlantMethod`, `AddTime` FROM `forest_patch` WHERE `TerID`=442 ORDER BY `Version`
WARN 2017-10-02 11:24:29.232 {02} <createWorld> [0] DB::noRS(1 ms) COMMIT;
ERRR 2017-10-02 11:24:29.234 {02} <createWorld> [0] [line #6596] CmChangeStore::_pushChange() - not sequentially change add. added=6141, startID=2, count=5592
ERRR 2017-10-02 11:24:29.235 {02} <createWorld> [0] [line #5995] CmChangeStore::_scanForestChanges_db() - can't push change
ERRR 2017-10-02 11:24:29.241 {02} <createWorld> [0] [line #5454] CmChangeStore::_loadDbChanges() - can't scan db changes
ERRR 2017-10-02 11:24:29.241 {02} <createWorld> [0] [line #4519] CmChangeStore::init() - can't read all patches from db(terid=442)
ERRR 2017-10-02 11:24:29.241 {02} <createWorld> [0] [line #343] CmPatcher::attachTerrain() - can't init CmChangeStore class. terID=442
INFO 2017-10-02 11:24:29.241 {02} <createWorld> [0] CmPatcher::detachTerrain(442) -- removing previous store!
ERRR 2017-10-02 11:24:29.241 {02} <createWorld> [0] [line #6236] TerrainDeformer::_attachTerrain() - can't register terrain#442 within patcher
ERRR 2017-10-02 11:24:29.241 {02} <createWorld> [0] Fatal: Can't init terrain list (mirror path=""). Terminating.


Suty138
 
Posts: 6
Joined: 23 Sep 2017, 12:41

Re: Server crashing on start-up after transfering DB [DEVS PLS HELP]

Post by Suty138 » 03 Oct 2017, 20:02

ok problem solved:

DELETE forest, forest_patch
FROM forest, forest_patch
WHERE forest.GeoDataID = forest_patch.GeoDataID AND
forest.Quality < 10;

SET @c442 = 1;
SET @c443 = 1;
SET @c444 = 1;
SET @c445 = 1;
SET @c446 = 1;
SET @c447 = 1;
SET @c448 = 1;
SET @c449 = 1;
SET @c450 = 1;

UPDATE forest_patch
SET Version = @c442:=@c442+1
WHERE TerID = 442;

UPDATE forest_patch
SET Version = @c443:=@c443+1
WHERE TerID = 443;

UPDATE forest_patch
SET Version = @c444:=@c444+1
WHERE TerID = 444;

UPDATE forest_patch
SET Version = @c445:=@c445+1
WHERE TerID = 445;

UPDATE forest_patch
SET Version = @c446:=@c446+1
WHERE TerID = 446;

UPDATE forest_patch
SET Version = @c447:=@c447+1
WHERE TerID = 447;

UPDATE forest_patch
SET Version = @c448:=@c448+1
WHERE TerID = 448;

UPDATE forest_patch
SET Version = @c449:=@c449+1
WHERE TerID = 449;

UPDATE forest_patch
SET Version = @c450:=@c450+1
WHERE TerID = 450;

SET @c442 = (SELECT Max(Version) as max FROM forest_patch WHERE TerID = 442 ORDER BY TerID);
SET @c443 = (SELECT Max(Version) as max FROM forest_patch WHERE TerID = 443 ORDER BY TerID);
SET @c444 = (SELECT Max(Version) as max FROM forest_patch WHERE TerID = 444 ORDER BY TerID);
SET @c445 = (SELECT Max(Version) as max FROM forest_patch WHERE TerID = 445 ORDER BY TerID);
SET @c446 = (SELECT Max(Version) as max FROM forest_patch WHERE TerID = 446 ORDER BY TerID);
SET @c447 = (SELECT Max(Version) as max FROM forest_patch WHERE TerID = 447 ORDER BY TerID);
SET @c448 = (SELECT Max(Version) as max FROM forest_patch WHERE TerID = 448 ORDER BY TerID);
SET @c449 = (SELECT Max(Version) as max FROM forest_patch WHERE TerID = 449 ORDER BY TerID);
SET @c450 = (SELECT Max(Version) as max FROM forest_patch WHERE TerID = 450 ORDER BY TerID);

UPDATE terrain_blocks
SET ForestVersion = @c442
WHERE ID = 442;

UPDATE terrain_blocks
SET ForestVersion = @c443
WHERE ID = 443;

UPDATE terrain_blocks
SET ForestVersion = @c444
WHERE ID = 444;

UPDATE terrain_blocks
SET ForestVersion = @c445
WHERE ID = 445;

UPDATE terrain_blocks
SET ForestVersion = @c446
WHERE ID = 446;

UPDATE terrain_blocks
SET ForestVersion = @c447
WHERE ID = 447;

UPDATE terrain_blocks
SET ForestVersion = @c448
WHERE ID = 448;

UPDATE terrain_blocks
SET ForestVersion = @c449
WHERE ID = 449;

UPDATE terrain_blocks
SET ForestVersion = @c450
WHERE ID = 450;

Return to General Discussion