Back
Cannot delete rows, deleted relationship column still showing in cli and with "stuck" status
I had defined a two-way relationship between 2 tables, then I deleted the relationship column I tried re-creating the column but I started to get errors about the column already existing, although it wasn't present in the columns list in the cloud console.
``` $ appwrite tables-db get-column --database-id="6978c6f5001c76c8ec40" --table-id="listings"--key="medias" key : medias type : string status : stuck error : Cannot delete relationship as an attribute required : false
TypeScript
When I tried to update the relationship column to a new name got this:
```
$ appwrite tables-db update-relationship-column --database-id="6978c6f5001c76c8ec40" --table-id="listings" --key="medias" --new-key="medias_delete" --verbose
AppwriteException: The requested column '%s' is not yet available. Please try again later.
at _Client.<anonymous> (/opt/homebrew/Cellar/appwrite/13.1.0/libexec/lib/node_modules/appwrite-cli/dist/cli.cjs:110478:15)
at Generator.next (<anonymous>)
at fulfilled (/opt/homebrew/Cellar/appwrite/13.1.0/libexec/lib/node_modules/appwrite-cli/dist/cli.cjs:109833:24)
at process.processTicksAndRejections (node:internal/process/task_queues:104:5) {
code: 400,
type: 'column_not_available',
response: `{"message":"The requested column '%s' is not yet available. Please try again later.","code":400,"type":"column_not_available","version":"1.8.1"}`
}
✗ Error: The requested column '%s' is not yet available. Please try again later.
```
There was also a row with the relationship column with a value, after deleting the column I am not able to delete that row.
```
✗ Error:
response: '{"message":"Server Error","code":500,"type":"general_unknown","version":"1.8.1"}'
}
```
TL;DR
Developers are experiencing issues when trying to delete a relationship column that still shows as 'stuck.' Even after attempting to update the column name, errors persist. A row with a relationship column value cannot be deleted. This requires a potentially complex solution and might involve a bug report to the platform provider.