I'm using a dedicated server runing on Debian, which I have set accordingly with the how to's and videos found here and there.
Just wondering if some one has an idea ...
The server starts fine, I can make a char and log in. I can play, everything goes fine, I can harvest everything, all fine.
After few hours (maybe related to the day cycle), issues start to appears with this in game message
"You can't do it. That item doesn't exist." when trying to get a branch, or bark, or plant fibre. Almost every gather action reply this error.
In the server folder\logs\
- Code: Select all
ERRR 2014-10-16 13:00:08.412 {00} <NOSCOPE> DB error #1305: FUNCTION f_addForestPatch does not exist. Query: select f_addForestPatch(442,2,116102892,NULL/*0*/,NULL/*0*/,1,NULL/*0*/)
WARN 2014-10-16 13:00:08.412 {00} <NOSCOPE> DB::RS(1 ms) select f_addForestPatch(442,2,116102892,NULL/*0*/,NULL/*0*/,1,NULL/*0*/)
ERRR 2014-10-16 13:00:08.412 {00} <NOSCOPE> cmdb_addForestPatch() - DB error
ERRR 2014-10-16 13:00:08.413 {00} <NOSCOPE> cmdb_updateForestItemHealth() - can't create forest change
ERRR 2014-10-16 13:00:08.413 {00} <NOSCOPE> ForestData::updateItem() - can't update tree in db
WARN 2014-10-16 13:00:08.413 {00} <NOSCOPE> ForestData::_updateItemsHealth() - can't update item health at geoid 116102892
ERRR 2014-10-16 13:00:08.413 {00} <NOSCOPE> DB error #1305: FUNCTION f_addForestPatch does not exist. Query: select f_addForestPatch(442,2,115980738,NULL/*0*/,NULL/*0*/,1,NULL/*0*/)
WARN 2014-10-16 13:00:08.414 {00} <NOSCOPE> DB::RS(0 ms) select f_addForestPatch(442,2,115980738,NULL/*0*/,NULL/*0*/,1,NULL/*0*/)
ERRR 2014-10-16 13:00:08.414 {00} <NOSCOPE> cmdb_addForestPatch() - DB error
And so on ...
It seems that my db finally goes corrupted cause i'm facing the "cr_internal_db_error" some hours after the server started.
I have obviously tried to DROP DATABASE, make a new one, and import the .sql with the same results.
I went one step before, and deleted my database from Windows, made a new one (utf8 general ci), and sent (in one go) the content of new.sql. Still same results.
Done again from this step but added the content of patch.sql, after I did the new.sql, even if I have no errors during this step, the end result is the same ...
Here is another error found in my log file which could be related
ERRR 2014-10-16 11:00:09.605 {00} <NOSCOPE> DB error #1305: FUNCTION f_createForestItem does not exist. Query: SELECT f_createForestItem(116075986,0,8,0,2.000000)
WARN 2014-10-16 11:00:09.606 {00} <NOSCOPE> DB::RS(0 ms) SELECT f_createForestItem(116075986,0,8,0,2.000000)
ERRR 2014-10-16 11:00:09.606 {00} <NOSCOPE> cmdb_addForestItem() - DB error
ERRR 2014-10-16 11:00:09.606 {00} <NOSCOPE> ForestData::addItem() - can't add tree in db
WARN 2014-10-16 11:00:09.606 {00} <NOSCOPE> ForestData::_addItems() - can't add tree at geoid=116075986
I can find both of this functions in the new.sql, which should mean that they are added to my db.
I'm a bit out of ideas actually ... So if anyone has a track, an idea, please just let me know so I can investigate
If any guy from the staff wants the full log files, just ask.
Thanks in advance !
F.
Edit This is the command I use when dumping my db from windows
- Code: Select all
mysqldump --routines -u root -p "lif_1" > "lifdu
mp.sql"