大虾帮忙解决下纠结已久的数据库+tomcat异常
一、windows事件查看器报告信息:
Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space
For more information, see Help and Support Center at http://www.mysql.com.
二、tomcat日志1:
java.sql.SQLException: Out of memory (Needed 906204 bytes)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1056)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2938)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1601)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1710)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2436)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1402)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1694)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1608)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1593)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
at cn.mchina.service.keyword.RelativityWordServiceImpl.calPv(RelativityWordServiceImpl.java:123)
at cn.mchina.action.search.SearchAction$1.run(SearchAction.java:399)
at java.lang.Thread.run(Thread.java:619)
tomcat日志2
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Server connection failure during transaction. Due to underlying exception: 'java.util.NoSuchElementException'.
** BEGIN NESTED EXCEPTION **
java.util.NoSuchElementException
STACKTRACE:
java.util.NoSuchElementException
at java.util.TreeMap.key(TreeMap.java:1206)
at java.util.TreeMap.lastKey(TreeMap.java:274)
at com.mysql.jdbc.Connection.buildCollationMapping(Connection.java:850)
at com.mysql.jdbc.Connection.initializePropsFromServer(Connection.java:3215)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2093)
at com.mysql.jdbc.Connection.<init>(Connection.java:716)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
at sun.reflect.GeneratedConstructorAccessor15.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:353)
at com.mysql.jdbc.Connection.getInstance(Connection.java:295)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:771)
at org.apache.commons.dbcp.AbandonedObjectPool.borrowObject(AbandonedObjectPool.java:74)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
at cn.common.db.MchinaDBManager.getConnection(MchinaDBManager.java:36)
at cn.common.DBManager.getDBConnection(DBManager.java:58)
at cn.mchina.service.keyword.RelativityWordServiceImpl.calPv(RelativityWordServiceImpl.java:114)
at cn.mchina.action.search.SearchAction$1.run(SearchAction.java:399)
at java.lang.Thread.run(Thread.java:619)
** END NESTED EXCEPTION **
Attempted reconnect 3 times. Giving up.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:353)
at com.mysql.jdbc.Util.getInstance(Util.java:336)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:985)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2150)
at com.mysql.jdbc.Connection.<init>(Connection.java:716)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
at sun.reflect.GeneratedConstructorAccessor15.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:353)
at com.mysql.jdbc.Connection.getInstance(Connection.java:295)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:771)
at org.apache.commons.dbcp.AbandonedObjectPool.borrowObject(AbandonedObjectPool.java:74)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
at cn.common.db.MchinaDBManager.getConnection(MchinaDBManager.java:36)
at cn.common.DBManager.getDBConnection(DBManager.java:58)
at cn.mchina.service.keyword.RelativityWordServiceImpl.calPv(RelativityWordServiceImpl.java:114)
at cn.mchina.action.search.SearchAction$1.run(SearchAction.java:399)
at java.lang.Thread.run(Thread.java:619)
java.lang.NullPointerException
at cn.mchina.service.keyword.RelativityWordServiceImpl.calPv(RelativityWordServiceImpl.java:115)
at cn.mchina.action.search.SearchAction$1.run(SearchAction.java:399)
at java.lang.Thread.run(Thread.java:619)
Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space
For more information, see Help and Support Center at http://www.mysql.com.
二、tomcat日志1:
java.sql.SQLException: Out of memory (Needed 906204 bytes)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1056)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2938)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1601)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1710)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2436)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1402)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1694)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1608)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1593)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
at cn.mchina.service.keyword.RelativityWordServiceImpl.calPv(RelativityWordServiceImpl.java:123)
at cn.mchina.action.search.SearchAction$1.run(SearchAction.java:399)
at java.lang.Thread.run(Thread.java:619)
tomcat日志2
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Server connection failure during transaction. Due to underlying exception: 'java.util.NoSuchElementException'.
** BEGIN NESTED EXCEPTION **
java.util.NoSuchElementException
STACKTRACE:
java.util.NoSuchElementException
at java.util.TreeMap.key(TreeMap.java:1206)
at java.util.TreeMap.lastKey(TreeMap.java:274)
at com.mysql.jdbc.Connection.buildCollationMapping(Connection.java:850)
at com.mysql.jdbc.Connection.initializePropsFromServer(Connection.java:3215)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2093)
at com.mysql.jdbc.Connection.<init>(Connection.java:716)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
at sun.reflect.GeneratedConstructorAccessor15.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:353)
at com.mysql.jdbc.Connection.getInstance(Connection.java:295)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:771)
at org.apache.commons.dbcp.AbandonedObjectPool.borrowObject(AbandonedObjectPool.java:74)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
at cn.common.db.MchinaDBManager.getConnection(MchinaDBManager.java:36)
at cn.common.DBManager.getDBConnection(DBManager.java:58)
at cn.mchina.service.keyword.RelativityWordServiceImpl.calPv(RelativityWordServiceImpl.java:114)
at cn.mchina.action.search.SearchAction$1.run(SearchAction.java:399)
at java.lang.Thread.run(Thread.java:619)
** END NESTED EXCEPTION **
Attempted reconnect 3 times. Giving up.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:353)
at com.mysql.jdbc.Util.getInstance(Util.java:336)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:985)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2150)
at com.mysql.jdbc.Connection.<init>(Connection.java:716)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
at sun.reflect.GeneratedConstructorAccessor15.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:353)
at com.mysql.jdbc.Connection.getInstance(Connection.java:295)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:771)
at org.apache.commons.dbcp.AbandonedObjectPool.borrowObject(AbandonedObjectPool.java:74)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
at cn.common.db.MchinaDBManager.getConnection(MchinaDBManager.java:36)
at cn.common.DBManager.getDBConnection(DBManager.java:58)
at cn.mchina.service.keyword.RelativityWordServiceImpl.calPv(RelativityWordServiceImpl.java:114)
at cn.mchina.action.search.SearchAction$1.run(SearchAction.java:399)
at java.lang.Thread.run(Thread.java:619)
java.lang.NullPointerException
at cn.mchina.service.keyword.RelativityWordServiceImpl.calPv(RelativityWordServiceImpl.java:115)
at cn.mchina.action.search.SearchAction$1.run(SearchAction.java:399)
at java.lang.Thread.run(Thread.java:619)
...全文
相关推荐
Tomcat正常启动,访问所有页面均报404异常,404异常总结分析
因此,清理并重启Tomcat服务器是解决问题的一个关键步骤。8. 小结:在解决Tomcat 404异常时,需要对可能的原因逐一排查。
db+Tomcat DataSource
【db+Tomcat DataSource】指的是在Java应用服务器Tomcat中配置数据库连接池DataSource,以便应用程序能够高效、安全地访问Oracle 11g数据库。
Tomcat常见异常及解决方案代码实例
这些是两个典型的Tomcat异常案例,但需要注意的是,每个异常可能有多种原因和解决方案。在实际问题排查中,应结合日志、代码以及具体环境来分析和解决。
SpringBoot项目打包发布到外部tomcat(出现各种异常的解决)
这篇文章将详细介绍如何将SpringBoot项目打包发布到外部tomcat,并解决各种可能出现的异常。
tomcat+database
标题“tomcat+database”和描述“tomcat database”表明我们关注的是Tomcat服务器与数据库的集成和交互。在这个主题下,我们将深入探讨以下几个关键知识点:1.


Web 开发
