Am 16.02.2017 um 10:04 schrieb Peter Laursen:
The particular error message "Got packet bigger than
'max_allowed_packet' bytes" is returned from the client and not the
server.
Both the server and the client has a "max_allowed_packet" setting. The
client-one is listed
here https://dev.mysql.com/doc/refman/5.7/en/mysql-command-options.html
well, that don't change the fact that i no longer can fetch a base64
encoded binary file uploaded on 2016-10-06 which was already on PHP
7.0, has a count of 32 downloads (not much i know) and the only recent
change is MariaDB 10.0.x to 10.1.x
[16-Feb-2017 10:33:15 Europe/Vienna] PHP Warning: mysqli_fetch_assoc()
[<a
href='http://at.php.net/manual/de/function.mysqli-fetch-assoc.php'>function.mysqli-fetch-assoc.php</a>]:
Malformed server packet. Field length pointing 22 bytes after end of
packet in /phpincludes/global_mysql_class.inc.php on line 639
[16-Feb-2017 10:33:15 Europe/Vienna] PHP Warning: mysqli_fetch_assoc()
[<a
href='http://at.php.net/manual/de/function.mysqli-fetch-assoc.php'>function.mysqli-fetch-assoc.php</a>]:
Error while reading a row in /phpincludes/global_mysql_class.inc.php
on line 639
On Thu, Feb 16, 2017 at 8:57 AM, Reindl Harald <h.reindl@xxxxxxxxxxxxx
<mailto:h.reindl@xxxxxxxxxxxxx>> wrote:
/etc/my.cnf (for many years now)
max_allowed_packet = 200M
how can it be that when the whole table file is 54MB large with a
setting of 200MB that something is larger then 200MB while obviously
it was not too large at insert time at 2016-10-06 but with MariaDB
10.0.x instead 10.1.x?
PHP says mysqli_fetch_assoc() [<a
href='http://at.php.net/manual/de/function.mysqli-fetch-assoc.php
<http://at.php.net/manual/de/function.mysqli-fetch-assoc.php>'>function.mysqli-fetch-assoc.php</a>]:
Malformed server packet. Field length pointing 22 bytes after end of
packet
MariaDB [afi]> select * from cms1_docmgmt_entrys where doc_id=19;
ERROR 2020 (HY000): Got packet bigger than 'max_allowed_packet'
bytes
MariaDB [afi]> show variables like 'max_allowed_packet';
+--------------------+-----------+
| Variable_name | Value |
+--------------------+-----------+
| max_allowed_packet | 209715200 |
+--------------------+-----------+
1 row in set (0,00 sec)
MariaDB [afi]> select doc_file_download_size from
cms1_docmgmt_entrys where doc_id=19;
+------------------------+
| doc_file_download_size |
+------------------------+
| 15838399 |
+------------------------+
1 row in set (0,00 sec)
-rw-rw---- 1 mysql mysql 9,3K 2017-02-04 15:39
cms1_docmgmt_entrys.frm
-rw-rw---- 1 mysql mysql 54M 2017-02-10 04:05
cms1_docmgmt_entrys.MYD
-rw-rw---- 1 mysql mysql 234K 2017-02-10 04:05
cms1_docmgmt_entrys.MYI
