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’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Long product descriptions can't be indexed (Postgres) #745

Closed
coderjib opened this issue Mar 4, 2021 · 0 comments
Closed

Long product descriptions can't be indexed (Postgres) #745

coderjib opened this issue Mar 4, 2021 · 0 comments
Assignees
Labels
type: bug 🐛 Something isn't working
Milestone

Comments

@coderjib
Copy link
Contributor

coderjib commented Mar 4, 2021

Describe the bug
When using postgres, if there is a product with a description field longer than 2704 bytes, this can't be indexed correctly. In this situation, trying to (re)build the search index results in the following error:
ERROR: index row size 2816 exceeds btree version 4 maximum 2704 for index "IDX_9a5a6a556f75c4ac7bfdd03410" - Index row references tuple (0,3) in relation "search_index_item" - Values larger than 1/3 of a buffer page cannot be indexed
The db crashes and the product view in the admin is empty.
The issue is in the SearchIndexItem.description field that has a length limit that is not reflected (for instance) in a length limit in the Admin UI for the description field.

Expected behavior
If this limit can't be increased easily, at least there should be either a limit in the max length of description field in the Admin UI or a message that states that longer descriptions cannot be fully indexed.

Environment (please complete the following information):

  • @vendure/core version: 0.18.3
  • Database (mysql/postgres etc): Postgres
@coderjib coderjib added the type: bug 🐛 Something isn't working label Mar 4, 2021
@michaelbromley michaelbromley added this to the v1.0.0 milestone Mar 4, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type: bug 🐛 Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants