weizhouapache commented on issue #11607: URL: https://github.com/apache/cloudstack/issues/11607#issuecomment-3310849496
I cannot reproduced the issue nics ``` mysql> select * from nics where ip4_address='10.0.18.7'; +----+--------------------------------------+-------------+-------------------+-------------+---------------+-----------+---------+-----------------+------------+------+----------+-------------+---------------------------+--------------------------------------+-----------+-------------+---------------+-------------+-------------+--------------+---------------------+---------+-------------+----------+--------------+-------------+------+ | id | uuid | instance_id | mac_address | ip4_address | netmask | gateway | ip_type | broadcast_uri | network_id | mode | state | strategy | reserver_name | reservation_id | device_id | update_time | isolation_uri | ip6_address | default_nic | vm_type | created | removed | ip6_gateway | ip6_cidr | secondary_ip | display_nic | mtu | +----+--------------------------------------+-------------+-------------------+-------------+---------------+-----------+---------+-----------------+------------+------+----------+-------------+---------------------------+--------------------------------------+-----------+-------------+---------------+-------------+-------------+--------------+---------------------+---------+-------------+----------+--------------+-------------+------+ | 8 | c1f7ceec-cfbf-4cda-8219-bdea7d8406bd | 4 | 1e:00:b7:00:00:18 | 10.0.18.7 | 255.255.240.0 | 10.0.16.1 | Ip4 | vlan://untagged | 204 | Dhcp | Reserved | Start | DirectPodBasedNetworkGuru | aa1b7cd2-34ed-4cb7-92c7-d51f017fa99b | 0 | NULL | NULL | NULL | 1 | DomainRouter | 2025-09-19 06:41:40 | NULL | NULL | NULL | 0 | 1 | 1500 | | 10 | 6ccf3215-bbd7-44f1-aa2a-68aaf1d3e4f8 | NULL | NULL | 10.0.18.7 | NULL | NULL | NULL | NULL | 204 | NULL | Reserved | PlaceHolder | NULL | NULL | 0 | NULL | NULL | NULL | 0 | DomainRouter | 2025-09-19 06:41:41 | NULL | NULL | NULL | 0 | 1 | NULL | +----+--------------------------------------+-------------+-------------------+-------------+---------------+-----------+---------+-----------------+------------+------+----------+-------------+---------------------------+--------------------------------------+-----------+-------------+---------------+-------------+-------------+--------------+---------------------+---------+-------------+----------+--------------+-------------+------+ 2 rows in set (0.00 sec) ``` user_ip_address ``` mysql> select * from user_ip_address where public_ip_address='10.0.18.7'; +----+--------------------------------------+------------+-----------+-------------------+----------------+------------+---------------------+------------+----------------+-------+-----------+-------------+-------------------+------------+---------------------+-----------+--------+-----------+-------------+---------+---------+---------+------------+--------------+------------+ | id | uuid | account_id | domain_id | public_ip_address | data_center_id | source_nat | allocated | vlan_db_id | one_to_one_nat | vm_id | state | mac_address | source_network_id | network_id | physical_network_id | is_system | vpc_id | dnat_vmip | is_portable | display | removed | created | rule_state | forsystemvms | for_router | +----+--------------------------------------+------------+-----------+-------------------+----------------+------------+---------------------+------------+----------------+-------+-----------+-------------+-------------------+------------+---------------------+-----------+--------+-----------+-------------+---------+---------+---------+------------+--------------+------------+ | 4 | 3151a4bf-7452-4196-bc7b-03c61ec39fda | 1 | 1 | 10.0.18.7 | 1 | 0 | 2025-09-19 06:41:41 | 1 | 0 | NULL | Allocated | 24 | 204 | NULL | 200 | 0 | NULL | NULL | 0 | 1 | NULL | NULL | NULL | 0 | 0 | +----+--------------------------------------+------------+-----------+-------------------+----------------+------------+---------------------+------------+----------------+-------+-----------+-------------+-------------------+------------+---------------------+-----------+--------+-----------+-------------+---------+---------+---------+------------+--------------+------------+ 1 row in set (0.00 sec) ``` -- 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: commits-unsubscr...@cloudstack.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org