Helge,
Thanks for sharing, have you upgraded both the management server and KVM host to 4.9.0? If so, from the mgmt server host are you able to access MySQL server, and can you share your MySQL server version? Are you able to run the SQL statement (the insert query, as seen in the error) on mysql. It is possible that something went wrong during the (db) upgrade paths causing schemas to not match what is expected by the 4.9.0 mgmt server. To investigate further can you increase log level to TRACE in the log4j xml/config file at /etc/cloudstack/management/, then try to add a host and share with exactly what error sql-error addHost operation fails. Regards. ________________________________ From: Helge Waastad <[email protected]> Sent: 01 September 2016 01:45:00 To: [email protected] Subject: Issue with 4.9.0 and kvm (ubuntu 14.04) Hi, I've started to test cloudstack (been running openstack before) but have som issues with the 4.9.0 release. It's working fine in 4.5.2 adding an advanced zone, the add host step fails with following: management server: DEBUG [c.c.a.m.AgentManagerImpl] (AgentConnectTaskPool-1:ctx-b5018830) (logid:ee42ac03) Failed to handle host connection: com.cloud.utils.exception.CloudRuntimeException: DB Exception on: com.m ysql.jdbc.JDBC4PreparedStatement@61cefb84: 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.cpu_sockets, 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'csmgmt-compute', 'Creating', 'Routing', _binary'192.168.56.101', _binary'52:54:00:76:c0:a8', _binary'255.255.255.0', null, null, null, _binary'192.168.56.101', 1, _binary'255.255.255.0', _binary'52:54:00:76:c0:a8', null, null, null, 'KVM', null, null, null, 1, 0, 'Creating', null, 0, _binary'7a631491- 3457-4f6c-a7d8-c0b6b9489170', 1, 1, 4, 4, null, 2292, -32821248, null, _binary'e1618560-81d4-3072-9c57-0b10e6cf83a8-LibvirtComputingResource', _binary'hvm,snapshot', null, 1438157518, 90520735303118, 0, _binary'4.9.0', '2016-08-31 19:54:58') 2016-08-31 19:54:58,926 WARN [c.c.a.m.AgentManagerImpl] (AgentConnectTaskPool-1:ctx-b5018830) (logid:ee42ac03) Unable to create attache for agent: Seq 0-0: { Cmd , MgmtId: -1, via: 0, Ver: v1, Flags: 1, [{"com.cloud.agent.api.StartupRoutingCommand":{"cpuSockets":4,"cpus":4, "speed":2292,"memory":- 32821248,"dom0MinMemory":1073741824,"poolSync":false,"supportsClonedVol umes":false,"caps":"hvm,snapshot","pool":"/root","hypervisorType":"KVM" ,"hostDetails":{"com.cloud.network.Networks.RouterPrivateIpStrategy":"H ostLocal","Host.OS":"Ubuntu","Host.OS.Kernel.Version":"3.13.0-93- generic","Host.OS.Version":"14.04"},"hostTags":[],"groupDetails":{},"ty pe":"Routing","dataCenter":"1","pod":"1","cluster":"1","guid":"e1618560 -81d4-3072-9c57-0b10e6cf83a8-LibvirtComputingResource","name":"csmgmt- compute","id":0,"version":"4.9.0","privateIpAddress":"192.168.56.101"," privateMacAddress":"52:54:00:76:c0:a8","privateNetmask":"255.255.255.0" ,"storageIpAddress":"192.168.56.101","storageNetmask":"255.255.255.0"," storageMacAddress":"52:54:00:76:c0:a8","resourceName":"LibvirtComputing Resource","gatewayIpAddress":"192.168.122.1","wait":0}},{"com.cloud.age nt.api.StartupStorageCommand":{"totalSize":0,"poolInfo":{"uuid":"f16894 7f-abad-43a5-82c2- a420c76f1c7c","host":"192.168.56.101","localPath":"/var/lib/libvirt/ima ges","hostPath":"/var/lib/libvirt/images","poolType":"Filesystem","capa cityBytes":19674116096,"availableBytes":17889828864},"resourceType":"ST ORAGE_POOL","hostDetails":{},"type":"Storage","dataCenter":"1","pod":"1 ","guid":"e1618560-81d4-3072-9c57-0b10e6cf83a8- LibvirtComputingResource","name":"csmgmt- compute","id":0,"version":"4.9.0","resourceName":"LibvirtComputingResou rce","wait":0}}] } 2016-08-31 19:54:58,943 WARN [c.c.a.m.AgentManagerImpl] (AgentManager- Handler-3:null) (logid:) Throwing away a request because it came through as the first command on a connect: Seq 0--1: { Cmd , MgmtId: -1, via: 0, Ver: v1, Flags: 111, [{"com.cloud.agent.api.ShutdownCommand":{"reason":"sig.kill","wait":0}} ] } 2016-08-31 19:54:58,983 WARN [c.c.a.m.AgentManagerImpl] (AgentManager- Handler-4:null) (logid:) Throwing away a request because it came through as the first command on a connect: Seq 0-1: { Cmd , MgmtId: -1, via: 0, Ver: v1, Flags: 11, [{"com.cloud.agent.api.PingRoutingWithNwGroupsCommand":{"newGroupStates ":{},"_hostVmStateReport":{},"_gatewayAccessible":true,"_vnetAccessible ":true,"hostType":"Routing","hostId":0,"wait":0}}] } and on the kvm host: DEBUG [cloud.agent.Agent] (agentRequest-Handler-1:null) (logid:) Not ready to connect to mgt server: com.cloud.utils.exception.CloudRuntimeException: DB Exception on: com.m ysql.jdbc.JDBC4PreparedStatement@61cefb84: 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.cpu_sockets, 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'csmgmt-compute', 'Creating', 'Routing', _binary'192.168.56.101', _binary'52:54:00:76:c0:a8', _binary'255.255.255.0', null, null, null, _binary'192.168.56.101', 1, _binary'255.255.255.0', _binary'52:54:00:76:c0:a8', null, null, null, 'KVM', null, null, null, 1, 0, 'Creating', null, 0, _binary'7a631491- 3457-4f6c-a7d8-c0b6b9489170', 1, 1, 4, 4, null, 2292, -32821248, null, _binary'e1618560-81d4-3072-9c57-0b10e6cf83a8-LibvirtComputingResource', _binary'hvm,snapshot', null, 1438157518, 90520735303118, 0, _binary'4.9.0', '2016-08-31 19:54:58') 2016-08-31 19:54:58,932 INFO [cloud.agent.Agent] (AgentShutdownThread:null) (logid:) Stopping the agent: Reason = sig.kill 2016-08-31 19:54:58,933 DEBUG [cloud.agent.Agent] (AgentShutdownThread:null) (logid:) Sending shutdown to management server I have'nt tried the other releases inbetween, but can always do so later on. any suggestions are welcome. br hw [email protected] www.shapeblue.com 53 Chandos Place, Covent Garden, London WC2N 4HSUK @shapeblue
