perfSONAR User Q&A and Other Discussion

["Liu, Dengfeng (NIH/CIT) [C]" <>]

Thank you Andrew; You are right, the skipTableBuild is set to 1 and after change to 0, working fine.

Another problem is how to disble http and use https exclusively? when I use https, mouse click on the dashboard not working, while working fine when using http.

Dengfeng

---

From: Andrew Lake <>
Sent: Tuesday, April 25, 2017 2:24 PM
To: Liu, Dengfeng (NIH/CIT) [C]; perfsonar-user
Subject: Re: [perfsonar-user] maddash erros

 

Hi,

In, your /etc/maddash/maddash-server/maddash.yaml file do you have “skipTableBuild” set to 0? If so set it to 1 and restart maddash-server. It looks like your database did not get upgraded.

Thanks,

Andy

On April 25, 2017 at 1:39:09 PM, Liu, Dengfeng (NIH/CIT) [C] () wrote:

After upgrade, maddash can not boot with this error, any suggestion?

#######################################################

SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
MLog initialization issue: slf4j found no binding or threatened to use its (dangerously silent) NOPLogger. We consider the slf4j library not found.
java.sql.SQLDataException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type 'java.sql.Clob'.
    at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
    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.Util.generateCsSQLException(Unknown Source)
    at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown Source)
    at org.apache.derby.impl.jdbc.ConnectionChild.newSQLException(Unknown Source)
    at org.apache.derby.impl.jdbc.EmbedPreparedStatement.dataTypeConversion(Unknown Source)
    at org.apache.derby.impl.jdbc.EmbedPreparedStatement.checkClobConditions(Unknown Source)
    at org.apache.derby.impl.jdbc.EmbedPreparedStatement.setClob(Unknown Source)
    at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.setClob(NewProxyPreparedStatement.java:1164)
    at net.es.maddash.ConfigLoader.load(ConfigLoader.java:214)
    at net.es.maddash.MaDDashGlobals.load(MaDDashGlobals.java:297)
    at net.es.maddash.MaDDashGlobals.<init>(MaDDashGlobals.java:188)
    at net.es.maddash.MaDDashGlobals.getInstance(MaDDashGlobals.java:506)
    at net.es.maddash.Invoker.main(Invoker.java:55)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at com.simontuffs.onejar.Boot.run(Boot.java:340)
    at com.simontuffs.onejar.Boot.main(Boot.java:166)
Caused by: ERROR 22005: An attempt was made to get a data value of type 'VARCHAR' from a data value of type 'java.sql.Clob'.
    at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
    at org.apache.derby.impl.jdbc.SQLExceptionFactory.wrapArgsForTransportAcrossDRDA(Unknown Source)
    ... 21 more
Initialization error: Error loading database: An attempt was made to get a data value of type 'VARCHAR' from a data value of type 'java.sql.Clob'.
java.lang.RuntimeException: Error loading database: An attempt was made to get a data value of type 'VARCHAR' from a data value of type 'java.sql.Clob'.
    at net.es.maddash.ConfigLoader.load(ConfigLoader.java:482)
    at net.es.maddash.MaDDashGlobals.load(MaDDashGlobals.java:297)
    at net.es.maddash.MaDDashGlobals.<init>(MaDDashGlobals.java:188)
    at net.es.maddash.MaDDashGlobals.getInstance(MaDDashGlobals.java:506)
    at net.es.maddash.Invoker.main(Invoker.java:55)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at com.simontuffs.onejar.Boot.run(Boot.java:340)
    at com.simontuffs.onejar.Boot.main(Boot.java:166)