Advertisement
Guest User

Untitled

a guest
Aug 3rd, 2017
451
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.69 KB | None | 0 0
  1. 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.
  2.  
  3. mysql> SHOW VARIABLES LIKE ‘max_allowed_packet'
  4.  
  5. +--------------------+---------+
  6. | Variable_name | Value |
  7. +--------------------+---------+
  8. | max_allowed_packet | 4194304 |
  9. +--------------------+---------+
  10. 1 row in set (0.00 sec)
  11.  
  12. mysql> SET GLOBAL max_allowed_packet=512000000;
  13.  
  14. mysql> SHOW VARIABLES LIKE ‘max_allowed_packet'
  15.  
  16. 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