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

Caught exception in MusicBrainz::Server::Controller::Series->add_alias "The edit could not be created.

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2014-05-26
    • Component/s: None
    • Labels:
      None

      Description

      Caught exception in MusicBrainz::Server::Controller::Series->add_alias "The edit could not be created.
      POST: $VAR1 =

      { 'edit-alias.edit_note' => '', 'edit-alias.as_auto_editor' => '1', 'edit-alias.type_id' => '2', 'edit-alias.name' => 'ISOS' }

      ;

      Exception:$VAR1 = 'DBD::Pg::st execute failed: ERROR: null value in column "sort_name" violates not-null constraint at lib/Sql.pm line 443, line 3.
      at lib/Sql.pm line 456
      Sql::_ANON_(\'DBD::Pg::st execute failed: ERROR: null value in column "sor...\') called at /usr/share/perl5/Try/Tiny.pm line 100
      Try::Tiny::try(\'CODE(0x13f6a0a0)\', \'Try::Tiny::Catch=REF(0x13f733c8)\', \'Try::Tiny::Finally=REF(0x106926f0)\') called at lib/Sql.pm line 460
      Sql::_select_list(\'Sql=HASH(0xee49d98)\', \'INSERT INTO series_alias (ended,primary_for_locale,name,type,...\', \'ARRAY(0x1061c838)\', \'arrayref\', \'CODE(0x551ef58)\') called at lib/Sql.pm line 479
      Sql::select_list_of_lists(\'Sql=HASH(0xee49d98)\', \'INSERT INTO series_alias (ended,primary_for_locale,name,type,...\', 0, 0, \'ISOS\', 2, undef, undef, 14, ...) called at lib/Sql.pm line 410
      Sql::select_single_column_array(\'Sql=HASH(0xee49d98)\', \'INSERT INTO series_alias (ended,primary_for_locale,name,type,...\', 0, 0, \'ISOS\', 2, undef, undef, 14, ...) called at lib/Sql.pm line 425
      Sql::select_single_value(\'Sql=HASH(0xee49d98)\', \'INSERT INTO series_alias (ended,primary_for_locale,name,type,...\', 0, 0, \'ISOS\', 2, undef, undef, 14, ...) called at lib/Sql.pm line 150
      Sql::insert_row(\'Sql=HASH(0xee49d98)\', \'series_alias\', \'HASH(0x13f59718)\', \'id\') called at lib/MusicBrainz/Server/Data/Alias.pm line 172
      MusicBrainz::Server::Data::Alias::insert(\'Moose::Meta::Class::_ANON_::SERIAL::385=HASH(0x550a5b8)\', \'HASH(0x13f499f0)\') called at lib/MusicBrainz/Server/Edit/Alias/Add.pm line 70
      Moose::Meta::Role::_ANON_::SERIAL::387::insert(\'MusicBrainz::Server::Edit::Series::AddAlias=HASH(0x10692a20)\') called at lib/MusicBrainz/Server/Data/Edit.pm line 463
      MusicBrainz::Server::Data::Edit::create(\'MusicBrainz::Server::Data::Edit=HASH(0xc9e4ff0)\', \'editor_id\', 495807, \'privileges\', 1, \'entity\', \'MusicBrainz::Server::Entity::Series=HASH(0xee53ae8)\', \'ended\', 0, ...) called at lib/MusicBrainz/Server/Controller.pm line 89
      MusicBrainz::Server::Controller::_ANON_() called at /usr/share/perl5/Try/Tiny.pm line 76
      eval

      {...} called at /usr/share/perl5/Try/Tiny.pm line 67
      Try::Tiny::try(\'CODE(0x106925d0)\', \'Try::Tiny::Catch=REF(0x10615b40)\') called at lib/MusicBrainz/Server/Controller.pm line 105
      MusicBrainz::Server::Controller::_insert_edit(\'MusicBrainz::Server::Controller::Series=HASH(0xdd78dd8)\', \'MusicBrainz::Server=HASH(0xe8691d0)\', \'MusicBrainz::Server::Form::Alias=HASH(0xf11d320)\', \'edit_type\', 145, \'name\', \'ISOS\', \'locale\', undef, ...) called at lib/MusicBrainz/Server/Controller.pm line 185
      MusicBrainz::Server::Controller::_ANON_() called at lib/Sql.pm line 307
      Sql::_ANON_() called at /usr/share/perl5/Try/Tiny.pm line 76
      eval {...}

      called at /usr/share/perl5/Try/Tiny.pm line 67
      Try::Tiny::try(\'CODE(0x106158e8)\', \'Try::Tiny::Catch=REF(0x1061c538)\') called at lib/Sql.pm line 320
      Sql::_auto_transaction(\'CODE(0x10615648)\', \'Sql=HASH(0xee49d98)\') called at lib/Sql.pm line 325
      Sql::_run_in_transaction_one(\'CODE(0x10615648)\', \'Sql=HASH(0xee49d98)\') called at lib/Sql.pm line 339
      Sql::run_in_transaction(\'CODE(0x10615648)\', \'Sql=HASH(0xee49d98)\') called at lib/MusicBrainz/Server/Model/MB.pm line 19
      MusicBrainz::Server::Model::MB::with_transaction(\'MusicBrainz::Server::Model::MB=HASH(0xc2bbfb8)\', \'CODE(0x10615648)\') called at lib/MusicBrainz/Server/Controller.pm line 202
      MusicBrainz::Server::Controller::edit_action(\'MusicBrainz::Server::Controller::Series=HASH(0xdd78dd8)\', \'MusicBrainz::Server=HASH(0xe8691d0)\', \'item\', \'HASH(0xefae8f0)\', \'form\', \'Alias\', \'edit_args\', \'HASH(0xea662f8)\', \'type\', ...) called at lib/MusicBrainz/Server/Controller/Role/EditRelationships.pm line 57
      Class::MOP::Class:::around(\'CODE(0x56443e8)\', \'MusicBrainz::Server::Controller::Series=HASH(0xdd78dd8)\', \'MusicBrainz::Server=HASH(0xe8691d0)\', \'form\', \'Alias\', \'form_args\', \'HASH(0xebeb4a8)\', \'type\', 145, ...) called at /usr/lib/perl5/Class/MOP/Method/Wrapped.pm line 162
      Class::MOP::Method::Wrapped::_ANON_(\'MusicBrainz::Server::Controller::Series=HASH(0xdd78dd8)\', \'MusicBrainz::Server=HASH(0xe8691d0)\', \'form\', \'Alias\', \'form_args\', \'HASH(0xebeb4a8)\', \'type\', 145, \'edit_args\', ...) called at /usr/lib/perl5/Class/MOP/Method/Wrapped.pm line 91
      MusicBrainz::Server::Controller::Series::edit_action(\'MusicBrainz::Server::Controller::Series=HASH(0xdd78dd8)\', \'MusicBrainz::Server=HASH(0xe8691d0)\', \'form\', \'Alias\', \'form_args\', \'HASH(0xebeb4a8)\', \'type\', 145, \'edit_args\', ...) called at lib/MusicBrainz/Server/Controller/Role/Alias.pm line 92
      MusicBrainz::Server::Controller::Role::Alias::add_alias(\'MusicBrainz::Server::Controller::Series=HASH(0xdd78dd8)\', \'MusicBrainz::Server=HASH(0xe8691d0)\') called at /usr/share/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute(\'Catalyst::Action=HASH(0xdf7fa00)\', \'MusicBrainz::Server::Controller::Series=HASH(0xdd78dd8)\', \'MusicBrainz::Server=HASH(0xe8691d0)\') called at /usr/share/perl5/Catalyst.pm line 1691
      eval

      {...} called at /usr/share/perl5/Catalyst.pm line 1691
      Catalyst::execute(\'MusicBrainz::Server=HASH(0xe8691d0)\', \'MusicBrainz::Server::Controller::Series\', \'Catalyst::Action=HASH(0xdf7fa00)\') called at /usr/share/perl5/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute(\'MusicBrainz::Server=HASH(0xe8691d0)\', \'MusicBrainz::Server::Controller::Series\', \'Catalyst::Action=HASH(0xdf7fa00)\') called at /usr/share/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch(\'Catalyst::Action=HASH(0xdf7fa00)\', \'MusicBrainz::Server=HASH(0xe8691d0)\') called at /usr/share/perl5/Catalyst/ActionChain.pm line 38
      Catalyst::ActionChain::dispatch(\'Catalyst::ActionChain=HASH(0xe87bda8)\', \'MusicBrainz::Server=HASH(0xe8691d0)\') called at /usr/share/perl5/Catalyst/Controller.pm line 125
      Catalyst::Controller::_ACTION(\'MusicBrainz::Server::Controller::Series=HASH(0xdd78dd8)\', \'MusicBrainz::Server=HASH(0xe8691d0)\') called at /usr/share/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute(\'Catalyst::Action=HASH(0xdf089d8)\', \'MusicBrainz::Server::Controller::Series=HASH(0xdd78dd8)\', \'MusicBrainz::Server=HASH(0xe8691d0)\') called at /usr/share/perl5/Catalyst.pm line 1691
      eval {...}

      called at /usr/share/perl5/Catalyst.pm line 1691
      Catalyst::execute(\'MusicBrainz::Server=HASH(0xe8691d0)\', \'MusicBrainz::Server::Controller::Series\', \'Catalyst::Action=HASH(0xdf089d8)\') called at /usr/share/perl5/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute(\'MusicBrainz::Server=HASH(0xe8691d0)\', \'MusicBrainz::Server::Controller::Series\', \'Catalyst::Action=HASH(0xdf089d8)\') called at /usr/share/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch(\'Catalyst::Action=HASH(0xdf089d8)\', \'MusicBrainz::Server=HASH(0xe8691d0)\') called at /usr/share/perl5/Catalyst/Dispatcher.pm line 257
      Catalyst::Dispatcher::_do_forward(\'Catalyst::Dispatcher=HASH(0x43e2948)\', \'forward\', \'MusicBrainz::Server=HASH(0xe8691d0)\', \'_ACTION\') called at /usr/share/perl5/Catalyst/Dispatcher.pm line 237
      Catalyst::Dispatcher::forward(\'Catalyst::Dispatcher=HASH(0x43e2948)\', \'MusicBrainz::Server=HASH(0xe8691d0)\', \'_ACTION\') called at /usr/share/perl5/Catalyst.pm line 358
      Catalyst::forward(\'MusicBrainz::Server=HASH(0xe8691d0)\', \'_ACTION\') called at /usr/share/perl5/Catalyst/Controller.pm line 99
      Catalyst::Controller::_DISPATCH(\'MusicBrainz::Server::Controller::Series=HASH(0xdd78dd8)\', \'MusicBrainz::Server=HASH(0xe8691d0)\') called at /usr/share/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute(\'Catalyst::Action=HASH(0xdf036c0)\', \'MusicBrainz::Server::Controller::Series=HASH(0xdd78dd8)\', \'MusicBrainz::Server=HASH(0xe8691d0)\') called at /usr/share/perl5/Catalyst.pm line 1691
      eval

      {...} called at /usr/share/perl5/Catalyst.pm line 1691
      Catalyst::execute(\'MusicBrainz::Server=HASH(0xe8691d0)\', \'MusicBrainz::Server::Controller::Series\', \'Catalyst::Action=HASH(0xdf036c0)\') called at /usr/share/perl5/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute(\'MusicBrainz::Server=HASH(0xe8691d0)\', \'MusicBrainz::Server::Controller::Series\', \'Catalyst::Action=HASH(0xdf036c0)\') called at /usr/share/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch(\'Catalyst::Action=HASH(0xdf036c0)\', \'MusicBrainz::Server=HASH(0xe8691d0)\') called at /usr/share/perl5/Catalyst/Dispatcher.pm line 257
      Catalyst::Dispatcher::_do_forward(\'Catalyst::Dispatcher=HASH(0x43e2948)\', \'forward\', \'MusicBrainz::Server=HASH(0xe8691d0)\', \'/series/_DISPATCH\') called at /usr/share/perl5/Catalyst/Dispatcher.pm line 237
      Catalyst::Dispatcher::forward(\'Catalyst::Dispatcher=HASH(0x43e2948)\', \'MusicBrainz::Server=HASH(0xe8691d0)\', \'/series/_DISPATCH\') called at /usr/share/perl5/Catalyst.pm line 358
      Catalyst::forward(\'MusicBrainz::Server=HASH(0xe8691d0)\', \'/series/_DISPATCH\') called at /usr/share/perl5/Catalyst/Dispatcher.pm line 105
      Catalyst::Dispatcher::dispatch(\'Catalyst::Dispatcher=HASH(0x43e2948)\', \'MusicBrainz::Server=HASH(0xe8691d0)\') called at /usr/share/perl5/Catalyst.pm line 1637
      Catalyst::dispatch(\'MusicBrainz::Server=HASH(0xe8691d0)\') called at lib/MusicBrainz/Server.pm line 335
      MusicBrainz::Server::_ANON_() called at lib/MusicBrainz/Server.pm line 309
      MusicBrainz::Server::with_translations(\'MusicBrainz::Server=HASH(0xe8691d0)\', \'CODE(0xea40518)\') called at lib/MusicBrainz/Server.pm line 336
      Class::MOP::Class:::around(\'CODE(0x380d2e0)\', \'MusicBrainz::Server=HASH(0xe8691d0)\') called at /usr/lib/perl5/Class/MOP/Method/Wrapped.pm line 162
      Class::MOP::Method::Wrapped::_ANON_(\'MusicBrainz::Server=HASH(0xe8691d0)\') called at lib/MusicBrainz/Server.pm line 350
      Class::MOP::Class:::around(\'CODE(0x43e27f8)\', \'MusicBrainz::Server=HASH(0xe8691d0)\') called at /usr/lib/perl5/Class/MOP/Method/Wrapped.pm line 162
      Class::MOP::Method::Wrapped::_ANON_(\'MusicBrainz::Server=HASH(0xe8691d0)\') called at lib/MusicBrainz/Server.pm line 395
      Class::MOP::Class:::around(\'CODE(0xe3883d8)\', \'MusicBrainz::Server=HASH(0xe8691d0)\') called at /usr/lib/perl5/Class/MOP/Method/Wrapped.pm line 162
      Class::MOP::Method::Wrapped::_ANON_(\'MusicBrainz::Server=HASH(0xe8691d0)\') called at /usr/lib/perl5/Class/MOP/Method/Wrapped.pm line 35
      Class::MOP::Method::Wrapped::_ANON_(\'MusicBrainz::Server=HASH(0xe8691d0)\') called at /usr/lib/perl5/Class/MOP/Method/Wrapped.pm line 91
      MusicBrainz::Server::dispatch(\'MusicBrainz::Server=HASH(0xe8691d0)\') called at /usr/share/perl5/Catalyst.pm line 1987
      Catalyst::_ANON_() called at /usr/share/perl5/Try/Tiny.pm line 76
      eval {...}

      called at /usr/share/perl5/Try/Tiny.pm line 67
      Try::Tiny::try(\'CODE(0xe875950)\', \'Try::Tiny::Catch=REF(0xe8e4420)\') called at /usr/share/perl5/Catalyst.pm line 1993
      Catalyst::handle_request(\'MusicBrainz::Server\', \'env\', \'HASH(0xe8e40a8)\', \'response_cb\', \'CODE(0xe8e1a80)\') called at /usr/share/perl5/Catalyst/Plugin/AutoRestart.pm line 117
      Catalyst::Plugin::AutoRestart::handle_request(\'MusicBrainz::Server\', \'env\', \'HASH(0xe8e40a8)\', \'response_cb\', \'CODE(0xe8e1a80)\') called at /usr/share/perl5/Catalyst/Engine.pm line 682
      Catalyst::Engine::_ANON_(\'CODE(0xe8e1a80)\') called at /usr/share/perl5/Starman/Server.pm line 225
      Starman::Server::process_request(\'Starman::Server=HASH(0x1973910)\') called at /usr/share/perl5/Net/Server.pm line 142
      Net::Server::run_client_connection(\'Starman::Server=HASH(0x1973910)\') called at /usr/share/perl5/Net/Server/PreFork.pm line 273
      eval

      {...}

      called at /usr/share/perl5/Net/Server/PreFork.pm line 273
      Net::Server::PreFork::run_child(\'Starman::Server=HASH(0x1973910)\') called at /usr/share/perl5/Net/Server/PreFork.pm line 229
      Net::Server::PreFork::run_n_children(\'Starman::Server=HASH(0x1973910)\', 1) called at /usr/share/perl5/Net/Server/PreFork.pm line 456
      Net::Server::PreFork::coordinate_children(\'Starman::Server=HASH(0x1973910)\') called at /usr/share/perl5/Net/Server/PreFork.pm line 357
      Net::Server::PreFork::run_parent(\'Starman::Server=HASH(0x1973910)\') called at /usr/share/perl5/Starman/Server.pm line 104
      Starman::Server::run_parent(\'Starman::Server=HASH(0x1973910)\') called at /usr/share/perl5/Net/Server/PreFork.pm line 147
      Net::Server::PreFork::loop(\'Starman::Server=HASH(0x1973910)\') called at /usr/share/perl5/Net/Server.pm line 117
      Net::Server::run(\'Starman::Server=HASH(0x1973910)\', \'port\', \'ARRAY(0x39e5220)\', \'host\', \'ARRAY(0x39e52f8)\', \'proto\', \'ARRAY(0xe56e2f8)\', \'serialize\', \'flock\', ...) called at /usr/share/perl5/Starman/Server.pm line 61
      Starman::Server::run(\'Starman::Server=HASH(0x1973910)\', \'CODE(0x19ab108)\', \'HASH(0x19a3450)\') called at /usr/share/perl5/Plack/Handler/Starman.pm line 18
      Plack::Handler::Starman::run(\'Plack::Handler::Starman=HASH(0x1973970)\', \'CODE(0x19ab108)\') called at /usr/share/perl5/Plack/Loader.pm line 88
      Plack::Loader::run(\'Plack::Loader=HASH(0x196e4f0)\', \'Plack::Handler::Starman=HASH(0x1973970)\') called at /usr/share/perl5/Plack/Runner.pm line 263
      Plack::Runner::run(\'Plack::Runner=HASH(0x1764898)\') called at /usr/local/bin/starman line 31
      ';
      at lib/MusicBrainz/Server/Controller.pm line 105
      at lib/Sql.pm line 320"

      Stack trace:

      line 19 MusicBrainz::Server::Model::MB
      line 202 MusicBrainz::Server::Controller
      line 57 MusicBrainz::Server::Controller::Role::EditRelationships
      line 92 MusicBrainz::Server::Controller::Role::Alias
      line 335 MusicBrainz::Server
      line 309 MusicBrainz::Server
      line 336 MusicBrainz::Server
      line 350 MusicBrainz::Server
      line 395 MusicBrainz::Server

      Request data:

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

      { 'edit-alias.as_auto_editor' => '1', 'edit-alias.edit_note' => '', 'edit-alias.type_id' => '2', 'edit-alias.name' => 'ISOS' }

      };

      Time: 2014-05-14 17:27:36 UTC

      Host: asterix

      URL: https://musicbrainz.org/series/b64c3640-79fc-43c0-9fef-addb6d04d8aa/add-alias

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: