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

Internal server error in the release editor (new row for relation "release_group" violates check constraint "control_for_whitespace")

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • 2014-04-28
    • None
    • Release editor
    • None

      Steps to reproduce:

      Gives the following error:

      DBD::Pg::st execute failed: ERROR: new row for relation "release_group" violates check constraint "control_for_whitespace" at lib/Sql.pm line 443, <$fh> line 1. at lib/Sql.pm line 456 Sql::_ANON('DBD::Pg::st execute failed: ERROR: new row for relation "rel...') called at /usr/share/perl5/Try/Tiny.pm line 100 Try::Tiny::try('CODE(0x101ffe90)', 'Try::Tiny::Catch=REF(0x105d00c0)', 'Try::Tiny::Finally=REF(0x105d00a8)') called at lib/Sql.pm line 460 Sql::_select_list('Sql=HASH(0x398d0a8)', 'INSERT INTO release_group (comment,name,type,artist_credit,gi...', 'ARRAY(0x105d03d8)', 'arrayref', 'CODE(0x4956da8)') called at lib/Sql.pm line 479 Sql::select_list_of_lists('Sql=HASH(0x398d0a8)', 'INSERT INTO release_group (comment,name,type,artist_credit,gi...', '', 'test ', undef, 1273959, '4ca3660f-d438-410e-ad29-484ac98df806') called at lib/Sql.pm line 410 Sql::select_single_column_array('Sql=HASH(0x398d0a8)', 'INSERT INTO release_group (comment,name,type,artist_credit,gi...', '', 'test ', undef, 1273959, '4ca3660f-d438-410e-ad29-484ac98df806') called at lib/Sql.pm line 425 Sql::select_single_value('Sql=HASH(0x398d0a8)', 'INSERT INTO release_group (comment,name,type,artist_credit,gi...', '', 'test ', undef, 1273959, '4ca3660f-d438-410e-ad29-484ac98df806') called at lib/Sql.pm line 150 Sql::insert_row('Sql=HASH(0x398d0a8)', 'release_group', 'HASH(0x4a071b8)', 'id') called at lib/MusicBrainz/Server/Data/ReleaseGroup.pm line 436 MusicBrainz::Server::Data::ReleaseGroup::insert('MusicBrainz::Server::Data::ReleaseGroup=HASH(0xc03f920)', 'HASH(0x10611d30)') called at lib/MusicBrainz/Server/Edit/Generic/Create.pm line 47 MusicBrainz::Server::Edit::Generic::Create::insert('MusicBrainz::Server::Edit::ReleaseGroup::Create=HASH(0x1052b910)') called at lib/MusicBrainz/Server/Data/Edit.pm line 454 MusicBrainz::Server::Data::Edit::create('MusicBrainz::Server::Data::Edit=HASH(0xb62fd48)', 'editor_id', 53705, 'privileges', 440, 'primary_type_id', undef, 'comment', '', ...) called at lib/MusicBrainz/Server/Controller/WS/js/Edit.pm line 336 MusicBrainz::Server::Controller::WS::js::Edit::ANON_() called at /usr/share/perl5/Try/Tiny.pm line 76 eval

      Unknown macro: {...}

      called at /usr/share/perl5/Try/Tiny.pm line 67 Try::Tiny::try('CODE(0xd5545e8)', 'Try::Tiny::Catch=REF(0xd55ad40)') called at lib/MusicBrainz/Server/Controller/WS/js/Edit.pm line 346 MusicBrainz::Server::Controller::WS::js::Edit::create_edits('MusicBrainz::Server::Controller::WS::js::Edit=HASH(0xc891d90)', 'MusicBrainz::Server=HASH(0xd433918)', 'HASH(0xd54e640)') called at lib/MusicBrainz/Server/Controller/WS/js/Edit.pm line 377 MusicBrainz::Server::Controller::WS::js::Edit::_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(0xd00ec58)', 'Try::Tiny::Catch=REF(0xd6abfd0)') called at lib/Sql.pm line 320 Sql::_auto_transaction('CODE(0xd6c4d40)', 'Sql=HASH(0x398d0a8)') called at lib/Sql.pm line 325 Sql::_run_in_transaction_one('CODE(0xd6c4d40)', 'Sql=HASH(0x398d0a8)') called at lib/Sql.pm line 339 Sql::run_in_transaction('CODE(0xd6c4d40)', 'Sql=HASH(0x398d0a8)') called at lib/MusicBrainz/Server/Model/MB.pm line 19 MusicBrainz::Server::Model::MB::with_transaction('MusicBrainz::Server::Model::MB=HASH(0xaf269d8)', 'CODE(0xd6c4d40)') called at lib/MusicBrainz/Server/Controller/WS/js/Edit.pm line 388 MusicBrainz::Server::Controller::WS::js::Edit::create('MusicBrainz::Server::Controller::WS::js::Edit=HASH(0xc891d90)', 'MusicBrainz::Server=HASH(0xd433918)') called at /usr/share/perl5/Catalyst/Action.pm line 65 Catalyst::Action::execute('Catalyst::Action=HASH(0xccc4cd0)', 'MusicBrainz::Server::Controller::WS::js::Edit=HASH(0xc891d90)', 'MusicBrainz::Server=HASH(0xd433918)') called at /usr/share/perl5/Catalyst.pm line 1691 eval

      Unknown macro: {...}

      called at /usr/share/perl5/Catalyst.pm line 1691 Catalyst::execute('MusicBrainz::Server=HASH(0xd433918)', 'MusicBrainz::Server::Controller::WS::js::Edit', 'Catalyst::Action=HASH(0xccc4cd0)') called at /usr/share/perl5/Catalyst/Plugin/StackTrace.pm line 94 Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xd433918)', 'MusicBrainz::Server::Controller::WS::js::Edit', 'Catalyst::Action=HASH(0xccc4cd0)') called at /usr/share/perl5/Catalyst/Action.pm line 60 Catalyst::Action::dispatch('Catalyst::Action=HASH(0xccc4cd0)', 'MusicBrainz::Server=HASH(0xd433918)') called at /usr/share/perl5/Catalyst/ActionChain.pm line 38 Catalyst::ActionChain::dispatch('Catalyst::ActionChain=HASH(0xd6a2ef0)', 'MusicBrainz::Server=HASH(0xd433918)') called at /usr/share/perl5/Catalyst/Controller.pm line 125 Catalyst::Controller::_ACTION('MusicBrainz::Server::Controller::WS::js::Edit=HASH(0xc891d90)', 'MusicBrainz::Server=HASH(0xd433918)') called at /usr/share/perl5/Catalyst/Action.pm line 65 Catalyst::Action::execute('Catalyst::Action=HASH(0xccc46d0)', 'MusicBrainz::Server::Controller::WS::js::Edit=HASH(0xc891d90)', 'MusicBrainz::Server=HASH(0xd433918)') called at /usr/share/perl5/Catalyst.pm line 1691 eval

      called at /usr/share/perl5/Catalyst.pm line 1691 Catalyst::execute('MusicBrainz::Server=HASH(0xd433918)', 'MusicBrainz::Server::Controller::WS::js::Edit', 'Catalyst::Action=HASH(0xccc46d0)') called at /usr/share/perl5/Catalyst/Plugin/StackTrace.pm line 94 Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xd433918)', 'MusicBrainz::Server::Controller::WS::js::Edit', 'Catalyst::Action=HASH(0xccc46d0)') called at /usr/share/perl5/Catalyst/Action.pm line 60 Catalyst::Action::dispatch('Catalyst::Action=HASH(0xccc46d0)', 'MusicBrainz::Server=HASH(0xd433918)') called at /usr/share/perl5/Catalyst/Dispatcher.pm line 257 Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x38ad848)', 'forward', 'MusicBrainz::Server=HASH(0xd433918)', '_ACTION') called at /usr/share/perl5/Catalyst/Dispatcher.pm line 237 Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x38ad848)', 'MusicBrainz::Server=HASH(0xd433918)', '_ACTION') called at /usr/share/perl5/Catalyst.pm line 358 Catalyst::forward('MusicBrainz::Server=HASH(0xd433918)', '_ACTION') called at /usr/share/perl5/Catalyst/Controller.pm line 99 Catalyst::Controller::_DISPATCH('MusicBrainz::Server::Controller::WS::js::Edit=HASH(0xc891d90)', 'MusicBrainz::Server=HASH(0xd433918)') called at /usr/share/perl5/Catalyst/Action.pm line 65 Catalyst::Action::execute('Catalyst::Action=HASH(0xccc4370)', 'MusicBrainz::Server::Controller::WS::js::Edit=HASH(0xc891d90)', 'MusicBrainz::Server=HASH(0xd433918)') called at /usr/share/perl5/Catalyst.pm line 1691 eval

      Unknown macro: {...}

      called at /usr/share/perl5/Catalyst.pm line 1691 Catalyst::execute('MusicBrainz::Server=HASH(0xd433918)', 'MusicBrainz::Server::Controller::WS::js::Edit', 'Catalyst::Action=HASH(0xccc4370)') called at /usr/share/perl5/Catalyst/Plugin/StackTrace.pm line 94 Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xd433918)', 'MusicBrainz::Server::Controller::WS::js::Edit', 'Catalyst::Action=HASH(0xccc4370)') called at /usr/share/perl5/Catalyst/Action.pm line 60 Catalyst::Action::dispatch('Catalyst::Action=HASH(0xccc4370)', 'MusicBrainz::Server=HASH(0xd433918)') called at /usr/share/perl5/Catalyst/Dispatcher.pm line 257 Catalyst::Dispatcher::do_forward('Catalyst::Dispatcher=HASH(0x38ad848)', 'forward', 'MusicBrainz::Server=HASH(0xd433918)', '/ws/js/edit/_DISPATCH') called at /usr/share/perl5/Catalyst/Dispatcher.pm line 237 Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x38ad848)', 'MusicBrainz::Server=HASH(0xd433918)', '/ws/js/edit/_DISPATCH') called at /usr/share/perl5/Catalyst.pm line 358 Catalyst::forward('MusicBrainz::Server=HASH(0xd433918)', '/ws/js/edit/_DISPATCH') called at /usr/share/perl5/Catalyst/Dispatcher.pm line 105 Catalyst::Dispatcher::dispatch('Catalyst::Dispatcher=HASH(0x38ad848)', 'MusicBrainz::Server=HASH(0xd433918)') called at /usr/share/perl5/Catalyst.pm line 1637 Catalyst::dispatch('MusicBrainz::Server=HASH(0xd433918)') 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(0xd433918)', 'CODE(0xd27a570)') called at lib/MusicBrainz/Server.pm line 336 Class::MOP::Class:::around('CODE(0x2d13c70)', 'MusicBrainz::Server=HASH(0xd433918)') called at /usr/lib/perl5/Class/MOP/Method/Wrapped.pm line 162 Class::MOP::Method::Wrapped::ANON('MusicBrainz::Server=HASH(0xd433918)') called at lib/MusicBrainz/Server.pm line 350 Class::MOP::Class:::around('CODE(0x38ad6f8)', 'MusicBrainz::Server=HASH(0xd433918)') called at /usr/lib/perl5/Class/MOP/Method/Wrapped.pm line 162 Class::MOP::Method::Wrapped::ANON('MusicBrainz::Server=HASH(0xd433918)') called at lib/MusicBrainz/Server.pm line 395 Class::MOP::Class:::around('CODE(0xce23b40)', 'MusicBrainz::Server=HASH(0xd433918)') called at /usr/lib/perl5/Class/MOP/Method/Wrapped.pm line 162 Class::MOP::Method::Wrapped::ANON('MusicBrainz::Server=HASH(0xd433918)') called at /usr/lib/perl5/Class/MOP/Method/Wrapped.pm line 35 Class::MOP::Method::Wrapped::ANON('MusicBrainz::Server=HASH(0xd433918)') called at /usr/lib/perl5/Class/MOP/Method/Wrapped.pm line 91 MusicBrainz::Server::dispatch('MusicBrainz::Server=HASH(0xd433918)') 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(0xd6c6b20)', 'Try::Tiny::Catch=REF(0xd5aebe8)') called at /usr/share/perl5/Catalyst.pm line 1993 Catalyst::handle_request('MusicBrainz::Server', 'env', 'HASH(0xd6a29b0)', 'response_cb', 'CODE(0xd72bc30)') called at /usr/share/perl5/Catalyst/Plugin/AutoRestart.pm line 117 Catalyst::Plugin::AutoRestart::handle_request('MusicBrainz::Server', 'env', 'HASH(0xd6a29b0)', 'response_cb', 'CODE(0xd72bc30)') called at /usr/share/perl5/Catalyst/Engine.pm line 682 Catalyst::Engine::_ANON_('CODE(0xd72bc30)') called at /usr/share/perl5/Starman/Server.pm line 225 Starman::Server::process_request('Starman::Server=HASH(0xeba4e0)') called at /usr/share/perl5/Net/Server.pm line 142 Net::Server::run_client_connection('Starman::Server=HASH(0xeba4e0)') called at /usr/share/perl5/Net/Server/PreFork.pm line 273 eval

      Unknown macro: {...}

      called at /usr/share/perl5/Net/Server/PreFork.pm line 273 Net::Server::PreFork::run_child('Starman::Server=HASH(0xeba4e0)') called at /usr/share/perl5/Net/Server/PreFork.pm line 229 Net::Server::PreFork::run_n_children('Starman::Server=HASH(0xeba4e0)', 1) called at /usr/share/perl5/Net/Server/PreFork.pm line 456 Net::Server::PreFork::coordinate_children('Starman::Server=HASH(0xeba4e0)') called at /usr/share/perl5/Net/Server/PreFork.pm line 357 Net::Server::PreFork::run_parent('Starman::Server=HASH(0xeba4e0)') called at /usr/share/perl5/Starman/Server.pm line 104 Starman::Server::run_parent('Starman::Server=HASH(0xeba4e0)') called at /usr/share/perl5/Net/Server/PreFork.pm line 147 Net::Server::PreFork::loop('Starman::Server=HASH(0xeba4e0)') called at /usr/share/perl5/Net/Server.pm line 117 Net::Server::run('Starman::Server=HASH(0xeba4e0)', 'port', 'ARRAY(0x2ed6038)', 'host', 'ARRAY(0x2ed6110)', 'proto', 'ARRAY(0xd001ac0)', 'serialize', 'flock', ...) called at /usr/share/perl5/Starman/Server.pm line 61 Starman::Server::run('Starman::Server=HASH(0xeba4e0)', 'CODE(0xce4ae68)', 'HASH(0xeba468)') called at /usr/share/perl5/Plack/Handler/Starman.pm line 18 Plack::Handler::Starman::run('Plack::Handler::Starman=HASH(0xeba540)', 'CODE(0xce4ae68)') called at /usr/share/perl5/Plack/Loader.pm line 88 Plack::Loader::run('Plack::Loader=HASH(0xe84778)', 'Plack::Handler::Starman=HASH(0xeba540)') called at /usr/share/perl5/Plack/Runner.pm line 263 Plack::Runner::run('Plack::Runner=HASH(0xc7e898)') called at /usr/bin/starman line 31

            bitmap Michael Wiencek
            nikki nikki
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved:

                Version Package
                2014-04-28