ERROR: index row size xxxx exceeds maximum 2712 for index "item_attributes_namevalue"

English mAirList 6.x
1

Hello,

I am using mAirListDB on a network with PostgreSQL 11.6-1. When importing new elements, some are not added to the database and cause an error.

ERROR index row size PostgreSQL
Is this related to the version of PostgreSQL?

2

Apparently there is a very long attribute name or value imported from the FLAC tag.

Can you please upload one of these files to www.mairlist.com/upload so we can have a look?

3

I think these are the tags from Serato (DJ software). How can I prevent them from being imported into mAirListDB?

4

You can’t, but maybe I can. Please send us one of these files.

5

Did you receive the file?

6

Yes, thank you.
I’m gonna test it.

7

Especially SERATO_MARKERS_V2 and SERATO_OVERVIEW. :roll_eyes:

So we think about filtering all attributes starting with SERATO while importing these files.
Is that okay with you?

8

Okay !

I know that it is possible to re-read tags of an imported file (Properties, Attributes, Export; Re-read File Tag…). How can I do this on multiple files at the same time?

9

Please try Build 4174 of v6.2.7:

[*] File import: SERATO_* tags ignored when importing Vorbis comments

v6.3-beta will follow.

Do you know what is stored in SERATO_MARKERS_V2?
Maybe there is some information we can import in mAirList?

Please mark these files and use mass-tagging > re-read file tag.

10

Build 4174 of v6.2.7 works great!

SERATO_MARKERS_V2 contains the song cue points, it would be perfect if we could use them for mAirList, but I doubt they can be read outside of Serato.

Thank you for your efficiency !

1 Like