Project

General

Profile

Actions

Bug #4450

open

DB provides too small size for tool problem descriptions

Added by Evgeny Novikov over 10 years ago.

Status:
New
Priority:
High
Assignee:
Category:
-
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

Also available in: Atom PDF