Hi,
And Thx for investing time on this.
Its not an upgrade, its a new install.
But I did another test on another PC and it worked fine. Right now I suspect
some kind of resource issue (processor/memory) and I'll try to verify the diffs
between the two.
I'll keep you posted over the weekend.
The virtual agents/management server are the same (ubuntu 14.04) on both
systems,but different hardware.
/hw
Sendt fra min iPhone
> Den 2. sep. 2016 kl. 02.26 skrev Rohit Yadav <rohit.ya...@shapeblue.com>:
>
> 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 <he...@waastad.org>
> Sent: 01 September 2016 01:45:00
> To: users@cloudstack.apache.org
> 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
>
> rohit.ya...@shapeblue.com
> www.shapeblue.com
> 53 Chandos Place, Covent Garden, London WC2N 4HSUK
> @shapeblue
>
>
>
