Deletion of a field from a table which is participating in Table Rotation/Extension can cause excessive errors


Description

Deletion of a field from a table which is participating in Table Rotation/Extension can cause excessive errors.

Error: Syntax Error or Access Rule Violation detected by database (Unknown column 'XYZ' in 'field list')

Release or Environment

All

Cause

When we delete a field from a table which is participating in Table Rotation/Extension, It might not get deleted from all the shards it has. It causes excessive errors in syslog table which in turn can cause rapid growth in syslog table since they have all the shards in the failing statement and each entry is massive.

Resolution

Delete the field from all shards.