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

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

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Normal Normal
    • None
    • None
    • Edit system
    • None
    • Android, Cyanogenmod, HP Touchpad

      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

            Unassigned Unassigned
            mdhowe Matt Howe
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved:

                Version Package