A 'max_allowed_packet' Exception
Posted by: Smith Owen
Date: March 31, 2015 11:35PM

Hi,everyone:
I have run into a tough problem, here is my stituation.
I run a MySQL for the persistence of activeMQ and it run give a exception 'the packet for query is bigger than ...'. Obviously, I re-configured my '/etc/my.cnf' to set the variable 'max_allowed_packet' to 100M which is more than what I need. To confirm it , I restarted both MySQL and ActiveMQ and check through 'SHOW VARIABLES like 'max_allowed_packet'', it is 100M. However, the Exception still exists. Then, I wrote a java program to insert a 20M record to MySQL, it is succeed. But where I query the record through 'SELECT ....', it says that 'Got packet bigger than 'max_allowed_packet' bytes'. I have no idea what to do right now , Do you guys have any suggestion?

Options: ReplyQuote


Subject
Written By
Posted
A 'max_allowed_packet' Exception
March 31, 2015 11:35PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.