I was working on magento2 and encountered error “Communication link failure: 1153 Got a packet bigger than ‘max_allowed_packet’ bytes”. The shop was quite big because more than 75000 products with a lot of custom attributes more than 150. When I tried to move category I couldn’t and there was no erros, page just reloaded itself after moving and category was back to previous place, when I tried to delete product from admin panel I had above error but after small digging I found a solution. All you need to do is set “net_buffer_length” and “max_allowed_packet”.

Example mysql:
1. set global net_buffer_length=1000000;
2. set global max_allowed_packet=1000000000;

 

Leave a Reply

Your email address will not be published. Required fields are marked *

Fork us on GitHub