Charles Moulliard created CLOUDSTACK-412: --------------------------------------------
Summary: Data truncation: Out of range value for column 'ram' at row 1 Key: CLOUDSTACK-412 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-412 Project: CloudStack Issue Type: Bug Reporter: Charles Moulliard Fix For: 4.1.0 During the deployment process on the target machine (= DevCloud VM running in VirtualBox), the following exception occurs and no storages and VM have been created : mvn -P developer,deploysvr -pl tools/devcloud -Ddeploysvr {code} [INFO] Started Jetty Server INFO [cloud.resource.ResourceManagerImpl] (1081948798@qtp-961137686-14:) Trying to add a new host at http://192.168.56.2/ in data center 1 INFO [xen.discoverer.XcpServerDiscoverer] (1081948798@qtp-961137686-14:) Found host devcloud ip=192.168.56.2 product version=1.6.0 INFO [xen.resource.CitrixResourceBase] (1081948798@qtp-961137686-14:) Private Network is Pool-wide network associated with eth0 for host 192.168.56.2 INFO [xen.resource.CitrixResourceBase] (1081948798@qtp-961137686-14:) Guest Network is Pool-wide network associated with eth0 for host 192.168.56.2 INFO [xen.resource.CitrixResourceBase] (1081948798@qtp-961137686-14:) Public Network is Pool-wide network associated with eth0 for host 192.168.56.2 INFO [xen.discoverer.XcpServerDiscoverer] (1081948798@qtp-961137686-14:) Host: devcloud connected with hypervisor type: XenServer. Checking CIDR... WARN [cloud.resource.ResourceManagerImpl] (1081948798@qtp-961137686-14:) Unable to connect due to com.cloud.utils.exception.CloudRuntimeException: DB Exception on: com.mysql.jdbc.JDBC4PreparedStatement@3ecbca0b: INSERT INTO host (host.disconnected, host.name, host.status, host.type, host.private_ip_address, host.private_mac_address, host.private_netmask, host.public_netmask, host.public_ip_address, host.public_mac_address, host.storage_ip_address, host.cluster_id, host.storage_netmask, host.storage_mac_address, host.storage_ip_address_2, host.storage_netmask_2, host.storage_mac_address_2, host.hypervisor_type, host.proxy_port, host.resource, host.fs_type, host.available, host.setup, host.resource_state, host.hypervisor_version, host.update_count, host.uuid, host.data_center_id, host.pod_id, host.cpus, host.url, host.speed, host.ram, host.parent, host.guid, host.capabilities, host.total_size, host.last_ping, host.mgmt_server_id, host.dom0_memory, host.version, host.created) VALUES (null, _binary'devcloud', 'Creating', 'Routing', _binary'192.168.56.2', _binary'08:00:27:7e:74:9c', _binary'255.255.255.0', null, null, null, null, 1, null, null, null, null, null, 'XenServer', null, _binary'com.cloud.hypervisor.xen.resource.XcpOssResource', null, 1, 0, 'Creating', null, 0, _binary'ab9665fd-5119-4b2f-8f51-b80c7634d95a', 1, 1, 1, _binary'', 2644, -128447424, null, _binary'759ee4c9-a15a-297b-67c6-ac267d8aa429', _binary'xen-3.0-x86_64 , xen-3.0-x86_32p , hvm', null, 1319480950, 101318446450665, 0, _binary'4.1.0-SNAPSHOT', '2012-10-25 07:01:33') at com.cloud.utils.db.GenericDaoBase.persist(GenericDaoBase.java:1320) at com.cloud.host.dao.HostDaoImpl.persist(HostDaoImpl.java:545) at com.cloud.utils.db.DatabaseCallback.intercept(DatabaseCallback.java:34) at com.cloud.host.dao.HostDaoImpl.persist(HostDaoImpl.java:63) at com.cloud.resource.ResourceManagerImpl.createHostVO(ResourceManagerImpl.java:1569) at com.cloud.resource.ResourceManagerImpl.createHostAndAgent(ResourceManagerImpl.java:1629) at com.cloud.resource.ResourceManagerImpl.discoverHostsFull(ResourceManagerImpl.java:720) at com.cloud.resource.ResourceManagerImpl.discoverHosts(ResourceManagerImpl.java:544) at com.cloud.api.commands.AddHostCmd.execute(AddHostCmd.java:140) at com.cloud.api.ApiDispatcher.dispatch(ApiDispatcher.java:167) at com.cloud.api.ApiServer.queueCommand(ApiServer.java:539) at com.cloud.api.ApiServer.handleRequest(ApiServer.java:423) at com.cloud.api.ApiServlet.processRequest(ApiServlet.java:304) at com.cloud.api.ApiServlet.doGet(ApiServlet.java:63) at javax.servlet.http.HttpServlet.service(HttpServlet.java:707) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:401) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:450) at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:230) at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.Server.handle(Server.java:326) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542) at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:928) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:549) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404) at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410) at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582) Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'ram' at row 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4072) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2468) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2629) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2719) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2450) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2371) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2355) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) at com.cloud.utils.db.GenericDaoBase.persist(GenericDaoBase.java:1283) ... 37 more INFO [cloud.resource.ResourceManagerImpl] (1081948798@qtp-961137686-14:) server resources successfully discovered by XCP Agent WARN [cloud.api.ApiDispatcher] (1081948798@qtp-961137686-14:) class com.cloud.api.ServerApiException : Failed to add host INFO [cloud.resource.ResourceManagerImpl] (1081948798@qtp-961137686-14:) Trying to add a new host at nfs://192.168.56.2:/opt/storage/secondary in data center 1 ERROR [cloud.resource.ServerResourceBase] (1081948798@qtp-961137686-14:) Nics are not configured! INFO [cloud.resource.ServerResourceBase] (1081948798@qtp-961137686-14:) Designating private to be nic vboxnet0 INFO [network.security.SecurityGroupListener] (1081948798@qtp-961137686-14:) Received a host startup notification WARN [agent.manager.AgentManagerImpl] (1081948798@qtp-961137686-14:) Resource [Host:1] is unreachable: Host 1: Host with specified id is not in the right state: Connecting INFO [agent.manager.AgentManagerImpl] (1081948798@qtp-961137686-14:) Host 1 is disconnecting with event AgentDisconnected INFO [cloud.resource.ResourceManagerImpl] (1081948798@qtp-961137686-14:) server resources successfully discovered by SecondaryStorage INFO [cloud.configuration.ConfigurationManagerImpl] (1081948798@qtp-961137686-14:) No storage traffic type was specified by admin, create default storage traffic on physical network 200 with same configure of management traffic type {code} -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira