search

wso2 / product-sp

An open source, cloud-native streaming data integration and analytics product optimized for agile digital businesses
https://wso2.com/analytics-and-stream-processing/
Apache License 2.0
119 stars 132 forks source link

Latest MySQL doest not work for cluster coordination #925

Open sybernix opened 5 years ago

sybernix commented 5 years ago

Description: I was trying to set up minimum HA deployment with Kafka. I used MySQL for cluster coordination and file based persistence. While starting the first active node SQLSyntaxErrorException is thrown with a message "Specified key was too long; max key length is 3072 bytes". However, this error did not appear when using MySQL 5.6 deployed from Docker. Please find the logs below;

Niruhans-MacBook-Pro:bin niruhan$ ./worker.sh JAVA_HOME environment variable is set to /Library/Java/JavaVirtualMachines/jdk1.8.0_201.jdk/Contents/Home CARBON_HOME environment variable is set to /Users/niruhan/Desktop/wso2sp-4.3.0-2 RUNTIME_HOME environment variable is set to /Users/niruhan/Desktop/wso2sp-4.3.0-2/wso2/worker osgi> [2019-03-08 10:31:54,466] INFO {org.wso2.msf4j.internal.websocket.WebSocketServerSC} - All required capabilities are available of WebSocket service component is available. [2019-03-08 10:31:54,560] INFO {org.wso2.carbon.metrics.core.config.model.JmxReporterConfig} - Creating JMX reporter for Metrics with domain 'org.wso2.carbon.metrics' [2019-03-08 10:31:54,570] INFO {org.wso2.msf4j.analytics.metrics.MetricsComponent} - Metrics Component is activated [2019-03-08 10:31:54,573] INFO {org.wso2.carbon.databridge.agent.internal.DataAgentDS} - Successfully deployed Agent Server Loading class com.mysql.jdbc.Driver'. This is deprecated. The new driver class iscom.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. [2019-03-08 10:32:01,999] ERROR {org.eclipse.equinox.ds} - [SCR] Exception while activating instance org.wso2.carbon.cluster.coordinator.rdbms.internal.RDBMSCoordinationServiceComponent@457eed5f of component org.wso2.carbon.cluster.coordinator.rdbms.internal.RDBMSCoordinationServiceComponent java.lang.reflect.InvocationTargetException 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 org.eclipse.equinox.internal.ds.model.ServiceComponent.activate(ServiceComponent.java:235) at org.eclipse.equinox.internal.ds.model.ServiceComponentProp.activate(ServiceComponentProp.java:146) at org.eclipse.equinox.internal.ds.model.ServiceComponentProp.build(ServiceComponentProp.java:345) at org.eclipse.equinox.internal.ds.InstanceProcess.buildComponent(InstanceProcess.java:620) at org.eclipse.equinox.internal.ds.InstanceProcess.buildComponents(InstanceProcess.java:197) at org.eclipse.equinox.internal.ds.Resolver.getEligible(Resolver.java:343) at org.eclipse.equinox.internal.ds.SCRManager.serviceChanged(SCRManager.java:222) at org.eclipse.osgi.internal.serviceregistry.FilteredServiceListener.serviceChanged(FilteredServiceListener.java:109) at org.eclipse.osgi.internal.framework.BundleContextImpl.dispatchEvent(BundleContextImpl.java:915) at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230) at org.eclipse.osgi.framework.eventmgr.ListenerQueue.dispatchEventSynchronous(ListenerQueue.java:148) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEventPrivileged(ServiceRegistry.java:862) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEvent(ServiceRegistry.java:801) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistrationImpl.register(ServiceRegistrationImpl.java:127) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.registerService(ServiceRegistry.java:225) at org.eclipse.osgi.internal.framework.BundleContextImpl.registerService(BundleContextImpl.java:464) at org.eclipse.osgi.internal.framework.BundleContextImpl.registerService(BundleContextImpl.java:482) at org.eclipse.osgi.internal.framework.BundleContextImpl.registerService(BundleContextImpl.java:999) at org.wso2.carbon.datasource.core.internal.DataSourceListenerComponent.onAllRequiredCapabilitiesAvailable(DataSourceListenerComponent.java:128) at org.wso2.carbon.kernel.internal.startupresolver.StartupComponentManager.lambda$notifySatisfiableComponents$7(StartupComponentManager.java:266) at java.util.ArrayList.forEach(ArrayList.java:1257) at org.wso2.carbon.kernel.internal.startupresolver.StartupComponentManager.notifySatisfiableComponents(StartupComponentManager.java:252) at org.wso2.carbon.kernel.internal.startupresolver.StartupOrderResolver$1.run(StartupOrderResolver.java:204) at java.util.TimerThread.mainLoop(Timer.java:555) at java.util.TimerThread.run(Timer.java:505) Caused by: org.wso2.carbon.cluster.coordinator.commons.exception.ClusterCoordinationException: Could not create table CLUSTER_NODE_STATUS_TABLE at org.wso2.carbon.cluster.coordinator.rdbms.RDBMSCommunicationBusContextImpl.createTableIfNotExist(RDBMSCommunicationBusContextImpl.java:192) at org.wso2.carbon.cluster.coordinator.rdbms.RDBMSCommunicationBusContextImpl.createTables(RDBMSCommunicationBusContextImpl.java:133) at org.wso2.carbon.cluster.coordinator.rdbms.RDBMSCommunicationBusContextImpl.(RDBMSCommunicationBusContextImpl.java:101) at org.wso2.carbon.cluster.coordinator.rdbms.RDBMSCoordinationStrategy.(RDBMSCoordinationStrategy.java:104) at org.wso2.carbon.cluster.coordinator.rdbms.internal.RDBMSCoordinationServiceComponent.start(RDBMSCoordinationServiceComponent.java:78) ... 29 more Caused by: java.sql.SQLSyntaxErrorException: Specified key was too long; max key length is 3072 bytes at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.StatementImpl.executeUpdateInternal(StatementImpl.java:1355) at com.mysql.cj.jdbc.StatementImpl.executeLargeUpdate(StatementImpl.java:2128) at com.mysql.cj.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1264) at com.zaxxer.hikari.proxy.StatementProxy.executeUpdate(StatementProxy.java:119) at com.zaxxer.hikari.proxy.HikariStatementProxy.executeUpdate(HikariStatementProxy.java) at org.wso2.carbon.cluster.coordinator.rdbms.RDBMSCommunicationBusContextImpl.createTableIfNotExist(RDBMSCommunicationBusContextImpl.java:189) ... 33 more

