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

Internal server error when searching for edits by ID with large numbers

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2014-04-14
    • Component/s: Edit search
    • Labels:
      None

      Description

      https://beta.musicbrainz.org/search/edits?auto_edit_filter=&order=desc&negation=0&combinator=and&conditions.0.field=id&conditions.0.operator=%3D&conditions.0.args.0=12345678901234567890&conditions.0.args.1=&field=Bitte+w%C3%A4hle+eine+Bedingung

      Fehler:

      Caught exception in MusicBrainz::Server::Controller::Edit->search "DBD::Pg::st execute failed: ERROR: value "12345678901234567890" is out of range for type integer
      ZEILE 2: ...ECT DISTINCT edit.* FROM edit WHERE ((edit.id = '123456789...
      ^ at lib/Sql.pm line 443, line 3.
      at lib/Sql.pm line 456, line 3.
      Sql::_ANON_("DBD::Pg::st execute failed: ERROR: value \"123456789012345678"...) called at /usr/local/share/perl/5.10.1/Try/Tiny.pm line 100
      Try::Tiny::try(CODE(0x1405b0e8), Try::Tiny::Catch=REF(0x10c0adc8), Try::Tiny::Finally=REF(0x14862ed8)) called at lib/Sql.pm line 460
      Sql::_select_list(Sql=HASH(0x148367c0), "\x

      Unknown macro: {a}

      WITH x AS (SELECT DISTINCT edit.* FROM edit WHERE "..., ARRAY(0x14862ff8), "hashref") called at lib/Sql.pm line 488
      Sql::select_list_of_hashes(Sql=HASH(0x148367c0), "\x

      WITH x AS (SELECT DISTINCT edit.* FROM edit WHERE "..., 12345678901234567890, 0) called at lib/MusicBrainz/Server/Data/Utils.pm line 244
      MusicBrainz::Server::Data::Utils::query_to_list_limited(Sql=HASH(0x148367c0), 0, 25, CODE(0x13e5b500), "SELECT DISTINCT edit.* FROM edit WHERE ((edit.id = ?))\x

      Unknown macro: {a}

      "..., 12345678901234567890, 0) called at lib/MusicBrainz/Server/Data/Edit.pm line 78
      MusicBrainz::Server::Data::Edit::run_query(MusicBrainz::Server::Data::Edit=HASH(0xc36af80), MusicBrainz::Server::EditSearch::Query=HASH(0x14052ec0), 25, 0) called at lib/MusicBrainz/Server/Controller/Edit.pm line 200
      MusicBrainz::Server::Controller::Edit::_ANON_(25, 0) called at lib/MusicBrainz/Server/Controller.pm line 255
      MusicBrainz::Server::Controller::_load_paged(MusicBrainz::Server::Controller::Edit=HASH(0xce68750), MusicBrainz::Server=HASH(0x140b3c10), CODE(0x13de9b10)) called at lib/MusicBrainz/Server/Controller/Edit.pm line 201
      MusicBrainz::Server::Controller::Edit::search(MusicBrainz::Server::Controller::Edit=HASH(0xce68750), MusicBrainz::Server=HASH(0x140b3c10)) called at /home/beta/perl5/lib/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute(Catalyst::Action=HASH(0xd83c180), MusicBrainz::Server::Controller::Edit=HASH(0xce68750), MusicBrainz::Server=HASH(0x140b3c10)) called at /home/beta/perl5/lib/perl5/Catalyst.pm line 1687
      eval

      Unknown macro: {...}

      called at /home/beta/perl5/lib/perl5/Catalyst.pm line 1687
      Catalyst::execute(MusicBrainz::Server=HASH(0x140b3c10), "MusicBrainz::Server::Controller::Edit", Catalyst::Action=HASH(0xd83c180)) called at /home/beta/perl5/lib/perl5/Catalyst/Plugin/StackTrace.pm line 93
      Catalyst::Plugin::StackTrace::execute(MusicBrainz::Server=HASH(0x140b3c10), "MusicBrainz::Server::Controller::Edit", Catalyst::Action=HASH(0xd83c180)) called at /home/beta/perl5/lib/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch(Catalyst::Action=HASH(0xd83c180), MusicBrainz::Server=HASH(0x140b3c10)) called at /home/beta/perl5/lib/perl5/Catalyst/Controller.pm line 158
      Catalyst::Controller::_ACTION(MusicBrainz::Server::Controller::Edit=HASH(0xce68750), MusicBrainz::Server=HASH(0x140b3c10)) called at /home/beta/perl5/lib/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute(Catalyst::Action=HASH(0xd8394f0), MusicBrainz::Server::Controller::Edit=HASH(0xce68750), MusicBrainz::Server=HASH(0x140b3c10)) called at /home/beta/perl5/lib/perl5/Catalyst.pm line 1687
      eval

      called at /home/beta/perl5/lib/perl5/Catalyst.pm line 1687
      Catalyst::execute(MusicBrainz::Server=HASH(0x140b3c10), "MusicBrainz::Server::Controller::Edit", Catalyst::Action=HASH(0xd8394f0)) called at /home/beta/perl5/lib/perl5/Catalyst/Plugin/StackTrace.pm line 93
      Catalyst::Plugin::StackTrace::execute(MusicBrainz::Server=HASH(0x140b3c10), "MusicBrainz::Server::Controller::Edit", Catalyst::Action=HASH(0xd8394f0)) called at /home/beta/perl5/lib/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch(Catalyst::Action=HASH(0xd8394f0), MusicBrainz::Server=HASH(0x140b3c10)) called at /home/beta/perl5/lib/perl5/Catalyst/Dispatcher.pm line 257
      Catalyst::Dispatcher::_do_forward(Catalyst::Dispatcher=HASH(0x45ddde8), "forward", MusicBrainz::Server=HASH(0x140b3c10), "_ACTION") called at /home/beta/perl5/lib/perl5/Catalyst/Dispatcher.pm line 237
      Catalyst::Dispatcher::forward(Catalyst::Dispatcher=HASH(0x45ddde8), MusicBrainz::Server=HASH(0x140b3c10), "_ACTION") called at /home/beta/perl5/lib/perl5/Catalyst.pm line 373
      Catalyst::forward(MusicBrainz::Server=HASH(0x140b3c10), "_ACTION") called at /home/beta/perl5/lib/perl5/Catalyst/Controller.pm line 132
      Catalyst::Controller::_DISPATCH(MusicBrainz::Server::Controller::Edit=HASH(0xce68750), MusicBrainz::Server=HASH(0x140b3c10)) called at /home/beta/perl5/lib/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute(Catalyst::Action=HASH(0xd831210), MusicBrainz::Server::Controller::Edit=HASH(0xce68750), MusicBrainz::Server=HASH(0x140b3c10)) called at /home/beta/perl5/lib/perl5/Catalyst.pm line 1687
      eval

      Unknown macro: {...}

      called at /home/beta/perl5/lib/perl5/Catalyst.pm line 1687
      Catalyst::execute(MusicBrainz::Server=HASH(0x140b3c10), "MusicBrainz::Server::Controller::Edit", Catalyst::Action=HASH(0xd831210)) called at /home/beta/perl5/lib/perl5/Catalyst/Plugin/StackTrace.pm line 93
      Catalyst::Plugin::StackTrace::execute(MusicBrainz::Server=HASH(0x140b3c10), "MusicBrainz::Server::Controller::Edit", Catalyst::Action=HASH(0xd831210)) called at /home/beta/perl5/lib/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch(Catalyst::Action=HASH(0xd831210), MusicBrainz::Server=HASH(0x140b3c10)) called at /home/beta/perl5/lib/perl5/Catalyst/Dispatcher.pm line 257
      Catalyst::Dispatcher::_do_forward(Catalyst::Dispatcher=HASH(0x45ddde8), "forward", MusicBrainz::Server=HASH(0x140b3c10), "/edit/_DISPATCH") called at /home/beta/perl5/lib/perl5/Catalyst/Dispatcher.pm line 237
      Catalyst::Dispatcher::forward(Catalyst::Dispatcher=HASH(0x45ddde8), MusicBrainz::Server=HASH(0x140b3c10), "/edit/_DISPATCH") called at /home/beta/perl5/lib/perl5/Catalyst.pm line 373
      Catalyst::forward(MusicBrainz::Server=HASH(0x140b3c10), "/edit/_DISPATCH") called at /home/beta/perl5/lib/perl5/Catalyst/Dispatcher.pm line 105
      Catalyst::Dispatcher::dispatch(Catalyst::Dispatcher=HASH(0x45ddde8), MusicBrainz::Server=HASH(0x140b3c10)) called at /home/beta/perl5/lib/perl5/Catalyst.pm line 1633
      Catalyst::dispatch(MusicBrainz::Server=HASH(0x140b3c10)) called at lib/MusicBrainz/Server.pm line 338
      MusicBrainz::Server::_ANON_() called at lib/MusicBrainz/Server.pm line 312
      MusicBrainz::Server::with_translations(MusicBrainz::Server=HASH(0x140b3c10), CODE(0x14042e90)) called at lib/MusicBrainz/Server.pm line 339
      Class::MOP::Class:::around(CODE(0x3a7ca80), MusicBrainz::Server=HASH(0x140b3c10)) called at /home/beta/perl5/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 162
      Class::MOP::Method::Wrapped::_ANON_(MusicBrainz::Server=HASH(0x140b3c10)) called at lib/MusicBrainz/Server.pm line 353
      Class::MOP::Class:::around(CODE(0xbabfbd0), MusicBrainz::Server=HASH(0x140b3c10)) called at /home/beta/perl5/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 162
      Class::MOP::Method::Wrapped::_ANON_(MusicBrainz::Server=HASH(0x140b3c10)) called at lib/MusicBrainz/Server.pm line 398
      Class::MOP::Class:::around(CODE(0xdade330), MusicBrainz::Server=HASH(0x140b3c10)) called at /home/beta/perl5/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 162
      Class::MOP::Method::Wrapped::_ANON_(MusicBrainz::Server=HASH(0x140b3c10)) called at /home/beta/perl5/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 35
      Class::MOP::Method::Wrapped::_ANON_(MusicBrainz::Server=HASH(0x140b3c10)) called at /home/beta/perl5/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 91
      MusicBrainz::Server::dispatch(MusicBrainz::Server=HASH(0x140b3c10)) called at /home/beta/perl5/lib/perl5/Catalyst.pm line 1992
      Catalyst::_ANON_() called at /usr/local/share/perl/5.10.1/Try/Tiny.pm line 76
      eval

      called at /usr/local/share/perl/5.10.1/Try/Tiny.pm line 67
      Try::Tiny::try(CODE(0x14077558), Try::Tiny::Catch=REF(0x10a3b6a8)) called at /home/beta/perl5/lib/perl5/Catalyst.pm line 1998
      Catalyst::handle_request("MusicBrainz::Server", "env", HASH(0x10165f00), "response_cb", CODE(0x1449a1d0)) called at /home/beta/perl5/lib/perl5/Catalyst/Plugin/AutoRestart.pm line 117
      Catalyst::Plugin::AutoRestart::handle_request("MusicBrainz::Server", "env", HASH(0x10165f00), "response_cb", CODE(0x1449a1d0)) called at /home/beta/perl5/lib/perl5/Catalyst/Engine.pm line 697
      Catalyst::Engine::_ANON_(CODE(0x1449a1d0)) called at /home/beta/perl5/lib/perl5/Plack/Handler/FCGI.pm line 136
      Plack::Handler::FCGI::run(Plack::Handler::FCGI=HASH(0x196fab8), CODE(0xdae5358)) called at /home/beta/perl5/lib/perl5/Plack/Loader.pm line 84
      Plack::Loader::run(Plack::Loader=HASH(0x1946eb0), Plack::Handler::FCGI=HASH(0x196fab8)) called at /home/beta/perl5/lib/perl5/Plack/Runner.pm line 277
      Plack::Runner::run(Plack::Runner=HASH(0x16e4600)) called at /home/beta/perl5/bin/plackup line 10"

      Stack-Trace:
      line 244 MusicBrainz::Server::Data::Utils
      line 78 MusicBrainz::Server::Data::Edit
      line 200 MusicBrainz::Server::Controller::Edit
      line 255 MusicBrainz::Server::Controller
      line 201 MusicBrainz::Server::Controller::Edit
      line 338 MusicBrainz::Server
      line 312 MusicBrainz::Server
      line 339 MusicBrainz::Server
      line 353 MusicBrainz::Server
      line 398 MusicBrainz::Server

      Anfragedaten:
      $VAR1 = {
      'query_parameters' => {
      'conditions.0.operator' => '=',
      'conditions.0.args.1' => '',
      'conditions.0.field' => 'id',
      'conditions.0.args.0' => '12345678901234567890',
      'order' => 'desc',
      'combinator' => 'and',
      'field' => "Bitte w\x

      Unknown macro: {e4}

      hle eine Bedingung",
      'auto_edit_filter' => '',
      'negation' => '0'
      },
      'body_parameters' => {}
      };

      Host: pino

      Oberflächensprache: de

      URL: https://beta.musicbrainz.org/search/edits?auto_edit_filter=&order=desc&negation=0&combinator=and&conditions.0.field=id&conditions.0.operator=%3D&conditions.0.args.0=12345678901234567890&conditions.0.args.1=&field=Bitte+w%C3%A4hle+eine+Bedingung

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Due:
                  Created:
                  Updated:
                  Resolved:

                  Packages

                  Version Package
                  2014-04-14