← Back to team overview

maria-discuss team mailing list archive

Re: 10.1.x: Got packet bigger than 'max_allowed_packet' bytes

 

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 <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'>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     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
>

Follow ups

References