• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Serious Problem with Database

SlashX

SlashX

Member
Joined
Jul 4, 2007
Messages
71
Reaction score
5
Problem with Shutdown Save & Emergency Save

Hello,

First... I come using the Forgotten sufficient the time, and i consider the Forgotten a better OT-Version currently. And would like to give congratulations developers of the project.

However...

The forgotten don't is completely steady and the database is very harmed with this.

Example: If the server crash, almost always the House Itens they disappear... causing a great upheaval with the players.

Or if the PC-Server shutdown because a energy problem, almost always have a problem with the House Itens... (PS: the times, even house owners is reseted).

For this, i have a sugestion of create a better system to prevent it problems. I wait that they give attention to this.

EDITED:
I walked studying, and i belive that problem happens on a possible function that make the "emergency save" (on server crash) or server shutdown (on close server with GUI Mode).

PS:
Error happens with GREAT frequency if you use ForgottenGUI Mode to compile (because of saveData (g_game.saveData(false) function on close server i belive...).
Now i test with the c++ compiler __EXCEPTION_TRACER__ disabled and on Console Mode (when my server back online... because I am suffering DOS Attack with great frequence :/).

Thanks!
 
Last edited:
I've never had problems with this before... sure its not something with your SQL server?

//Saphira
 
or simply that your serversave doesn't save the map (houseitems)?
 
i disable serversave (setting > 24 in config)...

i noticed that this problem sometimes happens on close server (exit)... sometimes the server don't "close with sucess" and happens a error (like in server crash)... and houseitems disappear :(

More someone have this bug??

thanks!
 
Setup a cronjob to create database backups hourly or daily, you're not the only one with this problem, happens to CipSoft too from time to time (the resets one day back on different).
 
I use the MySQL Gui Tools 5.0 to create a backups 6 in 6 hours :D

But this problem let the players dissatisfied (this has happened with great frequency)...

I walked studying, and i belive that problem happens on a possible function that make the "emergency save" or server shutdown (on close server).

PS:
Error happens with GREAT frequency if you use ForgottenGUI Mode to compile (because of saveData (g_game.saveData(false);) function on close server i belive...).
Now i test with the c++ compiler __EXCEPTION_TRACER__ disabled and on Console Mode (when my server back online... because I am suffering DOS Attack with great frequence :/).

Tnks!
 
Last edited:
I have the same error, each time I close the server I get a PC error about not being able to read the memory.
 
Talaturen said:
Setup a cronjob to create database backups hourly or daily, you're not the only one with this problem, happens to CipSoft too from time to time (the resets one day back on different).
Click to expand...

It's not very easy to setup cron on windows..
 
scriptha said:
It's not very easy to setup cron on windows..
Click to expand...

That's Winblows fault, better use Linux for servers, it's faster, higher security, no blue screens, great support, great package managers to keep everything updated, it's free, or shorter said with just two words... NO MICROSOFT.
 
There's a compiling one-liner in the README file.
 
i using windows xp to host mine server by 2 years and i not have problems with "blue screens" and others cited here ^^

now i thinking in migrate my server from windows xp to windows 2003 server :D

PS: Great versions of Linux (like RedHat or old Conectiva) reach cost $1000,00+ :O
in some version reach cost easy $2000,00+ :O

it is free? :O
or the good versions is privated?...
 
Last edited:
Vagabond said:
Microsoft's OS = fail.
Microsoft's Compiler = win.
Microsoft's Game System = win x 2.

Microsoft's not all bad. :*
Click to expand...

I've never tried MSVC so I have no comments about their compiler, Winblows game-compatibility is indeed alot better than Linux, but this thread is about server hosting and not gaming :p.
 
:S

about topic...

talaturen, if you make a Auto-ServerSave (to make a save each one hour for example) and disable all save on event (on server crash, on saver close and etc), this problem would not be corrected? (or at least reduced?).

thanks!
 
aff this problem is one bug of server is after the merging of revnetys before of revnetsys rev 371 dont have this problem i go use rev 371 because this bug happens with very great frequency here and my patience over.

@SlashX
the best distros of linux is ubuntu and debian and it's free,
RedHat and Conectiva is sux.
 
Last edited:
i have the same problem, its really annoying :( i just custom-coded an autosave every hour to prevent house losses
 
You must log in or register to reply here.
Back
Top