Description
When trying to ALTER a large table though methods such as deletion, field type change, or field length increase, transactions times out and gets cancelled on the back end.
Steps to Reproduce
- Create a new column directly on the [task] table (the table needs to have over 2 million records for larger ALTER).
- Creating a column will not time out, this has already been tested
- Creating a column will not time out, this has already been tested
- From the UI, delete a column or change the Field Type of the new column created on the [task] table.
Expected results: The transactions should complete even if it goes over the 298 seconds.
Actual results: The Transaction times out and gets cancelled from the back end causing orphaned metadata (which connects to PRB1315639 - When ALTERS are cancelled it leaves behind orphaned metadata)
Workaround
Please consult KB0547328 - Creating or altering a field on a large table from the UI can be canceled by "UI Transactions" Quota Rule
Related Problem: PRB1315581