Life is Feudal Official Forum

[Ragonz]

So very very odd problem that I am having, Literally will send a case of beer to whoever can fix it.

Been running a LIF server for ages (since way before release) all has been working fine. Crashed the other day and now am getting the following message in logs

Code: Select all

//-------------------------- 12/5/2015 -- 00:46:59 -- v1.0.0.11 --
ECHO 2015-12-05 00:46:59.821 {00} <NOSCOPE> # --------- Loading DIRS ---------
INFO 2015-12-05 00:46:59.821 {00} <NOSCOPE> # v1.0.0.11
ECHO 2015-12-05 00:46:59.822 {00} <NOSCOPE> #
ECHO 2015-12-05 00:46:59.880 {01} <onStart> ##
--------- Initializing Directory: scripts ---------
ECHO 2015-12-05 00:46:59.881 {02} <initServer> ###
--------- Initializing LiF Server: Server Scripts ---------
ECHO 2015-12-05 00:46:59.888 {02} <initServer> ### Loading CmConfiguration
ECHO 2015-12-05 00:46:59.889 {02} <initServer> ### Init of DB interface
WARN 2015-12-05 00:46:59.895 {02} <initServer> ### DB::RS(1 ms) SHOW DATABASES LIKE 'lif_1';
ECHO 2015-12-05 00:46:59.895 {02} <initServer> ### Patching database [1/2]...
ECHO 2015-12-05 00:46:59.895 {02} <initServer> ### Patching database [2/2]...
ECHO 2015-12-05 00:46:59.895 {02} <initServer> ### Validating database...
ERRR 2015-12-05 00:46:59.895 {02} <initServer> ### DB error #1046: No database selected. Query: CALL sp_checkForeignKeys('animal_breeds', 1, 1);
ECHO 2015-12-05 00:46:59.895 {02} <initServer> ### DB trying to reconnect
ECHO 2015-12-05 00:46:59.896 {02} <initServer> ### DB connected
ERRR 2015-12-05 00:46:59.896 {02} <initServer> ### DB error #1046: No database selected. Query: CALL sp_checkForeignKeys('animal_breeds', 1, 1);
ECHO 2015-12-05 00:46:59.896 {02} <initServer> ### DB trying to reconnect
ECHO 2015-12-05 00:46:59.896 {02} <initServer> ### DB connected
ERRR 2015-12-05 00:46:59.896 {02} <initServer> ### DB error #1046: No database selected. Query: CALL sp_checkForeignKeys('animal_breeds', 1, 1);
ECHO 2015-12-05 00:46:59.896 {02} <initServer> ### DB trying to reconnect
ECHO 2015-12-05 00:46:59.897 {02} <initServer> ### DB connected
ERRR 2015-12-05 00:46:59.897 {02} <initServer> ### DB error #1046: No database selected. Query: CALL sp_checkForeignKeys('animal_breeds', 1, 1);
ECHO 2015-12-05 00:46:59.897 {02} <initServer> ### DB trying to reconnect
ECHO 2015-12-05 00:46:59.897 {02} <initServer> ### DB connected
ERRR 2015-12-05 00:46:59.897 {02} <initServer> ### DB error #1046: No database selected. Query: CALL sp_checkForeignKeys('animal_breeds', 1, 1);
ECHO 2015-12-05 00:46:59.898 {02} <initServer> ### DB trying to reconnect
ECHO 2015-12-05 00:46:59.899 {02} <initServer> ### DB connected
ERRR 2015-12-05 00:46:59.899 {02} <initServer> ### DB error #1046: No database selected. Query: CALL sp_checkForeignKeys('animal_breeds', 1, 1);
ECHO 2015-12-05 00:46:59.899 {02} <initServer> ### DB trying to reconnect
ECHO 2015-12-05 00:46:59.900 {02} <initServer> ### DB connected
WARN 2015-12-05 00:46:59.900 {02} <initServer> ### DB::mfRS(5 ms) CALL sp_checkForeignKeys('animal_breeds', 1, 1);
ERRR 2015-12-05 00:46:59.900 {02} <initServer> ### CmServerInfoManager::_applyDbPatch() - call to sp_checkForeignKeys failed
ERRR 2015-12-05 00:46:59.900 {02} <initServer> ### CmServerInfoManager::processLocalWorlds() - can't access to db for world id=1
ERRR 2015-12-05 00:46:59.900 {02} <initServer> ### Fatal: Can't init local world (id=1). Terminating.
ECHO 2015-12-05 00:46:59.900 {00} <NOSCOPE> # Engine initialized...
ECHO 2015-12-05 00:46:59.901 {00} <NOSCOPE> # Thread pool initialized, threads: 7
core/scripts/server/server.cs (78): Unable to find function destroyWorld
INFO 2015-12-05 00:46:59.903 {01} <onExit> ## The server has been shut down!

