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

Internal server error when viewing editing history

    XMLWordPrintable

    Details

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

      Description

      Error:
      
      Caught exception in MusicBrainz::Server::Controller::Artist->edits "Failed query:
      	'SELECT
                  cover_art_archive.index_listing.id,
                  cover_art_archive.index_listing.release,
                  cover_art_archive.index_listing.comment,
                  cover_art_archive.index_listing.edit,
                  cover_art_archive.index_listing.ordering,
                  cover_art_archive.cover_art.edits_pending,
                  cover_art_archive.index_listing.approved,
                  cover_art_archive.index_listing.is_front,
                  cover_art_archive.index_listing.is_back
              FROM cover_art_archive.index_listing
              JOIN cover_art_archive.cover_art
              ON cover_art_archive.cover_art.id = cover_art_archive.index_listing.id
              WHERE cover_art_archive.index_listing.release
              IN (?)
              ORDER BY cover_art_archive.index_listing.ordering'
      	()
      DBD::Pg::st execute failed: ERROR:  invalid input syntax for integer: ""
      LINE 15:         IN ('')
                           ^ at lib/Sql.pm line 83.
      
       at lib/Sql.pm line 88.
      	Sql::__ANON__('DBD::Pg::st execute failed: ERROR:  invalid input syntax for ...') called at local/lib/perl5/Try/Tiny.pm line 100
      	Try::Tiny::try('CODE(0x105bfd78)', 'Try::Tiny::Catch=REF(0x105b28a8)') called at lib/Sql.pm line 90
      	Sql::select('Sql=HASH(0xd42ec18)', 'SELECT\x{a}            cover_art_archive.index_listing.id,\x{a}      ...', '') called at lib/MusicBrainz/Server/Data/Utils.pm line 194
      	MusicBrainz::Server::Data::Utils::query_to_list('Sql=HASH(0xd42ec18)', 'CODE(0x105bdb48)', 'SELECT\x{a}            cover_art_archive.index_listing.id,\x{a}      ...', '') called at lib/MusicBrainz/Server/Data/Artwork.pm line 81
      	MusicBrainz::Server::Data::Artwork::find_by_release('MusicBrainz::Server::Data::Artwork=HASH(0xa962998)', 'MusicBrainz::Server::Entity::Release=HASH(0x105bbc08)') called at lib/MusicBrainz/Server/Edit/Release/ReorderCoverArt.pm line 104
      	MusicBrainz::Server::Edit::Release::ReorderCoverArt::build_display_data('MusicBrainz::Server::Edit::Release::ReorderCoverArt=HASH(0x10...', 'HASH(0xde67c60)') called at lib/MusicBrainz/Server/Data/Edit.pm line 497
      	MusicBrainz::Server::Data::Edit::load_all('MusicBrainz::Server::Data::Edit=HASH(0xae437b0)', 'MusicBrainz::Server::Edit::Relationship::Create=HASH(0x104803c8)', 'MusicBrainz::Server::Edit::Relationship::Create=HASH(0xf101c68)', 'MusicBrainz::Server::Edit::Relationship::Create=HASH(0x10489a20)', 'MusicBrainz::Server::Edit::Relationship::Create=HASH(0x1048a2a8)', 'MusicBrainz::Server::Edit::Release::Edit=HASH(0x1048d980)', 'MusicBrainz::Server::Edit::Relationship::Create=HASH(0x1048fbe8)', 'MusicBrainz::Server::Edit::Medium::Create=HASH(0x104926d0)', 'MusicBrainz::Server::Edit::Release::Create=HASH(0x10492760)', ...) called at lib/MusicBrainz/Server/Controller/Role/EditListing.pm line 65
      	MusicBrainz::Server::Controller::Role::EditListing::_list('MusicBrainz::Server::Controller::Artist=HASH(0xbfe91e8)', 'MusicBrainz::Server=HASH(0xd268e00)', 'CODE(0xcdae900)') called at lib/MusicBrainz/Server/Controller/Role/EditListing.pm line 18
      	MusicBrainz::Server::Controller::Role::EditListing::edits('MusicBrainz::Server::Controller::Artist=HASH(0xbfe91e8)', 'MusicBrainz::Server=HASH(0xd268e00)') called at local/lib/perl5/Catalyst/Action.pm line 65
      	Catalyst::Action::execute('Catalyst::Action=HASH(0xc46a6d0)', 'MusicBrainz::Server::Controller::Artist=HASH(0xbfe91e8)', 'MusicBrainz::Server=HASH(0xd268e00)') called at local/lib/perl5/Catalyst.pm line 1672
      	eval {...} called at local/lib/perl5/Catalyst.pm line 1672
      	Catalyst::execute('MusicBrainz::Server=HASH(0xd268e00)', 'MusicBrainz::Server::Controller::Artist', 'Catalyst::Action=HASH(0xc46a6d0)') called at local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
      	Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xd268e00)', 'MusicBrainz::Server::Controller::Artist', 'Catalyst::Action=HASH(0xc46a6d0)') called at local/lib/perl5/Catalyst/Action.pm line 60
      	Catalyst::Action::dispatch('Catalyst::Action=HASH(0xc46a6d0)', 'MusicBrainz::Server=HASH(0xd268e00)') called at local/lib/perl5/Catalyst/ActionChain.pm line 38
      	Catalyst::ActionChain::dispatch('Catalyst::ActionChain=HASH(0xcd8e468)', 'MusicBrainz::Server=HASH(0xd268e00)') called at local/lib/perl5/Catalyst/Controller.pm line 158
      	Catalyst::Controller::_ACTION('MusicBrainz::Server::Controller::Artist=HASH(0xbfe91e8)', 'MusicBrainz::Server=HASH(0xd268e00)') called at local/lib/perl5/Catalyst/Action.pm line 65
      	Catalyst::Action::execute('Catalyst::Action=HASH(0xc4546e8)', 'MusicBrainz::Server::Controller::Artist=HASH(0xbfe91e8)', 'MusicBrainz::Server=HASH(0xd268e00)') called at local/lib/perl5/Catalyst.pm line 1672
      	eval {...} called at local/lib/perl5/Catalyst.pm line 1672
      	Catalyst::execute('MusicBrainz::Server=HASH(0xd268e00)', 'MusicBrainz::Server::Controller::Artist', 'Catalyst::Action=HASH(0xc4546e8)') called at local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
      	Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xd268e00)', 'MusicBrainz::Server::Controller::Artist', 'Catalyst::Action=HASH(0xc4546e8)') called at local/lib/perl5/Catalyst/Action.pm line 60
      	Catalyst::Action::dispatch('Catalyst::Action=HASH(0xc4546e8)', 'MusicBrainz::Server=HASH(0xd268e00)') called at local/lib/perl5/Catalyst/Dispatcher.pm line 257
      	Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x40373b0)', 'forward', 'MusicBrainz::Server=HASH(0xd268e00)', '_ACTION') called at local/lib/perl5/Catalyst/Dispatcher.pm line 237
      	Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x40373b0)', 'MusicBrainz::Server=HASH(0xd268e00)', '_ACTION') called at local/lib/perl5/Catalyst.pm line 362
      	Catalyst::forward('MusicBrainz::Server=HASH(0xd268e00)', '_ACTION') called at local/lib/perl5/Catalyst/Controller.pm line 132
      	Catalyst::Controller::_DISPATCH('MusicBrainz::Server::Controller::Artist=HASH(0xbfe91e8)', 'MusicBrainz::Server=HASH(0xd268e00)') called at local/lib/perl5/Catalyst/Action.pm line 65
      	Catalyst::Action::execute('Catalyst::Action=HASH(0xc4534a0)', 'MusicBrainz::Server::Controller::Artist=HASH(0xbfe91e8)', 'MusicBrainz::Server=HASH(0xd268e00)') called at local/lib/perl5/Catalyst.pm line 1672
      	eval {...} called at local/lib/perl5/Catalyst.pm line 1672
      	Catalyst::execute('MusicBrainz::Server=HASH(0xd268e00)', 'MusicBrainz::Server::Controller::Artist', 'Catalyst::Action=HASH(0xc4534a0)') called at local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
      	Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xd268e00)', 'MusicBrainz::Server::Controller::Artist', 'Catalyst::Action=HASH(0xc4534a0)') called at local/lib/perl5/Catalyst/Action.pm line 60
      	Catalyst::Action::dispatch('Catalyst::Action=HASH(0xc4534a0)', 'MusicBrainz::Server=HASH(0xd268e00)') called at local/lib/perl5/Catalyst/Dispatcher.pm line 257
      	Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x40373b0)', 'forward', 'MusicBrainz::Server=HASH(0xd268e00)', '/artist/_DISPATCH') called at local/lib/perl5/Catalyst/Dispatcher.pm line 237
      	Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x40373b0)', 'MusicBrainz::Server=HASH(0xd268e00)', '/artist/_DISPATCH') called at local/lib/perl5/Catalyst.pm line 362
      	Catalyst::forward('MusicBrainz::Server=HASH(0xd268e00)', '/artist/_DISPATCH') called at local/lib/perl5/Catalyst/Dispatcher.pm line 105
      	Catalyst::Dispatcher::dispatch('Catalyst::Dispatcher=HASH(0x40373b0)', 'MusicBrainz::Server=HASH(0xd268e00)') called at local/lib/perl5/Catalyst.pm line 1618
      	Catalyst::dispatch('MusicBrainz::Server=HASH(0xd268e00)') called at lib/MusicBrainz/Server.pm line 304
      	MusicBrainz::Server::__ANON__() called at lib/MusicBrainz/Server.pm line 296
      	MusicBrainz::Server::with_translations('MusicBrainz::Server=HASH(0xd268e00)', 'CODE(0xcd23148)') called at lib/MusicBrainz/Server.pm line 305
      	Class::MOP::Class:::around('CODE(0x328b228)', 'MusicBrainz::Server=HASH(0xd268e00)') called at local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 162
      	Class::MOP::Method::Wrapped::__ANON__('MusicBrainz::Server=HASH(0xd268e00)') called at lib/MusicBrainz/Server.pm line 318
      	Class::MOP::Class:::around('CODE(0x4ca59a8)', 'MusicBrainz::Server=HASH(0xd268e00)') called at local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 162
      	Class::MOP::Method::Wrapped::__ANON__('MusicBrainz::Server=HASH(0xd268e00)') called at lib/MusicBrainz/Server.pm line 363
      	Class::MOP::Class:::around('CODE(0xc57b9b8)', 'MusicBrainz::Server=HASH(0xd268e00)') called at local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 162
      	Class::MOP::Method::Wrapped::__ANON__('MusicBrainz::Server=HASH(0xd268e00)') called at local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 35
      	Class::MOP::Method::Wrapped::__ANON__('MusicBrainz::Server=HASH(0xd268e00)') called at local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 91
      	MusicBrainz::Server::dispatch('MusicBrainz::Server=HASH(0xd268e00)') called at local/lib/perl5/Catalyst.pm line 1968
      	Catalyst::__ANON__() called at local/lib/perl5/Try/Tiny.pm line 76
      	eval {...} called at local/lib/perl5/Try/Tiny.pm line 67
      	Try::Tiny::try('CODE(0xca20d50)', 'Try::Tiny::Catch=REF(0xd4e1de0)') called at local/lib/perl5/Catalyst.pm line 1974
      	Catalyst::handle_request('MusicBrainz::Server', 'env', 'HASH(0xc848c68)', 'response_cb', 'CODE(0xc848830)') called at local/lib/perl5/Catalyst/Plugin/AutoRestart.pm line 117
      	Catalyst::Plugin::AutoRestart::handle_request('MusicBrainz::Server', 'env', 'HASH(0xc848c68)', 'response_cb', 'CODE(0xc848830)') called at local/lib/perl5/Catalyst/Engine.pm line 688
      	Catalyst::Engine::__ANON__('CODE(0xc848830)') called at local/lib/perl5/Plack/Handler/FCGI.pm line 130
      	Plack::Handler::FCGI::run('Plack::Handler::FCGI=HASH(0x15c69d0)', 'CODE(0xc580db8)') called at local/lib/perl5/Plack/Loader.pm line 84
      	Plack::Loader::run('Plack::Loader=HASH(0x14edc90)', 'Plack::Handler::FCGI=HASH(0x15c69d0)') called at local/lib/perl5/Plack/Runner.pm line 267
      	Plack::Runner::run('Plack::Runner=HASH(0x1376808)') called at local/bin/plackup line 10"
      
      Stack trace:
      
          line 194 MusicBrainz::Server::Data::Utils
          line 81 MusicBrainz::Server::Data::Artwork
          line 104 MusicBrainz::Server::Edit::Release::ReorderCoverArt
          line 497 MusicBrainz::Server::Data::Edit
          line 65 MusicBrainz::Server::Controller::Role::EditListing
          line 18 MusicBrainz::Server::Controller::Role::EditListing
          line 304 MusicBrainz::Server
          line 296 MusicBrainz::Server
          line 305 MusicBrainz::Server
          line 318 MusicBrainz::Server
          line 363 MusicBrainz::Server
      
      Request data:
      
      $VAR1 = {
                'query_parameters' => {},
                'body_parameters' => {}
              };
                  
      
      Host: astro
      
      URL: http://musicbrainz.org/artist/dec0d102-2d5b-4087-af71-5321a2b88457/edits
      

        Attachments

          Activity

            People

            • Assignee:
              ianmcorvidae Ian McEwen
              Reporter:
              salo.rock Luca Salini
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Packages

                Version Package
                2013-03-11