Percona Server with XtraDB

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

Reported by Roel Van de Paar on 2012-08-27
14
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Percona Server
Status tracked in 5.6
5.1
Low
Alexey Bychko
5.5
Low
Alexey Bychko
5.6
Low
Laurynas Biveinis

Bug Description

description: updated

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

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
Alexey Kopytov (akopytov) wrote :

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.

Stewart Smith (stewart) wrote :

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
Roel Van de Paar (roel11) wrote :

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.

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Duplicates of this bug

Other bug subscribers