[MDEV-4808] Error installing help tables - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Won't Fix
Affects Version/s: 5.5.32
Fix Version/s: N/A
Component/s: OTHER
Labels:
- upstream-fixed
Environment:
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)

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

links to

Bug #61520 - help-tableformat doesn't match help-files

Bug #69853

Activity

Ascending order - Click to sort in descending order

Terry Roy created issue - 2013-07-22 22:11

Elena Stepanova made changes - 2013-07-23 13:55

Field	Original Value	New Value
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."	Help files don't completely install. Logs show this: {noformat} 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. {noformat} Manually trying to add the help tables results in this: {noformat} 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 {noformat} {code:sql} 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) {code} 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."

Elena Stepanova added a comment - 2013-07-25 19:55 - edited

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:

+------------------+----------------------+------+-----+---------+-------+

| 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              | text                 | NO   |     | NULL    |       |

+------------------+----------------------+------+-----+---------+-------+

url is of type text already, so no errors on filling the table for me.

Elena Stepanova made changes - 2013-07-25 20:03

Assignee		Elena Stepanova [ elenst ]
Labels		upstream

Elena Stepanova made changes - 2013-07-25 20:03

Remote Link

This issue links to "Bug #61520 - help-tableformat doesn't match help-files (Web Link)" [ 11901 ]

Terry Roy added a comment - 2013-07-26 17:04 - edited

I ran mysql_update. Received this message.

This installation of MySQL is already upgraded to 5.5.32-MariaDB, use --force if you still need to run mysql_upgrade

So I ran mysql_update --force. Script ran but url stays as type char.

MariaDB [mysql]> 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    |       |

+------------------+----------------------+------+-----+---------+-------+

Elena Stepanova added a comment - 2013-07-26 17:22 - edited

Which version did you upgrade from?

Upd: nevermind, I see that mysql_upgrade doesn't change the structure of the table. I suppose it's a side-effect of mysql_upgrade not updating the contents of help tables – probably it doesn't look at them at all and thus doesn't check the structure either...

