Send of 8192 bytes failed with errno=32 Broken pipe

mysqli::query(): send of 8192 bytes failed with errno=32 Broken pipe
mysqli::query(): send of 72 bytes failed with errno=32 Broken pipe

question
I encountered the above problem when my mysql entered data
I uploaded a 10m clip to an editor, and the network address generated by the editor is data:base64
, and then it does not enter the data database
. What is the problem with this problem?

Environment
Server type: MariaDB
Server version: 10.1.25-MariaDB-1~xenial-mariadb.org binary distribution
Apache/2.4.18 (Ubuntu)
Database client version: libmysql-mysqlnd 5.0.12-dev-20150407-$Id: b5c5906d452ec590732a93b051f3827e02749b83 $
PHP extension: mysqli Documentation
PHP version: 7.0.31-1+ubuntu16.04.1+deb.sury.org+1
Version information: 4.5.4.1deb2ubuntu2.1


exceeds the length of the field, right? 10m is equivalent to 10485760 bytes, and fields of type Varchar should not be able to handle this task.
in fact, you have been struggling in the wrong direction, the right way is to upload the image to the image server, the editor only saves the image path, not the current Base64. If you look for other open source Editor, you need to automatically upload the image (configure the upload path) after dragging the image, and then fill in the image path into the editor.

Froala Editor uploads pictures to his server in the editor


if someone is struggling with this problem, here is the fix:

attempt to change / configure wait_timeout my.cnf profile in your mysql:

wait_timeout=3600

this profile is located at / etc/mysql/my.cnf (Ubuntu/Debian) and `usr/local/mysql/my.cnf (OSX).

restart the mysql server and it should work.


Why not upload a picture as big as this to the file server?

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b321e6-2bdd2.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b321e6-2bdd2.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?