Help Center/ Data Replication Service/ Troubleshooting/ Solutions to Failed Check Items/ Database Parameters/ Checking Whether the Source Database Collections Contain TTL Indexes
Updated on 2022-09-21 GMT+08:00
View PDF

Checking Whether the Source Database Collections Contain TTL Indexes

MongoDB Migration

Table 1 Checking whether the source database collections contain TTL indexes

Check Item

Whether the source database collections contain TTL indexes

Description

Due to inconsistency of time zones and clocks between source and destination databases, migrating TTL indexes will cause data inconsistency.

Failure Cause and Handling Suggestion

Item to be confirmed: Due to inconsistency of time zones and clocks between source and destination databases, migrating TTL indexes will cause data inconsistency.

Handling suggestion: If data consistency is required, delete TTL indexes. Alternatively, do not migrate the collections containing TTL indexes.

Run the following command to delete the index:

run the db.Collection name.dropIndex(Index name)
Parent topic: Database Parameters