**Comment from Launchpad by: Carlos Salguero on: 17-11-2016 18:00:01

This is the default behavior.
From the docs:

--[no]safe-auto-increment
default: yes

Do not archive row with max AUTO_INCREMENT.

Adds an extra WHERE clause to prevent pt-archiver from removing the newest row when ascending a single-column AUTO_INCREMENT key. This guards against re-using AUTO_INCREMENT values if the server restarts, and is enabled by default.

The extra WHERE clause contains the maximum value of the auto-increment column as of the beginning of the archive or purge job. If new rows are inserted while pt-archiver is running, it will not see them.

**Comment from Launchpad by: Jesse McLaughlin on: 17-11-2016 14:14:41

Although if the test case listed above was added to the current code, it would also break. So either way you have broken tests.

**Comment from Launchpad by: Carlos Salguero on: 17-11-2016 13:43:20

That 'fix' breaks all the tests

**Comment from Launchpad by: Jesse McLaughlin on: 06-10-2016 10:53:29

FYI,

With reference to earlier in this thread, the following patch fixes the test case above:

$ diff pt-archiver pt-archiver-patched
6247c6247
< $first_sql .= " AND ($col < " . $q->quote_val($val) . ")";
—
> $first_sql .= " AND ($col <= " . $q->quote_val($val) . ")";

**Comment from Launchpad by: Jesse McLaughlin on: 04-10-2016 14:30:13

Here's a test case that reproduces this issue:

1. STEP 1. Create some test data (create table and inserts below):

$ mysql tmp

Server version: 5.5.37-MariaDB-log MariaDB Server
MariaDB [tmp]>

CREATE TABLE `tiger_pony` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`ref` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

insert into tiger_pony (ref) values ('Timber');
insert into tiger_pony (ref) values ('Shiny');

select * from tiger_pony;

--------+

--------+

--------+

1. STEP 2. Run the Percona archiver utility on the table:

$ /opt/percona-toolkit-2.2.17/bin/pt-archiver -u <user> -p <password> --source h=<host>,D=tmp,t=tiger_pony --where 'true' --no-delete --limit 1000 --commit-each --file ./tmp.txt

$ cat tmp.txt
1 Timber

1. So the original select gives two rows, and the Percona archiver utility only outputs one.