Ticket #294 (closed defect: fixed)
The total_*_size columns in maia_stats overflow too quickly
| Reported by: | rjl | Owned by: | rjl |
|---|---|---|---|
| Priority: | normal | Milestone: | 1.0.1 |
| Component: | SQL scripts | Version: | 1.0.0 RC5 |
| Severity: | normal | Keywords: | overflow total_oversized_size oversized stats |
| Cc: |
Description
The total_*_size columns in maia_stats are set to INTEGER for PostgreSQL (2 GB limit) and UNSIGNED INTEGER for MySQL (4 GB limit), but the value being stored in these columns is cumulative, and will eventually overflow the data type's allocation. Since it is not unreasonable for a site that processes 200+ 5 MB items to exceed a 2 GB limit, this will clearly result in an overflow error eventually. A larger data type is needed for these columns.
Change History
Note: See
TracTickets for help on using
tickets.

