# 2022-02-25-15:23:20-0800 Booking.com-Lightning-Import

Cause:

```
Feb 25, 2022 @ 16:01:06.846
tidb-lightning
 -
ERROR
[2022/02/25 21:01:06.846 +00:00] [ERROR] [lightning.go:219] ["tidb lightning encountered error"] [error="[tikv:9006]GC life time is shorter than transaction duration, transaction starts at 2022-02-25 20:44:20.986 +0000 UTC, GC safe point is 2022-02-25 20:44:21 +0000 UTC"] [errorVerbose="[tikv:9006]GC life time is shorter than transaction duration, transaction starts at 2022-02-25 20:44:20.986 +0000 UTC, GC safe point is 2022-02-25 20:44:21 +0000 UTC
```

Operation:
connecting to customer db

```
kubectl port-forward -n tidb1379661944595764068 svc/db-tidb-extra-service 4000 &
mysql -P 4000 -h 127.0.0.1
```

```
Run this in one MySQL client to update the downstream TiDB GC lifetime: update mysql.tidb set VARIABLE_VALUE="24h" where VARIABLE_NAME="tikv_gc_life_time";
Then, run this in one MySQL client to get the table checksum: admin checksum table accommodations_items, then we can get something like this:+---------+------------+---------------------+-----------+-------------+
| Db_name | Table_name | Checksum_crc64_xor  | Total_kvs | Total_bytes |
+---------+------------+---------------------+-----------+-------------+
| test    | t          | 8520875019404689597 |   7296873 |   357601387 |
+---------+------------+---------------------+-----------+-------------+
```