Now as if thats not strange enough I happen to have a server lying around that I thought "Hey, I'll just put it on there instead, obviously I have done somthing to my pc"

So installed windows 2012 R2, installed the C++ redist's and Maria DB (5.5.45) and whilst I was at it thought I'll start scratch so did not import any data.

Exactly the same error messages.
I have tried everything I can think of, multiple re-installs, fresh files from steam, confirmed I can access the database with the credentials in config_local.cs. What am I doing wrong?

[Elusiven]

DB error #1046: No database selected. error indicates that there either is no database connected, no database selected, or there is no lif tables in the database.

I can help you remotely fix it in my spare time if you want, maybe i can do it. I'm running a server on windows 2008 R2

[Ragonz]

DB error #1046: No database selected. error indicates that there either is no database connected, no database selected, or there is no lif tables in the database.

I can help you remotely fix it in my spare time if you want, maybe i can do it. I'm running a server on windows 2008 R2

Bear in mind that this was working fine up until a few days ago, nothing has changed on the original server and I am able to log into the database fine using heidisql.

On the new server with a fresh set of server files I get the same error despite there being no databases whatsoever (the server is supposed to create one automatically) and when I do manaually create a database and import all the data the error stays the same.

Servers are running 2012 R2 and I'm not being rude so please dont take it like that but I would prefer not letting anyone onto my servers, there is quite a lot of sensitive material on there from my work.

[HolyCrusader]

Anything changed at all the day or two before the server stopped working?

