[HELP] Database Server / World Server Crashing !

09/15/2014 08:01 princed2nd#1
Hello I've been having this problem for 4 days now :( I have a VPS HOST. which is 3GB ram .. 400 GB HDD .. my server is still a open beta..

But it is very annoying that the DATABASE is always crashing and need to restart all 7 application again so that they can connect. But it make them rollback again and again.

same as world server.. but most of the time database is always crashing. while the world server is sometimes only..

Thanks in advance Please help me :(
09/15/2014 08:10 Burdenz2007#2
This is ETC Flyff right? The source of Orthedor? The bugged files.
I heard you have a dev? Why not ask him?
09/15/2014 08:31 princed2nd#3
He said there is no error logs.. from database/worldserver.. that's why I'm asking here to ask if there's a way on how to fix the problem.
09/15/2014 09:05 Burdenz2007#4
Then your dev is a FAIL DEV. Thats impossible. Every crash has Error Logs in it. :)
He just dont know where to look.
09/15/2014 09:14 princed2nd#5
Sometimes it can last up to 4 hours. sometimes 3 hours somethimes 1 hour sometimes 15 minutes.. I really don't know what's the cause of it ..

my server host is 2gb and now 3gb ram just upgraded it today... I'm wondering if I really need to use 4gb and up just to make it stable.. could anyone please help me ? and give opinion/suggestion ? I really need an answer.
09/15/2014 09:27 xTwiLightx#6
Let your server run in debug mode or let your server dump it's memory stack and other information at crash.
09/15/2014 10:06 princed2nd#7
Good day twilight what do you mean by let my server run in debug mode or let my server dump its memory.. btw is 3gb not enough ??? 400 GB HDD
09/15/2014 10:22 xTwiLightx#8
3GB is not a good amount of RAM, 4GB at least, 8GB are recommended.
Everything above will just be needed with SQL Server versions above Express and lots of players (-> WorldServer RAM usage).

Well, if you (or your "dev") is compiling the source code to get the binaries, you (or he) should know Visual Studio's debugging feature.
09/15/2014 11:54 princed2nd#9
But do you think one of the reason why my database and world server crashing is due to lack of Memory? my previous ram is 2gb. and just upgraded today to 3gb same problem .

look @ the task manage is it normal ?

[Only registered and activated users can see links. Click Here To Register...]

This is the Full LOGS of sept 15.. I would be very thankful if someone could help me find the errors so I could tell this to my developer . Please help me

This is the link of the LOGS OF SEPTEMBER 15,2014
[Only registered and activated users can see links. Click Here To Register...]
09/15/2014 13:45 xTwiLightx#10
~2 GB RAM usage is quite normal.
  • Few models dont have an entry in mdlObj.inc.
  • Something is wrong with your continent data
    • CTax::GetTaxInfo() - À߸øµÈ ´ë·úÁ¤º¸ 0
    • 0 is the continent
  • CEventLua::SetLevelUpGift() - ItemProp is NULL. ItemId = "II_SYS_SYS_GM_SKLVLALL"
    • Your Item II_SYS_SYS_GM_SKLVLALL is not defined or has invalid properties
  • GetItemProp range_error min:0, max:224903, index:-1
    • no real hint, but I think an item is spawned in world which is not defined in defineItem.h

Well, that CTax error should not arrear, since that 0 gets caught here:
Code:
	if( nContinent == CONT_NODATA )
		return 0.0f;

	__TAXINFO* taxInfo = GetTaxInfo( nContinent );
CONT_NODATA = 0.
So GetTaxInfo should not be called when nContinent is 0 - which is happening here. That circumstance is throwing you that error in GetTaxInfo:

