In our website, magento order increment id is not working as expected. We are getting difference of 3 between every two orders. Like for example,we have order 000005167 and next order we are getting as 000005170.
And when we checked from DB to know the next autoincrement value,it is showing as follows:
MariaDB [pkdxthkinb4aa_stg]> SELECT AUTO_INCREMENT FROM information_schema.TABLES WHERE TABLE_SCHEMA = "pkdxthkinb4aa_stg" AND TABLE_NAME = "sequence_order_1";
+----------------+
| AUTO_INCREMENT |
+----------------+
| 5173 |
+----------------+
While we should get 5171 as the last value in sequence_order_1 table is 5170.
Can you please advice me on how can I fix this
Thanks in advance