David, the main reasons for not getting any joined records tend to be
a) you haven't set the flag to use the blah logs
b) specint values published for the cluster don't use the same name as
APEL.
Submit a GGUS ticket showing which version of the rpms you have
installed.
John
> -----Original Message-----
> From: Testbed Support for GridPP member institutes
> [mailto:[log in to unmask]] On Behalf Of David Robson
> Sent: 13 August 2008 17:30
> To: [log in to unmask]
> Subject: Apel publishing problem
>
> A few weeks ago, we encountered problems with our CE.
> Despite a lot of debugging, we never got to the bottom of the
> problem, and we eventually rebuilt it from a previous backup.
> Now we suspect that something is out of sync, and is
> stopping publishing.
>
> On the MON box, the apel logs shows that the are no Joined
> accounting records.
> Looking in the mysql database, I see that the EventRecords
> table has recent data, but GkRecords, LcgRecords,
> RepublishInfo and MessageRecords are out of date.
>
> Looking at the CE, where the trouble presumably originates,
> our apel logs look like (see below).
>
> Does anyone have any ideas on how to fix the problem, and how
> to publish the missing data?
>
> Thanks in advance
>
> Dave
>
>
> Wed Aug 13 06:21:01 UTC 2008: apel-publisher - Read-in
> configuration: [logenabled, p, inspectTables,
> j] [DBUsername=accounting,
> DBURL=jdbc:mysql://grid003.jet.efda.org:3306/accounting,
> DBPassword=**** , site=EFDA-JET, republish=missing] Wed Aug
> 13 06:21:01 UTC 2008: apel-publisher - ------ Starting the
> apel application ------ Wed Aug 13 06:21:01 UTC 2008:
> apel-publisher - **** APEL is examining the schema **** Wed
> Aug 13 06:21:01 UTC 2008: apel-publisher - Checking the
> LcgRecords table Wed Aug 13 06:21:01 UTC 2008: apel-publisher
> - The LcgRecords schema is up-to-date Wed Aug 13 06:21:01 UTC
> 2008: apel-publisher - Checking the BlahdRecords table Wed
> Aug 13 06:21:01 UTC 2008: apel-publisher - The BlahdRecords
> schema is up-to-date Wed Aug 13 06:21:01 UTC 2008:
> apel-publisher - Checking the LcgProcessedFiles table Wed Aug
> 13 06:21:01 UTC 2008: apel-publisher - The LcgProcessedFiles
> schema is up-to-date Wed Aug 13 06:21:01 UTC 2008:
> apel-publisher - Checking the SpecRecords table Wed Aug 13
> 06:21:01 UTC 2008: apel-publisher - The SpecRecords schema is
> up-to-date Wed Aug 13 06:21:01 UTC 2008: apel-publisher -
> Checking the GkRecords table Wed Aug 13 06:21:01 UTC 2008:
> apel-publisher - The GkRecords schema is up-to-date Wed Aug
> 13 06:21:01 UTC 2008: apel-publisher - Checking the
> MessageRecords table Wed Aug 13 06:21:01 UTC 2008:
> apel-publisher - The MessageRecords schema is up-to-date Wed
> Aug 13 06:21:01 UTC 2008: apel-publisher - **** Schema checks
> complete **** Wed Aug 13 06:21:02 UTC 2008: apel-publisher -
> Optimising table: EventRecords Wed Aug 13 06:21:02 UTC 2008:
> apel-publisher - Optimising table: GkRecords Wed Aug 13
> 06:21:02 UTC 2008: apel-publisher - Optimising table:
> MessageRecords Wed Aug 13 06:21:02 UTC 2008: apel-publisher -
> Optimising table: SpecRecords Wed Aug 13 06:21:02 UTC 2008:
> apel-publisher - Optimising table: LcgRecords Wed Aug 13
> 06:21:02 UTC 2008: apel-publisher - Optimising table:
> BlahdRecords Wed Aug 13 06:21:02 UTC 2008: apel-publisher -
> **** Combining tables and republishing in LcgRecords
> ****
> Wed Aug 13 06:21:02 UTC 2008: apel-publisher - Checking valid
> CPU spec data exists Wed Aug 13 06:21:02 UTC 2008:
> apel-publisher - CPU spec values found Wed Aug 13 06:21:02
> UTC 2008: apel-publisher - Creating a new Primary Producer
> Wed Aug 13 06:21:05 UTC 2008: apel-publisher -
> ====================================
> Wed Aug 13 06:21:05 UTC 2008: apel-publisher -
> Synchronisation data check
> Wed Aug 13 06:21:05 UTC 2008: apel-publisher -
> ====================================
> Wed Aug 13 06:21:07 UTC 2008: apel-publisher - Finding all
> records in local database since the last successful publish
> timestamp : 2008-06-25 09:14:33 Wed Aug 13 06:21:05 UTC 2008:
> apel-publisher - No records found Wed Aug 13 06:21:05 UTC
> 2008: apel-publisher - ====================================
> Wed Aug 13 06:21:05 UTC 2008: apel-publisher - Completed
> Synchronisation data check Wed Aug 13 06:21:05 UTC 2008:
> apel-publisher - ====================================
> Wed Aug 13 06:21:05 UTC 2008: apel-publisher - Publisher
> Mode = Apel Publisher (Default) Wed Aug 13 06:21:05 UTC 2008:
> apel-publisher - Building account records via the new
> Accounting Log F ile Wed Aug 13 06:21:05 UTC 2008:
> apel-publisher - NB: Record Counts may be zero if Patch #898
> is not ac tive on this CE Wed Aug 13 06:21:05 UTC 2008:
> apel-publisher - Stitching together all accounting records
> Wed Aug 13 06:21:05 UTC 2008: apel-publisher - Stitching
> completed Wed Aug 13 06:21:05 UTC 2008: apel-publisher - No
> accounting data to store Wed Aug 13 06:21:05 UTC 2008:
> apel-publisher - Number of Joined accounting records: 0 Wed
> Aug 13 06:21:05 UTC 2008: apel-publisher - Build complete Wed
> Aug 13 06:21:05 UTC 2008: apel-publisher - Building account
> records via GK Logs Wed Aug 13 06:21:05 UTC 2008:
> apel-publisher - NB: Record Counts may be zero if Patch #898 is active
> on this CE
> Wed Aug 13 06:21:05 UTC 2008: apel-publisher - Stitching
> together all accounting records Wed Aug 13 06:21:07 UTC 2008:
> apel-publisher - Stitching completed Wed Aug 13 06:21:07 UTC
> 2008: apel-publisher - No accounting data to store Wed Aug 13
> 06:21:07 UTC 2008: apel-publisher - Number of Joined
> accounting records: 0 Wed Aug 13 06:21:07 UTC 2008:
> apel-publisher - Build complete Wed Aug 13 06:21:07 UTC 2008:
> apel-publisher - Publishing data into rgma Wed Aug 13
> 06:21:07 UTC 2008: apel-publisher - Publishing Records to GOC
> (via Accounting Log): 0 Wed Aug 13 06:21:07 UTC 2008:
> apel-publisher - Publishing data into rgma Wed Aug 13
> 06:21:07 UTC 2008: apel-publisher - Publishing Records to GOC
> (via GK Log): 0 Wed Aug 13 06:21:07 UTC 2008: apel-publisher
> - **** Join processing complete **** Wed Aug 13 06:21:07 UTC
> 2008: apel-publisher - ====================================
> Wed Aug 13 06:21:07 UTC 2008: apel-publisher -
> Publishing Summary Data
> Wed Aug 13 06:21:07 UTC 2008: apel-publisher -
> ====================================
> Wed Aug 13 06:21:07 UTC 2008: apel-publisher - Data will be
> written to RGMA Table : LcgRecordsSync_v
> 2
> Wed Aug 13 06:21:07 UTC 2008: apel-publisher - Creating a new
> Primary Producer Wed Aug 13 06:21:09 UTC 2008: apel-publisher
> - Publishing summary data into rgma Wed Aug 13 06:21:11 UTC
> 2008: apel-publisher - ------ Processing finished ------ ~
>
> --
> David Robson
>
> CODAS & IT Department, UKAEA Culham
> Culham Science Centre, Abingdon, OXON, OX14 3DB, UK
> Voice: +44(0)1235-46-4569, Fax: 4404
> Work email: [log in to unmask]
> Home email: [log in to unmask]
>
|