-
Bug
-
Resolution: Fixed
-
Normal
-
None
-
None
Caught exception in MusicBrainz::Server::Controller::ReleaseEditor::Edit->edit "Failed query: 'UPDATE editor SET edits_accepted = edits_accepted + 1 WHERE id = ?' (53705) DBD::Pg::st execute failed: ERROR: deadlock detected DETAIL: Process 11487 waits for ShareLock on transaction 96888350; blocked by process 12561. Process 12561 waits for ExclusiveLock on tuple (6975,37) of relation 1514451 of database 1416385; blocked by process 11487. HINT: See server log for query details. at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 103. at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 109 Sql::__ANON__('DBD::Pg::st execute failed: ERROR: deadlock detected\x{a}DETAIL:...') called at /usr/local/share/perl/5.10.1/Try/Tiny.pm line 100 Try::Tiny::try('CODE(0xd9e37e0)', 'Try::Tiny::Catch=REF(0xd9e35a0)') called at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 110 Sql::do('Sql=HASH(0xa30afe8)', 'UPDATE editor SET edits_accepted = edits_accepted + 1 WHERE i...', 53705) called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Data/Editor.pm line 371 MusicBrainz::Server::Data::Editor::credit('MusicBrainz::Server::Data::Editor=HASH(0xd9b0b10)', 53705, 2) called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Data/Edit.pm line 590 MusicBrainz::Server::Data::Edit::_close('MusicBrainz::Server::Data::Edit=HASH(0x889b428)', 'MusicBrainz::Server::Edit::Release::Edit=HASH(0xd9e34c8)', 'CODE(0xd9b72d0)') called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Data/Edit.pm line 558 MusicBrainz::Server::Data::Edit::accept('MusicBrainz::Server::Data::Edit=HASH(0x889b428)', 'MusicBrainz::Server::Edit::Release::Edit=HASH(0xd9e34c8)') called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Data/Edit.pm line 416 MusicBrainz::Server::Data::Edit::__ANON__() called at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 264 Sql::__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(0xd9b2be0)', 'Try::Tiny::Catch=REF(0xd9c6ab8)') called at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 277 Sql::_auto_transaction('CODE(0xd988810)', 'Sql=HASH(0xa30afe8)') called at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 282 Sql::_run_in_transaction_one('CODE(0xd988810)', 'Sql=HASH(0xa30afe8)') called at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 296 Sql::run_in_transaction('CODE(0xd988810)', 'Sql=HASH(0xa30afe8)') called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Data/Edit.pm line 421 MusicBrainz::Server::Data::Edit::create('MusicBrainz::Server::Data::Edit=HASH(0x889b428)', 'edit_type', 32, 'editor_id', 53705, 'packaging_id', 1, 'privileges', 41, ...) called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 1203 MusicBrainz::Server::Wizard::ReleaseEditor::__ANON__('edit_type', 32, 'editor_id', 53705, 'packaging_id', 1, 'privileges', 41, 'date', ...) called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 1228 eval {...} called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 1227 MusicBrainz::Server::Wizard::ReleaseEditor::_create_edit('MusicBrainz::Server::Wizard::ReleaseEditor::Edit=HASH(0xbef2f68)', 'CODE(0xc43ba00)', 32, 53705, 'privileges', 41, 'packaging_id', 1, 'date', ...) called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 1204 MusicBrainz::Server::Wizard::ReleaseEditor::_submit_edit('MusicBrainz::Server::Wizard::ReleaseEditor::Edit=HASH(0xbef2f68)', 32, undef, 'packaging_id', 1, 'date', 'HASH(0xc337ef0)', 'name', 'Crazy', ...) called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 790 MusicBrainz::Server::Wizard::ReleaseEditor::__ANON__(32, undef, 'packaging_id', 1, 'date', 'HASH(0xc337ef0)', 'name', 'Crazy', 'barcode', ...) called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Wizard/ReleaseEditor/Edit.pm line 39 MusicBrainz::Server::Wizard::ReleaseEditor::Edit::__ANON__('MusicBrainz::Server::Wizard::ReleaseEditor::Edit=HASH(0xbef2f68)', 'data', 'HASH(0xc46a198)', 'create_edit', 'CODE(0xbf71d68)', 'edit_note', undef, 'previewing', '', ...) called at /usr/local/lib/perl/5.10.1/Moose.pm line 110 Moose::inner() called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 862 MusicBrainz::Server::Wizard::ReleaseEditor::create_edits('MusicBrainz::Server::Wizard::ReleaseEditor::Edit=HASH(0xbef2f68)', 'data', 'HASH(0xc46a198)', 'create_edit', 'CODE(0xbf71d68)', 'edit_note', undef, 'previewing', '', ...) called at /usr/local/lib/perl/5.10.1/Moose/Meta/Method/Augmented.pm line 46 MusicBrainz::Server::Wizard::ReleaseEditor::Edit::create_edits('MusicBrainz::Server::Wizard::ReleaseEditor::Edit=HASH(0xbef2f68)', 'data', 'HASH(0xc46a198)', 'create_edit', 'CODE(0xbf71d68)', 'edit_note', undef, 'previewing', '', ...) called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 791 MusicBrainz::Server::Wizard::ReleaseEditor::prepare_edits('MusicBrainz::Server::Wizard::ReleaseEditor::Edit=HASH(0xbef2f68)') called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 94 MusicBrainz::Server::Wizard::ReleaseEditor::run('MusicBrainz::Server::Wizard::ReleaseEditor::Edit=HASH(0xbef2f68)') called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Controller/ReleaseEditor/Edit.pm line 17 MusicBrainz::Server::Controller::ReleaseEditor::Edit::edit('MusicBrainz::Server::Controller::ReleaseEditor::Edit=HASH(0x9...', 'MusicBrainz::Server=HASH(0xc47b8f0)') called at /usr/local/share/perl/5.10.1/Catalyst/Action.pm line 65 Catalyst::Action::execute('Catalyst::Action=HASH(0x9db0c90)', 'MusicBrainz::Server::Controller::ReleaseEditor::Edit=HASH(0x9...', 'MusicBrainz::Server=HASH(0xc47b8f0)') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1665 eval {...} called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1665 Catalyst::execute('MusicBrainz::Server=HASH(0xc47b8f0)', 'MusicBrainz::Server::Controller::ReleaseEditor::Edit', 'Catalyst::Action=HASH(0x9db0c90)') called at /usr/local/share/perl/5.10.1/Catalyst/Plugin/StackTrace.pm line 94 Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xc47b8f0)', 'MusicBrainz::Server::Controller::ReleaseEditor::Edit', 'Catalyst::Action=HASH(0x9db0c90)') called at /usr/local/share/perl/5.10.1/Catalyst/Action.pm line 60 Catalyst::Action::dispatch('Catalyst::Action=HASH(0x9db0c90)', 'MusicBrainz::Server=HASH(0xc47b8f0)') called at /usr/local/share/perl/5.10.1/Catalyst/ActionChain.pm line 39 Catalyst::ActionChain::dispatch('Catalyst::ActionChain=HASH(0xc349c20)', 'MusicBrainz::Server=HASH(0xc47b8f0)') called at /usr/local/share/perl/5.10.1/Catalyst/Controller.pm line 110 Catalyst::Controller::_ACTION('MusicBrainz::Server::Controller::ReleaseEditor::Add=HASH(0x9b...', 'MusicBrainz::Server=HASH(0xc47b8f0)') called at /usr/local/share/perl/5.10.1/Catalyst/Action.pm line 65 Catalyst::Action::execute('Catalyst::Action=HASH(0x9da51a0)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add=HASH(0x9b...', 'MusicBrainz::Server=HASH(0xc47b8f0)') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1665 eval {...} called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1665 Catalyst::execute('MusicBrainz::Server=HASH(0xc47b8f0)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add', 'Catalyst::Action=HASH(0x9da51a0)') called at /usr/local/share/perl/5.10.1/Catalyst/Plugin/StackTrace.pm line 94 Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xc47b8f0)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add', 'Catalyst::Action=HASH(0x9da51a0)') called at /usr/local/share/perl/5.10.1/Catalyst/Action.pm line 60 Catalyst::Action::dispatch('Catalyst::Action=HASH(0x9da51a0)', 'MusicBrainz::Server=HASH(0xc47b8f0)') called at /usr/local/share/perl/5.10.1/Catalyst/Dispatcher.pm line 257 Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x22d6230)', 'forward', 'MusicBrainz::Server=HASH(0xc47b8f0)', '_ACTION') called at /usr/local/share/perl/5.10.1/Catalyst/Dispatcher.pm line 237 Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x22d6230)', 'MusicBrainz::Server=HASH(0xc47b8f0)', '_ACTION') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 377 Catalyst::forward('MusicBrainz::Server=HASH(0xc47b8f0)', '_ACTION') called at /usr/local/share/perl/5.10.1/Catalyst/Controller.pm line 84 Catalyst::Controller::_DISPATCH('MusicBrainz::Server::Controller::ReleaseEditor::Add=HASH(0x9b...', 'MusicBrainz::Server=HASH(0xc47b8f0)') called at /usr/local/share/perl/5.10.1/Catalyst/Action.pm line 65 Catalyst::Action::execute('Catalyst::Action=HASH(0x9ec61b0)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add=HASH(0x9b...', 'MusicBrainz::Server=HASH(0xc47b8f0)') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1665 eval {...} called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1665 Catalyst::execute('MusicBrainz::Server=HASH(0xc47b8f0)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add', 'Catalyst::Action=HASH(0x9ec61b0)') called at /usr/local/share/perl/5.10.1/Catalyst/Plugin/StackTrace.pm line 94 Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xc47b8f0)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add', 'Catalyst::Action=HASH(0x9ec61b0)') called at /usr/local/share/perl/5.10.1/Catalyst/Action.pm line 60 Catalyst::Action::dispatch('Catalyst::Action=HASH(0x9ec61b0)', 'MusicBrainz::Server=HASH(0xc47b8f0)') called at /usr/local/share/perl/5.10.1/Catalyst/Dispatcher.pm line 257 Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x22d6230)', 'forward', 'MusicBrainz::Server=HASH(0xc47b8f0)', '/release_editor/_DISPATCH') called at /usr/local/share/perl/5.10.1/Catalyst/Dispatcher.pm line 237 Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x22d6230)', 'MusicBrainz::Server=HASH(0xc47b8f0)', '/release_editor/_DISPATCH') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 377 Catalyst::forward('MusicBrainz::Server=HASH(0xc47b8f0)', '/release_editor/_DISPATCH') called at /usr/local/share/perl/5.10.1/Catalyst/Dispatcher.pm line 105 Catalyst::Dispatcher::dispatch('Catalyst::Dispatcher=HASH(0x22d6230)', 'MusicBrainz::Server=HASH(0xc47b8f0)') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1611 Catalyst::dispatch('MusicBrainz::Server=HASH(0xc47b8f0)') called at /usr/local/share/perl/5.10.1/Catalyst/Plugin/Static/Simple.pm line 76 Class::MOP::Class:::around('CODE(0x29322f0)', 'MusicBrainz::Server=HASH(0xc47b8f0)') called at /usr/local/lib/perl/5.10.1/Class/MOP/Method/Wrapped.pm line 159 Class::MOP::Method::Wrapped::__ANON__('MusicBrainz::Server=HASH(0xc47b8f0)') called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server.pm line 273 Class::MOP::Class:::around('CODE(0xa12c788)', 'MusicBrainz::Server=HASH(0xc47b8f0)') called at /usr/local/lib/perl/5.10.1/Class/MOP/Method/Wrapped.pm line 159 Class::MOP::Method::Wrapped::__ANON__('MusicBrainz::Server=HASH(0xc47b8f0)') called at /usr/local/lib/perl/5.10.1/Class/MOP/Method/Wrapped.pm line 89 MusicBrainz::Server::dispatch('MusicBrainz::Server=HASH(0xc47b8f0)') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1952 eval {...} called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1943 Catalyst::handle_request('MusicBrainz::Server', 'env', 'HASH(0x3696b90)') called at /home/musicbrainz/musicbrainz-server/script/../lib/Catalyst/Plugin/AutoRestart.pm line 119 Catalyst::Plugin::AutoRestart::handle_request('MusicBrainz::Server', 'env', 'HASH(0x3696b90)') called at /usr/local/share/perl/5.10.1/Catalyst/Engine/FastCGI.pm line 149 Catalyst::Engine::FastCGI::run('Catalyst::Engine::FastCGI=HASH(0x3661f70)', 'MusicBrainz::Server', '127.0.0.1:55901', 'HASH(0x11bfd48)') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 2396 Catalyst::run('MusicBrainz::Server', '127.0.0.1:55901', 'HASH(0x11bfd48)') called at ./script/musicbrainz_fastcgi.pl line 28 at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 277 ...propagated at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 1237." Stack trace: line 1237 MusicBrainz::Server::Wizard::ReleaseEditor line 1204 MusicBrainz::Server::Wizard::ReleaseEditor line 790 MusicBrainz::Server::Wizard::ReleaseEditor line 39 MusicBrainz::Server::Wizard::ReleaseEditor::Edit line 862 MusicBrainz::Server::Wizard::ReleaseEditor line 791 MusicBrainz::Server::Wizard::ReleaseEditor line 94 MusicBrainz::Server::Wizard::ReleaseEditor line 17 MusicBrainz::Server::Controller::ReleaseEditor::Edit line 273 MusicBrainz::Server Request data: $VAR1 = { 'query_parameters' => {}, 'body_parameters' => { 'save' => 'Enter edit', 'wizard_page_id' => '4', 'edit_note' => '', 'as_auto_editor' => '1', 'wizard_session_id' => '0.7236968333108' } };
URL: http://musicbrainz.org/release/ef136470-8f63-449c-bc33-91e104f1eefc/edit
- is duplicated by
-
MBS-4069 Deadlocks while adding works
- Closed