[Labs-l] Cannot connect to DB

Tue Jan 27 19:53:39 UTC 2015

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 <nuria at wikimedia.org> 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://<****>. at labsdb1002.eqiad.wmnet/{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 <yuvipanda at gmail.com> wrote:
>
>> Yes they should!
>> On Jan 26, 2015 5:04 PM, "Nuria" <nuria at wikimedia.org> wrote:
>>
>>> Do these hosts also workfor the centralauth
>>> database?
>>>
>>>
>>>
>>> > On Jan 21, 2015, at 8:20 PM, Yuvi Panda <yuvipanda at gmail.com> 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
>>> > Labs-l at lists.wikimedia.org
>>> > https://lists.wikimedia.org/mailman/listinfo/labs-l
>>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.wikimedia.org/pipermail/labs-l/attachments/20150127/e368ecf9/attachment.html>