Back

Something wrong with creating index attribute with fulltext type

  • 1
  • Databases
  • Cloud
Mosh Ontong
25 Sep, 2023, 14:05

Why it took so long to completee the process on creating index, when then I am trying to delete the attribute while the status is still in the processing, it gives me stuck

TL;DR
The user is experiencing difficulties creating an index attribute with fulltext type. They attempted to recreate the collection and create a key index instead, but the problem persists. They do not have many data entries, only around 50 or less. The user asks for assistance in checking their two Appwrite projects and provides their project IDs. They mention that the processing time for creating an index takes a long time, and attempting to delete the attribute while it is still processing gets stuck. They tried restarting Docker but the issue persists.
Mosh Ontong
25 Sep, 2023, 19:11

until now the processing is still exist

Mosh Ontong
25 Sep, 2023, 19:13
Mosh Ontong
25 Sep, 2023, 19:13

the stuck cant delete

Chris
25 Sep, 2023, 19:25

You can try this inside your appwrite directory.

docker down docker up -d

Drake
25 Sep, 2023, 22:04

backups happen once a day...during that time, it may take up to an hour to process.

Mosh Ontong
25 Sep, 2023, 22:25

its been over 6 hours

Mosh Ontong
25 Sep, 2023, 22:25

it starts on 10 pm

Mosh Ontong
25 Sep, 2023, 22:25

then I woke up at 3 am to try

Drake
25 Sep, 2023, 22:30

how much data do you have and what's your project id?

Mosh Ontong
25 Sep, 2023, 22:40

I dont have much data. It does not reach a hundreds of data. I think 50 below.

Project Ids: Dev Project = 64c8d4fe450efd228047 Staging Project = 64d79de210e0f3e6975d

Please check these two appwrite project

Drake
25 Sep, 2023, 22:43

hmm sorry no logs

Mosh Ontong
25 Sep, 2023, 22:44

Just create new one

Mosh Ontong
25 Sep, 2023, 22:44

but still on processing

Mosh Ontong
25 Sep, 2023, 22:46

But when I am creating a different index type for example key index type. Its fast to processed it

Drake
25 Sep, 2023, 22:46

ya these are in a limbo state now...it's not actually processing anymore

Mosh Ontong
25 Sep, 2023, 22:47

Ohhh never mind, same error occurs I just tried it to create key index, it still the same

Mosh Ontong
25 Sep, 2023, 22:47
Mosh Ontong
25 Sep, 2023, 22:48

I just used different project

Mosh Ontong
25 Sep, 2023, 22:48
Mosh Ontong
25 Sep, 2023, 22:48

why it so fast to create a index

Drake
25 Sep, 2023, 22:50

oye...something seems screwed up with your collection...

Mosh Ontong
25 Sep, 2023, 22:52

yup, I think I need to recreate this collection

Reply

Reply to this thread by joining our Discord

Reply on Discord

Need support?

Join our Discord

Get community support by joining our Discord server.

Join Discord

Get premium support

Join Appwrite Pro and get email support from our team.

Learn more