Dave,
0. http://bugs.mysql.com/bug.php?id=1279
Please check the permissions of the files in your APEL database directory.
Is it possible that they are not owned by mysql?
1. Please try the "REPAIR TABLE" proceedure described in the APEL FAQ.
2. What does your CE report when processing the GK and batch logs?
Does it show that new data is being written to the database tables GkRecords and EventRecords?
Please send us APELs XML config file for the CE.
3. On the Mon, what tables exist in your APEL database?
mysql>show tables;
4. Please send us APEL XML config file for the MON.
Dave Kant
-----Original Message-----
From: Testbed Support for GridPP member institutes on behalf of Gordon, JC (John)
Sent: Mon 3/26/2007 5:47 PM
To: [log in to unmask]
Subject: Re: Problem reporting accounting data to GOC
Dave, I presume you have read the FAQ.
http://goc.grid.sinica.edu.tw/gocwiki/APEL_FAQ
If no-one is answering it may be that only Dave Kant can help. He is on
holiday this week I am afraid.
John
> -----Original Message-----
> From: Testbed Support for GridPP member institutes
> [mailto:[log in to unmask]] On Behalf Of David Robson
> Sent: 26 March 2007 17:19
> To: [log in to unmask]
> Subject: Re: Problem reporting accounting data to GOC
>
> 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(MySQLImp
> > l.java:1573)
> >
> > at
> >
> org.glite.apel.core.db.MySQLImpl.generateAccountRecordsGliteCE(MySQLIm
> > pl.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(MySQLImp
> > l.java:1570)
> >
> > ... 6 more
> >
>
|