SSIS validation error when retrieving data via ProxySQL.

[robert....@sycle.net]

Hello,

I’m experiencing strange issues with ProxySQL (version 2.7.2) when using SSIS to retrieve data from MySQL, which is proxied through ProxySQL.

The setup doesn’t use query rules, and users are linked to the default_hostgroup. The hostgroup contains only one MySQL server (version 8.0.40).

The errors are only visible in SSIS and are puzzling:
- Input string format error for column user.id (auto-increment int).
- OLE DB provider error: object has no columns or current user lacks permissions (grants are correct).

On ProxySQL, there are no errors. I suspect the meta information is incorrect.

For each SSIS pull, the task runs the same query twice: once with SQL_SELECT_LIMIT=0 and a second time with SQL_SELECT_LIMIT=DEFAULT. I enabled audit and event logs, but I don’t see the second query with SQL_SELECT_LIMIT=DEFAULT. There are no errors.

I installed .NET on Mac OSX and ran the queries, fetched meta, and rows without issues and everything is matching.

This is intermittent, so reproducing is challenging.

Setting ProxySQL user fast_forward property to 1 seems to be a workaround.

I’m curious if others have encountered this problem and know the cause or solution.

I don’t have all the profs, but bypassing ProxySQL seems to work as expected or with the fast_forward flag.

Thank you!