Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-4808

Error installing help tables

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Fix
    • 5.5.32
    • N/A
    • OTHER
    • 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

        Activity

          Ascending order - Click to sort in descending order
          terryr Terry Roy created issue -
          elenst Elena Stepanova made changes -
          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."
          elenst Elena Stepanova made changes -
          Assignee Elena Stepanova [ elenst ]
          Labels upstream
          elenst Elena Stepanova made changes -
          elenst Elena Stepanova made changes -
          elenst Elena Stepanova made changes -
          Fix Version/s 5.5.33 [ 13300 ]
          Assignee Elena Stepanova [ elenst ]
          serg Sergei Golubchik made changes -
          Fix Version/s 5.5.34 [ 13500 ]
          Fix Version/s 5.5.33 [ 13300 ]
          serg Sergei Golubchik made changes -
          Fix Version/s 5.5.34 [ 13700 ]
          Fix Version/s 5.5.33a [ 13500 ]
          serg Sergei Golubchik made changes -
          Fix Version/s 5.5.35 [ 14000 ]
          Fix Version/s 5.5.34 [ 13700 ]
          serg Sergei Golubchik made changes -
          Fix Version/s 5.5.36 [ 14600 ]
          Fix Version/s 5.5.35 [ 14000 ]
          serg Sergei Golubchik made changes -
          Fix Version/s 5.5.37 [ 15000 ]
          Fix Version/s 5.5.36 [ 14600 ]
          serg Sergei Golubchik made changes -
          Fix Version/s 5.5.38 [ 15400 ]
          Fix Version/s 5.5.37 [ 15000 ]
          serg Sergei Golubchik made changes -
          Fix Version/s 5.5.39 [ 15800 ]
          Fix Version/s 5.5.38 [ 15400 ]
          serg Sergei Golubchik made changes -
          Workflow defaullt [ 28204 ] MariaDB v2 [ 44225 ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Workflow MariaDB v2 [ 44225 ] MariaDB v3 [ 64273 ]
          danblack Daniel Black made changes -
          Labels upstream upstream-fixed
          serg Sergei Golubchik made changes -
          Assignee Sergei Golubchik [ serg ]
          serg Sergei Golubchik made changes -
          Priority Minor [ 4 ] Major [ 3 ]
          serg Sergei Golubchik made changes -
          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 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 64273 ] MariaDB v4 [ 146879 ]

          People

            serg Sergei Golubchik
            terryr Terry Roy
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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