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

ModBot is unable to close Edit::Area::Merge edits

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2013-07-22
    • Component/s: Edit system
    • Labels:
      None

      Description

      Failed query:
      	'
              DELETE FROM area
              WHERE id IN (?)
              RETURNING gid'
      	(5164)
      DBD::Pg::st execute failed: ERROR:  update or delete on table "area" violates foreign key constraint "artist_fk_area" on table "artist"
      DETAIL:  Key (id)=(5164) is still referenced from table "artist". at /home/musicbrainz/musicbrainz-server/admin/../lib/Sql.pm line 440.
      
       at /home/musicbrainz/musicbrainz-server/admin/../lib/Sql.pm line 453.
      	Sql::__ANON__('DBD::Pg::st execute failed: ERROR:  update or delete on table...') called at local/lib/perl5/Try/Tiny.pm line 100
      	Try::Tiny::try('CODE(0xa3cb6b8)', 'Try::Tiny::Catch=REF(0xa511a50)') called at /home/musicbrainz/musicbrainz-server/admin/../lib/Sql.pm line 456
      	Sql::_select_list('Sql=HASH(0x3a0c6e0)', '\x{a}        DELETE FROM area\x{a}        WHERE id IN (?)\x{a}        RET...', 'ARRAY(0xa511d68)', 'arrayref', 'CODE(0x3bb10b0)') called at /home/musicbrainz/musicbrainz-server/admin/../lib/Sql.pm line 475
      	Sql::select_list_of_lists('Sql=HASH(0x3a0c6e0)', '\x{a}        DELETE FROM area\x{a}        WHERE id IN (?)\x{a}        RET...', 5164) called at /home/musicbrainz/musicbrainz-server/admin/../lib/Sql.pm line 408
      	Sql::select_single_column_array('Sql=HASH(0x3a0c6e0)', '\x{a}        DELETE FROM area\x{a}        WHERE id IN (?)\x{a}        RET...', 5164) called at /home/musicbrainz/musicbrainz-server/admin/../lib/MusicBrainz/Server/Data/CoreEntity.pm line 159
      	MusicBrainz::Server::Data::CoreEntity::_delete_and_redirect_gids('MusicBrainz::Server::Data::Area=HASH(0x9b264c8)', 'area', 9621, 5164) called at /home/musicbrainz/musicbrainz-server/admin/../lib/MusicBrainz/Server/Data/Area.pm line 286
      	MusicBrainz::Server::Data::Area::_merge_impl('MusicBrainz::Server::Data::Area=HASH(0x9b264c8)', 9621, 5164) called at /home/musicbrainz/musicbrainz-server/admin/../lib/MusicBrainz/Server/Data/Role/Merge.pm line 30
      	Class::MOP::Class:::around('CODE(0x4749fa8)', 'MusicBrainz::Server::Data::Area=HASH(0x9b264c8)', 9621, 5164) called at local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 162
      	Class::MOP::Method::Wrapped::__ANON__('MusicBrainz::Server::Data::Area=HASH(0x9b264c8)', 9621, 5164) called at local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 56
      	Class::MOP::Method::Wrapped::__ANON__('MusicBrainz::Server::Data::Area=HASH(0x9b264c8)', 9621, 5164) called at local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 91
      	MusicBrainz::Server::Data::Area::merge('MusicBrainz::Server::Data::Area=HASH(0x9b264c8)', 9621, 5164) called at /home/musicbrainz/musicbrainz-server/admin/../lib/MusicBrainz/Server/Edit/Generic/Merge.pm line 101
      	MusicBrainz::Server::Edit::Generic::Merge::do_merge('MusicBrainz::Server::Edit::Area::Merge=HASH(0xa3ad940)') called at /home/musicbrainz/musicbrainz-server/admin/../lib/MusicBrainz/Server/Edit/Generic/Merge.pm line 94
      	MusicBrainz::Server::Edit::Generic::Merge::accept('MusicBrainz::Server::Edit::Area::Merge=HASH(0xa3ad940)') called at /home/musicbrainz/musicbrainz-server/admin/../lib/MusicBrainz/Server/Data/Edit.pm line 565
      	MusicBrainz::Server::Data::Edit::__ANON__() called at local/lib/perl5/Try/Tiny.pm line 71
      	eval {...} called at local/lib/perl5/Try/Tiny.pm line 67
      	Try::Tiny::try('CODE(0x9b3da40)', 'Try::Tiny::Catch=REF(0x9b6b000)') called at /home/musicbrainz/musicbrainz-server/admin/../lib/MusicBrainz/Server/Data/Edit.pm line 591
      	MusicBrainz::Server::Data::Edit::_do_accept('MusicBrainz::Server::Data::Edit=HASH(0x3db2b38)', 'MusicBrainz::Server::Edit::Area::Merge=HASH(0xa3ad940)') called at /home/musicbrainz/musicbrainz-server/admin/../lib/MusicBrainz/Server/Data/Edit.pm line 630
      	MusicBrainz::Server::Data::Edit::__ANON__('MusicBrainz::Server::Edit::Area::Merge=HASH(0xa3ad940)') called at /home/musicbrainz/musicbrainz-server/admin/../lib/MusicBrainz/Server/Data/Edit.pm line 653
      	MusicBrainz::Server::Data::Edit::_close('MusicBrainz::Server::Data::Edit=HASH(0x3db2b38)', 'MusicBrainz::Server::Edit::Area::Merge=HASH(0xa3ad940)', 'CODE(0x9b6abf8)') called at /home/musicbrainz/musicbrainz-server/admin/../lib/MusicBrainz/Server/Data/Edit.pm line 630
      	MusicBrainz::Server::Data::Edit::accept('MusicBrainz::Server::Data::Edit=HASH(0x3db2b38)', 'MusicBrainz::Server::Edit::Area::Merge=HASH(0xa3ad940)') called at /home/musicbrainz/musicbrainz-server/admin/../lib/MusicBrainz/Server/EditQueue.pm line 157
      	MusicBrainz::Server::EditQueue::_process_open_edit('MusicBrainz::Server::EditQueue=HASH(0x39d4f00)', 'MusicBrainz::Server::Edit::Area::Merge=HASH(0xa3ad940)') called at /home/musicbrainz/musicbrainz-server/admin/../lib/MusicBrainz/Server/EditQueue.pm line 119
      	MusicBrainz::Server::EditQueue::_process_edit('MusicBrainz::Server::EditQueue=HASH(0x39d4f00)', 22902598) called at /home/musicbrainz/musicbrainz-server/admin/../lib/MusicBrainz/Server/EditQueue.pm line 76
      	MusicBrainz::Server::EditQueue::__ANON__() called at /home/musicbrainz/musicbrainz-server/admin/../lib/Sql.pm line 307
      	Sql::__ANON__() called at local/lib/perl5/Try/Tiny.pm line 76
      	eval {...} called at local/lib/perl5/Try/Tiny.pm line 67
      	Try::Tiny::try('CODE(0x9b7b5e8)', 'Try::Tiny::Catch=REF(0xa1b4c78)') called at /home/musicbrainz/musicbrainz-server/admin/../lib/Sql.pm line 320
      	Sql::_auto_transaction('CODE(0x3c75170)', 'Sql=HASH(0x3a0c6e0)') called at /home/musicbrainz/musicbrainz-server/admin/../lib/Sql.pm line 325
      	Sql::_run_in_transaction_one('CODE(0x3c75170)', 'Sql=HASH(0x3a0c6e0)') called at /home/musicbrainz/musicbrainz-server/admin/../lib/Sql.pm line 339
      	Sql::run_in_transaction('CODE(0x3c75170)', 'Sql=HASH(0x3a0c6e0)') called at /home/musicbrainz/musicbrainz-server/admin/../lib/MusicBrainz/Server/EditQueue.pm line 77
      	MusicBrainz::Server::EditQueue::__ANON__() called at local/lib/perl5/Try/Tiny.pm line 76
      	eval {...} called at local/lib/perl5/Try/Tiny.pm line 67
      	Try::Tiny::try('CODE(0x3b8eb78)', 'Try::Tiny::Catch=REF(0x9b26048)') called at /home/musicbrainz/musicbrainz-server/admin/../lib/MusicBrainz/Server/EditQueue.pm line 85
      	MusicBrainz::Server::EditQueue::process_edits('MusicBrainz::Server::EditQueue=HASH(0x39d4f00)') called at ./admin/CheckVotes.pl line 56
      Error while processing edit #22902598: DBD::Pg::st execute failed: ERROR:  update or delete on table "area" violates foreign key constraint "artist_fk_area" on table "artist"
      DETAIL:  Key (id)=(5164) is still referenced from table "artist". at /home/musicbrainz/musicbrainz-server/admin/../lib/Sql.pm line 440.
       at /home/musicbrainz/musicbrainz-server/admin/../lib/Sql.pm line 455.
      	Sql::__ANON__('DBD::Pg::st execute failed: ERROR:  update or delete on table...') called at local/lib/perl5/Try/Tiny.pm line 100
      	Try::Tiny::try('CODE(0xa3cb6b8)', 'Try::Tiny::Catch=REF(0xa511a50)') called at /home/musicbrainz/musicbrainz-server/admin/../lib/Sql.pm line 456
      	Sql::_select_list('Sql=HASH(0x3a0c6e0)', '\x{a}        DELETE FROM area\x{a}        WHERE id IN (?)\x{a}        RET...', 'ARRAY(0xa511d68)', 'arrayref', 'CODE(0x3bb10b0)') called at /home/musicbrainz/musicbrainz-server/admin/../lib/Sql.pm line 475
      	Sql::select_list_of_lists('Sql=HASH(0x3a0c6e0)', '\x{a}        DELETE FROM area\x{a}        WHERE id IN (?)\x{a}        RET...', 5164) called at /home/musicbrainz/musicbrainz-server/admin/../lib/Sql.pm line 408
      	Sql::select_single_column_array('Sql=HASH(0x3a0c6e0)', '\x{a}        DELETE FROM area\x{a}        WHERE id IN (?)\x{a}        RET...', 5164) called at /home/musicbrainz/musicbrainz-server/admin/../lib/MusicBrainz/Server/Data/CoreEntity.pm line 159
      	MusicBrainz::Server::Data::CoreEntity::_delete_and_redirect_gids('MusicBrainz::Server::Data::Area=HASH(0x9b264c8)', 'area', 9621, 5164) called at /home/musicbrainz/musicbrainz-server/admin/../lib/MusicBrainz/Server/Data/Area.pm line 286
      	MusicBrainz::Server::Data::Area::_merge_impl('MusicBrainz::Server::Data::Area=HASH(0x9b264c8)', 9621, 5164) called at /home/musicbrainz/musicbrainz-server/admin/../lib/MusicBrainz/Server/Data/Role/Merge.pm line 30
      	Class::MOP::Class:::around('CODE(0x4749fa8)', 'MusicBrainz::Server::Data::Area=HASH(0x9b264c8)', 9621, 5164) called at local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 162
      	Class::MOP::Method::Wrapped::__ANON__('MusicBrainz::Server::Data::Area=HASH(0x9b264c8)', 9621, 5164) called at local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 56
      	Class::MOP::Method::Wrapped::__ANON__('MusicBrainz::Server::Data::Area=HASH(0x9b264c8)', 9621, 5164) called at local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 91
      	MusicBrainz::Server::Data::Area::merge('MusicBrainz::Server::Data::Area=HASH(0x9b264c8)', 9621, 5164) called at /home/musicbrainz/musicbrainz-server/admin/../lib/MusicBrainz/Server/Edit/Generic/Merge.pm line 101
      	MusicBrainz::Server::Edit::Generic::Merge::do_merge('MusicBrainz::Server::Edit::Area::Merge=HASH(0xa3ad940)') called at /home/musicbrainz/musicbrainz-server/admin/../lib/MusicBrainz/Server/Edit/Generic/Merge.pm line 94
      	MusicBrainz::Server::Edit::Generic::Merge::accept('MusicBrainz::Server::Edit::Area::Merge=HASH(0xa3ad940)') called at /home/musicbrainz/musicbrainz-server/admin/../lib/MusicBrainz/Server/Data/Edit.pm line 565
      	MusicBrainz::Server::Data::Edit::__ANON__() called at local/lib/perl5/Try/Tiny.pm line 71
      	eval {...} called at local/lib/perl5/Try/Tiny.pm line 67
      	Try::Tiny::try('CODE(0x9b3da40)', 'Try::Tiny::Catch=REF(0x9b6b000)') called at /home/musicbrainz/musicbrainz-server/admin/../lib/MusicBrainz/Server/Data/Edit.pm line 591
      	MusicBrainz::Server::Data::Edit::_do_accept('MusicBrainz::Server::Data::Edit=HASH(0x3db2b38)', 'MusicBrainz::Server::Edit::Area::Merge=HASH(0xa3ad940)') called at /home/musicbrainz/musicbrainz-server/admin/../lib/MusicBrainz/Server/Data/Edit.pm line 630
      	MusicBrainz::Server::Data::Edit::__ANON__('MusicBrainz::Server::Edit::Area::Merge=HASH(0xa3ad940)') called at /home/musicbrainz/musicbrainz-server/admin/../lib/MusicBrainz/Server/Data/Edit.pm line 653
      	MusicBrainz::Server::Data::Edit::_close('MusicBrainz::Server::Data::Edit=HASH(0x3db2b38)', 'MusicBrainz::Server::Edit::Area::Merge=HASH(0xa3ad940)', 'CODE(0x9b6abf8)') called at /home/musicbrainz/musicbrainz-server/admin/../lib/MusicBrainz/Server/Data/Edit.pm line 630
      	MusicBrainz::Server::Data::Edit::accept('MusicBrainz::Server::Data::Edit=HASH(0x3db2b38)', 'MusicBrainz::Server::Edit::Area::Merge=HASH(0xa3ad940)') called at /home/musicbrainz/musicbrainz-server/admin/../lib/MusicBrainz/Server/EditQueue.pm line 157
      	MusicBrainz::Server::EditQueue::_process_open_edit('MusicBrainz::Server::EditQueue=HASH(0x39d4f00)', 'MusicBrainz::Server::Edit::Area::Merge=HASH(0xa3ad940)') called at /home/musicbrainz/musicbrainz-server/admin/../lib/MusicBrainz/Server/EditQueue.pm line 119
      	MusicBrainz::Server::EditQueue::_process_edit('MusicBrainz::Server::EditQueue=HASH(0x39d4f00)', 22902598) called at /home/musicbrainz/musicbrainz-server/admin/../lib/MusicBrainz/Server/EditQueue.pm line 76
      	MusicBrainz::Server::EditQueue::__ANON__() called at /home/musicbrainz/musicbrainz-server/admin/../lib/Sql.pm line 307
      	Sql::__ANON__() called at local/lib/perl5/Try/Tiny.pm line 76
      	eval {...} called at local/lib/perl5/Try/Tiny.pm line 67
      	Try::Tiny::try('CODE(0x9b7b5e8)', 'Try::Tiny::Catch=REF(0xa1b4c78)') called at /home/musicbrainz/musicbrainz-server/admin/../lib/Sql.pm line 320
      	Sql::_auto_transaction('CODE(0x3c75170)', 'Sql=HASH(0x3a0c6e0)') called at /home/musicbrainz/musicbrainz-server/admin/../lib/Sql.pm line 325
      	Sql::_run_in_transaction_one('CODE(0x3c75170)', 'Sql=HASH(0x3a0c6e0)') called at /home/musicbrainz/musicbrainz-server/admin/../lib/Sql.pm line 339
      	Sql::run_in_transaction('CODE(0x3c75170)', 'Sql=HASH(0x3a0c6e0)') called at /home/musicbrainz/musicbrainz-server/admin/../lib/MusicBrainz/Server/EditQueue.pm line 77
      	MusicBrainz::Server::EditQueue::__ANON__() called at local/lib/perl5/Try/Tiny.pm line 76
      	eval {...} called at local/lib/perl5/Try/Tiny.pm line 67
      	Try::Tiny::try('CODE(0x3b8eb78)', 'Try::Tiny::Catch=REF(0x9b26048)') called at /home/musicbrainz/musicbrainz-server/admin/../lib/MusicBrainz/Server/EditQueue.pm line 85
      	MusicBrainz::Server::EditQueue::process_edits('MusicBrainz::Server::EditQueue=HASH(0x39d4f00)') called at ./admin/CheckVotes.pl line 56
       at /home/musicbrainz/musicbrainz-server/admin/../lib/Sql.pm line 320.
      

        Attachments

          Activity

            People

            • Assignee:
              acid2 Oliver Charles
              Reporter:
              acid2 Oliver Charles
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Packages

                Version Package
                2013-07-22