Percona Server moved to https://jira.percona.com/projects/PS

Percona server misses CLI help texts (fill_help_tables.sql empty)

Bug #1041981 reported by Roel Van de Paar on 2012-08-27

This bug affects 2 people

	Status	Importance	Assigned to	Milestone
Percona Server moved to https://jira.percona.com/projects/PS	Fix Released	Low	Laurynas Biveinis	Percona Server moved to https://jira.percona.com/projects/PS 5.6.11-60.3
5.1	Fix Released	Low	Alexey Bychko	Percona Server moved to https://jira.percona.com/projects/PS 5.1.68-14.6
5.5	Fix Released	Low	Alexey Bychko	Percona Server moved to https://jira.percona.com/projects/PS 5.5.30-30.2
5.6	Fix Released	Low	Laurynas Biveinis	Percona Server moved to https://jira.percona.com/projects/PS 5.6.11-60.3

Bug Description

mysql> HELP SELECT;
Nothing found

Reason: fill_help_tables.sql is as good as empty.

Bugfix: include proper fill_help_tables.sql Available here:

http://dev.mysql.com/doc/index-other.html
http://downloads.mysql.com/docs/fill_help_tables-5.1.sql.zip
http://downloads.mysql.com/docs/fill_help_tables-5.5.sql.zip
http://downloads.mysql.com/docs/fill_help_tables-5.6.sql.zip

See original description

Tags:

Related branches

lp:~abychko/percona-server/bug1041981-5.1

Merged into lp:percona-server/5.1 at revision 540

Alexey Kopytov (community): Approve on 2013-03-21

lp:~abychko/percona-server/bug1041981-5.5

Merged into lp:percona-server/5.5 at revision 473

Alexey Kopytov (community): Approve on 2013-03-21

lp:~laurynas-biveinis/percona-server/5.6-merge-3

Merged into lp:percona-server/5.6 at revision 352

Alexey Kopytov (community): Approve on 2013-05-21

Percona core: Pending requested 2013-05-13

Diff: 19408 lines (+2919/-15492)

66 files modified

Percona-Server/client/mysqldump.c (+35/-4)
Percona-Server/mysql-test/r/create_delayed.result (+3/-0)
Percona-Server/mysql-test/r/percona_bug1127008.result (+28/-0)
Percona-Server/mysql-test/r/percona_innodb_version.result (+1/-1)
Percona-Server/mysql-test/r/percona_mysqldump_innodb_optimize_keys.result (+0/-443)
Percona-Server/mysql-test/suite/innodb/r/percona_bug_1133926.result (+4/-0)
Percona-Server/mysql-test/suite/innodb/t/percona_bug_999147-master.opt (+0/-1)
Percona-Server/mysql-test/suite/sys_vars/r/expand_fast_index_creation_basic.result (+6/-0)
Percona-Server/mysql-test/suite/sys_vars/r/innodb_corrupt_table_action_basic.result (+49/-0)
Percona-Server/mysql-test/t/create_delayed.test (+34/-0)
Percona-Server/mysql-test/t/percona_bug1127008.test (+28/-0)
Percona-Server/mysql-test/t/percona_innodb_version.test (+1/-1)
Percona-Server/mysql-test/t/percona_mysqldump_innodb_optimize_keys.test (+0/-227)
Percona-Server/scripts/fill_help_tables.sql (+2177/-9)
Percona-Server/sql/mdl.cc (+5/-1)
Percona-Server/sql/sql_base.cc (+92/-16)
Percona-Server/sql/sql_base.h (+2/-1)
Percona-Server/sql/sql_db.cc (+1/-1)
Percona-Server/sql/sql_insert.cc (+4/-0)
Percona-Server/sql/sql_parse.cc (+8/-1)
Percona-Server/sql/sql_table.cc (+5/-1)
Percona-Server/storage/innobase/btr/btr0btr.cc (+19/-23)
Percona-Server/storage/innobase/btr/btr0cur.cc (+52/-61)
Percona-Server/storage/innobase/btr/btr0pcur.cc (+6/-7)
Percona-Server/storage/innobase/btr/btr0sea.cc (+1/-4)
Percona-Server/storage/innobase/buf/buf0buf.cc (+31/-16)
Percona-Server/storage/innobase/buf/buf0rea.cc (+2/-4)
Percona-Server/storage/innobase/fil/fil0fil.cc (+26/-32)
Percona-Server/storage/innobase/fsp/fsp0fsp.cc (+15/-33)
Percona-Server/storage/innobase/handler/ha_innodb.cc (+4/-2)
Percona-Server/storage/innobase/include/btr0btr.ic (+1/-1)
Percona-Server/storage/innobase/include/buf0buf.ic (+1/-7)
Percona-Server/storage/innobase/include/fut0fut.ic (+1/-4)
Percona-Server/storage/innobase/include/srv0srv.h (+16/-0)
Percona-Server/storage/innobase/row/row0ins.cc (+5/-4)
Percona-Server/storage/innobase/row/row0merge.cc (+3/-2)
Percona-Server/storage/innobase/row/row0sel.cc (+6/-5)
build/build-binary.sh (+38/-1)
build/debian/additions/innotop/InnoDBParser.pm (+0/-1089)
build/debian/additions/innotop/changelog.innotop (+0/-318)
build/debian/additions/innotop/innotop (+0/-9485)
build/debian/additions/innotop/innotop.1 (+0/-2086)
build/debian/percona-server-client-5.6.dirs (+0/-1)
build/debian/percona-server-client-5.6.docs (+0/-1)
build/debian/percona-server-client-5.6.install (+0/-3)
build/debian/percona-server-client-5.6.lintian-overrides (+0/-2)
build/debian/percona-server-server-5.6.postinst (+9/-1)
build/percona-server.spec (+26/-27)
build/percona-shared-compat.spec (+4/-0)
doc/Makefile (+0/-145)
doc/source/diagnostics/innodb_deadlock_count.rst (+0/-57)
doc/source/diagnostics/innodb_show_lock_names.rst (+0/-24)
doc/source/diagnostics/innodb_show_status.rst (+0/-475)
doc/source/diagnostics/misc_info_schema_tables.rst (+0/-48)
doc/source/diagnostics/mysql_syslog.rst (+0/-43)
doc/source/diagnostics/process_list.rst (+0/-53)
doc/source/diagnostics/show_engines.rst (+0/-40)
doc/source/diagnostics/slow_extended_55.rst (+0/-377)
doc/source/diagnostics/thread_based_profiling.rst (+0/-17)
doc/source/diagnostics/user_stats.rst (+0/-242)
doc/source/installation/apt_repo.rst (+65/-0)
doc/source/installation/yum_repo.rst (+81/-0)
doc/source/release-notes/Percona-Server-5.6.5-60.0.rst (+0/-26)
doc/source/release-notes/Percona-Server-5.6.6-60.1.rst (+0/-18)
doc/source/release-notes/release-notes_index.rst (+11/-0)
doc/source/upstream-bug-fixes.rst (+13/-1)

