Message Position Error

Issue

The following error appears:

Error: The message position is <actual_position> when expected <expected_position>.

Environment

All database connectors

Resolution

To resolve this issue, do the following:

1. In Fivetran, pause your connection.

   i. Go to your connection page.

   ii. Set the Enabled toggle to OFF.

2. Contact our support team and request a pipeline queue reset.

3. Once the support team clears the queue, click Sync in the top right of your connection page to trigger a sync.

Cause

This issue occurs when two sync operations start on the same connection simultaneously. Fivetran processes data through a sequential pipeline, where each message has a unique position number. We track and enforce strict message ordering.

When multiple syncs run at the same time:

• One sync receives a message position that doesn't match the expected sequence, such as 114257 instead of 114256.
• Both syncs try to process the same set of messages, which can disrupt the connection's internal state.

To prevent duplication or inconsistency, we block concurrent syncs, resulting in the above error.