Bug #21524 'ps' test fails in --ps-protocol test AMD64 bit
Submitted: 8 Aug 2006 21:02 Modified: 6 Nov 2006 14:44
Reporter: Patrick Galbraith Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Tests Severity:S3 (Non-critical)
Version:Ver 5.1.12-beta-debug OS:Linux (Suse Linux, AMD 64-bit)
Assigned to: Bugs System CPU Architecture:Any
Tags: tsmith@maint1.mysql.com

[8 Aug 2006 21:02] Patrick Galbraith
Description:
While running mysql-test-run.pl --ps-protocol, the test fails. In looking at the trace, it fails in "multi_delete_precheck". I was unable to get --gdb to bring up a working debug session because when it fails, it brings down the gdb window that comes up (?)

TEST                           RESULT         TIME (ms)
-------------------------------------------------------

ps                             [ fail ]

Errors are (from /home/patg/mysql-build/mysql-5.1-clean2/mysql-test/var/log/mysqltest-time) :
mysqltest: At line 507: query 'execute stmt' failed: 2013: Lost connection to MySQL server during query
Warning: Not freed memory segments: 1
Warning: Memory that was not free'ed (256 bytes):
           256 bytes at 0x000610368, allocated at line   40 in 'string.c'
Maximum memory usage: 426914 bytes (417k)
(the last lines may be the most important ones)
Result from queries before failure can be found in r/ps.log

Trace:

T@10895138: | | >alloc_root
T@10895138: | | | enter: root: 0x1c3ebe0
T@10895138: | | | exit: ptr: 0x1c4dcd8
T@10895138: | | <alloc_root
T@10895138: | | >mysql_execute_command
T@10895138: | | | >mysql_sql_stmt_execute
T@10895138: | | | | info: EXECUTE: stmt

T@10895138: | | | | >hash_first
T@10895138: | | | | | exit: found key at 0
T@10895138: | | | | <hash_first
T@10895138: | | | | info: stmt: 0x1c67e88
T@10895138: | | | | >insert_params_from_vars
T@10895138: | | | | | >_mymalloc
T@10895138: | | | | | | enter: Size: 64
T@10895138: | | | | | | exit: ptr: 0x1c4a2e8
T@10895138: | | | | | <_mymalloc
T@10895138: | | | | <insert_params_from_vars
T@10895138: | | | | >hash_init
T@10895138: | | | | | enter: hash: 0x40f07e28  size: 0
T@10895138: | | | | | >init_dynamic_array
T@10895138: | | | | | | >_mymalloc
T@10895138: | | | | | | | enter: Size: 8144
T@10895138: | | | | | | | exit: ptr: 0x1c69f68
T@10895138: | | | | | | <_mymalloc
T@10895138: | | | | | <init_dynamic_array
T@10895138: | | | | <hash_init
T@10895138: | | | | >Statement::set_n_backup_statement
T@10895138: | | | | <Statement::set_n_backup_statement
T@10895138: | | | | >alloc_root
T@10895138: | | | | | enter: root: 0x1c3ebe0
T@10895138: | | | | | exit: ptr: 0x1c4dce0
T@10895138: | | | | <alloc_root
T@10895138: | | | | >reinit_stmt_before_use
T@10895138: | | | | | >Item_result_field::cleanup()
T@10895138: | | | | | | >Item::cleanup
T@10895138: | | | | | | <Item::cleanup
T@10895138: | | | | | <Item_result_field::cleanup()
T@10895138: | | | | <reinit_stmt_before_use
T@10895138: | | | | >mysql_execute_command
T@10895138: | | | | | >mysql_reset_errors
T@10895138: | | | | | | >free_root
T@10895138: | | | | | | | enter: root: 0x1c3fcf8  flags: 0
T@10895138: | | | | | | <free_root
T@10895138: | | | | | | | enter: root: 0x1c3fcf8  flags: 0
T@10895138: | | | | | | <free_root
T@10895138: | | | | | <mysql_reset_errors
T@10895138: | | | | | >wait_if_global_read_lock
T@10895138: | | | | | <wait_if_global_read_lock
T@10895138: | | | | | >multi_delete_precheck
T@10895138: | | | | | | >check_grant
T@10895138: | | | | | | <check_grant

How to repeat:
build 5.1 tree, run from within mysql-test dir, "mysql-test-run.pl --ps-protocol --debug ps" (no need to run debug, though I did to obtain a trace)
[10 Oct 2006 20:19] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/13435

ChangeSet@1.2357, 2006-10-11 00:18:38+04:00, ted@ted.mysql.internal +3 -0
  BUG#21524 ps.test updated to meet recent changes in SQL parser
[10 Oct 2006 22:36] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/13437

ChangeSet@1.2357, 2006-10-11 02:36:36+04:00, ted@ted.mysql.internal +3 -0
  BUG#21524 ps.test updated to meet recent changes in SQL parser
[11 Oct 2006 3:08] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/13438

ChangeSet@1.2358, 2006-10-11 07:08:32+04:00, ted@ted.mysql.internal +2 -0
  BUG#21524 ER_CANT_OPEN_LIBRARY output message used to confuse mysqltest on Solaris. Varying part of the message is now suppressed
[11 Oct 2006 11:54] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/13494

ChangeSet@1.2310, 2006-10-11 15:53:56+04:00, ted@ted.mysql.internal +3 -0
  BUG#21524 ps.test updated to meet recent changes in SQL parser
[6 Nov 2006 14:44] Paul Dubois
Test suite change. No changelog entry needed.