[2019-03-08 10:32:02,008] INFO {org.wso2.carbon.metrics.jdbc.core.config.model.JdbcReporterConfig} - Creating JDBC reporter for Metrics with source 'wso2-sp2', data source 'java:comp/env/jdbc/WSO2MetricsDB' and 60 seconds polling period [2019-03-08 10:32:02,027] ERROR {org.eclipse.equinox.ds} - [SCR] Exception while activating instance org.wso2.carbon.cluster.coordinator.rdbms.internal.RDBMSCoordinationServiceComponent@2663b48a of component org.wso2.carbon.cluster.coordinator.rdbms.internal.RDBMSCoordinationServiceComponent java.lang.reflect.InvocationTargetException 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 org.eclipse.equinox.internal.ds.model.ServiceComponent.activate(ServiceComponent.java:235) at org.eclipse.equinox.internal.ds.model.ServiceComponentProp.activate(ServiceComponentProp.java:146) at org.eclipse.equinox.internal.ds.model.ServiceComponentProp.build(ServiceComponentProp.java:345) at org.eclipse.equinox.internal.ds.InstanceProcess.buildComponent(InstanceProcess.java:620) at org.eclipse.equinox.internal.ds.InstanceProcess.buildComponents(InstanceProcess.java:197) at org.eclipse.equinox.internal.ds.Resolver.getEligible(Resolver.java:343) at org.eclipse.equinox.internal.ds.SCRManager.serviceChanged(SCRManager.java:222) at org.eclipse.osgi.internal.serviceregistry.FilteredServiceListener.serviceChanged(FilteredServiceListener.java:109) at org.eclipse.osgi.internal.framework.BundleContextImpl.dispatchEvent(BundleContextImpl.java:915) at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230) at org.eclipse.osgi.framework.eventmgr.ListenerQueue.dispatchEventSynchronous(ListenerQueue.java:148) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEventPrivileged(ServiceRegistry.java:862) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEvent(ServiceRegistry.java:801) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistrationImpl.register(ServiceRegistrationImpl.java:127) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.registerService(ServiceRegistry.java:225) at org.eclipse.osgi.internal.framework.BundleContextImpl.registerService(BundleContextImpl.java:464) at org.eclipse.equinox.internal.ds.InstanceProcess.registerService(InstanceProcess.java:536) at org.eclipse.equinox.internal.ds.InstanceProcess.buildComponents(InstanceProcess.java:260) at org.eclipse.equinox.internal.ds.Resolver.getEligible(Resolver.java:343) at org.eclipse.equinox.internal.ds.SCRManager.serviceChanged(SCRManager.java:222) at org.eclipse.osgi.internal.serviceregistry.FilteredServiceListener.serviceChanged(FilteredServiceListener.java:109) at org.eclipse.osgi.internal.framework.BundleContextImpl.dispatchEvent(BundleContextImpl.java:915) at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230) at org.eclipse.osgi.framework.eventmgr.ListenerQueue.dispatchEventSynchronous(ListenerQueue.java:148) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEventPrivileged(ServiceRegistry.java:862) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEvent(ServiceRegistry.java:801) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistrationImpl.register(ServiceRegistrationImpl.java:127) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.registerService(ServiceRegistry.java:225) at org.eclipse.osgi.internal.framework.BundleContextImpl.registerService(BundleContextImpl.java:464) at org.eclipse.osgi.internal.framework.BundleContextImpl.registerService(BundleContextImpl.java:482) at org.eclipse.osgi.internal.framework.BundleContextImpl.registerService(BundleContextImpl.java:999) at org.wso2.carbon.datasource.core.internal.DataSourceListenerComponent.onAllRequiredCapabilitiesAvailable(DataSourceListenerComponent.java:128) at org.wso2.carbon.kernel.internal.startupresolver.StartupComponentManager.lambda$notifySatisfiableComponents$7(StartupComponentManager.java:266) at java.util.ArrayList.forEach(ArrayList.java:1257) at org.wso2.carbon.kernel.internal.startupresolver.StartupComponentManager.notifySatisfiableComponents(StartupComponentManager.java:252) at org.wso2.carbon.kernel.internal.startupresolver.StartupOrderResolver$1.run(StartupOrderResolver.java:204) at java.util.TimerThread.mainLoop(Timer.java:555) at java.util.TimerThread.run(Timer.java:505) Caused by: org.wso2.carbon.cluster.coordinator.commons.exception.ClusterCoordinationException: Could not create table CLUSTER_NODE_STATUS_TABLE at org.wso2.carbon.cluster.coordinator.rdbms.RDBMSCommunicationBusContextImpl.createTableIfNotExist(RDBMSCommunicationBusContextImpl.java:192) at org.wso2.carbon.cluster.coordinator.rdbms.RDBMSCommunicationBusContextImpl.createTables(RDBMSCommunicationBusContextImpl.java:133) at org.wso2.carbon.cluster.coordinator.rdbms.RDBMSCommunicationBusContextImpl.(RDBMSCommunicationBusContextImpl.java:101) at org.wso2.carbon.cluster.coordinator.rdbms.RDBMSCoordinationStrategy.(RDBMSCoordinationStrategy.java:104) at org.wso2.carbon.cluster.coordinator.rdbms.internal.RDBMSCoordinationServiceComponent.start(RDBMSCoordinationServiceComponent.java:78) ... 42 more Caused by: java.sql.SQLSyntaxErrorException: Specified key was too long; max key length is 3072 bytes at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.StatementImpl.executeUpdateInternal(StatementImpl.java:1355) at com.mysql.cj.jdbc.StatementImpl.executeLargeUpdate(StatementImpl.java:2128) at com.mysql.cj.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1264) at com.zaxxer.hikari.proxy.StatementProxy.executeUpdate(StatementProxy.java:119) at com.zaxxer.hikari.proxy.HikariStatementProxy.executeUpdate(HikariStatementProxy.java) at org.wso2.carbon.cluster.coordinator.rdbms.RDBMSCommunicationBusContextImpl.createTableIfNotExist(RDBMSCommunicationBusContextImpl.java:189) ... 46 more

[2019-03-08 10:32:02,052] ERROR {org.eclipse.equinox.ds} - [SCR] Exception while activating instance org.wso2.carbon.cluster.coordinator.rdbms.internal.RDBMSCoordinationServiceComponent@2c811aeb of component org.wso2.carbon.cluster.coordinator.rdbms.internal.RDBMSCoordinationServiceComponent java.lang.reflect.InvocationTargetException 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 org.eclipse.equinox.internal.ds.model.ServiceComponent.activate(ServiceComponent.java:235) at org.eclipse.equinox.internal.ds.model.ServiceComponentProp.activate(ServiceComponentProp.java:146) at org.eclipse.equinox.internal.ds.model.ServiceComponentProp.build(ServiceComponentProp.java:345) at org.eclipse.equinox.internal.ds.InstanceProcess.buildComponent(InstanceProcess.java:620) at org.eclipse.equinox.internal.ds.InstanceProcess.buildComponents(InstanceProcess.java:197) at org.eclipse.equinox.internal.ds.Resolver.getEligible(Resolver.java:343) at org.eclipse.equinox.internal.ds.SCRManager.serviceChanged(SCRManager.java:222) at org.eclipse.osgi.internal.serviceregistry.FilteredServiceListener.serviceChanged(FilteredServiceListener.java:109) at org.eclipse.osgi.internal.framework.BundleContextImpl.dispatchEvent(BundleContextImpl.java:915) at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230) at org.eclipse.osgi.framework.eventmgr.ListenerQueue.dispatchEventSynchronous(ListenerQueue.java:148) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEventPrivileged(ServiceRegistry.java:862) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEvent(ServiceRegistry.java:801) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistrationImpl.register(ServiceRegistrationImpl.java:127) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.registerService(ServiceRegistry.java:225) at org.eclipse.osgi.internal.framework.BundleContextImpl.registerService(BundleContextImpl.java:464) at org.eclipse.osgi.internal.framework.BundleContextImpl.registerService(BundleContextImpl.java:482) at org.eclipse.osgi.internal.framework.BundleContextImpl.registerService(BundleContextImpl.java:999) at org.wso2.carbon.datasource.core.internal.DataSourceListenerComponent.onAllRequiredCapabilitiesAvailable(DataSourceListenerComponent.java:131) at org.wso2.carbon.kernel.internal.startupresolver.StartupComponentManager.lambda$notifySatisfiableComponents$7(StartupComponentManager.java:266) at java.util.ArrayList.forEach(ArrayList.java:1257) at org.wso2.carbon.kernel.internal.startupresolver.StartupComponentManager.notifySatisfiableComponents(StartupComponentManager.java:252) at org.wso2.carbon.kernel.internal.startupresolver.StartupOrderResolver$1.run(StartupOrderResolver.java:204) at java.util.TimerThread.mainLoop(Timer.java:555) at java.util.TimerThread.run(Timer.java:505) Caused by: org.wso2.carbon.cluster.coordinator.commons.exception.ClusterCoordinationException: Could not create table CLUSTER_NODE_STATUS_TABLE at org.wso2.carbon.cluster.coordinator.rdbms.RDBMSCommunicationBusContextImpl.createTableIfNotExist(RDBMSCommunicationBusContextImpl.java:192) at org.wso2.carbon.cluster.coordinator.rdbms.RDBMSCommunicationBusContextImpl.createTables(RDBMSCommunicationBusContextImpl.java:133) at org.wso2.carbon.cluster.coordinator.rdbms.RDBMSCommunicationBusContextImpl.(RDBMSCommunicationBusContextImpl.java:101) at org.wso2.carbon.cluster.coordinator.rdbms.RDBMSCoordinationStrategy.(RDBMSCoordinationStrategy.java:104) at org.wso2.carbon.cluster.coordinator.rdbms.internal.RDBMSCoordinationServiceComponent.start(RDBMSCoordinationServiceComponent.java:78) ... 29 more Caused by: java.sql.SQLSyntaxErrorException: Specified key was too long; max key length is 3072 bytes at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.StatementImpl.executeUpdateInternal(StatementImpl.java:1355) at com.mysql.cj.jdbc.StatementImpl.executeLargeUpdate(StatementImpl.java:2128) at com.mysql.cj.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1264) at com.zaxxer.hikari.proxy.StatementProxy.executeUpdate(StatementProxy.java:119) at com.zaxxer.hikari.proxy.HikariStatementProxy.executeUpdate(HikariStatementProxy.java) at org.wso2.carbon.cluster.coordinator.rdbms.RDBMSCommunicationBusContextImpl.createTableIfNotExist(RDBMSCommunicationBusContextImpl.java:189) ... 33 more

