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

Internal Server Error (deadlock detected)

    XMLWordPrintable

    Details

      Description

      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

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                ianmcorvidae Ian McEwen
                Reporter:
                nikki nikki
              • Votes:
                1 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Packages

                  Version Package
                  Bug fixes, 2012-08-20