In dewiki, total number of rows in geotags table is around 1.8M but its auto increment value is 2.4B and while it's unsinged it's the highest ratio of that value to maximum value in the whole infra (context: T291332). If it continues like this, it will fully and unfixably break in a couple of years.
Possible causes or solutions:
- It might be using upsert() a lot. Upsert is a terrible thing and every time it has to do update instead of insert, it wastes an auto-increment value.
- There is something inherently wrong in the code, maybe it's pushing gt_id? because dewiki doesn't have 2.4B edit altogether to cause that many upserts.
- Increasing the type to bigint and sweeping the problem under the rug.