Mysql automatically reset the max_allowed_packet to 1024
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
[mysqld]
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
Subject
Written By
Posted
Mysql automatically reset the max_allowed_packet to 1024
April 28, 2015 04:06AM
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.