Hudratronium commented on issue #6698:
URL: https://github.com/apache/cloudstack/issues/6698#issuecomment-1236671876
@shwstppr
Here the whole log with comments on database actions from my system. Out of
interest: new created CS4.17 setup or upgraded from 4.16 / 4.15 / .... ?
Cann you maybe take a look into your db and lookig if you can find in
`domain_vlan_map` a entry for referencing the vlan which is enabled for use
with systemVMs and the domain you are actually using ?
~~~
###################################################################### Nic
allocation
2022-08-31 18:44:21,203 DEBUG [c.c.v.VirtualMachineManagerImpl]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Allocating nics for VM instance
{id: "86", name: "v-86-VM", uuid: "6f77acb4-c65e-49e8-ae03-1175b3974412",
type="ConsoleProxy"}
2022-08-31 18:44:21,203 TRACE [c.c.u.d.T.Transaction]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Using current transaction:
consoleproxy-1 : tx-79, consoleproxy-1,
2022-08-31 18:44:21,204 TRACE [c.c.u.d.T.Transaction]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) txn: start requested by:
-Transaction.execute:39-NetworkOrchestrator.allocate:778-VirtualMachineManagerImpl$1.doInTransactionWithoutResult:478-TransactionCallbackWithExceptionNoReturn.doInTransaction:25-TransactionCallbackWithExceptionNoReturn.doInTransaction:21-Transaction.execute:40-VirtualMachineManagerImpl.allocate:469-VirtualMachineManagerImpl.allocate:528-ConsoleProxyManagerImpl.createProxyInstance:700-ConsoleProxyManagerImpl.startNew:572-ConsoleProxyManagerImpl.allocCapacity:809-ConsoleProxyManagerImpl.expandPool:1537
2022-08-31 18:44:21,204 TRACE [c.c.u.d.T.Transaction]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) txn: has already been started.
2022-08-31 18:44:21,204 TRACE [o.a.c.e.o.NetworkOrchestrator]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) allocating networks for
v-86-VM(template c20799e4-a990-449a-aae6-4b67374c7aff); 3 networks
2022-08-31 18:44:21,204 TRACE [c.c.u.d.T.Transaction]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Using current transaction:
consoleproxy-1 : tx-80, tx-79, consoleproxy-1,
2022-08-31 18:44:21,206 TRACE [c.c.u.d.T.Connection]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Creating a DB connection with
txn: for 0: dbconn623913035. Stack:
-TransactionLegacy.prepareStatement:466-TransactionLegacy.prepareAutoCloseStatement:459-GenericDaoBase.searchIncludingRemoved:396-GenericDaoBase.searchIncludingRemoved:359-GenericDaoBase.search:348-GenericDaoBase.search:1319-TemplateDeployAsIsDetailsDaoImpl.listDetailsByTemplateIdMatchingPrefix:64-TemplateDeployAsIsDetailsDaoImpl.listNetworkRequirementsByTemplateId:69-NativeMethodAccessorImpl.invoke0:-2-NativeMethodAccessorImpl.invoke:62-DelegatingMethodAccessorImpl.invoke:43-Method.invoke:566
2022-08-31 18:44:21,206 TRACE [c.c.u.d.T.Statement]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Preparing: SELECT
template_deploy_as_is_details.id, template_deploy_as_is_details.template_id,
template_deploy_as_is_details.name, template_deploy_as_is_details.value FROM
template_deploy_as_is_details WHERE template_deploy_as_is_details.template_id =
? AND template_deploy_as_is_details.name LIKE ?
#### template_deploy_as_is_details = empty --> no results returned
2022-08-31 18:44:21,206 TRACE [c.c.u.d.T.Statement]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Closing:
com.mysql.cj.jdbc.ClientPreparedStatement: SELECT
template_deploy_as_is_details.id, template_deploy_as_is_details.template_id,
template_deploy_as_is_details.name, template_deploy_as_is_details.value FROM
template_deploy_as_is_details WHERE template_deploy_as_is_details.template_id =
213 AND template_deploy_as_is_details.name LIKE x'6E6574776F726B2D25'
2022-08-31 18:44:21,207 TRACE [c.c.u.d.T.Connection]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) txn: Not closing DB connection
because we're still in a transaction.
2022-08-31 18:44:21,207 TRACE [c.c.u.d.T.Transaction]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Using current transaction:
consoleproxy-1 : tx-80, tx-79, consoleproxy-1,
2022-08-31 18:44:21,207 TRACE [c.c.u.d.T.Transaction]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) conn: Using existing DB
connection
2022-08-31 18:44:21,207 TRACE [c.c.u.d.T.Statement]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Preparing: SELECT networks.id,
networks.mode, networks.broadcast_domain_type, networks.traffic_type,
networks.name, networks.display_text, networks.broadcast_uri, networks.gateway,
networks.cidr, networks.network_cidr, networks.network_offering_id,
networks.vpc_id, networks.physical_network_id, networks.data_center_id,
networks.related, networks.guru_name, networks.state, networks.redundant,
networks.dns1, networks.domain_id, networks.account_id, networks.set_fields,
networks.guru_data, networks.dns2, networks.network_domain, networks.removed,
networks.created, networks.reservation_id, networks.uuid, networks.guest_type,
networks.acl_type, networks.restart_required, networks.specify_ip_ranges,
networks.ip6_gateway, networks.ip6_cidr, networks.display_network,
networks.network_acl_id, networks.streched_l2, networks.external_id FROM
networks WHERE networks.id = ? AND networks.removed
IS NULL
2022-08-31 18:44:21,209 DEBUG [o.a.c.e.o.NetworkOrchestrator]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Allocating nic for vm VM
instance {id: "86", name: "v-86-VM", uuid:
"6f77acb4-c65e-49e8-ae03-1175b3974412", type="ConsoleProxy"} in network Network
{"id": 200, "name": "null", "uuid": "1b0bf965-a391-478d-833d-3e37e4a15eb8",
"networkofferingid": 1} with requested profile NicProfile
{"broadcastUri":null,"iPv4Address":null,"id":0,"reservationId":null,"vmId":0}
2022-08-31 18:44:21,209 TRACE [c.c.u.d.T.Transaction]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Using current transaction:
consoleproxy-1 : tx-80, tx-79, consoleproxy-1,
2022-08-31 18:44:21,209 TRACE [c.c.u.d.T.Transaction]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) conn: Using existing DB
connection
2022-08-31 18:44:21,209 TRACE [c.c.u.d.T.Statement]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Preparing: SELECT
data_center.id, data_center.name, data_center.description, data_center.dns1,
data_center.dns2, data_center.ip6_dns1, data_center.ip6_dns2,
data_center.internal_dns1, data_center.internal_dns2,
data_center.router_mac_address, data_center.guest_network_cidr,
data_center.domain_id, data_center.domain, data_center.networktype,
data_center.dns_provider, data_center.dhcp_provider,
data_center.gateway_provider, data_center.vpn_provider,
data_center.userdata_provider, data_center.lb_provider,
data_center.firewall_provider, data_center.mac_address, data_center.zone_token,
data_center.removed, data_center.allocation_state, data_center.uuid,
data_center.is_security_group_enabled, data_center.is_local_storage_enabled,
data_center.sort_key FROM data_center WHERE data_center.id = ? AND
data_center.removed IS NULL
### Allocating public nic
2022-08-31 18:44:21,209 TRACE [c.c.u.d.T.Statement]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Closing:
com.mysql.cj.jdbc.ClientPreparedStatement: SELECT networks.id, networks.mode,
networks.broadcast_domain_type, networks.traffic_type, networks.name,
networks.display_text, networks.broadcast_uri, networks.gateway, networks.cidr,
networks.network_cidr, networks.network_offering_id, networks.vpc_id,
networks.physical_network_id, networks.data_center_id, networks.related,
networks.guru_name, networks.state, networks.redundant, networks.dns1,
networks.domain_id, networks.account_id, networks.set_fields,
networks.guru_data, networks.dns2, networks.network_domain, networks.removed,
networks.created, networks.reservation_id, networks.uuid, networks.guest_type,
networks.acl_type, networks.restart_required, networks.specify_ip_ranges,
networks.ip6_gateway, networks.ip6_cidr, networks.display_network,
networks.network_acl_id, networks.streched_l2, networks.external_id FROM
networks WHE
RE networks.id = 200 AND networks.removed IS NULL
2022-08-31 18:44:21,209 TRACE [c.c.u.d.T.Transaction]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Using current transaction:
consoleproxy-1 : tx-80, tx-79, consoleproxy-1,
2022-08-31 18:44:21,209 TRACE [c.c.u.d.T.Transaction]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) conn: Using existing DB
connection
2022-08-31 18:44:21,209 TRACE [c.c.u.d.T.Statement]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Preparing: SELECT account.id,
account.account_name, account.type, account.role_id, account.domain_id,
account.state, account.created, account.removed, account.cleanup_needed,
account.network_domain, account.uuid, account.default_zone_id, account.default
FROM account WHERE account.id = ? AND account.removed IS NULL
### Getting Zone Information
2022-08-31 18:44:21,209 TRACE [c.c.u.d.T.Statement]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Closing:
com.mysql.cj.jdbc.ClientPreparedStatement: SELECT data_center.id,
data_center.name, data_center.description, data_center.dns1, data_center.dns2,
data_center.ip6_dns1, data_center.ip6_dns2, data_center.internal_dns1,
data_center.internal_dns2, data_center.router_mac_address,
data_center.guest_network_cidr, data_center.domain_id, data_center.domain,
data_center.networktype, data_center.dns_provider, data_center.dhcp_provider,
data_center.gateway_provider, data_center.vpn_provider,
data_center.userdata_provider, data_center.lb_provider,
data_center.firewall_provider, data_center.mac_address, data_center.zone_token,
data_center.removed, data_center.allocation_state, data_center.uuid,
data_center.is_security_group_enabled, data_center.is_local_storage_enabled,
data_center.sort_key FROM data_center WHERE data_center.id = 1 AND
data_center.removed IS NULL
2022-08-31 18:44:21,211 TRACE [c.c.u.d.T.Transaction]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Using current transaction:
consoleproxy-1 : tx-80, tx-79, consoleproxy-1,
2022-08-31 18:44:21,211 TRACE [c.c.u.d.T.Transaction]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) txn: start requested by:
-Transaction.execute:39-IpAddressManagerImpl.listAvailablePublicIps:824-IpAddressManagerImpl.fetchNewPublicIp:811-IpAddressManagerImpl.fetchNewPublicIp:803-IpAddressManagerImpl.assignPublicIpAddress:784-PublicNetworkGuru.getIp:125-PublicNetworkGuru.allocate:172-NetworkOrchestrator.allocateNic:973-NetworkOrchestrator$3.addRequestedNicToNicListWithDeviceNumberAndRetrieveDefaultDevice:823-NetworkOrchestrator$3.doInTransactionWithoutResult:797-TransactionCallbackWithExceptionNoReturn.doInTransaction:25-TransactionCallbackWithExceptionNoReturn.doInTransaction:21
2022-08-31 18:44:21,211 TRACE [c.c.u.d.T.Transaction]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) txn: has already been started.
2022-08-31 18:44:21,211 TRACE [c.c.u.d.T.Transaction]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Using current transaction:
consoleproxy-1 : tx-81, tx-80, tx-79, consoleproxy-1,
2022-08-31 18:44:21,211 TRACE [c.c.u.d.T.Transaction]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) conn: Using existing DB
connection
2022-08-31 18:44:21,211 TRACE [c.c.u.d.T.Statement]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Preparing: SELECT
data_center.id, data_center.name, data_center.description, data_center.dns1,
data_center.dns2, data_center.ip6_dns1, data_center.ip6_dns2,
data_center.internal_dns1, data_center.internal_dns2,
data_center.router_mac_address, data_center.guest_network_cidr,
data_center.domain_id, data_center.domain, data_center.networktype,
data_center.dns_provider, data_center.dhcp_provider,
data_center.gateway_provider, data_center.vpn_provider,
data_center.userdata_provider, data_center.lb_provider,
data_center.firewall_provider, data_center.mac_address, data_center.zone_token,
data_center.removed, data_center.allocation_state, data_center.uuid,
data_center.is_security_group_enabled, data_center.is_local_storage_enabled,
data_center.sort_key FROM data_center WHERE data_center.id = ? AND
data_center.removed IS NULL
### Account Information "system"
2022-08-31 18:44:21,211 TRACE [c.c.u.d.T.Statement]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Closing:
com.mysql.cj.jdbc.ClientPreparedStatement: SELECT account.id,
account.account_name, account.type, account.role_id, account.domain_id,
account.state, account.created, account.removed, account.cleanup_needed,
account.network_domain, account.uuid, account.default_zone_id, account.default
FROM account WHERE account.id = 1 AND account.removed IS NULL
2022-08-31 18:44:21,212 TRACE [c.c.u.d.T.Transaction]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Using current transaction:
consoleproxy-1 : tx-81, tx-80, tx-79, consoleproxy-1,
2022-08-31 18:44:21,212 TRACE [c.c.u.d.T.Transaction]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) conn: Using existing DB
connection
2022-08-31 18:44:21,212 TRACE [c.c.u.d.T.Statement]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Preparing: SELECT networks.id,
networks.mode, networks.broadcast_domain_type, networks.traffic_type,
networks.name, networks.display_text, networks.broadcast_uri, networks.gateway,
networks.cidr, networks.network_cidr, networks.network_offering_id,
networks.vpc_id, networks.physical_network_id, networks.data_center_id,
networks.related, networks.guru_name, networks.state, networks.redundant,
networks.dns1, networks.domain_id, networks.account_id, networks.set_fields,
networks.guru_data, networks.dns2, networks.network_domain, networks.removed,
networks.created, networks.reservation_id, networks.uuid, networks.guest_type,
networks.acl_type, networks.restart_required, networks.specify_ip_ranges,
networks.ip6_gateway, networks.ip6_cidr, networks.display_network,
networks.network_acl_id, networks.streched_l2, networks.external_id FROM
networks WHERE networks.id = ? AND networks.removed
IS NULL
### Getting Zone Information
2022-08-31 18:44:21,212 TRACE [c.c.u.d.T.Statement]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Closing:
com.mysql.cj.jdbc.ClientPreparedStatement: SELECT data_center.id,
data_center.name, data_center.description, data_center.dns1, data_center.dns2,
data_center.ip6_dns1, data_center.ip6_dns2, data_center.internal_dns1,
data_center.internal_dns2, data_center.router_mac_address,
data_center.guest_network_cidr, data_center.domain_id, data_center.domain,
data_center.networktype, data_center.dns_provider, data_center.dhcp_provider,
data_center.gateway_provider, data_center.vpn_provider,
data_center.userdata_provider, data_center.lb_provider,
data_center.firewall_provider, data_center.mac_address, data_center.zone_token,
data_center.removed, data_center.allocation_state, data_center.uuid,
data_center.is_security_group_enabled, data_center.is_local_storage_enabled,
data_center.sort_key FROM data_center WHERE data_center.id = 1 AND
data_center.removed IS NULL
2022-08-31 18:44:21,212 TRACE [c.c.u.d.T.Transaction]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Using current transaction:
consoleproxy-1 : tx-81, tx-80, tx-79, consoleproxy-1,
2022-08-31 18:44:21,212 TRACE [c.c.u.d.T.Transaction]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) conn: Using existing DB
connection
2022-08-31 18:44:21,212 TRACE [c.c.u.d.T.Statement]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Preparing: SELECT
account_vlan_map.id, account_vlan_map.account_id, account_vlan_map.vlan_db_id
FROM account_vlan_map WHERE account_vlan_map.account_id = ?
### Getting network information
2022-08-31 18:44:21,212 TRACE [c.c.u.d.T.Statement]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Closing:
com.mysql.cj.jdbc.ClientPreparedStatement: SELECT networks.id, networks.mode,
networks.broadcast_domain_type, networks.traffic_type, networks.name,
networks.display_text, networks.broadcast_uri, networks.gateway, networks.cidr,
networks.network_cidr, networks.network_offering_id, networks.vpc_id,
networks.physical_network_id, networks.data_center_id, networks.related,
networks.guru_name, networks.state, networks.redundant, networks.dns1,
networks.domain_id, networks.account_id, networks.set_fields,
networks.guru_data, networks.dns2, networks.network_domain, networks.removed,
networks.created, networks.reservation_id, networks.uuid, networks.guest_type,
networks.acl_type, networks.restart_required, networks.specify_ip_ranges,
networks.ip6_gateway, networks.ip6_cidr, networks.display_network,
networks.network_acl_id, networks.streched_l2, networks.external_id FROM
networks WHE
RE networks.id = null AND networks.removed IS NULL
2022-08-31 18:44:21,213 TRACE [c.c.u.d.T.Transaction]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Using current transaction:
consoleproxy-1 : tx-81, tx-80, tx-79, consoleproxy-1,
2022-08-31 18:44:21,213 TRACE [c.c.u.d.T.Transaction]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) conn: Using existing DB
connection
2022-08-31 18:44:21,213 TRACE [c.c.u.d.T.Statement]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Preparing: SELECT
domain_vlan_map.id, domain_vlan_map.domain_id, domain_vlan_map.vlan_db_id FROM
domain_vlan_map WHERE domain_vlan_map.domain_id = ?
#### Account_vlan_map - no entry for account "System" nor for Account
"Admin"
2022-08-31 18:44:21,213 TRACE [c.c.u.d.T.Statement]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Closing:
com.mysql.cj.jdbc.ClientPreparedStatement: SELECT account_vlan_map.id,
account_vlan_map.account_id, account_vlan_map.vlan_db_id FROM account_vlan_map
WHERE account_vlan_map.account_id = 1
2022-08-31 18:44:21,213 TRACE [c.c.u.d.T.Transaction]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Using current transaction:
consoleproxy-1 : tx-81, tx-80, tx-79, consoleproxy-1,
2022-08-31 18:44:21,213 TRACE [c.c.u.d.T.Transaction]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) conn: Using existing DB
connection
2022-08-31 18:44:21,213 TRACE [c.c.u.d.T.Statement]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Preparing: SELECT vlan.id,
vlan.vlan_id, vlan.vlan_gateway, vlan.vlan_netmask, vlan.ip6_gateway,
vlan.ip6_cidr, vlan.data_center_id, vlan.ip4_range, vlan.ip6_range,
vlan.network_id, vlan.physical_network_id, vlan.vlan_type, vlan.uuid,
vlan.removed, vlan.created FROM vlan LEFT OUTER JOIN domain_vlan_map ON
vlan.id=domain_vlan_map.vlan_db_id LEFT OUTER JOIN account_vlan_map ON
vlan.id=account_vlan_map.vlan_db_id WHERE vlan.data_center_id = ? AND
vlan.removed IS NULL AND (domain_vlan_map.domain_id IS NULL ) AND
(account_vlan_map.account_id IS NULL )
### Checking for availeable VLANS for domain --> VLAN for system VM not
shown / or in the result
2022-08-31 18:44:21,213 TRACE [c.c.u.d.T.Statement]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Closing:
com.mysql.cj.jdbc.ClientPreparedStatement: SELECT domain_vlan_map.id,
domain_vlan_map.domain_id, domain_vlan_map.vlan_db_id FROM domain_vlan_map
WHERE domain_vlan_map.domain_id = 1
### Checking for availeable VLANS wich are NOT assigned to ANY Account NOR
to ANY Domain --> Result is the intended vlan with expected IP Range
2022-08-31 18:44:21,214 TRACE [c.c.u.d.GenericDaoBase]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) join search statement is
com.mysql.cj.jdbc.ClientPreparedStatement: SELECT vlan.id, vlan.vlan_id,
vlan.vlan_gateway, vlan.vlan_netmask, vlan.ip6_gateway, vlan.ip6_cidr,
vlan.data_center_id, vlan.ip4_range, vlan.ip6_range, vlan.network_id,
vlan.physical_network_id, vlan.vlan_type, vlan.uuid, vlan.removed, vlan.created
FROM vlan LEFT OUTER JOIN domain_vlan_map ON
vlan.id=domain_vlan_map.vlan_db_id LEFT OUTER JOIN account_vlan_map ON
vlan.id=account_vlan_map.vlan_db_id WHERE vlan.data_center_id = 1 AND
vlan.removed IS NULL AND (domain_vlan_map.domain_id IS NULL ) AND
(account_vlan_map.account_id IS NULL )
2022-08-31 18:44:21,214 TRACE [c.c.u.d.T.Transaction]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Using current transaction:
consoleproxy-1 : tx-81, tx-80, tx-79, consoleproxy-1,
2022-08-31 18:44:21,214 TRACE [c.c.u.d.T.Transaction]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) conn: Using existing DB
connection
2022-08-31 18:44:21,214 TRACE [c.c.u.d.T.Statement]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Preparing: SELECT
configuration.instance, configuration.component, configuration.name,
configuration.value, configuration.default_value, configuration.description,
configuration.category, configuration.is_dynamic, configuration.scope,
configuration.updated FROM configuration WHERE configuration.name = ?
### Getting further information on the vlan --> correct choice of expected
VLAN + IP-Range
2022-08-31 18:44:21,214 TRACE [c.c.u.d.T.Statement]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Closing:
com.mysql.cj.jdbc.ClientPreparedStatement: SELECT vlan.id, vlan.vlan_id,
vlan.vlan_gateway, vlan.vlan_netmask, vlan.ip6_gateway, vlan.ip6_cidr,
vlan.data_center_id, vlan.ip4_range, vlan.ip6_range, vlan.network_id,
vlan.physical_network_id, vlan.vlan_type, vlan.uuid, vlan.removed, vlan.created
FROM vlan LEFT OUTER JOIN domain_vlan_map ON
vlan.id=domain_vlan_map.vlan_db_id LEFT OUTER JOIN account_vlan_map ON
vlan.id=account_vlan_map.vlan_db_id WHERE vlan.data_center_id = 1 AND
vlan.removed IS NULL AND (domain_vlan_map.domain_id IS NULL ) AND
(account_vlan_map.account_id IS NULL )
2022-08-31 18:44:21,215 TRACE [c.c.u.d.T.Transaction]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Using current transaction:
consoleproxy-1 : tx-81, tx-80, tx-79, consoleproxy-1,
2022-08-31 18:44:21,215 TRACE [c.c.u.d.T.Transaction]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) conn: Using existing DB
connection
2022-08-31 18:44:21,215 TRACE [c.c.u.d.T.Statement]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Preparing: 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 WHERE
user_ip_address.data_center_id = ? AND user_ip_address.allocated IS NULL AND
user_ip_address.vlan_db_
id IN (?,?,?,?) AND user_ip_address.forsystemvms = ? AND
user_ip_address.removed IS NULL AND (vlan.vlan_type = ? ) ORDER BY
user_ip_address.forsystemvms DESC , user_ip_address.vlan_db_id ASC LIMIT 0, 1
FOR UPDATE
### Check of setting system.vm.public.ip.reservation.mode.strictness -->
value "true"
2022-08-31 18:44:21,215 TRACE [c.c.u.d.T.Statement]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Closing:
com.mysql.cj.jdbc.ClientPreparedStatement: SELECT configuration.instance,
configuration.component, configuration.name, configuration.value,
configuration.default_value, configuration.description, configuration.category,
configuration.is_dynamic, configuration.scope, configuration.updated FROM
configuration WHERE configuration.name =
x'73797374656D2E766D2E7075626C69632E69702E7265736572766174696F6E2E6D6F64652E7374726963746E657373'
2022-08-31 18:44:21,215 TRACE [c.c.u.d.GenericDaoBase]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) join search statement is
com.mysql.cj.jdbc.ClientPreparedStatement: 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 WHERE
user_ip_address.data_center_id = 1 AND use
r_ip_address.allocated IS NULL AND user_ip_address.vlan_db_id IN (3,10,13,14)
AND user_ip_address.forsystemvms = 1 AND user_ip_address.removed IS NULL AND
(vlan.vlan_type = 'VirtualNetwork' ) ORDER BY user_ip_address.forsystemvms
DESC , user_ip_address.vlan_db_id ASC LIMIT 0, 1 FOR UPDATE
2022-08-31 18:44:21,216 TRACE [c.c.u.d.T.Transaction]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) conn: Using existing DB
connection
2022-08-31 18:44:21,216 TRACE [c.c.u.d.T.Statement]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Preparing: SELECT
account_details.id, account_details.account_id, account_details.name,
account_details.value FROM account_details WHERE account_details.account_id = ?
AND account_details.name = ? ORDER BY RAND() LIMIT 1
### Trying to fetch IP-Address: No value / ip address returned - Domain
"Root" shall provide ip addresses; thats where the vlanIDs are comming from -->
user_ip_address.vlan_db_id IN (3,10,13,14)
2022-08-31 18:44:21,216 TRACE [c.c.u.d.T.Statement]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Closing:
com.mysql.cj.jdbc.ClientPreparedStatement: 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 WHERE
user_ip_address.data_center_id = 1 AND user_ip_address.alloca
ted IS NULL AND user_ip_address.vlan_db_id IN (3,10,13,14) AND
user_ip_address.forsystemvms = 1 AND user_ip_address.removed IS NULL AND
(vlan.vlan_type = 'VirtualNetwork' ) ORDER BY user_ip_address.forsystemvms DESC
, user_ip_address.vlan_db_id ASC LIMIT 0, 1 FOR UPDATE
2022-08-31 18:44:21,216 TRACE [c.c.u.d.T.Transaction]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Using current transaction:
consoleproxy-1 : tx-81, tx-80, tx-79, consoleproxy-1,
2022-08-31 18:44:21,216 TRACE [c.c.u.d.T.Transaction]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) conn: Using existing DB
connection
2022-08-31 18:44:21,216 TRACE [c.c.u.d.T.Statement]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Preparing: SELECT
configuration.instance, configuration.component, configuration.name,
configuration.value, configuration.default_value, configuration.description,
configuration.category, configuration.is_dynamic, configuration.scope,
configuration.updated FROM configuration WHERE configuration.name = ? ORDER BY
RAND() LIMIT 1
### Trying to get information from the table account_detail for the account
"system". Table is empty so no result back
2022-08-31 18:44:21,216 TRACE [c.c.u.d.T.Statement]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Closing:
com.mysql.cj.jdbc.ClientPreparedStatement: SELECT account_details.id,
account_details.account_id, account_details.name, account_details.value FROM
account_details WHERE account_details.account_id = 1 AND account_details.name
= x'7573652E73797374656D2E7075626C69632E697073' ORDER BY RAND() LIMIT 1
2022-08-31 18:44:21,217 TRACE [c.c.u.d.T.Transaction]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Using current transaction:
consoleproxy-1 : tx-81, tx-80, tx-79, consoleproxy-1,
2022-08-31 18:44:21,217 TRACE [c.c.u.d.T.Transaction]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) conn: Using existing DB
connection
2022-08-31 18:44:21,217 TRACE [c.c.u.d.T.Statement]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Preparing: SELECT
configuration.instance, configuration.component, configuration.name,
configuration.value, configuration.default_value, configuration.description,
configuration.category, configuration.is_dynamic, configuration.scope,
configuration.updated FROM configuration WHERE configuration.name = ?
### Check for Configuration enable.account.settings.for.domain --> current
value = false
2022-08-31 18:44:21,217 TRACE [c.c.u.d.T.Statement]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Closing:
com.mysql.cj.jdbc.ClientPreparedStatement: SELECT configuration.instance,
configuration.component, configuration.name, configuration.value,
configuration.default_value, configuration.description, configuration.category,
configuration.is_dynamic, configuration.scope, configuration.updated FROM
configuration WHERE configuration.name =
x'656E61626C652E6163636F756E742E73657474696E67732E666F722E646F6D61696E' ORDER
BY RAND() LIMIT 1
2022-08-31 18:44:21,217 WARN [c.c.n.IpAddressManagerImpl]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Unable to get ip address in
zone id=1, vlanId id=[3, 10, 13, 14]
2022-08-31 18:44:21,218 TRACE [c.c.u.d.T.Transaction]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Using current transaction:
consoleproxy-1 : tx-81, tx-80, tx-79, consoleproxy-1,
2022-08-31 18:44:21,218 TRACE [c.c.u.d.T.Transaction]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) conn: Using existing DB
connection
2022-08-31 18:44:21,218 TRACE [c.c.u.d.T.Statement]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Preparing: SELECT
data_center.id, data_center.name, data_center.description, data_center.dns1,
data_center.dns2, data_center.ip6_dns1, data_center.ip6_dns2,
data_center.internal_dns1, data_center.internal_dns2,
data_center.router_mac_address, data_center.guest_network_cidr,
data_center.domain_id, data_center.domain, data_center.networktype,
data_center.dns_provider, data_center.dhcp_provider,
data_center.gateway_provider, data_center.vpn_provider,
data_center.userdata_provider, data_center.lb_provider,
data_center.firewall_provider, data_center.mac_address, data_center.zone_token,
data_center.removed, data_center.allocation_state, data_center.uuid,
data_center.is_security_group_enabled, data_center.is_local_storage_enabled,
data_center.sort_key FROM data_center WHERE data_center.id = ? AND
data_center.removed IS NULL
### Check for setting use.system.public.ips --> current value = false
2022-08-31 18:44:21,218 TRACE [c.c.u.d.T.Statement]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Closing:
com.mysql.cj.jdbc.ClientPreparedStatement: SELECT configuration.instance,
configuration.component, configuration.name, configuration.value,
configuration.default_value, configuration.description, configuration.category,
configuration.is_dynamic, configuration.scope, configuration.updated FROM
configuration WHERE configuration.name =
x'7573652E73797374656D2E7075626C69632E697073'
### getting information for the current data_center / zone
2022-08-31 18:44:21,219 TRACE [c.c.u.d.T.Statement]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Closing:
com.mysql.cj.jdbc.ClientPreparedStatement: SELECT data_center.id,
data_center.name, data_center.description, data_center.dns1, data_center.dns2,
data_center.ip6_dns1, data_center.ip6_dns2, data_center.internal_dns1,
data_center.internal_dns2, data_center.router_mac_address,
data_center.guest_network_cidr, data_center.domain_id, data_center.domain,
data_center.networktype, data_center.dns_provider, data_center.dhcp_provider,
data_center.gateway_provider, data_center.vpn_provider,
data_center.userdata_provider, data_center.lb_provider,
data_center.firewall_provider, data_center.mac_address, data_center.zone_token,
data_center.removed, data_center.allocation_state, data_center.uuid,
data_center.is_security_group_enabled, data_center.is_local_storage_enabled,
data_center.sort_key FROM data_center WHERE data_center.id = 1 AND
data_center.removed IS NULL
2022-08-31 18:44:21,219 DEBUG [c.c.u.d.T.Transaction]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Rolling back the transaction:
Time = 17 Name = consoleproxy-1; called by
-TransactionLegacy.rollback:888-TransactionLegacy.removeUpTo:831-TransactionLegacy.close:655-Transaction.execute:38-IpAddressManagerImpl.listAvailablePublicIps:824-IpAddressManagerImpl.fetchNewPublicIp:811-IpAddressManagerImpl.fetchNewPublicIp:803-IpAddressManagerImpl.assignPublicIpAddress:784-PublicNetworkGuru.getIp:125-PublicNetworkGuru.allocate:172-NetworkOrchestrator.allocateNic:973-NetworkOrchestrator$3.addRequestedNicToNicListWithDeviceNumberAndRetrieveDefaultDevice:823
2022-08-31 18:44:21,219 TRACE [c.c.u.d.T.Lock] (consoleproxy-1:ctx-a0aef6e9)
(logid:d5e7c7c1) SQL com.mysql.cj.jdbc.ClientPreparedStatement: 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 WHERE
user_ip_address.data_center_id = 1 AND user_ip_address.allocated IS NUL
L AND user_ip_address.vlan_db_id IN (3,10,13,14) AND
user_ip_address.forsystemvms = 1 AND user_ip_address.removed IS NULL AND
(vlan.vlan_type = 'VirtualNetwork' ) ORDER BY user_ip_address.forsystemvms DESC
, user_ip_address.vlan_db_id ASC LIMIT 0, 1 FOR UPDATE took 4
2022-08-31 18:44:21,219 TRACE [c.c.u.d.T.Connection]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Closing DB connection:
dbconn623913035
2022-08-31 18:44:21,220 WARN [c.c.c.ConsoleProxyManagerImpl]
(consoleproxy-1:ctx-a0aef6e9) (logid:d5e7c7c1) Unable to allocate proxy
[Console VM instance {id: "86", name: "v-86-VM", uuid:
"6f77acb4-c65e-49e8-ae03-1175b3974412", type="ConsoleProxy"}] on zone [1] due
to [Insufficient address capacity].
com.cloud.exception.InsufficientAddressCapacityException: Insufficient
address capacityScope=interface com.cloud.dc.DataCenter; id=1
~~~
--
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]
