Uploaded image for project: 'MusicBrainz Server'
  1. MusicBrainz Server
  2. MBS-13555

index row size exceeds btree version 4 maximum

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: High High
    • None
    • None
    • Database setup
    • None

      Hi,

      I got an error message during the load of the new (20240424-001726) DB dump:

      psql:ERROR: index row size 2720 exceeds btree version 4 maximum 2704 for index "recording_idx_name"
      DETAIL: Index row references tuple (405902,4) in relation "recording".
      HINT: Values larger than 1/3 of a buffer page cannot be indexed.

      ####
      select id, length(name), name from recording where ctid = '(405902,4)';
      ####
      id 37960058
      length 3403
      name finally the final track on this total time waste of an ep, oh well, we go again, 13ths time the charm lucky charms cereal or whatever. anyways/anywhoo/anypoo/guesswhatchickenbuttguesswhochickenpoo, its cool this ep ended up with 13 tracks as thats always been a cool number, even if overused, its still cool, i remember as a kid my mom would often make cupcakes to celebrate it at school and the teachers and other kids would always be so insanely confused and say like "normally we don't celebrate this" and other funny resposnes, but they always just let us do it anyways – honestly i dont know how i even end up making releases like this, its always some idea i get in my head, but always delays what i actually feel like doing, which would be like, watching pripara or playing this konosuba game that i was playing yesterday more (especially since im almost done with it, also, megumin is super cute, EXPLOSION!!!, also one of my megumin figures has come alive and thrown her staff thing twice), but yeah, im honestly just annoyed at writing this now, but i want it to be longer than the track "this could be used as a drum sound (also, despite what bandcamp says, this isn't 0:01, its 0:00, same with track vore (4), i dont know why their systems cant show "0:00", additionally, 0:00 songs look so ugly on discogs now since its just "0" and not "0:00", also also, the way they do master releases now is annoying and makes it inconvenient to add stuff to collection/wantlist, and no, this isnt a "discogs fascists 2", i am just stating some facts, some street knowledge, also also also, uh, what was i going to say, let me re-read this title so far, well first of all, hopefully discogs fixes those issues before this releases and this title is just an artifact of the past, a long lost civilization, anyways, back to the focus here, oh yeah, john cage's 0'00" isn't actually 0:00 long, what a dork haha, 4'33" is cool though since it makes classical music nerds have to listen to live field recordings, 0'00" is cool though in how it makes these high brow types have to listen to audio shitpost musique concrete and act like they "get it", its epic, like look at this, https://www.youtube.com/watch?v=2kqAFAI8DfI – also also also also its interesting how its also called "4'33" (No. 2)" haha poop joke epic the gamer moment lol you lost, also just so this is annoying to add to discogs, here's some words right after stuff so they dont auto-capitalize, (dog (horse (cat (ninja (porcupine 69loli 1fish 2fish (red (fish (blue (fish blue fin tuna mix) [yes, i remebered to close it lol]" and ok cool, now that I deadass just copy and pasted it in, its now by default longer than that lol – thats such a cop out (fuck the police) though, and again, its annoying this modern age a man cant even have 9001 word titles anymore, 300 character limit, 300 the movie, they lost remember, THIS IS SPARTAAAA we had the dvd of that and that spoof movie meet the spartans lol ok i should stop now, the game, hotdog, hmm, 339894809328409328493284093824873284328974932897 yeah random numbers always works 93849834 9849843984092-04 0392482903849238 3287287764 18737293728 7382738979428948098847384 37872848 993838 0283983918238012744 lol this is epic ok this is epic peter griffin funniest vine compilation (lol imagine people who only know my tclb stuff and not the ninja mctits stuff wondering wtf is happening)
      ####

      Could you please fix it? It was fine in version 20240420-001730

      Could you please execute the following queries in your development DB and provide the results here?
      select current_setting('block_size'));
      select version();

      Regards,
      Attila

            yvanzo yvanzo
            nohattila Attila Horváth
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved:

                Version Package