| Bug #80622 | Packet for query is too large (1122 > 1024) | ||
|---|---|---|---|
| Submitted: | 5 Mar 2016 3:12 | Modified: | 7 Mar 2016 15:08 |
| Reporter: | Amila Banuka Amarasinghe | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Server: Connection Handling | Severity: | S2 (Serious) |
| Version: | 5.7.11 | OS: | Ubuntu |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | client, jdbc, query | ||
[5 Mar 2016 20:58]
MySQL Verification Team
Are you tried to increase the value of max_allowed_packet (maybe 250 MB)?. Thanks.
[6 Mar 2016 2:45]
Amila Banuka Amarasinghe
We have not tried. because the exception is complaining the max allowed packet size is 1122 (1122 > 1024). We'll update the server value and provide an update within few days.
[7 Mar 2016 15:08]
MySQL Verification Team
This is a duplicate of the bug #76177. If you do not consider this a duplicate, provide a fully repeatable test case. This test case should involve only MySQL server and a program written with some of our Connectors, best of all Connector/C. A test case using any second or third tier programs, like WWW servers will not be considered as this could just show a bug that does not belong to MySQL.
Description: We are experiencing a problem with mysql connectivity as below [DEBUG] 2016-03-05 02:50:18.845 [http-bio-8080-exec-1] SqlExceptionHelper - could not extract ResultSet [n/a] com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1122 > 1024). You can change this value on the server by setting the max_allowed_packet' variable. at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3592) ~[mysql-connector-java-5.1.34.jar:5.1.34] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2417) ~[mysql-connector-java-5.1.34.jar:5.1.34] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) ~[mysql-connector-java-5.1.3 when executed the following command on terminal it shows the max allowed packet size value as 32MB which is the configured value in the config file SHOW VARIABLES LIKE 'max_allowed_packet'; +--------------------+----------+ | Variable_name | Value | +--------------------+----------+ | max_allowed_packet | 33554432 | +--------------------+----------+ 1 row in set (0.00 sec) in /etc/mysql/my.cnf I have the config un [mysqld] as below [mysqld] /** other configs **/ max_allowed_packet = 32M connection url does not seems to be having any configuration on this as it shows the url as jdbc:mysql://localhost:3306/nickelring_test once the mysql server is restarted this problem goes away but appear again within few days. How to repeat: no idea. It would appear every few days.