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.