411435 - Database error caused by having a rowsize > 8000 using INNODB on mysql 5.0

Status: NEW

(Bugzilla :: Database, defect)

Description

[Alex Eiser]

User-Agent:       Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_5_1; en-us) AppleWebKit/525.1+ (KHTML, like Gecko) Version/3.0.4 Safari/523.10.6
Build Identifier: bugzilla-3.1.2

If you generate a record which has more then 8000 bytes in rowdata, then you will be treated with a blank result page and the following error on the commandline:

[Tue Jan 08 16:32:39 2008] [error] [client ::1] DBD::mysql::db do failed: Got error 139 from storage engine [for Statement "UPDATE bugs SET cf_shorttext2 = ?, cf_shorttext3 = ?, cf_shorttext4 = ? WHERE bug_id = ?"] at Bugzilla/Object.pm line 262, referer: http://localhost/bugzilla/process_bug.cgi
[Tue Jan 08 16:32:39 2008] [error] [client ::1] \tBugzilla::Object::update('Bugzilla::Bug=HASH(0xb71c08)') called at Bugzilla/Bug.pm line 494, referer: http://localhost/bugzilla/process_bug.cgi
[Tue Jan 08 16:32:39 2008] [error] [client ::1] \tBugzilla::Bug::update('Bugzilla::Bug=HASH(0xb71c08)', '2008-01-08 16:32:39') called at /Sites/bugzilla-3.1.2/process_bug.cgi line 955, referer: http://localhost/bugzilla/process_bug.cgi

To get this amount of row data you need to create the following set of custom fields.
11 Long Text fields, each with about 1000 characters
 - With INNODB LongText fields store their first 500 bytes into the same rowdata as other fields.

The only work around is to switch the database to myism, or reduce the number of columns in the bugs table.



Reproducible: Always

Steps to Reproduce:
1. Create an instance of Bugzilla and add 11 Long Text Fields
2. Create a record with 1000 characters on each of the text fields.
3. try and save
Actual Results:  
Blank screen and the error listed above

Expected Results:  
A error result page saying that the database row size has been exceeded. Talk to you system maintainer for options.