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. -- Peter -- Webyog On Thu, Feb 16, 2017 at 8:57 AM, Reindl Harald <[email protected]> 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'>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 > > _______________________________________________ > Mailing list: https://launchpad.net/~maria-discuss > Post to : [email protected] > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp >
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
