当前位置: 代码迷 >> Java Web开发 >> 帮忙解决下纠结已久的数据库+tomcat错误
  详细解决方案

帮忙解决下纠结已久的数据库+tomcat错误

热度:222   发布时间:2016-04-17 10:40:16.0
大虾帮忙解决下纠结已久的数据库+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)
  相关解决方案