Your software
My Mautic version is: 4.0.1
My PHP version is: 7.2.24
My Database type and version is: MySQL
Your problem
My problem is: I get a 500 internal server error when I try to send a new email or even save a new segment email without sending it.
This happened after I uploaded a large email list to a new segment and tried to send the email to two large segments. Maybe it has nothing to do.
Any help is appreciated.
These errors are showing in the log:
[2021-11-15 07:19:42] mautic.NOTICE: PHP Notice - SessionHandler::gc(): ps_files_cleanup_dir: opendir(/var/lib/php/sessions) failed: Permission denied (13) - in file /home/prolificpatterns/domains/mautic.prolificpatterns.com/public_html/vendor/symfony/http-foundation/Session/Storage/Handler/StrictSessionHandler.php - at line 106 {“maxlifetime”:1440}
[2021-11-15 11:20:04] mautic.NOTICE: PHP Notice - SessionHandler::gc(): ps_files_cleanup_dir: opendir(/var/lib/php/sessions) failed: Permission denied (13) - in file /home/prolificpatterns/domains/mautic.prolificpatterns.com/public_html/vendor/symfony/http-foundation/Session/Storage/Handler/StrictSessionHandler.php - at line 106 {“maxlifetime”:1440}
[2021-11-15 12:14:27] mautic.NOTICE: PHP Notice - SessionHandler::gc(): ps_files_cleanup_dir: opendir(/var/lib/php/sessions) failed: Permission denied (13) - in file /home/prolificpatterns/domains/mautic.prolificpatterns.com/public_html/vendor/symfony/http-foundation/Session/Storage/Handler/StrictSessionHandler.php - at line 106 {“maxlifetime”:1440}
[2021-11-15 16:14:18] mautic.ERROR: PHP Error: Maximum execution time of 360 seconds exceeded - in file /home/prolificpatterns/domains/mautic.prolificpatterns.com/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php - at line 330
[2021-11-15 16:14:18] mautic.ERROR: Symfony\Component\Debug\Exception\FatalErrorException: Error: Maximum execution time of 360 seconds exceeded - in file /home/prolificpatterns/domains/mautic.prolificpatterns.com/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php - at line 330
[2021-11-15 18:10:59] mautic.NOTICE: PHP Notice - Undefined index: ct - in file /home/prolificpatterns/domains/mautic.prolificpatterns.com/public_html/app/bundles/PageBundle/Controller/PublicController.php - at line 456 {“redirectId”:“d48de8d95dc91b17f22f8b584”,“logger”:"[object] (Symfony\Bridge\Monolog\Logger: {})",“redirectModel”:"[object] (Mautic\PageBundle\Model\RedirectModel: {})",“redirect”:"[object] (Mautic\PageBundle\Entity\Redirect: Mautic\PageBundle\Entity\Redirect with ID #12)",“url”:“https://bit.ly/3GsL3QF","query”:}
[2021-11-15 19:49:40] mautic.ERROR: Invalid clickthrough value: Yjo4OntmOjk6ImZiaGVkZiI7Yjo1Ont2OjM7Zjo4OiJmemJ2eSI7djo0O3Y6NDI7fWY6ODoiZnpidnkiO3Y6NDI7Zjo3OiJmZ2JnIjtmOjU1OiI5NDI1YzIyZWM3ZGQ3NjkwODAzMTc2IjtmOjc6InlmYmUiO2Y6ODoiMTUwMzQiO2Y6MDoiZHViYWFmeSI7Yjo0OntmOjg6ImZ6YnZ5Ijt2OjQyO319 {“exception”:"[object] (Mautic\CoreBundle\Exception\InvalidDecodedStringException(code: 0): The string b:8:{f:9:“fbhedf”;b:5:{v:3;f:8:“fzbvy”;v:4;v:42;}f:8:“fzbvy”;v:42;f:7:“fgbg”;f:55:“9425c22ec7dd7690803176”;f:7:“yfbe”;f:8:“15034”;f:0:“dubaafy”;b:4:{f:8:“fzbvy”;v:42;}} is not a serialized array at /home/prolificpatterns/domains/mautic.prolificpatterns.com/public_html/app/bundles/CoreBundle/Helper/ClickthroughHelper.php:46)"}
[2021-11-15 19:53:02] mautic.NOTICE: PHP Notice - Undefined index: ct - in file /home/prolificpatterns/domains/mautic.prolificpatterns.com/public_html/app/bundles/PageBundle/Controller/PublicController.php - at line 456 {“redirectId”:“762151a500cb42feb451181ef”,“logger”:"[object] (Symfony\Bridge\Monolog\Logger: {})",“redirectModel”:"[object] (Mautic\PageBundle\Model\RedirectModel: {})",“redirect”:"[object] (Mautic\PageBundle\Entity\Redirect: Mautic\PageBundle\Entity\Redirect with ID #15)",“url”:“https://bit.ly/3F9DJrE","query”:}
[2021-11-15 19:53:06] mautic.ERROR: Invalid clickthrough value: Yjo4OntmOjk6ImZiaGVkZiI7Yjo1Ont2OjM7Zjo4OiJmemJ2eSI7djo0O3Y6NDI7fWY6ODoiZnpidnkiO3Y6NDI7Zjo3OiJmZ2JnIjtmOjU1OiI5NDI1Y2IyOTRmMTFmMDAyMzExMjMxIjtmOjc6InlmYmUiO2Y6ODoiMTcxNzIiO2Y6MDoiZHViYWFmeSI7Yjo0OntmOjg6ImZ6YnZ5Ijt2OjQyO319 {“exception”:"[object] (Mautic\CoreBundle\Exception\InvalidDecodedStringException(code: 0): The string b:8:{f:9:“fbhedf”;b:5:{v:3;f:8:“fzbvy”;v:4;v:42;}f:8:“fzbvy”;v:42;f:7:“fgbg”;f:55:“9425cb294f11f002311231”;f:7:“yfbe”;f:8:“17172”;f:0:“dubaafy”;b:4:{f:8:“fzbvy”;v:42;}} is not a serialized array at /home/prolificpatterns/domains/mautic.prolificpatterns.com/public_html/app/bundles/CoreBundle/Helper/ClickthroughHelper.php:46)"}
[2021-11-15 19:53:13] mautic.NOTICE: PHP Notice - Undefined index: ct - in file /home/prolificpatterns/domains/mautic.prolificpatterns.com/public_html/app/bundles/PageBundle/Controller/PublicController.php - at line 456 {“redirectId”:“762151a500cb42feb451181ef”,“logger”:"[object] (Symfony\Bridge\Monolog\Logger: {})",“redirectModel”:"[object] (Mautic\PageBundle\Model\RedirectModel: {})",“redirect”:"[object] (Mautic\PageBundle\Entity\Redirect: Mautic\PageBundle\Entity\Redirect with ID #15)",“url”:“https://bit.ly/3F9DJrE","query”:}
[2021-11-15 19:53:16] mautic.NOTICE: PHP Notice - Undefined index: ct - in file /home/prolificpatterns/domains/mautic.prolificpatterns.com/public_html/app/bundles/PageBundle/Controller/PublicController.php - at line 456 {“redirectId”:“762151a500cb42feb451181ef”,“logger”:"[object] (Symfony\Bridge\Monolog\Logger: {})",“redirectModel”:"[object] (Mautic\PageBundle\Model\RedirectModel: {})",“redirect”:"[object] (Mautic\PageBundle\Entity\Redirect: Mautic\PageBundle\Entity\Redirect with ID #15)",“url”:“https://bit.ly/3F9DJrE","query”:}
[2021-11-15 20:08:13] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: “An exception occurred while executing ‘INSERT INTO email_stats (email_address, date_sent, is_read, is_failed, viewed_in_browser, date_read, tracking_hash, retry_count, source, source_id, tokens, open_count, last_opened, open_details, email_id, lead_id, list_id, ip_id, copy_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [“Okwuelumchinyere@yahoo.com”, “2021-11-15 20:08:13”, 0, 0, 0, null, “6192be2d6d815821227397”, 0, “email”, 19, “a:14:{s:36:”{dynamiccontent=“Dynamic Content 1”}”;s:23:“Default Dynamic Content”;s:18:"{unsubscribe_text}";s:161:“Don’t want any more patterns, tips or crazy special deals?Unsubscribe</a>.";s:17:"{unsubscribe_url}";s:76:“https://mautic.prolificpatterns.com/email/unsubscribe/6192be2d6d815821227397”;s:14:"{webview_text}";s:130:"[Having trouble reading this email? Click here.</a>”;s:13:"{webview_url}";s:69:“https://mautic.prolificpatterns.com/email/view/6192be2d6d815821227397";s:11:"{signature}";s:31:"Best regards, Prolific Patterns”;s:9:"{subject}";s:9:“Attention”;s:18:"{ownerfield=email}";s:25:"info@prolificpatterns.com";s:22:"{ownerfield=firstname}";s:8:“Prolific”;s:21:"{ownerfield=lastname}";s:8:“Patterns”;s:21:"{ownerfield=position}";s:0:"";s:22:"{ownerfield=signature}";s:0:"";s:37:"{trackable=762151a500cb42feb451181ef}";s:292:“Fat Quarter(ish) Clique – TheFabricClique, 0, null, “a:0:{}”, 19, “92662”, 22, null, “7393205ae9339197578162367f98d475”]: SQLSTATE[HY000]: General error: 1114 The table ‘email_stats’ is full” at /home/prolificpatterns/domains/mautic.prolificpatterns.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 128 {“exception”:"[object] (Doctrine\DBAL\Exception\DriverException(code: 0): An exception occurred while executing ‘INSERT INTO email_stats (email_address, date_sent, is_read, is_failed, viewed_in_browser, date_read, tracking_hash, retry_count, source, source_id, tokens, open_count, last_opened, open_details, email_id, lead_id, list_id, ip_id, copy_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params “Okwuelumchinyere@yahoo.com”, “2021-11-15 20:08:13”, 0, 0, 0, null, “6192be2d6d815821227397”, 0, “email”, 19, “a:14:{s:36:\”{dynamiccontent=\“Dynamic Content 1\”}\";s:23:\“Default Dynamic Content\”;s:18:\"{unsubscribe_text}\";s:161:\"Don’t want any more patterns, tips or crazy special deals?Unsubscribe<\/a>.\";s:17:\"{unsubscribe_url}\";s:76:\“https:\/\/mautic.prolificpatterns.com\/email\/unsubscribe\/6192be2d6d815821227397\”;s:14:\"{webview_text}\";s:130:\"[Having trouble reading this email? Click here.<\/a>\";s:13:\"{webview_url}\";s:69:\“https:\/\/mautic.prolificpatterns.com\/email\/view\/6192be2d6d815821227397\”;s:11:\"{signature}\";s:31:\“Best regards, Prolific Patterns\”;s:9:\"{subject}\";s:9:\“Attention\”;s:18:\"{ownerfield=email}\";s:25:\“info@prolificpatterns.com\”;s:22:\"{ownerfield=firstname}\";s:8:\“Prolific\”;s:21:\"{ownerfield=lastname}\";s:8:\“Patterns\”;s:21:\"{ownerfield=position}\";s:0:\"\";s:22:\"{ownerfield=signature}\";s:0:\"\";s:37:\"{trackable=762151a500cb42feb451181ef}\";s:292:\“https:\/\/mautic.prolificpatterns.com\/r\/762151a500cb42feb451181ef?ct=YTo1OntzOjY6InNvdXJjZSI7YToyOntpOjA7czo1OiJlbWFpbCI7aToxO2k6MTk7fXM6NToiZW1haWwiO2k6MTk7czo0OiJzdGF0IjtzOjIyOiI2MTkyYmUyZDZkODE1ODIxMjI3Mzk3IjtzOjQ6ImxlYWQiO3M6NToiOTI2NjIiO3M6NzoiY2hhbm5lbCI7YToxOntzOjU6ImVtYWlsIjtpOjE5O319&\”;s:16:\"{tracking_pixel}\";s:68:\“https:\/\/mautic.prolificpatterns.com\/email\/6192be2d6d815821227397.gif\”;}", 0, null, “a:0:{}”, 19, “92662”, 22, null, “7393205ae9339197578162367f98d475”]:\n\nSQLSTATE[HY000]: General error: 1114 The table ‘email_stats’ is full at /home/prolificpatterns/domains/mautic.prolificpatterns.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:128, Doctrine\DBAL\Driver\PDO\Exception(code: HY000): SQLSTATE[HY000]: General error: 1114 The table ‘email_stats’ is full at /home/prolificpatterns/domains/mautic.prolificpatterns.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: HY000): SQLSTATE[HY000]: General error: 1114 The table ‘email_stats’ is full at /home/prolificpatterns/domains/mautic.prolificpatterns.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:112)"} ](https://%22https//////mautic.prolificpatterns.com///email///view///6192be2d6d815821227397///%22)
[[2021-11-15 20:14:39] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: “An exception occurred while executing ‘INSERT INTO email_stats (email_address, date_sent, is_read, is_failed, viewed_in_browser, date_read, tracking_hash, retry_count, source, source_id, tokens, open_count, last_opened, open_details, email_id, lead_id, list_id, ip_id, copy_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params “olifant12@icloud.com”, “2021-11-15 20:14:39”, 0, 0, 0, null, “6192bfaf37e18994455394”, 0, “email”, 19, “a:14:{s:36:”{dynamiccontent=“Dynamic Content 1”}";s:23:“Default Dynamic Content”;s:18:"{unsubscribe_text}";s:161:"Don’t want any more patterns, tips or crazy special deals?Unsubscribe</a>.";s:17:"{unsubscribe_url}";s:76:“https://mautic.prolificpatterns.com/email/unsubscribe/6192bfaf37e18994455394”;s:14:"{webview_text}";s:130:"[Having trouble reading this email? Click here.</a>”;s:13:"{webview_url}";s:69:“https://mautic.prolificpatterns.com/email/view/6192bfaf37e18994455394";s:11:"{signature}";s:31:"Best regards, Prolific Patterns”;s:9:"{subject}";s:9:“Attention”;s:18:"{ownerfield=email}";s:25:"info@prolificpatterns.com";s:22:"{ownerfield=firstname}";s:8:“Prolific”;s:21:"{ownerfield=lastname}";s:8:“Patterns”;s:21:"{ownerfield=position}";s:0:"";s:22:"{ownerfield=signature}";s:0:"";s:37:"{trackable=762151a500cb42feb451181ef}";s:292:“Fat Quarter(ish) Clique – TheFabricClique, 0, null, “a:0:{}”, 19, “94803”, 22, null, “7393205ae9339197578162367f98d475”]: SQLSTATE[HY000]: General error: 1114 The table ‘email_stats’ is full” at /home/prolificpatterns/domains/mautic.prolificpatterns.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 128 {“exception”:"[object] (Doctrine\DBAL\Exception\DriverException(code: 0): An exception occurred while executing ‘INSERT INTO email_stats (email_address, date_sent, is_read, is_failed, viewed_in_browser, date_read, tracking_hash, retry_count, source, source_id, tokens, open_count, last_opened, open_details, email_id, lead_id, list_id, ip_id, copy_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params “olifant12@icloud.com”, “2021-11-15 20:14:39”, 0, 0, 0, null, “6192bfaf37e18994455394”, 0, “email”, 19, “a:14:{s:36:\”{dynamiccontent=\“Dynamic Content 1\”}\";s:23:\“Default Dynamic Content\”;s:18:\"{unsubscribe_text}\";s:161:\"Don’t want any more patterns, tips or crazy special deals?Unsubscribe<\/a>.\";s:17:\"{unsubscribe_url}\";s:76:\“https:\/\/mautic.prolificpatterns.com\/email\/unsubscribe\/6192bfaf37e18994455394\”;s:14:\"{webview_text}\";s:130:\"[Having trouble reading this email? Click here.<\/a>\";s:13:\"{webview_url}\";s:69:\“https:\/\/mautic.prolificpatterns.com\/email\/view\/6192bfaf37e18994455394\”;s:11:\"{signature}\";s:31:\“Best regards, Prolific Patterns\”;s:9:\"{subject}\";s:9:\“Attention\”;s:18:\"{ownerfield=email}\";s:25:\“info@prolificpatterns.com\”;s:22:\"{ownerfield=firstname}\";s:8:\“Prolific\”;s:21:\"{ownerfield=lastname}\";s:8:\“Patterns\”;s:21:\"{ownerfield=position}\";s:0:\"\";s:22:\"{ownerfield=signature}\";s:0:\"\";s:37:\"{trackable=762151a500cb42feb451181ef}\";s:292:\“https:\/\/mautic.prolificpatterns.com\/r\/762151a500cb42feb451181ef?ct=YTo1OntzOjY6InNvdXJjZSI7YToyOntpOjA7czo1OiJlbWFpbCI7aToxO2k6MTk7fXM6NToiZW1haWwiO2k6MTk7czo0OiJzdGF0IjtzOjIyOiI2MTkyYmZhZjM3ZTE4OTk0NDU1Mzk0IjtzOjQ6ImxlYWQiO3M6NToiOTQ4MDMiO3M6NzoiY2hhbm5lbCI7YToxOntzOjU6ImVtYWlsIjtpOjE5O319&\”;s:16:\"{tracking_pixel}\";s:68:\“https:\/\/mautic.prolificpatterns.com\/email\/6192bfaf37e18994455394.gif\”;}", 0, null, “a:0:{}”, 19, “94803”, 22, null, “7393205ae9339197578162367f98d475”]:\n\nSQLSTATE[HY000]: General error: 1114 The table ‘email_stats’ is full at /home/prolificpatterns/domains/mautic.prolificpatterns.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:128, Doctrine\DBAL\Driver\PDO\Exception(code: HY000): SQLSTATE[HY000]: General error: 1114 The table ‘email_stats’ is full at /home/prolificpatterns/domains/mautic.prolificpatterns.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: HY000): SQLSTATE[HY000]: General error: 1114 The table ‘email_stats’ is full at /home/prolificpatterns/domains/mautic.prolificpatterns.com/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:112)"} ](https://%22https//////mautic.prolificpatterns.com///email///view///6192bfaf37e18994455394///%22)
[[2021-11-15 20:15:43] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: "An exception occurred while executing ‘INSERT INTO emails (is_published, date_added, created_by, created_by_user, date_modified, modified_by, modified_by_user, checked_out, checked_out_by, checked_out_by_user, name, description, subject, from_address, from_name, reply_to_address, bcc_address, use_owner_as_mailer, template, content, utm_tags, plain_text, custom_html, email_type, publish_up, publish_down, read_count, sent_count, variant_sent_count, variant_read_count, revision, lang, variant_settings, variant_start_date, dynamic_content, headers, public_preview, category_id, translation_parent_id, variant_parent_id, unsubscribeform_id, preference_center_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params 0, “2021-11-15 20:15:43”, 1, “Prolific Patterns”, null, null, null, null, null, null, “FatQuarters 1 - Sewing - Duplicates Removed -3 - GEO - Filtered - 50rowsV2 - 35000 to 50042 and v3 1 to 35000”, null, “Attention”, null, null, null, null, 0, “blank”, “a:0:{}”, “a:4:{s:9:“utmSource”;N;s:9:“utmMedium”;N;s:11:“utmCampaign”;N;s:10:“utmContent”;N;}”, null, "
Steps I have tried to fix the problem: