Лог
Код:
2018-05-15 13:31:36,889 ERROR [DefaultQuartzScheduler_Worker-3] LoginServer.PayInfoDAO [0] MySql.Data.MySqlClient.MySqlException (0x80004005): Authentication to host '192.168.1.241' for user 'admin' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Reading from the stream has failed. ---> System.IO.IOException: Не удается прочитать данные из транспортного соединения: Программа на вашем хост-компьютере разорвала установленное подключение. ---> System.Net.Sockets.SocketException: Программа на вашем хост-компьютере разорвала установленное подключение
в System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
--- Конец трассировки внутреннего стека исключений ---
в MySql.Data.Common.MyNetworkStream.HandleOrRethrowException(Exception e)
в MySql.Data.Common.MyNetworkStream.Read(Byte[] buffer, Int32 offset, Int32 count)
в MySql.Data.MySqlClient.TimedStream.Read(Byte[] buffer, Int32 offset, Int32 count)
в System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)
в MySql.Data.MySqlClient.MySqlStream.ReadFully(Stream stream, Byte[] buffer, Int32 offset, Int32 count)
в MySql.Data.MySqlClient.MySqlStream.LoadPacket()
в MySql.Data.MySqlClient.MySqlStream.LoadPacket()
в MySql.Data.MySqlClient.MySqlStream.ReadPacket()
в MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.ReadPacket()
в MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.AuthenticationFailed(Exception ex)
в MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.ReadPacket()
в MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.Authenticate(Boolean reset)
в MySql.Data.MySqlClient.NativeDriver.Open()
в MySql.Data.MySqlClient.Driver.Open()
в MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
в MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
в MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
в MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
в MySql.Data.MySqlClient.MySqlPool.GetConnection()
в MySql.Data.MySqlClient.MySqlConnection.Open()
в LoginServer.PayInfoDAO.LoadPayInfo()
2018-05-15 14:02:22,464 ERROR [DefaultQuartzScheduler_Worker-1] LoginServer.PayInfoDAO [0] MySql.Data.MySqlClient.MySqlException (0x80004005): Authentication to host '192.168.1.241' for user 'admin' using method 'mysql_native_password' failed with message: Reading from the stream has failed. ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Reading from the stream has failed. ---> System.IO.IOException: Не удается прочитать данные из транспортного соединения: Программа на вашем хост-компьютере разорвала установленное подключение. ---> System.Net.Sockets.SocketException: Программа на вашем хост-компьютере разорвала установленное подключение
в System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
--- Конец трассировки внутреннего стека исключений ---
в MySql.Data.Common.MyNetworkStream.HandleOrRethrowException(Exception e)
в MySql.Data.Common.MyNetworkStream.Read(Byte[] buffer, Int32 offset, Int32 count)
в MySql.Data.MySqlClient.TimedStream.Read(Byte[] buffer, Int32 offset, Int32 count)
в System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)
в MySql.Data.MySqlClient.MySqlStream.ReadFully(Stream stream, Byte[] buffer, Int32 offset, Int32 count)
в MySql.Data.MySqlClient.MySqlStream.LoadPacket()
в MySql.Data.MySqlClient.MySqlStream.LoadPacket()
в MySql.Data.MySqlClient.MySqlStream.ReadPacket()
в MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.ReadPacket()
в MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.AuthenticationFailed(Exception ex)
в MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.ReadPacket()
в MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.Authenticate(Boolean reset)
в MySql.Data.MySqlClient.NativeDriver.Open()
в MySql.Data.MySqlClient.Driver.Open()
в MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
в MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
в MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
в MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
в MySql.Data.MySqlClient.MySqlPool.GetConnection()
в MySql.Data.MySqlClient.MySqlConnection.Open()
в LoginServer.PayInfoDAO.LoadPayInfo()
Добавлено через 10 минут
Game
Код:
2018-05-15 21:19:16,251 Database access problem. Killing off all remaining connections in the connection pool. SQL State = 08S01
2018-05-15 21:19:16,254 Error storing server time
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 180-003 milliseconds ago. The last packet sent successfully to the server was 180-003 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
at sun.reflect.GeneratedConstructorAccessor457.newInstance(Unknown Source) ~[na:na]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.7.0_25]
at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[na:1.7.0_25]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) ~[mysql-connector-java-5.1.18.jar:na]
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116) ~[mysql-connector-java-5.1.18.jar:na]
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3364) ~[mysql-connector-java-5.1.18.jar:na]
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1983) ~[mysql-connector-java-5.1.18.jar:na]
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163) ~[mysql-connector-java-5.1.18.jar:na]
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624) ~[mysql-connector-java-5.1.18.jar:na]
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2127) ~[mysql-connector-java-5.1.18.jar:na]
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2427) ~[mysql-connector-java-5.1.18.jar:na]
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2345) ~[mysql-connector-java-5.1.18.jar:na]
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2330) ~[mysql-connector-java-5.1.18.jar:na]
at com.jolbox.bonecp.PreparedStatementHandle.executeUpdate(PreparedStatementHandle.java:203) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE]
at mysql5.MySQL5ServerVariablesDAO.store(MySQL5ServerVariablesDAO.java]:70) ~[na:na]
at com.aionemu.gameserver.utils.gametime.GameTimeManager.saveTime(GameTimeManager.java:77) ~[AL-Game.jar:na]
at com.aionemu.gameserver.services.GameTimeService$1.run(GameTimeService.java:60) ~[AL-Game.jar:na]
at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrapper.java:46) ~[al-commons-1.3.jar:na]
at com.aionemu.commons.utils.concurrent.RunnableWrapper.run(RunnableWrapper.java:38) ~[al-commons-1.3.jar:na]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) ~[na:1.7.0_25]
at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:351) ~[na:1.7.0_25]
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:178) ~[na:1.7.0_25]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:178) ~[na:1.7.0_25]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) ~[na:1.7.0_25]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) ~[na:1.7.0_25]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) ~[na:1.7.0_25]
at java.lang.Thread.run(Thread.java:724) ~[na:1.7.0_25]
Caused by: java.net.SocketException: Software caused connection abort: socket write error
at java.net.SocketOutputStream.socketWrite0(Native Method) ~[na:1.7.0_25]
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:109) ~[na:1.7.0_25]
at java.net.SocketOutputStream.write(SocketOutputStream.java:153) ~[na:1.7.0_25]
at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82) ~[na:1.7.0_25]
at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140) ~[na:1.7.0_25]
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3345) ~[mysql-connector-java-5.1.18.jar:na]
... 21 common frames omitted