-
Bug
-
Resolution: Fixed
-
Normal
-
None
-
None
http://musicbrainz.org/edit/36281221 is currently stuck:
Edit queue processing starting Failed query: 'DELETE FROM artist WHERE id IN (?) RETURNING gid, name AS last_known_name, comment AS last_known_comment' (1304100) 23503 DBD::Pg::st execute failed: ERROR: update or delete on table "artist" violates foreign key constraint "editor_subscribe_artist_fk_artist" on table "editor_subscribe_artist" DETAIL: Key (id)=(1304100) is still referenced from table "editor_subscribe_artist". at /home/musicbrainz/musicbrainz-server/admin/../lib/Sql.pm line 458. Sql::catch {...} ('MusicBrainz::Server::Exceptions::DatabaseError=HASH(0xe6c4880)') called at /usr/share/perl5/Try/Tiny.pm line 104 Try::Tiny::try('CODE(0xe6bcaa0)', 'Try::Tiny::Catch=REF(0xe6bc638)', 'Try::Tiny::Finally=REF(0xe61d3f0)') called at /home/musicbrainz/musicbrainz-server/admin/../lib/Sql.pm line 464 Sql::_select_list('Sql=HASH(0x5a81528)', 'DELETE FROM artist WHERE id IN (?)\x{a} RETURNING...', 'ARRAY(0x4d36238)', 'hashref') called at /home/musicbrainz/musicbrainz-server/admin/../lib/Sql.pm line 492 Sql::select_list_of_hashes('Sql=HASH(0x5a81528)', 'DELETE FROM artist WHERE id IN (?)\x{a} RETURNING...', 1304100) called at /home/musicbrainz/musicbrainz-server/admin/../lib/MusicBrainz/Server/Data/Role/DeleteAndLog.pm line 13 Class::MOP::Class:::around('CODE(0x6ffbd50)', 'MusicBrainz::Server::Data::Artist=HASH(0xe5e9960)', 'artist', 1304100) called at /usr/lib/perl5/Class/MOP/Method/Wrapped.pm line 164 MusicBrainz::Server::Data::Artist::_wrapped_delete_returning_gids('MusicBrainz::Server::Data::Artist=HASH(0xe5e9960)', 'artist', 1304100) called at /usr/lib/perl5/Class/MOP/Method/Wrapped.pm line 95 MusicBrainz::Server::Data::Artist::delete_returning_gids('MusicBrainz::Server::Data::Artist=HASH(0xe5e9960)', 'artist', 1304100) called at /home/musicbrainz/musicbrainz-server/admin/../lib/MusicBrainz/Server/Data/Artist.pm line 249 MusicBrainz::Server::Data::Artist::delete('MusicBrainz::Server::Data::Artist=HASH(0xe5e9960)', 1304100) called at /usr/lib/perl5/Class/MOP/Method/Wrapped.pm line 50 MusicBrainz::Server::Data::Artist::_wrapped_delete('MusicBrainz::Server::Data::Artist=HASH(0xe5e9960)', 1304100) called at /usr/lib/perl5/Class/MOP/Method/Wrapped.pm line 95 MusicBrainz::Server::Data::Artist::delete('MusicBrainz::Server::Data::Artist=HASH(0xe5e9960)', 1304100) called at /home/musicbrainz/musicbrainz-server/admin/../lib/MusicBrainz/Server/Edit/Generic/Create.pm line 62 MusicBrainz::Server::Edit::Generic::Create::reject('MusicBrainz::Server::Edit::Artist::Create=HASH(0xe5e9630)') called at /home/musicbrainz/musicbrainz-server/admin/../lib/MusicBrainz/Server/Data/Edit.pm line 790 MusicBrainz::Server::Data::Edit::try {...} () called at /usr/share/perl5/Try/Tiny.pm line 76 eval {...} called at /usr/share/perl5/Try/Tiny.pm line 72 Try::Tiny::try('CODE(0xe5e45f0)', 'Try::Tiny::Catch=REF(0xe5e9600)') called at /home/musicbrainz/musicbrainz-server/admin/../lib/MusicBrainz/Server/Data/Edit.pm line 809 MusicBrainz::Server::Data::Edit::_do_reject('MusicBrainz::Server::Data::Edit=HASH(0x5bcaac0)', 'MusicBrainz::Server::Edit::Artist::Create=HASH(0xe5e9630)', 3) called at /home/musicbrainz/musicbrainz-server/admin/../lib/MusicBrainz/Server/Data/Edit.pm line 830 MusicBrainz::Server::Data::Edit::__ANON__('MusicBrainz::Server::Edit::Artist::Create=HASH(0xe5e9630)') called at /home/musicbrainz/musicbrainz-server/admin/../lib/MusicBrainz/Server/Data/Edit.pm line 842 MusicBrainz::Server::Data::Edit::_close('MusicBrainz::Server::Data::Edit=HASH(0x5bcaac0)', 'MusicBrainz::Server::Edit::Artist::Create=HASH(0xe5e9630)', 'CODE(0xe5e43f8)') called at /home/musicbrainz/musicbrainz-server/admin/../lib/MusicBrainz/Server/Data/Edit.pm line 830 MusicBrainz::Server::Data::Edit::reject('MusicBrainz::Server::Data::Edit=HASH(0x5bcaac0)', 'MusicBrainz::Server::Edit::Artist::Create=HASH(0xe5e9630)', 3) called at /home/musicbrainz/musicbrainz-server/admin/../lib/MusicBrainz/Server/EditQueue.pm line 165 MusicBrainz::Server::EditQueue::_process_open_edit('MusicBrainz::Server::EditQueue=HASH(0x55082f8)', 'MusicBrainz::Server::Edit::Artist::Create=HASH(0xe5e9630)') called at /home/musicbrainz/musicbrainz-server/admin/../lib/MusicBrainz/Server/EditQueue.pm line 121 MusicBrainz::Server::EditQueue::_process_edit('MusicBrainz::Server::EditQueue=HASH(0x55082f8)', 36262412) called at /home/musicbrainz/musicbrainz-server/admin/../lib/MusicBrainz/Server/EditQueue.pm line 78 MusicBrainz::Server::EditQueue::__ANON__() called at /home/musicbrainz/musicbrainz-server/admin/../lib/Sql.pm line 319 Sql::try {...} () called at /usr/share/perl5/Try/Tiny.pm line 81 eval {...} called at /usr/share/perl5/Try/Tiny.pm line 72 Try::Tiny::try('CODE(0x4d35908)', 'Try::Tiny::Catch=REF(0x5508070)') called at /home/musicbrainz/musicbrainz-server/admin/../lib/Sql.pm line 332 Sql::_auto_transaction('CODE(0x5bca7f0)', 'Sql=HASH(0x5a81528)') called at /home/musicbrainz/musicbrainz-server/admin/../lib/Sql.pm line 337 Sql::_run_in_transaction_one('CODE(0x5bca7f0)', 'Sql=HASH(0x5a81528)') called at /home/musicbrainz/musicbrainz-server/admin/../lib/Sql.pm line 351 Sql::run_in_transaction('CODE(0x5bca7f0)', 'Sql=HASH(0x5a81528)') called at /home/musicbrainz/musicbrainz-server/admin/../lib/MusicBrainz/Server/EditQueue.pm line 79 MusicBrainz::Server::EditQueue::try {...} () called at /usr/share/perl5/Try/Tiny.pm line 81 eval {...} called at /usr/share/perl5/Try/Tiny.pm line 72 Try::Tiny::try('CODE(0x54e2710)', 'Try::Tiny::Catch=REF(0x5bcab38)') called at /home/musicbrainz/musicbrainz-server/admin/../lib/MusicBrainz/Server/EditQueue.pm line 87 MusicBrainz::Server::EditQueue::process_edits('MusicBrainz::Server::EditQueue=HASH(0x55082f8)') called at ./admin/CheckVotes.pl line 56