Why am I getting unavailable partitions on scans in AP mode during migrations

Problem Description

During migrations, unavailable partitions were observed for a namespace running on AP mode doing long queries.

Explanation

Incoming partitions from migrations can cause a node to reject long queries, which is why AP mode can see unavailable partitions.

• Long queries (both PI and SI) cannot reserve a partition that has incoming migrations, unless they are specified to be ‘relaxed’ by the client in the QueryDuration policy and have Aerospike Server Version 7.1.0.0+.

• This is not the case for short queries on the versions below or later. This setting must be specified by the client in its policy.

• Versions:

  • 6.1.0.30

    • 7.0.0.5

  • 6.2.0.25

  • 6.3.0.18

  • 6.4.0.12

Solution

7.1+

• Run long queries as ‘relaxed’ (QueryDuration policy)

Pre 7.1

• Workaround could be to configure long queries as short queries

Applies To Earliest Version

Applies To Latest Version