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

error on changing artist alias

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Normal Normal
    • None
    • None
    • None
    • None

      This is the 1st time i am getting an error on MB and reporting it.

      The error was on
      https://musicbrainz.org/artist/11844805-f486-48c2-afdd-84f4dd208f4c/alias/330473/edit
      when i tried to set "Guy Wallace" as a primary alias for an artist, but may be because the main alias there was already set, it gives an error.

      Internal Server Error
      Oops, something went wrong!

      Error:

      The edit could not be created. Exception (string): Failed query:
      'UPDATE artist_alias SET primary_for_locale = ? WHERE id = ?'
      (1 330473)
      23505 DBD::Pg::st execute failed: ERROR: duplicate key value violates unique constraint "artist_alias_idx_primary"
      DETAIL: Key (artist, locale)=(894397, en) already exists. [for Statement "UPDATE artist_alias SET primary_for_locale = ? WHERE id = ?" with ParamValues: 1='1', 2='330473']

      Sql::catch

      {...} (MusicBrainz::Server::Exceptions::DatabaseError=HASH(0x562bba185088)) called at /home/musicbrainz/carton-local/lib/perl5/Try/Tiny.pm line 123
      Try::Tiny::try(CODE(0x562bba184ba8), Try::Tiny::Catch=REF(0x562bba0f7080)) called at lib/Sql.pm line 117
      Sql::do(Sql=HASH(0x562bb4265ce8), "UPDATE artist_alias SET primary_for_locale = ? WHERE id = ?", 1, 330473) called at lib/Sql.pm line 203
      Sql::update_row(Sql=HASH(0x562bb4265ce8), "artist_alias", HASH(0x562ba8a8b118), HASH(0x562bba0f6a80)) called at lib/MusicBrainz/Server/Data/Alias.pm line 248
      MusicBrainz::Server::Data::Alias::update(Moose::Meta::Class::_ANON_::SERIAL::93=HASH(0x562bb4ed61a0), 330473, HASH(0x562bba184ae8)) called at lib/MusicBrainz/Server/Edit/Alias/Edit.pm line 165
      MusicBrainz::Server::Edit::Alias::Edit::accept(MusicBrainz::Server::Edit::Artist::EditAlias=HASH(0x562bb9fc37d0)) called at lib/MusicBrainz/Server/Data/Edit.pm line 763
      MusicBrainz::Server::Data::Edit::try {...}

      () called at /home/musicbrainz/carton-local/lib/perl5/Try/Tiny.pm line 100
      eval

      {...} called at /home/musicbrainz/carton-local/lib/perl5/Try/Tiny.pm line 93
      Try::Tiny::try(CODE(0x562bba145558), Try::Tiny::Catch=REF(0x562bba0f66c0)) called at lib/MusicBrainz/Server/Data/Edit.pm line 798
      MusicBrainz::Server::Data::Edit::_do_accept(MusicBrainz::Server::Data::Edit=HASH(0x562bb19cd170), MusicBrainz::Server::Edit::Artist::EditAlias=HASH(0x562bb9fc37d0)) called at lib/MusicBrainz/Server/Data/Edit.pm line 837
      MusicBrainz::Server::Data::Edit::_ANON_(MusicBrainz::Server::Edit::Artist::EditAlias=HASH(0x562bb9fc37d0)) called at lib/MusicBrainz/Server/Data/Edit.pm line 860
      MusicBrainz::Server::Data::Edit::_close(MusicBrainz::Server::Data::Edit=HASH(0x562bb19cd170), MusicBrainz::Server::Edit::Artist::EditAlias=HASH(0x562bb9fc37d0), CODE(0x562bb5ddbb28)) called at lib/MusicBrainz/Server/Data/Edit.pm line 837
      MusicBrainz::Server::Data::Edit::accept(MusicBrainz::Server::Data::Edit=HASH(0x562bb19cd170), MusicBrainz::Server::Edit::Artist::EditAlias=HASH(0x562bb9fc37d0)) called at lib/MusicBrainz/Server/Data/Edit.pm line 607
      MusicBrainz::Server::Data::Edit::create(MusicBrainz::Server::Data::Edit=HASH(0x562bb19cd170), "editor", MusicBrainz::Server::Authentication::User=HASH(0x562bb434d6e0), "privileges", 0, "entity", MusicBrainz::Server::Entity::Artist=HASH(0x562bb4d22258), "begin_date", ...) called at lib/MusicBrainz/Server/Controller.pm line 67
      MusicBrainz::Server::Controller::try {...}

      () called at /home/musicbrainz/carton-local/lib/perl5/Try/Tiny.pm line 102
      eval

      {...} called at /home/musicbrainz/carton-local/lib/perl5/Try/Tiny.pm line 93
      Try::Tiny::try(CODE(0x562bb5d37c48), Try::Tiny::Catch=REF(0x562bb5be4e70)) called at lib/MusicBrainz/Server/Controller.pm line 82
      MusicBrainz::Server::Controller::_insert_edit(MusicBrainz::Server::Controller::Artist=HASH(0x562bb38ff368), MusicBrainz::Server=HASH(0x562bb403a1c8), MusicBrainz::Server::Form::Alias=HASH(0x562bb4eced50), "edit_type", 8, "name", "Guy Wallace", "locale", ...) called at lib/MusicBrainz/Server/Controller.pm line 170
      MusicBrainz::Server::Controller::_ANON_() called at lib/Sql.pm line 322
      Sql::try {...}

      () called at /home/musicbrainz/carton-local/lib/perl5/Try/Tiny.pm line 102
      eval

      {...} called at /home/musicbrainz/carton-local/lib/perl5/Try/Tiny.pm line 93
      Try::Tiny::try(CODE(0x562bb5900af0), Try::Tiny::Catch=REF(0x562bb5be4f30)) called at lib/Sql.pm line 335
      Sql::_auto_transaction(CODE(0x562bb4ecedb0), Sql=HASH(0x562bb4265ce8)) called at lib/Sql.pm line 340
      Sql::_run_in_transaction_one(CODE(0x562bb4ecedb0), Sql=HASH(0x562bb4265ce8)) called at lib/Sql.pm line 355
      Sql::run_in_transaction(CODE(0x562bb4ecedb0), Sql=HASH(0x562bb4265ce8)) called at lib/MusicBrainz/Server/Model/MB.pm line 19
      MusicBrainz::Server::Model::MB::with_transaction(MusicBrainz::Server::Model::MB=HASH(0x562bb11ba580), CODE(0x562bb4ecedb0)) called at lib/MusicBrainz/Server/Controller.pm line 184
      MusicBrainz::Server::Controller::edit_action(MusicBrainz::Server::Controller::Artist=HASH(0x562bb38ff368), MusicBrainz::Server=HASH(0x562bb403a1c8), "form_args", HASH(0x562bb4f4a928), "edit_args", HASH(0x562bb4fd3b60), "on_creation", CODE(0x562bb4f8c0c0), ...) called at lib/MusicBrainz/Server/Controller/Role/EditRelationships.pm line 274
      Class::MOP::Class:::around(CODE(0x562ba7c6ca68), MusicBrainz::Server::Controller::Artist=HASH(0x562bb38ff368), MusicBrainz::Server=HASH(0x562bb403a1c8), "form", "Alias", "form_args", HASH(0x562bb4f4a928), "item", ...) called at /home/musicbrainz/carton-local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 164
      MusicBrainz::Server::Controller::Artist::_wrapped_edit_action(MusicBrainz::Server::Controller::Artist=HASH(0x562bb38ff368), MusicBrainz::Server=HASH(0x562bb403a1c8), "form", "Alias", "form_args", HASH(0x562bb4f4a928), "item", MusicBrainz::Server::Entity::ArtistAlias=HASH(0x562bb4888210), ...) called at /home/musicbrainz/carton-local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 95
      MusicBrainz::Server::Controller::Artist::edit_action(MusicBrainz::Server::Controller::Artist=HASH(0x562bb38ff368), MusicBrainz::Server=HASH(0x562bb403a1c8), "form", "Alias", "form_args", HASH(0x562bb4f4a928), "item", MusicBrainz::Server::Entity::ArtistAlias=HASH(0x562bb4888210), ...) called at lib/MusicBrainz/Server/Controller/Role/Alias.pm line 196
      MusicBrainz::Server::Controller::Role::Alias::edit_alias(MusicBrainz::Server::Controller::Artist=HASH(0x562bb38ff368), MusicBrainz::Server=HASH(0x562bb403a1c8)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Action.pm line 358
      Catalyst::Action::execute(Catalyst::Action=HASH(0x562bb3ad1198), MusicBrainz::Server::Controller::Artist=HASH(0x562bb38ff368), MusicBrainz::Server=HASH(0x562bb403a1c8)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst.pm line 2061
      eval {...}

      called at /home/musicbrainz/carton-local/lib/perl5/Catalyst.pm line 2061
      Catalyst::execute(MusicBrainz::Server=HASH(0x562bb403a1c8), "MusicBrainz::Server::Controller::Artist", Catalyst::Action=HASH(0x562bb3ad1198)) called at lib/Catalyst/Plugin/ErrorInfo.pm line 34
      Catalyst::Plugin::ErrorInfo::execute(MusicBrainz::Server=HASH(0x562bb403a1c8), "MusicBrainz::Server::Controller::Artist", Catalyst::Action=HASH(0x562bb3ad1198)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Action.pm line 353
      Catalyst::Action::dispatch(Catalyst::Action=HASH(0x562bb3ad1198), MusicBrainz::Server=HASH(0x562bb403a1c8)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/ActionChain.pm line 46
      Catalyst::ActionChain::dispatch(Catalyst::ActionChain=HASH(0x562bb4047dd0), MusicBrainz::Server=HASH(0x562bb403a1c8)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Controller.pm line 170
      Catalyst::Controller::_ACTION(MusicBrainz::Server::Controller::Artist=HASH(0x562bb38ff368), MusicBrainz::Server=HASH(0x562bb403a1c8)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Action.pm line 358
      Catalyst::Action::execute(Catalyst::Action=HASH(0x562bb3ac3810), MusicBrainz::Server::Controller::Artist=HASH(0x562bb38ff368), MusicBrainz::Server=HASH(0x562bb403a1c8)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst.pm line 2061
      eval

      {...} called at /home/musicbrainz/carton-local/lib/perl5/Catalyst.pm line 2061
      Catalyst::execute(MusicBrainz::Server=HASH(0x562bb403a1c8), "MusicBrainz::Server::Controller::Artist", Catalyst::Action=HASH(0x562bb3ac3810)) called at lib/Catalyst/Plugin/ErrorInfo.pm line 34
      Catalyst::Plugin::ErrorInfo::execute(MusicBrainz::Server=HASH(0x562bb403a1c8), "MusicBrainz::Server::Controller::Artist", Catalyst::Action=HASH(0x562bb3ac3810)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Action.pm line 353
      Catalyst::Action::dispatch(Catalyst::Action=HASH(0x562bb3ac3810), MusicBrainz::Server=HASH(0x562bb403a1c8)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Dispatcher.pm line 261
      Catalyst::Dispatcher::_do_forward(Catalyst::Dispatcher=HASH(0x562ba6db8b58), "forward", MusicBrainz::Server=HASH(0x562bb403a1c8), "_ACTION") called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Dispatcher.pm line 241
      Catalyst::Dispatcher::forward(Catalyst::Dispatcher=HASH(0x562ba6db8b58), MusicBrainz::Server=HASH(0x562bb403a1c8), "_ACTION") called at /home/musicbrainz/carton-local/lib/perl5/Catalyst.pm line 483
      Catalyst::forward(MusicBrainz::Server=HASH(0x562bb403a1c8), "_ACTION") called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Controller.pm line 134
      Catalyst::Controller::_DISPATCH(MusicBrainz::Server::Controller::Artist=HASH(0x562bb38ff368), MusicBrainz::Server=HASH(0x562bb403a1c8)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Action.pm line 358
      Catalyst::Action::execute(Catalyst::Action=HASH(0x562bb3aa7350), MusicBrainz::Server::Controller::Artist=HASH(0x562bb38ff368), MusicBrainz::Server=HASH(0x562bb403a1c8)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst.pm line 2061
      eval {...}

      called at /home/musicbrainz/carton-local/lib/perl5/Catalyst.pm line 2061
      Catalyst::execute(MusicBrainz::Server=HASH(0x562bb403a1c8), "MusicBrainz::Server::Controller::Artist", Catalyst::Action=HASH(0x562bb3aa7350)) called at lib/Catalyst/Plugin/ErrorInfo.pm line 34
      Catalyst::Plugin::ErrorInfo::execute(MusicBrainz::Server=HASH(0x562bb403a1c8), "MusicBrainz::Server::Controller::Artist", Catalyst::Action=HASH(0x562bb3aa7350)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Action.pm line 353
      Catalyst::Action::dispatch(Catalyst::Action=HASH(0x562bb3aa7350), MusicBrainz::Server=HASH(0x562bb403a1c8)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Dispatcher.pm line 261
      Catalyst::Dispatcher::_do_forward(Catalyst::Dispatcher=HASH(0x562ba6db8b58), "forward", MusicBrainz::Server=HASH(0x562bb403a1c8), "/artist/_DISPATCH") called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Dispatcher.pm line 241
      Catalyst::Dispatcher::forward(Catalyst::Dispatcher=HASH(0x562ba6db8b58), MusicBrainz::Server=HASH(0x562bb403a1c8), "/artist/_DISPATCH") called at /home/musicbrainz/carton-local/lib/perl5/Catalyst.pm line 483
      Catalyst::forward(MusicBrainz::Server=HASH(0x562bb403a1c8), "/artist/_DISPATCH") called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Dispatcher.pm line 107
      Catalyst::Dispatcher::dispatch(Catalyst::Dispatcher=HASH(0x562ba6db8b58), MusicBrainz::Server=HASH(0x562bb403a1c8)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst.pm line 2007
      Catalyst::dispatch(MusicBrainz::Server=HASH(0x562bb403a1c8)) called at lib/MusicBrainz/Server.pm line 390
      MusicBrainz::Server::_ANON_() called at lib/MusicBrainz/Server.pm line 357
      MusicBrainz::Server::with_translations(MusicBrainz::Server=HASH(0x562bb403a1c8), CODE(0x562bb4051dc8)) called at lib/MusicBrainz/Server.pm line 391
      Class::MOP::Class:::around(CODE(0x562ba2bfd9c8), MusicBrainz::Server=HASH(0x562bb403a1c8)) called at /home/musicbrainz/carton-local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 164
      Class::MOP::Method::Wrapped::_ANON_(MusicBrainz::Server=HASH(0x562bb403a1c8)) called at lib/MusicBrainz/Server.pm line 405
      Class::MOP::Class:::around(CODE(0x562bb3e8be48), MusicBrainz::Server=HASH(0x562bb403a1c8)) called at /home/musicbrainz/carton-local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 164
      Class::MOP::Method::Wrapped::_ANON_(MusicBrainz::Server=HASH(0x562bb403a1c8)) called at lib/MusicBrainz/Server.pm line 490
      Class::MOP::Class:::around(CODE(0x562bb3e9c2a0), MusicBrainz::Server=HASH(0x562bb403a1c8)) called at /home/musicbrainz/carton-local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 164
      Class::MOP::Method::Wrapped::_ANON_(MusicBrainz::Server=HASH(0x562bb403a1c8)) called at /home/musicbrainz/carton-local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 35
      MusicBrainz::Server::_wrapped_dispatch(MusicBrainz::Server=HASH(0x562bb403a1c8)) called at /home/musicbrainz/carton-local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 95
      MusicBrainz::Server::dispatch(MusicBrainz::Server=HASH(0x562bb403a1c8)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst.pm line 2413
      Catalyst::try

      {...} () called at /home/musicbrainz/carton-local/lib/perl5/Try/Tiny.pm line 102
      eval {...}

      called at /home/musicbrainz/carton-local/lib/perl5/Try/Tiny.pm line 93
      Try::Tiny::try(CODE(0x562bb4039bf8), Try::Tiny::Catch=REF(0x562bb4039928)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst.pm line 2422
      Catalyst::handle_request("MusicBrainz::Server", "env", HASH(0x562bb3c261f0), "response_cb", CODE(0x562bb4039988)) called at /home/musicbrainz/carton-local/lib/perl5/Catalyst/Engine.pm line 807
      Catalyst::Engine::_ANON_(CODE(0x562bb4039988)) called at /home/musicbrainz/carton-local/lib/perl5/Plack/Middleware/HTTPExceptions.pm line 32
      Plack::Middleware::HTTPExceptions::try

      {...} () called at /home/musicbrainz/carton-local/lib/perl5/Try/Tiny.pm line 102
      eval {...}

      called at /home/musicbrainz/carton-local/lib/perl5/Try/Tiny.pm line 93
      Try::Tiny::try(CODE(0x562bb40397c0), Try::Tiny::Catch=REF(0x562bb3fd0f78)) called at /home/musicbrainz/carton-local/lib/perl5/Plack/Middleware/HTTPExceptions.pm line 41
      Plack::Middleware::HTTPExceptions::_ANON_(CODE(0x562bb40396d0)) called at /home/musicbrainz/carton-local/lib/perl5/Plack/Util.pm line 339
      Plack::Util::_ANON_(CODE(0x562bb40395e0)) called at /home/musicbrainz/carton-local/lib/perl5/Plack/Util.pm line 339
      Plack::Util::_ANON_(CODE(0x562bae7a7368)) called at /home/musicbrainz/carton-local/lib/perl5/Plack/Util.pm line 339
      Plack::Util::_ANON_(CODE(0x562bb40394c0)) called at /home/musicbrainz/carton-local/lib/perl5/Starlet/Server.pm line 377
      Starlet::Server::handle_connection(Plack::Handler::Starlet=HASH(0x562bb3915c70), HASH(0x562bb3c261f0), IO::Socket::INET=GLOB(0x562ba656e9b0), CODE(0x562bb3c7d090), "", "", "") called at /home/musicbrainz/carton-local/lib/perl5/Starlet/Server.pm line 190
      Starlet::Server::accept_loop(Plack::Handler::Starlet=HASH(0x562bb3915c70), CODE(0x562bb3c7d090), 48) called at /home/musicbrainz/carton-local/lib/perl5/Plack/Handler/Starlet.pm line 80
      Plack::Handler::Starlet::run(Plack::Handler::Starlet=HASH(0x562bb3915c70), CODE(0x562bb3c7d090)) called at /home/musicbrainz/carton-local/lib/perl5/Plack/Loader.pm line 84
      Plack::Loader::run(Plack::Loader=HASH(0x562ba07928d8), Plack::Handler::Starlet=HASH(0x562bb3915c70)) called at /home/musicbrainz/carton-local/lib/perl5/Plack/Runner.pm line 277
      Plack::Runner::run(Plack::Runner=HASH(0x562ba04efda0)) called at /home/musicbrainz/carton-local/bin/plackup line 7
      at lib/MusicBrainz/Server/Controller.pm line 82.
      at lib/Sql.pm line 335. at lib/MusicBrainz/Server/Model/MB.pm line 19
      MusicBrainz::Server::Model::MB::with_transaction(?, ?) called at lib/MusicBrainz/Server/Controller.pm line 184
      MusicBrainz::Server::Controller::edit_action(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) called at lib/MusicBrainz/Server/Controller/Role/EditRelationships.pm line 274
      MusicBrainz::Server::Controller::Artist::edit_action(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) called at lib/MusicBrainz/Server/Controller/Role/Alias.pm line 196
      Catalyst::dispatch called at lib/MusicBrainz/Server.pm line 390
      MusicBrainz::Server::_ANON_ at lib/MusicBrainz/Server.pm line 357
      MusicBrainz::Server::with_translations(?, ?) called at lib/MusicBrainz/Server.pm line 391
      Class::MOP::Method::Wrapped::_ANON_ called at lib/MusicBrainz/Server.pm line 405
      Class::MOP::Method::Wrapped::_ANON_ called at lib/MusicBrainz/Server.pm line 490
      Time: 2021-11-23T07:52:39.260Z

      Host: 444590e14fd3

      Interface language: en

      URL: https://musicbrainz.org/artist/11844805-f486-48c2-afdd-84f4dd208f4c/alias/330473/edit

      Request data:

      {
      "body_parameters":

      { "edit-alias.locale": "en", "edit-alias.sort_name": "Wallace, Guy", "edit-alias.name": "Guy Wallace", "edit-alias.period.end_date.year": "", "edit-alias.primary_for_locale": "1", "edit-alias.period.begin_date.year": "", "edit-alias.period.end_date.day": "", "edit-alias.period.end_date.month": "", "edit-alias.period.begin_date.day": "", "edit-alias.edit_note": "", "edit-alias.period.begin_date.month": "", "edit-alias.type_id": "1" }

      ,
      "query_parameters": {}
      }

            Unassigned Unassigned
            Darkloke Darkloke
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved:

                Version Package