Hi,
you have to ensure that
/etc/init.d/rgma-gin
/etc/init.d/rgma-servicetool
/etc/init.d/rgma-publish-site
are running on your MON, and that
/etc/init.d/rgma-gin
is running on your CE.
Looking closely, I see that the last day for which the record are present is
August 26 (after then the count is zero):
[root@ce root]# rgma -c 'select count(*) from LcgRecords where
ExecutingCE='\''alexander.it.uom.gr'\'' and MeasurementDate>='\''2005-08-
26'\'''
+----------+
| count(*) |
+----------+
| 8 |
+----------+
1 Rows in set
Wait for some jobs to finish, execute the parser by hand again, and see if
you are lucky. In the meantime, you can also check the latest files
in /var/spool/pbs/server_priv/accounting/ to see whether accounting is
working properly...
Hope this helps,
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 10:38:02 +0300
Subject: Re: [LCG-ROLLOUT] RGMA - 0 count
> 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/
------- End of Original Message -------
|