hi ,
now i have an output, before the awnswer was "program aborted" but now:
it seems it processing now but the count is = 0
[root@xg009 root]# /opt/glite/bin/apel-pbs-log-parser -f
/opt/glite/etc/glite-apel-pbs/parser-config-yaim.xml
Wed Aug 31 10:36:18 UTC 2005: apel-pbs-log-parser - Read-in configuration:
[quiet, c, e, recursiveEventFiles, g, recursiveGKFiles] [DBPassword=****,
site=GR-05-DEMOKRITOS, pbslog=/var/spool/pbs/server_priv/accounting,
GIIS=xg009.inp.demokritos.gr, CEhost=xg009.inp.demokritos.gr,
gklog=/var/log,
DBURL=jdbc:mysql://xg006.inp.demokritos.gr:3306/accounting,
DBUsername=accounting, mslog=/var/log, timeZone=UTC]
Wed Aug 31 10:36:18 UTC 2005: apel-pbs-log-parser - ------ Starting the
apel application ------
Wed Aug 31 10:36:18 UTC 2005: apel-pbs-log-parser - Finding CPU spec
values from GIIS server: xg009.inp.demokritos.gr
Wed Aug 31 10:36:18 UTC 2005: apel-pbs-log-parser - Cluster:
xg009.inp.demokritos.gr, Subcluster: xg009.inp.demokritos.gr, SpecInt2000:
990, SpecFloat2000: 990
Wed Aug 31 10:36:18 UTC 2005: apel-pbs-log-parser - Spec value remains
unchanged, no need to update it
Wed Aug 31 10:36:18 UTC 2005: apel-pbs-log-parser - Spec for catch-all
updated to specInt: 990 specFloat: 990
Wed Aug 31 10:36:18 UTC 2005: apel-pbs-log-parser - Number of entries
found for this cluster: 1
Wed Aug 31 10:36:18 UTC 2005: apel-pbs-log-parser - Reprocess disabled,
checking new event logs only
Wed Aug 31 10:36:18 UTC 2005: apel-pbs-log-parser - **** Updating PBS end
event table (EventRecords) ****
Wed Aug 31 10:36:18 UTC 2005: apel-pbs-log-parser - Ignoring already
processed event log file: 20050805
Wed Aug 31 10:36:18 UTC 2005: apel-pbs-log-parser - Ignoring already
processed event log file: 20050806
Wed Aug 31 10:36:18 UTC 2005: apel-pbs-log-parser - Ignoring already
processed event log file: 20050807
Wed Aug 31 10:36:18 UTC 2005: apel-pbs-log-parser - Ignoring already
processed event log file: 20050808
Wed Aug 31 10:36:18 UTC 2005: apel-pbs-log-parser - Ignoring already
processed event log file: 20050809
Wed Aug 31 10:36:18 UTC 2005: apel-pbs-log-parser - Ignoring already
processed event log file: 20050810
Wed Aug 31 10:36:18 UTC 2005: apel-pbs-log-parser - Ignoring already
processed event log file: 20050811
Wed Aug 31 10:36:18 UTC 2005: apel-pbs-log-parser - Ignoring already
processed event log file: 20050812
Wed Aug 31 10:36:18 UTC 2005: apel-pbs-log-parser - Ignoring already
processed event log file: 20050813
Wed Aug 31 10:36:18 UTC 2005: apel-pbs-log-parser - Ignoring already
processed event log file: 20050814
Wed Aug 31 10:36:18 UTC 2005: apel-pbs-log-parser - Ignoring already
processed event log file: 20050815
Wed Aug 31 10:36:18 UTC 2005: apel-pbs-log-parser - Ignoring already
processed event log file: 20050816
Wed Aug 31 10:36:18 UTC 2005: apel-pbs-log-parser - Ignoring already
processed event log file: 20050817
Wed Aug 31 10:36:18 UTC 2005: apel-pbs-log-parser - Ignoring already
processed event log file: 20050818
Wed Aug 31 10:36:18 UTC 2005: apel-pbs-log-parser - Ignoring already
processed event log file: 20050819
Wed Aug 31 10:36:18 UTC 2005: apel-pbs-log-parser - Ignoring already
processed event log file: 20050820
Wed Aug 31 10:36:18 UTC 2005: apel-pbs-log-parser - Ignoring already
processed event log file: 20050821
Wed Aug 31 10:36:18 UTC 2005: apel-pbs-log-parser - Ignoring already
processed event log file: 20050822
Wed Aug 31 10:36:18 UTC 2005: apel-pbs-log-parser - Ignoring already
processed event log file: 20050823
Wed Aug 31 10:36:18 UTC 2005: apel-pbs-log-parser - Ignoring already
processed event log file: 20050824
Wed Aug 31 10:36:18 UTC 2005: apel-pbs-log-parser - Ignoring already
processed event log file: 20050825
Wed Aug 31 10:36:19 UTC 2005: apel-pbs-log-parser - Ignoring already
processed event log file: 20050826
Wed Aug 31 10:36:19 UTC 2005: apel-pbs-log-parser - Ignoring already
processed event log file: 20050827
Wed Aug 31 10:36:19 UTC 2005: apel-pbs-log-parser - Ignoring already
processed event log file: 20050828
Wed Aug 31 10:36:19 UTC 2005: apel-pbs-log-parser - Ignoring already
processed event log file: 20050829
Wed Aug 31 10:36:19 UTC 2005: apel-pbs-log-parser - Ignoring already
processed event log file: 20050830
Wed Aug 31 10:36:19 UTC 2005: apel-pbs-log-parser - Processing
/var/spool/pbs/server_priv/accounting/20050831
Wed Aug 31 10:36:19 UTC 2005: apel-pbs-log-parser - Event records inserted: 0
Wed Aug 31 10:36:19 UTC 2005: apel-pbs-log-parser - **** Updating Gate
Keeper log table (GkRecords) ****
Wed Aug 31 10:36:19 UTC 2005: apel-pbs-log-parser - Processing gate keeper
log file: /var/log/globus-gatekeeper.log
Wed Aug 31 10:36:19 UTC 2005: apel-pbs-log-parser - Already processed GK
log file: globus-gatekeeper.log.20050821040205.1
Wed Aug 31 10:36:19 UTC 2005: apel-pbs-log-parser - Already processed GK
log file: globus-gatekeeper.log.20050807040204.0.gz
Wed Aug 31 10:36:19 UTC 2005: apel-pbs-log-parser - Already processed GK
log file: globus-gatekeeper.log.20050828040203.2
Wed Aug 31 10:36:19 UTC 2005: apel-pbs-log-parser - Already processed GK
log file: globus-gatekeeper.log.20050814040215.0.gz
Wed Aug 31 10:36:19 UTC 2005: apel-pbs-log-parser - Gk records inserted: 0
Wed Aug 31 10:36:19 UTC 2005: apel-pbs-log-parser - Msg records inserted: 0
Wed Aug 31 10:36:19 UTC 2005: apel-pbs-log-parser - **** Updating Job ID
table (MessageRecords) from system message log ****
Wed Aug 31 10:36:19 UTC 2005: apel-pbs-log-parser - Processing message log
file: /var/log/messages
Wed Aug 31 10:36:20 UTC 2005: apel-pbs-log-parser - Processing message log
file: /var/log/messages.1
Wed Aug 31 10:36:20 UTC 2005: apel-pbs-log-parser - Processing message log
file: /var/log/messages.2
Wed Aug 31 10:36:21 UTC 2005: apel-pbs-log-parser - Processing message log
file: /var/log/messages.3
Wed Aug 31 10:36:22 UTC 2005: apel-pbs-log-parser - Processing message log
file: /var/log/messages.4
Wed Aug 31 10:36:23 UTC 2005: apel-pbs-log-parser - Msg records inserted: 0
Wed Aug 31 10:36:23 UTC 2005: apel-pbs-log-parser - ------ Processing
finished ------
i run:
> Hi Xristos,
> what is the output of
>
> /opt/glite/bin/apel-pbs-log-parser -f
> /opt/glite/etc/glite-apel-pbs/parser-
> config-yaim.xml
>
> on your CE? Have you checked /var/log/apel.log on your CE and MON?
>
> Regards, Antun
>
> -----
> 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: Filippidis christos <[log in to unmask]>
> To: [log in to unmask]
> Sent: Wed, 31 Aug 2005 09:32:31 +0300
> Subject: Re: [LCG-ROLLOUT] RGMA - 0 count
>
>> hi,
>> i also have the same problem:
>> 2005-08-31 09:17:35
>> APEL Test
>> Checking if LcgRecords latest archiver is accessible:
>> + rgma -c 'select count(*) from LcgRecords'
>> + grep 'Rows in set'
>> + set +x
>> LcgRecords latest archiver is working.
>>
>> Checking if LcgRecords tuples are present for the site (max 1 day
>> old): ++ rgma -c 'select count(*) from LcgRecords where
>> ExecutingCE='\''xg009.inp.demokritos.gr'\'' and
>> MeasurementDate>='\''2005-08-30'\''' ++ grep '^|' ++ cut -f 2 -d ' '
>> ++ tail -n 1 + count=0 + set +x
>>
>> Count: 0
>> Empty Apel result set - FAILED!
>>
>> thanks
>> > Hi,
>> >
>> > I'm facing the following error here with rgma. Can anyone help?
>> >
>> >
>> > APEL Test
>> > Checking if LcgRecords latest archiver is accessible:
>> >
>> > + rgma -c 'select count(*) from LcgRecords'
>> > + grep 'Rows in set'
>> > + set +x
>> > LcgRecords latest archiver is working.
>> >
>> > Checking if LcgRecords tuples are present for the site (max 1 day
>> old):
>> >
>> > ++ rgma -c 'select count(*) from LcgRecords where
>> > ExecutingCE='\''ce.egee.man.poznan.pl'\'' and
>> > MeasurementDate>='\''2005-08-22'\'''
>> > ++ grep '^|'
>> > ++ cut -f 2 -d ' '
>> > ++ tail -n 1
>> > + count=0
>> > + set +x
>> >
>> > Count: 0
>> > Empty Apel result set - FAILED!
>> >
>> >
>> > --
>> > Piotr Siwczak <[log in to unmask]>
>> > System Administrator
>> >
>> > Poznan Supercomputing and Networking Center
>> > Supercomputing Department
>> >
>> > (www.eu-egee.org <[log in to unmask]>)
>> > --
>> >
>>
>> Christos Filippidis
>> NCSR DEMOKRITOS
>> Institute of Nuclear Physics
>> office block 6(ktirion 6)
>> Gr-15310 Agia Paraskevi
>> GREECE
>> Tel:2106503425
>>
>> http://consult.cern.ch/xwho/people/117002
>> http://www.inp.demokritos.gr/~filippidisx/
>>
>> ----------------------------------------------
>>
>> "Institute of Nuclear Physics NCSR Demokritos"
>> http://www.inp.demokritos.gr/
> ------- End of Original Message -------
>
Christos Filippidis
NCSR DEMOKRITOS
Institute of Nuclear Physics
office block 6(ktirion 6)
Gr-15310 Agia Paraskevi
GREECE
Tel:2106503425
http://consult.cern.ch/xwho/people/117002
http://www.inp.demokritos.gr/~filippidisx/
----------------------------------------------
"Institute of Nuclear Physics NCSR Demokritos"
http://www.inp.demokritos.gr/
|