Page 2 of 2
Re: epilogue server crash at every 9 hours!
Posted: Mon Apr 26, 2010 8:45 am
by 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.
Re: epilogue server crash at every 9 hours!
Posted: Mon Apr 26, 2010 8:50 am
by janiii
so check also your php scripts, if they ALWAYS close the database connection properly.
Re: epilogue server crash at every 9 hours!
Posted: Mon Apr 26, 2010 10:07 am
by thorl2
i use them all from 3 years and never had any problem... the problem is strict l2j to mysql
Re: epilogue server crash at every 9 hours!
Posted: Mon Apr 26, 2010 10:10 am
by JIV
post your jython custom script if you need help.
Re: epilogue server crash at every 9 hours!
Posted: Mon Apr 26, 2010 11:40 am
by 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;
Re: epilogue server crash at every 9 hours!
Posted: Mon Apr 26, 2010 11:55 am
by janiii
please use code tags for the pasting code fragments!
Re: epilogue server crash at every 9 hours!
Posted: Mon Apr 26, 2010 12:08 pm
by JIV
jython script with db access, not java one.
Re: epilogue server crash at every 9 hours!
Posted: Mon Apr 26, 2010 3:28 pm
by thorl2
the one from the site?
Re: epilogue server crash at every 9 hours!
Posted: Mon Apr 26, 2010 4:08 pm
by jurchiks
jeez...
site doesn't use jython, l2jserver does
post the custom script for l2jserver (THE JYTHON ONE)
Re: epilogue server crash at every 9 hours!
Posted: Wed Apr 28, 2010 8:49 pm
by thorl2
with this code all working well...
thx guys!
Code: Select all
-Dc3p0.unreturnedConnectionTimeout=1500 -Dc3p0.maxStatements=150 -Dc3p0.maxIdleTime=300
Re: epilogue server crash at every 9 hours!
Posted: Wed Apr 28, 2010 10:05 pm
by BiggBoss
that fix its a botched job
Re: epilogue server crash at every 9 hours!
Posted: Sat May 01, 2010 5:18 pm
by Szponiasty
BiggBoss wrote: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.