Vote #63059
完了Wiki/News/Documents truncate contents to 64K in MYSQL
0%
説明
I've found wiki posts over 64K get silently truncated. The problem is in the SQL specification of the following databases/fields is TEXT (64K) instead of MEDIUMTEXT (16MB) or LONGTEXT (>16MB):
| table changesets | comments |
| table comments | comments |
| table documents | description |
| table issues | description |
| table journals | notes |
| table messages | content |
| table news | description |
| table projects | description |
| table wiki_contents | text |
Perhaps some of these don't need to change but I think most should be MEDIUMTEXT or LARGETEXT (documents for example)?
I have worked around this at my site with using the mysql command:
mysql> ALTER TABLE wiki_contents CHANGE text MEDIUMTEXT ;
but I'm afraid the next db migrate will mess it up, and others will hit it.
I suggest this is urgent priority, since data is lost.
journals
There is also a BLOB in wiki_content_versions that should be MEDIUMBLOB or LARGEBLOB.
--------------------------------------------------------------------------------
Patch provided for it there: #1404
Hoping it helps.
--------------------------------------------------------------------------------
As described in #3777 this bug leads to silent loss of data for project users, is there any estimate on what release(s) the patch in #1404 or a similar solution will be included in?
--------------------------------------------------------------------------------
Ping - could the patch or this get integrated? This seems a serious defect. Thanks.
--------------------------------------------------------------------------------
Rewrite from the patch #1404 : set wiki content and versioned content up to 16MB.
I can eventually add a wiki content truncation detection system, but it'd cost a reload of the modified instance. Is this patch ok or should I add the check?
--------------------------------------------------------------------------------
IMO 16MB is fine. It becomes a HTML page not an attachment, so 16MB is enough.
--------------------------------------------------------------------------------
Will this go into 0.9?
I needed to split up some documents with big tables into two or more parts which isnt really nice.
--------------------------------------------------------------------------------
Fixed in r3254.
A mysql specific migration was added to raise the limit.
--------------------------------------------------------------------------------
Merged in 0.9-stable in r3255.
--------------------------------------------------------------------------------
related_issues
relates,Closed,1404,Raise wiki content page size
duplicates,Closed,3669,Wiki page size too small
duplicates,Closed,3777,Long wiki pages drop text when edited