-
Type:
Bug
-
Resolution: Fixed
-
Priority:
Normal
-
Affects Version/s: None
-
Component/s: Edit system
-
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