Actions
Bug #4450
openDB provides too small size for tool problem descriptions
Start date:
08/26/2013
Due date:
% Done:
0%
Estimated time:
Detected in build:
svn
Platform:
Published in build:
Description
Sometimes LDV tools produce rather big descriptions, that couldn't be stored to the DB, since we have:
mysql> describe stats; +-------------+-------------------------------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------------------------------------+------+-----+---------+----------------+ ... | description | text | YES | | NULL | | +-------------+-------------------------------------------+------+-----+---------+----------------+
For error traces we use much more size for storage:
mysql> describe traces; +-------------+---------------------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+---------------------------------+------+-----+---------+----------------+ ... | error_trace | mediumtext | YES | | NULL | | ... +-------------+---------------------------------+------+-----+---------+----------------+
From mysql documentation:
BLOB, TEXT L + 2 bytes, where L < 2^16 (64 Kilobytes) MEDIUMBLOB, MEDIUMTEXT L + 3 bytes, where L < 2^24 (16 Megabytes)
So, text should be replaced with mediumtext. DB version should be updated and all used DBs should be updated as well.
No data to display
Actions