Bonsoir,
Je me permet de demander votre aide concernant un plantage qui à eu lieu sans raison à 14h44 (aucune modification à eu lieu, le restart de 8h00 s'est passé tranquillement).
J'ai auparavant effectuer pas mal de recherches, avec l'aide de plusieurs personnes, mais sans réel succès...
Le serveur dédié est sous Debian 5.0 - Hebergeur Dedibox. (la configuration logicielle est similaire à celle du tutoriel d'installation de votre forum, mais ce n'est pas moi qui l'ai installé)
Edit : voici un screen de la console Putty avec un
ps aux :
Apparement, le java du GameServer ne se lance pas (pardonnez moi si cette phrase est mal formulée).
Je l'ai relancé, que cela soit en restart software, restart hardware ou kill proc (avec Putty et WinSCP). Mais lorsque je lance le LoginServer, le processus java loginserver est visible, mais quand il s'agit du GameServer, rien n'apparait.
Voici également les erreurs qui ressorte sous la console Game Serveur de la DB Michelle :
- Citation :
INFO loading ./config/datetime.properties
==================================================================-[ Database ]
INFO : MLog clients using log4j logging.
INFO : Initializing c3p0-0.9.1.2 [built 21-May-2007 15:04:56; debug? true; trace: 10]
WARN : Could not load driverClass com.mysql.jdbc.Driver java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
at java.lang.ClassLoader.loadClass(ClassLoader.java:252)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at com.mchange.v2.c3p0.DriverManagerDataSource.ensureDriverLoaded(DriverManagerDataSource.java:100)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:117)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:143)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:132)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.initializeAutomaticTestTable(C3P0PooledConnectionPoolManager.java:772)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.createPooledConnectionPool(C3P0PooledConnectionPoolManager.java:696)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0PooledConnectionPoolManager.java:257)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0PooledConnectionPoolManager.java:271)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getNumThreadsAwaitingCheckoutDefaultUser(AbstractPoolBackedDataSource.java:203)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.mchange.v2.beans.BeansUtils.extractAccessiblePropertiesToMap(BeansUtils.java:359)
at com.mchange.v2.beans.BeansUtils.appendPropNamesAndValues(BeansUtils.java:324)
at com.mchange.v2.c3p0.ComboPooledDataSource.toString(ComboPooledDataSource.java:539)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getPoolManager(AbstractPoolBackedDataSource.java:462)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
at com.l2jfree.L2DatabaseFactory.(L2DatabaseFactory.java:116)
at com.l2jfree.L2DatabaseFactory.getInstance(L2DatabaseFactory.java:40)
at com.l2jfree.gameserver.GameServer.(GameServer.java:173)
at com.l2jfree.gameserver.GameServer.main(GameServer.java:462)
INFO : Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ java.beans.IntrospectionException: java.lang.reflect.InvocationTargetException [numThreadsAwaitingCheckoutDefaultUser] ]
WARN : Could not load driverClass com.mysql.jdbc.Driver java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
at java.lang.ClassLoader.loadClass(ClassLoader.java:252)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at com.mchange.v2.c3p0.DriverManagerDataSource.ensureDriverLoaded(DriverManagerDataSource.java:100)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:117)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:143)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:132)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.initializeAutomaticTestTable(C3P0PooledConnectionPoolManager.java:772)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.createPooledConnectionPool(C3P0PooledConnectionPoolManager.java:696)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0PooledConnectionPoolManager.java:257)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0PooledConnectionPoolManager.java:271)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
at com.l2jfree.L2DatabaseFactory.(L2DatabaseFactory.java:116)
at com.l2jfree.L2DatabaseFactory.getInstance(L2DatabaseFactory.java:40)
at com.l2jfree.gameserver.GameServer.(GameServer.java:173)
at com.l2jfree.gameserver.GameServer.main(GameServer.java:462)
Exception in thread "main" java.sql.SQLException: L2DatabaseFactory: Failed to init database connections: java.sql.SQLException: No suitable driver
at com.l2jfree.L2DatabaseFactory.(L2DatabaseFactory.java:125)
at com.l2jfree.L2DatabaseFactory.getInstance(L2DatabaseFactory.java:40)
at com.l2jfree.gameserver.GameServer.(GameServer.java:173)
at com.l2jfree.gameserver.GameServer.main(GameServer.java:462)
Caused by: java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getDriver(DriverManager.java:264)
at com.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataSource.java:223)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:119)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:143)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:132)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.initializeAutomaticTestTable(C3P0PooledConnectionPoolManager.java:772)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.createPooledConnectionPool(C3P0PooledConnectionPoolManager.java:696)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0PooledConnectionPoolManager.java:257)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0PooledConnectionPoolManager.java:271)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
at com.l2jfree.L2DatabaseFactory.(L2DatabaseFactory.java:116)
... 3 more
J'ai fait des recherches sur le sujet (Java Driver), sur lequel j'ai réussi a trouver des bribes de pistes... mais qui ne m'avancent pas, ne réussissant pas à reconstituer le "puzzle"
Voici les liens que j'ai consulté (si cela peut aider)
http://www.javafr.com/forum/sujet-COULD-NOT-LOAD-JDBC-DRIVER-CLASS-COM-MYSQL_1240388.aspxOn fait allusion aux pilote de JDBC (?)
http://www.developpez.net/forums/d247069/java/general-java/jdbc/installer-pilote-jdbc-mysql-easyphp/Et donc référence au CLASSPATH.
http://java.developpez.com/faq/java/?page=langage#LANGUAGE_CLASSPATHLe soucis dans tout ça, c'est que cela arrive pile quand les 2 admins qui ont les connaissances pour ce genre de problèmes sont en vacances (ils sont partis avant-hier >_<), donc c'est pour cela que je me permet de poster cette demande.
Merci d'avance pour ceux qui ont pris le temps de me lire, et ceux qui me répondrons
Je suis à votre disposition quand à d'éventuelles questions, besoins d'informations complémentaires.
Cordialement.[/i]
[Edit]
Voici ce qui ressort du log avant le crash :
- Citation :
INFO - AllowedMemory: 932096 KB
INFO Allocated: 628480 KB (67.4265%)
INFO Non-Allocated: 303616 KB (32.5735%)
INFO - AllocatedMemory: 628480 KB
INFO Used: 399685 KB (42.8802%)
INFO Unused (cached): 228795 KB (24.5463%)
INFO - UseableMemory: 532411 KB (57.1198%)
INFO Maximum Numbers of Connected Players: 1000
INFO Server Loaded in 53 seconds
=============================================================-[ GameServerLog ]
INFO Registered on login as Server 1 : Bartz
INFO executing cron: data/scripts/cron/tvt.py
INFO TvT : Réinitialisation des joueurs.
INFO TvT : Réinitialisation des équipes.
INFO Réinitialisation TvT.
INFO Geodata Engine: Disabled.
INFO SevenSigns: Data updated successfully.
WARNING Exception in a Runnable execution:
java.util.NoSuchElementException
at javolution.util.FastList.removeFirst(Unknown Source)
at com.l2jfree.gameserver.threadmanager.FIFORunnableQueue.removeFirst(FIFORunnableQueue.java:67)
at com.l2jfree.gameserver.threadmanager.FIFORunnableQueue.run(FIFORunnableQueue.java:86)
at com.l2jfree.gameserver.threadmanager.ExecuteWrapper.execute(ExecuteWrapper.java:45)
at com.l2jfree.gameserver.threadmanager.ExecuteWrapper.run(ExecuteWrapper.java:36)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:98)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:207)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
...[erreur de comptes qui ont pas réussi a se connecter]
Exception in thread "LoginServerThread" java.lang.OutOfMemoryError: Java heap space
Exception in thread "ThreadPool-10" Exception in thread "com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0" java.lang.OutOfMemoryError: Java heap space
Exception in thread "ThreadPool-5" java.lang.OutOfMemoryError: Java heap space