Re: A 'max_allowed_packet' Exception

[Smith Owen]

Thanks Alexander.
My running environment is a GNU Linux 64 bits, MySQL5.6.19, ActiveMQ5.11.1. The MySQL is installed through rpm and basicly with the default setup.

One of the problems I mentioned before has been resolved this afternoon. I set the 'max_allowed_packet' of '[client]' to 100M in '/etc/my.cnf' and it worked, the 'SELECT' statement did not report any exceptions.

However, the first problem still exist. The MQ still report a ERROR like 'Packet for query is too large (1550606 > 1048576). You can change this value on the server by setting the max_allowed_packet variable.’. There are serval things to sure. First, the MQ is relied on the MySQL run into the question, because the MQ report can not connect to the MySQL when I stoped the MySQL. Second, the 'max_allowed_packet' value of target database is 100M, which I checked through 'show VARIABLES like '%max_allowed_packet%'', 'mysql --help' and the '/etc/my.cnf'. That means the '/etc/my.cnf' do not be covered, is that right? What makes me real confused is that where is the restriction 1048576==1M came from?????? I believe there is no such a value at all.