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

ISE when splitting disc in half

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      Internal Server Error

      Oops, something went wrong!

      Error:

      Caught exception in MusicBrainz::Server::Controller::ReleaseEditor::Edit->edit "DBD::Pg::st execute failed: ERROR: insert or update on table "track" violates foreign key constraint "track_fk_recording"
      DETAIL: Key (recording)=(7620097) is not present in table "recording". at lib/Sql.pm line 409.
      at lib/Sql.pm line 423
      Sql::_ANON_('DBD::Pg::st execute failed: ERROR: insert or update on table...') called at local/lib/perl5/Try/Tiny.pm line 100
      Try::Tiny::try('CODE(0xf908070)', 'Try::Tiny::Catch=REF(0xf8ee0e0)') called at lib/Sql.pm line 424
      Sql::_select_list('Sql=HASH(0xc48ade8)', 'INSERT INTO track (length,number,recording,name,position,arti...', 'ARRAY(0xf8f24f0)', 'arrayref', 'CODE(0x54b0630)') called at lib/Sql.pm line 443
      Sql::select_list_of_lists('Sql=HASH(0xc48ade8)', 'INSERT INTO track (length,number,recording,name,position,arti...', 195000, 1, 7620097, 3541814, 1, 875032, 1265961, ...) called at lib/Sql.pm line 377
      Sql::select_single_column_array('Sql=HASH(0xc48ade8)', 'INSERT INTO track (length,number,recording,name,position,arti...', 195000, 1, 7620097, 3541814, 1, 875032, 1265961, ...) called at lib/Sql.pm line 392
      Sql::select_single_value('Sql=HASH(0xc48ade8)', 'INSERT INTO track (length,number,recording,name,position,arti...', 195000, 1, 7620097, 3541814, 1, 875032, 1265961, ...) called at lib/Sql.pm line 146
      Sql::insert_row('Sql=HASH(0xc48ade8)', 'track', 'HASH(0xf8e5708)', 'id') called at lib/MusicBrainz/Server/Data/Track.pm line 145
      MusicBrainz::Server::Data::Track::insert('MusicBrainz::Server::Data::Track=HASH(0xb64b6e8)', 'HASH(0xf8f4c70)', 'HASH(0xf90b4d8)', 'HASH(0xf8f8a10)', 'HASH(0xf90c0f0)', 'HASH(0xf902d80)', 'HASH(0xf903830)', 'HASH(0xf8f8128)', 'HASH(0xf90d778)', ...) called at lib/MusicBrainz/Server/Data/Tracklist.pm line 71
      MusicBrainz::Server::Data::Tracklist::_add_tracks('MusicBrainz::Server::Data::Tracklist=HASH(0xb643540)', 1265961, 'ARRAY(0xf8dae40)') called at lib/MusicBrainz/Server/Data/Tracklist.pm line 31
      MusicBrainz::Server::Data::Tracklist::insert('MusicBrainz::Server::Data::Tracklist=HASH(0xb643540)', 'ARRAY(0xf8dae40)') called at lib/MusicBrainz/Server/Data/Tracklist.pm line 259
      MusicBrainz::Server::Data::Tracklist::find_or_insert('MusicBrainz::Server::Data::Tracklist=HASH(0xb643540)', 'ARRAY(0xf8dae40)') called at lib/MusicBrainz/Server/Edit/Medium/Create.pm line 139
      MusicBrainz::Server::Edit::Medium::Create::_insert_hash('MusicBrainz::Server::Edit::Medium::Create=HASH(0xf8e1d20)', 'HASH(0xf8df0f8)') called at lib/MusicBrainz/Server/Edit/Generic/Create.pm line 44
      MusicBrainz::Server::Edit::Generic::Create::insert('MusicBrainz::Server::Edit::Medium::Create=HASH(0xf8e1d20)') called at lib/MusicBrainz/Server/Data/Edit.pm line 388
      MusicBrainz::Server::Data::Edit::_ANON_() called at lib/Sql.pm line 277
      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(0xf8d8908)', 'Try::Tiny::Catch=REF(0xf8e1cf0)') called at lib/Sql.pm line 290
      Sql::_auto_transaction('CODE(0xf8d82f0)', 'Sql=HASH(0xc48ade8)') called at lib/Sql.pm line 295
      Sql::_run_in_transaction_one('CODE(0xf8d82f0)', 'Sql=HASH(0xc48ade8)') called at lib/Sql.pm line 309
      Sql::run_in_transaction('CODE(0xf8d82f0)', 'Sql=HASH(0xc48ade8)') called at lib/MusicBrainz/Server/Data/Edit.pm line 436
      MusicBrainz::Server::Data::Edit::create('MusicBrainz::Server::Data::Edit=HASH(0xa73dd80)', 'edit_type', 51, 'editor_id', 388788, 'format_id', 7, 'privileges', 1, ...) called at lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 1235
      MusicBrainz::Server::Wizard::ReleaseEditor::_ANON_('edit_type', 51, 'editor_id', 388788, 'format_id', 7, 'privileges', 1, 'position', ...) called at lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 1262
      MusicBrainz::Server::Wizard::ReleaseEditor::_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(0xf8e1198)', 'Try::Tiny::Catch=REF(0xf9119a8)') called at lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 1271
      MusicBrainz::Server::Wizard::ReleaseEditor::_create_edit('MusicBrainz::Server::Wizard::ReleaseEditor::Edit=HASH(0xcacf108)', 'CODE(0xd54f3e8)', 51, 388788, 'privileges', 1, 'format_id', 7, 'position', ...) called at lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 1236
      MusicBrainz::Server::Wizard::ReleaseEditor::_submit_edit('MusicBrainz::Server::Wizard::ReleaseEditor::Edit=HASH(0xcacf108)', 51, 'Splitting into 2 discs.

      http://www.discogs.com/Various-Bum...', 'format_id', 7, 'position', 2, 'release', 'MusicBrainz::Server::Entity::Release=HASH(0xcea6978)', ...) called at lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 823
      MusicBrainz::Server::Wizard::ReleaseEditor::_ANON_(51, 'Splitting into 2 discs.

      http://www.discogs.com/Various-Bum...', 'format_id', 7, 'position', 2, 'release', 'MusicBrainz::Server::Entity::Release=HASH(0xcea6978)', 'tracklist', ...) called at lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 1155
      MusicBrainz::Server::Wizard::ReleaseEditor::_edit_release_track_edits('MusicBrainz::Server::Wizard::ReleaseEditor::Edit=HASH(0xcacf108)', 'edit_note', 'Splitting into 2 discs.

      http://www.discogs.com/Various-Bum...', 'data', 'HASH(0xd4d89b0)', 'create_edit', 'CODE(0xd427c48)', 'previewing', '', ...) called at lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 918
      MusicBrainz::Server::Wizard::ReleaseEditor::create_common_edits('MusicBrainz::Server::Wizard::ReleaseEditor::Edit=HASH(0xcacf108)', 'edit_note', 'Splitting into 2 discs.

      http://www.discogs.com/Various-Bum...', 'data', 'HASH(0xd4d89b0)', 'create_edit', 'CODE(0xd427c48)', 'previewing', '', ...) called at lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 898
      MusicBrainz::Server::Wizard::ReleaseEditor::create_edits('MusicBrainz::Server::Wizard::ReleaseEditor::Edit=HASH(0xcacf108)', 'data', 'HASH(0xd4d89b0)', 'create_edit', 'CODE(0xd427c48)', 'edit_note', 'Splitting into 2 discs.

      http://www.discogs.com/Various-Bum...', 'previewing', '', ...) called at local/lib/perl5/x86_64-linux-gnu-thread-multi/Moose/Meta/Method/Augmented.pm line 48
      MusicBrainz::Server::Wizard::ReleaseEditor::Edit::create_edits('MusicBrainz::Server::Wizard::ReleaseEditor::Edit=HASH(0xcacf108)', 'data', 'HASH(0xd4d89b0)', 'create_edit', 'CODE(0xd427c48)', 'edit_note', 'Splitting into 2 discs.

      http://www.discogs.com/Various-Bum...', 'previewing', '', ...) called at lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 824
      MusicBrainz::Server::Wizard::ReleaseEditor::prepare_edits('MusicBrainz::Server::Wizard::ReleaseEditor::Edit=HASH(0xcacf108)') called at lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 94
      MusicBrainz::Server::Wizard::ReleaseEditor::run('MusicBrainz::Server::Wizard::ReleaseEditor::Edit=HASH(0xcacf108)') called at lib/MusicBrainz/Server/Controller/ReleaseEditor/Edit.pm line 17
      MusicBrainz::Server::Controller::ReleaseEditor::Edit::edit('MusicBrainz::Server::Controller::ReleaseEditor::Edit=HASH(0xb...', 'MusicBrainz::Server=HASH(0xc340b50)') called at local/lib/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute('Catalyst::Action=HASH(0xbf3eb00)', 'MusicBrainz::Server::Controller::ReleaseEditor::Edit=HASH(0xb...', 'MusicBrainz::Server=HASH(0xc340b50)') called at local/lib/perl5/Catalyst.pm line 1667
      eval

      {...} called at local/lib/perl5/Catalyst.pm line 1667
      Catalyst::execute('MusicBrainz::Server=HASH(0xc340b50)', 'MusicBrainz::Server::Controller::ReleaseEditor::Edit', 'Catalyst::Action=HASH(0xbf3eb00)') called at local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xc340b50)', 'MusicBrainz::Server::Controller::ReleaseEditor::Edit', 'Catalyst::Action=HASH(0xbf3eb00)') called at lib/MusicBrainz/Server.pm line 298
      MusicBrainz::Server::execute('MusicBrainz::Server=HASH(0xc340b50)', 'MusicBrainz::Server::Controller::ReleaseEditor::Edit', 'Catalyst::Action=HASH(0xbf3eb00)') called at local/lib/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch('Catalyst::Action=HASH(0xbf3eb00)', 'MusicBrainz::Server=HASH(0xc340b50)') called at local/lib/perl5/Catalyst/ActionChain.pm line 38
      Catalyst::ActionChain::dispatch('Catalyst::ActionChain=HASH(0xc729f58)', 'MusicBrainz::Server=HASH(0xc340b50)') called at local/lib/perl5/Catalyst/Controller.pm line 125
      Catalyst::Controller::_ACTION('MusicBrainz::Server::Controller::ReleaseEditor::Add=HASH(0xbd...', 'MusicBrainz::Server=HASH(0xc340b50)') called at local/lib/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute('Catalyst::Action=HASH(0xbf3e5a8)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add=HASH(0xbd...', 'MusicBrainz::Server=HASH(0xc340b50)') called at local/lib/perl5/Catalyst.pm line 1667
      eval {...}

      called at local/lib/perl5/Catalyst.pm line 1667
      Catalyst::execute('MusicBrainz::Server=HASH(0xc340b50)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add', 'Catalyst::Action=HASH(0xbf3e5a8)') called at local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xc340b50)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add', 'Catalyst::Action=HASH(0xbf3e5a8)') called at lib/MusicBrainz/Server.pm line 298
      MusicBrainz::Server::execute('MusicBrainz::Server=HASH(0xc340b50)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add', 'Catalyst::Action=HASH(0xbf3e5a8)') called at local/lib/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch('Catalyst::Action=HASH(0xbf3e5a8)', 'MusicBrainz::Server=HASH(0xc340b50)') called at local/lib/perl5/Catalyst/Dispatcher.pm line 257
      Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x3b84878)', 'forward', 'MusicBrainz::Server=HASH(0xc340b50)', '_ACTION') called at local/lib/perl5/Catalyst/Dispatcher.pm line 237
      Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x3b84878)', 'MusicBrainz::Server=HASH(0xc340b50)', '_ACTION') called at local/lib/perl5/Catalyst.pm line 342
      Catalyst::forward('MusicBrainz::Server=HASH(0xc340b50)', '_ACTION') called at local/lib/perl5/Catalyst/Controller.pm line 99
      Catalyst::Controller::_DISPATCH('MusicBrainz::Server::Controller::ReleaseEditor::Add=HASH(0xbd...', 'MusicBrainz::Server=HASH(0xc340b50)') called at local/lib/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute('Catalyst::Action=HASH(0xc097300)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add=HASH(0xbd...', 'MusicBrainz::Server=HASH(0xc340b50)') called at local/lib/perl5/Catalyst.pm line 1667
      eval

      {...} called at local/lib/perl5/Catalyst.pm line 1667
      Catalyst::execute('MusicBrainz::Server=HASH(0xc340b50)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add', 'Catalyst::Action=HASH(0xc097300)') called at local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xc340b50)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add', 'Catalyst::Action=HASH(0xc097300)') called at lib/MusicBrainz/Server.pm line 298
      MusicBrainz::Server::execute('MusicBrainz::Server=HASH(0xc340b50)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add', 'Catalyst::Action=HASH(0xc097300)') called at local/lib/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch('Catalyst::Action=HASH(0xc097300)', 'MusicBrainz::Server=HASH(0xc340b50)') called at local/lib/perl5/Catalyst/Dispatcher.pm line 257
      Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x3b84878)', 'forward', 'MusicBrainz::Server=HASH(0xc340b50)', '/release_editor/_DISPATCH') called at local/lib/perl5/Catalyst/Dispatcher.pm line 237
      Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x3b84878)', 'MusicBrainz::Server=HASH(0xc340b50)', '/release_editor/_DISPATCH') called at local/lib/perl5/Catalyst.pm line 342
      Catalyst::forward('MusicBrainz::Server=HASH(0xc340b50)', '/release_editor/_DISPATCH') called at local/lib/perl5/Catalyst/Dispatcher.pm line 105
      Catalyst::Dispatcher::dispatch('Catalyst::Dispatcher=HASH(0x3b84878)', 'MusicBrainz::Server=HASH(0xc340b50)') called at local/lib/perl5/Catalyst.pm line 1613
      Catalyst::dispatch('MusicBrainz::Server=HASH(0xc340b50)') called at lib/MusicBrainz/Server.pm line 262
      Class::MOP::Class:::around('CODE(0x3752dc0)', 'MusicBrainz::Server=HASH(0xc340b50)') 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=HASH(0xc340b50)') called at local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 91
      MusicBrainz::Server::dispatch('MusicBrainz::Server=HASH(0xc340b50)') called at local/lib/perl5/Catalyst.pm line 1963
      Catalyst::_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(0xc3011b0)', 'Try::Tiny::Catch=REF(0xc90ec08)') called at local/lib/perl5/Catalyst.pm line 1969
      Catalyst::handle_request('MusicBrainz::Server', 'env', 'HASH(0xc300e20)') called at lib/Catalyst/Plugin/AutoRestart.pm line 119
      Catalyst::Plugin::AutoRestart::handle_request('MusicBrainz::Server', 'env', 'HASH(0xc300e20)') called at local/lib/perl5/Catalyst/Engine.pm line 856
      Catalyst::Engine::_ANON_('CODE(0xc2ff3d0)') called at local/lib/perl5/Plack/Handler/FCGI.pm line 134
      Plack::Handler::FCGI::run('Plack::Handler::FCGI=HASH(0x1beda30)', 'CODE(0xc279040)') called at local/lib/perl5/Plack/Loader.pm line 88
      Plack::Loader::run('Plack::Loader=HASH(0x1bb6e00)', 'Plack::Handler::FCGI=HASH(0x1beda30)') called at local/lib/perl5/Plack/Runner.pm line 263
      Plack::Runner::run('Plack::Runner=HASH(0x19b9808)') called at local/bin/plackup line 10
      at lib/Sql.pm line 290"

      Stack trace:
      line 1270 MusicBrainz::Server::Wizard::ReleaseEditor
      line 1271 MusicBrainz::Server::Wizard::ReleaseEditor
      line 1236 MusicBrainz::Server::Wizard::ReleaseEditor
      line 823 MusicBrainz::Server::Wizard::ReleaseEditor
      line 1155 MusicBrainz::Server::Wizard::ReleaseEditor
      line 918 MusicBrainz::Server::Wizard::ReleaseEditor
      line 898 MusicBrainz::Server::Wizard::ReleaseEditor
      line 824 MusicBrainz::Server::Wizard::ReleaseEditor
      line 94 MusicBrainz::Server::Wizard::ReleaseEditor
      line 17 MusicBrainz::Server::Controller::ReleaseEditor::Edit
      line 298 MusicBrainz::Server
      line 298 MusicBrainz::Server
      line 298 MusicBrainz::Server
      line 262 MusicBrainz::Server

      Request data:
      $VAR1 = {
      'query_parameters' => {},
      'body_parameters' =>

      { 'save' => 'Enter edit', 'wizard_page_id' => '4', 'edit_note' => 'Splitting into 2 discs. http://www.discogs.com/Various-Bumpers/release/720521', 'id' => '342355', 'as_auto_editor' => '1', 'wizard_session_id' => '0.022193702028261' }

      };

      URL: http://musicbrainz.org/release/4142d979-2416-4bf6-8132-cdbd40d0dbb7/edit

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                humhumxx HumHumXX
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Packages

                  Version Package