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
