Bug #8129 help.test fails using --ps-protocol

• Submitted: 25 Jan 2005 11:24
• Modified: 28 Jan 2005 1:07
• Reporter: Ramil Kalimullin
• Status: Closed
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 5.0.3
• OS: FreeBSD (FreeBSD 5.1-RELEASE)
• Assigned to: Ramil Kalimullin
• CPU Architecture: Any

[25 Jan 2005 11:24] Ramil Kalimullin

Description:
$ ./mysql-test-run --ps-protocol help
...
TEST                            RESULT
-------------------------------------------------------
help                           [ fail ]

Errors are (from /usr/home/ram/work/5.0/mysql-test/var/log/mysqltest-time) :
/usr/home/ram/work/5.0/client/.libs/mysqltest: At line 47: query 'help 'function_of_my_dream'' failed: 2013: Lost connection to MySQL server during query
(the last lines may be the most important ones)

How to repeat:
mysql-test-run --ps-protocol help

[26 Jan 2005 7:23] Lenz Grimmer

The "help" test fails differently for me when using --ps-protocol - this is Linux/PPC, compiled with BUILD/compile-ppc-max:

help                           [ fail ]

Errors are (from /home/lenz/my/mysql-5.0-build/mysql-test/var/log/mysqltest-time) :
/home/lenz/my/mysql-5.0-build/client/.libs/mysqltest: At line 116: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/help.result       Thu Jan 13 16:16:32 2005
--- r/help.reject       Wed Jan 26 00:46:28 2005
***************
*** 64,72 ****
  impossible_function_7 N
  help 'impossible_category%';
  name  is_it_category
- impossible_category_1 Y
- impossible_category_2 Y
- impossible_category_3 Y
  help 'impossible_%';
  name  is_it_category
  impossible_function_1 N
--- 64,69 ----
***************
*** 74,82 ****
  impossible_function_3 N
  impossible_function_4 N
  impossible_function_7 N
- impossible_category_1 Y
- impossible_category_2 Y
- impossible_category_3 Y
  help '%function_1';
  name  description     example
  impossible_function_1 description of
--- 71,76 ----
***************
*** 129,137 ****
        example of
   impossible_function1
  help 'impossible_category_1';
! source_category_name  name    is_it_category
! impossible_category_1 impossible_function_1   N
! impossible_category_1 impossible_function_2   N
  alter table mysql.help_relation engine=innodb;
  alter table mysql.help_keyword engine=innodb;
  alter table mysql.help_topic engine=innodb;
--- 123,129 ----
        example of
   impossible_function1
  help 'impossible_category_1';
! name  is_it_category
  alter table mysql.help_relation engine=innodb;
  alter table mysql.help_keyword engine=innodb;
  alter table mysql.help_topic engine=innodb;
***************
*** 147,172 ****
  impossible_function_7 N
  help 'impossible_func%';
  name  is_it_category
- impossible_function_1 N
- impossible_function_2 N
- impossible_function_3 N
- impossible_function_4 N
- impossible_function_7 N
  help 'impossible_category%';
  name  is_it_category
- impossible_category_1 Y
- impossible_category_2 Y
- impossible_category_3 Y
  help 'impossible_%';
  name  is_it_category
- impossible_function_1 N
- impossible_function_2 N
- impossible_function_3 N
- impossible_function_4 N
- impossible_function_7 N
- impossible_category_1 Y
- impossible_category_2 Y
- impossible_category_3 Y
  help '%function_1';
  name  description     example
  impossible_function_1 description of
--- 139,148 ----
***************
*** 214,227 ****
  impossible_category_2 impossible_category_3   Y
  help 'impossible_function_1';
  name  description     example
! impossible_function_1 description of
!  impossible_function1
        example of
!  impossible_function1
  help 'impossible_category_1';
! source_category_name  name    is_it_category
! impossible_category_1 impossible_function_1   N
! impossible_category_1 impossible_function_2   N
  alter table mysql.help_relation engine=myisam;
  alter table mysql.help_keyword engine=myisam;
  alter table mysql.help_topic engine=myisam;
--- 190,201 ----
  impossible_category_2 impossible_category_3   Y
  help 'impossible_function_1';
  name  description     example
! impossible_function_2 description of
!  impossible_function2
        example of
!  impossible_function2
  help 'impossible_category_1';
! name  is_it_category
  alter table mysql.help_relation engine=myisam;
  alter table mysql.help_keyword engine=myisam;
  alter table mysql.help_topic engine=myisam;
-------------------------------------------------------
Please follow the instructions outlined at
http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html
to find the reason to this problem and how to report this.

Aborting: help failed in ps-protocol mode. To continue, re-run with '--force'.

[27 Jan 2005 0:00] Paul DuBois

No change note needed.

[27 Jan 2005 18:21] Sergey Petrunya

See also BUG#8129

[28 Jan 2005 9:04] Sergey Petrunya

correction: See also Bug#8168