Understood, thanks for the prompt response. On Tue, Jan 27, 2015 at 11:55 AM, Yuvi Panda <[email protected]> wrote:
> Labs-wide restarts are happening today due to security issues, so > expect some instabilities as we work things through. > > On Tue, Jan 27, 2015 at 11:53 AM, Nuria Ruiz <[email protected]> wrote: > > Also we get "too many connections". > > > > Yuvi: (or anyone) what are appropriate settings for pool size for db > > connections for these hosts? > > > > Thanks again, > > > > Nuria > > > > On Tue, Jan 27, 2015 at 11:21 AM, Nuria Ruiz <[email protected]> > wrote: > >> > >> Seems like something is missing cause despite having changed the config > >> our wikimetrics1 instance is still throwing a bunch of errors like: > >> > >> > >> File > "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", > >> line 238, in _revalidate_connection > >> "Can't reconnect until invalid " > >> StatementError: Can't reconnect until invalid transaction is rolled back > >> (original cause: InvalidRequestError: Can't reconnect until invalid > >> transaction is rolled back) u'SELECT user.user_id AS user_u > >> > >> > >> Restating the instance fixes things but somehow it gets "blocked" again. > >> Is there something special about how these connections need to be > managed? > >> > >> > >> Config is set up as follows (user removed) > >> > >> SQL_ECHO : False > >> WIKIMETRICS_ENGINE_URL : > 'mysql://<******>@localhost/wikimetrics' > >> WIKIMETRICS_POOL_SIZE : 100 > >> MEDIAWIKI_ENGINE_URL_TEMPLATE : > >> 'mysql://<****>[email protected]/{0}_p' > >> MEDIAWIKI_POOL_SIZE : 200 > >> CENTRALAUTH_ENGINE_URL : > >> 'mysql://<*****>@labsdb1002.eqiad.wmnet/centralauth_p' > >> REPLICATION_LAG_MW_PROJECTS : [ 'enwiki', 'eowiki', 'elwiki', > >> 'commonswiki', 'dewiki', 'frwiki', 'eswiki' ] > >> REPLICATION_LAG_THRESHOLD : 3 # (measured in hours) > >> > >> > >> > >> > >> > >> > >> > >> > >> On Mon, Jan 26, 2015 at 5:09 PM, Yuvi Panda <[email protected]> > wrote: > >>> > >>> Yes they should! > >>> > >>> On Jan 26, 2015 5:04 PM, "Nuria" <[email protected]> wrote: > >>>> > >>>> Do these hosts also workfor the centralauth > >>>> database? > >>>> > >>>> > >>>> > >>>> > On Jan 21, 2015, at 8:20 PM, Yuvi Panda <[email protected]> > wrote: > >>>> > > >>>> > the DNAT rules are no longer required. Just connect directly to one > of > >>>> > labsdb1001.eqiad.wmnet, labsdb1002.eqiad.wmnet, or > >>>> > labsdb1003.eqiad.wmnet. That should work. > >>>> > > >>>> > I tried this out on wikimetrics1 instance and that seems to work... > >>>> > -- > >>>> > Yuvi Panda T > >>>> > http://yuvi.in/blog > >>>> > > >>>> > _______________________________________________ > >>>> > Labs-l mailing list > >>>> > [email protected] > >>>> > https://lists.wikimedia.org/mailman/listinfo/labs-l > >> > >> > > > > > > -- > Yuvi Panda T > http://yuvi.in/blog >
_______________________________________________ Labs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/labs-l
