Error 2020: Got packet bigger than 'max_allowed_packet' bytes when dumping table XXX

Issue

When you request a backup, the task fails  with this error

mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet' bytes when dumping table XXXXX

Resolution

Acquia needs to upsize the 'max_allowed_packet' on the server, please  file a ticket with Acquia Support