Print

Print


Yes, I have retrieved the same output, mutatis mutandis. So, something still 
doesn't work...

Regards, Antun

[root@grid root]# /opt/glite/bin/apel-publisher -f /opt/glite/etc/glite-apel-
publisher/publisher-config-yaim.xml
Tue Sep  6 18:18:53 UTC 2005: apel-publisher - Read-in configuration: 
[logenabled, j] [DBUsername=accounting, 
DBURL=jdbc:mysql://grid.phy.bg.ac.yu:3306/accounting, DBPassword=****, 
site=AEGIS01-PHY-SCL, republish=missing]
Tue Sep  6 18:18:53 UTC 2005: apel-publisher - ------ Starting the apel 
application ------
Tue Sep  6 18:18:54 UTC 2005: apel-publisher - Optimising table: EventRecords
Tue Sep  6 18:18:54 UTC 2005: apel-publisher - Optimising table: GkRecords
Tue Sep  6 18:18:54 UTC 2005: apel-publisher - Optimising table: 
MessageRecords
Tue Sep  6 18:18:54 UTC 2005: apel-publisher - Optimising table: SpecRecords
Tue Sep  6 18:18:54 UTC 2005: apel-publisher - Optimising table: LcgRecords
Tue Sep  6 18:18:54 UTC 2005: apel-publisher - **** Combining tables and 
republishing in LcgRecords ****
Tue Sep  6 18:18:54 UTC 2005: apel-publisher - Checking valid CPU spec data 
exists
Tue Sep  6 18:18:54 UTC 2005: apel-publisher - CPU spec values found
Tue Sep  6 18:18:57 UTC 2005: apel-publisher - Finding records from: 2005-09-
01 01:11:05
Tue Sep  6 18:18:57 UTC 2005: apel-publisher - Record/s found: 799
Tue Sep  6 18:19:58 UTC 2005: apel-publisher - Unable to retrieve any 
response while querying the GOC
Tue Sep  6 18:19:58 UTC 2005: apel-publisher - WARNING - Received a 'null' 
result set while querying the 'LcgRecords' table using rgma, this probably 
means the GOC is currently off-line, will therefore cancel attempt to re-
publish
Tue Sep  6 18:19:58 UTC 2005: apel-publisher - Completed data check
Tue Sep  6 18:19:58 UTC 2005: apel-publisher - Building account records
Tue Sep  6 18:19:58 UTC 2005: apel-publisher - Stitching together all 
accounting records
Tue Sep  6 18:19:58 UTC 2005: apel-publisher - Stitching completed
Tue Sep  6 18:19:58 UTC 2005: apel-publisher - Storing accounting data into 
local database
Tue Sep  6 18:19:58 UTC 2005: apel-publisher - Build complete
Tue Sep  6 18:19:58 UTC 2005: apel-publisher - Publishing data into rgma
Tue Sep  6 18:19:59 UTC 2005: apel-publisher - Number of generated 
accounting records: 82
Tue Sep  6 18:19:59 UTC 2005: apel-publisher - **** Join processing complete 
****
Tue Sep  6 18:19:59 UTC 2005: apel-publisher - ------ Processing finished ---
---


-----
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: Valentin Vidic <[log in to unmask]>
To: [log in to unmask]
Sent: Tue, 6 Sep 2005 19:29:12 +0200
Subject: Re: [LCG-ROLLOUT] Accounting?

> Here is some more info on the subject:
> 
> [[log in to unmask] root]# env RGMA_HOME=/opt/glite 
> APEL_HOME=/opt/glite /opt/glite/bin/apel-publisher -f 
> /opt/glite/etc/glite-apel-publisher/publisher-config-yaim.xml
> Tue Sep  6 17:25:56 UTC 2005: apel-publisher - Read-in 
> configuration: [logenabled, j] [DBUsername=accounting, 
> DBURL=jdbc:mysql://grid2.irb.hr:3306/accounting, 
> DBPassword=xxxxxxxxx, site=HR-01-RBI, republish=missing]
> Tue Sep  6 17:25:56 UTC 2005: apel-publisher - ------ Starting the 
> apel application ------
> Tue Sep  6 17:25:56 UTC 2005: apel-publisher - Optimising table: 
EventRecords
> 
> Tue Sep  6 17:25:56 UTC 2005: apel-publisher - Optimising table: GkRecords
> 
> Tue Sep  6 17:25:56 UTC 2005: apel-publisher - Optimising table: 
MessageRecords
> 
> Tue Sep  6 17:25:56 UTC 2005: apel-publisher - Optimising table: 
SpecRecords
> 
> Tue Sep  6 17:25:56 UTC 2005: apel-publisher - Optimising table: LcgRecords
> 
> Tue Sep  6 17:25:56 UTC 2005: apel-publisher - **** Combining tables 
> and republishing in LcgRecords ****
> Tue Sep  6 17:25:56 UTC 2005: apel-publisher - Checking valid CPU 
> spec data exists
> Tue Sep  6 17:25:56 UTC 2005: apel-publisher - CPU spec values found
> Tue Sep  6 17:25:58 UTC 2005: apel-publisher - Finding records from: 
> 2005-08-28 01:11:02
> Tue Sep  6 17:25:59 UTC 2005: apel-publisher - Record/s found: 181
> Tue Sep  6 17:26:59 UTC 2005: apel-publisher - Unable to retrieve 
> any response while querying the GOC
> Tue Sep  6 17:26:59 UTC 2005: apel-publisher - WARNING - Received a 
> 'null' result set while querying the 'LcgRecords' table using rgma,
>  this probably means the GOC is currently off-line, will therefore 
> cancel attempt to re-publish
> Tue Sep  6 17:26:59 UTC 2005: apel-publisher - Completed data check
> Tue Sep  6 17:26:59 UTC 2005: apel-publisher - Building account records
> 
> Tue Sep  6 17:26:59 UTC 2005: apel-publisher - Stitching together 
> all accounting records
> Tue Sep  6 17:26:59 UTC 2005: apel-publisher - Stitching completed
> Tue Sep  6 17:26:59 UTC 2005: apel-publisher - No accounting data to 
> store
> Tue Sep  6 17:27:00 UTC 2005: apel-publisher - Build complete
> Tue Sep  6 17:27:00 UTC 2005: apel-publisher - Publishing data into rgma
> 
> Tue Sep  6 17:27:00 UTC 2005: apel-publisher - Number of generated 
> accounting records: 0
> Tue Sep  6 17:27:00 UTC 2005: apel-publisher - **** Join processing 
> complete ****
> Tue Sep  6 17:27:00 UTC 2005: apel-publisher - ------ Processing 
> finished ------
------- End of Original Message -------