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

Internal server error trying to register the username "0"

    XMLWordPrintable

    Details

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

      Description

      Oops, something went wrong!

      Error:

      Caught exception in MusicBrainz::Server::Controller::Account->register "DBD::Pg::st execute failed: ERROR: duplicate key value violates unique constraint "editor_idx_name"
      DETAIL: Key (lower(name::text))=(0) already exists. at lib/Sql.pm line 440, line 3.
      at lib/Sql.pm line 455, line 3.
      Sql::_ANON_('DBD::Pg::st execute failed: ERROR: duplicate key value viola...') called at local/lib/perl5/Try/Tiny.pm line 100
      Try::Tiny::try('CODE(0xecdb0e0)', 'Try::Tiny::Catch=REF(0xece7308)') called at lib/Sql.pm line 456
      Sql::_select_list('Sql=HASH(0xecfdc08)', 'INSERT INTO editor (password,name) VALUES (?,?) RETURNING id', 'ARRAY(0x5d1bd40)', 'arrayref', 'CODE(0x5d27280)') called at lib/Sql.pm line 475
      Sql::select_list_of_lists('Sql=HASH(0xecfdc08)', 'INSERT INTO editor (password,name) VALUES (?,?) RETURNING id', 'test', 0) called at lib/Sql.pm line 408
      Sql::select_single_column_array('Sql=HASH(0xecfdc08)', 'INSERT INTO editor (password,name) VALUES (?,?) RETURNING id', 'test', 0) called at lib/Sql.pm line 423
      Sql::select_single_value('Sql=HASH(0xecfdc08)', 'INSERT INTO editor (password,name) VALUES (?,?) RETURNING id', 'test', 0) called at lib/Sql.pm line 150
      Sql::insert_row('Sql=HASH(0xecfdc08)', 'editor', 'HASH(0xece3b38)', 'id') called at lib/MusicBrainz/Server/Data/Editor.pm line 223
      MusicBrainz::Server::Data::Editor::_ANON_() called at lib/Sql.pm line 306
      Sql::_ANON_() called at local/lib/perl5/Try/Tiny.pm line 71
      eval

      Unknown macro: {...}

      called at local/lib/perl5/Try/Tiny.pm line 67
      Try::Tiny::try('CODE(0xec388c8)', 'Try::Tiny::Catch=REF(0xed08540)') called at lib/Sql.pm line 320
      Sql::_auto_transaction('CODE(0xece3ac0)', 'Sql=HASH(0xecfdc08)') called at lib/Sql.pm line 325
      Sql::_run_in_transaction_one('CODE(0xece3ac0)', 'Sql=HASH(0xecfdc08)') called at lib/Sql.pm line 339
      Sql::run_in_transaction('CODE(0xece3ac0)', 'Sql=HASH(0xecfdc08)') called at lib/MusicBrainz/Server/Data/Editor.pm line 233
      MusicBrainz::Server::Data::Editor::insert('MusicBrainz::Server::Data::Editor=HASH(0xc24d1d8)', 'HASH(0xece3b38)') called at lib/MusicBrainz/Server/Controller/Account.pm line 446
      MusicBrainz::Server::Controller::Account::register('MusicBrainz::Server::Controller::Account=HASH(0xd3dac48)', 'MusicBrainz::Server=HASH(0xeb10420)') called at local/lib/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute('Catalyst::Action=HASH(0xd94a2e8)', 'MusicBrainz::Server::Controller::Account=HASH(0xd3dac48)', 'MusicBrainz::Server=HASH(0xeb10420)') called at local/lib/perl5/Catalyst.pm line 1672
      eval

      called at local/lib/perl5/Catalyst.pm line 1672
      Catalyst::execute('MusicBrainz::Server=HASH(0xeb10420)', 'MusicBrainz::Server::Controller::Account', 'Catalyst::Action=HASH(0xd94a2e8)') called at local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xeb10420)', 'MusicBrainz::Server::Controller::Account', 'Catalyst::Action=HASH(0xd94a2e8)') called at local/lib/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch('Catalyst::Action=HASH(0xd94a2e8)', 'MusicBrainz::Server=HASH(0xeb10420)') called at local/lib/perl5/Catalyst/Controller.pm line 158
      Catalyst::Controller::_ACTION('MusicBrainz::Server::Controller::Account=HASH(0xd3dac48)', 'MusicBrainz::Server=HASH(0xeb10420)') called at local/lib/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute('Catalyst::Action=HASH(0xd9438c0)', 'MusicBrainz::Server::Controller::Account=HASH(0xd3dac48)', 'MusicBrainz::Server=HASH(0xeb10420)') called at local/lib/perl5/Catalyst.pm line 1672
      eval

      Unknown macro: {...}

      called at local/lib/perl5/Catalyst.pm line 1672
      Catalyst::execute('MusicBrainz::Server=HASH(0xeb10420)', 'MusicBrainz::Server::Controller::Account', 'Catalyst::Action=HASH(0xd9438c0)') called at local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xeb10420)', 'MusicBrainz::Server::Controller::Account', 'Catalyst::Action=HASH(0xd9438c0)') called at local/lib/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch('Catalyst::Action=HASH(0xd9438c0)', 'MusicBrainz::Server=HASH(0xeb10420)') called at local/lib/perl5/Catalyst/Dispatcher.pm line 257
      Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x4cbb6d0)', 'forward', 'MusicBrainz::Server=HASH(0xeb10420)', '_ACTION') called at local/lib/perl5/Catalyst/Dispatcher.pm line 237
      Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x4cbb6d0)', 'MusicBrainz::Server=HASH(0xeb10420)', '_ACTION') called at local/lib/perl5/Catalyst.pm line 362
      Catalyst::forward('MusicBrainz::Server=HASH(0xeb10420)', '_ACTION') called at local/lib/perl5/Catalyst/Controller.pm line 132
      Catalyst::Controller::_DISPATCH('MusicBrainz::Server::Controller::Account=HASH(0xd3dac48)', 'MusicBrainz::Server=HASH(0xeb10420)') called at local/lib/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute('Catalyst::Action=HASH(0xd943578)', 'MusicBrainz::Server::Controller::Account=HASH(0xd3dac48)', 'MusicBrainz::Server=HASH(0xeb10420)') called at local/lib/perl5/Catalyst.pm line 1672
      eval

      called at local/lib/perl5/Catalyst.pm line 1672
      Catalyst::execute('MusicBrainz::Server=HASH(0xeb10420)', 'MusicBrainz::Server::Controller::Account', 'Catalyst::Action=HASH(0xd943578)') called at local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xeb10420)', 'MusicBrainz::Server::Controller::Account', 'Catalyst::Action=HASH(0xd943578)') called at local/lib/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch('Catalyst::Action=HASH(0xd943578)', 'MusicBrainz::Server=HASH(0xeb10420)') called at local/lib/perl5/Catalyst/Dispatcher.pm line 257
      Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x4cbb6d0)', 'forward', 'MusicBrainz::Server=HASH(0xeb10420)', '/account/_DISPATCH') called at local/lib/perl5/Catalyst/Dispatcher.pm line 237
      Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x4cbb6d0)', 'MusicBrainz::Server=HASH(0xeb10420)', '/account/_DISPATCH') called at local/lib/perl5/Catalyst.pm line 362
      Catalyst::forward('MusicBrainz::Server=HASH(0xeb10420)', '/account/_DISPATCH') called at local/lib/perl5/Catalyst/Dispatcher.pm line 105
      Catalyst::Dispatcher::dispatch('Catalyst::Dispatcher=HASH(0x4cbb6d0)', 'MusicBrainz::Server=HASH(0xeb10420)') called at local/lib/perl5/Catalyst.pm line 1618
      Catalyst::dispatch('MusicBrainz::Server=HASH(0xeb10420)') called at lib/MusicBrainz/Server.pm line 326
      MusicBrainz::Server::_ANON_() called at lib/MusicBrainz/Server.pm line 300
      MusicBrainz::Server::with_translations('MusicBrainz::Server=HASH(0xeb10420)', 'CODE(0xe914768)') called at lib/MusicBrainz/Server.pm line 327
      Class::MOP::Class:::around('CODE(0x408f218)', 'MusicBrainz::Server=HASH(0xeb10420)') 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(0xeb10420)') called at lib/MusicBrainz/Server.pm line 341
      Class::MOP::Class:::around('CODE(0xd984e78)', 'MusicBrainz::Server=HASH(0xeb10420)') 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(0xeb10420)') called at lib/MusicBrainz/Server.pm line 386
      Class::MOP::Class:::around('CODE(0xd998058)', 'MusicBrainz::Server=HASH(0xeb10420)') 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(0xeb10420)') called at local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 35
      Class::MOP::Method::Wrapped::_ANON_('MusicBrainz::Server=HASH(0xeb10420)') called at local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 91
      MusicBrainz::Server::dispatch('MusicBrainz::Server=HASH(0xeb10420)') called at local/lib/perl5/Catalyst.pm line 1968
      Catalyst::_ANON_() called at local/lib/perl5/Try/Tiny.pm line 76
      eval

      Unknown macro: {...}

      called at local/lib/perl5/Try/Tiny.pm line 67
      Try::Tiny::try('CODE(0x5a1bee0)', 'Try::Tiny::Catch=REF(0xeb08b08)') called at local/lib/perl5/Catalyst.pm line 1974
      Catalyst::handle_request('MusicBrainz::Server', 'env', 'HASH(0xeb21968)', 'response_cb', 'CODE(0xe5aa378)') called at local/lib/perl5/Catalyst/Plugin/AutoRestart.pm line 117
      Catalyst::Plugin::AutoRestart::handle_request('MusicBrainz::Server', 'env', 'HASH(0xeb21968)', 'response_cb', 'CODE(0xe5aa378)') called at local/lib/perl5/Catalyst/Engine.pm line 688
      Catalyst::Engine::_ANON_('CODE(0xe5aa378)') called at local/lib/perl5/Plack/Handler/FCGI.pm line 130
      Plack::Handler::FCGI::run('Plack::Handler::FCGI=HASH(0x1fd39d0)', 'CODE(0xd9b7120)') called at local/lib/perl5/Plack/Loader.pm line 84
      Plack::Loader::run('Plack::Loader=HASH(0x1efac90)', 'Plack::Handler::FCGI=HASH(0x1fd39d0)') called at local/lib/perl5/Plack/Runner.pm line 267
      Plack::Runner::run('Plack::Runner=HASH(0x1d83808)') called at local/bin/plackup line 10
      at lib/Sql.pm line 320."
      Stack trace:
      line 233 MusicBrainz::Server::Data::Editor
      line 446 MusicBrainz::Server::Controller::Account
      line 326 MusicBrainz::Server
      line 300 MusicBrainz::Server
      line 327 MusicBrainz::Server
      line 341 MusicBrainz::Server
      line 386 MusicBrainz::Server
      Request data:

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

      Unknown macro: { 'register.email' => '', 'register.confirm_password' => 'test', 'register.password' => 'test', 'recaptcha_response_field' => 'into soryrat', 'recaptcha_challenge_field' => '03AHJ_VuuBiv8MMNEC1ljGeyoCZWBxSWHiem5wEaIi1w-vpHJx2Z-6G5sXQSQp7wXsxXP2pOAXXDdbN-7wKgXCBZMYLNcRDBQLomrhpXhksSzH5XWN6I8rdP3e4U1ap43cIAZJkwQQEusbV552MWpRHG8cvjmGD3kz8BA4zgCMZNJvAxFwXcBUVr0', 'register.username' => '0' }

      };

      Host: astro

      URL: http://musicbrainz.org/register

        Attachments

          Activity

            People

            • Assignee:
              ianmcorvidae Ian McEwen
              Reporter:
              nikki nikki
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Due:
                Created:
                Updated:
                Resolved:

                Packages

                Version Package
                2013-08-05