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

Internal server error searching for multiple editor flags in the edit search

    XMLWordPrintable

    Details

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

      Description

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

      Error:

      Caught exception in MusicBrainz::Server::Controller::Edit->search "Failed query:
      '
      WITH x AS (SELECT DISTINCT edit.* FROM edit JOIN editor editor_1 ON editor_1.id = edit.editor WHERE ((editor_1.privs & != 0))
      ORDER BY edit.open_time desc, edit.id desc
      LIMIT 500 OFFSET ?)
      SELECT x.*, c.count AS total_row_count
      FROM x, (SELECT count from x) c LIMIT 25'
      (1 2 0)
      DBD::Pg::st execute failed: called with 3 bind variables when 2 are needed at lib/Sql.pm line 83, line 3.

      at lib/Sql.pm line 88
      Sql::_ANON_('DBD::Pg::st execute failed: called with 3 bind variables when...') called at /usr/share/perl5/Try/Tiny.pm line 100
      Try::Tiny::try('CODE(0x1211f228)', 'Try::Tiny::Catch=REF(0x1211efe8)') called at lib/Sql.pm line 90
      Sql::select('Sql=HASH(0x125ce858)', '
      WITH x AS (SELECT DISTINCT edit.* FROM edit JOIN edi...', 1, 2, 0) called at lib/MusicBrainz/Server/Data/Utils.pm line 253
      MusicBrainz::Server::Data::Utils::query_to_list_limited('Sql=HASH(0x125ce858)', 0, 25, 'CODE(0x1211eee0)', 'SELECT DISTINCT edit.* FROM edit JOIN editor editor_1 ON edit...', 1, 2, 0) called at lib/MusicBrainz/Server/Data/Edit.pm line 78
      MusicBrainz::Server::Data::Edit::run_query('MusicBrainz::Server::Data::Edit=HASH(0xc225c00)', 'MusicBrainz::Server::EditSearch::Query=HASH(0x1211ef28)', 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 211
      MusicBrainz::Server::Controller::_load_paged('MusicBrainz::Server::Controller::Edit=HASH(0xd4f9e78)', 'MusicBrainz::Server=HASH(0xe21b7c0)', 'CODE(0x11fc2ab8)') called at lib/MusicBrainz/Server/Controller/Edit.pm line 201
      MusicBrainz::Server::Controller::Edit::search('MusicBrainz::Server::Controller::Edit=HASH(0xd4f9e78)', 'MusicBrainz::Server=HASH(0xe21b7c0)') called at /usr/share/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute('Catalyst::Action=HASH(0xd856f28)', 'MusicBrainz::Server::Controller::Edit=HASH(0xd4f9e78)', 'MusicBrainz::Server=HASH(0xe21b7c0)') called at /usr/share/perl5/Catalyst.pm line 1691
      eval

      Unknown macro: {...}

      called at /usr/share/perl5/Catalyst.pm line 1691
      Catalyst::execute('MusicBrainz::Server=HASH(0xe21b7c0)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xd856f28)') called at /usr/share/perl5/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xe21b7c0)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xd856f28)') called at /usr/share/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch('Catalyst::Action=HASH(0xd856f28)', 'MusicBrainz::Server=HASH(0xe21b7c0)') called at /usr/share/perl5/Catalyst/Controller.pm line 125
      Catalyst::Controller::_ACTION('MusicBrainz::Server::Controller::Edit=HASH(0xd4f9e78)', 'MusicBrainz::Server=HASH(0xe21b7c0)') called at /usr/share/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute('Catalyst::Action=HASH(0xd8525c0)', 'MusicBrainz::Server::Controller::Edit=HASH(0xd4f9e78)', 'MusicBrainz::Server=HASH(0xe21b7c0)') called at /usr/share/perl5/Catalyst.pm line 1691
      eval

      called at /usr/share/perl5/Catalyst.pm line 1691
      Catalyst::execute('MusicBrainz::Server=HASH(0xe21b7c0)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xd8525c0)') called at /usr/share/perl5/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xe21b7c0)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xd8525c0)') called at /usr/share/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch('Catalyst::Action=HASH(0xd8525c0)', 'MusicBrainz::Server=HASH(0xe21b7c0)') called at /usr/share/perl5/Catalyst/Dispatcher.pm line 257
      Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x464dbb8)', 'forward', 'MusicBrainz::Server=HASH(0xe21b7c0)', '_ACTION') called at /usr/share/perl5/Catalyst/Dispatcher.pm line 237
      Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x464dbb8)', 'MusicBrainz::Server=HASH(0xe21b7c0)', '_ACTION') called at /usr/share/perl5/Catalyst.pm line 358
      Catalyst::forward('MusicBrainz::Server=HASH(0xe21b7c0)', '_ACTION') called at /usr/share/perl5/Catalyst/Controller.pm line 99
      Catalyst::Controller::_DISPATCH('MusicBrainz::Server::Controller::Edit=HASH(0xd4f9e78)', 'MusicBrainz::Server=HASH(0xe21b7c0)') called at /usr/share/perl5/Catalyst/Action.pm line 65
      Catalyst::Action::execute('Catalyst::Action=HASH(0xd852170)', 'MusicBrainz::Server::Controller::Edit=HASH(0xd4f9e78)', 'MusicBrainz::Server=HASH(0xe21b7c0)') called at /usr/share/perl5/Catalyst.pm line 1691
      eval

      Unknown macro: {...}

      called at /usr/share/perl5/Catalyst.pm line 1691
      Catalyst::execute('MusicBrainz::Server=HASH(0xe21b7c0)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xd852170)') called at /usr/share/perl5/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xe21b7c0)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xd852170)') called at /usr/share/perl5/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch('Catalyst::Action=HASH(0xd852170)', 'MusicBrainz::Server=HASH(0xe21b7c0)') called at /usr/share/perl5/Catalyst/Dispatcher.pm line 257
      Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x464dbb8)', 'forward', 'MusicBrainz::Server=HASH(0xe21b7c0)', '/edit/_DISPATCH') called at /usr/share/perl5/Catalyst/Dispatcher.pm line 237
      Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x464dbb8)', 'MusicBrainz::Server=HASH(0xe21b7c0)', '/edit/_DISPATCH') called at /usr/share/perl5/Catalyst.pm line 358
      Catalyst::forward('MusicBrainz::Server=HASH(0xe21b7c0)', '/edit/_DISPATCH') called at /usr/share/perl5/Catalyst/Dispatcher.pm line 105
      Catalyst::Dispatcher::dispatch('Catalyst::Dispatcher=HASH(0x464dbb8)', 'MusicBrainz::Server=HASH(0xe21b7c0)') called at /usr/share/perl5/Catalyst.pm line 1637
      Catalyst::dispatch('MusicBrainz::Server=HASH(0xe21b7c0)') called at lib/MusicBrainz/Server.pm line 330
      MusicBrainz::Server::_ANON_() called at lib/MusicBrainz/Server.pm line 304
      MusicBrainz::Server::with_translations('MusicBrainz::Server=HASH(0xe21b7c0)', 'CODE(0xe80c2b8)') called at lib/MusicBrainz/Server.pm line 331
      Class::MOP::Class:::around('CODE(0x3a67348)', 'MusicBrainz::Server=HASH(0xe21b7c0)') called at /usr/lib/perl5/Class/MOP/Method/Wrapped.pm line 162
      Class::MOP::Method::Wrapped::_ANON_('MusicBrainz::Server=HASH(0xe21b7c0)') called at lib/MusicBrainz/Server.pm line 345
      Class::MOP::Class:::around('CODE(0x464da98)', 'MusicBrainz::Server=HASH(0xe21b7c0)') called at /usr/lib/perl5/Class/MOP/Method/Wrapped.pm line 162
      Class::MOP::Method::Wrapped::_ANON_('MusicBrainz::Server=HASH(0xe21b7c0)') called at lib/MusicBrainz/Server.pm line 390
      Class::MOP::Class:::around('CODE(0xdac4670)', 'MusicBrainz::Server=HASH(0xe21b7c0)') called at /usr/lib/perl5/Class/MOP/Method/Wrapped.pm line 162
      Class::MOP::Method::Wrapped::_ANON_('MusicBrainz::Server=HASH(0xe21b7c0)') called at /usr/lib/perl5/Class/MOP/Method/Wrapped.pm line 35
      Class::MOP::Method::Wrapped::_ANON_('MusicBrainz::Server=HASH(0xe21b7c0)') called at /usr/lib/perl5/Class/MOP/Method/Wrapped.pm line 91
      MusicBrainz::Server::dispatch('MusicBrainz::Server=HASH(0xe21b7c0)') 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(0xe2f4fb8)', 'Try::Tiny::Catch=REF(0xe757778)') called at /usr/share/perl5/Catalyst.pm line 1993
      Catalyst::handle_request('MusicBrainz::Server', 'env', 'HASH(0xe93fb18)', 'response_cb', 'CODE(0xe614a38)') called at /usr/share/perl5/Catalyst/Plugin/AutoRestart.pm line 117
      Catalyst::Plugin::AutoRestart::handle_request('MusicBrainz::Server', 'env', 'HASH(0xe93fb18)', 'response_cb', 'CODE(0xe614a38)') called at /usr/share/perl5/Catalyst/Engine.pm line 682
      Catalyst::Engine::_ANON_('CODE(0xe614a38)') called at /usr/share/perl5/Starman/Server.pm line 225
      Starman::Server::process_request('Starman::Server=HASH(0x1c1b910)') called at /usr/share/perl5/Net/Server.pm line 142
      Net::Server::run_client_connection('Starman::Server=HASH(0x1c1b910)') called at /usr/share/perl5/Net/Server/PreFork.pm line 273
      eval

      Unknown macro: {...}

      called at /usr/share/perl5/Net/Server/PreFork.pm line 273
      Net::Server::PreFork::run_child('Starman::Server=HASH(0x1c1b910)') called at /usr/share/perl5/Net/Server/PreFork.pm line 229
      Net::Server::PreFork::run_n_children('Starman::Server=HASH(0x1c1b910)', 1) called at /usr/share/perl5/Net/Server/PreFork.pm line 456
      Net::Server::PreFork::coordinate_children('Starman::Server=HASH(0x1c1b910)') called at /usr/share/perl5/Net/Server/PreFork.pm line 357
      Net::Server::PreFork::run_parent('Starman::Server=HASH(0x1c1b910)') called at /usr/share/perl5/Starman/Server.pm line 104
      Starman::Server::run_parent('Starman::Server=HASH(0x1c1b910)') called at /usr/share/perl5/Net/Server/PreFork.pm line 147
      Net::Server::PreFork::loop('Starman::Server=HASH(0x1c1b910)') called at /usr/share/perl5/Net/Server.pm line 117
      Net::Server::run('Starman::Server=HASH(0x1c1b910)', 'port', 'ARRAY(0x3c387b0)', 'host', 'ARRAY(0x3c38888)', 'proto', 'ARRAY(0xdca1170)', 'serialize', 'flock', ...) called at /usr/share/perl5/Starman/Server.pm line 61
      Starman::Server::run('Starman::Server=HASH(0x1c1b910)', 'CODE(0x1c536e8)', 'HASH(0x1c4b450)') called at /usr/share/perl5/Plack/Handler/Starman.pm line 18
      Plack::Handler::Starman::run('Plack::Handler::Starman=HASH(0x1c1b970)', 'CODE(0x1c536e8)') called at /usr/share/perl5/Plack/Loader.pm line 88
      Plack::Loader::run('Plack::Loader=HASH(0x1c164f0)', 'Plack::Handler::Starman=HASH(0x1c1b970)') called at /usr/share/perl5/Plack/Runner.pm line 263
      Plack::Runner::run('Plack::Runner=HASH(0x1a0c898)') called at /usr/local/bin/starman line 31"

      Stack trace:
      line 253 MusicBrainz::Server::Data::Utils
      line 78 MusicBrainz::Server::Data::Edit
      line 200 MusicBrainz::Server::Controller::Edit
      line 211 MusicBrainz::Server::Controller
      line 201 MusicBrainz::Server::Controller::Edit
      line 330 MusicBrainz::Server
      line 304 MusicBrainz::Server
      line 331 MusicBrainz::Server
      line 345 MusicBrainz::Server
      line 390 MusicBrainz::Server

      Request data:
      $VAR1 = {
      'query_parameters' => {
      'conditions.0.args' => [
      '1',
      '2'
      ],
      'conditions.0.operator' => '=',
      'conditions.0.field' => 'editor_flag',
      'order' => 'desc',
      'combinator' => 'and',
      'auto_edit_filter' => '',
      'negation' => '0',
      'field' => "Bitte w\x

      Unknown macro: {e4}

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

      Host: asterix

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

        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-11-11