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