I have a stored procedure in Redshift that is loading data from a bunch of S3 JSON files in a loop.
Every time a file is loaded, its name is stored into a log table on Redshift side so i can link it to records in my staging tables, which i also use to avoid loading same file twice.
Any error during the loading is also recorded.
Anyways, everything worked fine for some time, but during the last run, I got following error (this is the exact error message):
> catalog is missing 1 attribute(s) for relid 5477788
Checking AWS documentation for Redshift, and looking into tables **STL_ERROR**, **STL_LOAD_ERRORS**, **SVL_STORED_PROC_MESSAGES**, **SVL_STORED_PROC_CALL**, **pg_class** did not clarify anything.
Any googling points only to PostgreSQL mentioning possible database corruption. I know that Redshift is based on PostgreSQL, but, how can i check it specifically for Redshift, that my database or table(s) are not corrupted?
Has anyone encountered similar error in Redshift before?
Asked by Oleksandr
(121 rep)
Mar 17, 2023, 10:46 AM
Last activity: Feb 22, 2025, 07:03 AM
Last activity: Feb 22, 2025, 07:03 AM