UiPath.Database.Activities SQL Select Fails with unexpected exit code

[ui_auto]

I have a very simple scenario

MySQL Table has 5 rows
id → primary key
name → non primary

Package installed: UiPath.Database.Activities v1.7.1
After establishing the connection, I use Execute Query.

SELECT id from TableName – works
SELECT * from TableName – fails
SELECT name from TableName – fails
SELECT name from TableName where id=‘XXX’ – fails

The error message is
System.Exception: Job stopped with an unexpected exit code: 0xC0000005

Looks like SELECT query works if I ONLY extract the primary key.
I need all or a selection of columns. In all the failure scenarios the job stops with an unexpected exit code.

INSERT/UPDATE has no issues

[oyvind.restad (Øyvind Restad)]

What happens when you try to execute this query directly from the mysql server? I suspect this has nothing to do with the RPA-process, but has everything to do with the server.

[supermanPunch (Arpan)]

@ui_auto

SELECT id from TableName – works
SELECT * from TableName – fails
SELECT name from TableName – fails
SELECT name from TableName where id=‘XXX’ – fails

Hi @ui_auto ,

Could you let us know what is the number of rows (approximate) present in the Database table ?

[ui_auto]

All good. The solution was to upgrade the MySQL driver (from 5.x to 8.x)