MySQL behaves the same way (upgrade from 5.5.30 to 5.5.32 doesn't change the structure of the table)

Elena Stepanova added a comment - 2013-07-26 17:22 - edited Which version did you upgrade from? Upd: nevermind, I see that mysql_upgrade doesn't change the structure of the table. I suppose it's a side-effect of mysql_upgrade not updating the contents of help tables – probably it doesn't look at them at all and thus doesn't check the structure either... MySQL behaves the same way (upgrade from 5.5.30 to 5.5.32 doesn't change the structure of the table)

Elena Stepanova added a comment - 2013-07-26 17:33

Terry,

Are you planning to file an upstream bug about it (about upgrade not changing the structure of the table), or maybe you have already?

Elena Stepanova added a comment - 2013-07-26 17:33 Terry, Are you planning to file an upstream bug about it (about upgrade not changing the structure of the table), or maybe you have already?

Terry Roy added a comment - 2013-07-26 17:35

On one server, I installed 5.5.30, upgraded when 5.5.31 came out then to 5.5.32. On another server, I have been running mariadb since 5.3.x and gone through the series of upgrades to 5.5.32. Have the problem on both servers.

Terry Roy added a comment - 2013-07-26 17:35 On one server, I installed 5.5.30, upgraded when 5.5.31 came out then to 5.5.32. On another server, I have been running mariadb since 5.3.x and gone through the series of upgrades to 5.5.32. Have the problem on both servers.

Elena Stepanova added a comment - 2013-07-26 17:47

Hi Terry,

Right, I get it.
We usually file such universal problems in the upstream (MySQL, in this case) bug base and wait to see if MySQL wants to fix them; if not, we fix ourselves. Are you willing to file a bug at bugs.mysql.com? Being an author will let you watch it easier. If not, I'll file one on your behalf..

Thanks.

Elena Stepanova added a comment - 2013-07-26 17:47 Hi Terry, Right, I get it. We usually file such universal problems in the upstream (MySQL, in this case) bug base and wait to see if MySQL wants to fix them; if not, we fix ourselves. Are you willing to file a bug at bugs.mysql.com? Being an author will let you watch it easier. If not, I'll file one on your behalf.. Thanks.

Terry Roy added a comment - 2013-07-26 17:48

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.

Terry Roy added a comment - 2013-07-26 17:48 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.

Terry Roy added a comment - 2013-07-26 17:56

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.

Terry Roy added a comment - 2013-07-26 17:56 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.

Elena Stepanova added a comment - 2013-07-26 18:12

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.

Elena Stepanova added a comment - 2013-07-26 18:12 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.

Terry Roy added a comment - 2013-07-27 02:39

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

Terry Roy added a comment - 2013-07-27 02:39 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

Elena Stepanova added a comment - 2013-07-27 02:50

Filed as http://bugs.mysql.com/bug.php?id=69853

Elena Stepanova added a comment - 2013-07-27 02:50 Filed as http://bugs.mysql.com/bug.php?id=69853

Elena Stepanova made changes - 2013-07-27 02:50

Remote Link

This issue links to "Bug #69853 (Web Link)" [ 11902 ]

Elena Stepanova made changes - 2013-08-18 14:57

Fix Version/s		5.5.33 [ 13300 ]
Assignee	Elena Stepanova [ elenst ]

Sergei Golubchik made changes - 2013-09-16 19:04

Fix Version/s		5.5.34 [ 13500 ]
Fix Version/s	5.5.33 [ 13300 ]

Sergei Golubchik made changes - 2013-09-20 18:22

Fix Version/s		5.5.34 [ 13700 ]
Fix Version/s	5.5.33a [ 13500 ]

Sergei Golubchik made changes - 2013-11-21 21:02

Fix Version/s		5.5.35 [ 14000 ]
Fix Version/s	5.5.34 [ 13700 ]

Sergei Golubchik made changes - 2014-01-29 10:10

Fix Version/s		5.5.36 [ 14600 ]
Fix Version/s	5.5.35 [ 14000 ]

Sergei Golubchik made changes - 2014-02-24 21:51

Fix Version/s		5.5.37 [ 15000 ]
Fix Version/s	5.5.36 [ 14600 ]

Sergei Golubchik made changes - 2014-04-15 23:53

Fix Version/s		5.5.38 [ 15400 ]
Fix Version/s	5.5.37 [ 15000 ]

Sergei Golubchik made changes - 2014-06-06 10:26

Fix Version/s		5.5.39 [ 15800 ]
Fix Version/s	5.5.38 [ 15400 ]

Sergei Golubchik made changes - 2014-06-13 15:06

Workflow

defaullt [ 28204 ]

MariaDB v2 [ 44225 ]

Rasmus Johansson (Inactive) made changes - 2015-05-18 17:51

Workflow

MariaDB v2 [ 44225 ]

MariaDB v3 [ 64273 ]

Daniel Black added a comment - 2017-12-30 06:44

upstream fix https://github.com/mysql/mysql-server/commit/924b64dec1e3fa58da2de286869153842914a123

~~MDEV-6779~~ - 10.0 branch was fixed with f7c50bf10f2738a633d8399b8fd97d7cfc665bef

Daniel Black added a comment - 2017-12-30 06:44 upstream fix https://github.com/mysql/mysql-server/commit/924b64dec1e3fa58da2de286869153842914a123 MDEV-6779 - 10.0 branch was fixed with f7c50bf10f2738a633d8399b8fd97d7cfc665bef

Daniel Black made changes - 2017-12-30 06:44

Labels

upstream

upstream-fixed

Sergei Golubchik made changes - 2017-12-30 09:17

Assignee

Sergei Golubchik [ serg ]

Sergei Golubchik made changes - 2017-12-30 09:17

Priority

Minor [ 4 ]

Major [ 3 ]

Sergei Golubchik made changes - 2019-04-03 15:26

Component/s		OTHER [ 10125 ]
Fix Version/s		N/A [ 14700 ]
Fix Version/s	5.5 [ 15800 ]
Resolution		Won't Fix [ 2 ]
Status	Open [ 1 ]	Closed [ 6 ]

Sergei Golubchik made changes - 2021-12-06 21:39

Workflow

MariaDB v3 [ 64273 ]

MariaDB v4 [ 146879 ]

People

Assignee:: Sergei Golubchik

Reporter:: Terry Roy

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2013-07-22 22:11

Updated:: 2019-04-03 15:26

Resolved:: 2019-04-03 15:26

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server

Details

Description

Attachments

Issue Links

Activity

People

Dates

Git Integration