PDOException : Table 'appwrite._1_' doesn't exist

any idea where does this error come from while deleting a document ? restarting appwrite doesn't rectify the issue.
i dont know how to recreate this issue . but what i remember doing is :

create a collection with some attributes.
create a string attribute named "domains".
add some entries into the collection.
delete the "domains" attribute.
add another many to many relationship to any other collection, BUT with same name "domains"
some days later, i removed "domains" relationship, and created another String array attribute named "domains"
then i added a key index and fulltext index for "domains" attribute.
now, when i tried to delete any of the entries i created earlier, i get this error..

i don't know whether these steps caused it. but what might be the possible reason??

i can write or read other collections without any error. error persist only for this collection and restarting server doesnt solve it.

Ya something odd has happened...something probably wasn't properly deleted. It would be great to be able to pinpoint the root cause so we can properly fix it.

The easiest way to clean this up right now is probably to recreate the collections

There lot of such bugs related to relationships.. its in beta. I know.. but in most of case , i am unable to properly pin point the cause of it as it comes randomly.. like im working for some time and it works.. and next day, if i make any changes in attributes or delete some other.. its breaks randomly, and this kind of errors appear..and wont go

Yes, as you said, it's a beta. Support for relationships was huge and required lots of changes to the code. Not only that, there are a lot of permutations of relationships (relationship type * one/two way * on delete strategy)

Ya.. its awesome..

Having the same issue. I there a way to clear this without clearing both collections?

Please create a new post rather than reusing a previous post