Rafael Fischmann

@threadi We’ve been looking into those for the past couple of months, trying to figure out the cause of the issue, but although there were a few ModSecurity logs especially, in the end they weren’t related at all. We even completely disabled ModSecurity and Cloudflare for testing once, and the behavior didn’t change.

I really think it’s not a server-side issue, otherwise it wouldn’t work fine via Safari.

Just pasting new logs from today that might maybe help identify the issue:

[09-Aug-2024 11:17:32 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query insert into wpftsi_tp
						(q_id, did, pow, res, ts) 
					SELECT
						t1.q_id,
						tbase2.id,
						0,
						0,
						NOW()
					FROM (
    					SELECT
							trel.q_id,
        					trel.did,
        					tindex.tid,
        					tindex.tsrc,
        					tbase.token
    					FROM wpftsi_tp trel
    					STRAIGHT_JOIN wpftsi_docs tbase
        					ON (trel.did = tbase.id) AND (trel.q_id = "149114")
    					STRAIGHT_JOIN wpftsi_index AS tindex
        					ON tindex.id = tbase.index_id
					) t1
					STRAIGHT_JOIN wpftsi_doctree dt
    					ON t1.tid = dt.c_tid AND t1.tsrc = dt.c_tsrc AND t1.token = dt.c_token
					STRAIGHT_JOIN wpftsi_index tindex2
    					ON tindex2.tid = dt.p_tid AND tindex2.tsrc = dt.p_tsrc
					STRAIGHT_JOIN wpftsi_docs AS tbase2
    					ON tbase2.index_id = tindex2.id AND dt.p_token = tbase2.token
					where
						tbase2.id not in ((select did from wpftsi_tp where q_id = "149114"))
				 made by require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, do_action_ref_array('pre_get_posts'), WP_Hook->do_action, WP_Hook->apply_filters, WPFTS_Search->index_pre_get_posts, WPFTS_Search->sql_parts, WPFTS_DB->query
[09-Aug-2024 11:17:35 UTC] WordPress database error Duplicate entry '1028694-wp_posts' for key 'tid_tsrc_unique' for query insert into wpftsi_index (tid, tsrc, tdt, build_time, update_dt, force_rebuild, locked_dt) values ("1028694", "wp_posts", "1970-01-01 00:00:00", 0, "1970-01-01 00:00:00", 1, "1970-01-01 00:00:00") made by bulk_edit_posts, wp_update_post, wp_insert_post, wp_after_insert_post, do_action('wp_after_insert_post'), WP_Hook->do_action, WP_Hook->apply_filters, wp_save_post_revision_on_insert, wp_save_post_revision, _wp_put_post_revision, wp_insert_post, do_action('save_post'), WP_Hook->do_action, WP_Hook->apply_filters, wpfts_save_post_action, wpfts_post_reindex, WPFTS_Core->MakePostsSync, WPFTS_DB->query

Just so you know, @epsiloncool, these are still showing up after the latest update:

[03-Aug-2024 15:47:36 UTC] WordPress database error Lock wait timeout exceeded; try restarting transaction for query UPDATE wp_options SET option_value = '2024-08-04 12:46:46' WHERE option_name = 'wpfts_detector2_message_expdt' made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), include_once('/plugins/fulltext-search/fulltext-search.php'), WPFTS_Core->Init, WPFTS_Core->FeatureDetector, WPFTS_Core->set_option, update_option

