perfSONAR User Q&A and Other Discussion

["Andrew Lake" <>]

Hi Roderick,

It looks like your database got corrupted somehow. The easiest way to fix it is to clear out the last few days of alert history (whether something was red, yellow, green, or orange) and restart maddash. You will NOT lose any of your measurements since they are stored in the measurement archives and the database in question is just the alert history. Run the following:

rm -rf /var/lib/maddash/* 

/sbin/service maddash-server restart

When it comes back up and you load the page your boxes will likely all be gray. That will change as maddash has a chance to run and fill-in the status of each check.

Thanks,

Andy

On Tue, Aug 4, 2015 at 7:28 AM, Roderick Mooi <> wrote:

Hi

Our MaDDash recently stopped working. In the maddash-server.log we get the following errors:

ERROR 2015-08-03 00:04:23,872 Error executing CheckSchedulerJob: The conglomerate (6,161) requested does not exist.
ERROR 2015-08-03 00:04:44,105 Error scheduling job The conglomerate (6,161) requested does not exist.
ERROR 2015-08-03 00:04:45,641 Error executing CheckSchedulerJob: The conglomerate (6,161) requested does not exist.
ERROR 2015-08-03 00:05:05,837 Error scheduling job The conglomerate (6,161) requested does not exist.
ERROR 2015-08-03 00:05:07,371 Error executing CheckSchedulerJob: The conglomerate (6,161) requested does not exist.
ERROR 2015-08-03 00:05:17,261 Error cleaning database The conglomerate (6,353) requested does not exist.
…

and maddash-server.out:

java.sql.SQLException: The conglomerate (6,161) requested does not exist.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement40.<init>(Unknown Source)
at org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:213)
at net.es.maddash.jobs.CheckSchedulerJob.execute(CheckSchedulerJob.java:75)
at net.es.maddash.jobs.CheckSchedulerJob.run(CheckSchedulerJob.java:44)
Caused by: java.sql.SQLException: The conglomerate (6,161) requested does not exist.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 16 more
Caused by: ERROR XSAI2: The conglomerate (6,161) requested does not exist.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.store.access.btree.index.B2IFactory.readConglomerate(Unknown Source)
at org.apache.derby.impl.store.access.RAMAccessManager.conglomCacheFind(Unknown Source)
at org.apache.derby.impl.store.access.RAMTransaction.findExistingConglomerate(Unknown Source)
at org.apache.derby.impl.store.access.RAMTransaction.openStoreCost(Unknown Source)
at org.apache.derby.impl.sql.compile.CompilerContextImpl.getStoreCostController(Unknown Source)
at org.apache.derby.impl.sql.compile.FromBaseTable.getStoreCostController(Unknown Source)
at org.apache.derby.impl.sql.compile.FromBaseTable.estimateCost(Unknown Source)
at org.apache.derby.impl.sql.compile.OptimizerImpl.estimateTotalCost(Unknown Source)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costBasedCostOptimizable(Unknown Source)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costOptimizable(Unknown Source)
at org.apache.derby.impl.sql.compile.FromBaseTable.optimizeIt(Unknown Source)
at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(Unknown Source)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Unknown Source)
at org.apache.derby.impl.sql.compile.SelectNode.optimize(Unknown Source)
at org.apache.derby.impl.sql.compile.DMLStatementNode.optimizeStatement(Unknown Source)
at org.apache.derby.impl.sql.compile.CursorNode.optimizeStatement(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)
... 10 more

Any ideas?

Thanks,

Roderick
--
This message is subject to the CSIR's copyright terms and conditions, e-mail legal notice, and implemented Open Document Format (ODF) standard.
The full disclaimer details can be found at http://www.csir.co.za/disclaimer.html.

This message has been scanned for viruses and dangerous content by MailScanner,
and is believed to be clean.

Please consider the environment before printing this email.