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

App keeps DB connections open and doesn't reconnect upon DB restart.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: Schema change, 2012-01-12
    • Component/s: Admin
    • Labels:
      None

      Description

      If a DB restart happens without an App restart being done afterwards all the subsequent requests try to use the old connection resulting in connection errors.
      The only way to recover is through App restart.

      An example stack trace follows...

      Caught exception in MusicBrainz::Server::Controller::WS::2::Artist->load "Failed query:
      	'SELECT artist.id, artist.gid, name.name, sort_name.name AS sort_name, artist.type, artist.country, gender, artist.edits_pending, artist.ipi_code, begin_date_year, begin_date_month, begin_date_day, end_date_year, end_date_month, end_date_day, artist.comment, artist.last_updated FROM artist  JOIN artist_name name ON artist.name=name.id JOIN artist_name sort_name ON artist.sort_name=sort_name.id WHERE gid IN (?)'
      	(89ad4ac3-39f7-470e-963a-56509c546377)
      DBD::Pg::st execute failed: no connection to the server at /home/castrp03/mb_from_svn/script/../lib/Sql.pm line 80.
      
       at /home/castrp03/mb_from_svn/script/../lib/Sql.pm line 85
      	Sql::__ANON__('DBD::Pg::st execute failed: no connection to the server at /h...') called at /data/mb-perl/lib/site_perl/5.12.3/Try/Tiny.pm line 100
      	Try::Tiny::try('CODE(0xdac9a58)', 'Try::Tiny::Catch=REF(0x2ae7058da638)') called at /home/castrp03/mb_from_svn/script/../lib/Sql.pm line 87
      	Sql::select('Sql=HASH(0xd83b6f8)', 'SELECT artist.id, artist.gid, name.name, sort_name.name AS so...', '89ad4ac3-39f7-470e-963a-56509c546377') called at /home/castrp03/mb_from_svn/script/../lib/MusicBrainz/Server/Data/Entity.pm line 36
      	MusicBrainz::Server::Data::Entity::_get_by_keys('MusicBrainz::Server::Data::Artist=HASH(0xb887868)', 'gid', '89ad4ac3-39f7-470e-963a-56509c546377') called at /home/castrp03/mb_from_svn/script/../lib/MusicBrainz/Server/Data/Role/GetByGID.pm line 10
      	MusicBrainz::Server::Data::Role::GetByGID::get_by_gid('MusicBrainz::Server::Data::Artist=HASH(0xb887868)', '89ad4ac3-39f7-470e-963a-56509c546377') called at /home/castrp03/mb_from_svn/script/../lib/MusicBrainz/Server/Data/CoreEntity.pm line 49
      	Class::MOP::Class:::around(undef, undef, '89ad4ac3-39f7-470e-963a-56509c546377') called at /data/mb-perl/lib/site_perl/5.12.3/x86_64-linux-thread-multi/Class/MOP/Method/Wrapped.pm line 161
      	Class::MOP::Method::Wrapped::__ANON__('MusicBrainz::Server::Data::Artist=HASH(0xb887868)', '89ad4ac3-39f7-470e-963a-56509c546377') called at /data/mb-perl/lib/site_perl/5.12.3/x86_64-linux-thread-multi/Class/MOP/Method/Wrapped.pm line 91
      	MusicBrainz::Server::Data::CoreEntity::get_by_gid('MusicBrainz::Server::Data::Artist=HASH(0xb887868)', '89ad4ac3-39f7-470e-963a-56509c546377') called at /home/castrp03/mb_from_svn/script/../lib/MusicBrainz/Server/Data/Role/CoreEntityCache.pm line 47
      ......
      ......
      ......
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                acid2 Oliver Charles
                Reporter:
                pecastro Paulo Edgar Castro
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Packages

                  Version Package
                  Schema change, 2012-01-12