deck icon indicating copy to clipboard operation
deck copied to clipboard

Long card description --> Indexing fails

Open besca-red opened this issue 2 years ago • 0 comments

Describe the bug After creating a card with a long description an error occurs in the log. After creating this card, no changes (title, description) to this card can be made. Every change attempt fails and produces an error in the log.

To Reproduce Steps to reproduce the behavior:

  1. Go to Deck
  2. Create a card
  3. Write a long description (in my case: ~3.900 letters)
  4. See error

Expected behavior Should work.

Server details

Database: PostgreSQL 14.10

PHP version: 8.1.25

Nextcloud version: 26.0.8 / 26.0.9

Logs

Nextcloud log (data/nextcloud.log)

[deck] Error: OC\DB\Exceptions\DbalException: An exception occurred while executing a query: SQLSTATE[54000]: Program limit exceeded: 7 ERROR:  index row size 2800 exceeds btree version 4 maximum 2704 for index "idx_last_editor"
DETAIL:  Index row references tuple (16,58) in relation "oc_deck_cards".
HINT:  Values larger than 1/3 of a buffer page cannot be indexed.
Consider a function index of an MD5 hash of the value, or use full text indexing.

besca-red avatar Nov 24 '23 01:11 besca-red