Open Bug 299350 Opened 19 years ago Updated 17 years ago

sanitycheck should warn if the attachments table is near full

Categories

(Bugzilla :: Administration, task)

2.19.1
x86
Windows XP
task
Not set
normal

Tracking

()

People

(Reporter: timeless, Unassigned)

Details

bmo's attachment table got full, this is probably a bad thing. but worse is that
we only found out when it happened, assuming people run sanity checks
occasionally, it'd be good if those warned about such a problem in advance of it
happening.

the following is my poor summary of justdave's description:
When the table 'attachments' is full (or near full) admins should see section
2.2.2.3 in the Bugzilla tip docs.

there's differing definitions of full, it'd have to query the DDL structure to
find out the capacity...

that max_rows and avg_row_length get multiplied by each other to get the
capacity and assume 4GB if those aren't present that max_data_length field seems
to imply a TB

that might be usable though...  all the dynamic tables seem to have 4 GB in that
column
I don't see a 2.2.2.3 did you mean:

2.2.2.1.3. Permit attachments table to grow beyond 4GB

http://www.bugzilla.org/docs/tip/html/configuration.html#AEN448
You need to log in before you can comment on or make changes to this bug.