Latest news ..
I have decided to take the drastic step of removing all glite,lcg,edg
and yaim rpms from our MON
box, downloading the latest version of yaim, followed by an install_node
and a configure_node.
The net result is - no change! We are still not publishing data, and
apel-publisher is still
complaining about the missing ./accounting/BlahdRecords.frm file, even
though
/var/lib/mysql/accounting/BlahdRecords.frm still exists.
If anyone has any idea on how I should progress, now is a good time!
Dave
David Robson wrote:
> Hi,
>
> We (EFDA-JET) have just received a ticket (* GGUS ID: * 19448) to say
> that EDFA-JET has not been
> reporting accounting data to GOC since 2007-01-28. This coincides
> with us upgrading to glite 3.0
> Update 12. On investigation, we found that the update had removed the
> mysql entry from
> /etc/passwd. We reinstated the entry and restarted all services.
> However, we are still not
> publishing. We then did a yum update for glite to update 17. Still
> not publishing.
>
> On running
>
> 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
>
> We get the error message shown at the end of this email
>
> Firstly, does anyone know about the "Can't find file:
> './accounting/BlahdRecord
> s.frm' (errno: 13)" message? We do have one
> (/var/lib/mysql/accounting/BlahdRecords.frm),
> but I assume that either,
>
> a) a process is running in the wrong directory
>
> or
>
> b) Some environmental variable is not set
>
>
> Any ideas anyone??
>
> Dave
>
>
> 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
>
> BC_PROVIDER is not set, using default location
> ... /opt/glite/share/glite-security-trustmanager/bcprov-jdk14-122.jar
> Fri Mar 23 16:58:26 UTC 2007: apel-publisher - Read-in configuration:
> [logenabled, j] [DBUsername=accounting,
> DBURL=jdbc:mysql://grid003.jet.efda.org:3306/accounting,
> DBPassword=****, site=EFDA-JET, republish=missing]
> Fri Mar 23 16:58:26 UTC 2007: apel-publisher - ------ Starting the
> apel application ------
> Fri Mar 23 16:58:26 UTC 2007: apel-publisher - Optimising table:
> EventRecords
> Fri Mar 23 16:58:26 UTC 2007: apel-publisher - Optimising table:
> GkRecords
> Fri Mar 23 16:58:26 UTC 2007: apel-publisher - Optimising table:
> MessageRecords
> Fri Mar 23 16:58:26 UTC 2007: apel-publisher - Optimising table:
> SpecRecords
> Fri Mar 23 16:58:26 UTC 2007: apel-publisher - Optimising table:
> LcgRecords
> Fri Mar 23 16:58:26 UTC 2007: apel-publisher - Checking Blahd table:
> BlahdRecords
> Fri Mar 23 16:58:26 UTC 2007: apel-publisher - Can't find file:
> './accounting/BlahdRecords.frm' (errno: 13)
> Fri Mar 23 16:58:26 UTC 2007: apel-publisher - Creating Blahd table:
> Fri Mar 23 16:58:26 UTC 2007: apel-publisher - Optimising table:
> BlahdRecords
> Fri Mar 23 16:58:26 UTC 2007: apel-publisher - **** Combining tables
> and republishing in LcgRecords ****
> Fri Mar 23 16:58:26 UTC 2007: apel-publisher - Checking valid CPU spec
> data exists
> Fri Mar 23 16:58:26 UTC 2007: apel-publisher - CPU spec values found
> Fri Mar 23 16:58:51 UTC 2007: apel-publisher -
> ====================================
> Fri Mar 23 16:58:51 UTC 2007: apel-publisher - Synchronisation
> data check Fri Mar 23 16:58:51 UTC 2007: apel-publisher -
> ====================================
> Fri Mar 23 16:58:52 UTC 2007: apel-publisher - Finding all records in
> local database since the last successful publish timestamp :
> 2007-03-23 10:40:23
> Fri Mar 23 16:58:52 UTC 2007: apel-publisher - No records found
> Fri Mar 23 16:58:52 UTC 2007: apel-publisher -
> ====================================
> Fri Mar 23 16:58:52 UTC 2007: apel-publisher - Completed
> Synchronisation data check
> Fri Mar 23 16:58:52 UTC 2007: apel-publisher -
> ====================================
> Fri Mar 23 16:58:52 UTC 2007: apel-publisher - Publisher Mode = Apel
> Publisher (Default)
> Fri Mar 23 16:58:52 UTC 2007: apel-publisher - Building account
> records for LCG CE
> Fri Mar 23 16:58:52 UTC 2007: apel-publisher - LCG CE: Stitching
> together all accounting records
> Fri Mar 23 16:58:52 UTC 2007: apel-publisher - LCG CE: Stitching
> completed
> Fri Mar 23 16:58:52 UTC 2007: apel-publisher - No accounting data to
> store
> Fri Mar 23 16:58:52 UTC 2007: apel-publisher - Number of Joined
> accounting records: 0
> Fri Mar 23 16:58:52 UTC 2007: apel-publisher - Build complete
> Fri Mar 23 16:58:52 UTC 2007: apel-publisher - Building account
> records for data through the new Glite CE
> Fri Mar 23 16:58:52 UTC 2007: apel-publisher - GliteCE: Stitching
> together all accounting records
> Fri Mar 23 16:58:52 UTC 2007: apel-publisher - program aborted
> org.glite.apel.core.ApelException: java.sql.SQLException: Can't find
> file: './accounting/BlahdRecords.frm' (errno: 13)
> at
> org.glite.apel.core.db.MySQLImpl.joinAccountingRecordsGliteCE(MySQLImpl.java:1573)
>
> at
> org.glite.apel.core.db.MySQLImpl.generateAccountRecordsGliteCE(MySQLImpl.java:745)
>
> at
> org.glite.apel.publisher.AccountManager.processRecords(AccountManager.java:304)
>
> at
> org.glite.apel.publisher.AccountManager.run(AccountManager.java:141)
> at
> org.glite.apel.publisher.ApelPublisher.runJoinProcessor(ApelPublisher.java:117)
>
> at
> org.glite.apel.publisher.ApelPublisher.run(ApelPublisher.java:65)
> at
> org.glite.apel.publisher.ApelPublisher.main(ApelPublisher.java:234)
> Caused by: java.sql.SQLException: Can't find file:
> './accounting/BlahdRecords.frm' (errno: 13)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2851)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622)
> at com.mysql.jdbc.Connection.execSQL(Connection.java:2379)
> at com.mysql.jdbc.Connection.execSQL(Connection.java:2306)
> at com.mysql.jdbc.Statement.executeQuery(Statement.java:1192)
> at
> org.glite.apel.core.db.MySQLImpl.joinAccountingRecordsGliteCE(MySQLImpl.java:1570)
>
> ... 6 more
>
|