Plugin Timeout When Bulk Updating

  • Hey there, so The plugin is basically timing out when I choose the bulk update option. I read another post with a similar problem but it was market resolved and the dude had like 10,000-20,000 posts, big range there lol. Anyways I have in total 1,173 posts, and I’m still getting a time out issue when trying to bulk update posts. Is there any fix for this or way I can stop WordPress from timing out?

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter kesenwang

    (@kesenwang)

    Here’s the error Log from WP Engine just for reference I dunno if it helps:

    [Sat Sep 15 14:28:02.169994 2018] [:error] [pid 17813] [client 220.130.220.237:19287] PHP Warning: mysqli_query(): MySQL server has gone away in /nas/content/live/kesen/wp-includes/wp-db.php on line 1924, referer: https://willywangstory.com/wp-admin/admin.php?page=amazon_ai_polly
    [Sat Sep 15 14:28:02.170088 2018] [:error] [pid 17813] [client 220.130.220.237:19287] PHP Warning: mysqli_query(): Error reading result set’s header in /nas/content/live/kesen/wp-includes/wp-db.php on line 1924, referer: https://willywangstory.com/wp-admin/admin.php?page=amazon_ai_polly
    [Sat Sep 15 14:38:02.787774 2018] [:error] [pid 4355] [client 220.130.220.237:23593] PHP Warning: mysqli_query(): MySQL server has gone away in /nas/content/live/kesen/wp-includes/wp-db.php on line 1924, referer: https://willywangstory.com/wp-admin/admin.php?page=amazon_ai_polly
    [Sat Sep 15 14:38:02.787862 2018] [:error] [pid 4355] [client 220.130.220.237:23593] PHP Warning: mysqli_query(): Error reading result set’s header in /nas/content/live/kesen/wp-includes/wp-db.php on line 1924, referer: https://willywangstory.com/wp-admin/admin.php?page=amazon_ai_polly
    [Sat Sep 15 14:45:02.891826 2018] [:error] [pid 11811] [client 137.74.21.218:26575] PHP Warning: mysqli_query(): MySQL server has gone away in /nas/content/live/kesen/wp-includes/wp-db.php on line 1924, referer: https://willywangstory.com/wp-admin/admin.php?page=amazon_ai_polly
    [Sat Sep 15 14:45:02.891920 2018] [:error] [pid 11811] [client 137.74.21.218:26575] PHP Warning: mysqli_query(): Error reading result set’s header in /nas/content/live/kesen/wp-includes/wp-db.php on line 1924, referer: https://willywangstory.com/wp-admin/admin.php?page=amazon_ai_polly

    I’m getting the same issue and error log statements as kensenwang from WPEngine. On top of those errors, I also get one additional error:

    [client 97.93.147.172:40428] WordPress database error MySQL server has gone away for query SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_postmeta ON (wp_posts.ID = wp_postmeta.post_id AND wp_postmeta.meta_key = ‘amazon_polly_audio_link_location’ ) LEFT JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) LEFT JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id ) LEFT JOIN wp_postmeta AS mt3 ON ( wp_posts.ID = mt3.post_id ) WHERE 1=1 AND ( \n wp_postmeta.post_id IS NULL \n OR \n ( mt1.meta_key = ‘amazon_polly_voice_id’ AND mt1.meta_value != ‘Matthew’ ) \n OR \n ( mt2.meta_key = ‘amazon_polly_sample_rate’ AND mt2.meta_value != ‘22050’ ) \n OR \n ( mt3.meta_key = ‘amazon_polly_audio_location’ AND mt3.meta_value != ‘s3’ )\n) AND wp_posts.post_type = ‘read’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘acf-disabled’ OR wp_posts.post_status = ‘future’ OR wp_posts.post_status = ‘draft’ OR wp_posts.post_status = ‘pending’ OR wp_posts.post_status = ‘private’) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1 /* From [**********.com/wp-admin/admin-ajax.php] in [/nas/content/live/cf2018/wp-content/plugins/amazon-polly/admin/AmazonAI-PollyService.php:487] */ made by do_action(‘wp_ajax_polly_transcribe’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, AmazonAI_PollyService->ajax_bulk_synthesize, WP_Query->__construct, WP_Query->query, WP_Query->get_posts, referer: https://***********.com/wp-admin/admin.php?page=amazon_ai_polly

    Commenting to upvote. We’re also seeing 502 Gateway errors on WPEngine during Bulk Update Ajax operations. We have about 2000 posts on each of our sites.

    It looks like the OR clause is causing the query to timeout. I was able to generate all the audio files by commenting out the voice, sample rate and location

    Lines 461-486:

    $args     = array(
				'posts_per_page' => $batch_size,
				'post_type'      => $post_types_supported,
				'meta_query'     => array(
					// 'relation' => 'OR',
					array(
						'key'     => 'amazon_polly_audio_link_location',
						'compare' => 'NOT EXISTS',
					),
					// array(
					// 	'key'     => 'amazon_polly_voice_id',
					// 	'value'   => $amazon_polly_voice_id,
					// 	'compare' => '!=',
					// ),
					// array(
					// 	'key'     => 'amazon_polly_sample_rate',
					// 	'value'   => $amazon_polly_sample_rate,
					// 	'compare' => '!=',
					// ),
					// array(
					// 	'key'     => 'amazon_polly_audio_location',
					// 	'value'   => $amazon_polly_audio_location,
					// 	'compare' => '!=',
					// ),
				),
			);

    Obviously, this isn’t ideal b/c we do want to check if there’s a change in voice, sample rate or location…

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Plugin Timeout When Bulk Updating’ is closed to new replies.