-
Bug
-
Resolution: Duplicate
-
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 123Try::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
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
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
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
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
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
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":
,
"query_parameters": {}
}
- duplicates
-
MBS-12021 ISE trying to overwrite primary for locale when adding alias
- Closed