You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cloudstack.apache.org by Vivek Kumar <vi...@indiqus.com.INVALID> on 2022/10/10 17:35:23 UTC
Usage server giving connection error on mysql
Hello Folks,
I have installed a management server where it’s able to connect to the cloud DB, even on the same machine management-server is working find and getting the details from cloud DB, but when I am starting the cloud_usage services it’s giving me error that couldn’t connect to the DB.
I have checked the password from DB.properties file, db.cloud.password and db.cloud_usage.password is same, I have tried to dechiper that they are same. Please find the logs below, if anyone can help what else to took at. If the password and connection is wrong then how come my management is running perfectly fine, and db.properties and key is a soft link to management’s db.properties and key.
Any help would be appreciated.
[root@acs-mgmt-03 ~]# /usr/bin/java -Dpid=105674 -Xms256m -Xmx2048m -cp /usr/share/cloudstack-usage/*:/usr/share/cloudstack-usage/lib/*:/usr/share/cloudstack-mysql-ha/lib/*:/etc/cloudstack/usage:/usr/share/java/mysql-connector-java.jar com.cloud.usage.UsageServer
log4j:WARN No appenders could be found for logger (com.cloud.utils.LogUtils).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
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.
WARNING: An illegal reflective access operation has occurred
WARNING: Illegal reflective access by net.sf.cglib.core.ReflectUtils$1 (file:/usr/share/cloudstack-usage/lib/cglib-nodep-3.3.0.jar) to method java.lang.ClassLoader.defineClass(java.lang.String,byte[],int,int,java.security.ProtectionDomain)
WARNING: Please consider reporting this to the maintainers of net.sf.cglib.core.ReflectUtils$1
WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations
WARNING: All illegal access operations will be denied in a future release
17:29:24,503 INFO Transaction:1027 - Is Data Base High Availiability enabled? Ans : false
Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
17:29:25,307 INFO ComponentContext:59 - Setup Spring Application context
17:29:25,581 INFO ComponentContext:108 - Configuring org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_e34a5239
17:29:25,581 INFO ComponentContext:108 - Configuring com.cloud.user.dao.UserStatsLogDaoImpl_EnhancerByCloudStack_71143423
17:29:25,582 INFO ComponentContext:108 - Configuring com.cloud.usage.dao.UsageVMSnapshotDaoImpl_EnhancerByCloudStack_ed7fd69f
17:29:25,582 INFO ComponentContext:108 - Configuring com.cloud.event.dao.UsageEventDaoImpl_EnhancerByCloudStack_d49a40ad
17:29:25,582 INFO ComponentContext:108 - Configuring com.cloud.domain.dao.DomainDaoImpl_EnhancerByCloudStack_64186150
17:29:25,582 INFO ComponentContext:108 - Configuring org.apache.cloudstack.quota.dao.UserVmDetailsDaoImpl_EnhancerByCloudStack_ad02d4e3
17:29:25,582 INFO ComponentContext:108 - Configuring com.cloud.user.dao.SSHKeyPairDaoImpl_EnhancerByCloudStack_c6fd775a
17:29:25,582 INFO ComponentContext:108 - Configuring com.cloud.usage.dao.UsageVmDiskDaoImpl_EnhancerByCloudStack_d213957e
17:29:25,582 INFO ComponentContext:108 - Configuring com.cloud.user.dao.UserStatisticsDaoImpl_EnhancerByCloudStack_eea571f5
17:29:25,582 INFO ComponentContext:108 - Configuring org.apache.cloudstack.quota.dao.QuotaUsageDaoImpl_EnhancerByCloudStack_b12520b4
17:29:25,582 INFO ComponentContext:108 - Configuring com.cloud.usage.dao.UsageVPNUserDaoImpl_EnhancerByCloudStack_c3eb5a9f
17:29:25,583 INFO ComponentContext:108 - Configuring com.cloud.event.dao.EventDaoImpl_EnhancerByCloudStack_92924530
17:29:25,583 INFO ComponentContext:108 - Configuring com.cloud.usage.dao.UsageLoadBalancerPolicyDaoImpl_EnhancerByCloudStack_37f7c74
17:29:25,583 INFO ComponentContext:108 - Configuring com.cloud.user.dao.UserAccountDaoImpl_EnhancerByCloudStack_1d64a023
17:29:25,583 INFO ComponentContext:108 - Configuring com.cloud.usage.dao.UsageStorageDaoImpl_EnhancerByCloudStack_676f39a3
17:29:25,584 INFO ComponentContext:108 - Configuring com.cloud.configuration.dao.ResourceCountDaoImpl_EnhancerByCloudStack_70547415
17:29:25,584 INFO ComponentContext:108 - Configuring org.apache.cloudstack.quota.dao.QuotaBalanceDaoImpl_EnhancerByCloudStack_6bd766c1
17:29:25,584 INFO ComponentContext:108 - Configuring com.cloud.usage.dao.UsageVMInstanceDaoImpl_EnhancerByCloudStack_d215a366
17:29:25,584 INFO ComponentContext:108 - Configuring org.apache.cloudstack.quota.dao.QuotaEmailTemplatesDaoImpl_EnhancerByCloudStack_cd8d2c06
17:29:25,584 INFO ComponentContext:108 - Configuring com.cloud.user.dao.AccountDaoImpl_EnhancerByCloudStack_89d68960
17:29:25,584 INFO ComponentContext:108 - Configuring com.cloud.usage.dao.UsageJobDaoImpl_EnhancerByCloudStack_14b80f91
17:29:25,584 INFO ComponentContext:108 - Configuring org.apache.cloudstack.quota.dao.QuotaTariffDaoImpl_EnhancerByCloudStack_9c5f6c87
17:29:25,584 INFO ComponentContext:108 - Configuring com.cloud.usage.dao.ExternalPublicIpStatisticsDaoImpl_EnhancerByCloudStack_92220bff
17:29:25,584 INFO ComponentContext:108 - Configuring com.cloud.event.dao.UsageEventDetailsDaoImpl_EnhancerByCloudStack_375866a9
17:29:25,585 INFO ComponentContext:108 - Configuring com.cloud.configuration.dao.ResourceLimitDaoImpl_EnhancerByCloudStack_8a16d989
17:29:25,585 INFO ComponentContext:108 - Configuring com.cloud.alert.dao.AlertDaoImpl_EnhancerByCloudStack_11a80a8c
17:29:25,585 INFO ComponentContext:108 - Configuring org.apache.cloudstack.quota.dao.ServiceOfferingDaoImpl_EnhancerByCloudStack_358cbd0
17:29:25,585 INFO ComponentContext:108 - Configuring com.cloud.user.dao.VmDiskStatisticsDaoImpl_EnhancerByCloudStack_dca34224
17:29:25,585 INFO ComponentContext:108 - Configuring com.cloud.usage.dao.UsagePortForwardingRuleDaoImpl_EnhancerByCloudStack_d0652388
17:29:25,585 INFO ComponentContext:108 - Configuring com.cloud.usage.dao.UsageNetworkDaoImpl_EnhancerByCloudStack_712152b8
17:29:25,585 INFO ComponentContext:108 - Configuring com.cloud.usage.dao.UsageVolumeDaoImpl_EnhancerByCloudStack_b241eee8
17:29:25,585 INFO ComponentContext:108 - Configuring com.cloud.user.dao.UserDaoImpl_EnhancerByCloudStack_2a90c3f0
17:29:25,585 INFO ComponentContext:108 - Configuring com.cloud.usage.dao.UsageNetworkOfferingDaoImpl_EnhancerByCloudStack_636bee22
17:29:25,585 INFO ComponentContext:108 - Configuring com.cloud.usage.dao.UsageVMSnapshotOnPrimaryDaoImpl_EnhancerByCloudStack_ed869b6e
17:29:25,586 INFO ComponentContext:108 - Configuring com.cloud.usage.dao.UsageBackupDaoImpl_EnhancerByCloudStack_6a940000
17:29:25,586 INFO ComponentContext:108 - Configuring com.cloud.usage.dao.UsageSecurityGroupDaoImpl_EnhancerByCloudStack_9cbea2df
17:29:25,586 INFO ComponentContext:108 - Configuring com.cloud.usage.dao.UsageIPAddressDaoImpl_EnhancerByCloudStack_8f89d561
17:29:25,586 INFO ComponentContext:108 - Configuring org.apache.cloudstack.quota.dao.QuotaAccountDaoImpl_EnhancerByCloudStack_d6e28308
17:29:25,586 INFO ComponentContext:108 - Configuring org.apache.cloudstack.quota.dao.QuotaCreditsDaoImpl_EnhancerByCloudStack_86f65ad3
17:29:25,586 INFO ComponentContext:108 - Configuring com.cloud.usage.dao.UsageDaoImpl_EnhancerByCloudStack_db469b32
17:29:25,586 INFO ComponentContext:108 - Configuring com.cloud.usage.UsageManagerImpl_EnhancerByCloudStack_b63073a9
17:29:25,586 INFO UsageManagerImpl:208 - Implementation Version is 4.15.1.0
Exception in thread "main" com.cloud.utils.exception.CloudRuntimeException: DB Exception on: null
at com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(GenericDaoBase.java:423)
at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_e34a5239.CGLIB$searchIncludingRemoved$51(<generated>)
at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_e34a5239_FastClassByCloudStack_f73b4cff.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228)
at com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:122)
at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_e34a5239.searchIncludingRemoved(<generated>)
at com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(GenericDaoBase.java:359)
at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_e34a5239.CGLIB$searchIncludingRemoved$52(<generated>)
at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_e34a5239_FastClassByCloudStack_f73b4cff.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228)
at com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:122)
at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_e34a5239.searchIncludingRemoved(<generated>)
at com.cloud.utils.db.GenericDaoBase.listIncludingRemovedBy(GenericDaoBase.java:932)
at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_e34a5239.CGLIB$listIncludingRemovedBy$80(<generated>)
at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_e34a5239_FastClassByCloudStack_f73b4cff.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228)
at com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:122)
at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_e34a5239.listIncludingRemovedBy(<generated>)
at com.cloud.utils.db.GenericDaoBase.listIncludingRemovedBy(GenericDaoBase.java:937)
at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_e34a5239.CGLIB$listIncludingRemovedBy$81(<generated>)
at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_e34a5239_FastClassByCloudStack_f73b4cff.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228)
at com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:122)
at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_e34a5239.listIncludingRemovedBy(<generated>)
at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl.getConfiguration(ConfigurationDaoImpl.java:78)
at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_e34a5239.CGLIB$getConfiguration$7(<generated>)
at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_e34a5239_FastClassByCloudStack_f73b4cff.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228)
at com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:122)
at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_e34a5239.getConfiguration(<generated>)
at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl.getConfiguration(ConfigurationDaoImpl.java:105)
at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_e34a5239.CGLIB$getConfiguration$8(<generated>)
at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_e34a5239_FastClassByCloudStack_f73b4cff.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228)
at com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:122)
at org.apache.cloudstack.framework.config.dao.ConfigurationDaoImpl_EnhancerByCloudStack_e34a5239.getConfiguration(<generated>)
at com.cloud.usage.UsageManagerImpl.configure(UsageManagerImpl.java:211)
at com.cloud.utils.component.ComponentContext.initComponentsLifeCycle(ComponentContext.java:116)
at com.cloud.usage.UsageServer.start(UsageServer.java:54)
at com.cloud.usage.UsageServer.main(UsageServer.java:41)
Caused by: java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:906)
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:831)
at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456)
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246)
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:197)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:228)
at org.apache.commons.dbcp2.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:121)
at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:357)
at org.apache.commons.pool2.impl.GenericObjectPool.create(GenericObjectPool.java:918)
at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:431)
at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:356)
at org.apache.commons.dbcp2.PoolingDataSource.getConnection(PoolingDataSource.java:134)
at com.cloud.utils.db.TransactionLegacy.getConnection(TransactionLegacy.java:555)
at com.cloud.utils.db.TransactionLegacy.prepareStatement(TransactionLegacy.java:466)
at com.cloud.utils.db.TransactionLegacy.prepareAutoCloseStatement(TransactionLegacy.java:459)
at com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(GenericDaoBase.java:396)
... 39 more
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
at com.mysql.cj.protocol.a.NativeProtocol.negotiateSSLConnection(NativeProtocol.java:338)
at com.mysql.cj.protocol.a.NativeAuthenticationProvider.negotiateSSLConnection(NativeAuthenticationProvider.java:777)
at com.mysql.cj.protocol.a.NativeAuthenticationProvider.proceedHandshakeWithPluggableAuthentication(NativeAuthenticationProvider.java:486)
at com.mysql.cj.protocol.a.NativeAuthenticationProvider.connect(NativeAuthenticationProvider.java:202)
at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1340)
at com.mysql.cj.NativeSession.connect(NativeSession.java:157)
at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:850)
... 55 more
Caused by: javax.net.ssl.SSLHandshakeException: No appropriate protocol (protocol is disabled or cipher suites are inappropriate)
at java.base/sun.security.ssl.HandshakeContext.<init>(HandshakeContext.java:170)
at java.base/sun.security.ssl.ClientHandshakeContext.<init>(ClientHandshakeContext.java:103)
at java.base/sun.security.ssl.TransportContext.kickstart(TransportContext.java:222)
at java.base/sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:449)
at java.base/sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:427)
at com.mysql.cj.protocol.ExportControlled.performTlsHandshake(ExportControlled.java:336)
at com.mysql.cj.protocol.StandardSocketFactory.performTlsHandshake(StandardSocketFactory.java:188)
at com.mysql.cj.protocol.a.NativeSocketConnection.performTlsHandshake(NativeSocketConnection.java:99)
at com.mysql.cj.protocol.a.NativeProtocol.negotiateSSLConnection(NativeProtocol.java:329)
... 61 more
Vivek Kumar
Sr. Manager - Cloud & DevOps
TechOps | Indiqus Technologies
vivek.kumar@indiqus.com <ma...@indiqus.com>
www.indiqus.com <https://www.indiqus.com/>
--
This message is intended only for the use of the individual or entity to
which it is addressed and may contain confidential and/or privileged
information. If you are not the intended recipient, please delete the
original message and any copy of it from your computer system. You are
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited unless proper authorization has been
obtained for such action. If you have received this communication in error,
please notify the sender immediately. Although IndiQus attempts to sweep
e-mail and attachments for viruses, it does not guarantee that both are
virus-free and accepts no liability for any damage sustained as a result of
viruses.