[2019-03-08 10:32:02,132] INFO {org.wso2.carbon.stream.processor.core.internal.ServiceComponent} - Periodic state persistence started with an interval of 1 using org.wso2.carbon.stream.processor.core.persistence.FileSystemPersistenceStore [2019-03-08 10:32:02,138] INFO {org.wso2.carbon.event.simulator.core.service.CSVFileDeployer} - CSV file deployer initiated. [2019-03-08 10:32:02,140] INFO {org.wso2.carbon.event.simulator.core.service.SimulationConfigDeployer} - Simulation config deployer initiated. [2019-03-08 10:32:02,218] INFO {org.wso2.msf4j.MicroservicesRunner} - Microservices server started in 72ms [2019-03-08 10:32:02,219] INFO {org.wso2.msf4j.MicroservicesRunner} - Microservices server started in 73ms [2019-03-08 10:32:02,226] INFO {org.wso2.transport.http.netty.listener.ServerConnectorBootstrap$HTTPServerConnector} - HTTP(S) Interface starting on host 0.0.0.0 and port 7071 [2019-03-08 10:32:02,226] INFO {org.wso2.transport.http.netty.listener.ServerConnectorBootstrap$HTTPServerConnector} - HTTP(S) Interface starting on host 0.0.0.0 and port 7444 [2019-03-08 10:32:02,230] INFO {org.wso2.carbon.stream.processor.statistics.api.StatisticsApi} - org.wso2.carbon.stream.processor.statistics.api.StatisticsApi service component has started. [2019-03-08 10:32:02,231] INFO {org.wso2.carbon.stream.processor.statistics.internal.service.OperatingSystemMetricsServiceComponent} - OperatingSystemMetricsService Component activated [2019-03-08 10:32:02,264] INFO {org.wso2.carbon.databridge.receiver.binary.internal.BinaryDataReceiverServiceComponent} - org.wso2.carbon.databridge.receiver.binary.internal.Service Component is activated [2019-03-08 10:32:02,298] INFO {org.wso2.carbon.databridge.receiver.binary.internal.BinaryDataReceiver} - Started Binary SSL Transport on port : 9714 [2019-03-08 10:32:02,299] INFO {org.wso2.carbon.databridge.receiver.binary.internal.BinaryDataReceiver} - Started Binary TCP Transport on port : 9614 [2019-03-08 10:32:02,301] INFO {org.wso2.carbon.databridge.receiver.thrift.internal.ThriftDataReceiverDS} - Service Component is activated [2019-03-08 10:32:02,313] INFO {org.wso2.carbon.databridge.receiver.thrift.ThriftDataReceiver} - Thrift Server started at 0.0.0.0 [2019-03-08 10:32:02,321] INFO {org.wso2.carbon.databridge.receiver.thrift.ThriftDataReceiver} - Thrift SSL port : 7713 [2019-03-08 10:32:02,324] INFO {org.wso2.carbon.databridge.receiver.thrift.ThriftDataReceiver} - Thrift port : 7613 [2019-03-08 10:32:02,340] ERROR {org.eclipse.equinox.ds} - [SCR] Exception while activating instance org.wso2.carbon.cluster.coordinator.rdbms.internal.RDBMSCoordinationServiceComponent@13375aab of component org.wso2.carbon.cluster.coordinator.rdbms.internal.RDBMSCoordinationServiceComponent java.lang.reflect.InvocationTargetException 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 org.eclipse.equinox.internal.ds.model.ServiceComponent.activate(ServiceComponent.java:235) at org.eclipse.equinox.internal.ds.model.ServiceComponentProp.activate(ServiceComponentProp.java:146) at org.eclipse.equinox.internal.ds.model.ServiceComponentProp.build(ServiceComponentProp.java:345) at org.eclipse.equinox.internal.ds.InstanceProcess.buildComponent(InstanceProcess.java:620) at org.eclipse.equinox.internal.ds.InstanceProcess.buildComponents(InstanceProcess.java:197) at org.eclipse.equinox.internal.ds.Resolver.getEligible(Resolver.java:343) at org.eclipse.equinox.internal.ds.SCRManager.serviceChanged(SCRManager.java:222) at org.eclipse.osgi.internal.serviceregistry.FilteredServiceListener.serviceChanged(FilteredServiceListener.java:109) at org.eclipse.osgi.internal.framework.BundleContextImpl.dispatchEvent(BundleContextImpl.java:915) at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230) at org.eclipse.osgi.framework.eventmgr.ListenerQueue.dispatchEventSynchronous(ListenerQueue.java:148) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEventPrivileged(ServiceRegistry.java:862) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEvent(ServiceRegistry.java:801) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistrationImpl.register(ServiceRegistrationImpl.java:127) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.registerService(ServiceRegistry.java:225) at org.eclipse.osgi.internal.framework.BundleContextImpl.registerService(BundleContextImpl.java:464) at org.eclipse.osgi.internal.framework.BundleContextImpl.registerService(BundleContextImpl.java:482) at org.wso2.carbon.analytics.idp.client.core.internal.IdPClientServiceComponent.onAllRequiredCapabilitiesAvailable(IdPClientServiceComponent.java:111) at org.wso2.carbon.kernel.internal.startupresolver.StartupComponentManager.lambda$notifySatisfiableComponents$7(StartupComponentManager.java:266) at java.util.ArrayList.forEach(ArrayList.java:1257) at org.wso2.carbon.kernel.internal.startupresolver.StartupComponentManager.notifySatisfiableComponents(StartupComponentManager.java:252) at org.wso2.carbon.kernel.internal.startupresolver.StartupOrderResolver$1.run(StartupOrderResolver.java:204) at java.util.TimerThread.mainLoop(Timer.java:555) at java.util.TimerThread.run(Timer.java:505) Caused by: org.wso2.carbon.cluster.coordinator.commons.exception.ClusterCoordinationException: Could not create table CLUSTER_NODE_STATUS_TABLE at org.wso2.carbon.cluster.coordinator.rdbms.RDBMSCommunicationBusContextImpl.createTableIfNotExist(RDBMSCommunicationBusContextImpl.java:192) at org.wso2.carbon.cluster.coordinator.rdbms.RDBMSCommunicationBusContextImpl.createTables(RDBMSCommunicationBusContextImpl.java:133) at org.wso2.carbon.cluster.coordinator.rdbms.RDBMSCommunicationBusContextImpl.(RDBMSCommunicationBusContextImpl.java:101) at org.wso2.carbon.cluster.coordinator.rdbms.RDBMSCoordinationStrategy.(RDBMSCoordinationStrategy.java:104) at org.wso2.carbon.cluster.coordinator.rdbms.internal.RDBMSCoordinationServiceComponent.start(RDBMSCoordinationServiceComponent.java:78) ... 28 more Caused by: java.sql.SQLSyntaxErrorException: Specified key was too long; max key length is 3072 bytes at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.StatementImpl.executeUpdateInternal(StatementImpl.java:1355) at com.mysql.cj.jdbc.StatementImpl.executeLargeUpdate(StatementImpl.java:2128) at com.mysql.cj.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1264) at com.zaxxer.hikari.proxy.StatementProxy.executeUpdate(StatementProxy.java:119) at com.zaxxer.hikari.proxy.HikariStatementProxy.executeUpdate(HikariStatementProxy.java) at org.wso2.carbon.cluster.coordinator.rdbms.RDBMSCommunicationBusContextImpl.createTableIfNotExist(RDBMSCommunicationBusContextImpl.java:189) ... 32 more

