Print

Print


Hello,
I have installed the new JobTransformations at SLAC (cache 11.0.41.6) 
and gave the CSC production a shot. There is a new environment variable 
that needs to be set, for example
T_ATLASMYSQLSERVER=osgserv04.slac.stanford.edu
But I have encountered problems. Not necessarily related to our database 
replica since if I replace osgserv04.slac.stanford.edu with 
atlasdbdev.cern.ch I find similar problems (testing on an interactive 
machine). If I unset this environment variable csc.simul.trf works as 
expected. I emailed Alessandro di Salvo et al my findings, maybe more 
tomorrow.
-- Dieter

Dieter Best wrote:

> ... and Martin Woudstra et al, the people working on the new python 
> Job Transforms, plan to add the same functionality. Looks like this 
> feature is in the main stream now.
> -- Dieter
>
> -------- Original Message --------
> Subject:     Re: New JT service for local MySQL replicas
> Date:     Mon, 20 Mar 2006 17:14:35 +0100
> From:     Martin Woudstra <[log in to unmask]>
> To:     Alessandro De Salvo <[log in to unmask]>
> CC:     Davide Costanzo <[log in to unmask]>, Mireia Dosil i 
> Bonmatí <[log in to unmask]>, Andrea Di Simone <[log in to unmask]>, 
> Kaushik De <[log in to unmask]>, Dieter Best <[log in to unmask]>
> References:     <[log in to unmask]>
>
>
>
> Hi Alessandro,
>
> Can you tell me where I can find this new tool?
> I will then also add the same functionality to the python jobtransforms.
>
> Cheers,
> Martin
>
>
> Alessandro De Salvo wrote:
>
>> Dear all,
>> I've just introduced a new JT tool to allow to use the local MySQL
>> replicas. The new service is called "addLocalMySQLSupport" and will
>> appear from JobTransforms 11.0.41.6 in the production caches, as it will
>> be ready.
>> I've changed all your transformations (csc.*, ctb.*) in that cache to
>> add the new service, so you may want to take a look at them.
>> This service is very useful for sites like SLAC, where we need to use
>> local replicas to access the CondDB. In that case the execution agent
>> should only set the env variable T_ATLASMYSQLSERVER to the name of the
>> local server with the replica(s). If the variable is not set, the
>> service addLocalMySQLSupport does nothing.
>> I'm waiting a bit before creating the cache because I want to add some
>> other changes in there too, but I'll soon put it in production.
>> Cheers,
>>
>>     Alessandro
>>
>