Stack Overflow
Stack Overflow

Questions tagged [max-allowed-packet]

23 questions
0
votes
1 answer

MySQL Server does not start after changing max_allowed_packet parameter

MySQL Community Edition 8.0.13 on Windows 10 Pro 32 GB x64 I am running the community server 8.0.18 (from the command line and not the service) and I need to set the max_allowed_packet value to higher than the default. However,the server hangs on…
Rajneesh
  • 51
  • 6
0
votes
0 answers

How to fix 'SchemaUpdate - HHH000319: Could not get database metadata' because Packet for query is too large (5,526,600 > 65,535)

0I want to connect spring boot with the mysql database on the global server, but I found an error 'HHH000319: Could not get database metadata' because Packet for query is too large (5,526,600> 65,535). You can change this value on the server by…
frikadacintia
  • 3
  • 1
0
votes
0 answers

ERROR 2020 (HY000): Got packet bigger than 'max_allowed_packet' bytes, when trying to retrieve data from a table

I am working on my local set up of a web application and I have to fetch all the items in a table, but when I do select * from my_table, it gives me this errorERROR 2020 (HY000): Got packet bigger than 'max_allowed_packet' bytes. I have tried many…
Harish Kumar Saini
  • 362
  • 3
  • 20
0
votes
3 answers

MySQL server has gone away, PDO and max_allowed_packet in PHP

Do you know how to avoid the following fatal error message : "...MySQL server has gone away". I suppose this means that PDO connection to MySQL has been lost. I have checked MySQL max_allowed_packet variable which is equal to 268435456 (I think…
Jam
  • 1
  • 1
0
votes
0 answers

max_allowed_packet in my.cnf is not reflected in MySql 5.7

We have changed the value of "max_allowed_packet" in my.cnf to [mysqld] max_allowed_packet = 200M but, when we show variables like 'max_allowed_packet';, we get the "max_allowed_packet" as 4194304. We tried to set global…
Ghadeer
  • 608
  • 2
  • 7
  • 21
0
votes
0 answers

max_allowed_packet in mysql_multi instances

I hace a mysql server with mysql_multi, so I have to instances mysql1 and mysql2, this two work on diferent ports, when try to consum a soap webservice y get in some ocassions an error like this SQLSTATE[08S01]: Communication link failure: 1153 Got…
pipook
  • 27
  • 1
  • 7
0
votes
1 answer

max_allowed_packet is resetting to 1024 because some unknown application

Whenever I change max_allowed_packet, its getting reset after few hours. when I checked query log then I found following queries. But I am unable to figure out which application or process executes this queries. Does anyone know what is it about? or…
nilesh
  • 1,483
  • 2
  • 19
  • 37
-1
votes
1 answer

How can I query the MySQL Max_Allowed_Packet through c#?

I am trying to check the value of the max_allowed_packet size. This is my code: public int MaxAllowedPacket() { var max = 0; using (var conn = new MySqlConnection(_ConnectionString)) { var sql =…
4ndy
  • 550
  • 1
  • 9
  • 23
1
2