[2019-03-08 10:32:02,520] ERROR {org.eclipse.equinox.ds} - [SCR] Exception while activating instance org.wso2.carbon.cluster.coordinator.rdbms.internal.RDBMSCoordinationServiceComponent@79e699dd of component org.wso2.carbon.cluster.coordinator.rdbms.internal.RDBMSCoordinationServiceComponent java.lang.reflect.InvocationTargetException 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 org.eclipse.equinox.internal.ds.model.ServiceComponent.activate(ServiceComponent.java:235) at org.eclipse.equinox.internal.ds.model.ServiceComponentProp.activate(ServiceComponentProp.java:146) at org.eclipse.equinox.internal.ds.model.ServiceComponentProp.build(ServiceComponentProp.java:345) at org.eclipse.equinox.internal.ds.InstanceProcess.buildComponent(InstanceProcess.java:620) at org.eclipse.equinox.internal.ds.InstanceProcess.buildComponents(InstanceProcess.java:197) at org.eclipse.equinox.internal.ds.Resolver.getEligible(Resolver.java:343) at org.eclipse.equinox.internal.ds.SCRManager.serviceChanged(SCRManager.java:222) at org.eclipse.osgi.internal.serviceregistry.FilteredServiceListener.serviceChanged(FilteredServiceListener.java:109) at org.eclipse.osgi.internal.framework.BundleContextImpl.dispatchEvent(BundleContextImpl.java:915) at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230) at org.eclipse.osgi.framework.eventmgr.ListenerQueue.dispatchEventSynchronous(ListenerQueue.java:148) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEventPrivileged(ServiceRegistry.java:862) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEvent(ServiceRegistry.java:801) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistrationImpl.register(ServiceRegistrationImpl.java:127) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.registerService(ServiceRegistry.java:225) at org.eclipse.osgi.internal.framework.BundleContextImpl.registerService(BundleContextImpl.java:464) at org.eclipse.osgi.internal.framework.BundleContextImpl.registerService(BundleContextImpl.java:482) at org.eclipse.osgi.internal.framework.BundleContextImpl.registerService(BundleContextImpl.java:999) at org.wso2.msf4j.internal.MicroservicesServerSC.onAllRequiredCapabilitiesAvailable(MicroservicesServerSC.java:385) at org.wso2.carbon.kernel.internal.startupresolver.StartupComponentManager.lambda$notifySatisfiableComponents$7(StartupComponentManager.java:266) at java.util.ArrayList.forEach(ArrayList.java:1257) at org.wso2.carbon.kernel.internal.startupresolver.StartupComponentManager.notifySatisfiableComponents(StartupComponentManager.java:252) at org.wso2.carbon.kernel.internal.startupresolver.StartupOrderResolver$1.run(StartupOrderResolver.java:204) at java.util.TimerThread.mainLoop(Timer.java:555) at java.util.TimerThread.run(Timer.java:505) Caused by: org.wso2.carbon.cluster.coordinator.commons.exception.ClusterCoordinationException: Could not create table CLUSTER_NODE_STATUS_TABLE at org.wso2.carbon.cluster.coordinator.rdbms.RDBMSCommunicationBusContextImpl.createTableIfNotExist(RDBMSCommunicationBusContextImpl.java:192) at org.wso2.carbon.cluster.coordinator.rdbms.RDBMSCommunicationBusContextImpl.createTables(RDBMSCommunicationBusContextImpl.java:133) at org.wso2.carbon.cluster.coordinator.rdbms.RDBMSCommunicationBusContextImpl.(RDBMSCommunicationBusContextImpl.java:101) at org.wso2.carbon.cluster.coordinator.rdbms.RDBMSCoordinationStrategy.(RDBMSCoordinationStrategy.java:104) at org.wso2.carbon.cluster.coordinator.rdbms.internal.RDBMSCoordinationServiceComponent.start(RDBMSCoordinationServiceComponent.java:78) ... 29 more Caused by: java.sql.SQLSyntaxErrorException: Specified key was too long; max key length is 3072 bytes at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.StatementImpl.executeUpdateInternal(StatementImpl.java:1355) at com.mysql.cj.jdbc.StatementImpl.executeLargeUpdate(StatementImpl.java:2128) at com.mysql.cj.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1264) at com.zaxxer.hikari.proxy.StatementProxy.executeUpdate(StatementProxy.java:119) at com.zaxxer.hikari.proxy.HikariStatementProxy.executeUpdate(HikariStatementProxy.java) at org.wso2.carbon.cluster.coordinator.rdbms.RDBMSCommunicationBusContextImpl.createTableIfNotExist(RDBMSCommunicationBusContextImpl.java:189) ... 33 more

