🐛 Bug Report: Recreate Same Name Relationship Attribute Only Self-Hosted

[SafakB]

👟 Reproduction steps

The error occurs after deleting the existing relationship attribute and adding it again with the same name.

Relationship Settings

• One-way Relationshop
• Many to one
• Set NULL

Steps

1 - Create Relationship
2 - Data entry with relationship
3 - Delete Relationship attribute
4 - Re-add Relationship
5 - Added to the list but “Failed”
6 - When I check the data I see that the old attributes are still selected :)

I found this
After step 3, in the background the attribute is deleted from the list, but the attribute values remain in the rows

👍 Expected behavior

Deleted relationship should be able to be added again with the same name

👎 Actual Behavior

After adding a relationship, it gives a “Failed” warning. The process is not completed.
Error only occurs in Self-Hosted

Our Live Server 1.5.5 [ ❌ Not working]
Our Test Server 1.5.5 [ ❌ Not working]
Zero installation 1.5.5 [ ❌ Not working]
Cloud [ ✅ Working]

🎲 Appwrite version

Version 1.5.x

💻 Operating system

Linux
Windows 10 (Edited)

🧱 Your Environment

Used Appwite 1.5.5
The bug is not dependent on any SDK

👀 Have you spent some time to check if this issue has been raised before?

• I checked and didn't find similar issue

🏢 Have you read the Code of Conduct?

• I have read the Code of Conduct

[SafakB]

Also tested on Windows 10. Bug causes problems here too

[Tanu1201]

Hey, I am Tanu Sharma having 2 number of exp in backend development, can I take this issue up.

[stnguyen90]

@SafakB, thanks for creating this issue! 🙏

Let's continue troubleshooting in https://discord.com/channels/564160730845151244/1239545933839073301

[SafakB]

I'll be sharing a status update

When I check via MariaDB, I see that the column has not really been deleted

Database worker logs after relationship rebuilding

SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'blogCategory'

There are also remnants in the _1__metadata table

|  31 | database_1_collection_3 | 2024-05-17 20:36:26.080 | 2024-05-17 20:36:26.080 | ["create(\"any\")","read(\"any\")","update(\"any\")","delete(\"any\")"] | database_1_collection_3 | [{"$id":"title","key":"title","type":"string","size":36,"required":false,"default":null,"signed":true,"array":false,"format":"","formatOptions":[],"filters":[]},{"$id":"content","key":"content","type":"string","size":100,"required":false,"default":null,"signed":true,"array":false,"format":"","formatOptions":[],"filters":[]}] | [{"$id":"_index_blogCategory","key":"_index_blogCategory","type":"key","attributes":["blogCategory"],"lengths":[],"orders":[]}]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |                0 |

[stnguyen90]

The fix for this should be released in 1.5.6 which has #8080