Large amount of errors recorded logged Apache Error Log – MC4WP_Queue_Job

  • Resolved Johan F00

    (@justrunlah)


    8 years, 3 months ago

    Hello,

    My Apache Error Log is flooded with hundreds of errors like the one shown below.

    (screenshot: https://i.imgur.com/brilUmp.png)

    I figured that MC4WP_Queue_Job is related to this plugin. Could you please advise how to fix this?

    WordPress database error MySQL server has gone away for query UPDATEset_optionsSEToption_value= ‘a:7132:{i:0;O:15:\\”MC4WP_Queue_Job\\”:2:{s:2:\\”id\\”;s:19:\\”1473418041.96439413\\”;s:4:\\”data\\”;a:2:{s:4:\\”type\\”;s:9:\\”subscribe\\”;s:7:\\”user_id\\”;i:11936;}}i:1;O:15:\\”MC4WP_Queue_Job\\”:2:{s:2:\\”id\\”;s:19:\\”1473418124.82741919\\”;s:4:\\”data\\”;a:2:{s:4:\\”type\\”;s:6:\\”handle\\”;s:7:\\”user_id\\”;i:11936;}}i:2;O:15:\\”MC4WP_Queue_Job\\”:2:{s:2:\\”id\\”;s:19:\\”1473418176.13963981\\”;s:4:\\”data\\”;a:2:{s:4:\\”type\\”;s:6:\\”handle\\”;s:7:\\”user_id\\”;i:11936;}}i:3;O:15:\\”MC4WP_Queue_Job\\”:2:{s:2:\\”id\\”;s:19:\\”1473418176.14219935\\”;s:4:\\”data\\”;a:2:{s:4:\\”type\\”;s:6:\\”handle\\”;s:7:\\”user_id\\”;i:11936;}}i:4;O:15:\\”MC4WP_Queue_Job\\”:2:{s:2:\\”id\\”;s:18:\\”1473418575.8797814\\”;s:4:\\”data\\”;a:2:{s:4:\\”type\\”;s:9:\\”subscribe\\”;s:7:\\”user_id\\”;i:11937;}}i:5;O:15:\\”MC4WP_Queue_Job\\”:2:{s:2:\\”id\\”;s:19:\\”1473418889.55961035\\”;s:4:\\”data\\”;a:2:{s:4:\\”type\\”;s:6:\\”handle\\”;s:7:\\”user_id\\”;i:11937;}}i:6;O:15:\\”MC4WP_Queue_Job\\”:2:{s:2:\\”id\\”;s:19:\\”1473419018.23425839\\”;s:4:\\”data\\”;a:2:{s:4:\\”type\\”;s:6:\\”handle\\”;s:7:\\”user_id\\”;i:11937;}}i:7;O:15:\\”MC4WP_Queue_Job\\”:2:{s:2:\\”id\\”;s:19:\\”1473419018.23892273\\”;s:4:\\”data\\”;a:2:{s:4:\\”type\\”;s:6:\\”handle\\”;s:7:\\”user_id\\”;i:11937;}}i:8;O:15:\\”MC4WP_Queue_Job\\”:2:{s:2:\\”id\\”;s:19:\\”1473419590.39314855\\”;s:4:\\”data\\”;a:2:{s:4:\\”type\\”;s:9:\\”subscribe\\”;s:7:\\”user_id\\”;i:11938;}}i:9;O:15:\\”MC4WP_Queue_Job\\”:2:{s:2:\\”id\\”;s:19:\\”1473419655.80263967\\”;s:4:\\”data\\”;a:2:{s:4:\\”type\\”;s:6:\\”handle\\”;s:7:\\”user_id\\”;i:11938;}}i:10;O:15:\\”MC4WP_Queue_Job\\”:2:{s:2:\\”id\\”;s:19:\\”1473419717.63545503\\”;s:4:\\”data\\”;a:2:{s:4:\\”type\\”;s:6:\\”handle\\”;s:7:\\”user_id\\”;i:11938;}}i:11;O:15:\\”MC4WP_Queue_Job\\”:2:{s:2:\\”id\\”;s:19:\\”1473419717.63867643\\”;s:4:\\”data\\”;a:2:{s:4:\\”type\\”;s:6:\\”handle\\”;s:7:\\”user_id\\”;i:11938;}}i:12;O:15:\\”MC4WP_Queue_Job\\”:2:{s:2:\\”id\\”;s:19:\\”1473422934.24737573\\”;s:4:\\”data\\”;a:2:{s:4:\\”type\\”;s:6:\\”handle\\”;s:7:\\”user_id\\”;i:11941;}}i:26;O:15:\\”MC4WP_Queue_Job\\”:2:{s:2:\\”id\\”;s:18:\\”1473429098.3583360\\”;s:4:\\”data\\”;a:2:{s:4:\\”type\\”;s:6:\\”handle\\”;s:7:\\”user_id\\”;i:11914;}}i:27;O:15:\\”MC4WP_Queue_Job\\”:2:{s:2:\\”id\\”;s:19:\\”1473429345.61888876\\”;s:4:\\”data\\”;a:2:{s:4:\\”type\\”;s:6:\\”handle\\”;s:7:\\”user_id\\”;i:9002;}}i:28;O:15:\\”MC4WP_Queue_Job\\”:2:{s:2:\\”id\\”;s:18:\\”1473431159.4319790\\”;s:4:\\”data\\”;a:2:{s:4:\\”type\\”;s:6:\\”handle\\”;s:7:\\”user_id\\”;i:8897;}}i:29;O:15:\\”MC4WP_Queue_Job\\”:2:{s:2:\\”id\\”;s:18:\\”1473431159.4352383\\”;s:4:\\”data\\”;a:2:{s:4:\\”type\\”;s:6:\\”handle\\”;s:7:\\”user_id\\”;i:8897;}}i:30;O:15:\\”MC4WP_Queue_Job\\”:2:{s:2:\\”id\\”;s:19:\\”1473431159.43975763\\”;s:4:\\”data\\”;a:2:{s:4:\\”type\\”;s:6:\\”handle\\”;s:7:\\”user_id\\”;i:8897;}}i:31;O:15:\\”MC4WP_Queue_Job\\”:2:{s:2:\\”id\\”;s:19:\\”1473431404.25481562\\”;s:4:\\”data\\”;a:2:{s:4:\\”type\\”;s:6:\\”handle\\”;s:7:\\”user_id\\”;i:11939;}}i:32;O:15:\\”MC4WP_Queue_Job\\”:2:{s:2:\\”id\\”;s:19:\\”1473431576.59991267\\”;s:4:\\”data\\”;a:2:{s:4:\\”type\\”;s:6:\\”handle\\”;s:7:\\”user_id\\”;i:11939;}}i:33;O:15:\\”MC4WP_Queue_Job\\”:2:{s:2:\\”id\\”;s:19:\\”1473431576.60262882\\”;s:4:\\”data\\”;a:2:{s:4:\\”type\\”;s:6:\\”handle\\”;s:7:\\”user_id\\”;i:11939;}}i:34;O:15:\\”MC4WP_Queue_Job\\”:2:{s:2:\\”id\\”;s:19:\\”1473433193.02625816\\”;s:4:\\”data\\”;a:2:{s:4:\\”type\\”;s:9:\\”subscribe\\”;s:7:\\”user_id\\”;i:11942;}}i:35;O:15:\\”MC4WP_Queue_Job\\”:2:{s:2:\\”id\\”;s:19:\\”1473433322.53566310\\”;s:4:\\”data\\”;a:2:{s:4:\\”type\\”;s:6:\\”handle\\”;s:7:\\”user_id\\”;i:11942;}}i:36;O:15:\\”MC4WP_Queue_Job\\”:2:{s:2:\\”id\\”;s:19:\\”1473433413.82254157\\”;s:4:\\”data\\”;a:2:{s:4:\\”type\\”;s:6:\\”handle\\”;s:7:\\”user_id\\”;i:11942;}}i:37;O:15:\\”MC4WP_Queue_Job\\”:2:{s:2:\\”id\\”;s:19:\\”1473433413.82518615\\”;s:4:\\”data\\”;a:2:{s:4:\\”type\\”;s:6:\\”handle\\”;s:7:\\”user_id\\”;i:11942;}}i:38;O:15:\\”MC4WP_Queue_Job\\”:2:{s:2:\\”id\\”;s:19:\\”1473433469.75839504\\”;s:4:\\”data\\”;a:2:{s:4:\\”type\\”;s:6:\\”handle\\”;s:7:\\”user_id\\”;i:11942;}}i:39;O:15:\\”MC4WP_Queue_Job\\”:2:{s:2:\\”id\\”;s:19:\\”1473434498.93434976\\”;s:4:\\”data\\”;a:2:{s:4:\\”type\\”;s:9:\\”subscribe\\”;s:7:\\”user_id\\”;i:11943;}}i:40;O:15:\\”MC4WP_Queue_Job\\”:2:{s:2:\\”id\\”;s:19:\\”1473434566.13789456\\”;s:4:\\”data\\”;a:2:{s:4:\\”type\\”;s:9:\\”subscribe\\”;s:7:\\”user_id\\”;i:11944;}}i:41;O:15:\\”MC4WP_Queue_Job\\”:2:{s:2:\\”id\\”;s:18:\\”1473434588.7033026\\”;s:4:\\”data\\”;a:2:{s:4:\\”type\\”;s:6:\\”handle\\”;s:7:\\”user_id\\”;i:11943;}}i:42;O:15:\\”MC4WP_Queue_Job\\”:2:{s:2:\\”id\\”;s:18:\\”1474246550.7649695\\”;s:4:\\”data\\”;a:2:{s:4:\\”type\\”;s:6:\\”handle\\”;s:7:\\”user_id\\”;i:12235;}}i:1367;O:15:\\”MC4WP_Queue_Job\\”:2:{s:2:\\”id\\”;s:19:\\”1474246550.76812079\\”;s:4:\\”data\\”;a:2:{s:4:\\”type\\”;s:6:\\”handle\\”;s:7:\\”user_id\\”;i:12235;}}i:1368;O:15:\\”MC4WP_Queue_Job\\”:2:{s:2:\\”id\\”;s:17:\\”1474247486.369419\\”;s:4:\\”data\\”;a:2:{s:4:\\”type\\”;s:6:\\”handle\\”;s:7:\\”user_id\\”;i:12233;}}i:1369;O:15:\\”MC4WP_Queue_Job\\”:2:{s:2:\\”id\\”;s:19:\\”1474247497.03387147\\”;s:4:\\”data\\”;a:2:{s:4:\\”type\\”;s:6:\\”handle\\”;s:7:\\”user_id\\”;i:1058;}}i:1370;O:15:\\”MC4WP_Queue_Job\\”:2:{s:2:\\”id\\”;s:19:\\”1474247528.44172044\\”;s:4:\\”data\\”;a:2:{s:4:\\”type\\”;s:6:\\”handle\\”;s:7:\\”user_id\\”;i:12233;}}i:1371;O:15:\\”MC4WP_Queue_Job\\”:2:{s:2:\\”id\\”;s:19:\\”1474247528.44479084\\”;s:4:\\”data\\”;a:2:

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Danny van Kooten

    (@dvankooten)

    Hi Johan,

    I apologise for the late reply but if this is still relevant, it seems that the background queue of MailChimp User Sync is never being processed. Can you clear it out by running the following MySQL query please?

    
DELETE FROM wp_options WHERE option_name = 'mc4wp_sync_queue';

    Hope that helps!

    Thread Starter Johan F00

    (@justrunlah)

    Hi Danny,

    Thanks for the reply. As this is a DELETE query, it makes me a bit nervous..

    Could you please explain what it will do and what it can possible affect if I run it?

    Regarding the errors, yes, there are still plenty of errors being logged all the time that look like the one I posted.

    Thanks!

    Plugin Contributor Lap

    (@lapzor)

    Hi,

    It will delete the cron background schedule for UserSync, nothing more (so nothing related to contact info). When all those background tasks are deleted it will just try and do a fresh sync next time.

    Anyhow, as always make a good backup before running any manual SQL queries.

    Hope that helps,

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Large amount of errors recorded logged Apache Error Log – MC4WP_Queue_Job’ is closed to new replies.