After pushing from appwrite.json I kept getting the following error:
✓ Success: Created 10 attributes
ℹ Info: Creating indexes ...
Error: Index 'status_idx' failed!
at C:\ProgramData\nvm\v20.11.1\node_modules\appwrite-cli\lib\commands\push.js:320:31
at Array.filter (<anonymous>)
at Object.expectIndexes (C:\ProgramData\nvm\v20.11.1\node_modules\appwrite-cli\lib\commands\push.js:317:14)
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
at async createIndexes (C:\ProgramData\nvm\v20.11.1\node_modules\appwrite-cli\lib\commands\push.js:863:20)
at async pushCollection (C:\ProgramData\nvm\v20.11.1\node_modules\appwrite-cli\lib\commands\push.js:1434:13)
Then I tried manually creating the status index via the console, still failed (see attached screenshots). But nothing is telling me why it failed. What am I doing wrong?
TL;DR
Developers are experiencing issues creating an index using the appwrite-cli, leading to an error message. Even manual creation of the status index in the console is failing. The concern is regarding the type of index used (fulltext instead of key) and potential performance problems in queries.
Solution: Check the index creation method, ensure it's correct to avoid the error, and determine the impact of using fulltext index on query performance.