[2019-03-08 10:32:02,532] ERROR {org.eclipse.equinox.ds} - [SCR] Exception while activating instance org.wso2.carbon.cluster.coordinator.rdbms.internal.RDBMSCoordinationServiceComponent@40dc3757 of component org.wso2.carbon.cluster.coordinator.rdbms.internal.RDBMSCoordinationServiceComponent java.lang.reflect.InvocationTargetException 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 org.eclipse.equinox.internal.ds.model.ServiceComponent.activate(ServiceComponent.java:235) at org.eclipse.equinox.internal.ds.model.ServiceComponentProp.activate(ServiceComponentProp.java:146) at org.eclipse.equinox.internal.ds.model.ServiceComponentProp.build(ServiceComponentProp.java:345) at org.eclipse.equinox.internal.ds.InstanceProcess.buildComponent(InstanceProcess.java:620) at org.eclipse.equinox.internal.ds.InstanceProcess.buildComponents(InstanceProcess.java:197) at org.eclipse.equinox.internal.ds.Resolver.getEligible(Resolver.java:343) at org.eclipse.equinox.internal.ds.SCRManager.serviceChanged(SCRManager.java:222) at org.eclipse.osgi.internal.serviceregistry.FilteredServiceListener.serviceChanged(FilteredServiceListener.java:109) at org.eclipse.osgi.internal.framework.BundleContextImpl.dispatchEvent(BundleContextImpl.java:915) at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230) at org.eclipse.osgi.framework.eventmgr.ListenerQueue.dispatchEventSynchronous(ListenerQueue.java:148) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEventPrivileged(ServiceRegistry.java:862) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEvent(ServiceRegistry.java:801) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistrationImpl.register(ServiceRegistrationImpl.java:127) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.registerService(ServiceRegistry.java:225) at org.eclipse.osgi.internal.framework.BundleContextImpl.registerService(BundleContextImpl.java:464) at org.eclipse.osgi.internal.framework.BundleContextImpl.registerService(BundleContextImpl.java:482) at org.eclipse.osgi.internal.framework.BundleContextImpl.registerService(BundleContextImpl.java:999) at org.wso2.msf4j.internal.MicroservicesServerSC.onAllRequiredCapabilitiesAvailable(MicroservicesServerSC.java:386) at org.wso2.carbon.kernel.internal.startupresolver.StartupComponentManager.lambda$notifySatisfiableComponents$7(StartupComponentManager.java:266) at java.util.ArrayList.forEach(ArrayList.java:1257) at org.wso2.carbon.kernel.internal.startupresolver.StartupComponentManager.notifySatisfiableComponents(StartupComponentManager.java:252) at org.wso2.carbon.kernel.internal.startupresolver.StartupOrderResolver$1.run(StartupOrderResolver.java:204) at java.util.TimerThread.mainLoop(Timer.java:555) at java.util.TimerThread.run(Timer.java:505) Caused by: org.wso2.carbon.cluster.coordinator.commons.exception.ClusterCoordinationException: Could not create table CLUSTER_NODE_STATUS_TABLE at org.wso2.carbon.cluster.coordinator.rdbms.RDBMSCommunicationBusContextImpl.createTableIfNotExist(RDBMSCommunicationBusContextImpl.java:192) at org.wso2.carbon.cluster.coordinator.rdbms.RDBMSCommunicationBusContextImpl.createTables(RDBMSCommunicationBusContextImpl.java:133) at org.wso2.carbon.cluster.coordinator.rdbms.RDBMSCommunicationBusContextImpl.(RDBMSCommunicationBusContextImpl.java:101) at org.wso2.carbon.cluster.coordinator.rdbms.RDBMSCoordinationStrategy.(RDBMSCoordinationStrategy.java:104) at org.wso2.carbon.cluster.coordinator.rdbms.internal.RDBMSCoordinationServiceComponent.start(RDBMSCoordinationServiceComponent.java:78) ... 29 more Caused by: java.sql.SQLSyntaxErrorException: Specified key was too long; max key length is 3072 bytes at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.StatementImpl.executeUpdateInternal(StatementImpl.java:1355) at com.mysql.cj.jdbc.StatementImpl.executeLargeUpdate(StatementImpl.java:2128) at com.mysql.cj.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1264) at com.zaxxer.hikari.proxy.StatementProxy.executeUpdate(StatementProxy.java:119) at com.zaxxer.hikari.proxy.HikariStatementProxy.executeUpdate(HikariStatementProxy.java) at org.wso2.carbon.cluster.coordinator.rdbms.RDBMSCommunicationBusContextImpl.createTableIfNotExist(RDBMSCommunicationBusContextImpl.java:189) ... 33 more

[2019-03-08 10:32:02,548] ERROR {org.eclipse.equinox.ds} - [SCR] Exception while activating instance org.wso2.carbon.cluster.coordinator.rdbms.internal.RDBMSCoordinationServiceComponent@8e17cc0 of component org.wso2.carbon.cluster.coordinator.rdbms.internal.RDBMSCoordinationServiceComponent java.lang.reflect.InvocationTargetException 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 org.eclipse.equinox.internal.ds.model.ServiceComponent.activate(ServiceComponent.java:235) at org.eclipse.equinox.internal.ds.model.ServiceComponentProp.activate(ServiceComponentProp.java:146) at org.eclipse.equinox.internal.ds.model.ServiceComponentProp.build(ServiceComponentProp.java:345) at org.eclipse.equinox.internal.ds.InstanceProcess.buildComponent(InstanceProcess.java:620) at org.eclipse.equinox.internal.ds.InstanceProcess.buildComponents(InstanceProcess.java:197) at org.eclipse.equinox.internal.ds.Resolver.getEligible(Resolver.java:343) at org.eclipse.equinox.internal.ds.SCRManager.serviceChanged(SCRManager.java:222) at org.eclipse.osgi.internal.serviceregistry.FilteredServiceListener.serviceChanged(FilteredServiceListener.java:109) at org.eclipse.osgi.internal.framework.BundleContextImpl.dispatchEvent(BundleContextImpl.java:915) at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230) at org.eclipse.osgi.framework.eventmgr.ListenerQueue.dispatchEventSynchronous(ListenerQueue.java:148) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEventPrivileged(ServiceRegistry.java:862) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEvent(ServiceRegistry.java:801) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistrationImpl.register(ServiceRegistrationImpl.java:127) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.registerService(ServiceRegistry.java:225) at org.eclipse.osgi.internal.framework.BundleContextImpl.registerService(BundleContextImpl.java:464) at org.eclipse.osgi.internal.framework.BundleContextImpl.registerService(BundleContextImpl.java:482) at org.eclipse.osgi.internal.framework.BundleContextImpl.registerService(BundleContextImpl.java:999) at org.wso2.msf4j.internal.MicroservicesServerSC.onAllRequiredCapabilitiesAvailable(MicroservicesServerSC.java:387) at org.wso2.carbon.kernel.internal.startupresolver.StartupComponentManager.lambda$notifySatisfiableComponents$7(StartupComponentManager.java:266) at java.util.ArrayList.forEach(ArrayList.java:1257) at org.wso2.carbon.kernel.internal.startupresolver.StartupComponentManager.notifySatisfiableComponents(StartupComponentManager.java:252) at org.wso2.carbon.kernel.internal.startupresolver.StartupOrderResolver$1.run(StartupOrderResolver.java:204) at java.util.TimerThread.mainLoop(Timer.java:555) at java.util.TimerThread.run(Timer.java:505) Caused by: org.wso2.carbon.cluster.coordinator.commons.exception.ClusterCoordinationException: Could not create table CLUSTER_NODE_STATUS_TABLE at org.wso2.carbon.cluster.coordinator.rdbms.RDBMSCommunicationBusContextImpl.createTableIfNotExist(RDBMSCommunicationBusContextImpl.java:192) at org.wso2.carbon.cluster.coordinator.rdbms.RDBMSCommunicationBusContextImpl.createTables(RDBMSCommunicationBusContextImpl.java:133) at org.wso2.carbon.cluster.coordinator.rdbms.RDBMSCommunicationBusContextImpl.(RDBMSCommunicationBusContextImpl.java:101) at org.wso2.carbon.cluster.coordinator.rdbms.RDBMSCoordinationStrategy.(RDBMSCoordinationStrategy.java:104) at org.wso2.carbon.cluster.coordinator.rdbms.internal.RDBMSCoordinationServiceComponent.start(RDBMSCoordinationServiceComponent.java:78) ... 29 more Caused by: java.sql.SQLSyntaxErrorException: Specified key was too long; max key length is 3072 bytes at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.StatementImpl.executeUpdateInternal(StatementImpl.java:1355) at com.mysql.cj.jdbc.StatementImpl.executeLargeUpdate(StatementImpl.java:2128) at com.mysql.cj.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1264) at com.zaxxer.hikari.proxy.StatementProxy.executeUpdate(StatementProxy.java:119) at com.zaxxer.hikari.proxy.HikariStatementProxy.executeUpdate(HikariStatementProxy.java) at org.wso2.carbon.cluster.coordinator.rdbms.RDBMSCommunicationBusContextImpl.createTableIfNotExist(RDBMSCommunicationBusContextImpl.java:189) ... 33 more

