Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
5.5.32
-
Debian Wheezy using mariadb.org repository
Description
Help files don't completely install. Logs show this:
Jul 19 07:11:40 mail1 mysqld_safe[3617]: WARNING: HELP FILES ARE NOT COMPLETELY INSTALLED!
|
Jul 19 07:11:40 mail1 mysqld_safe[3617]: The "HELP" command might not work properly.
|
Manually trying to add the help tables results in this:
mysql -u root mysql < /usr/share/mysql/fill_help_tables.sql
|
ERROR 1406 (22001) at line 75: Data too long for column 'url' at row 1
|
MariaDB [mysql]> desc help_topic; |
--------------
|
desc help_topic |
--------------
|
|
|
+------------------+----------------------+------+-----+---------+-------+ |
| Field | Type | Null | Key | Default | Extra | |
+------------------+----------------------+------+-----+---------+-------+ |
| help_topic_id | int(10) unsigned | NO | PRI | NULL | | |
| name | char(64) | NO | UNI | NULL | | |
| help_category_id | smallint(5) unsigned | NO | | NULL | | |
| description | text | NO | | NULL | | |
| example | text | NO | | NULL | | |
| url | char(128) | NO | | NULL | | |
+------------------+----------------------+------+-----+---------+-------+ |
6 rows in set (0.01 sec) |
These urls exceed the 128 length:
==> grep 'insert into help_topic ' /usr/share/mysql/fill_help_tables.sql | perl -ne " m/.,'(.)'/; print \$1.\"\n\" if (length(\$1) > 128) "
http://dev.mysql.com/doc/refman/5.5/en/functions-for-testing-spatial-relations-between-geometric-objects.html#functions-that-test-spatial-relationships-between-geometries
http://dev.mysql.com/doc/refman/5.5/en/functions-for-testing-spatial-relations-between-geometric-objects.html#functions-that-test-spatial-relationships-between-geometries
http://dev.mysql.com/doc/refman/5.5/en/functions-for-testing-spatial-relations-between-geometric-objects.html#functions-that-test-spatial-relationships-between-geometries
http://dev.mysql.com/doc/refman/5.5/en/functions-for-testing-spatial-relations-between-geometric-objects.html#functions-that-test-spatial-relationships-between-geometries
http://dev.mysql.com/doc/refman/5.5/en/functions-for-testing-spatial-relations-between-geometric-objects.html#relations-on-geometry-mbr
http://dev.mysql.com/doc/refman/5.5/en/functions-for-testing-spatial-relations-between-geometric-objects.html#relations-on-geometry-mbr
http://dev.mysql.com/doc/refman/5.5/en/functions-for-testing-spatial-relations-between-geometric-objects.html#functions-that-test-spatial-relationships-between-geometries
http://dev.mysql.com/doc/refman/5.5/en/functions-for-testing-spatial-relations-between-geometric-objects.html#relations-on-geometry-mbr
http://dev.mysql.com/doc/refman/5.5/en/functions-for-testing-spatial-relations-between-geometric-objects.html#relations-on-geometry-mbr
http://dev.mysql.com/doc/refman/5.5/en/functions-for-testing-spatial-relations-between-geometric-objects.html#functions-that-test-spatial-relationships-between-geometries
http://dev.mysql.com/doc/refman/5.5/en/functions-for-testing-spatial-relations-between-geometric-objects.html#functions-that-test-spatial-relationships-between-geometries
http://dev.mysql.com/doc/refman/5.5/en/functions-for-testing-spatial-relations-between-geometric-objects.html#relations-on-geometry-mbr
http://dev.mysql.com/doc/refman/5.5/en/functions-for-testing-spatial-relations-between-geometric-objects.html#relations-on-geometry-mbr
http://dev.mysql.com/doc/refman/5.5/en/functions-for-testing-spatial-relations-between-geometric-objects.html#relations-on-geometry-mbr
http://dev.mysql.com/doc/refman/5.5/en/functions-for-testing-spatial-relations-between-geometric-objects.html#functions-that-test-spatial-relationships-between-geometries
See this discussion http://bugs.mysql.com/bug.php?id=61520 where a solution was implemented.
"The url columns in the mysql datatbase help tables were too short to
hold some of the URLs in the help content. These columns are now type
TEXT to accommodate longer URLs."
Attachments
Issue Links
Activity
Yes, I think it's a slightly different problem, although of course MySQL verification team might judge differently.
I mean, the bugs are obviously related, but what they have fixed is that the contents of the table didn't fit the existing structure. So, now newly created help tables have the field of the type TEXT, and the problem doesn't exist.
But it can still occur upon upgrade (as opposed to a clean installation), because mysql_upgrade doesn't fix the structure of the existing help table.
Coincidentally enough though, fill_help_tables.sql in MySQL 5.5.32 doesn't contain links longer than 128 symbols anymore, so the error on filling the table doesn't occur, even although the structure remains old.
Hi Elena,
Thanks for your explanation. I went over to MySQL to file a bug report and cannot login. Have tried asking for my password multiple times and even my username but I'm not getting anything back from Oracle. Even tried setting up a new account with Oracle and nothing there either. If you have the ability to file the report, I would appreciate it. Thanks,
Terry
upstream fix https://github.com/mysql/mysql-server/commit/924b64dec1e3fa58da2de286869153842914a123
MDEV-6779 - 10.0 branch was fixed with f7c50bf10f2738a633d8399b8fd97d7cfc665bef
Hi Elena,
Is this a different bug than the one described in 61520? Sorry for being dense, but I am happy to file one if 61520 doesn't cover it. I'm relatively new to the filing of bug reports.