1. su - dbuser -c "source /home/dbuser/appgsdb.bashrc; gsql -d dcnnwpersistentdb -U ossdbuser -W Changeme_123 -p `cat /opt/oss/envs/Product-DCNService/\`ls /opt/oss/envs/Product-DCNService/ | awk 'END {print}'\`/etc/sysconf/DCNService-*.json | grep -A 2 "dcnnwpersistentdb" | grep "port" | awk -F':' '{print $2}' | awk -F',' '{print $1}' | awk '{print $1}'` -h `cat /opt/oss/envs/Product-DCNService/\`ls /opt/oss/envs/Product-DCNService/ | awk 'END {print}'\`/etc/sysconf/DCNService-*.json | grep -A 2 "dcnnwpersistentdb" | grep "serverName" | awk -F':' '{print $2}' | awk -F',' '{print $1}' | awk '{print $1}' | awk -F'"' '{print $2}'`"
    4. 错误信息： 错误状态=400, 错误码=0x003400a8, 错误内容=VLAN resources failed to be applied. The possible causes are as follows: 1. The VLAN resources are not configured. 2. The VLAN resources have been occupied. 3. The VLAN resources are out of the VLAN range. 修改端口。（端口id=23e5135d-6f5f-4697-82e6-ad51bd33eebd，所属网络id=502182bd-bf3e-4f49-a530-242e58b73226，mac地址=fa:16:3e:04:06:e0，允许的地址对=[]，端口所属的对象类型=compute:az0.dc0，租户名称=4c1dfd643b2e4f35b7e4a7281e18b442，端口名称=，租户id=4c1dfd643b2e4f35b7e4a7281e18b442，云平台=FusionSphere，创建时间=2020-12-02T20:24:58，修改时间=2020-12-10T10:39:25，管理状态=true，状态=null，DHCP的选项=[]，端口所属子网及IP地址=[{"ip-address":"10.82.100.29","subnet-id":"56a05ca4-e259-42a0-8466-23db5231fb78"}]，端口所属安全组=["fb55412a-9ec7-4928-87e6-76fd0d430cc0"]，端口所属的对象ID=22983bbc-01d6-4412-bd12-a847f81efc2b，qos策略id=null，trunk id=null， trunk子端口信息=null，主机=44454C4C-5900-1035-804B-C4C04F4A3233，虚接口详述=[]，虚接口类型=unbound，虚网卡类型=normal，profile={'physical_network': 'physnet2', 'migrating_to': '', 'vm-name': 'cHJvZC10ZXN0', 'availability_zone': 'az0.dc0'}，dns-name=None，dns-assignment=null，端口安全使能=true）
    11. select * from tab_dcn_svo_rowlock where res_id ='HostAllocateVlan_502182bd-bf3e-4f49-a530-242e58b73226_44454C4C-5900-1035-804B-C4C04F4A3233';
    13. select * from tab_dcn_bindport where host_id='44454C4C-5900-1035-804B-C4C04F4A3233' and network_id='502182bd-bf3e-4f49-a530-242e58b73226';
    15. select * from tab_dcn_logic_port_device_info where device_id='72dbe78a-7e57-3c2d-8f64-bad74993889d' and device_port_id='d9477568-48b3-38b5-ae2f-71e0e8e82e4f';
    21. -[ RECORD 1 ]-----+-------------------------------------
    22. ID                | be702da8-732d-4f1c-9572-cd9b01c8bf63
    23. LOGIC_PORT_ID     | ac81469a-15d7-487c-833d-60c83abbe2d1
    24. DEVICE_GROUP_ID   | 4b0d624c-6ece-4b7b-93fe-a37b5a49c643
    25. DEVICE_GROUP_NAME | B02D13_Leaf
    26. DEVICE_ID         | 72dbe78a-7e57-3c2d-8f64-bad74993889d
    27. DEVICE_NAME       | ZJ_B02D13_CE6856_Leaf_2
    28. DEVICE_PORT_ID    | d9477568-48b3-38b5-ae2f-71e0e8e82e4f
    29. DEVICE_PORT_NAME  | 10GE1/0/15
    30. -[ RECORD 2 ]-----+-------------------------------------
    31. ID                | ad64cc88-7a62-4fba-a5a9-3bb0c91a574f
    32. LOGIC_PORT_ID     | ab3fc0a1-8fa8-4c31-8d50-b50c60e0279c
    33. DEVICE_GROUP_ID   | 4b0d624c-6ece-4b7b-93fe-a37b5a49c643
    34. DEVICE_GROUP_NAME | B02D13_Leaf
    35. DEVICE_ID         | 72dbe78a-7e57-3c2d-8f64-bad74993889d
    36. DEVICE_NAME       | ZJ_B02D13_CE6856_Leaf_2
    37. DEVICE_PORT_ID    | d9477568-48b3-38b5-ae2f-71e0e8e82e4f
    38. DEVICE_PORT_NAME  | 10GE1/0/15
    39. -[ RECORD 3 ]-----+-------------------------------------
    40. ID                | 558fc5ee-92f8-4c97-8b06-32cbc1334b61
    41. LOGIC_PORT_ID     | cd206138-6378-453c-b202-ee78ae21e81f
    42. DEVICE_GROUP_ID   | 4b0d624c-6ece-4b7b-93fe-a37b5a49c643
    43. DEVICE_GROUP_NAME | B02D13_Leaf
    44. DEVICE_ID         | 72dbe78a-7e57-3c2d-8f64-bad74993889d
    45. DEVICE_NAME       | ZJ_B02D13_CE6856_Leaf_2
    46. DEVICE_PORT_ID    | d9477568-48b3-38b5-ae2f-71e0e8e82e4f
    47. DEVICE_PORT_NAME  | 10GE1/0/15
    48. -[ RECORD 4 ]-----+-------------------------------------
    49. ID                | 39051536-7243-4197-8304-db584e622305
    50. LOGIC_PORT_ID     | 5c6a333b-7331-4d7a-a1b7-e9d3a3c2d552
    51. DEVICE_GROUP_ID   | 4b0d624c-6ece-4b7b-93fe-a37b5a49c643
    52. DEVICE_GROUP_NAME | B02D13_Leaf
    53. DEVICE_ID         | 72dbe78a-7e57-3c2d-8f64-bad74993889d
    54. DEVICE_NAME       | ZJ_B02D13_CE6856_Leaf_2
    55. DEVICE_PORT_ID    | d9477568-48b3-38b5-ae2f-71e0e8e82e4f
    56. DEVICE_PORT_NAME  | 10GE1/0/15
    59. select * from tab_dcn_logic_port where pk_dcn_id='ac81469a-15d7-487c-833d-60c83abbe2d1';
    60. select * from tab_dcn_logic_port where pk_dcn_id='ab3fc0a1-8fa8-4c31-8d50-b50c60e0279c';
    61. select * from tab_dcn_logic_port where pk_dcn_id='cd206138-6378-453c-b202-ee78ae21e81f';
    62. select * from tab_dcn_logic_port where pk_dcn_id='5c6a333b-7331-4d7a-a1b7-e9d3a3c2d552';
    64. \q
    66. neutron-port-id":"311211ef-3003-438f-8c5b-851ac55594fd"  100.83
    67. neutron-port-id":"6b8c76ce-9cf6-4b7a-a9a8-e98a21b1d0a5"   100.82
    69. select * from tab_dcn_neutron_port where uuid='311211ef-3003-438f-8c5b-851ac55594fd';
    70. select * from tab_dcn_neutron_port where uuid='6b8c76ce-9cf6-4b7a-a9a8-e98a21b1d0a5';
    71. select * from tab_dcn_bindport where host_id='44454C4C-5900-1035-804B-C4C04F4A3233' and network_id='502182bd-bf3e-4f49-a530-242e58b73226';
    76. DCNNWPERSISTENTDB=> select * from tab_dcn_bindport where host_id='44454C4C-5900-1035-804B-C4C04F4A3233' and network_id='502182bd-bf3e-4f49-a530-242e58b73226';
    77. -[ RECORD 1 ]-------------------------------------
    78. ID          | 8bea57e4-059c-43b4-86bf-b69e1abd3c2d
    79. HOST_ID     | 44454C4C-5900-1035-804B-C4C04F4A3233
    80. NETWORK_ID  | 502182bd-bf3e-4f49-a530-242e58b73226
    81. DEV_PORT    | 04e3f672-ee98-36b6-92fc-79eaa4c56503
    82. DEV_ID      | 73e3f43d-3acd-3534-8c9d-1b1de56205d9
    83. VLAN        | 3199
    84. HOST_TYPE   | 0
    85. CREATE_TIME | 2020-05-22 23:10:47.175554
    86. -[ RECORD 2 ]-------------------------------------
    87. ID          | ee4dac69-9845-4a5d-a52b-876b4f59f2e7
    88. HOST_ID     | 44454C4C-5900-1035-804B-C4C04F4A3233
    89. NETWORK_ID  | 502182bd-bf3e-4f49-a530-242e58b73226
    90. DEV_PORT    | d9477568-48b3-38b5-ae2f-71e0e8e82e4f
    91. DEV_ID      | 72dbe78a-7e57-3c2d-8f64-bad74993889d
    92. VLAN        | 3199
    93. HOST_TYPE   | 0
    94. CREATE_TIME | 2020-05-22 23:10:47.176314
    96. DCNNWPERSISTENTDB=> select * from tab_dcn_logic_port_device_info where device_id='72dbe78a-7e57-3c2d-8f64-bad74993889d' and device_port_id='d9477568-48b3-38b5-ae2f-71e0e8e82e4f';
    97. DCNNWPERSISTENTDB=> 
    98. DCNNWPERSISTENTDB=> select * from tab_dcn_logic_port where pk_dcn_id='ac81469a-15d7-487c-833d-60c83abbe2d1';
    99. -[ RECORD 1 ]--------+---------------------------------------------
    100. PK_DCN_ID            | ac81469a-15d7-487c-833d-60c83abbe2d1
    101. APP_ID               | b55e1af1-4ae1-4a65-adc6-fe082b23e354
    102. NAME                 | B02D13_CE6856_External_OM_Dell_AP_Compute_15
    103. DESCRIPTION          | 
    104. CREATE_TYPE          | 
    105. FABRIC_ID            | 97ba4d47-6efd-43f3-8554-9ffa3a2b1818
    106. LOGIC_SWITCH_ID      | e43a4e6e-9155-45c3-8ac3-a8829c1d2fc8
    107. QOS_TEMPLATE         | 
    108. QOS_SHAPING_TEMPLATE | 
    109. ACCESS_TYPE          | Dot1q
    110. REWRITE_ACTION       | 
    111. SUB_INTERFACE_INDEX  | 
    112. OUTER_VLAN_BEGIN     | 
    113. OUTER_VLAN_END       | 
    114. INNER_VLAN_BEGIN     | 
    115. INNER_VLAN_END       | 
    116. VLAN_ID              | 3904
    117. EGRESS_VLAN_ID       | 
    118. POSITION_X           | 0
    119. POSITION_Y           | 0
    120. READ_ONLY            | f
    121. PRODUCER             | 
    122. DEPLOYED             | t
    123. TO_DEPLOY            | t
    124. TENANT_ID            | 00000000-0000-0000-0000-000000000000
    125. ACCESS_MODE          | Uni
    126. IMPORTED             | t
    127. SECURITY_GROUP       | 
    128. META_DATA            | 
    129. ETH_TRUNK_MODE       | 
    130. TRAFFIC_BLOCK_ID     | 
    131. VMM_PRE_CONFIG       | 
    132. UPDATE_TIME          | 
    133. CREATE_TIME          | 2020-04-16 12:44:05
    135. DCNNWPERSISTENTDB=> select * from tab_dcn_logic_port where pk_dcn_id='ab3fc0a1-8fa8-4c31-8d50-b50c60e0279c';
    136. -[ RECORD 1 ]--------+-----------------------------------------------
    137. PK_DCN_ID            | ab3fc0a1-8fa8-4c31-8d50-b50c60e0279c
    138. APP_ID               | b55e1af1-4ae1-4a65-adc6-fe082b23e354
    139. NAME                 | B02D13_CE6856_Internal_Base_Dell_AP_Compute_15
    140. DESCRIPTION          | 
    141. CREATE_TYPE          | 
    142. FABRIC_ID            | 97ba4d47-6efd-43f3-8554-9ffa3a2b1818
    143. LOGIC_SWITCH_ID      | a96db617-e500-4a26-bfd6-4848df81021b
    144. QOS_TEMPLATE         | 
    145. QOS_SHAPING_TEMPLATE | 
    146. ACCESS_TYPE          | Untag
    147. REWRITE_ACTION       | 
    148. SUB_INTERFACE_INDEX  | 
    149. OUTER_VLAN_BEGIN     | 
    150. OUTER_VLAN_END       | 
    151. INNER_VLAN_BEGIN     | 
    152. INNER_VLAN_END       | 
    153. VLAN_ID              | 
    154. EGRESS_VLAN_ID       | 
    155. POSITION_X           | 0
    156. POSITION_Y           | 0
    157. READ_ONLY            | f
    158. PRODUCER             | 
    159. DEPLOYED             | t
    160. TO_DEPLOY            | t
    161. TENANT_ID            | 00000000-0000-0000-0000-000000000000
    162. ACCESS_MODE          | Uni
    163. IMPORTED             | t
    164. SECURITY_GROUP       | 
    165. META_DATA            | 
    166. ETH_TRUNK_MODE       | 
    167. TRAFFIC_BLOCK_ID     | 
    168. VMM_PRE_CONFIG       | 
    169. UPDATE_TIME          | 
    170. CREATE_TIME          | 2020-04-16 12:44:33
    172. DCNNWPERSISTENTDB=> select * from tab_dcn_logic_port where pk_dcn_id='cd206138-6378-453c-b202-ee78ae21e81f';
    173. -[ RECORD 1 ]--------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    174. PK_DCN_ID            | cd206138-6378-453c-b202-ee78ae21e81f
    175. APP_ID               | 425a72be-4033-4359-af1d-d7a3b7449fe4
    176. NAME                 | lp-VM_port_10.82.100.82
    177. DESCRIPTION          | 
    178. CREATE_TYPE          | 
    179. FABRIC_ID            | 97ba4d47-6efd-43f3-8554-9ffa3a2b1818
    180. LOGIC_SWITCH_ID      | 502182bd-bf3e-4f49-a530-242e58b73226
    181. QOS_TEMPLATE         | 
    182. QOS_SHAPING_TEMPLATE | 
    183. ACCESS_TYPE          | Dot1q
    184. REWRITE_ACTION       | 
    185. SUB_INTERFACE_INDEX  | 
    186. OUTER_VLAN_BEGIN     | 
    187. OUTER_VLAN_END       | 
    188. INNER_VLAN_BEGIN     | 
    189. INNER_VLAN_END       | 
    190. VLAN_ID              | 3199
    191. EGRESS_VLAN_ID       | 
    192. POSITION_X           | 0
    193. POSITION_Y           | 0
    194. READ_ONLY            | t
    195. PRODUCER             | component-neutron
    196. DEPLOYED             | t
    197. TO_DEPLOY            | t
    198. TENANT_ID            | 4c1dfd64-3b2e-4f35-b7e4-a7281e18b442
    199. ACCESS_MODE          | Uni
    200. IMPORTED             | f
    201. SECURITY_GROUP       | fb55412a-9ec7-4928-87e6-76fd0d430cc0
    202. META_DATA            | {"neutron-port-id":"6b8c76ce-9cf6-4b7a-a9a8-e98a21b1d0a5","allow-address-pair-list":[],"vmip":"10.82.100.82","vmmac":"fa:16:3e:cf:e0:29","ifindex-value":"68","fixiplist":[{"vmip":"10.82.100.82"}],"cloud-name":"FusionSphere","neutron-port-name":"","fixipv6list":[],"port-security-enabled":true,"port-type":0,"vnic_type":"normal","status":true,"neutron-host-id":"44454C4C-5900-1035-804B-C4C04F4A3233"}
    203. ETH_TRUNK_MODE       | 
    204. TRAFFIC_BLOCK_ID     | 
    205. VMM_PRE_CONFIG       | 
    206. UPDATE_TIME          | 2020-05-22 23:10:57
    207. CREATE_TIME          | 2020-05-22 23:10:47
    209. DCNNWPERSISTENTDB=> select * from tab_dcn_logic_port where pk_dcn_id='5c6a333b-7331-4d7a-a1b7-e9d3a3c2d552';
    210. -[ RECORD 1 ]--------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    211. PK_DCN_ID            | 5c6a333b-7331-4d7a-a1b7-e9d3a3c2d552
    212. APP_ID               | 425a72be-4033-4359-af1d-d7a3b7449fe4
    213. NAME                 | lp-VM_port_10.82.100.83
    214. DESCRIPTION          | 
    215. CREATE_TYPE          | 
    216. FABRIC_ID            | 97ba4d47-6efd-43f3-8554-9ffa3a2b1818
    217. LOGIC_SWITCH_ID      | 502182bd-bf3e-4f49-a530-242e58b73226
    218. QOS_TEMPLATE         | 
    219. QOS_SHAPING_TEMPLATE | 
    220. ACCESS_TYPE          | Dot1q
    221. REWRITE_ACTION       | 
    222. SUB_INTERFACE_INDEX  | 
    223. OUTER_VLAN_BEGIN     | 
    224. OUTER_VLAN_END       | 
    225. INNER_VLAN_BEGIN     | 
    226. INNER_VLAN_END       | 
    227. VLAN_ID              | 3199
    228. EGRESS_VLAN_ID       | 
    229. POSITION_X           | 0
    230. POSITION_Y           | 0
    231. READ_ONLY            | t
    232. PRODUCER             | component-neutron
    233. DEPLOYED             | t
    234. TO_DEPLOY            | t
    235. TENANT_ID            | 4c1dfd64-3b2e-4f35-b7e4-a7281e18b442
    236. ACCESS_MODE          | Uni
    237. IMPORTED             | f
    238. SECURITY_GROUP       | fb55412a-9ec7-4928-87e6-76fd0d430cc0
    239. META_DATA            | {"neutron-port-id":"311211ef-3003-438f-8c5b-851ac55594fd","allow-address-pair-list":[],"vmip":"10.82.100.83","vmmac":"fa:16:3e:cb:67:d2","ifindex-value":"72","fixiplist":[{"vmip":"10.82.100.83"}],"cloud-name":"FusionSphere","neutron-port-name":"","fixipv6list":[],"port-security-enabled":true,"port-type":0,"vnic_type":"normal","status":true,"neutron-host-id":"44454C4C-5900-1035-804B-C4C04F4A3233"}
    240. ETH_TRUNK_MODE       | 
    241. TRAFFIC_BLOCK_ID     | 
    242. VMM_PRE_CONFIG       | 
    243. UPDATE_TIME          | 2020-05-22 23:11:36
    244. CREATE_TIME          | 2020-05-22 23:11:33
    246. DCNNWPERSISTENTDB=> select * from tab_dcn_neutron_port where uuid='311211ef-3003-438f-8c5b-851ac55594fd';
    247. -[ RECORD 1 ]--------+----------------------------------------------------------------------------------------------------
    248. UUID                 | 311211ef-3003-438f-8c5b-851ac55594fd
    249. NAME                 | 
    250. TENANT_ID            | 4c1dfd64-3b2e-4f35-b7e4-a7281e18b442
    251. ADMIN_STATE_UP       | t
    252. NETWORK_ID           | 502182bd-bf3e-4f49-a530-242e58b73226
    253. PROVIDER_ID          | 
    254. DEVICE_OWNER         | compute:az0.dc0
    255. MAC_ADDRESS          | fa:16:3e:cb:67:d2
    256. DEVICE_ID            | cf81f829-065b-4023-ab1b-53e76f0d469e
    257. QOS_POLICY_ID        | 
    258. HOST_ID              | 44454C4C-5900-1035-804B-C4C04F4A3233
    259. VIF_TYPE             | ovs
    260. VNIC_TYPE            | normal
    261. PROFILE              | {'physical_network': 'physnet1', 'vm-name': 'QUQtU0VSVkVSLUlULTA0', 'availability_zone': 'az0.dc0'}
    262. CLOUD_NAME           | FusionSphere
    263. TENANT_NAME          | 4c1dfd643b2e4f35b7e4a7281e18b442
    264. SECURITY_GROUPS      | {fb55412a-9ec7-4928-87e6-76fd0d430cc0}
    265. STATUS               | 
    266. CREATED_AT           | 2020-05-22T23:05:33
    267. UPDATED_AT           | 2020-05-22T23:11:26
    268. QOS_FROM_NETWORK     | f
    269. DNS_NAME             | None
    270. PORT_SECURITY_ENABLE | t
    272. DCNNWPERSISTENTDB=> select * from tab_dcn_neutron_port where uuid='6b8c76ce-9cf6-4b7a-a9a8-e98a21b1d0a5';
    273. -[ RECORD 1 ]--------+----------------------------------------------------------------------------------------------------
    274. UUID                 | 6b8c76ce-9cf6-4b7a-a9a8-e98a21b1d0a5
    275. NAME                 | 
    276. TENANT_ID            | 4c1dfd64-3b2e-4f35-b7e4-a7281e18b442
    277. ADMIN_STATE_UP       | t
    278. NETWORK_ID           | 502182bd-bf3e-4f49-a530-242e58b73226
    279. PROVIDER_ID          | 
    280. DEVICE_OWNER         | compute:az0.dc0
    281. MAC_ADDRESS          | fa:16:3e:cf:e0:29
    282. DEVICE_ID            | 5787243e-a7af-4490-a718-fbbbaa6e7d00
    283. QOS_POLICY_ID        | 
    284. HOST_ID              | 44454C4C-5900-1035-804B-C4C04F4A3233
    285. VIF_TYPE             | ovs
    286. VNIC_TYPE            | normal
    287. PROFILE              | {'physical_network': 'physnet1', 'vm-name': 'QUQtU0VSVkVSLUlULTAz', 'availability_zone': 'az0.dc0'}
    288. CLOUD_NAME           | FusionSphere
    289. TENANT_NAME          | 4c1dfd643b2e4f35b7e4a7281e18b442
    290. SECURITY_GROUPS      | {fb55412a-9ec7-4928-87e6-76fd0d430cc0}
    291. STATUS               | 
    292. CREATED_AT           | 2020-05-22T23:04:43
    293. UPDATED_AT           | 2020-05-22T23:10:47
    294. QOS_FROM_NETWORK     | f
    295. DNS_NAME             | None
    296. PORT_SECURITY_ENABLE | t
    298. DCNNWPERSISTENTDB=> 
    302. [ RECORD 1 ]-------------------------------------
    303. ID          | 8bea57e4-059c-43b4-86bf-b69e1abd3c2d
    304. HOST_ID     | 44454C4C-5900-1035-804B-C4C04F4A3233
    305. NETWORK_ID  | 502182bd-bf3e-4f49-a530-242e58b73226
    306. DEV_PORT    | 04e3f672-ee98-36b6-92fc-79eaa4c56503
    307. DEV_ID      | 73e3f43d-3acd-3534-8c9d-1b1de56205d9
    308. VLAN        | 3199
    309. HOST_TYPE   | 0
    310. CREATE_TIME | 2020-05-22 23:10:47.175554
    311. -[ RECORD 2 ]-------------------------------------
    312. ID          | ee4dac69-9845-4a5d-a52b-876b4f59f2e7
    313. HOST_ID     | 44454C4C-5900-1035-804B-C4C04F4A3233
    314. NETWORK_ID  | 502182bd-bf3e-4f49-a530-242e58b73226
    315. DEV_PORT    | d9477568-48b3-38b5-ae2f-71e0e8e82e4f
    316. DEV_ID      | 72dbe78a-7e57-3c2d-8f64-bad74993889d
    317. VLAN        | 3199
    318. HOST_TYPE   | 0
    319. CREATE_TIME | 2020-05-22 23:10:47.176314
    323. select * from tab_dcn_logic_port_device_info where device_id='73e3f43d-3acd-3534-8c9d-1b1de56205d9' and device_port_id='04e3f672-ee98-36b6-92fc-79eaa4c56503';
    326. neutron port-show 311211ef-3003-438f-8c5b-851ac55594fd
    327. neutron port-show 6b8c76ce-9cf6-4b7a-a9a8-e98a21b1d0a5