Details
Minor
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."
Gliffy Diagrams
Attachments
Issue Links
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
I hadn't planned on it since someone else had already filed a bug report and the bug was marked as closed. From the mysql bug report http://bugs.mysql.com/bug.php?id=61520:
Noted in 5.1.70, 5.5.32, 5.6.12, 5.7.2 changelogs.
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.
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.
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
Hi Terry,
Did you run mysql_upgrade after installing 5.5.32?
Here is what I see for help_topic newly created by 5.5.32:
-----------------
----------------------------------------+-----------------
----------------------------------------+-----------------
----------------------------------------+url is of type text already, so no errors on filling the table for me.