-
Bug
-
Resolution: Fixed
-
Normal
-
None
-
None
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 ...... ...... ......
- resolves
-
MBS-4099 The server should give a good error message when it can't connect to the DB
- Closed