After installing the glite-apel packages and rgma-gin (yes this was
missing too) on the CE and following the
instructions below and also the corrections from the thread
http://listserv.cclrc.ac.uk/cgi-bin/webadmin?A2=ind0508&L=lcg-rollout&O=D&P=50152
it seems that apel is ok now. Thanks for all the help.
Regards,
Kostas
Antun Balaz wrote:
>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 -------
>
>
|