Home > database >  After start tomcat, as long as there is data manipulation mysql service will automatically shut down
After start tomcat, as long as there is data manipulation mysql service will automatically shut down

Time:10-02

Today the project is deployed to the server, an error,
Later inspection found that the mysql service stopped, but before the service has started, after a few tests found that didn't start tomcat, using Navicat for database operations will not have a problem, as long as the startup project, a data operation will automatically stop the mysql service, what is this?
The error information is as follows:
The 2017-11-01 08:49:35, 007 ERROR [com. Alibaba. Druid. Pool. DruidDataSource] - the create
Connection error, url: JDBC: mysql://192.168.251.229:3306/creditteaching? UseUnico
DE=true& CharacterEncoding=utf-8, errorCode 0, state 08 s01
Com.mysql.jdbc.exceptions.jdbc4.Com municationsException: Communications link fai
Lure

The last packet sent successfully to The server was 0 milliseconds line. The driv
Er has not received any packets from the server.
At sun. Reflect. NativeConstructorAccessorImpl. NewInstance0 (Native Method)

At sun. Reflect. NativeConstructorAccessorImpl. NewInstance (NativeConstruct
OrAccessorImpl. Java: 57)
At sun. Reflect. DelegatingConstructorAccessorImpl. NewInstance (DelegatingC
OnstructorAccessorImpl. Java: 45)
The at Java. Lang. Reflect. Constructor. NewInstance (526) Constructor. Java:
At com. Mysql. JDBC. Util. HandleNewInstance (Util. Java: 409)
At com. Mysql. JDBC. SQLError. CreateCommunicationsException (SQLError. Java: 1
127)
At com. Mysql. JDBC. MysqlIO. & lt; init> (MysqlIO. Java: 356)
At com. Mysql. JDBC. ConnectionImpl. CoreConnect (ConnectionImpl. Java: 2502)
At com. Mysql. JDBC. ConnectionImpl. ConnectOneTryOnly (ConnectionImpl. Java: 2
539)
At com. Mysql. JDBC. ConnectionImpl. CreateNewIO (ConnectionImpl. Java: 2321)
At com. Mysql. JDBC. ConnectionImpl. & lt; init> (ConnectionImpl. Java: 832)
At com. Mysql. JDBC. JDBC4Connection. & lt; init> (JDBC4Connection. Java: 46)
At sun. Reflect. NativeConstructorAccessorImpl. NewInstance0 (Native Method)

At sun. Reflect. NativeConstructorAccessorImpl. NewInstance (NativeConstruct
OrAccessorImpl. Java: 57)
At sun. Reflect. DelegatingConstructorAccessorImpl. NewInstance (DelegatingC
OnstructorAccessorImpl. Java: 45)
The at Java. Lang. Reflect. Constructor. NewInstance (526) Constructor. Java:
At com. Mysql. JDBC. Util. HandleNewInstance (Util. Java: 409)
At com. Mysql. JDBC. ConnectionImpl. GetInstance (ConnectionImpl. Java: 417)
At com. Mysql. JDBC. NonRegisteringDriver. Connect (NonRegisteringDriver. Java
: 344)
At com. Alibaba. Druid. Filter. FilterChainImpl. Connection_connect (FilterCha
InImpl. Java: 148)
At com. Alibaba. Druid. Filter. Stat. StatFilter. Connection_connect (StatFilte
R.j ava: 211)
At com. Alibaba. Druid. Filter. FilterChainImpl. Connection_connect (FilterCha
InImpl. Java: 142)
At com. Alibaba. Druid. Pool. DruidAbstractDataSource. CreatePhysicalConnecti
On (DruidAbstractDataSource. Java: 1410)
At com. Alibaba. Druid. Pool. DruidAbstractDataSource. CreatePhysicalConnecti
On (DruidAbstractDataSource. Java: 1464)
At com. Alibaba. Druid. Pool. DruidDataSource $CreateConnectionThread. Run (Dru
IdDataSource. Java: 1969)
Under Caused by: java.net.ConnectException: Connection refused: connect
The at java.net.DualStackPlainSocketImpl.connect0 (Native Method)
The at java.net.DualStackPlainSocketImpl.socketConnect (DualStackPlainSocketI
MPL. Java: 79)
The at java.net.AbstractPlainSocketImpl.doConnect (AbstractPlainSocketImpl. Ja
Va: 339)
The at java.net.AbstractPlainSocketImpl.connectToAddress (AbstractPlainSocket
Impl. Java: 200)
The at java.net.AbstractPlainSocketImpl.connect (AbstractPlainSocketImpl. Java
: 182)
At java.net.PlainSocketImpl.connect PlainSocketImpl. Java: (172)
At java.net.SocksSocketImpl.connect SocksSocketImpl. Java: (392)
At java.net.Socket.connect (579) Socket. Java:
At java.net.Socket.connect (528) Socket. Java:
The at java.net.Socket. (Socket. Java: 425)
The at java.net.Socket. (Socket. Java: 241)
At com. Mysql. JDBC. StandardSocketFactory. Connect (StandardSocketFactory. Ja
Va: 258)
At com. Mysql. JDBC. MysqlIO. & lt; init> (MysqlIO. Java: 306)
. 18 more

The data source using the druid, configuration information is as follows:





  • Related