2.0.14 DB error

Hi @crosseyedcoder,

Thanks for writing to us.

Please let us know the order of events that led to this error. You can record a short video replicating the issue so that we can get more clarity.

Looking forward to hearing from you.

1) update the plugin
2) go to any admin page
3) this is in QueryMonitor https://imagizer.imageshack.com/img923/2056/UvzOTx.png

• This reply was modified 2 years ago by crosseyedcoder.

This seems to be resolved in 2.0.15

*It isn’t resolved in 2.0.15

• This reply was modified 2 years ago by crosseyedcoder. Reason: It isn't resolved in 2.0.15

Hi @crosseyedcoder,

Thanks for writing back.

I am not replicating the same on my end as shown here:https://share.getcloudapp.com/z8ulARKx.

I request you open a ticket from here:https://wpspectra.com/support/ to help you better.

Regards.
Judith.

Hi @crosseyedcoder,

It’s been a while since we heard from you, please allow me to go ahead and mark this as resolved. Feel free to open a new thread in case of any other queries.

Regards.
Judith

Apologies, I was away over Thanksgiving.

This hasn’t been resolved in 2.0.16 either.
Locally I’ve increased the ‘max_allowed_packet’ size and now run into a gateway timeout.

This is the issue. It may not be a problem until a site is at scale. We have 171k+ posts this would process.

Please add a return; at the end of the trigger_background_processing method in classes/class-uagb-loader.php

/**
 * Render background processing for block count.
 *
 * @since 2.0.14
 * @return mixed Returns the block count.
 */
public function trigger_background_processing() {

	/* Action to get total blocks count */
	if ( 'done' !== get_option( 'spectra_blocks_count_status' ) ) {

		delete_option( 'get_spectra_block_count' );

		update_option( 'spectra_blocks_count_status', 'processing' );

		$posts_ids = get_posts(
			array(
				'post_type'   => 'any',
				'numberposts' => -1,
				'post_status' => 'publish',
				'fields'      => 'ids',
			)
		);

		foreach ( $posts_ids as $post_id ) {
			$this->collect_spectra_blocks_count->push_to_queue(
				array(
					'data'        => $post_id,
					'list_blocks' => UAGB_Helper::$block_list,
				)
			);
		}

		$this->collect_spectra_blocks_count->save()->dispatch();

	}

}

Hello @crosseyedcoder ,

I would request you let us know whether this issue is still persisting even after updating to current version 2.1.1.

If it is, I would request you open a support ticket from our website so that the support team can have a better look into the issue.

Regards.

Judith.

Yes, this has been resolved after creating a ticket with support.

Hello @crosseyedcoder,

We are glad you were able to have this resolved.

I am going to mark this as resolved. Please feel free open a new thread in case of any other queries.

Regards.

Judith.

This definitely isn’t resolved, crosseyedcoder do you have a patch for the Spectra files that stopped the massive INSERT query?

@bcolflesh, I would start with adding the return to the method as I mention here and see if that does anything for you.

The response from mainline support was

UAGB_Background_Process class contain push_to_queue and save->dispatch() which have returned. I don’t think return statement is needed at this point.

While that might be technically true, it doesn’t change that its only returning to the method where it was called, and that method requires a return as well.

I hope this is helpful and will nudge Brainstorm Force @judith0 to resolve the matter.

Fwiw, I found an alternate solution — disable stats collection. Here’s how I resolved it. It doesn’t get to the root of the issue, but it does allow me to keep things running and isn’t continuing to grow the wp_options table.

https://www.ads-software.com/support/topic/huge-wp_options-table-size/#post-16378967

Hope it helps someone.

Hi @crosseyedcoder,@bcolflesh!

We have released current version 2.3.1 which has fixed this issue. Please update and let us know whether you are still experiencing these issues.

Thanks.

Hello @sageth,

It’s been a while since we heard from you. Please let us know whether this issue was resolved for you or still persisted even after the update.

Looking forward to hearing from you.