Cron Job server load

  • Resolved popandbob

    (@popandbob)


    1 year, 7 months ago

    Hi, after updating to wordpress 8.0.1 I was having major server load issues and I found in the action scheduler that mailpoet had a task running every two minutes.
    Is there any way to increase the repeat time for this task? Or what does this task even do running every 2 minutes? It seems to be hammering my server with load after the update despite having a small database and not many subscribers. Its so much load the website errors out with service unavailable or can’t connect to database.

    After putting my site in under attack mode (via cloudflare) the task stalls out and stops running because it blocks access to something it needs (the mailpoet status page confirms this) There is no traffic spikes or request spikes via cloudflare so its not an actual attack as far as I can tell. As soon as I deactivate under attack mode the task starts up again and server load spikes. I didn’t want to cancel the task because I don’t know how to restart it afterwards.

    This has happened on two separate websites running on two separate servers.
    Any other thoughts/suggestions I can try?

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Bruna a11n

    (@bruberries)

    Hi @popandbob,

    It seems to be hammering my server with load after the update despite having a small database and not many subscribers. Its so much load the website errors out with service unavailable or can’t connect to database.

    If you’re facing issues with the current cron option taking too much of your CPU resources and it may be slowing down your website, we recommend switching the cron option to the “Linux Cron”. You’ll find this option via?MailPoet > Settings > Advanced > Newsletter Task Scheduler > choose “Linux Cron”:
    https://kb.mailpoet.com/article/257-setting-the-server-side-cron-linux-cron

    Most hosts provide a cron interface in their control panel and cPanel also includes an option to set the cron. Please reach out to your host if you need assistance with configuring the cron for your site, as each host is different.

    I hope it helps!

    Thread Starter popandbob

    (@popandbob)

    Thanks @bruberries

    I investigated further along this path and it turns out there was some sort of conflict with jetpack after the update… if I disabled either mailpoet or jetpack the website was fine – as soon as both were enabled it was max cpu and nothing would load. Naturally Jetpack lost but….

    Now after the latest mailpoet update I have a new error that has disabled the plugin. 
    

An error of tve E ERROR was caused in line 59 of the file /var/www/html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Dri ver/AbstractMySQLDriver. php . Error message:

Uncaught PDOException: SQLSTATE[42522]:

Column not found: 1054 Unknown column

'tO.wp_post_id' in 'field list' in /var/www/html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dal/lib/Doctrine/DBAL/Dri

ver/PDOStatement.php:59 Stack trace: #0 /var/www/html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Dri

ver/PDOStatement.php (59): PDOStatement-

?execute () #1 /var/www/html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Con nection.php (495) :

MailPoetVendor\ Doctrine\ DBAL\Driver\ PD0State ment->execute ( ) #2 /var/www/html/w-content/plugins/mailpoet/vendor-prefixed/doctrine/orm/lib/Doctrine/ORM/Persi sters/Entity/BasicEntityPersister.php(375):

MailPoetVendor\Doctrine\DBAL\Connection-

?executeQuery #3 /var/www/html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/orm/lib/Doctrine/ORM/Persi sters/Entity/BasicEntityPersister. php (386):

MailPoetVendor\Doctrine\ORM\Persisters\Entit

y\BasicEntityPersister->load () #4 /var/www/html/wp-content/plugins/mailpoet/vendo
    Plugin Author Bruna a11n

    (@bruberries)

    Hi @popandbob,

    We’ve seen a couple of similar reports and the team is already working on a fix to prevent this from happening.

    In your case, we suggest deactivating and reactivating the plugin in the WordPress > Plugins page (yes, the good old “turn it off and on again”!).

    Let us know if it does the trick!

    Plugin Support Gui A. a11n

    (@guicmazeredo)

    We haven’t heard back from you in a while, so I’m going to mark this as resolved – if you have any further questions, you can start a new thread.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Cron Job server load’ is closed to new replies.