Technical issue

Resolved me1xx2
(@me1xx2)

9 months, 1 week ago

Hi,

my site has currently an issue. This is the error log.
Can you say what the error causes? Is it a woocommerce problem?

Fehler-Details

Ein Fehler vom Typ E_ERROR wurde in der Zeile 32 der Datei/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php verursacht. Fehlermeldung: Uncaught MailPoet\Doctrine\WPDB\Exceptions\QueryException: Lock wait timeout exceeded; try restarting transaction in/wp-content/plugins/mailpoet/lib/Doctrine/WPDB/Connection.php:132
Stack trace: 0/wp-content/plugins/mailpoet/lib/Doctrine/WPDB/Connection.php(123): MailPoet\Doctrine\WPDB\Connection->handleQueryError() 1/wp-content/plugins/mailpoet/lib/Doctrine/WPDB/Connection.php(35): MailPoet\Doctrine\WPDB\Connection->runQuery(‘\n DELETE F…’) 2/wp-content/plugins/mailpoet/lib/Doctrine/WPDB/Statement.php(71): MailPoet\Doctrine\WPDB\Connection->query(‘\n DELETE F…’) 3/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/src/Connection.php(471): MailPoet\Doctrine\WPDB\Statement->execute() 4/wp-content/plugins/mailpoet/lib/Logging/LogRepository.php(98): MailPoetVendor\Doctrine\DBAL\Connection->executeStatement(‘\n DELETE F…’, Array, Array) 5/wp-content/plugins/mailpoet/lib/Logging/LogHandler.php(69): MailPoet\Logging\LogRepository->purgeOldLogs(30, 1000) 6/wp-content/plugins/mailpoet/lib/Logging/LogHandler.php(57): MailPoet\Logging\LogHandler->purgeOldLogs() 7/wp-content/plugins/mailpoet/vendor-prefixed/monolog/monolog/src/Monolog/Handler/AbstractProcessingHandler.php(18): MailPoet\Logging\LogHandler->write(Array) 8/wp-content/plugins/mailpoet/vendor-prefixed/monolog/monolog/src/Monolog/Logger.php(149): MailPoetVendor\Monolog\Handler\AbstractProcessingHandler->handle(Array) 9/wp-content/plugins/mailpoet/vendor-prefixed/monolog/monolog/src/Monolog/Logger.php(249): MailPoetVendor\Monolog\Logger->addRecord(100, ‘Personalization…’, Array) 10/wp-content/plugins/mailpoet/lib/EmailEditor/Integrations/MailPoet/Logger.php(110): MailPoetVendor\Monolog\Logger->debug(‘Personalization…’, Array) 11/wp-content/plugins/mailpoet/vendor/woocommerce/email-editor/src/Engine/Logger/class-email-editor-logger.php(35): MailPoet\EmailEditor\Integrations\MailPoet\Logger->debug(‘Personalization…’, Array) 12/wp-content/plugins/mailpoet/vendor/woocommerce/email-editor/src/Engine/PersonalizationTags/class-personalization-tags-registry.php(30): Automattic\WooCommerce\EmailEditor\Engine\Logger\Email_Editor_Logger->debug(‘Personalization…’, Array) 13/wp-content/plugins/mailpoet/lib/EmailEditor/Integrations/MailPoet/PersonalizationTagManager.php(78): Automattic\WooCommerce\EmailEditor\Engine\PersonalizationTags\Personalization_Tags_Registry->register(Object(Automattic\WooCommerce\EmailEditor\Engine\PersonalizationTags\Personalization_Tag)) 14/wp-includes/class-wp-hook.php(324): MailPoet\EmailEditor\Integrations\MailPoet\PersonalizationTagManager->MailPoet\EmailEditor\Integrations\MailPoet{closure}(Object(Automattic\WooCommerce\EmailEditor\Engine\PersonalizationTags\Personalization_Tags_Registry)) 15/wp-includes/plugin.php(205): WP_Hook->apply_filters(Object(Automattic\WooCommerce\EmailEditor\Engine\PersonalizationTags\Personalization_Tags_Registry), Array) 16/wp-content/plugins/mailpoet/vendor/woocommerce/email-editor/src/Engine/PersonalizationTags/class-personalization-tags-registry.php(14): apply_filters(‘woocommerce_ema…’, Object(Automattic\WooCommerce\EmailEditor\Engine\PersonalizationTags\Personalization_Tags_Registry)) 17/wp-content/plugins/mailpoet/vendor/woocommerce/email-editor/src/Engine/class-email-editor.php(81): Automattic\WooCommerce\EmailEditor\Engine\PersonalizationTags\Personalization_Tags_Registry->initialize() 18/wp-content/plugins/mailpoet/vendor/woocommerce/email-editor/src/Engine/class-email-editor.php(45): Automattic\WooCommerce\EmailEditor\Engine\Email_Editor->register_personalization_tags() 19/wp-content/plugins/mailpoet/vendor/woocommerce/email-editor/src/class-bootstrap.php(40): Automattic\WooCommerce\EmailEditor\Engine\Email_Editor->initialize() 20/wp-includes/class-wp-hook.php(324): Automattic\WooCommerce\EmailEditor\Bootstrap->initialize(”) 21/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters(NULL, Array) 22/wp-includes/plugin.php(517): WP_Hook->do_action(Array) 23/wp-settings.php(727): do_action(‘init’) 24/wp-config.php(104): require_once(‘/pages/0b/e8/d0…’) 25/wp-load.php(50): require_once(‘/pages/0b/e8/d0…’) 26/wp-admin/admin.php(35): require_once(‘/pages/0b/e8/d0…’) 27 {main}

Next MailPoetVendor\Doctrine\DBAL\Exception\LockWaitTimeoutException: An exception occurred while executing a query: Lock wait timeout exceeded; try restarting transaction in/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:32
Stack trace: 0/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/src/Connection.php(821): MailPoetVendor\Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(Object(MailPoet\Doctrine\WPDB\Exceptions\QueryException), Object(MailPoetVendor\Doctrine\DBAL\Query)) 1/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/src/Connection.php(793): MailPoetVendor\Doctrine\DBAL\Connection->handleDriverException(Object(MailPoet\Doctrine\WPDB\Exceptions\QueryException), Object(MailPoetVendor\Doctrine\DBAL\Query)) 2/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/src/Connection.php(475): MailPoetVendor\Doctrine\DBAL\Connection->convertExceptionDuringQuery(Object(MailPoet\Doctrine\WPDB\Exceptions\QueryException), ‘\n DELETE F…’, Array, Array) 3/wp-content/plugins/mailpoet/lib/Logging/LogRepository.php(98): MailPoetVendor\Doctrine\DBAL\Connection->executeStatement(‘\n DELETE F…’, Array, Array) 4/wp-content/plugins/mailpoet/lib/Logging/LogHandler.php(69): MailPoet\Logging\LogRepository->purgeOldLogs(30, 1000) 5/wp-content/plugins/mailpoet/lib/Logging/LogHandler.php(57): MailPoet\Logging\LogHandler->purgeOldLogs() 6/wp-content/plugins/mailpoet/vendor-prefixed/monolog/monolog/src/Monolog/Handler/AbstractProcessingHandler.php(18): MailPoet\Logging\LogHandler->write(Array) 7/wp-content/plugins/mailpoet/vendor-prefixed/monolog/monolog/src/Monolog/Logger.php(149): MailPoetVendor\Monolog\Handler\AbstractProcessingHandler->handle(Array) 8/wp-content/plugins/mailpoet/vendor-prefixed/monolog/monolog/src/Monolog/Logger.php(249): MailPoetVendor\Monolog\Logger->addRecord(100, ‘Personalization…’, Array) 9/wp-content/plugins/mailpoet/lib/EmailEditor/Integrations/MailPoet/Logger.php(110): MailPoetVendor\Monolog\Logger->debug(‘Personalization…’, Array) 10/wp-content/plugins/mailpoet/vendor/woocommerce/email-editor/src/Engine/Logger/class-email-editor-logger.php(35): MailPoet\EmailEditor\Integrations\MailPoet\Logger->debug(‘Personalization…’, Array) 11/wp-content/plugins/mailpoet/vendor/woocommerce/email-editor/src/Engine/PersonalizationTags/class-personalization-tags-registry.php(30): Automattic\WooCommerce\EmailEditor\Engine\Logger\Email_Editor_Logger->debug(‘Personalization…’, Array) 12/wp-content/plugins/mailpoet/lib/EmailEditor/Integrations/MailPoet/PersonalizationTagManager.php(78): Automattic\WooCommerce\EmailEditor\Engine\PersonalizationTags\Personalization_Tags_Registry->register(Object(Automattic\WooCommerce\EmailEditor\Engine\PersonalizationTags\Personalization_Tag)) 13/wp-includes/class-wp-hook.php(324): MailPoet\EmailEditor\Integrations\MailPoet\PersonalizationTagManager->MailPoet\EmailEditor\Integrations\MailPoet{closure}(Object(Automattic\WooCommerce\EmailEditor\Engine\PersonalizationTags\Personalization_Tags_Registry)) 14/wp-includes/plugin.php(205): WP_Hook->apply_filters(Object(Automattic\WooCommerce\EmailEditor\Engine\PersonalizationTags\Personalization_Tags_Registry), Array) 15/wp-content/plugins/mailpoet/vendor/woocommerce/email-editor/src/Engine/PersonalizationTags/class-personalization-tags-registry.php(14): apply_filters(‘woocommerce_ema…’, Object(Automattic\WooCommerce\EmailEditor\Engine\PersonalizationTags\Personalization_Tags_Registry)) 16/wp-content/plugins/mailpoet/vendor/woocommerce/email-editor/src/Engine/class-email-editor.php(81): Automattic\WooCommerce\EmailEditor\Engine\PersonalizationTags\Personalization_Tags_Registry->initialize() 17/wp-content/plugins/mailpoet/vendor/woocommerce/email-editor/src/Engine/class-email-editor.php(45): Automattic\WooCommerce\EmailEditor\Engine\Email_Editor->register_personalization_tags() 18/wp-content/plugins/mailpoet/vendor/woocommerce/email-editor/src/class-bootstrap.php(40): Automattic\WooCommerce\EmailEditor\Engine\Email_Editor->initialize() 19/wp-includes/class-wp-hook.php(324): Automattic\WooCommerce\EmailEditor\Bootstrap->initialize(”) 20/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters(NULL, Array) 21/wp-includes/plugin.php(517): WP_Hook->do_action(Array) 22/wp-settings.php(727): do_action(‘init’) 23/wp-config.php(104): require_once(‘/pages/0b/e8/d0…’) 24/wp-load.php(50): require_once(‘/pages/0b/e8/d0…’) 25/wp-admin/admin.php(35): require_once(‘/pages/0b/e8/d0…’) 26 {main}

thrown

Viewing 1 replies (of 1 total)

Plugin Support Ojoma a11n
(@geraltrivia)

9 months ago
Hello there @me1xx2 ,

Thank you for reaching out to us.

Our devs actually discovered an issue with logs and are actively working on a fix. I believe this is related to the issue you are experiencing.

As a workaround, we discovered that changing the “Logging” setting to Errors only in MailPoet > Settings > Advanced should fix the issue.

Our devs are already working on a fix that should be included on our next release today Tuesday, 9th. After the update, you should no longer experience this issue, even if you have logs set to Everything.

If you’d like to clear the extra logging details caused by this issue in your database, you can remove older entries from the wp_mailpoet_log table. The SQL query below should work to delete logs older than a month.
```
DELETE FROM wp_mailpoet_log WHERE created_at < '2025-08-03 14:24:03' ORDER BY id ASC LIMIT 1000
```
Please, make sure to create a backup of your website before running this query.

I hope this is helpful.

Viewing 1 replies (of 1 total)

The topic ‘Technical issue’ is closed to new replies.