[04-Aug-2024 09:12:04 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query insert into wpftsi_tp
						(q_id, did, pow, res, ts) 
					SELECT
						t1.q_id,
						tbase2.id,
						0,
						0,
						NOW()
					FROM (
    					SELECT
							trel.q_id,
        					trel.did,
        					tindex.tid,
        					tindex.tsrc,
        					tbase.token
    					FROM wpftsi_tp trel
    					STRAIGHT_JOIN wpftsi_docs tbase
        					ON (trel.did = tbase.id) AND (trel.q_id = "140810")
    					STRAIGHT_JOIN wpftsi_index AS tindex
        					ON tindex.id = tbase.index_id
					) t1
					STRAIGHT_JOIN wpftsi_doctree dt
    					ON t1.tid = dt.c_tid AND t1.tsrc = dt.c_tsrc AND t1.token = dt.c_token
					STRAIGHT_JOIN wpftsi_index tindex2
    					ON tindex2.tid = dt.p_tid AND tindex2.tsrc = dt.p_tsrc
					STRAIGHT_JOIN wpftsi_docs AS tbase2
    					ON tbase2.index_id = tindex2.id AND dt.p_token = tbase2.token
					where
						tbase2.id not in ((select did from wpftsi_tp where q_id = "140810"))
				 made by require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, do_action_ref_array('pre_get_posts'), WP_Hook->do_action, WP_Hook->apply_filters, WPFTS_Search->index_pre_get_posts, WPFTS_Search->sql_parts, WPFTS_DB->query

Hi @epsiloncool,

Just looked at my error logs again and found a few new, different entries:

[29-Jul-2024 16:26:01 UTC] WordPress database error Lock wait timeout exceeded; try restarting transaction for query UPDATE wp_options SET option_value = '2024-07-30 13:25:11' WHERE option_name = 'wpfts_detector2_message_expdt' made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), include_once('/plugins/fulltext-search/fulltext-search.php'), WPFTS_Core->Init, WPFTS_Core->FeatureDetector, WPFTS_Core->set_option, update_option

And:

