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

DBD::Pg::st execute failed: ERROR: new row for relation "recording" violates check constraint "recording_length_check" at lib/Sql.pm line 396

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: Bug fixes, 2012-03-12
    • Component/s: None
    • Labels:
      None
    • Environment:
      Windows NT, Firefox

      Description

      Error:

      Caught exception in MusicBrainz::Server::Controller::ReleaseEditor::Add->add "DBD::Pg::st execute failed: ERROR: new row for relation "recording" violates check constraint "recording_length_check" at lib/Sql.pm line 396.
      at lib/Sql.pm line 410
      Sql::_ANON_('DBD::Pg::st execute failed: ERROR: new row for relation "rec...') called at local/lib/perl5/Try/Tiny.pm line 100
      Try::Tiny::try('CODE(0xefb3d60)', 'Try::Tiny::Catch=REF(0xefd1c28)') called at lib/Sql.pm line 411
      Sql::_select_list('Sql=HASH(0xbdfe500)', 'INSERT INTO recording (length,name,artist_credit,gid) VALUES ...', 'ARRAY(0xefbd088)', 'arrayref', 'CODE(0x522ac90)') called at lib/Sql.pm line 430
      Sql::select_list_of_lists('Sql=HASH(0xbdfe500)', 'INSERT INTO recording (length,name,artist_credit,gid) VALUES ...', 0, 5708860, 953021, 'B41B9646-17BE-4E14-92B7-F65EC5C42153') called at lib/Sql.pm line 364
      Sql::select_single_column_array('Sql=HASH(0xbdfe500)', 'INSERT INTO recording (length,name,artist_credit,gid) VALUES ...', 0, 5708860, 953021, 'B41B9646-17BE-4E14-92B7-F65EC5C42153') called at lib/Sql.pm line 379
      Sql::select_single_value('Sql=HASH(0xbdfe500)', 'INSERT INTO recording (length,name,artist_credit,gid) VALUES ...', 0, 5708860, 953021, 'B41B9646-17BE-4E14-92B7-F65EC5C42153') called at lib/Sql.pm line 146
      Sql::insert_row('Sql=HASH(0xbdfe500)', 'recording', 'HASH(0xcf30708)', 'id') called at lib/MusicBrainz/Server/Data/Recording.pm line 136
      MusicBrainz::Server::Data::Recording::insert('MusicBrainz::Server::Data::Recording=HASH(0xadbea98)', 'HASH(0xefba6e0)') called at lib/MusicBrainz/Server/Edit/Medium/Create.pm line 133
      MusicBrainz::Server::Edit::Medium::Create::_insert_hash('MusicBrainz::Server::Edit::Medium::Create=HASH(0xefbacb0)', 'HASH(0xcf30528)') called at lib/MusicBrainz/Server/Edit/Generic/Create.pm line 44
      MusicBrainz::Server::Edit::Generic::Create::insert('MusicBrainz::Server::Edit::Medium::Create=HASH(0xefbacb0)') called at lib/MusicBrainz/Server/Data/Edit.pm line 388
      MusicBrainz::Server::Data::Edit::_ANON_() called at lib/Sql.pm line 264
      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(0xefc9110)', 'Try::Tiny::Catch=REF(0xef47b58)') called at lib/Sql.pm line 277
      Sql::_auto_transaction('CODE(0xefbf5a0)', 'Sql=HASH(0xbdfe500)') called at lib/Sql.pm line 282
      Sql::_run_in_transaction_one('CODE(0xefbf5a0)', 'Sql=HASH(0xbdfe500)') called at lib/Sql.pm line 296
      Sql::run_in_transaction('CODE(0xefbf5a0)', 'Sql=HASH(0xbdfe500)') called at lib/MusicBrainz/Server/Data/Edit.pm line 427
      MusicBrainz::Server::Data::Edit::create('MusicBrainz::Server::Data::Edit=HASH(0x9fb1c00)', 'edit_type', 51, 'editor_id', 321185, 'format_id', 31, 'privileges', 0, ...) called at lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 1233
      MusicBrainz::Server::Wizard::ReleaseEditor::_ANON_('edit_type', 51, 'editor_id', 321185, 'format_id', 31, 'privileges', 0, 'position', ...) called at lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 1260
      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(0xef627c0)', 'Try::Tiny::Catch=REF(0xef624d8)') called at lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 1269
      MusicBrainz::Server::Wizard::ReleaseEditor::_create_edit('MusicBrainz::Server::Wizard::ReleaseEditor::Add=HASH(0xc1c99e8)', 'CODE(0xcf304b0)', 51, 321185, 'privileges', 0, 'format_id', 31, 'position', ...) called at lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 1234
      MusicBrainz::Server::Wizard::ReleaseEditor::_submit_edit('MusicBrainz::Server::Wizard::ReleaseEditor::Add=HASH(0xc1c99e8)', 51, 'Imported from http://discogs.com/release/1371465', 'format_id', 31, 'position', 1, 'release', 'MusicBrainz::Server::Entity::Release=HASH(0xefbaf38)', ...) called at lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 824
      MusicBrainz::Server::Wizard::ReleaseEditor::_ANON_(51, 'Imported from http://discogs.com/release/1371465', 'format_id', 31, 'position', 1, 'release', 'MusicBrainz::Server::Entity::Release=HASH(0xefbaf38)', 'tracklist', ...) called at lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 1153
      MusicBrainz::Server::Wizard::ReleaseEditor::_edit_release_track_edits('MusicBrainz::Server::Wizard::ReleaseEditor::Add=HASH(0xc1c99e8)', 'edit_note', 'Imported from http://discogs.com/release/1371465', 'data', 'HASH(0xcf24158)', 'create_edit', 'CODE(0xced3828)', 'previewing', '', ...) called at lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 919
      MusicBrainz::Server::Wizard::ReleaseEditor::create_common_edits('MusicBrainz::Server::Wizard::ReleaseEditor::Add=HASH(0xc1c99e8)', 'edit_note', 'Imported from http://discogs.com/release/1371465', 'data', 'HASH(0xcf24158)', 'create_edit', 'CODE(0xced3828)', 'previewing', '', ...) called at lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 899
      MusicBrainz::Server::Wizard::ReleaseEditor::create_edits('MusicBrainz::Server::Wizard::ReleaseEditor::Add=HASH(0xc1c99e8)', 'data', 'HASH(0xcf24158)', 'create_edit', 'CODE(0xced3828)', 'edit_note', 'Imported from http://discogs.com/release/1371465', 'previewing', '', ...) called at 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(0xc1c99e8)', 'data', 'HASH(0xcf24158)', 'create_edit', 'CODE(0xced3828)', 'edit_note', 'Imported from http://discogs.com/release/1371465', 'previewing', '', ...) 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::Wizard::ReleaseEditor::Add=HASH(0xc1c99e8)', 'data', 'HASH(0xcf24158)', 'create_edit', 'CODE(0xced3828)', 'edit_note', 'Imported from http://discogs.com/release/1371465', 'previewing', '', ...) called at 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(0xc1c99e8)', 'data', 'HASH(0xcf24158)', 'create_edit', 'CODE(0xced3828)', 'edit_note', 'Imported from http://discogs.com/release/1371465', 'previewing', '', ...) called at lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 825
      MusicBrainz::Server::Wizard::ReleaseEditor::prepare_edits('MusicBrainz::Server::Wizard::ReleaseEditor::Add=HASH(0xc1c99e8)') called at lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 95
      MusicBrainz::Server::Wizard::ReleaseEditor::run('MusicBrainz::Server::Wizard::ReleaseEditor::Add=HASH(0xc1c99e8)') called at lib/MusicBrainz/Server/Controller/ReleaseEditor/Add.pm line 23
      MusicBrainz::Server::Controller::ReleaseEditor::Add::add('MusicBrainz::Server::Controller::ReleaseEditor::Add=HASH(0xb6...', 'MusicBrainz::Server=HASH(0xbeca358)') called at local/lib/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute('Catalyst::Action=HASH(0xb9b9210)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add=HASH(0xb6...', 'MusicBrainz::Server=HASH(0xbeca358)') called at local/lib/perl5/Catalyst.pm line 1667
      eval

      {...} called at local/lib/perl5/Catalyst.pm line 1667
      Catalyst::execute('MusicBrainz::Server=HASH(0xbeca358)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add', 'Catalyst::Action=HASH(0xb9b9210)') called at local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xbeca358)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add', 'Catalyst::Action=HASH(0xb9b9210)') called at lib/MusicBrainz/Server.pm line 315
      MusicBrainz::Server::execute('MusicBrainz::Server=HASH(0xbeca358)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add', 'Catalyst::Action=HASH(0xb9b9210)') called at local/lib/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch('Catalyst::Action=HASH(0xb9b9210)', 'MusicBrainz::Server=HASH(0xbeca358)') called at local/lib/perl5/Catalyst/Controller.pm line 125
      Catalyst::Controller::_ACTION('MusicBrainz::Server::Controller::ReleaseEditor::Add=HASH(0xb6...', 'MusicBrainz::Server=HASH(0xbeca358)') called at local/lib/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute('Catalyst::Action=HASH(0xb872990)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add=HASH(0xb6...', 'MusicBrainz::Server=HASH(0xbeca358)') called at local/lib/perl5/Catalyst.pm line 1667
      eval {...}

      called at local/lib/perl5/Catalyst.pm line 1667
      Catalyst::execute('MusicBrainz::Server=HASH(0xbeca358)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add', 'Catalyst::Action=HASH(0xb872990)') called at local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xbeca358)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add', 'Catalyst::Action=HASH(0xb872990)') called at lib/MusicBrainz/Server.pm line 315
      MusicBrainz::Server::execute('MusicBrainz::Server=HASH(0xbeca358)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add', 'Catalyst::Action=HASH(0xb872990)') called at local/lib/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch('Catalyst::Action=HASH(0xb872990)', 'MusicBrainz::Server=HASH(0xbeca358)') called at local/lib/perl5/Catalyst/Dispatcher.pm line 257
      Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x396f4a8)', 'forward', 'MusicBrainz::Server=HASH(0xbeca358)', '_ACTION') called at local/lib/perl5/Catalyst/Dispatcher.pm line 237
      Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x396f4a8)', 'MusicBrainz::Server=HASH(0xbeca358)', '_ACTION') called at local/lib/perl5/Catalyst.pm line 342
      Catalyst::forward('MusicBrainz::Server=HASH(0xbeca358)', '_ACTION') called at local/lib/perl5/Catalyst/Controller.pm line 99
      Catalyst::Controller::_DISPATCH('MusicBrainz::Server::Controller::ReleaseEditor::Add=HASH(0xb6...', 'MusicBrainz::Server=HASH(0xbeca358)') called at local/lib/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute('Catalyst::Action=HASH(0xb9b9b10)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add=HASH(0xb6...', 'MusicBrainz::Server=HASH(0xbeca358)') called at local/lib/perl5/Catalyst.pm line 1667
      eval

      {...} called at local/lib/perl5/Catalyst.pm line 1667
      Catalyst::execute('MusicBrainz::Server=HASH(0xbeca358)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add', 'Catalyst::Action=HASH(0xb9b9b10)') called at local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xbeca358)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add', 'Catalyst::Action=HASH(0xb9b9b10)') called at lib/MusicBrainz/Server.pm line 315
      MusicBrainz::Server::execute('MusicBrainz::Server=HASH(0xbeca358)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add', 'Catalyst::Action=HASH(0xb9b9b10)') called at local/lib/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch('Catalyst::Action=HASH(0xb9b9b10)', 'MusicBrainz::Server=HASH(0xbeca358)') called at local/lib/perl5/Catalyst/Dispatcher.pm line 257
      Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x396f4a8)', 'forward', 'MusicBrainz::Server=HASH(0xbeca358)', '/release_editor/_DISPATCH') called at local/lib/perl5/Catalyst/Dispatcher.pm line 237
      Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x396f4a8)', 'MusicBrainz::Server=HASH(0xbeca358)', '/release_editor/_DISPATCH') called at local/lib/perl5/Catalyst.pm line 342
      Catalyst::forward('MusicBrainz::Server=HASH(0xbeca358)', '/release_editor/_DISPATCH') called at local/lib/perl5/Catalyst/Dispatcher.pm line 105
      Catalyst::Dispatcher::dispatch('Catalyst::Dispatcher=HASH(0x396f4a8)', 'MusicBrainz::Server=HASH(0xbeca358)') called at local/lib/perl5/Catalyst.pm line 1613
      Catalyst::dispatch('MusicBrainz::Server=HASH(0xbeca358)') called at lib/MusicBrainz/Server.pm line 279
      Class::MOP::Class:::around('CODE(0x3525318)', 'MusicBrainz::Server=HASH(0xbeca358)') 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(0xbeca358)') called at local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 91
      MusicBrainz::Server::dispatch('MusicBrainz::Server=HASH(0xbeca358)') 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(0xbc29b70)', 'Try::Tiny::Catch=REF(0xc3e6470)') called at local/lib/perl5/Catalyst.pm line 1969
      Catalyst::handle_request('MusicBrainz::Server', 'env', 'HASH(0xbc50ee0)') called at local/lib/perl5/Catalyst/Plugin/AutoRestart.pm line 114
      Catalyst::Plugin::AutoRestart::handle_request('MusicBrainz::Server', 'env', 'HASH(0xbc50ee0)') called at local/lib/perl5/Catalyst/Engine.pm line 856
      Catalyst::Engine::_ANON_('CODE(0xbc297e0)') called at local/lib/perl5/Plack/Handler/FCGI.pm line 134
      Plack::Handler::FCGI::run('Plack::Handler::FCGI=HASH(0x19c1a30)', 'CODE(0xbbd3718)') called at local/lib/perl5/Plack/Loader.pm line 88
      Plack::Loader::run('Plack::Loader=HASH(0x198ae00)', 'Plack::Handler::FCGI=HASH(0x19c1a30)') called at local/lib/perl5/Plack/Runner.pm line 263
      Plack::Runner::run('Plack::Runner=HASH(0x178d808)') called at local/bin/plackup line 10
      at lib/Sql.pm line 277"

      Stack trace:

      line 1268 MusicBrainz::Server::Wizard::ReleaseEditor
      line 1269 MusicBrainz::Server::Wizard::ReleaseEditor
      line 1234 MusicBrainz::Server::Wizard::ReleaseEditor
      line 824 MusicBrainz::Server::Wizard::ReleaseEditor
      line 1153 MusicBrainz::Server::Wizard::ReleaseEditor
      line 919 MusicBrainz::Server::Wizard::ReleaseEditor
      line 899 MusicBrainz::Server::Wizard::ReleaseEditor
      line 825 MusicBrainz::Server::Wizard::ReleaseEditor
      line 95 MusicBrainz::Server::Wizard::ReleaseEditor
      line 23 MusicBrainz::Server::Controller::ReleaseEditor::Add
      line 315 MusicBrainz::Server
      line 315 MusicBrainz::Server
      line 315 MusicBrainz::Server
      line 279 MusicBrainz::Server

      Request data:

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

      { 'save' => 'Enter edit', 'wizard_page_id' => '5', 'edit_note' => 'Imported from http://discogs.com/release/1371465', 'id' => '', 'wizard_session_id' => '0.557159713094251' }

      };

      URL: http://musicbrainz.org/release/add

      Encountered when importing a lot of releases, for instance http://www.discogs.com/release/1371465 using http://userscripts.org/scripts/show/36376

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Packages

                  Version Package
                  Bug fixes, 2012-03-12