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

beta.mb: Random internal server error (current transaction is aborted)

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: Beta
    • Fix Version/s: Bug fixes, 2012-08-20
    • Component/s: None
    • Labels:
      None

      Description

      I have suddenly started getting errors like the following in the release editor:

      Caught exception in MusicBrainz::Server::Controller::Release->load "Failed query: 'SELECT release.id, release.gid, name.name, release.artist_credit AS artist_credit_id, release.release_group, release.status, release.packaging, release.date_year, release.date_month, release.date_day, release.country, release.comment, release.edits_pending, release.barcode, release.script, release.language, release.quality, release.last_updated FROM release JOIN release_name name ON release.name=name.id WHERE gid IN (?) ' (c68edd74-75b4-4d0a-9bec-2b671a77aa22) DBD::Pg::st execute failed: ERROR: current transaction is aborted, commands ignored until end of transaction block at lib/Sql.pm line 79. at lib/Sql.pm line 84 Sql::__ANON__('DBD::Pg::st execute failed: ERROR: current transaction is ab...') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Try/Tiny.pm line 100 Try::Tiny::try('CODE(0x7f027f6ab798)', 'Try::Tiny::Catch=REF(0x10c0e3a0)') called at lib/Sql.pm line 86 Sql::select('Sql=HASH(0xb17e110)', 'SELECT release.id, release.gid, name.name, release.artist_cre...', 'c68edd74-75b4-4d0a-9bec-2b671a77aa22') called at lib/MusicBrainz/Server/Data/Entity.pm line 44 MusicBrainz::Server::Data::Entity::_get_by_keys_append_sql('MusicBrainz::Server::Data::Release=HASH(0xa233008)', 'gid', '', 'c68edd74-75b4-4d0a-9bec-2b671a77aa22') called at lib/MusicBrainz/Server/Data/Entity.pm line 31 MusicBrainz::Server::Data::Entity::_get_by_keys('MusicBrainz::Server::Data::Release=HASH(0xa233008)', 'gid', 'c68edd74-75b4-4d0a-9bec-2b671a77aa22') called at lib/MusicBrainz/Server/Data/Role/GetByGID.pm line 10 MusicBrainz::Server::Data::Role::GetByGID::get_by_gid('MusicBrainz::Server::Data::Release=HASH(0xa233008)', 'c68edd74-75b4-4d0a-9bec-2b671a77aa22') called at lib/MusicBrainz/Server/Data/CoreEntity.pm line 50 Class::MOP::Class:::around(undef, undef, 'c68edd74-75b4-4d0a-9bec-2b671a77aa22') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 162 Class::MOP::Method::Wrapped::__ANON__('MusicBrainz::Server::Data::Release=HASH(0xa233008)', 'c68edd74-75b4-4d0a-9bec-2b671a77aa22') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 91 MusicBrainz::Server::Data::CoreEntity::get_by_gid('MusicBrainz::Server::Data::Release=HASH(0xa233008)', 'c68edd74-75b4-4d0a-9bec-2b671a77aa22') called at lib/MusicBrainz/Server/Controller/Role/Load.pm line 60 Moose::Meta::Role::__ANON__::SERIAL::155::_load('MusicBrainz::Server::Controller::Release=HASH(0xaad3650)', 'MusicBrainz::Server=HASH(0x1020e5f0)', 'c68edd74-75b4-4d0a-9bec-2b671a77aa22') called at lib/MusicBrainz/Server/Controller/Role/LoadWithRowID.pm line 17 Class::MOP::Class:::around('CODE(0x7a68070)', 'MusicBrainz::Server::Controller::Release=HASH(0xaad3650)', 'MusicBrainz::Server=HASH(0x1020e5f0)', 'c68edd74-75b4-4d0a-9bec-2b671a77aa22') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 162 Class::MOP::Method::Wrapped::__ANON__('MusicBrainz::Server::Controller::Release=HASH(0xaad3650)', 'MusicBrainz::Server=HASH(0x1020e5f0)', 'c68edd74-75b4-4d0a-9bec-2b671a77aa22') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 91 MusicBrainz::Server::Controller::Release::_load('MusicBrainz::Server::Controller::Release=HASH(0xaad3650)', 'MusicBrainz::Server=HASH(0x1020e5f0)', 'c68edd74-75b4-4d0a-9bec-2b671a77aa22') called at lib/MusicBrainz/Server/Controller/Role/Load.pm line 41 Moose::Meta::Role::__ANON__::SERIAL::155::load('MusicBrainz::Server::Controller::Release=HASH(0xaad3650)', 'MusicBrainz::Server=HASH(0x1020e5f0)', 'c68edd74-75b4-4d0a-9bec-2b671a77aa22') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 56 Class::MOP::Method::Wrapped::__ANON__('MusicBrainz::Server::Controller::Release=HASH(0xaad3650)', 'MusicBrainz::Server=HASH(0x1020e5f0)', 'c68edd74-75b4-4d0a-9bec-2b671a77aa22') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 91 MusicBrainz::Server::Controller::Release::load('MusicBrainz::Server::Controller::Release=HASH(0xaad3650)', 'MusicBrainz::Server=HASH(0x1020e5f0)', 'c68edd74-75b4-4d0a-9bec-2b671a77aa22') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Action.pm line 65 Catalyst::Action::execute('Catalyst::Action=HASH(0xaea1be0)', 'MusicBrainz::Server::Controller::Release=HASH(0xaad3650)', 'MusicBrainz::Server=HASH(0x1020e5f0)', 'c68edd74-75b4-4d0a-9bec-2b671a77aa22') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst.pm line 1667 eval {...} called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst.pm line 1667 Catalyst::execute('MusicBrainz::Server=HASH(0x1020e5f0)', 'MusicBrainz::Server::Controller::Release', 'Catalyst::Action=HASH(0xaea1be0)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94 Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0x1020e5f0)', 'MusicBrainz::Server::Controller::Release', 'Catalyst::Action=HASH(0xaea1be0)') called at lib/MusicBrainz/Server.pm line 306 MusicBrainz::Server::execute('MusicBrainz::Server=HASH(0x1020e5f0)', 'MusicBrainz::Server::Controller::Release', 'Catalyst::Action=HASH(0xaea1be0)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Action.pm line 60 Catalyst::Action::dispatch('Catalyst::Action=HASH(0xaea1be0)', 'MusicBrainz::Server=HASH(0x1020e5f0)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst/ActionChain.pm line 36 Catalyst::ActionChain::dispatch('Catalyst::ActionChain=HASH(0x10316f28)', 'MusicBrainz::Server=HASH(0x1020e5f0)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Controller.pm line 125 Catalyst::Controller::_ACTION('MusicBrainz::Server::Controller::ReleaseEditor::Add=HASH(0xab...', 'MusicBrainz::Server=HASH(0x1020e5f0)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Action.pm line 65 Catalyst::Action::execute('Catalyst::Action=HASH(0xace5ef8)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add=HASH(0xab...', 'MusicBrainz::Server=HASH(0x1020e5f0)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst.pm line 1667 eval {...} called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst.pm line 1667 Catalyst::execute('MusicBrainz::Server=HASH(0x1020e5f0)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add', 'Catalyst::Action=HASH(0xace5ef8)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94 Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0x1020e5f0)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add', 'Catalyst::Action=HASH(0xace5ef8)') called at lib/MusicBrainz/Server.pm line 306 MusicBrainz::Server::execute('MusicBrainz::Server=HASH(0x1020e5f0)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add', 'Catalyst::Action=HASH(0xace5ef8)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Action.pm line 60 Catalyst::Action::dispatch('Catalyst::Action=HASH(0xace5ef8)', 'MusicBrainz::Server=HASH(0x1020e5f0)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Dispatcher.pm line 257 Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x2d408b8)', 'forward', 'MusicBrainz::Server=HASH(0x1020e5f0)', '_ACTION') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Dispatcher.pm line 237 Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x2d408b8)', 'MusicBrainz::Server=HASH(0x1020e5f0)', '_ACTION') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst.pm line 342 Catalyst::forward('MusicBrainz::Server=HASH(0x1020e5f0)', '_ACTION') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Controller.pm line 99 Catalyst::Controller::_DISPATCH('MusicBrainz::Server::Controller::ReleaseEditor::Add=HASH(0xab...', 'MusicBrainz::Server=HASH(0x1020e5f0)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Action.pm line 65 Catalyst::Action::execute('Catalyst::Action=HASH(0xae48f30)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add=HASH(0xab...', 'MusicBrainz::Server=HASH(0x1020e5f0)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst.pm line 1667 eval {...} called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst.pm line 1667 Catalyst::execute('MusicBrainz::Server=HASH(0x1020e5f0)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add', 'Catalyst::Action=HASH(0xae48f30)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94 Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0x1020e5f0)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add', 'Catalyst::Action=HASH(0xae48f30)') called at lib/MusicBrainz/Server.pm line 306 MusicBrainz::Server::execute('MusicBrainz::Server=HASH(0x1020e5f0)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add', 'Catalyst::Action=HASH(0xae48f30)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Action.pm line 60 Catalyst::Action::dispatch('Catalyst::Action=HASH(0xae48f30)', 'MusicBrainz::Server=HASH(0x1020e5f0)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Dispatcher.pm line 257 Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x2d408b8)', 'forward', 'MusicBrainz::Server=HASH(0x1020e5f0)', '/release_editor/_DISPATCH') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Dispatcher.pm line 237 Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x2d408b8)', 'MusicBrainz::Server=HASH(0x1020e5f0)', '/release_editor/_DISPATCH') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst.pm line 342 Catalyst::forward('MusicBrainz::Server=HASH(0x1020e5f0)', '/release_editor/_DISPATCH') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Dispatcher.pm line 105 Catalyst::Dispatcher::dispatch('Catalyst::Dispatcher=HASH(0x2d408b8)', 'MusicBrainz::Server=HASH(0x1020e5f0)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst.pm line 1613 Catalyst::dispatch('MusicBrainz::Server=HASH(0x1020e5f0)') called at lib/MusicBrainz/Server.pm line 270 Class::MOP::Class:::around('CODE(0x27cf258)', 'MusicBrainz::Server=HASH(0x1020e5f0)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 162 Class::MOP::Method::Wrapped::__ANON__('MusicBrainz::Server=HASH(0x1020e5f0)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 91 MusicBrainz::Server::dispatch('MusicBrainz::Server=HASH(0x1020e5f0)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst.pm line 1963 Catalyst::__ANON__() called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Try/Tiny.pm line 76 eval {...} called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Try/Tiny.pm line 67 Try::Tiny::try('CODE(0x10c0e430)', 'Try::Tiny::Catch=REF(0x10208c38)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst.pm line 1969 Catalyst::handle_request('MusicBrainz::Server', 'env', 'HASH(0xfc78018)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Plugin/AutoRestart.pm line 114 Catalyst::Plugin::AutoRestart::handle_request('MusicBrainz::Server', 'env', 'HASH(0xfc78018)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Catalyst/Engine.pm line 856 Catalyst::Engine::__ANON__('CODE(0xb0b7010)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Plack/Handler/FCGI.pm line 134 Plack::Handler::FCGI::run('Plack::Handler::FCGI=HASH(0xbb9d30)', 'CODE(0xb0582b8)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Plack/Loader.pm line 88 Plack::Loader::run('Plack::Loader=HASH(0xb82bb0)', 'Plack::Handler::FCGI=HASH(0xbb9d30)') called at /home/beta/musicbrainz-server/admin/../local/lib/perl5/Plack/Runner.pm line 263 Plack::Runner::run('Plack::Runner=HASH(0x97ffb0)') called at /home/beta/musicbrainz-server/admin/../local/bin/plackup line 10"
      Caught exception in MusicBrainz::Server::Controller::ReleaseEditor::Edit->edit "Can't call method "id" on an undefined value at lib/MusicBrainz/Server/Data/Utils.pm line 360."
      
      
      Stack trace:
      line 360 MusicBrainz::Server::Data::Utils
      line 74 MusicBrainz::Server::Data::Medium
      line 89 MusicBrainz::Server::Wizard::ReleaseEditor::Edit
      line 61 MusicBrainz::Server::Wizard::ReleaseEditor
      line 168 MusicBrainz::Server::Wizard
      line 401 MusicBrainz::Server::Wizard
      line 132 MusicBrainz::Server::Wizard
      line 92 MusicBrainz::Server::Wizard::ReleaseEditor
      line 17 MusicBrainz::Server::Controller::ReleaseEditor::Edit
      line 306 MusicBrainz::Server
      line 306 MusicBrainz::Server
      line 306 MusicBrainz::Server
      line 270 MusicBrainz::Server
      
      Request data: 
      $VAR1 = {
                'query_parameters' => {},
                'body_parameters' => {
                                       'artist_credit.names.0.name' => 'Sefiros',
                                       'packaging_id' => '',
                                       'date.month' => '',
                                       'release_group_id' => '622852',
                                       'labels.0.catalog_number' => '',
                                       'wizard_page_id' => '0',
                                       'release_group.name' => 'Fadeout',
                                       'artist_credit.names.0.artist.id' => '492976',
                                       'labels.0.deleted' => '0',
                                       'country_id' => '',
                                       'labels.0.name' => '',
                                       'date.year' => '',
                                       'id' => '1015879',
                                       'script_id' => '28',
                                       'status_id' => '1',
                                       'step_tracklist' => 'Tracklist',
                                       'date.day' => '',
                                       'name' => 'Fadeout',
                                       'gc-keepuppercase' => 'on',
                                       'barcode' => '',
                                       'artist_credit.names.0.join_phrase' => '',
                                       'labels.0.label_id' => '',
                                       'wizard_session_id' => '0.528341263942053',
                                       'language_id' => '120',
                                       'comment' => '',
                                       'gc-mode' => 'English',
                                       'artist_credit.names.0.artist.name' => 'Sefiros',
                                       'annotation' => ''
                                     }
              };
                  
      
      
      URL: http://beta.musicbrainz.org/release/c68edd74-75b4-4d0a-9bec-2b671a77aa22/edit
      

      Refreshing makes the error go away and I've seen it on several releases in the last few minutes. I don't know if it affects anything other than the release editor yet.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                acid2 Oliver Charles
                Reporter:
                nikki nikki
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Packages

                  Version Package
                  Bug fixes, 2012-08-20