[GE users] ARCO db error

Petr Horna ext.Petr.Horna at skoda-auto.cz
Thu Sep 25 13:44:28 BST 2008


Hello to all,

I want to ask for help:

Probably during a restart a dbwriter stop to process a reporting file:
----------------------------------------------------------------------------
  5/07/2008 11:03:23|smbesge5.mb.skoda.vwg|
er.file.FileParser.processFile|
I|Renaming reporting  to reporting.processing
25/07/2008 11:03:23|smbesge5.mb.skoda.vwg|
iter.file.FileParser.parseFile|I|Deleting file reporting.processing
25/07/2008 11:03:23|smbesge5.mb.skoda.vwg|
iter.file.FileParser.parseFile|I|Processed 9 lines in 0.03s (290.32
lines/s)
12/08/2008 03:09:00|smbesge5.mb.skoda.vwg|
dbwriter.ReportingDBWriter.run|E|Uncaught exception: null
                              java.lang.ArrayIndexOutOfBoundsException:
null

com.sun.grid.reporting.dbwriter.HostValueManager.handleNewSubRecord(HostValueManager.java:96)

com.sun.grid.reporting.dbwriter.HostManager.initSubRecordsFromEvent(HostManager.java:87)

com.sun.grid.reporting.dbwriter.StoredRecordManager.newLineParsed(StoredRecordManager.java:63)

com.sun.grid.reporting.dbwriter.GeneralManager.newLineParsed(GeneralManager.java:70)

com.sun.grid.reporting.dbwriter.file.FileParser.fireEvent(FileParser.java:485)

com.sun.grid.reporting.dbwriter.file.FileParser.fireEvent(FileParser.java:479)

com.sun.grid.reporting.dbwriter.file.FileParser.parseLine(FileParser.java:473)

com.sun.grid.reporting.dbwriter.file.FileParser.parseFile(FileParser.java:362)

com.sun.grid.reporting.dbwriter.file.FileParser.processFile(FileParser.java:283)

com.sun.grid.reporting.dbwriter.ReportingDBWriter.processFile(ReportingDBWriter.java:1148)

12/08/2008 03:09:00|smbesge5.mb.skoda.vwg|
dbwriter.ReportingDBWriter.run|I|dbwriter stopped
--------------------------------------------------

and it is not possible to start dbwriter again now:

---------------------------------------------------
23/09/2008 16:10:03|
smbesge5.mb.skoda.vwg|.ReportingDBWriter.initLogging|I|Starting up
dbwriter (Version 6.1u2) ---------------------------
23/09/2008 16:10:03|smbesge5.mb.skoda.vwg|
r.ReportingDBWriter.initialize|I|Connection to db
jdbc:postgresql://smbesge0.mb.skoda.vwg:5432/arco
23/09/2008 16:10:03|smbesge5.mb.skoda.vwg|
r.ReportingDBWriter.initialize|I|Found database model version 6
23/09/2008 16:10:03|smbesge5.mb.skoda.vwg|Writer
$VacuumAnalyzeThread.run|I|Next vacuum analyze will be executed at
9/24/08 12:11 PM
23/09/2008 16:10:03|smbesge5.mb.skoda.vwg|
tingDBWriter.getDbWriterConfig|I|calculation
file /opt/sge/dbwriter/database/postgres/dbwriter.xml has changed,
reread it
23/09/2008 16:10:03|smbesge5.mb.skoda.vwg|
er.file.FileParser.processFile|W|Found a data file left from a previous
run (reporting.processing), trying to process this file first
23/09/2008 16:10:04|smbesge5.mb.skoda.vwg|
dbwriter.ReportingDBWriter.run|E|Error in SQL Statement: SELECT ch_line
FROM sge_checkpoint WHERE ch_id=1

com.sun.grid.reporting.dbwriter.ReportingException: Error in SQL
Statement: SELECT ch_line FROM sge_checkpoint WHERE ch_id=1

com.sun.grid.reporting.dbwriter.db.Database.createSQLError(Database.java:359)

com.sun.grid.reporting.dbwriter.db.Database.executeQuery(Database.java:568)

com.sun.grid.reporting.dbwriter.file.FileParser.readCheckpoint(FileParser.java:237)

com.sun.grid.reporting.dbwriter.file.FileParser.processFile(FileParser.java:277)

com.sun.grid.reporting.dbwriter.ReportingDBWriter.processFile(ReportingDBWriter.java:1146)

com.sun.grid.reporting.dbwriter.ReportingDBWriter.mainLoop(ReportingDBWriter.java:1186)

com.sun.grid.reporting.dbwriter.ReportingDBWriter.run(ReportingDBWriter.java:1322)
                              Caused by
org.postgresql.util.PSQLException: ERROR: relation "sge_checkpoint" does
not exist


org.postgresql.util.PSQLException.parseServerError(PSQLException.java:139)

org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:156)

org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:101)

org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43)

org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:517)

org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:50)

org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:233)

org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:221)

com.sun.grid.reporting.dbwriter.db.Database.executeQuery(Database.java:563)

com.sun.grid.reporting.dbwriter.file.FileParser.readCheckpoint(FileParser.java:237)

23/09/2008 16:10:04|smbesge5.mb.skoda.vwg|
dbwriter.ReportingDBWriter.run|I|dbwriter stopped
--------------------------------------------------------

Do you have a best recommendation how to fix it?

Thanks


Petr

SGE 6.1u4, postgresql-8.1.11-0.2, SLES10 SP2, 2.6.16.60-0.23-xen

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe at gridengine.sunsource.net
For additional commands, e-mail: users-help at gridengine.sunsource.net




More information about the gridengine-users mailing list