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

      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
      ......
      ......
      ......
      

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

              Created:
              Updated:
              Resolved:

                Version Package
                Schema change, 2012-01-12