[2019-03-08 10:32:02,550] INFO {org.wso2.msf4j.internal.MicroservicesServerSC} - All microservices are available [2019-03-08 10:32:02,553] INFO {org.wso2.transport.http.netty.listener.ServerConnectorBootstrap$HTTPServerConnector} - HTTP(S) Interface starting on host 0.0.0.0 and port 9444 [2019-03-08 10:32:02,553] INFO {org.wso2.transport.http.netty.listener.ServerConnectorBootstrap$HTTPServerConnector} - HTTP(S) Interface starting on host 0.0.0.0 and port 9091 [2019-03-08 10:32:02,864] INFO {org.apache.kafka.clients.consumer.ConsumerConfig} - ConsumerConfig values: auto.commit.interval.ms = 5000 auto.offset.reset = earliest bootstrap.servers = [localhost:9092] check.crcs = true client.id = connections.max.idle.ms = 540000 enable.auto.commit = false exclude.internal.topics = true fetch.max.bytes = 52428800 fetch.max.wait.ms = 500 fetch.min.bytes = 1 group.id = test-consumer-group heartbeat.interval.ms = 3000 interceptor.classes = null key.deserializer = class org.apache.kafka.common.serialization.StringDeserializer max.partition.fetch.bytes = 1048576 max.poll.interval.ms = 300000 max.poll.records = 500 metadata.max.age.ms = 300000 metric.reporters = [] metrics.num.samples = 2 metrics.recording.level = INFO metrics.sample.window.ms = 30000 partition.assignment.strategy = [class org.apache.kafka.clients.consumer.RangeAssignor] receive.buffer.bytes = 65536 reconnect.backoff.ms = 50 request.timeout.ms = 305000 retry.backoff.ms = 100 sasl.jaas.config = null sasl.kerberos.kinit.cmd = /usr/bin/kinit sasl.kerberos.min.time.before.relogin = 60000 sasl.kerberos.service.name = null sasl.kerberos.ticket.renew.jitter = 0.05 sasl.kerberos.ticket.renew.window.factor = 0.8 sasl.mechanism = GSSAPI security.protocol = PLAINTEXT send.buffer.bytes = 131072 session.timeout.ms = 30000 ssl.cipher.suites = null ssl.enabled.protocols = [TLSv1.2, TLSv1.1, TLSv1] ssl.endpoint.identification.algorithm = null ssl.key.password = null ssl.keymanager.algorithm = SunX509 ssl.keystore.location = null ssl.keystore.password = null ssl.keystore.type = JKS ssl.protocol = TLS ssl.provider = null ssl.secure.random.implementation = null ssl.trustmanager.algorithm = PKIX ssl.truststore.location = null ssl.truststore.password = null ssl.truststore.type = JKS value.deserializer = class org.apache.kafka.common.serialization.StringDeserializer

[2019-03-08 10:32:03,013] INFO {org.apache.kafka.common.utils.AppInfoParser} - Kafka version : 0.10.2.1 [2019-03-08 10:32:03,013] INFO {org.apache.kafka.common.utils.AppInfoParser} - Kafka commitId : e89bffd6b2eff799 [2019-03-08 10:32:03,039] INFO {org.wso2.extension.siddhi.io.mgwfile.task.MGWFileCleanUpTask} - Uploaded API Usage data in the db will be cleaned up to : 2019-03-03 10:32:03.038 [2019-03-08 10:32:03,060] INFO {org.apache.kafka.clients.producer.ProducerConfig} - ProducerConfig values: acks = 1 batch.size = 16384 block.on.buffer.full = false bootstrap.servers = [localhost:9092] buffer.memory = 33554432 client.id = compression.type = none connections.max.idle.ms = 540000 interceptor.classes = null key.serializer = class org.apache.kafka.common.serialization.ByteArraySerializer linger.ms = 0 max.block.ms = 60000 max.in.flight.requests.per.connection = 5 max.request.size = 1048576 metadata.fetch.timeout.ms = 60000 metadata.max.age.ms = 300000 metric.reporters = [] metrics.num.samples = 2 metrics.sample.window.ms = 30000 partitioner.class = class org.apache.kafka.clients.producer.internals.DefaultPartitioner receive.buffer.bytes = 32768 reconnect.backoff.ms = 50 request.timeout.ms = 30000 retries = 0 retry.backoff.ms = 100 sasl.jaas.config = null sasl.kerberos.kinit.cmd = /usr/bin/kinit sasl.kerberos.min.time.before.relogin = 60000 sasl.kerberos.service.name = null sasl.kerberos.ticket.renew.jitter = 0.05 sasl.kerberos.ticket.renew.window.factor = 0.8 sasl.mechanism = GSSAPI security.protocol = PLAINTEXT send.buffer.bytes = 131072 ssl.cipher.suites = null ssl.enabled.protocols = [TLSv1.2, TLSv1.1, TLSv1] ssl.endpoint.identification.algorithm = null ssl.key.password = null ssl.keymanager.algorithm = SunX509 ssl.keystore.location = null ssl.keystore.password = null ssl.keystore.type = JKS ssl.protocol = TLS ssl.provider = null ssl.secure.random.implementation = null ssl.trustmanager.algorithm = PKIX ssl.truststore.location = null ssl.truststore.password = null ssl.truststore.type = JKS timeout.ms = 30000 value.serializer = class org.apache.kafka.common.serialization.StringSerializer