Roel Van de Paar (roel11) on 2012-08-27

description:

updated

Revision history for this message

Raghavendra D Prabhu (raghavendra-prabhu) wrote on 2012-09-11:

I found the help tables in a PS 5.5 build I had but not in the RPM installation. So, I think this may be a packaging bug.

tags:

added: pkg

Revision history for this message

Raghavendra D Prabhu (raghavendra-prabhu) wrote on 2012-09-11:

Weird, may not be a packaging bug since the fill_help_tables.sql is indeed empty.

The fill_help_tables.sql states

-- fill_help_tables.sql - this file is a placeholder to satisfy build dependencies -
-- it will be replaced with the appropriate content by the Boostrap script that
-- creates the official source distribution.

So, I think it is just a stub.

However,

from stracing on the mysqld I had built I noticed:

[pid 2513] open("./mysql/help_topic.frm", O_RDONLY) = 36
[pid 2513] open("/home/mysql/mysql/help_topic.MYI", O_RDWR) = 36
[pid 2513] open("./mysql/help_topic.MYD", O_RDWR) = 37
[pid 2513] open("./mysql/help_category.frm", O_RDONLY) = 38
[pid 2513] open("/home/mysql/mysql/help_category.MYI", O_RDWR) = 38
[pid 2513] open("./mysql/help_category.MYD", O_RDWR) = 39
[pid 2513] open("./mysql/help_relation.frm", O_RDONLY) = 40
[pid 2513] open("/home/mysql/mysql/help_relation.MYI", O_RDWR) = 40
[pid 2513] open("./mysql/help_relation.MYD", O_RDWR) = 41
[pid 2513] open("./mysql/help_keyword.frm", O_RDONLY) = 42

I wonder if this is related to mysql_install_db

tags:

removed: pkg

Revision history for this message

Alexey Kopytov (akopytov) wrote on 2012-09-12:

Raghu,

Yes, the fix here is to take fill_help_tables.sql from the corresponding MySQL release binaries and replace the placeholder in Percona Server branches with that one.

I think you had help files in your PS installation because it was reusing a datadir from a previously installed MySQL release.

Revision history for this message

Stewart Smith (stewart) wrote on 2012-09-25:

We should also ensure that the license is compatible... i.e. check for notices in MySQL distribution.

Alexey Bychko (abychko) on 2013-02-06

tags:

added: pkg

Revision history for this message

Roel Van de Paar (roel11) wrote on 2013-06-04:

Header in actual file:

-- Copyright (c) 2003, 2013, Oracle and/or its affiliates. All rights reserved.
--
-- This program is free software; you can redistribute it and/or modify
-- it under the terms of the GNU General Public License as published by
-- the Free Software Foundation; version 2 of the License.

Revision history for this message

Shahriyar Rzayev (rzayev-sehriyar) wrote on 2018-01-25:

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-1933

Report a bug

This report contains Public information

Everyone can see this information.

Duplicates of this bug

Bug #1049286

You are

Subscribing...

Edit bug mail

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.