1

Topic: Throttle Out of range value for column 'cur_quota'

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 1.7.3
- Deployed with iRedMail Easy or the downloadable installer?downloadable installer
- Linux/BSD distribution name and version: Rocky 8
- Store mail accounts in which backend (LDAP/MySQL/PGSQL):  MYSQL
- Web server (Apache or Nginx): Nginx
- Manage mail accounts with iRedAdmin-Pro? Yes
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

Hi,

i have following errors. What do you suggest? Is it safe to bump row size?

iredapd [SQL] Failed in updating throttle tracking data: (pymysql.err.DataError) (1264, "Out of range value for column 'cur_quota' at row 1")
                                                       [SQL: UPDATE throttle_tracking
                                                                            SET period=86400,
                                                                                last_time=1753705140,
                                                                                init_time=1753682534,
                                                                                cur_msgs=cur_msgs + 1,
                                                                                cur_quota=cur_quota + 13831775
                                                                          WHERE id=328298]
                                                       (Background on this error at: http://sqlalche.me/e/9h9h)

Table specs:
MariaDB [iredapd]> describe throttle_tracking;
+------------------+-----------------------+------+-----+---------+----------------+
| Field            | Type                  | Null | Key | Default | Extra          |
+------------------+-----------------------+------+-----+---------+----------------+
| id               | bigint(20) unsigned   | NO   | PRI | NULL    | auto_increment |
| tid              | bigint(20) unsigned   | NO   | MUL | 0       |                |
| account          | varchar(255)          | NO   |     |         |                |
| period           | int(10) unsigned      | NO   |     | 0       |                |
| cur_msgs         | mediumint(8) unsigned | NO   |     | 0       |                |
| cur_quota        | int(10) unsigned      | NO   |     | 0       |                |
| init_time        | int(10) unsigned      | NO   |     | 0       |                |
| last_time        | int(10) unsigned      | NO   |     | 0       |                |
| last_notify_time | int(10) unsigned      | NO   |     | 0       |                |
+------------------+-----------------------+------+-----+---------+----------------+

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2

Re: Throttle Out of range value for column 'cur_quota'

- What's the value of `cur_quota` right now?
- Replace "int(10)" by "BIGINT".

3

Re: Throttle Out of range value for column 'cur_quota'

You mean the largest value?
Its 4293523256

I modify column to BIGINT(20) like id or tid.