Project

General

Profile

Actions
Copy link

Bug #21951

closed

User IDs are skipping every other number since Reclaim migration

Added by Boone Gorges 22 days ago. Updated 16 days ago.

Status:
Resolved
Priority name:
Normal
Assignee:
Raymond Hoh
Category name:
Registration
Target version:
Not tracked
Start date:
2025-01-30
Due date:
% Done:

0%

Estimated time:
Deployment actions:

Description

I just noticed that, since the site reopened for traffic on 2025-01-17, only odd IDs are used for new users:

MariaDB > select ID, user_registered from wp_users where user_registered >= '2025-01-14' order
by ID ASC limit 10;
+-------+---------------------+
| ID    | user_registered     |
+-------+---------------------+
| 54787 | 2025-01-14 02:42:21 |
| 54788 | 2025-01-14 05:54:04 |
| 54789 | 2025-01-14 09:58:16 |
| 54790 | 2025-01-14 21:22:23 |
| 54791 | 2025-01-15 01:19:00 |
| 54792 | 2025-01-15 10:48:11 |
| 54793 | 2025-01-15 14:33:12 |
| 54795 | 2025-01-17 20:50:02 |
| 54797 | 2025-01-18 04:29:34 |
| 54799 | 2025-01-18 06:05:47 |
+-------+---------------------+
10 rows in set (0.001 sec)

I don't think this really hurts anything, but I worry that it's happening because of some bug that could affect something else in the system. Ray, could you please take a bit of time to investigate?

Actions
Copy link
 #1

Updated by Raymond Hoh 21 days ago

It appears this isn't limited to just the wp_users table. The auto increment by 2 is occurring for all tables.

I believe this has something to do with how Reclaim set up DB replication, but we now have that turned off. Here's an article discussing the DB auto increment and how this might work with a multiple DB server replication set up: https://floyk.com/en/post/how-to-change-increment-step-on-auto-increment-fields-in-mysql-1

Actions
Copy link
 #2

Updated by Raymond Hoh 16 days ago

  • Status changed from New to Resolved
  • Target version changed from 2.5.2 to Not tracked

In an email support thread, Reclaim confirmed my suspicions that the DB increment by 2 is due to their DB replication set up.

Actions
Copy link

Also available in: Atom PDF