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

Release editor fails on releases without disambiguation comment

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: Schema change, 2012-10-15
    • Fix Version/s: 2012-10-29
    • Component/s: Release editor
    • Labels:
      None
    • Environment:
      Windows 7 x64, Google Chrome 23.0.1271.26

      Description

      Caught exception in MusicBrainz::Server::Controller::ReleaseEditor::Add->add "DBD::Pg::st execute failed: ERROR: null value in column "comment" violates not-null constraint at lib/Sql.pm line 414.
      at lib/Sql.pm line 429
      Sql::_ANON_('DBD::Pg::st execute failed: ERROR: null value in column "com...') called at local/lib/perl5/Try/Tiny.pm line 100
      Try::Tiny::try('CODE(0x10c20c78)', 'Try::Tiny::Catch=REF(0x10c20558)') called at lib/Sql.pm line 430
      Sql::_select_list('Sql=HASH(0x1019b898)', 'INSERT INTO release (date_day,country,script,language,release...', 'ARRAY(0x10c206d8)', 'arrayref', 'CODE(0x4fa44e0)') called at lib/Sql.pm line 449
      Sql::select_list_of_lists('Sql=HASH(0x1019b898)', 'INSERT INTO release (date_day,country,script,language,release...', 03, 13, 28, 120, 1203016, 1, 491767, ...) called at lib/Sql.pm line 382
      Sql::select_single_column_array('Sql=HASH(0x1019b898)', 'INSERT INTO release (date_day,country,script,language,release...', 03, 13, 28, 120, 1203016, 1, 491767, ...) called at lib/Sql.pm line 397
      Sql::select_single_value('Sql=HASH(0x1019b898)', 'INSERT INTO release (date_day,country,script,language,release...', 03, 13, 28, 120, 1203016, 1, 491767, ...) called at lib/Sql.pm line 150
      Sql::insert_row('Sql=HASH(0x1019b898)', 'release', 'HASH(0x10bf5c38)', 'id') called at lib/MusicBrainz/Server/Data/Release.pm line 540
      MusicBrainz::Server::Data::Release::insert('MusicBrainz::Server::Data::Release=HASH(0xb747740)', 'HASH(0x10c1fe38)') called at lib/MusicBrainz/Server/Edit/Generic/Create.pm line 45
      MusicBrainz::Server::Edit::Generic::Create::insert('MusicBrainz::Server::Edit::Release::Create=HASH(0x10c1ac78)') called at lib/MusicBrainz/Server/Data/Edit.pm line 391
      MusicBrainz::Server::Data::Edit::create('MusicBrainz::Server::Data::Edit=HASH(0xaefa2e0)', 'edit_type', 31, 'editor_id', 191697, 'privileges', 0, 'date', 'HASH(0x10ae5ae0)', ...) called at lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 1266
      MusicBrainz::Server::Wizard::ReleaseEditor::_ANON_('edit_type', 31, 'editor_id', 191697, 'privileges', 0, 'date', 'HASH(0x10ae5ae0)', 'name', ...) called at lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 1293
      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(0x10bfdc68)', 'Try::Tiny::Catch=REF(0x10c205e8)') called at lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 1302
      MusicBrainz::Server::Wizard::ReleaseEditor::_create_edit('MusicBrainz::Server::Wizard::ReleaseEditor::Add=HASH(0x101a5498)', 'CODE(0x10af2dc0)', 31, 191697, 'privileges', 0, 'date', 'HASH(0x10ae5ae0)', 'name', ...) called at lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 1267
      MusicBrainz::Server::Wizard::ReleaseEditor::_submit_edit('MusicBrainz::Server::Wizard::ReleaseEditor::Add=HASH(0x101a5498)', 31, 'http://shop.abc.net.au/products/mckenzie-s-close-your-ey-cd', 'date', 'HASH(0x10ae5ae0)', 'name', 'Close Your Eyes', 'barcode', 00602537095940, ...) called at lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 848
      MusicBrainz::Server::Wizard::ReleaseEditor::_ANON_(31, 'http://shop.abc.net.au/products/mckenzie-s-close-your-ey-cd', 'date', 'HASH(0x10ae5ae0)', 'name', 'Close Your Eyes', 'barcode', 00602537095940, 'artist_credit', ...) called at lib/MusicBrainz/Server/Wizard/ReleaseEditor/Add.pm line 219
      MusicBrainz::Server::Wizard::ReleaseEditor::Add::_ANON_('MusicBrainz::Server::Wizard::ReleaseEditor::Add=HASH(0x101a5498)', 'data', 'HASH(0x10ae5948)', 'create_edit', 'CODE(0x10b875c8)', 'edit_note', 'http://shop.abc.net.au/products/mckenzie-s-close-your-ey-cd', 'previewing', '', ...) called at local/lib/perl5/x86_64-linux-gnu-thread-multi/Moose.pm line 119
      Moose::inner() called at lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 922
      MusicBrainz::Server::Wizard::ReleaseEditor::create_edits('MusicBrainz::Server::Wizard::ReleaseEditor::Add=HASH(0x101a5498)', 'data', 'HASH(0x10ae5948)', 'create_edit', 'CODE(0x10b875c8)', 'edit_note', 'http://shop.abc.net.au/products/mckenzie-s-close-your-ey-cd', '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(0x101a5498)', 'data', 'HASH(0x10ae5948)', 'create_edit', 'CODE(0x10b875c8)', 'edit_note', 'http://shop.abc.net.au/products/mckenzie-s-close-your-ey-cd', '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(0x101a5498)', 'data', 'HASH(0x10ae5948)', 'create_edit', 'CODE(0x10b875c8)', 'edit_note', 'http://shop.abc.net.au/products/mckenzie-s-close-your-ey-cd', '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(0x101a5498)', 'data', 'HASH(0x10ae5948)', 'create_edit', 'CODE(0x10b875c8)', 'edit_note', 'http://shop.abc.net.au/products/mckenzie-s-close-your-ey-cd', 'previewing', '', ...) called at lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 849
      MusicBrainz::Server::Wizard::ReleaseEditor::prepare_edits('MusicBrainz::Server::Wizard::ReleaseEditor::Add=HASH(0x101a5498)') called at lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 94
      MusicBrainz::Server::Wizard::ReleaseEditor::run('MusicBrainz::Server::Wizard::ReleaseEditor::Add=HASH(0x101a5498)') called at lib/MusicBrainz/Server/Controller/ReleaseEditor/Add.pm line 23
      MusicBrainz::Server::Controller::ReleaseEditor::Add::add('MusicBrainz::Server::Controller::ReleaseEditor::Add=HASH(0xc0...', 'MusicBrainz::Server=HASH(0x9706ce8)') called at local/lib/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute('Catalyst::Action=HASH(0xc371e30)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add=HASH(0xc0...', 'MusicBrainz::Server=HASH(0x9706ce8)') called at local/lib/perl5/Catalyst.pm line 1667
      eval {...}

      called at local/lib/perl5/Catalyst.pm line 1667
      Catalyst::execute('MusicBrainz::Server=HASH(0x9706ce8)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add', 'Catalyst::Action=HASH(0xc371e30)') called at local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0x9706ce8)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add', 'Catalyst::Action=HASH(0xc371e30)') called at lib/MusicBrainz/Server.pm line 322
      MusicBrainz::Server::execute('MusicBrainz::Server=HASH(0x9706ce8)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add', 'Catalyst::Action=HASH(0xc371e30)') called at local/lib/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch('Catalyst::Action=HASH(0xc371e30)', 'MusicBrainz::Server=HASH(0x9706ce8)') called at local/lib/perl5/Catalyst/Controller.pm line 125
      Catalyst::Controller::_ACTION('MusicBrainz::Server::Controller::ReleaseEditor::Add=HASH(0xc0...', 'MusicBrainz::Server=HASH(0x9706ce8)') called at local/lib/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute('Catalyst::Action=HASH(0xc220e10)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add=HASH(0xc0...', 'MusicBrainz::Server=HASH(0x9706ce8)') called at local/lib/perl5/Catalyst.pm line 1667
      eval

      {...} called at local/lib/perl5/Catalyst.pm line 1667
      Catalyst::execute('MusicBrainz::Server=HASH(0x9706ce8)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add', 'Catalyst::Action=HASH(0xc220e10)') called at local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0x9706ce8)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add', 'Catalyst::Action=HASH(0xc220e10)') called at lib/MusicBrainz/Server.pm line 322
      MusicBrainz::Server::execute('MusicBrainz::Server=HASH(0x9706ce8)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add', 'Catalyst::Action=HASH(0xc220e10)') called at local/lib/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch('Catalyst::Action=HASH(0xc220e10)', 'MusicBrainz::Server=HASH(0x9706ce8)') called at local/lib/perl5/Catalyst/Dispatcher.pm line 257
      Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x36c6308)', 'forward', 'MusicBrainz::Server=HASH(0x9706ce8)', '_ACTION') called at local/lib/perl5/Catalyst/Dispatcher.pm line 237
      Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x36c6308)', 'MusicBrainz::Server=HASH(0x9706ce8)', '_ACTION') called at local/lib/perl5/Catalyst.pm line 342
      Catalyst::forward('MusicBrainz::Server=HASH(0x9706ce8)', '_ACTION') called at local/lib/perl5/Catalyst/Controller.pm line 99
      Catalyst::Controller::_DISPATCH('MusicBrainz::Server::Controller::ReleaseEditor::Add=HASH(0xc0...', 'MusicBrainz::Server=HASH(0x9706ce8)') called at local/lib/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute('Catalyst::Action=HASH(0xc371f98)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add=HASH(0xc0...', 'MusicBrainz::Server=HASH(0x9706ce8)') called at local/lib/perl5/Catalyst.pm line 1667
      eval {...}

      called at local/lib/perl5/Catalyst.pm line 1667
      Catalyst::execute('MusicBrainz::Server=HASH(0x9706ce8)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add', 'Catalyst::Action=HASH(0xc371f98)') called at local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0x9706ce8)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add', 'Catalyst::Action=HASH(0xc371f98)') called at lib/MusicBrainz/Server.pm line 322
      MusicBrainz::Server::execute('MusicBrainz::Server=HASH(0x9706ce8)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add', 'Catalyst::Action=HASH(0xc371f98)') called at local/lib/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch('Catalyst::Action=HASH(0xc371f98)', 'MusicBrainz::Server=HASH(0x9706ce8)') called at local/lib/perl5/Catalyst/Dispatcher.pm line 257
      Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x36c6308)', 'forward', 'MusicBrainz::Server=HASH(0x9706ce8)', '/release_editor/_DISPATCH') called at local/lib/perl5/Catalyst/Dispatcher.pm line 237
      Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x36c6308)', 'MusicBrainz::Server=HASH(0x9706ce8)', '/release_editor/_DISPATCH') called at local/lib/perl5/Catalyst.pm line 342
      Catalyst::forward('MusicBrainz::Server=HASH(0x9706ce8)', '/release_editor/_DISPATCH') called at local/lib/perl5/Catalyst/Dispatcher.pm line 105
      Catalyst::Dispatcher::dispatch('Catalyst::Dispatcher=HASH(0x36c6308)', 'MusicBrainz::Server=HASH(0x9706ce8)') called at local/lib/perl5/Catalyst.pm line 1613
      Catalyst::dispatch('MusicBrainz::Server=HASH(0x9706ce8)') called at lib/MusicBrainz/Server.pm line 286
      Class::MOP::Class:::around('CODE(0x2fc9098)', 'MusicBrainz::Server=HASH(0x9706ce8)') 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(0x9706ce8)') called at local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 91
      MusicBrainz::Server::dispatch('MusicBrainz::Server=HASH(0x9706ce8)') 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(0xfa93680)', 'Try::Tiny::Catch=REF(0x10291ab8)') called at local/lib/perl5/Catalyst.pm line 1969
      Catalyst::handle_request('MusicBrainz::Server', 'env', 'HASH(0xc600b10)') called at lib/Catalyst/Plugin/AutoRestart.pm line 119
      Catalyst::Plugin::AutoRestart::handle_request('MusicBrainz::Server', 'env', 'HASH(0xc600b10)') called at local/lib/perl5/Catalyst/Engine.pm line 856
      Catalyst::Engine::_ANON_('CODE(0x10291f68)') called at local/lib/perl5/Plack/Handler/FCGI.pm line 134
      Plack::Handler::FCGI::run('Plack::Handler::FCGI=HASH(0x1465a30)', 'CODE(0xc59ec50)') called at local/lib/perl5/Plack/Loader.pm line 88
      Plack::Loader::run('Plack::Loader=HASH(0x142ee00)', 'Plack::Handler::FCGI=HASH(0x1465a30)') called at local/lib/perl5/Plack/Runner.pm line 263
      Plack::Runner::run('Plack::Runner=HASH(0x1231808)') called at local/bin/plackup line 10"
      Stack trace:
      line 1301 MusicBrainz::Server::Wizard::ReleaseEditor
      line 1302 MusicBrainz::Server::Wizard::ReleaseEditor
      line 1267 MusicBrainz::Server::Wizard::ReleaseEditor
      line 848 MusicBrainz::Server::Wizard::ReleaseEditor
      line 219 MusicBrainz::Server::Wizard::ReleaseEditor::Add
      line 922 MusicBrainz::Server::Wizard::ReleaseEditor
      line 849 MusicBrainz::Server::Wizard::ReleaseEditor
      line 94 MusicBrainz::Server::Wizard::ReleaseEditor
      line 23 MusicBrainz::Server::Controller::ReleaseEditor::Add
      line 322 MusicBrainz::Server
      line 322 MusicBrainz::Server
      line 322 MusicBrainz::Server
      line 286 MusicBrainz::Server
      Request data:

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

      { 'save' => 'Enter edit', 'wizard_page_id' => '5', 'edit_note' => 'http://shop.abc.net.au/products/mckenzie-s-close-your-ey-cd', 'id' => '', 'wizard_session_id' => '36954' }

      };

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                alkimiya alkimiya
              • Votes:
                2 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Packages

                  Version Package
                  2012-10-29