Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Caused by: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (4237058 > 4194304). You can change this value on the server by setting the max_allowed_packet' variable.
- mysql> SHOW VARIABLES LIKE ‘max_allowed_packet'
- +--------------------+---------+
- | Variable_name | Value |
- +--------------------+---------+
- | max_allowed_packet | 4194304 |
- +--------------------+---------+
- 1 row in set (0.00 sec)
- mysql> SET GLOBAL max_allowed_packet=512000000;
- mysql> SHOW VARIABLES LIKE ‘max_allowed_packet'
- jdbc:mysql://[dbhost]:[dbport]?useUnicode=true&rewriteBatchedStatements=true&characterEncoding=utf8&useServerPrepStmts=true&maxAllowedPacket=20000000&useSSL=false
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement