Heatwave table LOAD_STATUS has become STALE_RPDGSTABSTATE and queries no longer offloading
(Doc ID 2941149.1)
Last updated on JULY 22, 2024
Applies to:
MySQL Database Service - Version N/A to N/AHeatWave on AWS - Version N/A to N/A
Information in this document applies to any platform.
Symptoms
Queries that were offloading for a particular table, no longer offload and execute in InnoDB instead of HeatWave.
LOAD_STATUS quick reference;
For more information see https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-tables-table.html
Changes
Its possible that a temporary error, or issue with Heatwave or a particular table can cause change propagation to fail.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |