Machine DCs [Support/Discussion]

[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

[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?

[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????

[_DS_]

Copy entire "working" server on this machine for tests.

[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

[rocoder]

I think you have diff mysql config... try with this

Code: Select all

max_connections=400table_cache=4000

[Pere]

It didn't happen again moving the "cursed" server on a better machine (12GB DDR3 o.O)
Thank you so much anyways!!!

[DrHouse]

Anyone with the same might find this interesting:

http://forums.mysql.com/read.php?39,199 ... msg-204628
http://community.jboss.org/wiki/ConfigDataSources