corrupted table

Hello again,

I attach to you the system information from one corrupted table of our clients:

### rank-math ###

version: 1.0.87
database_version: 1
plugin_plan: Free
active_modules: link-counter, analytics, seo-analysis, sitemap, rich-snippet, role-manager, redirections, 404-monitor, content-ai, instant-indexing
refresh_token: Token exists
permissions: 
	Search Console: Given
rank_math_404_logs: 32 KB
rank_math_redirections: 32 KB
rank_math_redirections_cache: 32 KB
rank_math_internal_links: 176 KB
rank_math_internal_meta: 16 KB
rank_math_analytics_gsc: 61 MB
rank_math_analytics_objects: 144 KB
rank_math_analytics_inspections: 208 KB

### wp-core ###

version: 5.9.3
site_language: en_US
user_language: en_US
timezone: +07:00
permalink: /%category%/%postname%/
https_status: true
multisite: false
user_registration: 0
blog_public: 0
default_comment_status: open
environment_type: production
user_count: 6
dotorg_communication: true

### wp-dropins (1) ###

advanced-cache.php: true

### wp-active-theme ###

name: Astra Child (astra-child)
version: 1.0.0
author: Brainstorm Force
author_website: http://wpastra.com/about/
parent_theme: Astra (astra)
theme_features: core-block-patterns, astra_hooks, widgets-block-editor, align-wide, automatic-feed-links, title-tag, post-thumbnails, html5, post-formats, custom-logo, customize-selective-refresh-widgets, editor-style, woocommerce, rank-math-breadcrumbs, amp, editor-color-palette, widgets, menus
theme_path: /www/xxx/public/wp-content/themes/astra-child
auto_update: Disabled

### wp-parent-theme ###

name: Astra (astra)
version: 3.7.7 (latest version: 3.7.10)
author: Brainstorm Force
author_website: https://wpastra.com/about/?utm_source=theme_preview&utm_medium=author_link&utm_campaign=astra_theme
theme_path: /www/xxx/public/wp-content/themes/astra
auto_update: Disabled

### wp-mu-plugins (2) ###

Health Check Troubleshooting Mode: author: (undefined), version: 1.7.2
Kinsta Must-use Plugins: version: 2.3.4, author: Kinsta Team

### wp-plugins-active (24) ###

Akismet Anti-Spam: version: 4.2.2, author: Automattic (latest version: 4.2.3), Auto-updates disabled
Astra Pro: version: 3.6.5, author: Brainstorm Force, Auto-updates disabled
Contact Form 7: version: 5.5.6, author: Takayuki Miyoshi, Auto-updates disabled
Contact Form 7 Signature Addon: version: 4.2.2, author: Breizhtorm, Auto-updates disabled
Contact Form CFDB7: version: 1.2.6.4, author: Arshid, Auto-updates disabled
Cookie Notice & Compliance for GDPR / CCPA: version: 2.2.3, author: Hu-manity.co, Auto-updates disabled
Elementor: version: 3.5.6, author: Elementor.com (latest version: 3.6.5), Auto-updates disabled
Elementor Pro: version: 3.6.2, author: Elementor.com, Auto-updates disabled
Essential Addons for Elementor: version: 5.0.13, author: WPDeveloper (latest version: 5.1.1), Auto-updates disabled
Google Tag Manager for WordPress: version: 1.15, author: Thomas Geiger, Auto-updates disabled
Health Check & Troubleshooting: version: 1.4.5, author: The WordPress.org community, Auto-updates disabled
Popup Maker: version: 1.16.7, author: Popup Maker, Auto-updates disabled
Popup Maker - Advanced Theme Builder: version: 1.2.0, author: Popup Maker, Auto-updates disabled
Popup Maker - Popup Analytics: version: 1.1.13, author: WP Popup Maker, Auto-updates disabled
Popup Maker - Scroll Triggered Popups: version: 1.3.2, author: WP Popup Maker, Auto-updates disabled
Quiz Maker: version: 6.3.2.2, author: Quiz Maker team (latest version: 6.3.2.6), Auto-updates disabled
Rank Math SEO: version: 1.0.87, author: Rank Math, Auto-updates disabled
Sassy Social Share: version: 3.3.40, author: Team Heateor, Auto-updates disabled
Search Exclude: version: 1.2.6, author: Roman Pronskiy, Auto-updates disabled
Site Health Tool Manager: version: 1.1, author: William Earnhardt, Auto-updates disabled
Smush: version: 3.9.5, author: WPMU DEV (latest version: 3.9.8), Auto-updates disabled
Split Test For Elementor: version: 1.5.1, author: Rocket Elements, Auto-updates disabled
Tracking Script Manager: version: 2.0.7, author: Red8 Interactive, Auto-updates disabled
WP Rocket: version: 3.11.0.4, author: WP Media, Auto-updates disabled

### wp-server ###

server_architecture: Linux 5.13.0-1023-gcp x86_64
httpd_software: nginx/1.19.10
php_version: 7.4.25 64bit
php_sapi: fpm-fcgi
max_input_variables: 10000
time_limit: 300
memory_limit: 256M
max_input_time: 300
upload_max_filesize: 128M
php_post_max_size: 128M
curl_version: 7.68.0 OpenSSL/1.1.1j
suhosin: false
imagick_availability: true
pretty_permalinks: true
htaccess_extra_rules: true

### wp-database ###

extension: mysqli
server_version: 10.5.15-MariaDB-1:10.5.15+maria~focal
client_version: mysqlnd 7.4.25
max_allowed_packet: 33554432
max_connections: 10

### wp-constants ###

WP_HOME: undefined
WP_SITEURL: undefined
WP_CONTENT_DIR: /www/xxx/public/wp-content
WP_PLUGIN_DIR: /www/xxx/public/wp-content/plugins
WP_MEMORY_LIMIT: 40M
WP_MAX_MEMORY_LIMIT: 256M
WP_DEBUG: true
WP_DEBUG_DISPLAY: true
WP_DEBUG_LOG: false
SCRIPT_DEBUG: false
WP_CACHE: true
CONCATENATE_SCRIPTS: undefined
COMPRESS_SCRIPTS: undefined
COMPRESS_CSS: undefined
WP_ENVIRONMENT_TYPE: Undefined
DB_CHARSET: utf8
DB_COLLATE: undefined

### wp-filesystem ###

wordpress: writable
wp-content: writable
uploads: writable
plugins: writable
themes: writable
mu-plugins: writable

We keep digging about this issue as it keeps affecting several of our client. We have not find out any root cause so far other than it seems that “special characters” are causing the corruption.

One thing i noticed is all of the corruption issues in our clients started around 12-13 of March. Checking at your changelog of your plugin i see the following one that is pretty close to that date:

v1.0.84 March 9, 2022
Added: [HUGE!] Google URL Inspection API Integration in our Analytics Module, now you can see current Index Staus, Earned Rich Results, Errors & Warnings from Google directly in your WordPress backend!
Improved: Keyword in URL test now detects the Focus Keyword in the parent page slug and domain name
Improved: Made several code improvements
Fixed: 404 Monitor was not working on the Full Site Editing sites
Fixed: Thumbnail Overlay option was not working on some setups
Fixed: SEO data was not updating in the Divi Page Builder’s editor on the sub-folder installation
Fixed: SERP Preview was showing text from the commented code
Fixed: The startDate field in Event schema was not accepting the variables
Fixed: Content AI style on RTL sites

Can you please check with your devs if with the changed that happened at that date, it was somehow affected either the structure of the wp_rank_math_analytics_gsc table or the indexes relating to it?