Communication link failure: 1153 Got a packet bigger than 'max_allowed_packet

[feerdispzoo]

Everytime I get:

[2022-06-28 09:58:23] main.CRITICAL: SQLSTATE[08S01]: Communication link failure: 1153 Got a packet bigger than 'max_allowed_packet' bytes, query was: SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=2

im using litespeed web server. I edit:

vi /etc/my.cnf

and increase max_allowed_pocket to 600M

then

service lsws restart

But still the same error, How can I check if my changes are approved?

 

[Ohm J]

you restart wrong service,

should do
service mysqld restart