Possible Problem with L2J - Need Help

[leonscottkennedy]

Hi guys.After about 2 months of search I didn't find the problem I have with my ping.Server keep crushing.Until I saw this while server was on.The only custom script I use is a scheme buffer.Can anybody help me?Do anybody know what this means :

 

 

 

 

Thanks a lot :D

[minideed]

The problem is the scheme buffer as it accesses the database and not closing the connection each time the buffer is used. Basically each time a player uses the scheme buffer a new connection is opened and never closed, so if the buffer is used 300 times a day that's how many connection are left open.

 

After a short time the server gets overloaded with open connections and crashes.

 

You have to fix the script to close the connection after each use; you can increase the mysql connections but it will only delay the crash a little longer.

[DarkRise41]

it is easy :)

[leonscottkennedy]

  On 11/16/2011 at 3:18 AM, minideed said:

The problem is the scheme buffer as it accesses the database and not closing the connection each time the buffer is used. Basically each time a player uses the scheme buffer a new connection is opened and never closed, so if the buffer is used 300 times a day that's how many connection are left open.

 

After a short time the server gets overloaded with open connections and crashes.

 

You have to fix the script to close the connection after each use; you can increase the mysql connections but it will only delay the crash a little longer.

 

Thanks a lot man!But how can I fix the script?I don't have any idea on java :( and scheme buffer is really helpful..Can someone see where is the problem if I upload the script?Please ? ►_◄

 

Scheme Buffer : http://www.mediafire.com/?iqigg3nn14na5n4

[dpbBryan]

[variable_name_of_sql_connection].close();

[leonscottkennedy]

  On 11/16/2011 at 6:01 PM, dpbBryan said:

[variable_name_of_sql_connection].close();

 

What does this mean? Do I need to add it somewhere in my script?

[dpbBryan]

  On 11/16/2011 at 6:07 PM, leonscottkennedy said:

What does this mean? Do I need to add it somewhere in my script?

 

Yes. I'm not going to search through the code there because I hate python. But how it works is your connection is created like:

Connection connection = L2DatabaseFactory.getInstance().getConnection();

 

The name won't be exactly the same, but after you're done with your query and you have your results, you need to:

connection.close();

 

How good is your understanding of java/python?

[leonscottkennedy]

  On 11/16/2011 at 6:12 PM, dpbBryan said:

Yes. I'm not going to search through the code there because I hate python. But how it works is your connection is created like:

Connection connection = L2DatabaseFactory.getInstance().getConnection();

 

The name won't be exactly the same, but after you're done with your query and you have your results, you need to:

connection.close();

 

How good is your understanding of java/python?

 

I have never worked with python or java :( but I understand a little...Do I need to replace something or to add something?

[mogo]

Connections do get closed. There is a timeout, but it is better to close them manually.

[dpbBryan]

  On 11/17/2011 at 12:42 AM, leonscottkennedy said:

I have never worked with python or java :( but I understand a little...Do I need to replace something or to add something?

 

I dunno, I'm not looking through that code.

 

  Quote

Connections do get closed. There is a timeout, but it is better to close them manually.

 

Eventually, however in the time that there isn't a timeout theres connections being made every time the people go the buffer.

[leonscottkennedy]

So should I remove this buffer from my server or is there any fix?I downloaded other similar buffers but again the same.Do you know where can I "buy" one?That's the magical word :D