-
Bug
-
Resolution: Fixed
-
Normal
-
2012-10-01
-
None
I added a track of length "0:00" which the release editor converted into a length of "0ms" which caused an ISE.
Error:
Caught exception in MusicBrainz::Server::Controller::ReleaseEditor::Add->add "DBD::Pg::st execute failed: ERROR: new row for relation "recording" violates check constraint "recording_length_check" at lib/Sql.pm line 414.
at lib/Sql.pm line 429
Sql::_ANON_('DBD::Pg::st execute failed: ERROR: new row for relation "rec...') called at local/lib/perl5/Try/Tiny.pm line 100
Try::Tiny::try('CODE(0xf900378)', 'Try::Tiny::Catch=REF(0xf8d9488)') called at lib/Sql.pm line 430
Sql::_select_list('Sql=HASH(0xd12e070)', 'INSERT INTO recording (length,name,artist_credit,gid) VALUES ...', 'ARRAY(0xf88e9e8)', 'arrayref', 'CODE(0x4cf0ba8)') called at lib/Sql.pm line 449
Sql::select_list_of_lists('Sql=HASH(0xd12e070)', 'INSERT INTO recording (length,name,artist_credit,gid) VALUES ...', 0, 6184932, 654949, '1b45f285-bf96-47cd-84da-2af3df54caba') called at lib/Sql.pm line 382
Sql::select_single_column_array('Sql=HASH(0xd12e070)', 'INSERT INTO recording (length,name,artist_credit,gid) VALUES ...', 0, 6184932, 654949, '1b45f285-bf96-47cd-84da-2af3df54caba') called at lib/Sql.pm line 397
Sql::select_single_value('Sql=HASH(0xd12e070)', 'INSERT INTO recording (length,name,artist_credit,gid) VALUES ...', 0, 6184932, 654949, '1b45f285-bf96-47cd-84da-2af3df54caba') called at lib/Sql.pm line 150
Sql::insert_row('Sql=HASH(0xd12e070)', 'recording', 'HASH(0xf86e7d8)', 'id') called at lib/MusicBrainz/Server/Data/Recording.pm line 166
MusicBrainz::Server::Data::Recording::insert('MusicBrainz::Server::Data::Recording=HASH(0xb332288)', 'HASH(0xf877778)') called at lib/MusicBrainz/Server/Edit/Medium/Create.pm line 141
MusicBrainz::Server::Edit::Medium::Create::_insert_hash('MusicBrainz::Server::Edit::Medium::Create=HASH(0xf892bc0)', 'HASH(0xebd6ab8)') called at lib/MusicBrainz/Server/Edit/Generic/Create.pm line 44
MusicBrainz::Server::Edit::Generic::Create::insert('MusicBrainz::Server::Edit::Medium::Create=HASH(0xf892bc0)') called at lib/MusicBrainz/Server/Data/Edit.pm line 391
MusicBrainz::Server::Data::Edit::create('MusicBrainz::Server::Data::Edit=HASH(0xab410e0)', 'edit_type', 51, 'editor_id', 232267, 'format_id', 1, 'privileges', 57, ...) called at lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 1266
MusicBrainz::Server::Wizard::ReleaseEditor::_ANON_('edit_type', 51, 'editor_id', 232267, 'format_id', 1, 'privileges', 57, 'position', ...) called at lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 1293
MusicBrainz::Server::Wizard::ReleaseEditor::_ANON_() called at local/lib/perl5/Try/Tiny.pm line 76
eval
Try::Tiny::try('CODE(0xf877568)', 'Try::Tiny::Catch=REF(0xf88e4c0)') called at lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 1302
MusicBrainz::Server::Wizard::ReleaseEditor::_create_edit('MusicBrainz::Server::Wizard::ReleaseEditor::Add=HASH(0xc2bc688)', 'CODE(0xf86f080)', 51, 232267, 'privileges', 57, 'format_id', 1, 'position', ...) called at lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 1267
MusicBrainz::Server::Wizard::ReleaseEditor::_submit_edit('MusicBrainz::Server::Wizard::ReleaseEditor::Add=HASH(0xc2bc688)', 51, 'http://www.audionetwork.com/production-music/cd/ANW-1803-quir...', 'format_id', 1, 'position', 1, 'release', 'MusicBrainz::Server::Entity::Release=HASH(0xf87c008)', ...) called at lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 848
MusicBrainz::Server::Wizard::ReleaseEditor::_ANON_(51, 'http://www.audionetwork.com/production-music/cd/ANW-1803-quir...', 'format_id', 1, 'position', 1, 'release', 'MusicBrainz::Server::Entity::Release=HASH(0xf87c008)', 'tracklist', ...) called at lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 1186
MusicBrainz::Server::Wizard::ReleaseEditor::_edit_release_track_edits('MusicBrainz::Server::Wizard::ReleaseEditor::Add=HASH(0xc2bc688)', 'edit_note', 'http://www.audionetwork.com/production-music/cd/ANW-1803-quir...', 'data', 'HASH(0xd12c6c0)', 'create_edit', 'CODE(0xd079cf8)', 'previewing', '', ...) called at lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 947
MusicBrainz::Server::Wizard::ReleaseEditor::create_common_edits('MusicBrainz::Server::Wizard::ReleaseEditor::Add=HASH(0xc2bc688)', 'edit_note', 'http://www.audionetwork.com/production-music/cd/ANW-1803-quir...', 'data', 'HASH(0xd12c6c0)', 'create_edit', 'CODE(0xd079cf8)', 'previewing', '', ...) called at lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 925
MusicBrainz::Server::Wizard::ReleaseEditor::create_edits('MusicBrainz::Server::Wizard::ReleaseEditor::Add=HASH(0xc2bc688)', 'data', 'HASH(0xd12c6c0)', 'create_edit', 'CODE(0xd079cf8)', 'edit_note', 'http://www.audionetwork.com/production-music/cd/ANW-1803-quir...', 'previewing', '', ...) called at local/lib/perl5/x86_64-linux-gnu-thread-multi/Moose/Meta/Method/Augmented.pm line 48
MusicBrainz::Server::Wizard::ReleaseEditor::Add::create_edits('MusicBrainz::Server::Wizard::ReleaseEditor::Add=HASH(0xc2bc688)', 'data', 'HASH(0xd12c6c0)', 'create_edit', 'CODE(0xd079cf8)', 'edit_note', 'http://www.audionetwork.com/production-music/cd/ANW-1803-quir...', 'previewing', '', ...) called at local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 56
Class::MOP::Method::Wrapped::_ANON_('MusicBrainz::Server::Wizard::ReleaseEditor::Add=HASH(0xc2bc688)', 'data', 'HASH(0xd12c6c0)', 'create_edit', 'CODE(0xd079cf8)', 'edit_note', 'http://www.audionetwork.com/production-music/cd/ANW-1803-quir...', 'previewing', '', ...) called at local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 91
MusicBrainz::Server::Wizard::ReleaseEditor::Add::create_edits('MusicBrainz::Server::Wizard::ReleaseEditor::Add=HASH(0xc2bc688)', 'data', 'HASH(0xd12c6c0)', 'create_edit', 'CODE(0xd079cf8)', 'edit_note', 'http://www.audionetwork.com/production-music/cd/ANW-1803-quir...', 'previewing', '', ...) called at lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 849
MusicBrainz::Server::Wizard::ReleaseEditor::prepare_edits('MusicBrainz::Server::Wizard::ReleaseEditor::Add=HASH(0xc2bc688)') called at lib/MusicBrainz/Server/Wizard/ReleaseEditor.pm line 94
MusicBrainz::Server::Wizard::ReleaseEditor::run('MusicBrainz::Server::Wizard::ReleaseEditor::Add=HASH(0xc2bc688)') called at lib/MusicBrainz/Server/Controller/ReleaseEditor/Add.pm line 23
MusicBrainz::Server::Controller::ReleaseEditor::Add::add('MusicBrainz::Server::Controller::ReleaseEditor::Add=HASH(0xbc...', 'MusicBrainz::Server=HASH(0xc286a80)') called at local/lib/perl5/Catalyst/Action.pm line 65
Catalyst::Action::execute('Catalyst::Action=HASH(0xbfa0fe8)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add=HASH(0xbc...', 'MusicBrainz::Server=HASH(0xc286a80)') called at local/lib/perl5/Catalyst.pm line 1667
eval {...}
called at local/lib/perl5/Catalyst.pm line 1667
Catalyst::execute('MusicBrainz::Server=HASH(0xc286a80)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add', 'Catalyst::Action=HASH(0xbfa0fe8)') called at local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xc286a80)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add', 'Catalyst::Action=HASH(0xbfa0fe8)') called at lib/MusicBrainz/Server.pm line 322
MusicBrainz::Server::execute('MusicBrainz::Server=HASH(0xc286a80)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add', 'Catalyst::Action=HASH(0xbfa0fe8)') called at local/lib/perl5/Catalyst/Action.pm line 60
Catalyst::Action::dispatch('Catalyst::Action=HASH(0xbfa0fe8)', 'MusicBrainz::Server=HASH(0xc286a80)') called at local/lib/perl5/Catalyst/Controller.pm line 125
Catalyst::Controller::_ACTION('MusicBrainz::Server::Controller::ReleaseEditor::Add=HASH(0xbc...', 'MusicBrainz::Server=HASH(0xc286a80)') called at local/lib/perl5/Catalyst/Action.pm line 65
Catalyst::Action::execute('Catalyst::Action=HASH(0xbe52e08)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add=HASH(0xbc...', 'MusicBrainz::Server=HASH(0xc286a80)') called at local/lib/perl5/Catalyst.pm line 1667
eval
Catalyst::execute('MusicBrainz::Server=HASH(0xc286a80)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add', 'Catalyst::Action=HASH(0xbe52e08)') called at local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xc286a80)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add', 'Catalyst::Action=HASH(0xbe52e08)') called at lib/MusicBrainz/Server.pm line 322
MusicBrainz::Server::execute('MusicBrainz::Server=HASH(0xc286a80)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add', 'Catalyst::Action=HASH(0xbe52e08)') called at local/lib/perl5/Catalyst/Action.pm line 60
Catalyst::Action::dispatch('Catalyst::Action=HASH(0xbe52e08)', 'MusicBrainz::Server=HASH(0xc286a80)') called at local/lib/perl5/Catalyst/Dispatcher.pm line 257
Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x38d1fc0)', 'forward', 'MusicBrainz::Server=HASH(0xc286a80)', '_ACTION') called at local/lib/perl5/Catalyst/Dispatcher.pm line 237
Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x38d1fc0)', 'MusicBrainz::Server=HASH(0xc286a80)', '_ACTION') called at local/lib/perl5/Catalyst.pm line 342
Catalyst::forward('MusicBrainz::Server=HASH(0xc286a80)', '_ACTION') called at local/lib/perl5/Catalyst/Controller.pm line 99
Catalyst::Controller::_DISPATCH('MusicBrainz::Server::Controller::ReleaseEditor::Add=HASH(0xbc...', 'MusicBrainz::Server=HASH(0xc286a80)') called at local/lib/perl5/Catalyst/Action.pm line 65
Catalyst::Action::execute('Catalyst::Action=HASH(0xbfa1150)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add=HASH(0xbc...', 'MusicBrainz::Server=HASH(0xc286a80)') called at local/lib/perl5/Catalyst.pm line 1667
eval {...}
called at local/lib/perl5/Catalyst.pm line 1667
Catalyst::execute('MusicBrainz::Server=HASH(0xc286a80)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add', 'Catalyst::Action=HASH(0xbfa1150)') called at local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xc286a80)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add', 'Catalyst::Action=HASH(0xbfa1150)') called at lib/MusicBrainz/Server.pm line 322
MusicBrainz::Server::execute('MusicBrainz::Server=HASH(0xc286a80)', 'MusicBrainz::Server::Controller::ReleaseEditor::Add', 'Catalyst::Action=HASH(0xbfa1150)') called at local/lib/perl5/Catalyst/Action.pm line 60
Catalyst::Action::dispatch('Catalyst::Action=HASH(0xbfa1150)', 'MusicBrainz::Server=HASH(0xc286a80)') called at local/lib/perl5/Catalyst/Dispatcher.pm line 257
Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x38d1fc0)', 'forward', 'MusicBrainz::Server=HASH(0xc286a80)', '/release_editor/_DISPATCH') called at local/lib/perl5/Catalyst/Dispatcher.pm line 237
Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x38d1fc0)', 'MusicBrainz::Server=HASH(0xc286a80)', '/release_editor/_DISPATCH') called at local/lib/perl5/Catalyst.pm line 342
Catalyst::forward('MusicBrainz::Server=HASH(0xc286a80)', '/release_editor/_DISPATCH') called at local/lib/perl5/Catalyst/Dispatcher.pm line 105
Catalyst::Dispatcher::dispatch('Catalyst::Dispatcher=HASH(0x38d1fc0)', 'MusicBrainz::Server=HASH(0xc286a80)') called at local/lib/perl5/Catalyst.pm line 1613
Catalyst::dispatch('MusicBrainz::Server=HASH(0xc286a80)') called at lib/MusicBrainz/Server.pm line 286
Class::MOP::Class:::around('CODE(0x2d11bd8)', 'MusicBrainz::Server=HASH(0xc286a80)') 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(0xc286a80)') called at local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 91
MusicBrainz::Server::dispatch('MusicBrainz::Server=HASH(0xc286a80)') called at local/lib/perl5/Catalyst.pm line 1963
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(0xc245e78)', 'Try::Tiny::Catch=REF(0xc3278b8)') called at local/lib/perl5/Catalyst.pm line 1969
Catalyst::handle_request('MusicBrainz::Server', 'env', 'HASH(0xc21cf80)') called at lib/Catalyst/Plugin/AutoRestart.pm line 119
Catalyst::Plugin::AutoRestart::handle_request('MusicBrainz::Server', 'env', 'HASH(0xc21cf80)') called at local/lib/perl5/Catalyst/Engine.pm line 856
Catalyst::Engine::_ANON_('CODE(0xc245c08)') called at local/lib/perl5/Plack/Handler/FCGI.pm line 134
Plack::Handler::FCGI::run('Plack::Handler::FCGI=HASH(0x11b0a30)', 'CODE(0xc1aeaa0)') called at local/lib/perl5/Plack/Loader.pm line 88
Plack::Loader::run('Plack::Loader=HASH(0x1179e00)', 'Plack::Handler::FCGI=HASH(0x11b0a30)') called at local/lib/perl5/Plack/Runner.pm line 263
Plack::Runner::run('Plack::Runner=HASH(0xf7c808)') called at local/bin/plackup line 10"
Stack trace:
line 1301 MusicBrainz::Server::Wizard::ReleaseEditor
line 1302 MusicBrainz::Server::Wizard::ReleaseEditor
line 1267 MusicBrainz::Server::Wizard::ReleaseEditor
line 848 MusicBrainz::Server::Wizard::ReleaseEditor
line 1186 MusicBrainz::Server::Wizard::ReleaseEditor
line 947 MusicBrainz::Server::Wizard::ReleaseEditor
line 925 MusicBrainz::Server::Wizard::ReleaseEditor
line 849 MusicBrainz::Server::Wizard::ReleaseEditor
line 94 MusicBrainz::Server::Wizard::ReleaseEditor
line 23 MusicBrainz::Server::Controller::ReleaseEditor::Add
line 322 MusicBrainz::Server
line 322 MusicBrainz::Server
line 322 MusicBrainz::Server
line 286 MusicBrainz::Server
Request data:
$VAR1 = {
'query_parameters' => {},
'body_parameters' =>
};