Error while sending QUERY packet

Question

i was trying to insert some data into the database but i got this error  Error while sending QUERY packet      insertDeta    conPat- gt prepare  insert into table1 data  VALUES  data      insertDeta- gt bindParam   data   data    conPat- gt beginTransaction             insertDeta- gt execute     conPat- gt commit      but what i think the problem is that size of the data is over 16MB  the data type of the column is set as longtext  which i think can keep data as big as 4GB     I dont know if PDOs is having problems running the query or transfering 16MB of data to the database  Thats the only guess i can make as mysql might send the data in packets and the packet cannot hold data as large as 16MB

User · Answer

In  etc my cnf add     max allowed packet 32M   It worked for me   You can verify by going into PHPMyAdmin and opening a SQL command window and executing   SHOW VARIABLES LIKE   max allowed packet

User · Answer

You cannot have the WHERE clause in an INSERT statement   insert into table1 data  VALUES  data  where sno   45830   Should be  insert into table1 data  VALUES  data     Update  You have removed that from your code  I assume you copied the code in wrong   You want to increase your allowed packet size   SET GLOBAL max allowed packet 32M  Change the 32M  32 megabytes  up down as required  Here is a link to the MySQL documentation on the subject

User · Answer

You may also have this error if the variable wait timeout is too low   If so  you may set it higher like that    SET GLOBAL wait timeout 10    This was the solution for the same error in my case

User · Answer

You can solve this problem by following few steps   1  open your terminal window  2  please write following command in your terminal  ssh root yourIP port   3  Enter root password  4  Now edit your server my cnf file using below command  nano  etc my cnf     if command is not recognized do this first or try vi then repeat  yum install nano   OR    vi  etc my cnf    5  Add the line under the  MYSQLD  section      max allowed packet 524288000  obviously adjust size for whatever you need   wait timeout   100   6  Control   O  save   then ENTER  confirm  then Control   X  exit file   7  Then restart your mysql server by following command   etc init d mysql stop  etc init d mysql start   8   You can verify by going into PHPMyAdmin or opening a SQL command window and executing   SHOW VARIABLES LIKE  max allowed packet    This works for me  I hope it should work for you

User · Answer

You guessed right MySQL have limitation for size of data  you need to break your query in small group of records or you can Change your max allowed packet by using SET GLOBAL max allowed packet 524288000

User · Answer

I encountered a rare edge case in cygwin  where I would get this error when doing exec  rsync    somewhere before the query  Might be a general PHP problem  but I could only reproduce this in cygwin with rsync    pdo   new PDO  mysql host 127 0 0 1 dbname mysql    root    var dump  pdo- gt query  SELECT   FROM db     exec  rsync    var dump  pdo- gt query  SELECT   FROM db       produces  object PDOStatement  2  1         queryString    gt     string 16   SELECT   FROM db    PHP Warning   Error while sending QUERY packet  PID 15036 in test php on line 5 bool false    Bug reported in https   cygwin com ml cygwin 2017-05 msg00272 html

User · Answer

If inserting  too much data  fails due to the max allowed packet setting of the database server  the following warning is raised   SQLSTATE 08S01   Communication link failure  1153 Got a packet bigger than   max allowed packet  bytes   If this warning is catched as exception  due to the set error handler   the database connection is  probably  lost but the application doesn t know about this  failing inserts can have several causes   The next query in line  which can be as simple as   SELECT 1 FROM DUAL   Will then fail with the error this SO-question started   Error while sending QUERY packet  PID 18486   Simple test script to reproduce my explanation  try it with and without the error handler to see the difference in impact   set error handler function  errno   errstr   errfile   errline  array  errcontext           error was suppressed with the  -operator     if  0     error reporting              return false             throw new ErrorException  errstr  0   errno   errfile   errline        try           oDb is instance of PDO     var dump  oDb- gt query  SELECT 1 FROM DUAL           oStatement    oDb- gt prepare  INSERT INTO  test    id    message   VALUES  NULL   message           oStatement- gt bindParam   message    largetext  PDO  PARAM STR       var dump  oStatement- gt execute       catch Exception  e         e- gt getMessage      var dump  oDb- gt query  SELECT 2 FROM DUAL

User · Answer

Had such a problem when executing forking in php for command line  In my case from time to time the php killed the child process  To fix this  just wait for the process to complete using the command pcntl wait  status    here s a piece of code for a visual example          bin php -n      lt  php     error reporting E ALL  amp   E NOTICE       ini set  log errors   1       ini set  error log     media logs php fork log         ski   substr str shuffle str repeat  0123456789abcdefghijklmnopqrstuvwxyz   5    0  5       error log getmypid        ski   start my php          pid   pcntl fork        if  pid        error log getmypid        ski   start 2           Wait for children to return  Otherwise they         would turn into  Zombie  processes               add this            pcntl wait  status                 add this              else       error log getmypid        ski   start 3           03-Apr-2020 12 13 47 UTC  PHP Warning   Error while sending QUERY packet  PID 18048 in  speed sport fortest php on line 22457     mysqli query  con  query MYSQLI ASYNC   error log getmypid        ski   sleep child      sleep 15       exit             error log getmypid        ski  end my php        exit 0         gt

[php] Error while sending QUERY packet

Examples related to php

Examples related to mysql