Hi,
I tried to install and reinstall SDNC in many different ways but every time
Karaf on dev-sdnc-sdnc-0 is throwing the same exception every couple seconds:
2019-10-17T12:32:30,914 | ERROR | DBResourcemanagerWatchThread | ConnectionPool
| 152 - org.apache.tomcat.jdbc - 8.5.14 | - | Unable to
create initial connections of pool.
java.sql.SQLException: Unable to load class: org.mariadb.jdbc.Driver from
ClassLoader:org.eclipse.osgi.internal.loader.EquinoxClassLoader@2c6ab45b[org.apache.tomcat.jdbc:8.5.14(id=152)];ClassLoader:org.eclipse.osgi.internal.framework.Con
textFinder@5e56f644
at
org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:283)
[152:org.apache.tomcat.jdbc:8.5.14]
at
org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:203)
[152:org.apache.tomcat.jdbc:8.5.14]
at
org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:735)
[152:org.apache.tomcat.jdbc:8.5.14]
at
org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:667)
[152:org.apache.tomcat.jdbc:8.5.14]
at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:482)
[152:org.apache.tomcat.jdbc:8.5.14]
at org.apache.tomcat.jdbc.pool.ConnectionPool.<init>(ConnectionPool.java:154)
[152:org.apache.tomcat.jdbc:8.5.14]
at
org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:118)
[152:org.apache.tomcat.jdbc:8.5.14]
at
org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:107)
[152:org.apache.tomcat.jdbc:8.5.14]
at
org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:131)
[152:org.apache.tomcat.jdbc:8.5.14]
at
org.onap.ccsdk.sli.core.dblib.CachedDataSource.getConnection(CachedDataSource.java:121)
[225:org.onap.ccsdk.sli.core.dblib-provider:0.4.4]
at
org.onap.ccsdk.sli.core.dblib.CachedDataSource.testConnection(CachedDataSource.java:369)
[225:org.onap.ccsdk.sli.core.dblib-provider:0.4.4]
at
org.onap.ccsdk.sli.core.dblib.CachedDataSource.testConnection(CachedDataSource.java:359)
[225:org.onap.ccsdk.sli.core.dblib-provider:0.4.4]
at
org.onap.ccsdk.sli.core.dblib.DBResourceManager$RecoveryMgr.resetConnectionPool(DBResourceManager.java:442)
[225:org.onap.ccsdk.sli.core.dblib-provider:0.4.4]
at
org.onap.ccsdk.sli.core.dblib.DBResourceManager$RecoveryMgr.run(DBResourceManager.java:415)
[225:org.onap.ccsdk.sli.core.dblib-provider:0.4.4]
Caused by: java.lang.ClassNotFoundException: Unable to load class:
org.mariadb.jdbc.Driver from
ClassLoader:org.eclipse.osgi.internal.loader.EquinoxClassLoader@2c6ab45b[org.apache.tomcat.jdbc:8.5.14(id=152)];ClassLoader:org.eclipse.osgi.
internal.framework.ContextFinder@5e56f644
at
org.apache.tomcat.jdbc.pool.ClassLoaderUtil.loadClass(ClassLoaderUtil.java:56)
~[?:?]
at
org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:271)
~[?:?]
... 13 more
Caused by: java.lang.ClassNotFoundException: org.mariadb.jdbc.Driver
at java.net.URLClassLoader.findClass(URLClassLoader.java:382) ~[?:?]
at java.lang.ClassLoader.loadClass(ClassLoader.java:424) ~[?:?]
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349) ~[?:?]
at java.lang.ClassLoader.loadClass(ClassLoader.java:357) ~[?:?]
at
org.eclipse.osgi.internal.framework.ContextFinder.loadClass(ContextFinder.java:132)
~[?:?]
at java.lang.ClassLoader.loadClass(ClassLoader.java:357) ~[?:?]
at java.lang.Class.forName0(Native Method) ~[?:?]
at java.lang.Class.forName(Class.java:348) ~[?:?]
at
org.apache.tomcat.jdbc.pool.ClassLoaderUtil.loadClass(ClassLoaderUtil.java:38)
~[?:?]
at
org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:271)
~[?:?]
... 13 more
2019-10-17T12:32:30,917 | INFO | DBResourcemanagerWatchThread |
CachedDataSource | 225 - org.onap.ccsdk.sli.core.dblib-provider
- 0.4.4 | - | SQL DataSource < sdnctldb01 > test failed. Cause : Unable to
load class: org
.mariadb.jdbc.Driver from
ClassLoader:org.eclipse.osgi.internal.loader.EquinoxClassLoader@2c6ab45b[org.apache.tomcat.jdbc:8.5.14(id=152)];ClassLoader:org.eclipse.osgi.internal.framework.ContextFinder@5e56f644>
test failed. Cause : {}
and if I try to use SDNC it responds with " SQL query failed ". Robot health
check for SDNC fails with:
Resolving variable '${resp.json()['output']['response-code']}' failed:
JSONDecodeError: Expecting value: line 1 column 1 (char 0)
I can easily connect from dev-sdnc-sdnc-0 to mariadb-galera databases, sdnctl
database is populated and tables exist.
Did any of you encountered this before? I would be grateful for any tips and
hints how to solve this issue.
Thanks,
Marek Szwałkiewicz
-=-=-=-=-=-=-=-=-=-=-=-
Links: You receive all messages sent to this group.
View/Reply Online (#19212): https://lists.onap.org/g/onap-discuss/message/19212
Mute This Topic: https://lists.onap.org/mt/34701783/21656
Mute #sdnc: https://lists.onap.org/mk?hashtag=sdnc&subid=2740164
Group Owner: [email protected]
Unsubscribe: https://lists.onap.org/g/onap-discuss/unsub
[[email protected]]
-=-=-=-=-=-=-=-=-=-=-=-
