Queue item_id field type to bigint

Created on 3 February 2023, almost 2 years ago

Problem/Motivation

Hi,

I have a site which is importin a lot of content with migrate modules. It worked around 3 years untill
the queue autoincrement became full.
SQLSTATE[22003]: Numeric value out of range: 167 Out of range value for column 'item_id'
This caused wsod on almost all admin pages, like status report. But the site was working.

I had to fix it with this sql statement:
ALTER TABLE queue AUTO_INCREMENT = 1

Steps to reproduce

Proposed resolution

What about changing the field type to something which allows more than the int(10) does?
Bigint?

Remaining tasks

User interface changes

API changes

Data model changes

Release notes snippet

Feature request
Status

Active

Version

10.1

Component
Database 

Last updated 2 days ago

  • Maintained by
  • 🇳🇱Netherlands @daffie
Created by

🇫🇮Finland anaconda777

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Production build 0.71.5 2024