> Hi,
> the problem is that 'sftests submit' uses this query! How to use sftests on 2.7?
For the moment you cannot. Yes, the QUERY syntax has changed , you have
to ommit the AS tag and there is some other problem with the merged
table search. But I think, Piotr is already working on an SFT for 2.7.0.
Gergo
>
> -----
> Antun Balaz
> Research Assistant
> E-mail: [log in to unmask]
> Web: http://scl.phy.bg.ac.yu/
>
> Phone: +381 11 3160260, Ext. 152
> Fax: +381 11 3162190
>
> Scientific Computing Laboratory
> Institute of Physics, Belgrade
> Serbia and Montenegro
> -----
>
> ---------- Original Message -----------
> From: Steve Fisher <[log in to unmask]>
> To: [log in to unmask]
> Sent: Wed, 15 Feb 2006 10:49:24 +0000
> Subject: Re: [LCG-ROLLOUT] sftests problem
>
> > On Wed, Feb 15, 2006 at 09:35:08AM +0100, Frederic Schaer wrote:
> > > Are you saying that R-GMA bundled with LCG 2.7 does not support the
> > > following query (I can not test yet..) ??
> > > rgma -c "SELECT s.siteID,hostname,sitename,region,inMaintenance from
> > > GocSite_v0_4 as s, GocNode_v0_4 as n where s.siteID=n.siteID and
> > > nodetype='CE' and s.status='Certified' and type='Production' and
> > > monitor='Y' and inMonitoring='Y' order by s.siteID"
> > >
> > > ?
> >
> > This is quite possible. In the LCG2.6 release we were not checking
> > SQL very much. We now parse everything, but it has shown up some problems
> > with the parser. In this case I suggest you avoid using the "AS"
> > construct.
> >
> > Steve
> >
> > >
> > > It did support it in LCG 2.6... are you sure you're using latest R-GMA
> > > package ? What's your $RGMA_HOME ?
> > > Cheers,
> > > Frederic
> >
> > >
> > > Antun Balaz wrote:
> > >
> > > >Hi,
> > > >why am I getting these errors when submitting SFT to my site? I am using
> > > >the
> > > >latest SFT source from CVS... Since I have earlier version of "GOC sites
> > > >map"
> > > >(before upgrade to LCG-2_7_0) in .sft2, test is successfully submitted
> > > >after
> > > >all and executed, but obviously this map is not up-to-date anymore.
> > > >
> > > >Thank, Antun
> > > >
> > > >
> > > >[antun@ce antun]$ sftests submit AEGIS01-PHY-SCL
> > > >Starting Grid Environment Tests:
> > > >Getting list of monitored sites from GOC DB via R-GMA
> > > >Getting Apel statistics for records not older than 2006-02-11 via R-GMA
> > > >ERROR: Invalid query: SELECT
> > > >s.siteID,hostname,sitename,region,inMaintenance fro
> > > >m GocSite_v0_4 as s, GocNode_v0_4 as n where s.siteID=n.siteID and
> > > >nodetype='CE'
> > > >and s.status='Certified' and type='Production' and monitor='Y' and
> > > >inMonitoring
> > > >='Y' order by s.siteID
> > > >Caused by: org.edg.info.sqlutil.parsql.ParseException:Encountered "as" at
> > > >line 1
> > > >, column 74.
> > > >Was expecting one of:
> > > > "FOR" ...
> > > > "GROUP" ...
> > > > "INTERSECT" ...
> > > > "MINUS" ...
> > > > "ORDER" ...
> > > > "UNION" ...
> > > > "WHERE" ...
> > > > <S_IDENTIFIER> ...
> > > > ";" ...
> > > > "," ...
> > > > "." ...
> > > > "NATURAL" ...
> > > > "INNER" ...
> > > > "LEFT" ...
> > > > "RIGHT" ...
> > > > "FULL" ...
> > > >
> > > >Could not download the new GOC sites map. Using old one if present...
> > > >
> > > >Results:
> > > >Found good central SE: lxn1183.cern.ch
> > > >Found good RB: gdrb03.cern.ch
> > > >
> > > >Finished Grid Environment Tests.
> > > >
> > > >Publishing environmet:
> > > >DONE
> > > >
> > > >Publishing tests definitions:
> > > >sft-apel: OK
> > > >Etc.
> > > >
> > > >-----
> > > >Antun Balaz
> > > >Research Assistant
> > > >E-mail: [log in to unmask]
> > > >Web: http://scl.phy.bg.ac.yu/
> > > >
> > > >Phone: +381 11 3160260, Ext. 152
> > > >Fax: +381 11 3162190
> > > >
> > > >Scientific Computing Laboratory
> > > >Institute of Physics, Belgrade
> > > >Serbia and Montenegro
> > > >-----
> > > >
> > > >
> > > >
> ------- End of Original Message -------
>
--
|