Hello,
since the upgrade of the CE (gcn54.hep.physik.uni-siegen.de) to SLC4 / glite
3.1 no accounting data is published by our site. Before the MON - Box was
hosted by the the same host like the CE, during the upgrade the MON was
migrated to another host (gcn51) und runs still with SLC3.
On the MON I found the appended entry in the logs. I have no experience with
APEL. Does somebody know how to solve this problem?
Regards,
Daniel Lorenz
Wed Dec 19 00:35:01 UTC 2007: apel-pbs-log-parser - Read-in configuration:
[quiet, c, e, recursiveEventFiles, g, recursiveGKFiles, b,
recursiveBlahdFiles] [DBPassword=****, site=UNI-SIEGEN-HEP,
pbslog=/var/spool/pbs/server_priv/accounting,
GIIS=gcn54.hep.physik.uni-siegen.de, CEhost=[gcn54.hep.physik.uni-siegen.de,
gcn54.hep.physik.uni-siegen.de], blahdlogPrefix=blahp.log, gklog=/var/log,
DBURL=jdbc:mysql://gcn54.hep.physik.uni-siegen.de:3306/accounting,
DBUsername=accounting, mslog=/var/log, timeZone=UTC,
blahdlog=/var/log/glite/accounting]
Wed Dec 19 00:35:01 UTC 2007: apel-pbs-log-parser - ------ Starting the apel
application ------
Wed Dec 19 00:35:01 UTC 2007: apel-pbs-log-parser - program aborted
org.glite.apel.core.ApelException: Unable to setup a database connection:
Communications link failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.net.SocketException
MESSAGE: java.net.ConnectException: Connection refused
STACKTRACE:
java.net.SocketException: java.net.ConnectException: Connection refused
at
com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:151)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:280)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1774)
at com.mysql.jdbc.Connection.<init>(Connection.java:437)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at org.glite.apel.core.db.MySQLImpl.<init>(MySQLImpl.java:83)
at org.glite.apel.core.processor.SpecProcessor.<init>(SpecProcessor.java:93)
at org.glite.apel.pbs.ApelLogParser.runSpecProcessor(ApelLogParser.java:102)
at org.glite.apel.pbs.ApelLogParser.run(ApelLogParser.java:77)
at org.glite.apel.pbs.ApelLogParser.main(ApelLogParser.java:283)
** END NESTED EXCEPTION **
at org.glite.apel.core.db.MySQLImpl.<init>(MySQLImpl.java:86)
at org.glite.apel.core.processor.SpecProcessor.<init>(SpecProcessor.java:93)
at org.glite.apel.pbs.ApelLogParser.runSpecProcessor(ApelLogParser.java:102)
at org.glite.apel.pbs.ApelLogParser.run(ApelLogParser.java:77)
at org.glite.apel.pbs.ApelLogParser.main(ApelLogParser.java:283)
BC_PROVIDER is not set, using default location
... /opt/glite/share/glite-security-trustmanager/bcprov-jdk14-122.jar
Wed Dec 19 01:10:01 UTC 2007: apel-publisher - Read-in configuration:
[logenabled, p, inspectTables, j] [DBUsername=accounting,
DBURL=jdbc:mysql://gcn51.hep.physik.uni-siegen.de:3306/accounting,
DBPassword=****, site=UNI-SIEGEN-HEP, republish=missing]
Wed Dec 19 01:10:01 UTC 2007: apel-publisher - ------ Starting the apel
application ------
Wed Dec 19 01:10:01 UTC 2007: apel-publisher - **** APEL is examining the
schema ****
Wed Dec 19 01:10:01 UTC 2007: apel-publisher - Checking the LcgRecords table
Wed Dec 19 01:10:01 UTC 2007: apel-publisher - The LcgRecords schema is
up-to-date
Wed Dec 19 01:10:01 UTC 2007: apel-publisher - Checking the BlahdRecords table
Wed Dec 19 01:10:01 UTC 2007: apel-publisher - The BlahdRecords schema is
up-to-date
Wed Dec 19 01:10:01 UTC 2007: apel-publisher - Checking the LcgProcessedFiles
table
Wed Dec 19 01:10:01 UTC 2007: apel-publisher - The LcgProcessedFiles schema is
up-to-date
Wed Dec 19 01:10:01 UTC 2007: apel-publisher - Checking the SpecRecords table
Wed Dec 19 01:10:01 UTC 2007: apel-publisher - The SpecRecords schema is
up-to-date
Wed Dec 19 01:10:01 UTC 2007: apel-publisher - Checking the GkRecords table
Wed Dec 19 01:10:01 UTC 2007: apel-publisher - The GkRecords schema is
up-to-date
Wed Dec 19 01:10:01 UTC 2007: apel-publisher - Checking the MessageRecords
table
Wed Dec 19 01:10:01 UTC 2007: apel-publisher - The MessageRecords schema is
up-to-date
Wed Dec 19 01:10:01 UTC 2007: apel-publisher - **** Schema checks complete
****
Wed Dec 19 01:10:01 UTC 2007: apel-publisher - Optimising table: EventRecords
Wed Dec 19 01:10:02 UTC 2007: apel-publisher - Optimising table: GkRecords
Wed Dec 19 01:10:02 UTC 2007: apel-publisher - Optimising table:
MessageRecords
Wed Dec 19 01:10:02 UTC 2007: apel-publisher - Optimising table: SpecRecords
Wed Dec 19 01:10:02 UTC 2007: apel-publisher - Optimising table: LcgRecords
Wed Dec 19 01:10:02 UTC 2007: apel-publisher - Optimising table: BlahdRecords
Wed Dec 19 01:10:02 UTC 2007: apel-publisher - **** Combining tables and
republishing in LcgRecords ****
Wed Dec 19 01:10:02 UTC 2007: apel-publisher - Checking valid CPU spec data
exists
Wed Dec 19 01:10:02 UTC 2007: apel-publisher - CPU spec values found
Wed Dec 19 01:10:02 UTC 2007: apel-publisher - Creating a new Primary Producer
Wed Dec 19 01:10:06 UTC 2007: apel-publisher -
====================================
Wed Dec 19 01:10:06 UTC 2007: apel-publisher - Synchronisation data check
Wed Dec 19 01:10:06 UTC 2007: apel-publisher -
====================================
Wed Dec 19 01:10:06 UTC 2007: apel-publisher - Finding all records in local
database since the last successful publish timestamp : 2007-12-18 12:45:19
Wed Dec 19 01:10:06 UTC 2007: apel-publisher - Record/s found: 1756
Wed Dec 19 01:10:06 UTC 2007: apel-publisher - Checking Archiver is Online
Wed Dec 19 01:10:06 UTC 2007: apel-publisher - Creating a Resilient Consumer
Wed Dec 19 01:10:06 UTC 2007: apel-publisher - Starting Resilient Consumer
Wed Dec 19 01:10:19 UTC 2007: apel-publisher - Closing Resilient Consumer
Wed Dec 19 01:10:19 UTC 2007: apel-publisher - Archiver Alive
Wed Dec 19 01:10:19 UTC 2007: apel-publisher - Archiver Record Count: Record/s
found site UNI-SIEGEN-HEP : 1756
Wed Dec 19 01:10:19 UTC 2007: apel-publisher - GOC Archiver and local db
match-up, updating the RepublishInfo table
Wed Dec 19 01:10:19 UTC 2007: apel-publisher - Rows deleted from
RepublishInfo: 1
Wed Dec 19 01:10:19 UTC 2007: apel-publisher -
====================================
Wed Dec 19 01:10:19 UTC 2007: apel-publisher - Completed Synchronisation data
check
Wed Dec 19 01:10:19 UTC 2007: apel-publisher -
====================================
Wed Dec 19 01:10:19 UTC 2007: apel-publisher - Publisher Mode = Apel
Publisher (Default)
Wed Dec 19 01:10:19 UTC 2007: apel-publisher - Building account records via
the new Accounting Log File
Wed Dec 19 01:10:19 UTC 2007: apel-publisher - NB: Record Counts may be zero
if Patch #898 is not active on this CE
Wed Dec 19 01:10:19 UTC 2007: apel-publisher - Stitching together all
accounting records
Wed Dec 19 01:10:19 UTC 2007: apel-publisher - Stitching completed
Wed Dec 19 01:10:19 UTC 2007: apel-publisher - Storing accounting data into
local database
Wed Dec 19 01:10:19 UTC 2007: apel-publisher - Number of Joined accounting
records: 33
Wed Dec 19 01:10:19 UTC 2007: apel-publisher - Build complete
Wed Dec 19 01:10:19 UTC 2007: apel-publisher - Building account records via GK
Logs
Wed Dec 19 01:10:19 UTC 2007: apel-publisher - NB: Record Counts may be zero
if Patch #898 is active on this CE
Wed Dec 19 01:10:19 UTC 2007: apel-publisher - Stitching together all
accounting records
Wed Dec 19 01:10:20 UTC 2007: apel-publisher - Stitching completed
Wed Dec 19 01:10:20 UTC 2007: apel-publisher - No accounting data to store
Wed Dec 19 01:10:20 UTC 2007: apel-publisher - Number of Joined accounting
records: 0
Wed Dec 19 01:10:20 UTC 2007: apel-publisher - Build complete
Wed Dec 19 01:10:20 UTC 2007: apel-publisher - Publishing data into rgma
Wed Dec 19 01:10:20 UTC 2007: apel-publisher - Publishing Records to GOC (via
Accounting Log): 33
Wed Dec 19 01:10:20 UTC 2007: apel-publisher - Publishing data into rgma
Wed Dec 19 01:10:20 UTC 2007: apel-publisher - Publishing Records to GOC (via
GK Log): 0
Wed Dec 19 01:10:20 UTC 2007: apel-publisher - **** Join processing complete
****
Wed Dec 19 01:10:20 UTC 2007: apel-publisher -
====================================
Wed Dec 19 01:10:20 UTC 2007: apel-publisher - Publishing Summary Data
Wed Dec 19 01:10:20 UTC 2007: apel-publisher -
====================================
Wed Dec 19 01:10:20 UTC 2007: apel-publisher - Data will be written to RGMA
Table : LcgRecordsSync_v2
Wed Dec 19 01:10:20 UTC 2007: apel-publisher - Creating a new Primary Producer
Wed Dec 19 01:10:22 UTC 2007: apel-publisher - Publishing summary data into
rgma
Wed Dec 19 01:10:22 UTC 2007: apel-publisher - ------ Processing finished
------
|