Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We鈥檒l occasionally send you account related emails.

Already on GitHub? Sign in to your account

馃悰 Bug Report: No logs for failed index #8119

Open
2 tasks done
stnguyen90 opened this issue May 15, 2024 · 0 comments
Open
2 tasks done

馃悰 Bug Report: No logs for failed index #8119

stnguyen90 opened this issue May 15, 2024 · 0 comments
Assignees
Labels
bug Something isn't working product / databases Fixes and upgrades for the Appwrite Database.

Comments

@stnguyen90
Copy link
Contributor

stnguyen90 commented May 15, 2024

馃憻 Reproduction steps

  1. Create a collection with a string attribute
  2. Create 2 documents with the same text for the string attribute
  3. Create a unique index on the string attribute

馃憤 Expected behavior

Index creation fails, but there are some error logs

馃憥 Actual Behavior

No error logs:

{
  "key": "index_1",
  "type": "unique",
  "status": "failed",
  "error": "",
  "attributes": [
    "s"
  ],
  "orders": [
    "ASC"
  ]
}

appwrite-worker-databases logs show:

appwrite-worker-databases  | [Job] Received Job (6644383f225e21.72265046).
appwrite-worker-databases  | SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'a' for key 'index_1'
appwrite-worker-databases  | [Job] (6644383f225e21.72265046) successfully run.

The behavior on Cloud is slightly different. On Cloud, the index is stuck at processing.

馃幉 Appwrite version

Version 1.5.x

馃捇 Operating system

Linux

馃П Your Environment

Tested in dev version of 1.5.5

馃憖 Have you spent some time to check if this issue has been raised before?

  • I checked and didn't find similar issue

馃彚 Have you read the Code of Conduct?

@stnguyen90 stnguyen90 added bug Something isn't working product / databases Fixes and upgrades for the Appwrite Database. labels May 15, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working product / databases Fixes and upgrades for the Appwrite Database.
Projects
Status: Todo
Development

No branches or pull requests

2 participants