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

ISE and data loss (recordings) while trying to split a tracklist into 2 tracklists

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: Bug fixes, 2012-06-11
    • Component/s: None
    • Labels:
      None

      Description

      I was splitting a release and this error happened.

      What I did:

      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)=(3739928) is not present in table "recording". at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 396.
      at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 410
      Sql::_ANON_('DBD::Pg::st execute failed: ERROR: insert or update on table...') called at /usr/local/share/perl/5.10.1/Try/Tiny.pm line 100
      Try::Tiny::try('CODE(0xcd7c970)', 'Try::Tiny::Catch=REF(0xcd77380)') called at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 411
      Sql::_select_list('Sql=HASH(0x9ec8130)', 'INSERT INTO track (length,recording,name,position,artist_cred...', 'ARRAY(0xcd7bdd0)', 'arrayref', 'CODE(0x4777258)') called at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 430
      Sql::select_list_of_lists('Sql=HASH(0x9ec8130)', 'INSERT INTO track (length,recording,name,position,artist_cred...', 124160, 3739928, 3351373, 1, 262471, 1168832) called at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 364
      Sql::select_single_column_array('Sql=HASH(0x9ec8130)', 'INSERT INTO track (length,recording,name,position,artist_cred...', 124160, 3739928, 3351373, 1, 262471, 1168832) called at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 379
      Sql::select_single_value('Sql=HASH(0x9ec8130)', 'INSERT INTO track (length,recording,name,position,artist_cred...', 124160, 3739928, 3351373, 1, 262471, 1168832) called at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 146
      Sql::insert_row('Sql=HASH(0x9ec8130)', 'track', 'HASH(0xcd77020)', 'id') called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Data/Track.pm line 142
      MusicBrainz::Server::Data::Track::insert('MusicBrainz::Server::Data::Track=HASH(0xcd11978)', 'HASH(0xcd63cc0)', 'HASH(0xcd63d38)', 'HASH(0xcd7c940)', 'HASH(0xcd644b8)', 'HASH(0xcd64308)', 'HASH(0xcd771e8)', 'HASH(0xcd63fc0)', 'HASH(0xcd771d0)', ...) called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Data/Tracklist.pm line 70
      MusicBrainz::Server::Data::Tracklist::_add_tracks('MusicBrainz::Server::Data::Tracklist=HASH(0xcd281d0)', 1168832, 'ARRAY(0xcd57b80)') called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Data/Tracklist.pm line 30
      MusicBrainz::Server::Data::Tracklist::insert('MusicBrainz::Server::Data::Tracklist=HASH(0xcd281d0)', 'ARRAY(0xcd57b80)') called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Data/Tracklist.pm line 255
      MusicBrainz::Server::Data::Tracklist::find_or_insert('MusicBrainz::Server::Data::Tracklist=HASH(0xcd281d0)', 'ARRAY(0xcd57b80)') called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Edit/Medium/Create.pm line 139
      MusicBrainz::Server::Edit::Medium::Create::_insert_hash('MusicBrainz::Server::Edit::Medium::Create=HASH(0xcd29f98)', 'HASH(0xcd57b50)') called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Edit/Generic/Create.pm line 44
      MusicBrainz::Server::Edit::Generic::Create::insert('MusicBrainz::Server::Edit::Medium::Create=HASH(0xcd29f98)') called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Data/Edit.pm line 387
      MusicBrainz::Server::Data::Edit::_ANON_() called at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 264
      Sql::_ANON_() called at /usr/local/share/perl/5.10.1/Try/Tiny.pm line 76
      eval

      {...} called at /usr/local/share/perl/5.10.1/Try/Tiny.pm line 67
      Try::Tiny::try('CODE(0xcd7bb48)', 'Try::Tiny::Catch=REF(0xcd29e18)') called at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 277
      Sql::_auto_transaction('CODE(0xcd29ce0)', 'Sql=HASH(0x9ec8130)') called at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 282
      Sql::_run_in_transaction_one('CODE(0xcd29ce0)', 'Sql=HASH(0x9ec8130)') called at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 296
      Sql::run_in_transaction('CODE(0xcd29ce0)', 'Sql=HASH(0x9ec8130)') called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Data/Edit.pm line 426
      MusicBrainz::Server::Data::Edit::create('MusicBrainz::Server::Data::Edit=HASH(0x84b0358)', 'edit_type', 51, 'editor_id', 319148, 'format_id', 1, 'privileges', 1, ...) called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 1191
      MusicBrainz::Server::Wizard::ReleaseEditor::_ANON_('edit_type', 51, 'editor_id', 319148, 'format_id', 1, 'privileges', 1, 'position', ...) called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 1218
      MusicBrainz::Server::Wizard::ReleaseEditor::_ANON_() called at /usr/local/share/perl/5.10.1/Try/Tiny.pm line 76
      eval {...}

      called at /usr/local/share/perl/5.10.1/Try/Tiny.pm line 67
      Try::Tiny::try('CODE(0xcd3efe8)', 'Try::Tiny::Catch=REF(0xcd777e8)') called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 1227
      MusicBrainz::Server::Wizard::ReleaseEditor::_create_edit('MusicBrainz::Server::Wizard::ReleaseEditor::Edit=HASH(0xb22af88)', 'CODE(0xb7451f8)', 51, 319148, 'privileges', 1, 'format_id', 1, 'position', ...) called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 1192
      MusicBrainz::Server::Wizard::ReleaseEditor::_submit_edit('MusicBrainz::Server::Wizard::ReleaseEditor::Edit=HASH(0xb22af88)', 51, 'The 1-disc edition does not exist. Split to match this 2-disc...', 'format_id', 1, 'position', 2, 'release', 'MusicBrainz::Server::Entity::Release=HASH(0xb21c908)', ...) called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 778
      MusicBrainz::Server::Wizard::ReleaseEditor::_ANON_(51, 'The 1-disc edition does not exist. Split to match this 2-disc...', 'format_id', 1, 'position', 2, 'release', 'MusicBrainz::Server::Entity::Release=HASH(0xb21c908)', 'tracklist', ...) called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 1112
      MusicBrainz::Server::Wizard::ReleaseEditor::_edit_release_track_edits('MusicBrainz::Server::Wizard::ReleaseEditor::Edit=HASH(0xb22af88)', 'edit_note', 'The 1-disc edition does not exist. Split to match this 2-disc...', 'data', 'HASH(0xb713f00)', 'create_edit', 'CODE(0xb21c6b0)', 'previewing', '', ...) called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 873
      MusicBrainz::Server::Wizard::ReleaseEditor::create_common_edits('MusicBrainz::Server::Wizard::ReleaseEditor::Edit=HASH(0xb22af88)', 'edit_note', 'The 1-disc edition does not exist. Split to match this 2-disc...', 'data', 'HASH(0xb713f00)', 'create_edit', 'CODE(0xb21c6b0)', 'previewing', '', ...) called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 853
      MusicBrainz::Server::Wizard::ReleaseEditor::create_edits('MusicBrainz::Server::Wizard::ReleaseEditor::Edit=HASH(0xb22af88)', 'data', 'HASH(0xb713f00)', 'create_edit', 'CODE(0xb21c6b0)', 'edit_note', 'The 1-disc edition does not exist. Split to match this 2-disc...', 'previewing', '', ...) called at /usr/local/lib/perl/5.10.1/Moose/Meta/Method/Augmented.pm line 46
      MusicBrainz::Server::Wizard::ReleaseEditor::Edit::create_edits('MusicBrainz::Server::Wizard::ReleaseEditor::Edit=HASH(0xb22af88)', 'data', 'HASH(0xb713f00)', 'create_edit', 'CODE(0xb21c6b0)', 'edit_note', 'The 1-disc edition does not exist. Split to match this 2-disc...', 'previewing', '', ...) called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 779
      MusicBrainz::Server::Wizard::ReleaseEditor::prepare_edits('MusicBrainz::Server::Wizard::ReleaseEditor::Edit=HASH(0xb22af88)') called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 94
      MusicBrainz::Server::Wizard::ReleaseEditor::run('MusicBrainz::Server::Wizard::ReleaseEditor::Edit=HASH(0xb22af88)') called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Controller/ReleaseEditor/Edit.pm line 17
      MusicBrainz::Server::Controller::ReleaseEditor::Edit::edit('MusicBrainz::Server::Controller::ReleaseEditor::Edit=HASH(0x9...', 'MusicBrainz::Server=HASH(0xaeb21f8)') called at /usr/local/share/perl/5.10.1/Catalyst/Action.pm line 65
      Catalyst::Action::execute('Catalyst::Action=HASH(0x9a060f8)', 'MusicBrainz::Server::Controller::ReleaseEditor::Edit=HASH(0x9...', 'MusicBrainz::Server=HASH(0xaeb21f8)') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1665
      eval

      {...} called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1665
      Catalyst::execute('MusicBrainz::Server=HASH(0xaeb21f8)', 'MusicBrainz::Server::Controller::ReleaseEditor::Edit', 'Catalyst::Action=HASH(0x9a060f8)') called at /usr/local/share/perl/5.10.1/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xaeb21f8)', 'MusicBrainz::Server::Controller::ReleaseEditor::Edit', 'Catalyst::Action=HASH(0x9a060f8)') called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server.pm line 326
      MusicBrainz::Server::execute('MusicBrainz::Server=HASH(0xaeb21f8)', 'MusicBrainz::Server::Controller::ReleaseEditor::Edit', 'Catalyst::Action=HASH(0x9a060f8)') called at /usr/local/share/perl/5.10.1/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch('Catalyst::Action=HASH(0x9a060f8)', 'MusicBrainz::Server=HASH(0xaeb21f8)') called at /usr/local/share/perl/5.10.1/Catalyst/ActionChain.pm line 39
      Catalyst::ActionChain::dispatch('Catalyst::ActionChain=HASH(0xaf4fbc0)', 'MusicBrainz::Server=HASH(0xaeb21f8)') called at /usr/local/share/perl/5.10.1/Catalyst/Controller.pm line 110
      Catalyst::Controller::_ACTION('MusicBrainz::Server::Controller::ReleaseEditor::Add=HASH(0x98...', 'MusicBrainz::Server=HASH(0xaeb21f8)') called at /usr/local/share/perl/5.10.1/Catalyst/Action.pm line 65
      Catalyst::Action::execute('Catalyst::Action=HASH(0x99fa360)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add=HASH(0x98...', 'MusicBrainz::Server=HASH(0xaeb21f8)') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1665
      eval {...}

      called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1665
      Catalyst::execute('MusicBrainz::Server=HASH(0xaeb21f8)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add', 'Catalyst::Action=HASH(0x99fa360)') called at /usr/local/share/perl/5.10.1/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xaeb21f8)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add', 'Catalyst::Action=HASH(0x99fa360)') called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server.pm line 326
      MusicBrainz::Server::execute('MusicBrainz::Server=HASH(0xaeb21f8)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add', 'Catalyst::Action=HASH(0x99fa360)') called at /usr/local/share/perl/5.10.1/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch('Catalyst::Action=HASH(0x99fa360)', 'MusicBrainz::Server=HASH(0xaeb21f8)') called at /usr/local/share/perl/5.10.1/Catalyst/Dispatcher.pm line 257
      Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x229ed98)', 'forward', 'MusicBrainz::Server=HASH(0xaeb21f8)', '_ACTION') called at /usr/local/share/perl/5.10.1/Catalyst/Dispatcher.pm line 237
      Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x229ed98)', 'MusicBrainz::Server=HASH(0xaeb21f8)', '_ACTION') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 377
      Catalyst::forward('MusicBrainz::Server=HASH(0xaeb21f8)', '_ACTION') called at /usr/local/share/perl/5.10.1/Catalyst/Controller.pm line 84
      Catalyst::Controller::_DISPATCH('MusicBrainz::Server::Controller::ReleaseEditor::Add=HASH(0x98...', 'MusicBrainz::Server=HASH(0xaeb21f8)') called at /usr/local/share/perl/5.10.1/Catalyst/Action.pm line 65
      Catalyst::Action::execute('Catalyst::Action=HASH(0x9b24310)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add=HASH(0x98...', 'MusicBrainz::Server=HASH(0xaeb21f8)') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1665
      eval

      {...} called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1665
      Catalyst::execute('MusicBrainz::Server=HASH(0xaeb21f8)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add', 'Catalyst::Action=HASH(0x9b24310)') called at /usr/local/share/perl/5.10.1/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xaeb21f8)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add', 'Catalyst::Action=HASH(0x9b24310)') called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server.pm line 326
      MusicBrainz::Server::execute('MusicBrainz::Server=HASH(0xaeb21f8)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add', 'Catalyst::Action=HASH(0x9b24310)') called at /usr/local/share/perl/5.10.1/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch('Catalyst::Action=HASH(0x9b24310)', 'MusicBrainz::Server=HASH(0xaeb21f8)') called at /usr/local/share/perl/5.10.1/Catalyst/Dispatcher.pm line 257
      Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x229ed98)', 'forward', 'MusicBrainz::Server=HASH(0xaeb21f8)', '/release_editor/_DISPATCH') called at /usr/local/share/perl/5.10.1/Catalyst/Dispatcher.pm line 237
      Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x229ed98)', 'MusicBrainz::Server=HASH(0xaeb21f8)', '/release_editor/_DISPATCH') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 377
      Catalyst::forward('MusicBrainz::Server=HASH(0xaeb21f8)', '/release_editor/_DISPATCH') called at /usr/local/share/perl/5.10.1/Catalyst/Dispatcher.pm line 105
      Catalyst::Dispatcher::dispatch('Catalyst::Dispatcher=HASH(0x229ed98)', 'MusicBrainz::Server=HASH(0xaeb21f8)') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1611
      Catalyst::dispatch('MusicBrainz::Server=HASH(0xaeb21f8)') called at /usr/local/share/perl/5.10.1/Catalyst/Plugin/Static/Simple.pm line 76
      Class::MOP::Class:::around('CODE(0x28fa780)', 'MusicBrainz::Server=HASH(0xaeb21f8)') called at /usr/local/lib/perl/5.10.1/Class/MOP/Method/Wrapped.pm line 159
      Class::MOP::Method::Wrapped::_ANON_('MusicBrainz::Server=HASH(0xaeb21f8)') called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server.pm line 275
      Class::MOP::Class:::around('CODE(0x229e150)', 'MusicBrainz::Server=HASH(0xaeb21f8)') called at /usr/local/lib/perl/5.10.1/Class/MOP/Method/Wrapped.pm line 159
      Class::MOP::Method::Wrapped::_ANON_('MusicBrainz::Server=HASH(0xaeb21f8)') called at /usr/local/lib/perl/5.10.1/Class/MOP/Method/Wrapped.pm line 89
      MusicBrainz::Server::dispatch('MusicBrainz::Server=HASH(0xaeb21f8)') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1952
      eval {...}

      called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1943
      Catalyst::handle_request('MusicBrainz::Server', 'env', 'HASH(0x3660310)') called at /home/musicbrainz/musicbrainz-server/script/../lib/Catalyst/Plugin/AutoRestart.pm line 119
      Catalyst::Plugin::AutoRestart::handle_request('MusicBrainz::Server', 'env', 'HASH(0x3660310)') called at /usr/local/share/perl/5.10.1/Catalyst/Engine/FastCGI.pm line 149
      Catalyst::Engine::FastCGI::run('Catalyst::Engine::FastCGI=HASH(0x362c0c0)', 'MusicBrainz::Server', '127.0.0.1:55901', 'HASH(0x118dd48)') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 2396
      Catalyst::run('MusicBrainz::Server', '127.0.0.1:55901', 'HASH(0x118dd48)') called at ./script/musicbrainz_fastcgi.pl line 28
      at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 277"

      Stack trace:

      • line 1226 MusicBrainz::Server::Wizard::ReleaseEditor
      • line 1227 MusicBrainz::Server::Wizard::ReleaseEditor
      • line 1192 MusicBrainz::Server::Wizard::ReleaseEditor
      • line 778 MusicBrainz::Server::Wizard::ReleaseEditor
      • line 1112 MusicBrainz::Server::Wizard::ReleaseEditor
      • line 873 MusicBrainz::Server::Wizard::ReleaseEditor
      • line 853 MusicBrainz::Server::Wizard::ReleaseEditor
      • line 779 MusicBrainz::Server::Wizard::ReleaseEditor
      • line 94 MusicBrainz::Server::Wizard::ReleaseEditor
      • line 17 MusicBrainz::Server::Controller::ReleaseEditor::Edit
      • line 326 MusicBrainz::Server
      • line 326 MusicBrainz::Server
      • line 326 MusicBrainz::Server
      • line 275 MusicBrainz::Server

      Request data:

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

      { 'save' => 'Enter edit', 'wizard_page_id' => '4', 'edit_note' => 'The 1-disc edition does not exist. Split to match this 2-disc edition: http://www.amazon.de/Rita-Pavone/dp/samples/B002DHNB7M/ref=dp_tracks_all_1/279-7495942-5533501#disc_1', 'id' => '907993', 'as_auto_editor' => '1', 'wizard_session_id' => '0.769358726122245' }

      };

      URL: http://musicbrainz.org/release/a44151b3-2b11-41f6-a97d-8ed9f5467c6a/edit

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Packages

                  Version Package
                  Bug fixes, 2012-06-11