Error: Invalid column name because it conflicts with the existing column: isdirectdeal

[LexLuthr]

A storage provider upgrading from v2.0.0 to a higher version may encounter the below error.

Error: running cassandra migrations: running migration ts20230913144459_dealsAddIsDirectDealColumn: creating new column IsDirectDeal: Duplicate Column. Invalid column name because it conflicts with the existing column: isdirectdeal ALTER TABLE PieceDeal ADD IsDirectDeal BOOLEAN

The error comes from an incomplete migration which add the new column to the existing Cassandra table in the YugabyteDB. The migration does the following:

1. Add a new column
2. Set a the value of that column for all rows to false

The problem is encountered when first step complete but the second one doesn't. This causes the migration to be marked as incomplete and when it is attempted again on the next start we run into the above error.

Fix:

1. Login to CQL shell using the ycqlsh utility from YugabyteDB.
2. Drop the column from the table using the query ALTER TABLE idx.PieceDeal DROP IsDirectDeal;
3. Restart the `boostd-data service. You should see a migration successful message now and service should start properly

** We are still investigating the condition which leads to the incomplete migrations. If you encounter this error, I would request you to please submit logs here of boostd-data service from last time it worked till latest. **

[LexLuthr]

Permanent fix is at #1761