I would like to ask if any one knows how I can solve this error that come while I was importing the data

Shopware 5 International (English Only)
1

It comes when I was running the cron: /opt/plesk/php/8.2/bin/php -d memory_limit=8G bin/console sw:cron:run Shopware_CronJob_XMLget -f

An exception occurred while executing ‚UPDATE s_crontab SET action = ?, interval = ?, data = ?, active = ?, next = ?, start = ?, end = ?, disable_on_error = ?, name = ? WHERE id = ?‘ with params [„Shopware_CronJob_XMLget“, 3600, „a:1:{s:5:"error";s:63:"SQLSTATE[HY000]: General error: 2006 MySQL server has gone away";}“, „0“, „2023-09-17 11:58:17“, „2023-09-17 09:32:12“, „2023-09-17 10:57:59“, „0“, „XML Get“, 31]:

SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
Please use the action name of a cronjob. You can see existing cronjobs in shopware backend or via sw:cron:list command.

2

Your MySQL Server had too much data to handle and thus „crashed“. Try to increase the memory limit für MySQL or reduce the PHP memory_limit, that it is available for MySQL.

Maybe try to reduce the import file by splitting it into several files and import it one by one.