Issue Details (XML | Word | Printable)

Key: MBS-4930
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Normal Normal
Assignee: Oliver Charles
Reporter: nikki
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
MusicBrainz Server

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

Created: 25/Jun/12 08:00 PM   Updated: 20/Aug/12 09:51 AM   Resolved: 20/Aug/12 09:51 AM
Component/s: None
Affects Version/s: Beta
Fix Version/s: Bug fixes, 2012-08-20

Issue Links:
Duplicate
 


 Description  « Hide

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.

Sort Order: Ascending order - Click to sort in descending order
[ Permalink | « Hide ]
nikki added a comment - 25/Jun/12 09:18 PM

Confirmed that it's not just the release editor. Got the same thing while trying to vote/comment on an edit.


[ Permalink | « Hide ]
nikki added a comment - 29/Jun/12 05:25 AM

Seems to have gone away. Will reopen if it starts again.


[ Permalink | « Hide ]
nikki added a comment - 10/Jul/12 01:26 PM

This started happening again yesterday and despite restarting things, beta is still pretty much unusable today.


[ Permalink | « Hide ]
Oliver Charles added a comment - 16/Jul/12 09:03 AM

nikki: has this happened since totoro exploded last week?


[ Permalink | « Hide ]
nikki added a comment - 16/Jul/12 10:18 AM

I don't remember when it stopped, but it's gone away again for now.


[ Permalink | « Hide ]
Oliver Charles added a comment - 16/Jul/12 10:55 AM

Please reopen if it starts happening again. It's a bit frustrating we haven't got a real fix yet though


Atlassian JIRA (v4.0.1#471) | Report a problem | Request a feature | Contact administrators
Powered by a free Atlassian JIRA open source license for MetaBrainz Foundation. Try JIRA - bug tracking software for your team.