[HELP] Database Server / World Server Crashing !

[princed2nd]

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

[Burdenz2007]

This is ETC Flyff right? The source of Orthedor? The bugged files.
I heard you have a dev? Why not ask him?

[princed2nd]

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.

[Burdenz2007]

Then your dev is a FAIL DEV. Thats impossible. Every crash has Error Logs in it.
He just dont know where to look.

[princed2nd]

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.

[xTwiLightx]

Let your server run in debug mode or let your server dump it's memory stack and other information at crash.

[princed2nd]

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

[xTwiLightx]

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.

[princed2nd]

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 ?



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

[xTwiLightx]

~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:

	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:

__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.

[xMeher]

Try to debug it , btw "400 GB HDD" for a Flyff server ? GGWP.

[princed2nd]

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

Originally Posted by xMeher

Try to debug it , btw "400 GB HDD" for a Flyff server ? GGWP.

It's a package of a 3GB RAM VPS xD ...

[xTwiLightx]

Originally Posted by princed2nd

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



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

[Burdenz2007]

Originally Posted by xTwiLightx

~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:

    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:

__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.

[princed2nd]

Already solved Thanks to all of your help we just changed the server files.

SOLVED (Y) -CLOSED-