[29-Jul-2024 17:44:18 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query insert into wpftsi_tp
						(q_id, did, pow, res, ts) 
					SELECT
						t1.q_id,
						tbase2.id,
						0,
						0,
						NOW()
					FROM (
    					SELECT
							trel.q_id,
        					trel.did,
        					tindex.tid,
        					tindex.tsrc,
        					tbase.token
    					FROM wpftsi_tp trel
    					STRAIGHT_JOIN wpftsi_docs tbase
        					ON (trel.did = tbase.id) AND (trel.q_id = "130483")
    					STRAIGHT_JOIN wpftsi_index AS tindex
        					ON tindex.id = tbase.index_id
					) t1
					STRAIGHT_JOIN wpftsi_doctree dt
    					ON t1.tid = dt.c_tid AND t1.tsrc = dt.c_tsrc AND t1.token = dt.c_token
					STRAIGHT_JOIN wpftsi_index tindex2
    					ON tindex2.tid = dt.p_tid AND tindex2.tsrc = dt.p_tsrc
					STRAIGHT_JOIN wpftsi_docs AS tbase2
    					ON tbase2.index_id = tindex2.id AND dt.p_token = tbase2.token
					where
						tbase2.id not in ((select did from wpftsi_tp where q_id = "130483"))
				 made by require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, do_action_ref_array('pre_get_posts'), WP_Hook->do_action, WP_Hook->apply_filters, WPFTS_Search->index_pre_get_posts, WPFTS_Search->sql_parts, WPFTS_DB->query
[29-Jul-2024 17:55:04 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query insert into wpftsi_tp
						(q_id, did, pow, res, ts) 
					SELECT
						t1.q_id,
						tbase2.id,
						0,
						0,
						NOW()
					FROM (
    					SELECT
							trel.q_id,
        					trel.did,
        					tindex.tid,
        					tindex.tsrc,
        					tbase.token
    					FROM wpftsi_tp trel
    					STRAIGHT_JOIN wpftsi_docs tbase
        					ON (trel.did = tbase.id) AND (trel.q_id = "130496")
    					STRAIGHT_JOIN wpftsi_index AS tindex
        					ON tindex.id = tbase.index_id
					) t1
					STRAIGHT_JOIN wpftsi_doctree dt
    					ON t1.tid = dt.c_tid AND t1.tsrc = dt.c_tsrc AND t1.token = dt.c_token
					STRAIGHT_JOIN wpftsi_index tindex2
    					ON tindex2.tid = dt.p_tid AND tindex2.tsrc = dt.p_tsrc
					STRAIGHT_JOIN wpftsi_docs AS tbase2
    					ON tbase2.index_id = tindex2.id AND dt.p_token = tbase2.token
					where
						tbase2.id not in ((select did from wpftsi_tp where q_id = "130496"))
				 made by require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, do_action_ref_array('pre_get_posts'), WP_Hook->do_action, WP_Hook->apply_filters, WPFTS_Search->index_pre_get_posts, WPFTS_Search->sql_parts, WPFTS_DB->query
[29-Jul-2024 17:59:03 UTC] WordPress database error Deadlock found when trying to get lock; try restarting transaction for query insert into wpftsi_tp
						(q_id, did, pow, res, ts) 
					SELECT
						t1.q_id,
						tbase2.id,
						0,
						0,
						NOW()
					FROM (
    					SELECT
							trel.q_id,
        					trel.did,
        					tindex.tid,
        					tindex.tsrc,
        					tbase.token
    					FROM wpftsi_tp trel
    					STRAIGHT_JOIN wpftsi_docs tbase
        					ON (trel.did = tbase.id) AND (trel.q_id = "130500")
    					STRAIGHT_JOIN wpftsi_index AS tindex
        					ON tindex.id = tbase.index_id
					) t1
					STRAIGHT_JOIN wpftsi_doctree dt
    					ON t1.tid = dt.c_tid AND t1.tsrc = dt.c_tsrc AND t1.token = dt.c_token
					STRAIGHT_JOIN wpftsi_index tindex2
    					ON tindex2.tid = dt.p_tid AND tindex2.tsrc = dt.p_tsrc
					STRAIGHT_JOIN wpftsi_docs AS tbase2
    					ON tbase2.index_id = tindex2.id AND dt.p_token = tbase2.token
					where
						tbase2.id not in ((select did from wpftsi_tp where q_id = "130500"))
				 made by require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, do_action_ref_array('pre_get_posts'), WP_Hook->do_action, WP_Hook->apply_filters, WPFTS_Search->index_pre_get_posts, WPFTS_Search->sql_parts, WPFTS_DB->query

There are a few of these.

Just looked at it and the first error, right after I updated the plugin, was very similar to the one I’ve pasted above @epsiloncool. Then, the error log started getting flooded by various similar entries like that until I reverted back to the previous version.

Would those DB errors really be in that same PHP error.log file or maybe in another one?

Thanks for the quick reply, @epsiloncool!

So I deactivated the plugin, updated it again to the latest version, and re-activated it.

This time, I’m not seeing any error logs and it seems to be working fine. Maybe now it did create the new DB table on activation, but didn’t do that before when I simply updated over the previous version while it was already activated?

Cheers!

Hi @epsiloncool, so I’ve updated to 1.71.238 today and now am seeing lots of these in my PHP error log:

[28-Jul-2024 09:30:57 UTC] WordPress database error Table 'wordpress.wpftsi_doctree' doesn't exist for query insert into wpftsi_tp
						(q_id, did, pow, res, ts) 
					SELECT
						t1.q_id,
						tbase2.id,
						0,
						0,
						NOW()
					FROM (
    					SELECT
							trel.q_id,
        					trel.did,
        					tindex.tid,
        					tindex.tsrc,
        					tbase.token
    					FROM wpftsi_tp trel
    					STRAIGHT_JOIN wpftsi_docs tbase
        					ON (trel.did = tbase.id) AND (trel.q_id = "128390")
    					STRAIGHT_JOIN wpftsi_index AS tindex
        					ON tindex.id = tbase.index_id
					) t1
					STRAIGHT_JOIN wpftsi_doctree dt
    					ON t1.tid = dt.c_tid AND t1.tsrc = dt.c_tsrc AND t1.token = dt.c_token
					STRAIGHT_JOIN wpftsi_index tindex2
    					ON tindex2.tid = dt.p_tid AND tindex2.tsrc = dt.p_tsrc
					STRAIGHT_JOIN wpftsi_docs AS tbase2
    					ON tbase2.index_id = tindex2.id AND dt.p_token = tbase2.token
					where
						tbase2.id not in ((select did from wpftsi_tp where q_id = "128390"))
				 made by require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, do_action_ref_array('pre_get_posts'), WP_Hook->do_action, WP_Hook->apply_filters, WPFTS_Search->index_pre_get_posts, WPFTS_Search->sql_parts, WPFTS_DB->query
[28-Jul-2024 09:30:57 UTC] WordPress database error Table 'wordpress.wpftsi_doctree' doesn't exist for query SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID, wpftsi_t.relev 
					 FROM wp_posts 
				inner join ( 
					select 
						fi.tid, 
						t_end.relev 
					from wpftsi_index fi 
					straight_join ( 				
				SELECT 
					tbase.index_id,
					sum(
						(
							if(tbase.n < 1,0,trel.pow + (trel.res / LOG(tbase.n + 1)) / 1) 
						+ if(isnull(t3.id) or (t3.n < 1),0, (
									t3.pow + (t3.res / LOG(t3.n + 1)) / 1
								) *  (case tbase.token  when "post_title" then 0.9 when "post_content" then 0.4 when "post_excerpt" then 0.2 else 1 end) / (17))
						) *  (case tbase.token  when "post_title" then 0.9 when "post_content" then 0.4 when "post_excerpt" then 0.2 else 1 end) / (17)
					) relev
			FROM 
				wpftsi_tp trel
			STRAIGHT_JOIN 
				wpftsi_docs tbase
				ON (trel.did = tbase.id)
			STRAIGHT_JOIN 
				wpftsi_index tindex
				ON tindex.id = tbase.index_id
			LEFT JOIN (
				SELECT 
					dt.p_tid,
					dt.p_tsrc,
					dt.p_token,
					t2.id,
					t2.token AS token2,
					t2.n AS n2,
					t2.index_id AS index_id2,
					t2.pow,
					t2.res,
					t2.n
				FROM 
					wpftsi_doctree AS dt
				STRAIGHT_JOIN (
					SELECT 
						tbase.id,
						tbase.n,
						trel.did,
						trel.res,
						trel.pow,
						tindex.tid,
						tindex.tsrc,
						tindex.id AS index_id,
						tbase.token
					FROM 
						wpftsi_tp trel
					STRAIGHT_JOIN 
						wpftsi_docs AS tbase
						ON (trel.did = tbase.id)
					STRAIGHT_JOIN 
						wpftsi_index AS tindex
						ON tindex.id = tbase.index_id
						where 1  and (trel.q_id = "128390")
				) AS t2 
				ON t2.tid = dt.c_tid AND t2.tsrc = dt.c_tsrc AND t2.token = dt.c_token
			) AS t3 
			ON tindex.tid = t3.p_tid AND tindex.tsrc = t3.p_tsrc AND tbase.token = t3.p_token
			where 1  and (trel.q_id = "128390")
				group by tbase.index_id
				ORDER BY NULL
			) t_end 
			on t_end.index_id = fi.id 
		order by null
	) wpftsi_t 
		on wpftsi_t.tid = wp_posts.ID 
				 
					 WHERE 1=1  and (((1))) and (wpftsi_t.relev > 0) AND ((wp_posts.post_type = 'attachment' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled')) OR (wp_posts.post_type = 'page' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled')) OR (wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled')))
					 
					 ORDER BY  (wpftsi_t.relev) DESC, wp_posts.post_date DESC
					 LIMIT 0, 20 made by require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, apply_filters_ref_array('posts_pre_query'), WP_Hook->apply_filters, WPFTS_Search->index_posts_pre_query, WPFTS_DB->get_results
[28-Jul-2024 09:30:57 UTC] PHP Warning:  Cannot modify header information - headers already sent by (output started at /home/macmagazine/public_html/wp-content/themes/caards-child/functions/itunes_live_tile.php:294) in /home/macmagazine/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1831
[28-Jul-2024 09:30:59 UTC] PHP Warning:  Cannot modify header information - headers already sent by (output started at /home/macmagazine/public_html/wp-content/themes/caards-child/functions/itunes_live_tile.php:393) in /home/macmagazine/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1831
[28-Jul-2024 09:31:01 UTC] PHP Warning:  Cannot modify header information - headers already sent by (output started at /home/macmagazine/public_html/wp-content/themes/caards-child/functions/itunes_live_tile.php:294) in /home/macmagazine/public_html/wp-includes/rest-api/class-wp-rest-server.php on line 1831
[28-Jul-2024 09:31:06 UTC] WordPress database error Table 'wordpress.wpftsi_doctree' doesn't exist for query insert into wpftsi_tp
						(q_id, did, pow, res, ts) 
					SELECT
						t1.q_id,
						tbase2.id,
						0,
						0,
						NOW()
					FROM (
    					SELECT
							trel.q_id,
        					trel.did,
        					tindex.tid,
        					tindex.tsrc,
        					tbase.token
    					FROM wpftsi_tp trel
    					STRAIGHT_JOIN wpftsi_docs tbase
        					ON (trel.did = tbase.id) AND (trel.q_id = "128391")
    					STRAIGHT_JOIN wpftsi_index AS tindex
        					ON tindex.id = tbase.index_id
					) t1
					STRAIGHT_JOIN wpftsi_doctree dt
    					ON t1.tid = dt.c_tid AND t1.tsrc = dt.c_tsrc AND t1.token = dt.c_token
					STRAIGHT_JOIN wpftsi_index tindex2
    					ON tindex2.tid = dt.p_tid AND tindex2.tsrc = dt.p_tsrc
					STRAIGHT_JOIN wpftsi_docs AS tbase2
    					ON tbase2.index_id = tindex2.id AND dt.p_token = tbase2.token
					where
						tbase2.id not in ((select did from wpftsi_tp where q_id = "128391"))
				 made by require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, do_action_ref_array('pre_get_posts'), WP_Hook->do_action, WP_Hook->apply_filters, WPFTS_Search->index_pre_get_posts, WPFTS_Search->sql_parts, WPFTS_DB->query
[28-Jul-2024 09:31:06 UTC] WordPress database error Table 'wordpress.wpftsi_doctree' doesn't exist for query SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID, wpftsi_t.relev 
					 FROM wp_posts 
				inner join ( 
					select 
						fi.tid, 
						t_end.relev 
					from wpftsi_index fi 
					straight_join ( 				
				SELECT 
					tbase.index_id,
					sum(
						(
							if(tbase.n < 1,0,trel.pow + (trel.res / LOG(tbase.n + 1)) / 1305.5032653379349) 
						+ if(isnull(t3.id) or (t3.n < 1),0, (
									t3.pow + (t3.res / LOG(t3.n + 1)) / 1305.5032653379349
								) *  (case tbase.token  when "post_title" then 0.9 when "post_content" then 0.4 when "post_excerpt" then 0.2 else 1 end) / (5))
						) *  (case tbase.token  when "post_title" then 0.9 when "post_content" then 0.4 when "post_excerpt" then 0.2 else 1 end) / (5)
					) relev
			FROM 
				wpftsi_tp trel
			STRAIGHT_JOIN 
				wpftsi_docs tbase
				ON (trel.did = tbase.id)
			STRAIGHT_JOIN 
				wpftsi_index tindex
				ON tindex.id = tbase.index_id
			LEFT JOIN (
				SELECT 
					dt.p_tid,
					dt.p_tsrc,
					dt.p_token,
					t2.id,
					t2.token AS token2,
					t2.n AS n2,
					t2.index_id AS index_id2,
					t2.pow,
					t2.res,
					t2.n
				FROM 
					wpftsi_doctree AS dt
				STRAIGHT_JOIN (
					SELECT 
						tbase.id,
						tbase.n,
						trel.did,
						trel.res,
						trel.pow,
						tindex.tid,
						tindex.tsrc,
						tindex.id AS index_id,
						tbase.token
					FROM 
						wpftsi_tp trel
					STRAIGHT_JOIN 
						wpftsi_docs AS tbase
						ON (trel.did = tbase.id)
					STRAIGHT_JOIN 
						wpftsi_index AS tindex
						ON tindex.id = tbase.index_id
						where 1  and (trel.q_id = "128391")
				) AS t2 
				ON t2.tid = dt.c_tid AND t2.tsrc = dt.c_tsrc AND t2.token = dt.c_token
			) AS t3 
			ON tindex.tid = t3.p_tid AND tindex.tsrc = t3.p_tsrc AND tbase.token = t3.p_token
			where 1  and (trel.q_id = "128391")
				group by tbase.index_id
				ORDER BY NULL
			) t_end 
			on t_end.index_id = fi.id 
		order by null
	) wpftsi_t 
		on wpftsi_t.tid = wp_posts.ID 
				 
					 WHERE 1=1  and (((1))) and (wpftsi_t.relev > 0) AND ((wp_posts.post_type = 'attachment' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled')) OR (wp_posts.post_type = 'page' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled')) OR (wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled')))
					 
					 ORDER BY  (wpftsi_t.relev) DESC, wp_posts.post_date DESC
					 LIMIT 0, 20 made by require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, apply_filters_ref_array('posts_pre_query'), WP_Hook->apply_filters, WPFTS_Search->index_posts_pre_query, WPFTS_DB->get_results

What should I do, please?