---
slug: "mysql-autoincrement-failed-to-read"
title: "対応方法 When MySQL AutoIncrement Runs Out"
description: "MySQLdb._exceptions.OperationalError: (1467, 'Failed to read auto-increment value from storage engine')\nIn Django, when you specify an implicit id, the above error occurs if the auto increment value reaches its upper limit."
url: "https://www.ytyng.com/en/blog/mysql-autoincrement-failed-to-read"
publish_date: "2020-05-18T02:16:05Z"
created: "2020-05-18T02:16:05Z"
updated: "2026-02-27T08:48:50.496Z"
categories: ["Django"]
keywords: ""
featured_image_url: "https://media.ytyng.com/resize/20230812/1b0719c1c4c840319bdadf46fadcc559.png.webp?width=768"
has_video: false
has_music: false
video_urls: []
music_urls: []
lang: "en"
---
# 対応方法 When MySQL AutoIncrement Runs Out
MySQLdb._exceptions.OperationalError: (1467, 'Failed to read auto-increment value from storage engine')
In Django, when you specify an implicit id, the above error occurs if the auto increment value reaches its upper limit.
Checking the database:
SELECT AUTO_INCREMENT
FROM information_schema.tables
WHERE TABLE_SCHEMA = 'my_schema'
AND TABLE_NAME = 'my_table';
| AUTO_INCREMENT |
| 2147483647 |
SHOW CREATE TABLE my_table;
CREATE TABLE `my_table` (
`id` int(11) NOT NULL AUTO_INCREMENT,
...
Modifying the model:
id = models.BigAutoField(primary_key=True)
Adding the above line
./manage.py makemigrations
./manage.py migrate
SHOW CREATE TABLE my_table;
CREATE TABLE `my_table` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
...