Sync fails with MySQL source

[bobbyiliev]

I've tried using the MySQL source a few times with two different MySQL database servers:

Server version: 8.0.32-0ubuntu0.20.04.2 (Ubuntu)

However, each time I tried to run a sync I got the following error:

unable to take snapshot for snapshotId: some_id_here, Error 1292: 
Incorrect datetime value: '2023-08-30T08:26:38Z' for column 'rudder_snapshot_run_at' at row 1

This is the table that is being automatically generated:

mysql> describe snapshot_fee7547160652ed1fa1458b7b1edb072_1693382703;
+------------------------+------------------+------+-----+-------------------+-----------------------------------------------+
| Field                  | Type             | Null | Key | Default           | Extra                                         |
+------------------------+------------------+------+-----+-------------------+-----------------------------------------------+
| id                     | bigint unsigned  | NO   |     | 0                 |                                               |
| order_status           | tinyint unsigned | YES  |     | 1                 |                                               |
| price                  | decimal(12,2)    | YES  |     | NULL              |                                               |
| created_at             | timestamp        | YES  |     | CURRENT_TIMESTAMP | DEFAULT_GENERATED                             |
| updated_at             | datetime         | YES  |     | CURRENT_TIMESTAMP | DEFAULT_GENERATED on update CURRENT_TIMESTAMP |
| rudder_invalid         | int              | NO   |     | 0                 |                                               |
| rudder_snapshot_run_at | datetime         | YES  |     | NULL              |                                               |
| rudder_snapshot_id     | varchar(256)     | YES  |     | NULL              |                                               |
+------------------------+------------------+------+-----+-------------------+-----------------------------------------------+