MySQL SI failed to bind/unbind after upgrading to MySQL for TAS tile v2.10.6+

Products

• VMware Tanzu SQL

Issue/Introduction

Customer tried to unbind mysql SI from TAS, getting below error:

unbind could not be completed: Service broker failed to delete service binding for instance bdx-mysql: HTTPClient::KeepAliveDisconnected: Connection reset by peer @ io_fillbuf - fd:9

Checking the broker.stderr.log, there is TLS handshake error -

2023/06/29 02:34:11 http: TLS handshake error from 10.***.***.**:34074: tls: first record does not look like a TLS handshake

The IP address (10.***.***.**) in the above error message is Cloud Controller VM.

Environment

Product Version: 2.10

Resolution

According to the MySQL for TAS v2.10.6 release note, The on-demand broker now communicates with the Cloud Foundry Cloud Controller over TLS.
The issue was that on-demand broker expects now TLS communication over https and Cloud Controller was unaware of it and still using http. To fix this issue, customer needs to run "Register On-demand MySQL Broker" errand on MySQL for TAS tile.