Did you change the mariadb "root" id and password? Make sure those are correct in the LiF cfg files (I think it is config_local.cs or main.cs?) & doublecheck the target line used to launch the server process (ensure that its -world #), the cfg file is called world_#.xml & inside the cfg file you have the same world # id

In heidiSQL what is the name of your database, is it actually lif_1?

[Ragonz]

No changes
Maria DB root password is correct and works (Copied and pasted out of Config_local.cs to ensure credentials correct)
world is called lif_1 inside mariadb
server is launched with -world 1

[HolyCrusader]

No changes
Maria DB root password is correct and works (Copied and pasted out of Config_local.cs to ensure credentials correct)
world is called lif_1 inside mariadb
server is launched with -world 1

Got another backup out there you can work from? Would be interested to see if that works

That log you posted, is that the log from AFTER you moved to a new server? On your database, check your triggers and see what credentials they are setup to run on (is it root@localhost as well)?

[HolyCrusader]

So very very odd problem that I am having, Literally will send a case of beer to whoever can fix it.

Been running a LIF server for ages (since way before release) all has been working fine. Crashed the other day and now am getting the following message in logs

Code: Select all

//-------------------------- 12/5/2015 -- 00:46:59 -- v1.0.0.11 --
ECHO 2015-12-05 00:46:59.821 {00} <NOSCOPE> # --------- Loading DIRS ---------
INFO 2015-12-05 00:46:59.821 {00} <NOSCOPE> # v1.0.0.11
ECHO 2015-12-05 00:46:59.822 {00} <NOSCOPE> #
ECHO 2015-12-05 00:46:59.880 {01} <onStart> ##
--------- Initializing Directory: scripts ---------
ECHO 2015-12-05 00:46:59.881 {02} <initServer> ###
--------- Initializing LiF Server: Server Scripts ---------
ECHO 2015-12-05 00:46:59.888 {02} <initServer> ### Loading CmConfiguration
ECHO 2015-12-05 00:46:59.889 {02} <initServer> ### Init of DB interface
WARN 2015-12-05 00:46:59.895 {02} <initServer> ### DB::RS(1 ms) SHOW DATABASES LIKE 'lif_1';
ECHO 2015-12-05 00:46:59.895 {02} <initServer> ### Patching database [1/2]...
ECHO 2015-12-05 00:46:59.895 {02} <initServer> ### Patching database [2/2]...
ECHO 2015-12-05 00:46:59.895 {02} <initServer> ### Validating database...
ERRR 2015-12-05 00:46:59.895 {02} <initServer> ### DB error #1046: No database selected. Query: CALL sp_checkForeignKeys('animal_breeds', 1, 1);
ECHO 2015-12-05 00:46:59.895 {02} <initServer> ### DB trying to reconnect
ECHO 2015-12-05 00:46:59.896 {02} <initServer> ### DB connected
ERRR 2015-12-05 00:46:59.896 {02} <initServer> ### DB error #1046: No database selected. Query: CALL sp_checkForeignKeys('animal_breeds', 1, 1);
ECHO 2015-12-05 00:46:59.896 {02} <initServer> ### DB trying to reconnect
ECHO 2015-12-05 00:46:59.896 {02} <initServer> ### DB connected
ERRR 2015-12-05 00:46:59.896 {02} <initServer> ### DB error #1046: No database selected. Query: CALL sp_checkForeignKeys('animal_breeds', 1, 1);
ECHO 2015-12-05 00:46:59.896 {02} <initServer> ### DB trying to reconnect
ECHO 2015-12-05 00:46:59.897 {02} <initServer> ### DB connected
ERRR 2015-12-05 00:46:59.897 {02} <initServer> ### DB error #1046: No database selected. Query: CALL sp_checkForeignKeys('animal_breeds', 1, 1);
ECHO 2015-12-05 00:46:59.897 {02} <initServer> ### DB trying to reconnect
ECHO 2015-12-05 00:46:59.897 {02} <initServer> ### DB connected
ERRR 2015-12-05 00:46:59.897 {02} <initServer> ### DB error #1046: No database selected. Query: CALL sp_checkForeignKeys('animal_breeds', 1, 1);
ECHO 2015-12-05 00:46:59.898 {02} <initServer> ### DB trying to reconnect
ECHO 2015-12-05 00:46:59.899 {02} <initServer> ### DB connected
ERRR 2015-12-05 00:46:59.899 {02} <initServer> ### DB error #1046: No database selected. Query: CALL sp_checkForeignKeys('animal_breeds', 1, 1);
ECHO 2015-12-05 00:46:59.899 {02} <initServer> ### DB trying to reconnect
ECHO 2015-12-05 00:46:59.900 {02} <initServer> ### DB connected
WARN 2015-12-05 00:46:59.900 {02} <initServer> ### DB::mfRS(5 ms) CALL sp_checkForeignKeys('animal_breeds', 1, 1);
ERRR 2015-12-05 00:46:59.900 {02} <initServer> ### CmServerInfoManager::_applyDbPatch() - call to sp_checkForeignKeys failed
ERRR 2015-12-05 00:46:59.900 {02} <initServer> ### CmServerInfoManager::processLocalWorlds() - can't access to db for world id=1
ERRR 2015-12-05 00:46:59.900 {02} <initServer> ### Fatal: Can't init local world (id=1). Terminating.
ECHO 2015-12-05 00:46:59.900 {00} <NOSCOPE> # Engine initialized...
ECHO 2015-12-05 00:46:59.901 {00} <NOSCOPE> # Thread pool initialized, threads: 7
core/scripts/server/server.cs (78): Unable to find function destroyWorld
INFO 2015-12-05 00:46:59.903 {01} <onExit> ## The server has been shut down!

Now as if thats not strange enough I happen to have a server lying around that I thought "Hey, I'll just put it on there instead, obviously I have done somthing to my pc"

So installed windows 2012 R2, installed the C++ redist's and Maria DB (5.5.45) and whilst I was at it thought I'll start scratch so did not import any data.

Exactly the same error messages.
I have tried everything I can think of, multiple re-installs, fresh files from steam, confirmed I can access the database with the credentials in config_local.cs. What am I doing wrong?

I looked around and I think this might help you with your issue:
https://steamcommunity.com/app/290080/d ... 472625620/

[Ragonz]

Using that seemed to fix it for a little bit but its back with avengance now.

Bear in mind this is happening across multiple identical servers each running different LiF instances.