1、问题
我的Tomcat版本是8.5,数据源用的是Druid,当把Tomcat停止时候,报错如图:
提取其中报错信息:
15-Apr-2020 23:08:12.700 警告 [localhost-startStop-2] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesJdbc The web application [squirrel] registered the JDBC driver [com.alibaba.druid.proxy.DruidDriver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
15-Apr-2020 23:08:12.700 警告 [localhost-startStop-2] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesJdbc The web application [squirrel] registered the JDBC driver [com.mysql.jdbc.Driver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
15-Apr-2020 23:08:12.700 警告 [localhost-startStop-2] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [squirrel] appears to have started a thread named [Abandoned connection cleanup thread] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:
java.lang.Object.wait(Native Method)
java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:144)
com.mysql.jdbc.AbandonedConnectionCleanupThread.run(AbandonedConnectionCleanupThread.java:64)
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
java.lang.Thread.run(Thread.java:748)
大概意思:
web应用程序注册了JDBC驱动程序[com.alibaba.druid.proxy.DruidDriver]。
但是当web应用程序被停止时,无法取消注册。
为了防止内存泄漏,JDBC驱动程序被强制取消注册。
web应用程序似乎启动了一个名为[connection cleanup thread]的线程,但未能停止它。
2、解决方案
手动配置监听器,用来在Tomcat关闭时取消注册JDBC驱动程序,并将线程停止。需要做两件事:
1、编写自定义监听侦
package com.ldu.util;
/**
* @Description 监听侦:用于解决tomcat停止出现内存泄漏。
* @Author ICHENY
*/
import com.mysql.jdbc.AbandonedConnectionCleanupThread;
import javax.servlet.ServletContextEvent;
import javax.servlet.ServletContextListener;
import java.sql.DriverManager;
import java.sql.SQLException;
public class MyContextListener implements ServletContextListener {
@Override
public void contextInitialized(ServletContextEvent arg0) {
System.out.println("webService start");
}
@Override
public void contextDestroyed(ServletContextEvent arg0) {
System.out.println("webService stop");
try {
while(DriverManager.getDrivers().hasMoreElements()) {
DriverManager.deregisterDriver(DriverManager.getDrivers().nextElement());
}
System.out.println("jdbc Driver close");
AbandonedConnectionCleanupThread.shutdown();
System.out.println("clean thread success");
} catch (SQLException e) {
e.printStackTrace();
}
}
}
2、在web.xml中注册监听侦
<!--监听侦-->
<listener>
<listener-class>com.ldu.util.MyContextListener</listener-class>
</listener>
3、运行结果
参考博客:
https://blog.51cto.com/11364212/2134469?cid=712360