### Cause: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1146583 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable.
; SQL []; Packet for query is too large (1146583 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable.; nested exception is com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1146583 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable., mergedContextConfiguration = [MergedContextConfiguration@64aa401e testClass = IDicPcctvServiceTest, locations = '{classpath*:config/applicationContext.xml}', classes = '{}', activeProfiles = '{}', contextLoader = 'org.springframework.test.context.support.DelegatingSmartContextLoader']]]
INFO - Closing org.springframework.context.support.GenericApplicationContext@67291453: startup date [Sun Apr 07 22:25:56 CST 2013]; root of context hierarchy
INFO - Destroying singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@7a7962ea: defining beans [org.springframework.context.annotation.internalConfigurationAnnotationProcessor,org.springframework.context.annotation.internalAutowiredAnnotationProcessor,org.springframework.context.annotation.internalRequiredAnnotationProcessor,org.springframework.context.annotation.internalCommonAnnotationProcessor,org.springframework.context.config.internalBeanConfigurerAspect,baseServiceImpl,customerAttachmentServiceImpl,customerBankAccountsServiceImpl,customerIncomePayoutDetailServiceImpl,customerInfoServiceImpl,customerLoginLogServiceImpl,customerProductPriceServiceImpl,customerReceiveAddressServiceImpl,dicDataServiceImpl,dicPcctvServiceImpl,dicTypeServiceImpl,orderCancelServiceImpl,orderDeliveryDetailServiceImpl,orderDeliveryServiceImpl,orderDetailServiceImpl,orderInfoServiceImpl,orderPaymentDetailServiceImpl,orderProcessServiceImpl,orderShoppingCartDetailServiceImpl,orderShoppingCartServiceImpl,productBrandServiceImpl,productFirstPageShowServiceImpl,productImageServiceImpl,productInfoServiceImpl,productIngredientServiceImpl,productPromotionDetailServiceImpl,productPromotionServiceImpl,productSaleRankingServiceImpl,productTypeServiceImpl,sellerCustomerServiceImpl,sysDepartmentServiceImpl,sysModuleServiceImpl,sysOrgServiceImpl,sysPermissionServiceImpl,sysRoleServiceImpl,sysUserServiceImpl,propertyConfigurer,transactionManager,dataSource,org.springframework.aop.config.internalAutoProxyCreator,org.springframework.transaction.annotation.AnnotationTransactionAttributeSource#0,org.springframework.transaction.interceptor.TransactionInterceptor#0,org.springframework.transaction.config.internalTransactionAdvisor,sqlSessionFactory,org.mybatis.spring.mapper.MapperScannerConfigurer#0,org.springframework.context.annotation.ConfigurationClassPostProcessor$ImportAwareBeanPostProcessor#0,customerAttachmentMapper,customerBankAccountsMapper,customerIncomePayoutDetailMapper,customerInfoMapper,customerLoginLogMapper,customerProductPriceMapper,customerReceiveAddressMapper,dicDataMapper,dicPcctvMapper,dicTypeMapper,orderCancelMapper,orderDeliveryDetailMapper,orderDeliveryMapper,orderDetailMapper,orderInfoMapper,orderPaymentDetailMapper,orderProcessMapper,orderShoppingCartDetailMapper,orderShoppingCartMapper,productBrandMapper,productFirstPageShowMapper,productImageMapper,productInfoMapper,productIngredientMapper,productPromotionDetailMapper,productPromotionMapper,productSaleRankingMapper,productTypeMapper,sellerCustomerMapper,sysDepartmentMapper,sysDepartmentUserMapper,sysModuleMapper,sysOrgMapper,sysOrgModuleMapper,sysOrgUserMapper,sysOrgUserPermissionMapper,sysPermissionMapper,sysRoleMapper,sysRolePermissionMapper,sysUserMapper,sysUserRoleMapper]; root of factory hierarchy
MySQL\MySQL Server 5.5\my-large.ini 修改
max_allowed_packet = 8M
相关推荐
在描述中提到的错误信息 "Packet for query is too large (11087 > 102)" 指明了问题的具体情况,即数据包的大小(11087字节)超出了MySQL默认允许的最大值102字节。 这个问题通常发生在以下几种情况: 1. **大数据...
在上述示例中,当遇到“Packet for query is too large (1040 > 1024)”错误时,用户首先通过`SHOW VARIABLES LIKE '%max_allowed_packet%'`查询了当前的设置,发现是1024KB。然后,他们尝试通过命令行临时增加这个...
今天在往mysql中插入数据时遇到的问题,翻译过来的意思是:查询数据包太大 建议修改max_allowed_packet参数值。 针对我执行的插入操作来说,意味着一次性执行的sql语句太大,超过了mysql默认设置的值(我用的是...
想改变这个问题,需要注意几点: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (2054817 > 1048576). You can change this value on the server by setting the max_allowed_packet’ ...
com.mysql.jdbc.PacketTooBigException: Packet for query is too large (4232009 > 4194304). You can change this value on the server by setting the max_allowed_packet’ variable. 出现上面的错误是因为...
<br>18.2.3 Host '...' is blocked错误 <br>18.2.4 Out of memory错误 <br>18.2.5 Packet too large错误 <br>18.2.6 The table is full错误 <br>18.2.7 Commands out of sync in client错误 <br>18.2.8 Ignoring ...
<br/>8.4.4.3 选择特定列 <br/>8.4.4.4 排序行 <br/>8.4.4.5 日期计算 <br/>8.4.4.6 NULL值操作 <br/>8.4.4.7 模式匹配 <br/>8.4.4.8 行计数 <br/>8.4.5 使用多个数据库表 <br/>8.5 获得数据库和表的信息 <br/>8.6 ...
MySQL批量插入问题 ...nested exception is com.mysql.jdbc.PacketTooBigException: Packet for query is too large (5677854 > 1048576). You can change this value on the server by setting the max_allowed_pac
当日志中出现了诸如:“Package for query is too large (xxxxxxxx > 4194304). You can change this value on the server by setting the max_allowed_package variable”的提示的时候,错误的本身就清楚的提示了...
如果设置得过小,则可能会遇到“packet for query is too large”的错误。默认情况下,`max_allowed_packet` 的值通常为1MB或更小,这对于大多数应用来说已经足够,但在处理大量数据时可能需要对其进行调整。 #### ...
nested exception is com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1280 > 1024). You can change this value on the server by setting the max_allowed_packet' variable ``` - **...
is attempting to send too much over one link. We note, however, that since the IMP at the destination does not have enough capacity to handle all 32 links simultaneously, the links serve their ...
[2884071] [AIX host] prefetch: EIP [00010000] > CS.limit [0000ffff] [3053542] 64 bit mode: far-jmp instruction is error [3011112] error compile vs2008/2010 with X2APIC [3002017] compile error with...
* 0 译者序 * 1 MySQL的一般的信息 o 1.1 什么是MySQL? o 1.2 关于本手册 + 1.2.1 本手册中使用的约定 o 1.3 MySQL的历史 o 1.4 MySQL的主要特征 o 1.5 MySQL稳定性? o 1.6 顺应2000年 ...