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
