-
Bug
-
Resolution: Fixed
-
Normal
-
None
-
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
- is related to
-
MBVM-90 Collation error message present in mirror.log
- Open