[Clas_offline] [G12] caldb mysql error during connection to server.

[Eugene Pasyuk]

We had similar situation a shrot while ago. caldb and all our wikies 
reside on the same mysql server.
It seems to be too many requests that mysql server cannot handle them.
One thing that may help a little, but not much, is moving wikies to the 
different server. There are far more requests to caldb than to the wikies.

-Eugene

Mukesh Saini wrote:
> Hi Johann,
> 
> I get a similar message while trying to access the wiki.
> 
> The page loaded after refreshing it a few times. This is the first time this error has occurred ever with me.
> -----------------------------------------------------------------------
> G12_wiki has a problem
> 
> Sorry! This site is experiencing technical difficulties.
> 
> Try waiting a few minutes and reloading.
> 
> (Can't contact the database server: Can't create a new thread (errno 11). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug (clasdb.jlab.org))
> ------------------------------------------------------------------------
> 
> 
> ----- Original Message -----
> From: "John T. Goetz" <jgoetz at ucla.edu>
> Date: Wednesday, August 19, 2009 5:06 am
> Subject: [G12] caldb mysql error during connection to server.
> To: clas_offline at jlab.org, helpdesk at jlab.org, weygand at jlab.org, g12 at jlab.org, sandy.philpott at jlab.org
> 
>> Hi,
>> has anyone seen this error during reconstruction? This is issued from
>> the caldb package:
>>
>> calib_connect: RunIndex_table = "calib_user.RunIndexg12"
>> calib_connect: using server=clasdb.jlab.org (default)
>> calib_connect: using latest constants
>> calib_connect: connecting as user=clasuser
>> calib_connect: connection error. Can't create a new thread (errno 
>> 11). If you are not out of available memory, you can consult the 
>> manual for
>> a possible OS-dependent bug
>> calib_get_int SQL_ERR: MySQL server has gone away
>> calib_get_int SQL_ERR: query error SELECT systemId FROM System WHERE
>> System.systemName='RUN_CONTROL'
>>
>> I'm not sure if its a memory problem or if the MySQL server is
>> overloaded. This just started at about 18:24 on Aug. 18th 2009. I get
>> this error from both the farm and when I run interactively. 
>> However, I
>> can keep running a1c over and over and eventually i can get it to
>> connect properly.
>>
>> -Johann.
>>
>> _______________________________________________
>> G12 mailing list
>> G12 at jlab.org
>> https://mailman.jlab.org/mailman/listinfo/g12
>>
> _______________________________________________
> G12 mailing list
> G12 at jlab.org
> https://mailman.jlab.org/mailman/listinfo/g12