Page 1 of 1
Machine DCs [Support/Discussion]
Posted: Wed Jan 27, 2010 9:23 pm
by Pere
These last months the machine where my 3rd server is hosted began to get disconnected from the network. Yeah, it had to be restarted from hard and then I found tons of SQL connection errors on the logs, which log hours were while the machine was "crashed". So what I guess from here is that the machine works, and only gets disconnected from the network.
Then I tried with another machine which I was using for my 1rst server (same population, more or less) and the same happened there, and it didn't happen before while hosting the 1st server!
The most amazing thing is that they use the same .jar file, only configs and some data are different.
What do you think that it could be? I'm really thinking about to close this "cursed" server, lol
Thank you
Re: Machine DCs [Support/Discussion]
Posted: Thu Jan 28, 2010 12:13 am
by Deadmeat
Have you check the memory and thread settings in the game server batch file, is it the same MySQL config settings, and what is the error in the log file?
Re: Machine DCs [Support/Discussion]
Posted: Thu Jan 28, 2010 12:25 am
by Pere
Everything exactly the same except rates and such those things, and the errors look like:
Code: Select all
INFO: An exception occurred while acquiring a poolable resource. Will retry.com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. at sun.reflect.GeneratedConstructorAccessor100.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2214) at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:781) at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46) at sun.reflect.GeneratedConstructorAccessor85.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:352) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:284) at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137) at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014) at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32) at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810) at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. at sun.reflect.GeneratedConstructorAccessor100.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074) at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:343) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2137) ... 16 moreCaused by: java.net.ConnectException: Connection timed out: connect at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(Unknown Source) at java.net.PlainSocketImpl.connectToAddress(Unknown Source) at java.net.PlainSocketImpl.connect(Unknown Source) at java.net.SocksSocketImpl.connect(Unknown Source) at java.net.Socket.connect(Unknown Source) at java.net.Socket.connect(Unknown Source) at java.net.Socket.<init>(Unknown Source) at java.net.Socket.<init>(Unknown Source) at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:253) at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:292) ... 17 more
Can a java program kill the whole server's ping????
Re: Machine DCs [Support/Discussion]
Posted: Fri Jan 29, 2010 3:01 am
by _DS_
Copy entire "working" server on this machine for tests.
Re: Machine DCs [Support/Discussion]
Posted: Tue Feb 02, 2010 1:58 am
by Pere
I was asking only info about if you knew about the possibility of java.exe to kill a network driver (which is fixed on machine restart) u.U
Re: Machine DCs [Support/Discussion]
Posted: Thu Feb 04, 2010 9:57 am
by rocoder
I think you have diff mysql config... try with this
Code: Select all
max_connections=400table_cache=4000
Re: Machine DCs [Support/Discussion]
Posted: Sat Feb 06, 2010 5:04 pm
by Pere
It didn't happen again moving the "cursed" server on a better machine (12GB DDR3 o.O)
Thank you so much anyways!!!
Re: Machine DCs [Support/Discussion]
Posted: Sun Feb 07, 2010 10:08 am
by DrHouse