[2019-03-08 10:32:03,069] INFO {org.apache.kafka.common.utils.AppInfoParser} - Kafka version : 0.10.2.1 [2019-03-08 10:32:03,071] INFO {org.apache.kafka.common.utils.AppInfoParser} - Kafka commitId : e89bffd6b2eff799 [2019-03-08 10:32:03,111] INFO {org.wso2.carbon.stream.processor.core.internal.StreamProcessorService} - Periodic State persistence enabled. Restoring last persisted state of KafkaSourceWithMinHA [2019-03-08 10:32:03,113] INFO {org.wso2.extension.siddhi.io.kafka.source.KafkaSource} - Kafka Adapter paused for topic(s): sequential_events [2019-03-08 10:32:03,120] INFO {org.wso2.carbon.stream.processor.core.persistence.FileSystemPersistenceStore} - State loaded for KafkaSourceWithMinHA revision 1552021228240KafkaSourceWithMinHA from the file system. [2019-03-08 10:32:03,123] INFO {org.wso2.carbon.stream.processor.core.internal.StreamProcessorService} - Siddhi App KafkaSourceWithMinHA restored to revision 1552021228240KafkaSourceWithMinHA [2019-03-08 10:32:03,123] INFO {org.apache.kafka.clients.consumer.ConsumerConfig} - ConsumerConfig values: auto.commit.interval.ms = 5000 auto.offset.reset = earliest bootstrap.servers = [localhost:9092] check.crcs = true client.id = connections.max.idle.ms = 540000 enable.auto.commit = false exclude.internal.topics = true fetch.max.bytes = 52428800 fetch.max.wait.ms = 500 fetch.min.bytes = 1 group.id = group heartbeat.interval.ms = 3000 interceptor.classes = null key.deserializer = class org.apache.kafka.common.serialization.StringDeserializer max.partition.fetch.bytes = 1048576 max.poll.interval.ms = 300000 max.poll.records = 500 metadata.max.age.ms = 300000 metric.reporters = [] metrics.num.samples = 2 metrics.recording.level = INFO metrics.sample.window.ms = 30000 partition.assignment.strategy = [class org.apache.kafka.clients.consumer.RangeAssignor] receive.buffer.bytes = 65536 reconnect.backoff.ms = 50 request.timeout.ms = 305000 retry.backoff.ms = 100 sasl.jaas.config = null sasl.kerberos.kinit.cmd = /usr/bin/kinit sasl.kerberos.min.time.before.relogin = 60000 sasl.kerberos.service.name = null sasl.kerberos.ticket.renew.jitter = 0.05 sasl.kerberos.ticket.renew.window.factor = 0.8 sasl.mechanism = GSSAPI security.protocol = PLAINTEXT send.buffer.bytes = 131072 session.timeout.ms = 30000 ssl.cipher.suites = null ssl.enabled.protocols = [TLSv1.2, TLSv1.1, TLSv1] ssl.endpoint.identification.algorithm = null ssl.key.password = null ssl.keymanager.algorithm = SunX509 ssl.keystore.location = null ssl.keystore.password = null ssl.keystore.type = JKS ssl.protocol = TLS ssl.provider = null ssl.secure.random.implementation = null ssl.trustmanager.algorithm = PKIX ssl.truststore.location = null ssl.truststore.password = null ssl.truststore.type = JKS value.deserializer = class org.apache.kafka.common.serialization.StringDeserializer

[2019-03-08 10:32:03,128] INFO {org.apache.kafka.common.utils.AppInfoParser} - Kafka version : 0.10.2.1 [2019-03-08 10:32:03,128] INFO {org.apache.kafka.common.utils.AppInfoParser} - Kafka commitId : e89bffd6b2eff799 [2019-03-08 10:32:03,129] ERROR {org.wso2.extension.siddhi.io.kafka.source.ConsumerKafkaGroup} - Error while creating KafkaConsumerThread for topic(s): [sequential_events] java.lang.NullPointerException at org.wso2.extension.siddhi.io.kafka.source.KafkaConsumerThread.(KafkaConsumerThread.java:80) at org.wso2.extension.siddhi.io.kafka.source.ConsumerKafkaGroup.run(ConsumerKafkaGroup.java:82) at org.wso2.extension.siddhi.io.kafka.source.KafkaSource.connect(KafkaSource.java:248) at org.wso2.siddhi.core.stream.input.source.Source.connectWithRetry(Source.java:130) at org.wso2.siddhi.core.SiddhiAppRuntime.startSources(SiddhiAppRuntime.java:441) at org.wso2.siddhi.core.SiddhiAppRuntime.start(SiddhiAppRuntime.java:378) at org.wso2.carbon.stream.processor.core.internal.StreamProcessorService.deploySiddhiApp(StreamProcessorService.java:224) at org.wso2.carbon.stream.processor.core.internal.StreamProcessorDeployer.deploySiddhiQLFile(StreamProcessorDeployer.java:93) at org.wso2.carbon.stream.processor.core.internal.StreamProcessorDeployer.deploy(StreamProcessorDeployer.java:306) at org.wso2.carbon.deployment.engine.internal.DeploymentEngine.lambda$deployArtifacts$0(DeploymentEngine.java:291) at java.util.ArrayList.forEach(ArrayList.java:1257) at org.wso2.carbon.deployment.engine.internal.DeploymentEngine.deployArtifacts(DeploymentEngine.java:282) at org.wso2.carbon.deployment.engine.internal.RepositoryScanner.sweep(RepositoryScanner.java:112) at org.wso2.carbon.deployment.engine.internal.RepositoryScanner.scan(RepositoryScanner.java:68) at org.wso2.carbon.deployment.engine.internal.DeploymentEngine.start(DeploymentEngine.java:121) at org.wso2.carbon.deployment.engine.internal.DeploymentEngineListenerComponent.onAllRequiredCapabilitiesAvailable(DeploymentEngineListenerComponent.java:216) at org.wso2.carbon.kernel.internal.startupresolver.StartupComponentManager.lambda$notifySatisfiableComponents$7(StartupComponentManager.java:266) at java.util.ArrayList.forEach(ArrayList.java:1257) at org.wso2.carbon.kernel.internal.startupresolver.StartupComponentManager.notifySatisfiableComponents(StartupComponentManager.java:252) at org.wso2.carbon.kernel.internal.startupresolver.StartupOrderResolver$1.run(StartupOrderResolver.java:204) at java.util.TimerThread.mainLoop(Timer.java:555) at java.util.TimerThread.run(Timer.java:505)