Code:
__TAXINFO* CTax::GetTaxInfo( BYTE nContinent )	// ÇØ´ç ´ë·úÀÇ ¼¼À² Á¤º¸
{
	if( m_mapTaxInfo.find( nContinent ) != m_mapTaxInfo.end() )
		return m_mapTaxInfo.find( nContinent )->second;
#ifndef __CLIENT
	else
		Error( "CTax::GetTaxInfo() - À߸øµÈ ´ë·úÁ¤º¸ %x", nContinent );
#endif // __CLIENT
Something is really upset in your "dev's" sourcecode.
09/15/2014 13:50 xMeher#11
Try to debug it , btw "400 GB HDD" for a Flyff server ? GGWP.
09/15/2014 13:55 princed2nd#12
SO MEANING. THERE IS NO PROBLEM WITH THE VPS? In short The error is from the files. Twilight May I know your FB name? your info is very useful .

Actually I don't understand what errors are that. because I don't have any experience developing a server just hiring and paying a dev to set up my server and maintain it.

That's why I asked my dev if there is a server files error. and they said there is no problem about the server files. But you said just right now there is ! . Thank you so much Gonna tell this to them. Btw it would be nice if you can PM me ur fb hehe thanks :D

Quote:
Originally Posted by xMeher View Post
Try to debug it , btw "400 GB HDD" for a Flyff server ? GGWP.
It's a package of a 3GB RAM VPS xD ...
09/16/2014 08:45 xTwiLightx#13
Quote:
Originally Posted by princed2nd View Post
SO MEANING. THERE IS NO PROBLEM WITH THE VPS? In short The error is from the files. Twilight May I know your FB name? your info is very useful .

Actually I don't understand what errors are that. because I don't have any experience developing a server just hiring and paying a dev to set up my server and maintain it.

That's why I asked my dev if there is a server files error. and they said there is no problem about the server files. But you said just right now there is ! . Thank you so much Gonna tell this to them. Btw it would be nice if you can PM me ur fb hehe thanks :D



It's a package of a 3GB RAM VPS xD ...
I not gonna share private data here. ;)
This is a job for your developer - not mine :P
09/16/2014 12:35 Burdenz2007#14
Quote:
Originally Posted by xTwiLightx View Post
~2 GB RAM usage is quite normal.
  • Few models dont have an entry in mdlObj.inc.
  • Something is wrong with your continent data
    • CTax::GetTaxInfo() - À߸øµÈ ´ë·úÁ¤º¸ 0
    • 0 is the continent
  • CEventLua::SetLevelUpGift() - ItemProp is NULL. ItemId = "II_SYS_SYS_GM_SKLVLALL"
    • Your Item II_SYS_SYS_GM_SKLVLALL is not defined or has invalid properties
  • GetItemProp range_error min:0, max:224903, index:-1
    • no real hint, but I think an item is spawned in world which is not defined in defineItem.h

Well, that CTax error should not arrear, since that 0 gets caught here:
Code:
    if( nContinent == CONT_NODATA )
        return 0.0f;

    __TAXINFO* taxInfo = GetTaxInfo( nContinent );
CONT_NODATA = 0.
So GetTaxInfo should not be called when nContinent is 0 - which is happening here. That circumstance is throwing you that error in GetTaxInfo:

Code:
__TAXINFO* CTax::GetTaxInfo( BYTE nContinent )    // ÇØ´ç ´ë·úÀÇ ¼¼À² Á¤º¸
{
    if( m_mapTaxInfo.find( nContinent ) != m_mapTaxInfo.end() )
        return m_mapTaxInfo.find( nContinent )->second;
#ifndef __CLIENT
    else
        Error( "CTax::GetTaxInfo() - À߸øµÈ ´ë·úÁ¤º¸ %x", nContinent );
#endif // __CLIENT
Something is really upset in your "dev's" sourcecode.
Well the real thing is he just bought a ready made source from a guy called "othedor cipher". a source full of crap. :handsdown:
09/17/2014 06:35 princed2nd#15
Already solved :D Thanks to all of your help :D we just changed the server files.

SOLVED (Y) -CLOSED-