Re: Connect to mysqlx failed

[Rui Quelhas]

Already addressed via Slack ;) Here's the gist though.

This is a known forward compatibility issue, which is only reproducible with client versions lower than or equal to 8.0.17 and server versions higher than or equal to 8.0.18. The X Plugin introduces an object-based capability for the first time on MySQL 8.0.18 which can't be parsed by the client because there is a hidden bug in the protobuf decoding routine.

The practical solution is to upgrade the client to a version higher than or equal to 8.0.18. If not possible, the client source can be locally patched simply with the following:

/var/nodejs/myapp/node_modules/@mysql/xdevapi/lib/Protocol/Protobuf/Adapters/Datatypes.js:387
- return this.extractObject(proto.getObject());
+ return this.extractObject(proto.getObj());

Thanks