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

"Add artist" edit can't be rejected if the artist has subscriptions

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2015-12-28
    • Component/s: Edit system
    • Labels:
      None

      Description

      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
      

        Attachments

          Activity

            People

            Assignee:
            bitmap Michael Wiencek
            Reporter:
            bitmap Michael Wiencek
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Due:
              Created:
              Updated:
              Resolved:

                Packages

                Version Package
                2015-12-28