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

Internal server error when adding new artist in the release editor with same name/comment as existing artist

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2014-02-17
    • Component/s: Release editor
    • Labels:
      None

      Description

      Attempt to add a new artist in the release editor with the same name and comment as an existing artist, it crashes.

      Fehler:

      Caught exception in MusicBrainz::Server::Controller::ReleaseEditor::Add->add "DBD::Pg::st execute failed: ERROR: duplicate key value violates unique constraint "artist_idx_uniq_name_comment"
      DETAIL: Key (name, comment)=(544045, Special Purpose Artist - MusicBrainz Test Artist) already exists. at lib/Sql.pm line 414, line 13.
      at lib/Sql.pm line 429, line 13.
      Sql::_ANON_('DBD::Pg::st execute failed: ERROR: duplicate key value viola...') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Try/Tiny.pm line 100
      Try::Tiny::try('CODE(0x1017ff58)', 'Try::Tiny::Catch=REF(0x10e348f8)') called at lib/Sql.pm line 430
      Sql::_select_list('Sql=HASH(0xdd6a698)', 'INSERT INTO artist (comment,name,sort_name,gid) VALUES (?,?,?...', 'ARRAY(0x58f6770)', 'arrayref', 'CODE(0x58f67e8)') called at lib/Sql.pm line 449
      Sql::select_list_of_lists('Sql=HASH(0xdd6a698)', 'INSERT INTO artist (comment,name,sort_name,gid) VALUES (?,?,?...', 'Special Purpose Artist - MusicBrainz Test Artist', 544045, 544045, 'b4f9eaf4-8eec-439d-a6c7-9582cc99fec5') called at lib/Sql.pm line 382
      Sql::select_single_column_array('Sql=HASH(0xdd6a698)', 'INSERT INTO artist (comment,name,sort_name,gid) VALUES (?,?,?...', 'Special Purpose Artist - MusicBrainz Test Artist', 544045, 544045, 'b4f9eaf4-8eec-439d-a6c7-9582cc99fec5') called at lib/Sql.pm line 397
      Sql::select_single_value('Sql=HASH(0xdd6a698)', 'INSERT INTO artist (comment,name,sort_name,gid) VALUES (?,?,?...', 'Special Purpose Artist - MusicBrainz Test Artist', 544045, 544045, 'b4f9eaf4-8eec-439d-a6c7-9582cc99fec5') called at lib/Sql.pm line 150
      Sql::insert_row('Sql=HASH(0xdd6a698)', 'artist', 'HASH(0x59a3658)', 'id') called at lib/MusicBrainz/Server/Data/Artist.pm line 214
      MusicBrainz::Server::Data::Artist::insert('MusicBrainz::Server::Data::Artist=HASH(0xb5e3628)', 'HASH(0x10e23d28)') called at lib/MusicBrainz/Server/Edit/Generic/Create.pm line 45
      MusicBrainz::Server::Edit::Generic::Create::insert('MusicBrainz::Server::Edit::Artist::Create=HASH(0xe71ead0)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 56
      Class::MOP::Method::Wrapped::_ANON_('MusicBrainz::Server::Edit::Artist::Create=HASH(0xe71ead0)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 91
      MusicBrainz::Server::Edit::Artist::Create::insert('MusicBrainz::Server::Edit::Artist::Create=HASH(0xe71ead0)') called at lib/MusicBrainz/Server/Data/Edit.pm line 433
      MusicBrainz::Server::Data::Edit::create('MusicBrainz::Server::Data::Edit=HASH(0xbb4d090)', 'edit_type', 1, 'editor_id', 53705, 'privileges', 184, 'comment', 'Special Purpose Artist - MusicBrainz Test Artist', ...) called at lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 1326
      MusicBrainz::Server::Wizard::ReleaseEditor::_ANON_('edit_type', 1, 'editor_id', 53705, 'privileges', 184, 'comment', 'Special Purpose Artist - MusicBrainz Test Artist', 'name', ...) called at lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 1353
      MusicBrainz::Server::Wizard::ReleaseEditor::_ANON_() called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Try/Tiny.pm line 76
      eval

      Unknown macro: {...}

      called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Try/Tiny.pm line 67
      Try::Tiny::try('CODE(0xe71dd20)', 'Try::Tiny::Catch=REF(0xe71e9f8)') called at lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 1362
      MusicBrainz::Server::Wizard::ReleaseEditor::_create_edit('MusicBrainz::Server::Wizard::ReleaseEditor::Add=HASH(0xdf56568)', 'CODE(0xe71eef0)', 1, 53705, 'privileges', 184, 'comment', 'Special Purpose Artist - MusicBrainz Test Artist', 'name', ...) called at lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 1327
      MusicBrainz::Server::Wizard::ReleaseEditor::_submit_edit('MusicBrainz::Server::Wizard::ReleaseEditor::Add=HASH(0xdf56568)', 1, 'test', 'as_auto_editor', 0, 'name', 'MusicBrainz Test Artist', 'sort_name', 'MusicBrainz Test Artist', ...) called at lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 864
      MusicBrainz::Server::Wizard::ReleaseEditor::_ANON_(1, 'test', 'as_auto_editor', 0, 'name', 'MusicBrainz Test Artist', 'sort_name', 'MusicBrainz Test Artist', 'comment', ...) called at lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 1017
      MusicBrainz::Server::Wizard::ReleaseEditor::_edit_missing_entities('MusicBrainz::Server::Wizard::ReleaseEditor::Add=HASH(0xdf56568)', 'edit_note', 'test', 'data', 'HASH(0xe71e638)', 'create_edit', 'CODE(0xe66e028)', 'previewing', '', ...) called at lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 920
      MusicBrainz::Server::Wizard::ReleaseEditor::create_edits('MusicBrainz::Server::Wizard::ReleaseEditor::Add=HASH(0xdf56568)', 'data', 'HASH(0xe71e638)', 'create_edit', 'CODE(0xe66e028)', 'edit_note', 'test', 'previewing', '', ...) called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/x86_64-linux-gnu-thread-multi/Moose/Meta/Method/Augmented.pm line 48
      MusicBrainz::Server::Wizard::ReleaseEditor::Add::create_edits('MusicBrainz::Server::Wizard::ReleaseEditor::Add=HASH(0xdf56568)', 'data', 'HASH(0xe71e638)', 'create_edit', 'CODE(0xe66e028)', 'edit_note', 'test', 'previewing', '', ...) called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 56
      Class::MOP::Method::Wrapped::_ANON_('MusicBrainz::Server::Wizard::ReleaseEditor::Add=HASH(0xdf56568)', 'data', 'HASH(0xe71e638)', 'create_edit', 'CODE(0xe66e028)', 'edit_note', 'test', 'previewing', '', ...) called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 91
      MusicBrainz::Server::Wizard::ReleaseEditor::Add::create_edits('MusicBrainz::Server::Wizard::ReleaseEditor::Add=HASH(0xdf56568)', 'data', 'HASH(0xe71e638)', 'create_edit', 'CODE(0xe66e028)', 'edit_note', 'test', 'previewing', '', ...) called at lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 865
      MusicBrainz::Server::Wizard::ReleaseEditor::prepare_edits('MusicBrainz::Server::Wizard::ReleaseEditor::Add=HASH(0xdf56568)') called at lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 95
      MusicBrainz::Server::Wizard::ReleaseEditor::run('MusicBrainz::Server::Wizard::ReleaseEditor::Add=HASH(0xdf56568)') called at lib/MusicBrainz/Server/Controller/ReleaseEditor/Add.pm line 23
      MusicBrainz::Server::Controller::ReleaseEditor::Add::add('MusicBrainz::Server::Controller::ReleaseEditor::Add=HASH(0xcd...', 'MusicBrainz::Server=HASH(0xda57818)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute('Catalyst::Action=HASH(0xd127778)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add=HASH(0xcd...', 'MusicBrainz::Server=HASH(0xda57818)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst.pm line 1672
      eval

      called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst.pm line 1672
      Catalyst::execute('MusicBrainz::Server=HASH(0xda57818)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add', 'Catalyst::Action=HASH(0xd127778)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xda57818)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add', 'Catalyst::Action=HASH(0xd127778)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch('Catalyst::Action=HASH(0xd127778)', 'MusicBrainz::Server=HASH(0xda57818)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Controller.pm line 158
      Catalyst::Controller::_ACTION('MusicBrainz::Server::Controller::ReleaseEditor::Add=HASH(0xcd...', 'MusicBrainz::Server=HASH(0xda57818)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute('Catalyst::Action=HASH(0xcfc2b30)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add=HASH(0xcd...', 'MusicBrainz::Server=HASH(0xda57818)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst.pm line 1672
      eval

      Unknown macro: {...}

      called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst.pm line 1672
      Catalyst::execute('MusicBrainz::Server=HASH(0xda57818)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add', 'Catalyst::Action=HASH(0xcfc2b30)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xda57818)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add', 'Catalyst::Action=HASH(0xcfc2b30)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch('Catalyst::Action=HASH(0xcfc2b30)', 'MusicBrainz::Server=HASH(0xda57818)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Dispatcher.pm line 257
      Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x4804da0)', 'forward', 'MusicBrainz::Server=HASH(0xda57818)', '_ACTION') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Dispatcher.pm line 237
      Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x4804da0)', 'MusicBrainz::Server=HASH(0xda57818)', '_ACTION') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst.pm line 362
      Catalyst::forward('MusicBrainz::Server=HASH(0xda57818)', '_ACTION') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Controller.pm line 132
      Catalyst::Controller::_DISPATCH('MusicBrainz::Server::Controller::ReleaseEditor::Add=HASH(0xcd...', 'MusicBrainz::Server=HASH(0xda57818)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute('Catalyst::Action=HASH(0xd1389e0)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add=HASH(0xcd...', 'MusicBrainz::Server=HASH(0xda57818)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst.pm line 1672
      eval

      called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst.pm line 1672
      Catalyst::execute('MusicBrainz::Server=HASH(0xda57818)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add', 'Catalyst::Action=HASH(0xd1389e0)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xda57818)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add', 'Catalyst::Action=HASH(0xd1389e0)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch('Catalyst::Action=HASH(0xd1389e0)', 'MusicBrainz::Server=HASH(0xda57818)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Dispatcher.pm line 257
      Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x4804da0)', 'forward', 'MusicBrainz::Server=HASH(0xda57818)', '/release_editor/_DISPATCH') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Dispatcher.pm line 237
      Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x4804da0)', 'MusicBrainz::Server=HASH(0xda57818)', '/release_editor/_DISPATCH') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst.pm line 362
      Catalyst::forward('MusicBrainz::Server=HASH(0xda57818)', '/release_editor/_DISPATCH') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Dispatcher.pm line 105
      Catalyst::Dispatcher::dispatch('Catalyst::Dispatcher=HASH(0x4804da0)', 'MusicBrainz::Server=HASH(0xda57818)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst.pm line 1618
      Catalyst::dispatch('MusicBrainz::Server=HASH(0xda57818)') called at lib/MusicBrainz/Server.pm line 326
      MusicBrainz::Server::_ANON_() called at lib/MusicBrainz/Server.pm line 300
      MusicBrainz::Server::with_translations('MusicBrainz::Server=HASH(0xda57818)', 'CODE(0xda57b90)') called at lib/MusicBrainz/Server.pm line 327
      Class::MOP::Class:::around('CODE(0x3bc1f10)', 'MusicBrainz::Server=HASH(0xda57818)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 162
      Class::MOP::Method::Wrapped::_ANON_('MusicBrainz::Server=HASH(0xda57818)') called at lib/MusicBrainz/Server.pm line 341
      Class::MOP::Class:::around('CODE(0xd322670)', 'MusicBrainz::Server=HASH(0xda57818)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 162
      Class::MOP::Method::Wrapped::_ANON_('MusicBrainz::Server=HASH(0xda57818)') called at lib/MusicBrainz/Server.pm line 386
      Class::MOP::Class:::around('CODE(0xd33d6d8)', 'MusicBrainz::Server=HASH(0xda57818)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 162
      Class::MOP::Method::Wrapped::_ANON_('MusicBrainz::Server=HASH(0xda57818)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 35
      Class::MOP::Method::Wrapped::_ANON_('MusicBrainz::Server=HASH(0xda57818)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 91
      MusicBrainz::Server::dispatch('MusicBrainz::Server=HASH(0xda57818)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst.pm line 1968
      Catalyst::_ANON_() called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Try/Tiny.pm line 76
      eval

      Unknown macro: {...}

      called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Try/Tiny.pm line 67
      Try::Tiny::try('CODE(0xd90e5e8)', 'Try::Tiny::Catch=REF(0xda59950)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst.pm line 1974
      Catalyst::handle_request('MusicBrainz::Server', 'env', 'HASH(0xd5a7a98)', 'response_cb', 'CODE(0xd3e2b18)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Plugin/AutoRestart.pm line 117
      Catalyst::Plugin::AutoRestart::handle_request('MusicBrainz::Server', 'env', 'HASH(0xd5a7a98)', 'response_cb', 'CODE(0xd3e2b18)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Engine.pm line 688
      Catalyst::Engine::_ANON_('CODE(0xd3e2b18)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Plack/Handler/FCGI.pm line 130
      Plack::Handler::FCGI::run('Plack::Handler::FCGI=HASH(0x1a2deb8)', 'CODE(0xd343178)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Plack/Loader.pm line 84
      Plack::Loader::run('Plack::Loader=HASH(0x1955290)', 'Plack::Handler::FCGI=HASH(0x1a2deb8)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Plack/Runner.pm line 267
      Plack::Runner::run('Plack::Runner=HASH(0x17d7700)') called at /home/beta/musicbrainz-server/admin/../local/bin/plackup line 10"

      Stack-Trace:
      line 1361 MusicBrainz::Server::Wizard::ReleaseEditor
      line 1362 MusicBrainz::Server::Wizard::ReleaseEditor
      line 1327 MusicBrainz::Server::Wizard::ReleaseEditor
      line 864 MusicBrainz::Server::Wizard::ReleaseEditor
      line 1017 MusicBrainz::Server::Wizard::ReleaseEditor
      line 920 MusicBrainz::Server::Wizard::ReleaseEditor
      line 865 MusicBrainz::Server::Wizard::ReleaseEditor
      line 95 MusicBrainz::Server::Wizard::ReleaseEditor
      line 23 MusicBrainz::Server::Controller::ReleaseEditor::Add
      line 326 MusicBrainz::Server
      line 300 MusicBrainz::Server
      line 327 MusicBrainz::Server
      line 341 MusicBrainz::Server
      line 386 MusicBrainz::Server

      Anfragedaten:
      $VAR1 = {
      'query_parameters' => {},
      'body_parameters' =>

      Unknown macro: { 'save' => 'Bearbeitung eingeben', 'wizard_page_id' => '5', 'edit_note' => 'test', 'id' => '', 'wizard_session_id' => '806' }

      };

      Host: pino

      Oberflächensprache: de

      URL: https://beta.musicbrainz.org/release/add

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Due:
                  Created:
                  Updated:
                  Resolved:

                  Packages

                  Version Package
                  2014-02-17