Skip to content
Back

[SOLVED]indexes stopped working after updating to 1.3.8

  • 0
  • Databases
๐ŸœUdon๐Ÿœ
17 Aug, 2023, 20:55

Apparently Query.search doesn't work

TL;DR
Issue: After updating to version 1.3.8, indexes stopped working properly. The search function is returning null when querying the full text index. The code seems to be fine and the problem might be related to caching the database. Solution: Reinstall the Appwrite application or consider creating a new one. Confirm the attributes in the collection and check the indexes, their types, and the attributes they are set on. Additionally, investigate the code that is causing the issue. There might be a problem with the OpenSSL key, which could be the cause of the search function not working.
Binyamin
17 Aug, 2023, 20:55

It was the SSL?

D5
17 Aug, 2023, 20:55

Uh, so the issue was due to the OpenSSL key? ๐Ÿ˜ตโ€๐Ÿ’ซ

๐ŸœUdon๐Ÿœ
17 Aug, 2023, 20:55

But Query.equal does

๐ŸœUdon๐Ÿœ
17 Aug, 2023, 20:55

Nope but I changed my key so it wasn't blank

๐ŸœUdon๐Ÿœ
17 Aug, 2023, 20:56

Try this out on your end guys Query.equals works for me but as soon as you try Query.search fails

D5
17 Aug, 2023, 21:03

What you're searching for?

D5
17 Aug, 2023, 21:04

Query.search seems to be working fine for me ๐Ÿค”

๐ŸœUdon๐Ÿœ
18 Aug, 2023, 15:12

It's still acting weird guys. I think it's how I upgraded from 1.3.7 to 1.3.8

๐ŸœUdon๐Ÿœ
18 Aug, 2023, 15:15

When I try to migrate this is the error I get ```Migrating Collection audit:

Fatal error: Uncaught RedisException: Connection lost in /usr/src/code/vendor/utopia-php/cache/src/Cache/Adapter/Redis.php:34 Stack trace: #0 /usr/src/code/vendor/utopia-php/cache/src/Cache/Adapter/Redis.php(34): Redis->get('cache-_3:_metad...') #1 /usr/src/code/vendor/utopia-php/cache/src/Cache/Cache.php(48): Utopia\Cache\Adapter\Redis->load('cache-_3:_metad...', 86400) #2 /usr/src/code/vendor/utopia-php/database/src/Database/Database.php(2146): Utopia\Cache\Cache->load('cache-_3:_metad...', 86400) #3 /usr/src/code/vendor/utopia-php/database/src/Database/Database.php(721): Utopia\Database\Database->getDocument(Object(Utopia\Database\Document), 'audit') #4 /usr/src/code/vendor/utopia-php/database/src/Database/Database.php(391): Utopia\Database\Database->Utopia\Databaseclosure}() #5 /usr/src/code/vendor/utopia-php/database/src/Database/Database.php(721): Utopia\Database\Database->silent(Object(Closure)) #6 /usr/src/code/vendor/utopia-php/database/src/Database/Database.php(3915): Utopia\Database\Database->getCollection('audit') #7 /usr/src/code/vendor/utopia-php/database/src/Database/Database.php(391): Utopia\Database\Database->Utopia\Databaseclosure}() #8 /usr/src/code/vendor/utopia-php/database/src/Database/Database.php(3915): Utopia\Database\Database->silent(Object(Closure)) #9 /usr/src/code/src/Appwrite/Migration/Migration.php(179): Utopia\Database\Database->count('audit') #10 /usr/src/code/src/Appwrite/Migration/Migration.php(143): Appwrite\Migration\Migration->documentsIterator('audit') #11 {main} thrown in /usr/src/code/vendor/utopia-php/cache/src/Cache/Adapter/Redis.php on line 34 root@Appwrite:~/appwrite#```

๐ŸœUdon๐Ÿœ
18 Aug, 2023, 15:16

Any idea what this error could mean

D5
18 Aug, 2023, 15:32

That seems a problem with caching database ๐Ÿค”

๐ŸœUdon๐Ÿœ
18 Aug, 2023, 15:37

How can I fix it

๐ŸœUdon๐Ÿœ
18 Aug, 2023, 15:38

Not sure what broke or how I broke it

๐ŸœUdon๐Ÿœ
18 Aug, 2023, 15:38

Please help

๐ŸœUdon๐Ÿœ
18 Aug, 2023, 15:42

@Binyamin any ideas

Binyamin
18 Aug, 2023, 15:47

Let's summary the issue so we can better tackle it

  • What are the attributes in that collection
  • What are the indexes, types and on which attributes
  • What the your code you're running that you're getting null
๐ŸœUdon๐Ÿœ
18 Aug, 2023, 15:53

The attributes are things that are full text indexes and the search doesn't work but the equals does but only for one attribute. I know a work around and I've checked that my code isn't the problem

๐ŸœUdon๐Ÿœ
18 Aug, 2023, 15:54

It only returns null when I directly Query.search the full text index

๐ŸœUdon๐Ÿœ
18 Aug, 2023, 15:54

Hope that explains it better

๐ŸœUdon๐Ÿœ
18 Aug, 2023, 15:56

I might have to create a new appwrite

๐ŸœUdon๐Ÿœ
18 Aug, 2023, 16:17

We can close this ticket, I just reinstalled appwrite

๐ŸœUdon๐Ÿœ
18 Aug, 2023, 16:17

[Solved]indexes stopped working after updating to 1.3.8

๐ŸœUdon๐Ÿœ
18 Aug, 2023, 16:17

[SOLVED]indexes stopped working after updating to 1.3.8

Binyamin
18 Aug, 2023, 16:26

๐Ÿ‘

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