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

          Transition Time In Source Status Execution Times
          Sergei Golubchik made transition -
          Open Closed
          		2080d 17h 14m 1

          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.