slavkap commented on issue #5240:
URL: https://github.com/apache/cloudstack/issues/5240#issuecomment-886974277


   The error msg from the log says that there isn't an IP address for the guest 
VM. The SQL query is:
   
   > SELECT user_ip_address.id, user_ip_address.account_id, 
user_ip_address.domain_id, user_ip_address.public_ip_address, 
user_ip_address.data_center_id, user_ip_address.source_nat, 
user_ip_address.allocated, user_ip_address.vlan_db_id, 
user_ip_address.one_to_one_nat, user_ip_address.vm_id, user_ip_address.state, 
user_ip_address.mac_address, user_ip_address.source_network_id, 
user_ip_address.network_id, user_ip_address.uuid, 
user_ip_address.physical_network_id, user_ip_address.is_system, 
user_ip_address.vpc_id, user_ip_address.dnat_vmip, user_ip_address.is_portable, 
user_ip_address.display, user_ip_address.rule_state, 
user_ip_address.forsystemvms, user_ip_address.removed, user_ip_address.created 
   FROM user_ip_address  INNER JOIN vlan 
   ON user_ip_address.vlan_db_id=vlan.id  
   INNER JOIN pod_vlan_map 
   ON user_ip_address.vlan_db_id=pod_vlan_map.vlan_db_id 
   WHERE user_ip_address.data_center_id = 2  
   AND user_ip_address.allocated IS NULL  
   AND user_ip_address.removed IS NULL  
   AND  (vlan.vlan_type = 'DirectAttached'  AND vlan.network_id = 209 ) 
   AND (pod_vlan_map.pod_id = 2 ) 
   ORDER BY user_ip_address.forsystemvms ASC , user_ip_address.vlan_db_id ASC  
LIMIT 0, 1 FOR UPDATE;
   
   Can you test this with the respective values of your setup?


-- 
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.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


Reply via email to