maria-discuss team mailing list archive

[Reindl Harald <h.reindl@xxxxxxxxxxxxx>]

/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'>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