Numeric value out of range: Out of range value for column 'expires'

Created on 1 July 2025, 7 days ago

I think because being a repeated offender, auto unban grows the expires value indefinitely maybe and we're hitting 2038 issues?

Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'expires' at row 1: UPDATE "ban_ip" SET "ip"=:db_update_placeholder_0, "expires"=:db_update_placeholder_1, "attempts"=:db_update_placeholder_2
WHERE "ip" = :db_condition_placeholder_0; Array
(
    [:db_update_placeholder_0] => 104.247.193.58
    [:db_update_placeholder_1] => 2223177560
    [:db_update_placeholder_2] => 18
    [:db_condition_placeholder_0] => 104.247.193.58

https://app.crowdsec.net/cti/104.247.193.58

2223177560 is Wed Jun 13 2040 05:19:20 GMT+0000

As this is basically a core issue, we might want to wrap the exception in a try/catch?

📌 Task
Status

Active

Version

1.0

Component

Code

Created by

🇪🇸Spain pcambra Asturies

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

Comments & Activities

Production build 0.71.5 2024