vCenter will auto restart

[NXxIT]

Hello All,

Environment: Window Server 2012 R2 + vCenter Server 6.5 installed on HP DL180 Gen9.

HP server auto restarted from last Friday, it work normal several hours after restart. But the CPU will suddenly consume 100% caused by Java which used by vmon.exe; I cannot login the webclient and everything is stuck. Then server will auto restart anytime.

the related event log as below:

An unrecoverable problem has occurred, stopping the VMware VirtualCenter service. Error: Error[VdbODBCError] (-1) "ODBC error: (HY000) - internal savepoint error in libpq_bind_and_exec" is returned when executing SQL statement "UPDATE VPX_HOST SET MASTER_GEN = ? WHERE ID = ?"

Any idea fix the issue ? thank you!!

Regards,

Niki

[daphnissov]

Your best bet is going to be to open a case with GSS. And for the record, Windows vCenter is dead and even in 6.5 had severe disadvantages when compared to the vCSA. You should be actively trying to migrate away from it.

[NXxIT]

Hello All,

I've opened a support ticket and support said that should be caused by LDAP error, but my AD server do not have any change and there are no error log related the vCenter Server.

the vmon log as below:

2020-06-12T00:27:01.720+08:00| vthread-5| I125: Re-check service vsphere-client health since it is still initializing.^M

2020-06-12T00:27:01.727+08:00| vthread-5| I125: Re-check service vsphere-ui health since it is still initializing.^M

2020-06-12T00:27:03.436+08:00| vthread-5| W115: Service cm api-health command's stderr: ERROR:root:CM search failed. ProductId=com.vmware.cis, TypeId=cs.identity^M^M

2020-06-12T00:27:03.436+08:00| vthread-5| W115+ ERROR:root:Error connecting to CM: {^M^M

2020-06-12T00:27:03.436+08:00| vthread-5| W115+ "resolution": {^M^M

2020-06-12T00:27:03.436+08:00| vthread-5| W115+ "id": "install.default.failure.resolution", ^M^M

2020-06-12T00:27:03.436+08:00| vthread-5| W115+ "localized": "This is an unrecoverable error, please retry install. If you encounter this error again, please search for these symptoms in the VMware Knowledge Base for any known issues and possible resolutions. If none can be found, collect a support bundle and open a support request.", ^M^M

2020-06-12T00:27:03.436+08:00| vthread-5| W115+ "translatable": "This is an unrecoverable error, please retry install. If you encounter this error again, please search for these symptoms in the VMware Knowledge Base for any known issues and possible resolutions. If none can be found, collect a support bundle and open a support request."^M^M

2020-06-12T00:27:03.436+08:00| vthread-5| W115+ }, ^M^M

2020-06-12T00:27:03.436+08:00| vthread-5| W115+ "detail": [^M^M

2020-06-12T00:27:03.436+08:00| vthread-5| W115+ {^M^M

2020-06-12T00:27:03.436+08:00| vthread-5| W115+ "args": [^M^M

2020-06-12T00:27:03.436+08:00| vthread-5| W115+ "CM search failed. ProductId=com.vmware.cis, TypeId=cs.identity:[Errno 10061] No connection could be made because the target machine actively refused it"^M^M

2020-06-12T00:27:03.436+08:00| vthread-5| W115+ ], ^M^M

2020-06-12T00:27:03.436+08:00| vthread-5| W115+ "id": "install.ciscommon.internal.error", ^M^M

2020-06-12T00:27:03.436+08:00| vthread-5| W115+ "localized": "Encountered an internal error.\n\nCM search failed. ProductId=com.vmware.cis, TypeId=cs.identity:[Errno 10061] No connection could be made because the target machine actively refused it", ^M^M

2020-06-12T00:27:03.436+08:00| vthread-5| W115+ "translatable": "Encountered an internal error.\n\n%(0)s"^M^M

2020-06-12T00:27:03.436+08:00| vthread-5| W115+ }^M^M

2020-06-12T00:27:03.436+08:00| vthread-5| W115+ ], ^M^M

2020-06-12T00:27:03.436+08:00| vthread-5| W115+ "componentKey": null, ^M^M

2020-06-12T00:27:03.436+08:00| vthread-5| W115+ "problemId": null^M^M

2020-06-12T00:27:03.436+08:00| vthread-5| W115+ }^M^M

2020-06-12T00:27:03.436+08:00| vthread-5| W115: ^M

Does anyone have an idea? thank you!

Regards,

Niki

[Sukanyad]

check if there is a duplicate key on VPX_HOST table.