做excel 数据批量导入功能2万条数据 报错
com.mysql.cj.jdbc.exceptions.PacketTooBigException: Packet for query is too large (30,647,972 > 20,971,520). You can change this value on the server by setting the 'max_allowed_packet' variable.
; Packet for query is too large (30,647,972 > 20,971,520). You can change this value on the server by setting the 'max_allowed_packet' variable.; nested exception is com.mysql.cj.jdbc.exceptions.PacketTooBigException: Packet for query is too large (30,647,972 > 20,971,520). You can change this value on the server by setting the 'max_allowed_packet' variable.] with root cause
解决方案
show VARIABLES like '%max_allowed_packet%';
set global max_allowed_packet = 3*1024*1024*10
设置后 需要断开连接后再查询即可
相关推荐
在描述中提到的错误信息 "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. 出现上面的错误是因为...
当日志中出现了诸如：“Package for query is too large （xxxxxxxx > 4194304). You can change this value on the server by setting the max_allowed_package variable”的提示的时候，错误的本身就清楚的提示了...
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
- added warranty disclaimer: no warranty at all<br/><br/>2002.05.03: alpha 0.1.2<br/> - parse content of all 13818-1 descriptors<br/> - added change log to this dialog box<br/><br/>2002.04.25: ...
If saving to a zip file, the comment is also used for the zip file comment.<br><br><br><br>The Settings Window<br><br>This Window allows you to customize the capture process. Checkbox options in this...
This is the release notice for the PCnet Magic Packet(TM) Utility Revision 1.00 software. All files are in DOS FAT format. AMD抯 Magic Packet utility is a convenient tool for system administrators ...
It also parses out the ethernet and IP header information, as well as timestamp information for each packet. The VI enumerates all the ethernet adapters on your system and allows you interactively ...
The Practical Packet Analysis course is perfect for beginners to intermediate analysts, but seasoned pros will probably learn a few useful techniques too. Whether you’ve never capture packets before ...
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 ``` - **...
3、Can’t connect to local MySQL server through socket ‘/Data/mydata/mysql.sock’ socket文件目录不对应导致的问题 4、今天要说的就是 没有打开only_full_group_by Cause:...
计网学习练习的软件
无线网络破解工具What is aircrack ? aircrack is a set of tools for auditing wireless networks: + airodump: 802.11 packet capture program ... Note: you can also use Kismet .dump files for WEP cracking.
**Cisco Packet Tracer 7.1.1 for Windows 64 bit** 是一款由思科公司推出的强大网络模拟工具，专为教育和培训领域设计。它允许用户在虚拟环境中构建、配置、故障排除和管理网络，无需实际硬件设备。这款模拟器支持...
For example, she can easily change the phrase “Alice, I owe you $1000” to “Alice, I owe you $10,000”. Furthermore, Trudy can even drop the packets that are being sent by Bob to Alice (and vise-...