perfSONAR User Q&A and Other Discussion

[HADJALI Mehdi <>]

Hello community,

 

I have a maddash server that at the service level stops after a few seconds after restarting it.

 

I find this error when I run this command : cat /var/log/maddash/maddash-server.out

 

org.apache.derby.shared.common.error.DerbySQLIntegrityConstraintViolationException: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'GRIDSGRIDNAME' defined on 'GRIDS'.

        at org.apache.derby.impl.jdbc.SQLExceptionFactory.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.EmbedStatement.executeStatement(Unknown Source)

        at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)

        at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(Unknown Source)

        at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source)

        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)

        at net.es.maddash.ConfigLoader.load(ConfigLoader.java:381)

        at net.es.maddash.MaDDashGlobals.load(MaDDashGlobals.java:305)

        at net.es.maddash.MaDDashGlobals.<init>(MaDDashGlobals.java:188)

        at net.es.maddash.MaDDashGlobals.getInstance(MaDDashGlobals.java:520)

        at net.es.maddash.Invoker.main(Invoker.java:55)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

        at java.lang.reflect.Method.invoke(Method.java:498)

        at com.simontuffs.onejar.Boot.run(Boot.java:340)

        at com.simontuffs.onejar.Boot.main(Boot.java:166)

Caused by: ERROR 23505: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'GRIDSGRIDNAME' defined on 'GRIDS'.

        at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)

        at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)

        at org.apache.derby.impl.sql.execute.IndexChanger.insertAndCheckDups(Unknown Source)

        at org.apache.derby.impl.sql.execute.IndexChanger.doInsert(Unknown Source)

        at org.apache.derby.impl.sql.execute.IndexChanger.insert(Unknown Source)

        at org.apache.derby.impl.sql.execute.IndexSetChanger.insert(Unknown Source)

        at org.apache.derby.impl.sql.execute.RowChangerImpl.insertRow(Unknown Source)

        at org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown Source)

        at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source)

        at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)

        at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)

        ... 16 more

Initialization error: Error loading database: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'GRIDSGRIDNAME' defined on 'GRIDS'.

java.lang.RuntimeException: Error loading database: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'GRIDSGRIDNAME' defined on 'GRIDS'.

        at net.es.maddash.ConfigLoader.load(ConfigLoader.java:483)

        at net.es.maddash.MaDDashGlobals.load(MaDDashGlobals.java:305)

        at net.es.maddash.MaDDashGlobals.<init>(MaDDashGlobals.java:188)

        at net.es.maddash.MaDDashGlobals.getInstance(MaDDashGlobals.java:520)

        at net.es.maddash.Invoker.main(Invoker.java:55)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

        at java.lang.reflect.Method.invoke(Method.java:498)

        at com.simontuffs.onejar.Boot.run(Boot.java:340)

        at com.simontuffs.onejar.Boot.main(Boot.java:166)

 

I feel like there's a problem with either Apache or the database.

 

Thanks in advance for your help

 

Cordialement / Regards

Mehdi HADJALI

DSI Network & Telecom

Sopra Steria

Tour Chantecoq
5, rue Chantecoq

92800 Puteaux Cedex - France
Phone: +33 (0)1 47 17 23 04
- www.soprasteria.com