vCenter/vSphere is Inaccessible Due to Error in VPXD Logs "ODBC error: (22001) - ERROR: value too long for type character varying(48);"

Products

• VMware vSphere ESXi

Issue/Introduction

vSphere is inaccessible when connecting a host to vCenter. 

Environment

VMware vCenter Server 

Cause

VPXD is crashing due to the vpx_dvport table column external_id being exhausted. When re-connecting a host to vCenter, VPXD performs a host sync and when it fails to add a value VPXD crashes making the vCenter inaccessible. 

/var/log/vmware/vpxd/vpxd.log:

####-##-##T##:##:## error vpxd[#####] [Originator@#### sub=Default opID=#######################] [VdbStatement] SQLError was thrown: "ODBC error: (22001) - ERROR: value too long for type character varying(48);

/var/log/vmware/vpostgres/vpostgresql.log: 

####-##-## ##:##:## ############.##### 0 VCDB vpxd [local] 236487 4ERROR:  value too long for type character varying(48)
####-##-## ##:##:## ############.##### 0 VCDB vpxd [local] 236487 5STATEMENT:  UPDATE VPX_DVPORT SET NAME=$1,DESCRIPTION=$2,CONFIG_VERSION=$3,LINK_UP=$4,LINK_BLOCKED=$5,PROXY_HOST=$6,TRUNK_MODE_FLG=$7,CONFLICT_FLG=$8,CONFLICT_PORT_KEY=$9,CONNECTION_COOKIE=$10,LAST_STATUS_CHANGE=$11,MTU=$12,LINK_PEER=$13,MAC_ADDRESS=$14,STATUS_DETAIL=$15,NPT_ACTIVE=$16,NPT_INACTIVE_NET=$17,NPT_INACTIVE_OTHER=$18,NPT_INACTIVE_MISC=$19,STATS_PACKET_IN_MULTICAST=$20,STATS_PACKET_OUT_MULTICAST=$21,STATS_BYTE_IN_MULTICAST=$22,STATS_BYTE_OUT_MULTICAST=$23,STATS_PACKET_IN_UNICAST=$24,STATS_PACKET_OUT_UNICAST=$25,STATS_BYTE_IN_UNICAST=$26,STATS_BYTE_OUT_UNICAST=$27,STATS_PACKET_IN_BROADCAST=$28,STATS_PACKET_OUT_BROADCAST=$29,STATS_BYTE_IN_BROADCAST=$30,STATS_BYTE_OUT_BROADCAST=$31,STATS_PACKET_IN_DROPPED=$32,STATS_PACKET_OUT_DROPPED=$33,STATS_PACKET_IN_EXCEPTION=$34,STATS_PACKET_OUT_EXCEPTION=$35,PERSISTENCE_LOCATION=$36,CONNECTEE=$37,CONNECTEE_TYPE=$38,CONNECTEE_NIC_KEY=$39,CONNECTEE_ADDRESS=$40,RESERVED_TIME=$41,POWERING_ON_FLG=$42,LAST_CONNECTEE=$43,HOST_LOCAL_PORT_FLG=$44,EXTERNAL_ID=$45,BACKING_TYPE=$46,SEGMENT_PORT_ID=$47 WHERE DVS_ID=$48 AND DVPORT_KEY=$49

Resolution

Please contact Broadcom support to address this issue.