-
Type:
Bug
-
Resolution: Fixed
-
Priority:
Normal
-
Affects Version/s: None
-
Component/s: 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
- is related to
-
-
- Open
-