- Newest
- Most votes
- Most comments
I am experiencing similar errors in our redshift cluster, accessing tables across databases, and it also first appeared in our system on 10/24/23.
[Amazon](500310) Invalid operation:
-----------------------------------------------
error: Assert
code: 1000
context: current_dml_end_version < structure_change_version - current_dml_end_version=3484461, structure_change_version=3474690.
query: 0
location: StorageOidManager.cpp:1366
process: padbmaster [pid=1073816691]
-----------------------------------------------
Each time it appears, I've found that I can narrow down the scope of the issue to one particular table involved in whichever query encountered that error, and reproduce the error by EXPLAINing a simple query against the table, e.g.
explain select 1 from db_name.schema_name.table_name;
I can fix the problem for a particular table by connecting to its host database, adding an empty column to the table, and then immediately dropping that column:
alter table schema_name.table_name add column _temp varchar(1) null;
alter table schema_name.table_name drop column _temp;
However, the issue keeps recurring, disrupting our nightly data warehouse build. Each time it's a different table, and we have to manually perform the fix above. I'm guessing it's an issue with the synchronization of the table structure between the databases - hence the "version" mismatch in the error message - but that's just a guess.
I would also like to know the root cause of these errors and how to prevent them from occurring.
Relevant content
- asked 2 years ago
- asked 10 months ago
- AWS OFFICIALUpdated a month ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 3 years ago
Don't have an answer, but i experienced the exact same thing!