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

unable to add artist as database entry

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • 2014-08-18
    • None
    • Editing interface
    • None

      Hi, tried to add a really fine artist, and it didn't go so well...

      I have a mac, OS 10.8.5 and Safari 6.0.5...
      see dump below

      Internal Server Error
      Oops, something went wrong!

      Error:

      Caught exception in MusicBrainz::Server::Controller::Artist->create "DBD::Pg::st execute failed: ERROR: invalid input syntax for integer: "ARRAY(0xe77b7f8)"
      LINE 7: ...S orderable_direction FROM link_type WHERE id IN ('ARRAY(0xe...
      ^ at lib/Sql.pm line 453, line 3.
      at lib/Sql.pm line 466
      Sql::_ANON_('DBD::Pg::st execute failed: ERROR: invalid input syntax for ...') called at /usr/share/perl5/Try/Tiny.pm line 100
      Try::Tiny::try('CODE(0xe79bc18)', 'Try::Tiny::Catch=REF(0xe6016a8)', 'Try::Tiny::Finally=REF(0xe726c98)') called at lib/Sql.pm line 470
      Sql::_select_list('Sql=HASH(0xe778e30)', 'SELECT id, parent AS parent_id, gid, name, link_phrase,\x

      {a} ...', 'ARRAY(0xdb97ad0)', 'hashref') called at lib/Sql.pm line 498
      Sql::select_list_of_hashes('Sql=HASH(0xe778e30)', 'SELECT id, parent AS parent_id, gid, name, link_phrase,\x{a}

      ...', 'ARRAY(0xe77b7f8)') called at lib/MusicBrainz/Server/Data/Entity.pm line 45
      MusicBrainz::Server::Data::Entity::_get_by_keys_append_sql('MusicBrainz::Server::Data::LinkType=HASH(0xc44be28)', 'id', '', 'ARRAY(0xe77b7f8)') called at lib/MusicBrainz/Server/Data/Entity.pm line 31
      MusicBrainz::Server::Data::Entity::_get_by_keys('MusicBrainz::Server::Data::LinkType=HASH(0xc44be28)', 'id', 'ARRAY(0xe77b7f8)') called at lib/MusicBrainz/Server/Data/Entity.pm line 77
      MusicBrainz::Server::Data::Entity::get_by_ids('MusicBrainz::Server::Data::LinkType=HASH(0xc44be28)', 'ARRAY(0xe77b7f8)') called at lib/MusicBrainz/Server/Data/LinkType.pm line 68
      MusicBrainz::Server::Data::LinkType::get_by_ids('MusicBrainz::Server::Data::LinkType=HASH(0xc44be28)', 'ARRAY(0xe77b7f8)') called at lib/MusicBrainz/Server/Data/Role/EntityCacheBase.pm line 22
      Class::MOP::Class:::around('CODE(0x64a0620)', 'MusicBrainz::Server::Data::LinkType=HASH(0xc44be28)', 'ARRAY(0xe77b7f8)') called at /usr/lib/perl5/Class/MOP/Method/Wrapped.pm line 162
      Class::MOP::Method::Wrapped::_ANON_('MusicBrainz::Server::Data::LinkType=HASH(0xc44be28)', 'ARRAY(0xe77b7f8)') called at /usr/lib/perl5/Class/MOP/Method/Wrapped.pm line 91
      MusicBrainz::Server::Data::LinkType::get_by_ids('MusicBrainz::Server::Data::LinkType=HASH(0xc44be28)', 'ARRAY(0xe77b7f8)') called at lib/MusicBrainz/Server/Controller/Role/EditRelationships.pm line 26
      MusicBrainz::Server::Controller::Role::EditRelationships::load_entities('MusicBrainz::Server=HASH(0xdb7ca20)', 'artist', 'HASH(0xe793c20)') called at lib/MusicBrainz/Server/Controller/Role/EditRelationships.pm line 81
      MusicBrainz::Server::Controller::Role::EditRelationships::_ANON_('HASH(0xe793c20)') called at lib/MusicBrainz/Server/Controller/Role/EditRelationships.pm line 150
      Class::MOP::Class:::around('CODE(0x44eae00)', 'MusicBrainz::Server::Controller::Artist=HASH(0xce92250)', 'MusicBrainz::Server=HASH(0xdb7ca20)', 'form', 'Artist', 'type', 1, 'on_creation', 'CODE(0xda948f0)', ...) called at /usr/lib/perl5/Class/MOP/Method/Wrapped.pm line 162
      Class::MOP::Method::Wrapped::_ANON_('MusicBrainz::Server::Controller::Artist=HASH(0xce92250)', 'MusicBrainz::Server=HASH(0xdb7ca20)', 'form', 'Artist', 'type', 1, 'on_creation', 'CODE(0xda948f0)', 'redirect', ...) called at /usr/lib/perl5/Class/MOP/Method/Wrapped.pm line 91
      MusicBrainz::Server::Controller::Artist::edit_action('MusicBrainz::Server::Controller::Artist=HASH(0xce92250)', 'MusicBrainz::Server=HASH(0xdb7ca20)', 'form', 'Artist', 'type', 1, 'on_creation', 'CODE(0xda948f0)', 'redirect', ...) called at lib/MusicBrainz/Server/Controller/Role/Create.pm line 88
      Moose::Meta::Role::_ANON_::SERIAL::255::create('MusicBrainz::Server::Controller::Artist=HASH(0xce92250)', 'MusicBrainz::Server=HASH(0xdb7ca20)') called at /usr/share/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute('Catalyst::Action=HASH(0xd360870)', 'MusicBrainz::Server::Controller::Artist=HASH(0xce92250)', 'MusicBrainz::Server=HASH(0xdb7ca20)') called at /usr/share/perl5/Catalyst.pm line 1691
      eval

      {...} called at /usr/share/perl5/Catalyst.pm line 1691
      Catalyst::execute('MusicBrainz::Server=HASH(0xdb7ca20)', 'MusicBrainz::Server::Controller::Artist', 'Catalyst::Action=HASH(0xd360870)') called at /usr/share/perl5/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xdb7ca20)', 'MusicBrainz::Server::Controller::Artist', 'Catalyst::Action=HASH(0xd360870)') called at /usr/share/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch('Catalyst::Action=HASH(0xd360870)', 'MusicBrainz::Server=HASH(0xdb7ca20)') called at /usr/share/perl5/Catalyst/Controller.pm line 125
      Catalyst::Controller::_ACTION('MusicBrainz::Server::Controller::Artist=HASH(0xce92250)', 'MusicBrainz::Server=HASH(0xdb7ca20)') called at /usr/share/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute('Catalyst::Action=HASH(0xd349eb8)', 'MusicBrainz::Server::Controller::Artist=HASH(0xce92250)', 'MusicBrainz::Server=HASH(0xdb7ca20)') called at /usr/share/perl5/Catalyst.pm line 1691
      eval {...}

      called at /usr/share/perl5/Catalyst.pm line 1691
      Catalyst::execute('MusicBrainz::Server=HASH(0xdb7ca20)', 'MusicBrainz::Server::Controller::Artist', 'Catalyst::Action=HASH(0xd349eb8)') called at /usr/share/perl5/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xdb7ca20)', 'MusicBrainz::Server::Controller::Artist', 'Catalyst::Action=HASH(0xd349eb8)') called at /usr/share/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch('Catalyst::Action=HASH(0xd349eb8)', 'MusicBrainz::Server=HASH(0xdb7ca20)') called at /usr/share/perl5/Catalyst/Dispatcher.pm line 257
      Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x32f8148)', 'forward', 'MusicBrainz::Server=HASH(0xdb7ca20)', '_ACTION') called at /usr/share/perl5/Catalyst/Dispatcher.pm line 237
      Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x32f8148)', 'MusicBrainz::Server=HASH(0xdb7ca20)', '_ACTION') called at /usr/share/perl5/Catalyst.pm line 358
      Catalyst::forward('MusicBrainz::Server=HASH(0xdb7ca20)', '_ACTION') called at /usr/share/perl5/Catalyst/Controller.pm line 99
      Catalyst::Controller::_DISPATCH('MusicBrainz::Server::Controller::Artist=HASH(0xce92250)', 'MusicBrainz::Server=HASH(0xdb7ca20)') called at /usr/share/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute('Catalyst::Action=HASH(0xd349258)', 'MusicBrainz::Server::Controller::Artist=HASH(0xce92250)', 'MusicBrainz::Server=HASH(0xdb7ca20)') called at /usr/share/perl5/Catalyst.pm line 1691
      eval

      {...} called at /usr/share/perl5/Catalyst.pm line 1691
      Catalyst::execute('MusicBrainz::Server=HASH(0xdb7ca20)', 'MusicBrainz::Server::Controller::Artist', 'Catalyst::Action=HASH(0xd349258)') called at /usr/share/perl5/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xdb7ca20)', 'MusicBrainz::Server::Controller::Artist', 'Catalyst::Action=HASH(0xd349258)') called at /usr/share/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch('Catalyst::Action=HASH(0xd349258)', 'MusicBrainz::Server=HASH(0xdb7ca20)') called at /usr/share/perl5/Catalyst/Dispatcher.pm line 257
      Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x32f8148)', 'forward', 'MusicBrainz::Server=HASH(0xdb7ca20)', '/artist/_DISPATCH') called at /usr/share/perl5/Catalyst/Dispatcher.pm line 237
      Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x32f8148)', 'MusicBrainz::Server=HASH(0xdb7ca20)', '/artist/_DISPATCH') called at /usr/share/perl5/Catalyst.pm line 358
      Catalyst::forward('MusicBrainz::Server=HASH(0xdb7ca20)', '/artist/_DISPATCH') called at /usr/share/perl5/Catalyst/Dispatcher.pm line 105
      Catalyst::Dispatcher::dispatch('Catalyst::Dispatcher=HASH(0x32f8148)', 'MusicBrainz::Server=HASH(0xdb7ca20)') called at /usr/share/perl5/Catalyst.pm line 1637
      Catalyst::dispatch('MusicBrainz::Server=HASH(0xdb7ca20)') 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(0xdb7ca20)', 'CODE(0xe7aaa20)') called at lib/MusicBrainz/Server.pm line 336
      Class::MOP::Class:::around('CODE(0x1a9f9e0)', 'MusicBrainz::Server=HASH(0xdb7ca20)') called at /usr/lib/perl5/Class/MOP/Method/Wrapped.pm line 162
      Class::MOP::Method::Wrapped::_ANON_('MusicBrainz::Server=HASH(0xdb7ca20)') called at lib/MusicBrainz/Server.pm line 350
      Class::MOP::Class:::around('CODE(0x32f7ff8)', 'MusicBrainz::Server=HASH(0xdb7ca20)') called at /usr/lib/perl5/Class/MOP/Method/Wrapped.pm line 162
      Class::MOP::Method::Wrapped::_ANON_('MusicBrainz::Server=HASH(0xdb7ca20)') called at lib/MusicBrainz/Server.pm line 395
      Class::MOP::Class:::around('CODE(0xd4816f0)', 'MusicBrainz::Server=HASH(0xdb7ca20)') called at /usr/lib/perl5/Class/MOP/Method/Wrapped.pm line 162
      Class::MOP::Method::Wrapped::_ANON_('MusicBrainz::Server=HASH(0xdb7ca20)') called at /usr/lib/perl5/Class/MOP/Method/Wrapped.pm line 35
      Class::MOP::Method::Wrapped::_ANON_('MusicBrainz::Server=HASH(0xdb7ca20)') called at /usr/lib/perl5/Class/MOP/Method/Wrapped.pm line 91
      MusicBrainz::Server::dispatch('MusicBrainz::Server=HASH(0xdb7ca20)') 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(0xdb6b050)', 'Try::Tiny::Catch=REF(0xe26b4b0)') called at /usr/share/perl5/Catalyst.pm line 1993
      Catalyst::handle_request('MusicBrainz::Server', 'env', 'HASH(0xe798290)', 'response_cb', 'CODE(0xe734990)') called at /usr/share/perl5/Catalyst/Plugin/AutoRestart.pm line 117
      Catalyst::Plugin::AutoRestart::handle_request('MusicBrainz::Server', 'env', 'HASH(0xe798290)', 'response_cb', 'CODE(0xe734990)') called at /usr/share/perl5/Catalyst/Engine.pm line 682
      Catalyst::Engine::_ANON_('CODE(0xe734990)') called at /usr/share/perl5/Starman/Server.pm line 225
      Starman::Server::process_request('Starman::Server=HASH(0x8ef4e0)') called at /usr/share/perl5/Net/Server.pm line 142
      Net::Server::run_client_connection('Starman::Server=HASH(0x8ef4e0)') 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(0x8ef4e0)') called at /usr/share/perl5/Net/Server/PreFork.pm line 229
      Net::Server::PreFork::run_n_children('Starman::Server=HASH(0x8ef4e0)', 1) called at /usr/share/perl5/Net/Server/PreFork.pm line 456
      Net::Server::PreFork::coordinate_children('Starman::Server=HASH(0x8ef4e0)') called at /usr/share/perl5/Net/Server/PreFork.pm line 357
      Net::Server::PreFork::run_parent('Starman::Server=HASH(0x8ef4e0)') called at /usr/share/perl5/Starman/Server.pm line 104
      Starman::Server::run_parent('Starman::Server=HASH(0x8ef4e0)') called at /usr/share/perl5/Net/Server/PreFork.pm line 147
      Net::Server::PreFork::loop('Starman::Server=HASH(0x8ef4e0)') called at /usr/share/perl5/Net/Server.pm line 117
      Net::Server::run('Starman::Server=HASH(0x8ef4e0)', 'port', 'ARRAY(0xd489918)', 'host', 'ARRAY(0xd4899f0)', 'proto', 'ARRAY(0xd664ef0)', 'serialize', 'flock', ...) called at /usr/share/perl5/Starman/Server.pm line 61
      Starman::Server::run('Starman::Server=HASH(0x8ef4e0)', 'CODE(0xd4a4e30)', 'HASH(0x8ef468)') called at /usr/share/perl5/Plack/Handler/Starman.pm line 18
      Plack::Handler::Starman::run('Plack::Handler::Starman=HASH(0x8ef540)', 'CODE(0xd4a4e30)') called at /usr/share/perl5/Plack/Loader.pm line 88
      Plack::Loader::run('Plack::Loader=HASH(0x8b9778)', 'Plack::Handler::Starman=HASH(0x8ef540)') called at /usr/share/perl5/Plack/Runner.pm line 263
      Plack::Runner::run('Plack::Runner=HASH(0x6b3898)') called at /usr/bin/starman line 31"
      Stack trace:
      line 45 MusicBrainz::Server::Data::Entity
      line 31 MusicBrainz::Server::Data::Entity
      line 77 MusicBrainz::Server::Data::Entity
      line 68 MusicBrainz::Server::Data::LinkType
      line 22 MusicBrainz::Server::Data::Role::EntityCacheBase
      line 26 MusicBrainz::Server::Controller::Role::EditRelationships
      line 81 MusicBrainz::Server::Controller::Role::EditRelationships
      line 150 MusicBrainz::Server::Controller::Role::EditRelationships
      line 88 MusicBrainz::Server::Controller::Role::Create
      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-artist.edit_note' => 'http://www.mazeoftime.com', 'edit-artist.end_area.name' => '', 'edit-artist.period.end_date.month' => '', 'edit-artist.begin_area.gid' => '1127ddc2-eab3-4662-8718-6adbdeea3b10', 'edit-artist.area_id' => '', 'edit-artist.period.end_date.year' => '', 'edit-artist.area.gid' => '', 'edit-artist.period.end_date.day' => '', 'edit-artist.comment' => '', 'edit-artist.end_area_id' => '', 'edit-artist.name' => 'Maze of Time', 'edit-artist.begin_area.name' => 'Stockholm', 'edit-artist.area.name' => 'Symphonic prog', 'edit-artist.url.0.link_type_id' => [ '183', '183' ], 'edit-artist.url.0.text' => [ 'http://www.mazeoftime.com', 'http://www.mazeoftime.com' ], 'edit-artist.isni_codes.0' => '', 'edit-artist.end_area.gid' => '', 'edit-artist.period.begin_date.year' => '2001', 'edit-artist.begin_area_id' => '5114', 'edit-artist.ipi_codes.0' => '', 'edit-artist.period.begin_date.month' => '11', 'edit-artist.type_id' => '2', 'edit-artist.sort_name' => 'Maze of Time', 'edit-artist.period.begin_date.day' => '01' }

      };

      Time: 2014-08-08 19:31:30 UTC

      Host: pingu

      URL: https://musicbrainz.org/artist/create

      We're terribly sorry for this problem. Please wait a few minutes and repeat your request — the problem may go away.

      If the problem persists, please report a bug and include any error message that is shown above.

      Please be sure to include the stack trace and request data shown above!

      Donate | Wiki | Forums | Bug Tracker | Twitter | Use beta site Cover Art provided by the Cover Art Archive. Hosted by Digital West. Sponsored by: Google, OSUOSL and others....

            bitmap Michael Wiencek
            mazekeeper Alex Jonsson
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved:

                Version Package
                2014-08-18