epilogue server crash at every 9 hours!

[thorl2]

yes i have kind o many but i never had this problem:

acc manager
tok pk
top pvp kills
top 30
top classes
clan status
seven signs
sieges dates
online maps
online players


that are on site.

[janiii]

so check also your php scripts, if they ALWAYS close the database connection properly.

[thorl2]

i use them all from 3 years and never had any problem... the problem is strict l2j to mysql

[JIV]

post your jython custom script if you need help.

[thorl2]

only in this script i found java.sql.Connection ( fake-pcs )

Code: Select all

Index: java/com/l2jserver/gameserver/datatables/FakePcsTable.java===================================================================--- java/com/l2jserver/gameserver/datatables/FakePcsTable.java	(revision 0)+++ java/com/l2jserver/gameserver/datatables/FakePcsTable.java	(revision 0)@@ -0,0 +1,153 @@+package com.l2jserver.gameserver.datatables;++import java.sql.Connection;+import java.sql.PreparedStatement;+import java.sql.ResultSet;+import java.sql.SQLException;+import java.util.logging.Logger;

[janiii]

please use code tags for the pasting code fragments!

[JIV]

jython script with db access, not java one.

[thorl2]

the one from the site?

[jurchiks]

jeez...
site doesn't use jython, l2jserver does
post the custom script for l2jserver (THE JYTHON ONE)

[thorl2]

with this code all working well...

thx guys!

Code: Select all

-Dc3p0.unreturnedConnectionTimeout=1500 -Dc3p0.maxStatements=150 -Dc3p0.maxIdleTime=300

[BiggBoss]

that fix its a botched job

[Szponiasty]

that fix its a botched job

It's not a fix at all. But now since he's server is not crashing thx for this addon, he knows why he had problems and how to solve this.