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

Some recent replication packet breaks slave servers with collate indexes

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2013-12-09
    • Component/s: None
    • Labels:
      None

      Description

      http://forums.musicbrainz.org/viewtopic.php?id=4625
      http://forums.musicbrainz.org/viewtopic.php?id=4629

      both report an issue with http://musicbrainz.org/release-group/9b4c2532-1006-40e0-bbe1-76e5f8dd9b30

      The error message seems to be

      Failed query:
      'INSERT INTO "musicbrainz"."release_group" ("artist_credit", "comment", "edits_pending", "gid", "id", "last_updated", "name", "type") VALUES (?, ?, ?, ?, ?, ?, ?, ?)'
      (602380 0 9b4c2532-1006-40e0-bbe1-76e5f8dd9b30 1320815 2013-11-23 01:17:49.599961+00 Lorem ipsum dolor sit amet,
      .....LOADS OF TEXT HERE.....
      )
      DBD::Pg::st execute failed: ERROR: index row size 6608 exceeds maximum 2712 for index "release_group_idx_musicbrainz_collate"
      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. at /home/solace/repos/musicbrainz-server/admin/replication/../../lib/Sql.pm line 107.

      at /home/solace/repos/musicbrainz-server/admin/replication/../../lib/Sql.pm line 113.
      Sql::catch

      Unknown macro: {...}

      ("DBD::Pg::st execute failed: ERROR: index row size 6608 excee"...) called at /home/solace/perl5/lib/perl5/Try/Tiny.pm line 106
      Try::Tiny::try(CODE(0x231cf08), Try::Tiny::Catch=REF(0x231d688)) called at /home/solace/repos/musicbrainz-server/admin/replication/../../lib/Sql.pm line 114
      Sql::do(Sql=HASH(0x219c418), "INSERT INTO \"musicbrainz\".\"release_group\" (\"artist_credit\", \""..., 602380, "", 0, "9b4c2532-1006-40e0-bbe1-76e5f8dd9b30", 1320815, "2013-11-23 01:17:49.599961+00", "Lorem ipsum dolor sit amet, consectetur adipiscing elit. Done"..., ...) called at /home/solace/repos/musicbrainz-server/admin/replication/ProcessReplicationChanges line 284
      main::mirrorInsert(Sql=HASH(0x21a88f8), Sql=HASH(0x219c418), ARRAY(0x2116838), 788205867) called at /home/solace/repos/musicbrainz-server/admin/replication/ProcessReplicationChanges line 252
      main::mirrorCommand("i", Sql=HASH(0x21a88f8), Sql=HASH(0x219c418), ARRAY(0x2116838), 788205867, CODE(0x231cce0)) called at /home/solace/repos/musicbrainz-server/admin/replication/ProcessReplicationChanges line 181

      Luks mentioned this on IRC as well:

      2207 luks| it probably breaks all db slaves with the collate indexes
      2207 luks| (fortunatelly, I don't have them in my dbs)

        Attachments

          Activity

            People

            • Assignee:
              acid2 Oliver Charles
              Reporter:
              mineo Wieland Hoffmann
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Due:
                Created:
                Updated:
                Resolved:

                Packages

                Version Package
                2013-12-09