Errors from mailpoet in admin/error_log

Hi,
We are running mailpoet the latest version and we are experiencing the following errors in our wp-admin/error_log file:

WordPress database error The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay for query
SELECT SQL_CALC_FOUND_ROWS wpposts.*
FROM wpposts LEFT JOIN wppostmeta ON ( wpposts.ID = wppostmeta.post_id ) LEFT JOIN wppostmeta AS mt1 ON ( wpposts.ID = mt1.post_id AND mt1.meta_key = ‘smush-complete’ ) LEFT JOIN wppostmeta AS mt2 ON ( wpposts.ID = mt2.post_id ) LEFT JOIN wppostmeta AS mt3 ON ( wpposts.ID = mt3.post_id AND mt3.meta_key = ‘_shortpixel_status’ ) LEFT JOIN wppostmeta AS mt4 ON ( wpposts.ID = mt4.post_id AND mt4.meta_key = ‘wp-smpro-smush-data’ ) LEFT JOIN wppostmeta AS mt5 ON ( wpposts.ID = mt5.post_id AND mt5.meta_key = ‘_imagify_optimization_level’ ) LEFT JOIN wppostmeta AS mt6 ON ( wpposts.ID = mt6.post_id AND mt6.meta_key = ‘tiny_compress_images’ )
WHERE 1=1 AND (wpposts.post_mime_type LIKE ‘image/%’) AND (
(
( wppostmeta.meta_key = ‘smush-complete’ AND wppostmeta.meta_value != ‘1’ )
OR
mt1.post_id IS NULL
)
AND
(
( mt2.meta_key = ‘_shortpixel_status’ AND mt2.meta_value < ‘2’ )
OR
( mt2.meta_key = ‘_shortpixel_status’ AND mt2.meta_value >= ‘3’ )
OR
mt3.post_id IS NULL
)
AND
mt4.post_id IS NULL
AND
mt5.post_id IS NULL
AND
mt6.post_id IS NULL
) AND wpposts.post_type = ‘attachment’ AND ((wpposts.post_status = ‘inherit’))
GROUP BY wpposts.ID
ORDER BY wpposts.post_date DESC
LIMIT 0, 1000
made by do_action(‘wp_ajax_updraft_smush_ajax’), WP_Hook->do_action, WP_Hook->apply_filters, Updraft_Smush_Manager->updraft_smush_ajax, Updraft_Smush_Manager_Commands->get_ui_update, Updraft_Smush_Manager->get_uncompressed_images, WP_Query->__construct, WP_Query->query, WP_Query->get_posts
[23-Sep-2022 13:36:22 UTC] WordPress database error The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay for query
SELECT SQL_CALC_FOUND_ROWS wpposts.*
FROM wpposts LEFT JOIN wppostmeta ON ( wpposts.ID = wppostmeta.post_id ) LEFT JOIN wppostmeta AS mt1 ON ( wpposts.ID = mt1.post_id AND mt1.meta_key = ‘smush-complete’ ) LEFT JOIN wppostmeta AS mt2 ON ( wpposts.ID = mt2.post_id ) LEFT JOIN wppostmeta AS mt3 ON ( wpposts.ID = mt3.post_id AND mt3.meta_key = ‘_shortpixel_status’ ) LEFT JOIN wppostmeta AS mt4 ON ( wpposts.ID = mt4.post_id AND mt4.meta_key = ‘wp-smpro-smush-data’ ) LEFT JOIN wppostmeta AS mt5 ON ( wpposts.ID = mt5.post_id AND mt5.meta_key = ‘_imagify_optimization_level’ ) LEFT JOIN wppostmeta AS mt6 ON ( wpposts.ID = mt6.post_id AND mt6.meta_key = ‘tiny_compress_images’ )
WHERE 1=1 AND (wpposts.post_mime_type LIKE ‘image/%’) AND (
(
( wppostmeta.meta_key = ‘smush-complete’ AND wppostmeta.meta_value != ‘1’ )
OR
mt1.post_id IS NULL
)
AND
(
( mt2.meta_key = ‘_shortpixel_status’ AND mt2.meta_value < ‘2’ )
OR
( mt2.meta_key = ‘_shortpixel_status’ AND mt2.meta_value >= ‘3’ )
OR
mt3.post_id IS NULL
)
AND
mt4.post_id IS NULL
AND
mt5.post_id IS NULL
AND
mt6.post_id IS NULL
) AND wpposts.post_type = ‘attachment’ AND ((wpposts.post_status = ‘inherit’))
GROUP BY wpposts.ID
ORDER BY wpposts.post_date DESC
LIMIT 0, 1000
made by do_action(‘wp_ajax_updraft_smush_ajax’), WP_Hook->do_action, WP_Hook->apply_filters, Updraft_Smush_Manager->updraft_smush_ajax, Updraft_Smush_Manager_Commands->get_ui_update, Updraft_Smush_Manager->get_uncompressed_images, WP_Query->__construct, WP_Query->query, WP_Query->get_posts
[26-Sep-2022 06:34:54 UTC] PHP Warning: session_write_close(): Cannot call session save handler in a recursive manner in /public_html/wp-includes/class-wp-hook.php on line 305
[26-Sep-2022 06:34:54 UTC] PHP Warning: session_write_close(): Failed to write session data using user defined save handler. (session.save_path: /var/cpanel/php/sessions/ea-php74) in /public_html/wp-includes/class-wp-hook.php on line 305
[26-Sep-2022 06:34:57 UTC] PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in /public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:59
Stack trace:
#0 /public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(59): PDOStatement->execute(NULL)
#1 /public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(495): MailPoetVendor\Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(375): MailPoetVendor\Doctrine\DBAL\Connection->executeQuery(‘SELECT t0.wp_us…’, Array, Array)
#3 /public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php(78): MailPoetVendo in /public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php on line 91`

This was invoked while an image was changed in a mailpoet newsletter. Please advise on how to fix this sql error.
Thanks in advance