Issue Details (XML | Word | Printable)

Key: MBS-7530
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Normal Normal
Assignee: Michael Wiencek
Reporter: Marko Sultsing
Votes: 0
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
MusicBrainz Server

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

Created: 14/May/14 05:28 PM   Updated: 16/May/14 02:59 PM   Resolved: 16/May/14 02:59 PM
Component/s: None
Affects Version/s: None
Fix Version/s: 2014-05-26

Issue Links:
Duplicate
 
Relates
 


 Description  « Hide

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



Sort Order: Ascending order - Click to sort in descending order
Ian McEwen added a comment - 14/May/14 06:37 PM

Note: I've run the script that should fix this, but it'll be in the next release (or a hotfix) as far as the actual code goes.


Ian McEwen added a comment - 16/May/14 02:59 PM

Should be fixed, missing triggers was all.