[GE users] ARCO db error

Martin Frys Martin.Frys at Sun.COM
Mon Sep 29 10:51:30 BST 2008


    [ The following text is in the "ISO-8859-1" character set. ]
    [ Your display is set for the "ISO-8859-10" character set.  ]
    [ Some special characters may be displayed incorrectly. ]

Hi,

Have you checked that the table sge_checkpoint exists in the database? 
And what does it contain? Have you tried to restart the postmaster?

Martin Frys

Petr Horna wrote:
> 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
>
>   


-- 
Martin Frys
Sun Microsystems
Phone x44930/+420-2-33009 930


---------------------------------------------------------------------
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