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

Replication is blocked by tag duplicates

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • 2023-10-24-hotfix
    • None
    • Back-end
    • None

      Since the server move on Monday 23 October, a tag index has been corrupted in the main database. As a consequence replication packets cannot be loaded on mirrors for now.

      Below is the error message in mirror logs:

      Processing replication changes
           XIDs     Stmts est%  XIDs/sec  Stmt/sec
           2368     18606  62%        64       507Failed query:
              'INSERT INTO musicbrainz.tag (id, name, ref_count) VALUES (?, ?, ?)'
              (259975 girl group 0)
      23505 DBD::Pg::st execute failed: ERROR:  duplicate key value violates unique constraint "tag_idx_name"
      DETAIL:  Key (name)=(girl group) already exists. [for Statement "INSERT INTO musicbrainz.tag (id, name, ref_count) VALUES (?, ?, ?)" with ParamValues: 1='259975', 2='girl group', 3='0']
       at /musicbrainz-server/admin/replication/../../lib/Sql.pm line 123.
              Sql::catch {...} (MusicBrainz::Server::Exceptions::DatabaseError=HASH(0x5649b21c9138)) called at /root/perl5/lib/perl5/Try/Tiny.pm line 123
              Try::Tiny::try(CODE(0x5649b21c8e68), Try::Tiny::Catch=REF(0x5649b21d4a18)) called at /musicbrainz-server/admin/replication/../../lib/Sql.pm line 124
              Sql::do(Sql=HASH(0x5649b1da5d20), "INSERT INTO musicbrainz.tag (id, name, ref_count) VALUES (?, "..., 259975, "girl group", 0) called at /musicbrainz-server/admin/replication/ProcessReplicationChanges line 515
              main::dbmirror2_insert(Sql=HASH(0x5649b1da5d20), "musicbrainz.tag", HASH(0x5649b21d4a48)) called at /musicbrainz-server/admin/replication/ProcessReplicationChanges line 336
              main::dbmirror2_command(Sql=HASH(0x5649b1da5d20), ARRAY(0x5649b1936408)) called at /musicbrainz-server/admin/replication/ProcessReplicationChanges line 185
      
      

            bitmap Michael Wiencek
            yvanzo yvanzo
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:

                Version Package
                2023-10-24-hotfix