Issue Details (XML | Word | Printable)

Key: MBS-5466
Type: Bug Bug
Status: Closed Closed
Resolution: Duplicate
Priority: Normal Normal
Assignee: Unassigned
Reporter: Matt Howe
Votes: 0
Watchers: 0
Operations

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

null value in column "comment" violates not-null constraint at lib/Sql.pm line 107

Created: 16/Oct/12 09:41 PM   Updated: 16/Oct/12 09:52 PM   Resolved: 16/Oct/12 09:52 PM
Component/s: Edit system
Affects Version/s: None
Fix Version/s: None

Environment: Android, Cyanogenmod, HP Touchpad
Issue Links:
Duplicate
 


 Description  « Hide

Error:

Caught exception in MusicBrainz::Server::Controller::Edit->approve "Failed query:
'UPDATE release SET comment = ?, name = ? WHERE id = ?'
( 933789 1197987)
DBD::Pg::st execute failed: ERROR: null value in column "comment" violates not-null constraint at lib/Sql.pm line 107.

at lib/Sql.pm line 113
Sql::_ANON_('DBD::Pg::st execute failed: ERROR: null value in column "com...') called at local/lib/perl5/Try/Tiny.pm line 100
Try::Tiny::try('CODE(0xcbb5418)', 'Try::Tiny::Catch=REF(0xcbaca68)') called at lib/Sql.pm line 114
Sql::do('Sql=HASH(0xc6944a0)', 'UPDATE release SET comment = ?, name = ? WHERE id = ?', undef, 933789, 1197987) called at lib/Sql.pm line 171
Sql::update_row('Sql=HASH(0xc6944a0)', 'release', 'HASH(0x5057340)', 'HASH(0xf5ae700)') called at lib/MusicBrainz/Server/Data/Release.pm line 554
MusicBrainz::Server::Data::Release::update('MusicBrainz::Server::Data::Release=HASH(0xb747740)', 1197987, 'HASH(0xcba85f8)') called at lib/MusicBrainz/Server/Edit/Generic/Edit.pm line 69
MusicBrainz::Server::Edit::Generic::Edit::_ANON_('MusicBrainz::Server::Edit::Release::Edit=HASH(0xf5ae430)') called at local/lib/perl5/x86_64-linux-gnu-thread-multi/Moose/Meta/Method/Overridden.pm line 38
MusicBrainz::Server::Edit::Generic::Edit::accept('MusicBrainz::Server::Edit::Release::Edit=HASH(0xf5ae430)') called at local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 50
Class::MOP::Method::Wrapped::_ANON_('MusicBrainz::Server::Edit::Release::Edit=HASH(0xf5ae430)') called at local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 91
MusicBrainz::Server::Edit::Release::Edit::accept('MusicBrainz::Server::Edit::Release::Edit=HASH(0xf5ae430)') called at lib/MusicBrainz/Server/Data/Edit.pm line 519
MusicBrainz::Server::Data::Edit::_ANON_() called at local/lib/perl5/Try/Tiny.pm line 71
eval {...} called at local/lib/perl5/Try/Tiny.pm line 67
Try::Tiny::try('CODE(0xf5aebc8)', 'Try::Tiny::Catch=REF(0xcbac810)') called at lib/MusicBrainz/Server/Data/Edit.pm line 545
MusicBrainz::Server::Data::Edit::_do_accept('MusicBrainz::Server::Data::Edit=HASH(0xaefa2e0)', 'MusicBrainz::Server::Edit::Release::Edit=HASH(0xf5ae430)') called at lib/MusicBrainz/Server/Data/Edit.pm line 584
MusicBrainz::Server::Data::Edit::_ANON_('MusicBrainz::Server::Edit::Release::Edit=HASH(0xf5ae430)') called at lib/MusicBrainz/Server/Data/Edit.pm line 607
MusicBrainz::Server::Data::Edit::_close('MusicBrainz::Server::Data::Edit=HASH(0xaefa2e0)', 'MusicBrainz::Server::Edit::Release::Edit=HASH(0xf5ae430)', 'CODE(0xf6ffd18)') called at lib/MusicBrainz/Server/Data/Edit.pm line 584
MusicBrainz::Server::Data::Edit::accept('MusicBrainz::Server::Data::Edit=HASH(0xaefa2e0)', 'MusicBrainz::Server::Edit::Release::Edit=HASH(0xf5ae430)') called at lib/MusicBrainz/Server/Data/Edit.pm line 510
MusicBrainz::Server::Data::Edit::_ANON_() called at lib/Sql.pm line 281
Sql::_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(0xce8e688)', 'Try::Tiny::Catch=REF(0xf6ffa00)') called at lib/Sql.pm line 294
Sql::_auto_transaction('CODE(0xd051088)', 'Sql=HASH(0xc6944a0)') called at lib/Sql.pm line 299
Sql::_run_in_transaction_one('CODE(0xd051088)', 'Sql=HASH(0xc6944a0)') called at lib/Sql.pm line 313
Sql::run_in_transaction('CODE(0xd051088)', 'Sql=HASH(0xc6944a0)') called at lib/MusicBrainz/Server/Data/Edit.pm line 511
MusicBrainz::Server::Data::Edit::approve('MusicBrainz::Server::Data::Edit=HASH(0xaefa2e0)', 'MusicBrainz::Server::Edit::Release::Edit=HASH(0xf6ff8e0)', 81629) called at lib/MusicBrainz/Server/Controller/Edit.pm line 112
MusicBrainz::Server::Controller::Edit::approve('MusicBrainz::Server::Controller::Edit=HASH(0xbfed228)', 'MusicBrainz::Server=HASH(0xc7d24c0)') called at local/lib/perl5/Catalyst/Action.pm line 65
Catalyst::Action::execute('Catalyst::Action=HASH(0xc32f2c0)', 'MusicBrainz::Server::Controller::Edit=HASH(0xbfed228)', 'MusicBrainz::Server=HASH(0xc7d24c0)') called at local/lib/perl5/Catalyst.pm line 1667
eval {...} called at local/lib/perl5/Catalyst.pm line 1667
Catalyst::execute('MusicBrainz::Server=HASH(0xc7d24c0)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xc32f2c0)') called at local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xc7d24c0)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xc32f2c0)') called at lib/MusicBrainz/Server.pm line 322
MusicBrainz::Server::execute('MusicBrainz::Server=HASH(0xc7d24c0)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xc32f2c0)') called at local/lib/perl5/Catalyst/Action.pm line 60
Catalyst::Action::dispatch('Catalyst::Action=HASH(0xc32f2c0)', 'MusicBrainz::Server=HASH(0xc7d24c0)') called at local/lib/perl5/Catalyst/ActionChain.pm line 38
Catalyst::ActionChain::dispatch('Catalyst::ActionChain=HASH(0xc936da0)', 'MusicBrainz::Server=HASH(0xc7d24c0)') called at local/lib/perl5/Catalyst/Controller.pm line 125
Catalyst::Controller::_ACTION('MusicBrainz::Server::Controller::Edit=HASH(0xbfed228)', 'MusicBrainz::Server=HASH(0xc7d24c0)') called at local/lib/perl5/Catalyst/Action.pm line 65
Catalyst::Action::execute('Catalyst::Action=HASH(0xc32ed20)', 'MusicBrainz::Server::Controller::Edit=HASH(0xbfed228)', 'MusicBrainz::Server=HASH(0xc7d24c0)') called at local/lib/perl5/Catalyst.pm line 1667
eval {...} called at local/lib/perl5/Catalyst.pm line 1667
Catalyst::execute('MusicBrainz::Server=HASH(0xc7d24c0)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xc32ed20)') called at local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xc7d24c0)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xc32ed20)') called at lib/MusicBrainz/Server.pm line 322
MusicBrainz::Server::execute('MusicBrainz::Server=HASH(0xc7d24c0)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xc32ed20)') called at local/lib/perl5/Catalyst/Action.pm line 60
Catalyst::Action::dispatch('Catalyst::Action=HASH(0xc32ed20)', 'MusicBrainz::Server=HASH(0xc7d24c0)') called at local/lib/perl5/Catalyst/Dispatcher.pm line 257
Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x36c6308)', 'forward', 'MusicBrainz::Server=HASH(0xc7d24c0)', '_ACTION') called at local/lib/perl5/Catalyst/Dispatcher.pm line 237
Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x36c6308)', 'MusicBrainz::Server=HASH(0xc7d24c0)', '_ACTION') called at local/lib/perl5/Catalyst.pm line 342
Catalyst::forward('MusicBrainz::Server=HASH(0xc7d24c0)', '_ACTION') called at local/lib/perl5/Catalyst/Controller.pm line 99
Catalyst::Controller::_DISPATCH('MusicBrainz::Server::Controller::Edit=HASH(0xbfed228)', 'MusicBrainz::Server=HASH(0xc7d24c0)') called at local/lib/perl5/Catalyst/Action.pm line 65
Catalyst::Action::execute('Catalyst::Action=HASH(0xc32e900)', 'MusicBrainz::Server::Controller::Edit=HASH(0xbfed228)', 'MusicBrainz::Server=HASH(0xc7d24c0)') called at local/lib/perl5/Catalyst.pm line 1667
eval {...} called at local/lib/perl5/Catalyst.pm line 1667
Catalyst::execute('MusicBrainz::Server=HASH(0xc7d24c0)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xc32e900)') called at local/lib/perl5/Catalyst/Plugin/StackTrace.pm line 94
Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xc7d24c0)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xc32e900)') called at lib/MusicBrainz/Server.pm line 322
MusicBrainz::Server::execute('MusicBrainz::Server=HASH(0xc7d24c0)', 'MusicBrainz::Server::Controller::Edit', 'Catalyst::Action=HASH(0xc32e900)') called at local/lib/perl5/Catalyst/Action.pm line 60
Catalyst::Action::dispatch('Catalyst::Action=HASH(0xc32e900)', 'MusicBrainz::Server=HASH(0xc7d24c0)') called at local/lib/perl5/Catalyst/Dispatcher.pm line 257
Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x36c6308)', 'forward', 'MusicBrainz::Server=HASH(0xc7d24c0)', '/edit/_DISPATCH') called at local/lib/perl5/Catalyst/Dispatcher.pm line 237
Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x36c6308)', 'MusicBrainz::Server=HASH(0xc7d24c0)', '/edit/_DISPATCH') called at local/lib/perl5/Catalyst.pm line 342
Catalyst::forward('MusicBrainz::Server=HASH(0xc7d24c0)', '/edit/_DISPATCH') called at local/lib/perl5/Catalyst/Dispatcher.pm line 105
Catalyst::Dispatcher::dispatch('Catalyst::Dispatcher=HASH(0x36c6308)', 'MusicBrainz::Server=HASH(0xc7d24c0)') called at local/lib/perl5/Catalyst.pm line 1613
Catalyst::dispatch('MusicBrainz::Server=HASH(0xc7d24c0)') called at lib/MusicBrainz/Server.pm line 286
Class::MOP::Class:::around('CODE(0x2fc9098)', 'MusicBrainz::Server=HASH(0xc7d24c0)') 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(0xc7d24c0)') called at local/lib/perl5/x86_64-linux-gnu-thread-multi/Class/MOP/Method/Wrapped.pm line 91
MusicBrainz::Server::dispatch('MusicBrainz::Server=HASH(0xc7d24c0)') 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(0xc5c0730)', 'Try::Tiny::Catch=REF(0xc6e8b50)') called at local/lib/perl5/Catalyst.pm line 1969
Catalyst::handle_request('MusicBrainz::Server', 'env', 'HASH(0xc63e4a8)') called at lib/Catalyst/Plugin/AutoRestart.pm line 119
Catalyst::Plugin::AutoRestart::handle_request('MusicBrainz::Server', 'env', 'HASH(0xc63e4a8)') called at local/lib/perl5/Catalyst/Engine.pm line 856
Catalyst::Engine::_ANON_('CODE(0xc5ff1d0)') called at local/lib/perl5/Plack/Handler/FCGI.pm line 134
Plack::Handler::FCGI::run('Plack::Handler::FCGI=HASH(0x1465a30)', 'CODE(0xc59ec50)') called at local/lib/perl5/Plack/Loader.pm line 88
Plack::Loader::run('Plack::Loader=HASH(0x142ee00)', 'Plack::Handler::FCGI=HASH(0x1465a30)') called at local/lib/perl5/Plack/Runner.pm line 263
Plack::Runner::run('Plack::Runner=HASH(0x1231808)') called at local/bin/plackup line 10
at lib/Sql.pm line 294"
Stack trace:
line 511 MusicBrainz::Server::Data::Edit
line 112 MusicBrainz::Server::Controller::Edit
line 322 MusicBrainz::Server
line 322 MusicBrainz::Server
line 322 MusicBrainz::Server
line 286 MusicBrainz::Server
Request data:

$VAR1 = {
'query_parameters' => { 'url' => 'http://musicbrainz.org/release-group/7c465f88-bf0b-4e79-8e01-d3d1c880c0d6/edits' },
'body_parameters' => {}
};

URL: http://musicbrainz.org/edit/19331771/approve?url=http%3A%2F%2Fmusicbrainz.org%2Frelease-group%2F7c465f88-bf0b-4e79-8e01-d3d1c880c0d6%2Fedits



Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.