azexcy commented on PR #21689:
URL: https://github.com/apache/shardingsphere/pull/21689#issuecomment-1287577525
now increment task finished
```
dataSourceName: ds_1
incremental:
delay:
lastEventTimestamps: 1666401396000
latestActiveTimeMillis: 1666401742854
position: binlog.000003#3432139
inventory:
```
then restart proxy, If there is no incremental data coming in, the
incremental.delay will be overwritten
```
dataSourceName: ds_1
incremental:
delay:
lastEventTimestamps: 0
latestActiveTimeMillis: 0
position: binlog.000003#3432139
inventory:
```
just like this.
```
mysql> show migration status 'j01019761922f8fab5ce3c61496c22f733586';
+------+-------------+--------------------------+--------+-------------------------+-------------------------------+--------------------------+---------------+
| item | data_source | status | active |
processed_records_count | inventory_finished_percentage |
incremental_idle_seconds | error_message |
+------+-------------+--------------------------+--------+-------------------------+-------------------------------+--------------------------+---------------+
| 0 | source_ds | EXECUTE_INCREMENTAL_TASK | true | 9
| 100 | 27 |
|
+------+-------------+--------------------------+--------+-------------------------+-------------------------------+--------------------------+---------------+
1 row in set (0.20 sec)
mysql> show migration status 'j01019761922f8fab5ce3c61496c22f733586';
ERROR 2013 (HY000): Lost connection to MySQL server during query
No connection. Trying to reconnect...
Connection id: 1
Current database: sharding_db
+------+-------------+--------------------------+--------+-------------------------+-------------------------------+--------------------------+---------------+
| item | data_source | status | active |
processed_records_count | inventory_finished_percentage |
incremental_idle_seconds | error_message |
+------+-------------+--------------------------+--------+-------------------------+-------------------------------+--------------------------+---------------+
| 0 | source_ds | EXECUTE_INCREMENTAL_TASK | true | 9
| 100 | 0 |
|
+------+-------------+--------------------------+--------+-------------------------+-------------------------------+--------------------------+---------------+
1 row in set (2.66 sec)
mysql>
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
