org.hibernate.exception.GenericJDBCException: could not insert:

org.hibernate.exception.GenericJDBCException: could not insert: [com.wellsynergy.kmatrix.db.TbDocument]
at org.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:92)
at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:80)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1777)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2178)
at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:34)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:240)
at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:160)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:95)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:184)
at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:173)
at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:69)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:481)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:476)
at com.wellsynergy.kmatrix.grasper.http.kmatrix.KMatrixBaseAction.saveDocument(KMatrixBaseAction.java:277)
at com.wellsynergy.kmatrix.grasper.http.kmatrix.KMatrixBaseAction.saveList(KMatrixBaseAction.java:121)
at com.wellsynergy.kmatrix.grasper.http.kmatrix.KMatrixBaseAction.doAction(KMatrixBaseAction.java:54)
at com.wellsynergy.kmatrix.grasper.http.command.HttpGrasperDoAction.processCommand(HttpGrasperDoAction.java:20)
at com.wellsynergy.kmatrix.grasper.http.AbstractHttpGrasperCommand.process(AbstractHttpGrasperCommand.java:213)
at com.wellsynergy.kmatrix.grasper.http.AbstractHttpGrasperCommand.runGrap(AbstractHttpGrasperCommand.java:111)
at com.wellsynergy.kmatrix.grasper.http.AbstractHttpGrasperCommand.executeChild(AbstractHttpGrasperCommand.java:171)
at com.wellsynergy.kmatrix.grasper.http.command.HttpGrasperGenNextPage.processCommand(HttpGrasperGenNextPage.java:38)
at com.wellsynergy.kmatrix.grasper.http.AbstractHttpGrasperCommand.process(AbstractHttpGrasperCommand.java:213)
at com.wellsynergy.kmatrix.grasper.http.AbstractHttpGrasperCommand.runGrap(AbstractHttpGrasperCommand.java:117)
at com.wellsynergy.kmatrix.grasper.http.AbstractHttpGrasperCommand.executeChild(AbstractHttpGrasperCommand.java:171)
at com.wellsynergy.kmatrix.grasper.http.command.HttpGrasperGenNextPage.processCommand(HttpGrasperGenNextPage.java:38)
at com.wellsynergy.kmatrix.grasper.http.AbstractHttpGrasperCommand.process(AbstractHttpGrasperCommand.java:213)
at com.wellsynergy.kmatrix.grasper.http.AbstractHttpGrasperCommand.runGrap(AbstractHttpGrasperCommand.java:117)
at com.wellsynergy.kmatrix.grasper.http.AbstractHttpGrasperCommand.executeChild(AbstractHttpGrasperCommand.java:171)
at com.wellsynergy.kmatrix.grasper.http.command.HttpGrasperStartHTTPGrasper.processCommand(HttpGrasperStartHTTPGrasper.java:63)
at com.wellsynergy.kmatrix.grasper.http.AbstractHttpGrasperCommand.process(AbstractHttpGrasperCommand.java:213)
at com.wellsynergy.kmatrix.grasper.http.HttpGrasperJob.runGrasper(HttpGrasperJob.java:128)
at com.wellsynergy.kmatrix.grasper.http.HttpGrasper.grasp(HttpGrasper.java:48)
at com.wellsynergy.kmatrix.grasper.http.test.GrasperThread.run(GraspWebForums.java:225)
Caused by: java.sql.SQLException: The table 'tb_document' is full
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2921)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1570)
at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1085)
at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:670)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1159)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1076)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1061)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:104)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1759)

... 33 more


(以下来自 http://zuzong.iteye.com/blog/1071738

tmp_table_size 

如果内存内的临时表超过该值,MySQL自动将它转换为硬盘上的MyISAM表。如果你执行许多高级GROUP BY查询并且有大量内存,则可以增加tmp_table_size的值。 


max_heap_table_size 

该变量设置MEMORY (HEAP)表可以增长到的最大空间大小。该变量用来计算MEMORY表的MAX_ROWS值。在已有的MEMORY表上设置该变量没有效果,除非用CREATE TABLE或TRUNCATE TABLE等语句重新创建表。 


如何设置: 
方法一,修改my.ini或my.cnf 
tmp_table_size=64M 
max_heap_table_size=32M 
此方法最大的缺点,是一旦mysql重启,一切恢复默认值 

方法二,mysqld命令行 
mysqld_safe --key_buffer_size=512K --sort_buffer_size=16K \ 
           --tmp_table_size=64M --max_heap_table_size=32M &
 

方法三,动态修改 
因为tmp_table_size和max_heap_table_size,都有session作用域,所以,一般情况下,尽量这样做吧 
SET SESSION tmp_table_size=64*1024*1024 
SET SESSION max_heap_table_size=32*1024*1024
 

修改好后如何查看: 
查看服务器配置信息 
SHOW VARIABLES WHERE Variable_name LIKE '%tmp_table_size%' 

查看服务器运行信息 
SHOW STATUS 

如何使用JDBC获得他们的值: 
SELECT @@tmp_table_size 
SELECT @@max_heap_table_size


发现以上方面没有用.

试试下面的方法:

1,在 my.ini 里更改 tmp_table_size=256M;( 如果不行可以改为 512M 试试)

2,把 data 文件夹下的 ibdata1 文件移到其他磁盘中;

3,在 my.ini 里添加 innodb_data_home_dir="d:/" 。

针对的是 mysql-workbench-oss-5.0.22-win32.msi 

我pc  c盘的分区是 FAT32(属性--文件系统),最多可以容纳 ibdata1 文件 4G ,而我pc里现在 ibdata1 是 4.07G ,所以需要把 ibdata1 移到其他磁盘里。 



 


  • 1
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值