[2019-03-08 10:32:03,130] INFO {org.wso2.carbon.stream.processor.core.internal.StreamProcessorService} - Siddhi App KafkaSourceWithMinHA deployed successfully [2019-03-08 10:32:03,146] ERROR {org.eclipse.equinox.ds} - [SCR] Exception while activating instance org.wso2.carbon.cluster.coordinator.rdbms.internal.RDBMSCoordinationServiceComponent@52763e7b of component org.wso2.carbon.cluster.coordinator.rdbms.internal.RDBMSCoordinationServiceComponent java.lang.reflect.InvocationTargetException 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 org.eclipse.equinox.internal.ds.model.ServiceComponent.activate(ServiceComponent.java:235) at org.eclipse.equinox.internal.ds.model.ServiceComponentProp.activate(ServiceComponentProp.java:146) at org.eclipse.equinox.internal.ds.model.ServiceComponentProp.build(ServiceComponentProp.java:345) at org.eclipse.equinox.internal.ds.InstanceProcess.buildComponent(InstanceProcess.java:620) at org.eclipse.equinox.internal.ds.InstanceProcess.buildComponents(InstanceProcess.java:197) at org.eclipse.equinox.internal.ds.Resolver.getEligible(Resolver.java:343) at org.eclipse.equinox.internal.ds.SCRManager.serviceChanged(SCRManager.java:222) at org.eclipse.osgi.internal.serviceregistry.FilteredServiceListener.serviceChanged(FilteredServiceListener.java:109) at org.eclipse.osgi.internal.framework.BundleContextImpl.dispatchEvent(BundleContextImpl.java:915) at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230) at org.eclipse.osgi.framework.eventmgr.ListenerQueue.dispatchEventSynchronous(ListenerQueue.java:148) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEventPrivileged(ServiceRegistry.java:862) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEvent(ServiceRegistry.java:801) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistrationImpl.register(ServiceRegistrationImpl.java:127) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.registerService(ServiceRegistry.java:225) at org.eclipse.osgi.internal.framework.BundleContextImpl.registerService(BundleContextImpl.java:464) at org.eclipse.osgi.internal.framework.BundleContextImpl.registerService(BundleContextImpl.java:482) at org.wso2.carbon.deployment.engine.internal.DeploymentEngineListenerComponent.onAllRequiredCapabilitiesAvailable(DeploymentEngineListenerComponent.java:225) at org.wso2.carbon.kernel.internal.startupresolver.StartupComponentManager.lambda$notifySatisfiableComponents$7(StartupComponentManager.java:266) at java.util.ArrayList.forEach(ArrayList.java:1257) at org.wso2.carbon.kernel.internal.startupresolver.StartupComponentManager.notifySatisfiableComponents(StartupComponentManager.java:252) at org.wso2.carbon.kernel.internal.startupresolver.StartupOrderResolver$1.run(StartupOrderResolver.java:204) at java.util.TimerThread.mainLoop(Timer.java:555) at java.util.TimerThread.run(Timer.java:505) Caused by: org.wso2.carbon.cluster.coordinator.commons.exception.ClusterCoordinationException: Could not create table CLUSTER_NODE_STATUS_TABLE at org.wso2.carbon.cluster.coordinator.rdbms.RDBMSCommunicationBusContextImpl.createTableIfNotExist(RDBMSCommunicationBusContextImpl.java:192) at org.wso2.carbon.cluster.coordinator.rdbms.RDBMSCommunicationBusContextImpl.createTables(RDBMSCommunicationBusContextImpl.java:133) at org.wso2.carbon.cluster.coordinator.rdbms.RDBMSCommunicationBusContextImpl.(RDBMSCommunicationBusContextImpl.java:101) at org.wso2.carbon.cluster.coordinator.rdbms.RDBMSCoordinationStrategy.(RDBMSCoordinationStrategy.java:104) at org.wso2.carbon.cluster.coordinator.rdbms.internal.RDBMSCoordinationServiceComponent.start(RDBMSCoordinationServiceComponent.java:78) ... 28 more Caused by: java.sql.SQLSyntaxErrorException: Specified key was too long; max key length is 3072 bytes at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.StatementImpl.executeUpdateInternal(StatementImpl.java:1355) at com.mysql.cj.jdbc.StatementImpl.executeLargeUpdate(StatementImpl.java:2128) at com.mysql.cj.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1264) at com.zaxxer.hikari.proxy.StatementProxy.executeUpdate(StatementProxy.java:119) at com.zaxxer.hikari.proxy.HikariStatementProxy.executeUpdate(HikariStatementProxy.java) at org.wso2.carbon.cluster.coordinator.rdbms.RDBMSCommunicationBusContextImpl.createTableIfNotExist(RDBMSCommunicationBusContextImpl.java:189) ... 32 more

[2019-03-08 10:32:03,150] INFO {org.wso2.carbon.kernel.internal.CarbonStartupHandler} - WSO2 Stream Processor started in 10.707 sec [2019-03-08 10:32:03,159] ERROR {org.eclipse.equinox.ds} - [SCR] Exception while activating instance org.wso2.carbon.cluster.coordinator.rdbms.internal.RDBMSCoordinationServiceComponent@18cc7d46 of component org.wso2.carbon.cluster.coordinator.rdbms.internal.RDBMSCoordinationServiceComponent java.lang.reflect.InvocationTargetException 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 org.eclipse.equinox.internal.ds.model.ServiceComponent.activate(ServiceComponent.java:235) at org.eclipse.equinox.internal.ds.model.ServiceComponentProp.activate(ServiceComponentProp.java:146) at org.eclipse.equinox.internal.ds.model.ServiceComponentProp.build(ServiceComponentProp.java:345) at org.eclipse.equinox.internal.ds.InstanceProcess.buildComponent(InstanceProcess.java:620) at org.eclipse.equinox.internal.ds.InstanceProcess.buildComponents(InstanceProcess.java:197) at org.eclipse.equinox.internal.ds.Resolver.getEligible(Resolver.java:343) at org.eclipse.equinox.internal.ds.SCRManager.serviceChanged(SCRManager.java:222) at org.eclipse.osgi.internal.serviceregistry.FilteredServiceListener.serviceChanged(FilteredServiceListener.java:109) at org.eclipse.osgi.internal.framework.BundleContextImpl.dispatchEvent(BundleContextImpl.java:915) at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230) at org.eclipse.osgi.framework.eventmgr.ListenerQueue.dispatchEventSynchronous(ListenerQueue.java:148) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEventPrivileged(ServiceRegistry.java:862) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.publishServiceEvent(ServiceRegistry.java:801) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistrationImpl.register(ServiceRegistrationImpl.java:127) at org.eclipse.osgi.internal.serviceregistry.ServiceRegistry.registerService(ServiceRegistry.java:225) at org.eclipse.osgi.internal.framework.BundleContextImpl.registerService(BundleContextImpl.java:464) at org.eclipse.osgi.internal.framework.BundleContextImpl.registerService(BundleContextImpl.java:482) at org.eclipse.osgi.internal.framework.BundleContextImpl.registerService(BundleContextImpl.java:999) at org.wso2.carbon.kernel.internal.CarbonStartupHandler.registerCarbonServerInfoService(CarbonStartupHandler.java:55) at org.wso2.carbon.kernel.internal.startupresolver.StartupOrderResolver$1.run(StartupOrderResolver.java:192) at java.util.TimerThread.mainLoop(Timer.java:555) at java.util.TimerThread.run(Timer.java:505) Caused by: org.wso2.carbon.cluster.coordinator.commons.exception.ClusterCoordinationException: Could not create table CLUSTER_NODE_STATUS_TABLE at org.wso2.carbon.cluster.coordinator.rdbms.RDBMSCommunicationBusContextImpl.createTableIfNotExist(RDBMSCommunicationBusContextImpl.java:192) at org.wso2.carbon.cluster.coordinator.rdbms.RDBMSCommunicationBusContextImpl.createTables(RDBMSCommunicationBusContextImpl.java:133) at org.wso2.carbon.cluster.coordinator.rdbms.RDBMSCommunicationBusContextImpl.(RDBMSCommunicationBusContextImpl.java:101) at org.wso2.carbon.cluster.coordinator.rdbms.RDBMSCoordinationStrategy.(RDBMSCoordinationStrategy.java:104) at org.wso2.carbon.cluster.coordinator.rdbms.internal.RDBMSCoordinationServiceComponent.start(RDBMSCoordinationServiceComponent.java:78) ... 26 more Caused by: java.sql.SQLSyntaxErrorException: Specified key was too long; max key length is 3072 bytes at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.StatementImpl.executeUpdateInternal(StatementImpl.java:1355) at com.mysql.cj.jdbc.StatementImpl.executeLargeUpdate(StatementImpl.java:2128) at com.mysql.cj.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1264) at com.zaxxer.hikari.proxy.StatementProxy.executeUpdate(StatementProxy.java:119) at com.zaxxer.hikari.proxy.HikariStatementProxy.executeUpdate(HikariStatementProxy.java) at org.wso2.carbon.cluster.coordinator.rdbms.RDBMSCommunicationBusContextImpl.createTableIfNotExist(RDBMSCommunicationBusContextImpl.java:189) ... 30 more

Affected Product Version: wso2sp-4.3.0

OS, DB, other environment details and versions:
Machine: Macbook pro OS: Mac OS Mojave DB: MySQL Community server 8.0.15

Steps to reproduce:

  1. Install MySQL 8.0.15 from https://dev.mysql.com/downloads/mysql/ on a MacBook
  2. Configure minimum HA deployment with Kafka
  3. Start a worker
bigbradwong commented 5 years ago

this is because default uft-8 charset in the latest version which occupy 3-byte, you can specify the database charset by CHARACTER SET latin1 COLLATE latin1_swedish_ci