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

When entering a CD stub there are no checks for field length

XMLWordPrintable

      Internal Server Error

      Oops, something went wrong!

      Error:

      Caught exception in MusicBrainz::Server::Controller::CDStub->add "DBD::Pg::st execute failed: ERROR: value too long for type character varying(255) at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 396.
      at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 410
      Sql::_ANON_('DBD::Pg::st execute failed: ERROR: value too long for type c...') called at /usr/local/share/perl/5.10.1/Try/Tiny.pm line 100
      Try::Tiny::try('CODE(0xc77c5d0)', 'Try::Tiny::Catch=REF(0xc779f50)') called at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 411
      Sql::_select_list('Sql=HASH(0xa67f670)', 'INSERT INTO release_raw (artist,comment,lookup_count,barcode,...', 'ARRAY(0xc688de0)', 'arrayref', 'CODE(0x558ab78)') called at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 430
      Sql::select_list_of_lists('Sql=HASH(0xa67f670)', 'INSERT INTO release_raw (artist,comment,lookup_count,barcode,...', undef, 'The CD\'s cover says it is by "Albert Lee & Hogan\'s Heroes"....', 8, undef, 'Tear It Up') called at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 364
      Sql::select_single_column_array('Sql=HASH(0xa67f670)', 'INSERT INTO release_raw (artist,comment,lookup_count,barcode,...', undef, 'The CD\'s cover says it is by "Albert Lee & Hogan\'s Heroes"....', 8, undef, 'Tear It Up') called at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 379
      Sql::select_single_value('Sql=HASH(0xa67f670)', 'INSERT INTO release_raw (artist,comment,lookup_count,barcode,...', undef, 'The CD\'s cover says it is by "Albert Lee & Hogan\'s Heroes"....', 8, undef, 'Tear It Up') called at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 146
      Sql::insert_row('Sql=HASH(0xa67f670)', 'release_raw', 'HASH(0xc779cc8)', 'id') called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Data/CDStub.pm line 153
      MusicBrainz::Server::Data::CDStub::_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(0xc766f98)', 'Try::Tiny::Catch=REF(0xc709328)') called at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 277
      Sql::_auto_transaction('CODE(0xc779920)', 'Sql=HASH(0xa67f670)') called at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 282
      Sql::_run_in_transaction_one('CODE(0xc779920)', 'Sql=HASH(0xa67f670)') called at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 296
      Sql::run_in_transaction('CODE(0xc779920)', 'Sql=HASH(0xa67f670)') called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Data/CDStub.pm line 179
      MusicBrainz::Server::Data::CDStub::insert('MusicBrainz::Server::Data::CDStub=HASH(0x8cf3a80)', 'HASH(0xc7670e8)') called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server/Controller/CDStub.pm line 77
      MusicBrainz::Server::Controller::CDStub::add('MusicBrainz::Server::Controller::CDStub=HASH(0xa0b0b40)', 'MusicBrainz::Server=HASH(0xc331830)') called at /usr/local/share/perl/5.10.1/Catalyst/Action.pm line 65
      Catalyst::Action::execute('Catalyst::Action=HASH(0xa4dc560)', 'MusicBrainz::Server::Controller::CDStub=HASH(0xa0b0b40)', 'MusicBrainz::Server=HASH(0xc331830)') 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(0xc331830)', 'MusicBrainz::Server::Controller::CDStub', 'Catalyst::Action=HASH(0xa4dc560)') called at /usr/local/share/perl/5.10.1/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xc331830)', 'MusicBrainz::Server::Controller::CDStub', 'Catalyst::Action=HASH(0xa4dc560)') called at /usr/local/share/perl/5.10.1/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch('Catalyst::Action=HASH(0xa4dc560)', 'MusicBrainz::Server=HASH(0xc331830)') called at /usr/local/share/perl/5.10.1/Catalyst/Controller.pm line 110
      Catalyst::Controller::_ACTION('MusicBrainz::Server::Controller::CDStub=HASH(0xa0b0b40)', 'MusicBrainz::Server=HASH(0xc331830)') called at /usr/local/share/perl/5.10.1/Catalyst/Action.pm line 65
      Catalyst::Action::execute('Catalyst::Action=HASH(0xa4e1830)', 'MusicBrainz::Server::Controller::CDStub=HASH(0xa0b0b40)', 'MusicBrainz::Server=HASH(0xc331830)') 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(0xc331830)', 'MusicBrainz::Server::Controller::CDStub', 'Catalyst::Action=HASH(0xa4e1830)') called at /usr/local/share/perl/5.10.1/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xc331830)', 'MusicBrainz::Server::Controller::CDStub', 'Catalyst::Action=HASH(0xa4e1830)') called at /usr/local/share/perl/5.10.1/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch('Catalyst::Action=HASH(0xa4e1830)', 'MusicBrainz::Server=HASH(0xc331830)') called at /usr/local/share/perl/5.10.1/Catalyst/Dispatcher.pm line 257
      Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x29a9b90)', 'forward', 'MusicBrainz::Server=HASH(0xc331830)', '_ACTION') called at /usr/local/share/perl/5.10.1/Catalyst/Dispatcher.pm line 237
      Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x29a9b90)', 'MusicBrainz::Server=HASH(0xc331830)', '_ACTION') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 377
      Catalyst::forward('MusicBrainz::Server=HASH(0xc331830)', '_ACTION') called at /usr/local/share/perl/5.10.1/Catalyst/Controller.pm line 84
      Catalyst::Controller::_DISPATCH('MusicBrainz::Server::Controller::CDStub=HASH(0xa0b0b40)', 'MusicBrainz::Server=HASH(0xc331830)') called at /usr/local/share/perl/5.10.1/Catalyst/Action.pm line 65
      Catalyst::Action::execute('Catalyst::Action=HASH(0xa4dbfd8)', 'MusicBrainz::Server::Controller::CDStub=HASH(0xa0b0b40)', 'MusicBrainz::Server=HASH(0xc331830)') 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(0xc331830)', 'MusicBrainz::Server::Controller::CDStub', 'Catalyst::Action=HASH(0xa4dbfd8)') called at /usr/local/share/perl/5.10.1/Catalyst/Plugin/StackTrace.pm line 94
      Catalyst::Plugin::StackTrace::execute('MusicBrainz::Server=HASH(0xc331830)', 'MusicBrainz::Server::Controller::CDStub', 'Catalyst::Action=HASH(0xa4dbfd8)') called at /usr/local/share/perl/5.10.1/Catalyst/Action.pm line 60
      Catalyst::Action::dispatch('Catalyst::Action=HASH(0xa4dbfd8)', 'MusicBrainz::Server=HASH(0xc331830)') called at /usr/local/share/perl/5.10.1/Catalyst/Dispatcher.pm line 257
      Catalyst::Dispatcher::_do_forward('Catalyst::Dispatcher=HASH(0x29a9b90)', 'forward', 'MusicBrainz::Server=HASH(0xc331830)', '/cdstub/_DISPATCH') called at /usr/local/share/perl/5.10.1/Catalyst/Dispatcher.pm line 237
      Catalyst::Dispatcher::forward('Catalyst::Dispatcher=HASH(0x29a9b90)', 'MusicBrainz::Server=HASH(0xc331830)', '/cdstub/_DISPATCH') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 377
      Catalyst::forward('MusicBrainz::Server=HASH(0xc331830)', '/cdstub/_DISPATCH') called at /usr/local/share/perl/5.10.1/Catalyst/Dispatcher.pm line 105
      Catalyst::Dispatcher::dispatch('Catalyst::Dispatcher=HASH(0x29a9b90)', 'MusicBrainz::Server=HASH(0xc331830)') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 1611
      Catalyst::dispatch('MusicBrainz::Server=HASH(0xc331830)') called at /usr/local/share/perl/5.10.1/Catalyst/Plugin/Static/Simple.pm line 76
      Class::MOP::Class:::around('CODE(0x3009340)', 'MusicBrainz::Server=HASH(0xc331830)') called at /usr/local/lib/perl/5.10.1/Class/MOP/Method/Wrapped.pm line 159
      Class::MOP::Method::Wrapped::_ANON_('MusicBrainz::Server=HASH(0xc331830)') called at /home/musicbrainz/musicbrainz-server/script/../lib/MusicBrainz/Server.pm line 258
      Class::MOP::Class:::around('CODE(0xa618b10)', 'MusicBrainz::Server=HASH(0xc331830)') called at /usr/local/lib/perl/5.10.1/Class/MOP/Method/Wrapped.pm line 159
      Class::MOP::Method::Wrapped::_ANON_('MusicBrainz::Server=HASH(0xc331830)') called at /usr/local/lib/perl/5.10.1/Class/MOP/Method/Wrapped.pm line 89
      MusicBrainz::Server::dispatch('MusicBrainz::Server=HASH(0xc331830)') 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(0x3d61fd0)') called at /home/musicbrainz/musicbrainz-server/script/../lib/Catalyst/Plugin/AutoRestart.pm line 119
      Catalyst::Plugin::AutoRestart::handle_request('MusicBrainz::Server', 'env', 'HASH(0x3d61fd0)') called at /usr/local/share/perl/5.10.1/Catalyst/Engine/FastCGI.pm line 149
      Catalyst::Engine::FastCGI::run('Catalyst::Engine::FastCGI=HASH(0x3d2c3f0)', 'MusicBrainz::Server', '127.0.0.1:55901', 'HASH(0x1896d48)') called at /usr/local/share/perl/5.10.1/Catalyst.pm line 2396
      Catalyst::run('MusicBrainz::Server', '127.0.0.1:55901', 'HASH(0x1896d48)') called at ./script/musicbrainz_fastcgi.pl line 28
      at /home/musicbrainz/musicbrainz-server/script/../lib/Sql.pm line 277"

      Stack trace:

      • line 179 MusicBrainz::Server::Data::CDStub
      • line 77 MusicBrainz::Server::Controller::CDStub
      • line 258 MusicBrainz::Server

      Request data:

      $VAR1 = {
                'query_parameters' => {
                                        'toc' => '1 15 243525 150 19057 35302 46203 61465 72296 85417 101345 122939 138531 156170 180541 193095 219123 237176'
                                      },
                'body_parameters' => {
                                       'CDStub.title' => 'Tear It Up',
                                       'CDStub.tracks.14.artist' => 'Albert Lee & Hogan\'s Heroes',
                                       'CDStub.barcode' => '',
                                       'CDStub.tracks.8.title' => 'Gone Too Long',
                                       'CDStub.tracks.6.artist' => 'Albert Lee & Hogan\'s Heroes',
                                       'CDStub.tracks.0.title' => 'I\'m Ready',
                                       'CDStub.tracks.1.title' => 'Rock Around With Ollie Vee',
                                       'CDStub.tracks.13.artist' => 'Albert Lee & Hogan\'s Heroes',
                                       'CDStub.tracks.11.title' => 'SingingThe Blues',
                                       'CDStub.tracks.8.artist' => 'Albert Lee & Hogan\'s Heroes',
                                       'CDStub.tracks.12.title' => '\'Til I Gain Control Again',
                                       'CDStub.tracks.7.artist' => 'Albert Lee & Hogan\'s Heroes',
                                       'CDStub.tracks.11.artist' => 'Albert Lee & Hogan\'s Heroes',
                                       'CDStub.tracks.6.title' => 'Jitterbug Boogie',
                                       'CDStub.tracks.0.artist' => 'Albert Lee & Hogan\'s Heroes',
                                       'CDStub.tracks.14.title' => 'Down To The Wire',
                                       'CDStub.tracks.9.artist' => 'Albert Lee & Hogan\'s Heroes',
                                       'CDStub.tracks.3.title' => 'Back In The USA',
                                       'CDStub.tracks.5.title' => 'On The Rebound',
                                       'CDStub.tracks.3.artist' => 'Albert Lee & Hogan\'s Heroes',
                                       'CDStub.multiple_artists' => '1',
                                       'CDStub.tracks.5.artist' => 'Albert Lee & Hogan\'s Heroes',
                                       'CDStub.tracks.7.title' => 'If You See Me Getting Smaller',
                                       'CDStub.tracks.10.artist' => 'Albert Lee & Hogan\'s Heroes',
                                       'CDStub.tracks.10.title' => 'Country Comfort',
                                       'CDStub.tracks.2.title' => 'Take Your Time',
                                       'CDStub.tracks.4.title' => 'Last Date',
                                       'CDStub.tracks.9.title' => 'Luxury Liner',
                                       'CDStub.tracks.2.artist' => 'Albert Lee & Hogan\'s Heroes',
                                       'CDStub.comment' => 'The CD\'s cover says it is by "Albert Lee & Hogan\'s Heroes". No individual tracks are creditied to any particular artist(s). But it IS stated that the items were recorded at FIVE different studios. See [http://www.albertleeandhogansheroes.com/] and [http://en.wikipedia.org/wiki/Albert_Lee]',
                                       'CDStub.tracks.1.artist' => 'Albert Lee & Hogan\'s Heroes',
                                       'CDStub.tracks.13.title' => 'Tear It Up',
                                       'CDStub.tracks.12.artist' => 'Albert Lee & Hogan\'s Heroes',
                                       'CDStub.tracks.4.artist' => 'Albert Lee & Hogan\'s Heroes'
                                     }
              };
                  
      
      URL: http://musicbrainz.org/cdstub/add?toc=1+15+243525+150+19057+35302+46203+61465+72296+85417+101345+122939+138531+156170+180541+193095+219123+237176
      
      We're terribly sorry for this problem. Please wait a few minutes and repeat your request — the problem may go away.
      
      If the problem persists, please report a bug and include all of the information that is shown above.
      
      Please be sure to include the stack trace and request data shown above!
      

            acid2 Oliver Charles
            Anonymous Anonymous
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved:

                Version Package
                Bug fixes, 2011-08-22