MySQL Forums
Forum List  »  Newbie

Mysql automatically reset the max_allowed_packet to 1024
Posted by: Mahesh Gohil
Date: April 28, 2015 04:06AM

Caused by: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (2420 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.

I set
SET GLOBAL max_allowed_packet=16777216;

and also
max_allowed_packet = 16M

I also check the value after setting the value

SHOW VARIABLES LIKE 'max_allowed_packet'; and value = 16777216.

But after few days the value set to 1024 automatically.
Mysql not restarted and there is no script that updated this value.

How to repeat:
I don't konw how to repeat. It would appear every few days

Options: ReplyQuote

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.