Error when migrate/update to 1.5.3 from 1.4.13
I im trying to update to 1.5.3, i made my backup, then run the docker command to install :
--volume /var/run/docker.sock:/var/run/docker.sock \
--volume "$(pwd)"/appwrite:/usr/src/code/appwrite:rw \
--entrypoint="upgrade" \
appwrite/appwrite:1.5.3```
It installed sucessfully, then i run the migration command `docker compose exec appwrite migrate` and it failed on this:
```5731 / 5731
Migrating Collection providers:
0 / 0
Migrating Collection messages:
0 / 0
Migrating Collection topics:
0 / 0
Migrating Collection subscribers:
0 / 0
Migrating Collection targets:
0 / 0
Migrating Project: MyProject (6567a46b9f47bb4f6f0e)
Migrating Collections
Failed to update project ("6567a46b9f47bb4f6f0e") version with error: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'appwrite._3_' doesn't exist
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'appwrite._3_' doesn't exist```
And it exit to bash
if i navigate my browser to console i got `{"message":"Server Error","code":500,"type":"general_unknown","version":"1.5.3"}`
What to do now? Re-Run migration?
Look through the _console_projects table for your project
The _id column tells you the internal id. Then, look through the _<internal id>_attributes table for all attributes that are arrays
I dont know if this help, but, i started this project after i upgrade to 1.4.13, i upgraded to 1.4.13 en november 2023 and i started this project in January
ok, i have them, query returned 43 in total: SELECT * FROM _6_attributes WHERE array = 1 ORDER BY array DESC
Does anything look weird about them?
Maybe missing a size?
There is one that in the error column says "Attribute already exists", actually is the same name that in past weeks (if you remember) give us problem when creating that attribute give us error and i changed it to plural.. there are another attributes (_uid) that has my test names when testing that error but i deleted them but still here, and about the size, nope, all have a size, all have size 100 there is one that have size 1073741824
Hmm...
Hmm also looks like there's a problem with how we're deleting indexes...
Jesus you have lots of attributes π
These logs are from this for loop: https://github.com/appwrite/appwrite/blob/42eacd860ef3629608738c5f7b1c5f66ae140cfd/src/Appwrite/Migration/Version/V20.php#L82
Maybe it's the 43rd attribute that has 15 indexes?
actually no i do not have lots of attributes, maybe they are not deleted when i delete them from console?
let me check
does the indexes are on the same _6_attributes table?
Yep
i dont see any column index or indexes, seeing the structure of the table neither, nor editing that record, im exploring it using phpmyadmin
Oops sorry indexes are in a separate table but still under the _6 namespace
ok i found _6_indexes and _6_indexes_prems, the _indexes table only has 15 rows, none of them has a error, 14 of them has a length of [100] the first of them has [100,100,100] and its order is ["ASC","ASC","ASC"] this has 3 attributes too, key is searcn and type is fulltext
Full text indexes on search attributes aren't allowed anymore.
Maybe you can restore to 1.4.13, delete them, and then try to upgrade?
ok, let me do that and i will return with results
I'm still a little baffled why it keeps printing 0/15 over and over...
ok, i restored it... but there are no indexes on my restored database
