digitalgust commented on issue #3523: 4.11.3.0 create ceph primary storage error URL: https://github.com/apache/cloudstack/issues/3523#issuecomment-515283164 since 4.9.2 cloudstack add primary storage error: ``` 2019-07-26 10:16:49,763 DEBUG [c.c.a.ApiServlet] (catalina-exec-2:ctx-8368781e) (logid:151a79c4) ===START=== 10.0.1.11 -- GET command=createStoragePool&zoneid=e744901f-745a-4bb0-b8e3-4b1cf4ca9b60&podId=964682b7-367b-4d1a-8a48-c55b4e986fe7&clusterid=9dc1e904-57d7-4678-b4e8-cb2380abc93e&name=Z1_PRI1_CEPH&scope=zone&hypervisor=KVM&url=rbd%3A%2F%2Fcloudstack%3AAQATDjld4LBvBxAABbwFU5C_m%2FaTVkI95xrSzw%3D%3D%40192.168.100.10%2Fcloudstack&response=json&_=1564107409711 2019-07-26 10:16:49,776 DEBUG [o.a.c.s.d.l.CloudStackPrimaryDataStoreLifeCycleImpl] (catalina-exec-2:ctx-8368781e ctx-616f5ed3) (logid:151a79c4) createPool Params @ scheme - rbd storageHost - null hostPath - /[email protected]/cloudstack port - -1 2019-07-26 10:16:49,793 DEBUG [c.c.u.d.T.Transaction] (catalina-exec-2:ctx-8368781e ctx-616f5ed3) (logid:151a79c4) Rolling back the transaction: Time = 1 Name = catalina-exec-2; called by -TransactionLegacy.rollback:889-TransactionLegacy.removeUpTo:832-TransactionLegacy.close:656-TransactionContextInterceptor.invoke:36-ReflectiveMethodInvocation.proceed:161-ExposeInvocationInterceptor.invoke:91-ReflectiveMethodInvocation.proceed:172-JdkDynamicAopProxy.invoke:204-$Proxy67.persist:-1-PrimaryDataStoreHelper.createPrimaryDataStore:132-CloudStackPrimaryDataStoreLifeCycleImpl.initialize:353-StorageManagerImpl.createPool:706 2019-07-26 10:16:49,794 DEBUG [c.c.s.StorageManagerImpl] (catalina-exec-2:ctx-8368781e ctx-616f5ed3) (logid:151a79c4) Failed to add data store: DB Exception on: com.mysql.jdbc.JDBC4PreparedStatement@38670f4f: INSERT INTO storage_pool (storage_pool.id, storage_pool.name, storage_pool.uuid, storage_pool.pool_type, storage_pool.created, storage_pool.update_time, storage_pool.data_center_id, storage_pool.pod_id, storage_pool.used_bytes, storage_pool.capacity_bytes, storage_pool.status, storage_pool.storage_provider_name, storage_pool.host_address, storage_pool.path, storage_pool.port, storage_pool.user_info, storage_pool.cluster_id, storage_pool.scope, storage_pool.managed, storage_pool.capacity_iops, storage_pool.hypervisor) VALUES (0, _binary'Z1_PRI1_CEPH', _binary'ca5cbccb-fb46-3fdd-881a-aa857dcdac00', 'RBD', '2019-07-26 02:16:49', null, 1, null, 0, 0, 'Initialized', _binary'DefaultPrimary', null, _binary'[email protected]/cloudstack', 6789, null, null, null, 0, null, null) com.cloud.utils.exception.CloudRuntimeException: DB Exception on: com.mysql.jdbc.JDBC4PreparedStatement@38670f4f: INSERT INTO storage_pool (storage_pool.id, storage_pool.name, storage_pool.uuid, storage_pool.pool_type, storage_pool.created, storage_pool.update_time, storage_pool.data_center_id, storage_pool.pod_id, storage_pool.used_bytes, storage_pool.capacity_bytes, storage_pool.status, storage_pool.storage_provider_name, storage_pool.host_address, storage_pool.path, storage_pool.port, storage_pool.user_info, storage_pool.cluster_id, storage_pool.scope, storage_pool.managed, storage_pool.capacity_iops, storage_pool.hypervisor) VALUES (0, _binary'Z1_PRI1_CEPH', _binary'ca5cbccb-fb46-3fdd-881a-aa857dcdac00', 'RBD', '2019-07-26 02:16:49', null, 1, null, 0, 0, 'Initialized', _binary'DefaultPrimary', null, _binary'[email protected]/cloudstack', 6789, null, null, null, 0, null, null) at com.cloud.utils.db.GenericDaoBase.persist(GenericDaoBase.java:1427) at org.apache.cloudstack.storage.datastore.db.PrimaryDataStoreDaoImpl.persist(PrimaryDataStoreDaoImpl.java:262) 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.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at com.cloud.utils.db.TransactionContextInterceptor.invoke(TransactionContextInterceptor.java:34) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:91) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy67.persist(Unknown Source) at org.apache.cloudstack.storage.volume.datastore.PrimaryDataStoreHelper.createPrimaryDataStore(PrimaryDataStoreHelper.java:132) at org.apache.cloudstack.storage.datastore.lifecycle.CloudStackPrimaryDataStoreLifeCycleImpl.initialize(CloudStackPrimaryDataStoreLifeCycleImpl.java:353) at com.cloud.storage.StorageManagerImpl.createPool(StorageManagerImpl.java:706) at com.cloud.storage.StorageManagerImpl.createPool(StorageManagerImpl.java:199) at org.apache.cloudstack.api.command.admin.storage.CreateStoragePoolCmd.execute(CreateStoragePoolCmd.java:163) at com.cloud.api.ApiDispatcher.dispatch(ApiDispatcher.java:150) at com.cloud.api.ApiServer.queueCommand(ApiServer.java:709) at com.cloud.api.ApiServer.handleRequest(ApiServer.java:533) at com.cloud.api.ApiServlet.processRequestInContext(ApiServlet.java:299) at com.cloud.api.ApiServlet$1.run(ApiServlet.java:129) at org.apache.cloudstack.managed.context.impl.DefaultManagedContext$1.call(DefaultManagedContext.java:56) at org.apache.cloudstack.managed.context.impl.DefaultManagedContext.callWithContext(DefaultManagedContext.java:103) at org.apache.cloudstack.managed.context.impl.DefaultManagedContext.runWithContext(DefaultManagedContext.java:53) at com.cloud.api.ApiServlet.processRequest(ApiServlet.java:126) at com.cloud.api.ApiServlet.doGet(ApiServlet.java:88) at javax.servlet.http.HttpServlet.service(HttpServlet.java:624) at javax.servlet.http.HttpServlet.service(HttpServlet.java:731) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:962) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1087) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1770) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1729) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'host_address' cannot be null at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ... 68 more 2019-07-26 10:16:49,794 INFO [c.c.a.ApiServer] (catalina-exec-2:ctx-8368781e ctx-616f5ed3) (logid:151a79c4) Failed to add data store: DB Exception on: com.mysql.jdbc.JDBC4PreparedStatement@38670f4f: INSERT INTO storage_pool (storage_pool.id, storage_pool.name, storage_pool.uuid, storage_pool.pool_type, storage_pool.created, storage_pool.update_time, storage_pool.data_center_id, storage_pool.pod_id, storage_pool.used_bytes, storage_pool.capacity_bytes, storage_pool.status, storage_pool.storage_provider_name, storage_pool.host_address, storage_pool.path, storage_pool.port, storage_pool.user_info, storage_pool.cluster_id, storage_pool.scope, storage_pool.managed, storage_pool.capacity_iops, storage_pool.hypervisor) VALUES (0, _binary'Z1_PRI1_CEPH', _binary'ca5cbccb-fb46-3fdd-881a-aa857dcdac00', 'RBD', '2019-07-26 02:16:49', null, 1, null, 0, 0, 'Initialized', _binary'DefaultPrimary', null, _binary'[email protected]/cloudstack', 6789, null, null, null, 0, null, null) 2019-07-26 10:16:49,796 DEBUG [c.c.a.ApiServlet] (catalina-exec-2:ctx-8368781e ctx-616f5ed3) (logid:151a79c4) ===END=== 10.0.1.11 -- GET command=createStoragePool&zoneid=e744901f-745a-4bb0-b8e3-4b1cf4ca9b60&podId=964682b7-367b-4d1a-8a48-c55b4e986fe7&clusterid=9dc1e904-57d7-4678-b4e8-cb2380abc93e&name=Z1_PRI1_CEPH&scope=zone&hypervisor=KVM&url=rbd%3A%2F%2Fcloudstack%3AAQATDjld4LBvBxAABbwFU5C_m%2FaTVkI95xrSzw%3D%3D%40192.168.100.10%2Fcloudstack&response=json&_=1564107409711 ```
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services
