Stack Overflow
Stack Overflow

Questions tagged [max-allowed-packet]

23 questions
524
votes
15 answers

MySQL Error 1153 - Got a packet bigger than 'max_allowed_packet' bytes

I'm importing a MySQL dump and getting the following error. $ mysql foo < foo.sql ERROR 1153 (08S01) at line 96: Got a packet bigger than 'max_allowed_packet' bytes Apparently there are attachments in the database, which makes for very large…
kch
  • 77,385
  • 46
  • 136
  • 148
48
votes
3 answers

increase max_allowed_packet size in mysql docker

We are using Docker for mysql, We are facing the below error while running Packet for query is too large (12884616 > 4194304). You can change this value on the server by setting the max_allowed_packet' variable.; nested exception is…
Bharath Dasararaju
  • 505
  • 1
  • 4
  • 9
9
votes
2 answers

MySql Error 'max_allowed_packet' bytes during import SQL script on database hosted on AWS RDS

I was facing an issue during import SQL file on MySql database which is on AWS RDS, during import SQL file initial table was imported then suddenly it shows an error. I know this error and I can solve this by increasing max_allowed_packet size in…
Krupal Patel
  • 1,387
  • 3
  • 12
  • 28
5
votes
1 answer

osx mariaDB how to set max_allowed_packet

I am trying to set 'max_allowed_packet' in 'my.cnf' which on my iMac is located in: /usr/local/etc/ I've tried: SET GLOBAL max_allowed_packet=1073741824; I've also tried adding a section: [mysqld] SET GLOBAL…
SPlatten
  • 5,334
  • 11
  • 57
  • 128
2
votes
2 answers

How calculate the size of a MySQL statement (not the query results)

I'm working on a tool that generates and runs SQL against a MySQL database. I'm trying to add the ability to limit the size of a insert statement based on a user-specified setting. I found some info about the max_allowed_packet setting, but I…
Microsoft Excel
  • 159
  • 2
  • 11
1
vote
1 answer

Find the size of a query

Based on the max_allowed_packet configuration parameter in MySQL, I am curious to understand how I can determine the size of the query related to that particular configuration? We can use the SHOW VARIABLES LIKE 'max_allowed_packet' command in the…
Mahshid H
  • 13
  • 3
1
vote
2 answers

MySQL complains about max_allowed_packet violation with query shorter than the allowed limit

Doing a multi-insert query, I receive error "SQLSTATE[08S01]: Communication link failure: 1153 Got a packet bigger than 'max_allowed_packet' bytes". I have a complex class that composes multi-insert queries thoroughly checking against the limit, so…
Alex the Marrch Ca'at
  • 11
  • 1
1
vote
0 answers

max_allowed_packet variable change not resolving Packet for query is too large error

I have MYSQL server hosted on a linux box. I am trying to access the server from my Java application. In the process, I came across an error message which is seemingly quite common with a resolution specified. I have tried the same at the Mysql…
VSTech
  • 77
  • 3
  • 11
1
vote
1 answer

MySQL: Error while sending QUERY packet. PID=2

I try to execute a very simple query to delete one row. the "max_allowed_packet" equals "1073741824" that's why I'm confused why I get Error while sending QUERY packet. PID=2 I select just 25 rows from a table to send their data via sms and…
PHP User
  • 2,350
  • 6
  • 46
  • 87
1
vote
1 answer

Error 'Packet for query is too large' when I tried to make a query on my website

Again I need your help. I'm trying to put my java web site online. What I use : MySQL server : command line mysql -V, result : mysql Ver 15.1 Distrib 10.1.23-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2 Cayenne Debian server Java…
Bob
  • 529
  • 1
  • 7
  • 28
1
vote
1 answer

My sql: PacketTooBigException: Packet for query is too large (4,739,923 > 65,535)

I am trying to connect to a database on my raspbery pi. I have mysql downloaded on the pi and have created a database on there already. I am trying to use driver manager to connect. Here is my code for it: public static void main(String[] args) { …
Will Johnston
  • 11
  • 2
0
votes
0 answers

MySql/MariaDB longtext truncated and max_allowed_packet

I have a problem with MariaDB with a longtext field. It is limited to 32770 chars and there is no way to grow it up. SELECT CHAR_LENGTH(longtext_column) from table where id = x; I edited my cnf like this: [mysqld] max_allowed_packet = …
JuliSmz
  • 996
  • 1
  • 12
  • 26
0
votes
0 answers

mysql server log file is increasing in size with warnings

Version: Mysql server version is 8.0 and it is installed on Windows server 2019. Problem statement: Error log file from location C:\programdata\mysql80\data\ is increasing and it is about ~100GB. Error log statements are : [Warning] [MY-011959]…
SupriyaD
  • 71
  • 1
  • 1
  • 2
0
votes
1 answer

Packet for query to large. Setting max_allowed_packet

When i connect to my databse via phpmyadmin everything works fine and it shows me the data. When i am on my server i can see all data and work with it. But when i try to connect to my server i'm getting this…
kaeptenlook
  • 27
  • 7
0
votes
1 answer

mysql INSERT fails but no error thrown: max_allowed_packet: settings show conflicting results

I successfully receive data into server client account via _POST but I can't insert data into row table that holds longblob types when row data is above ~25MB. I cannot see any errors thrown by the the php prepared statements/file, php file closes…
Sergio Solorzano
  • 476
  • 9
  • 29
1
2