Bug #30430 crash: ./mtr --embeded-server --ps-protocol cache_innodb func_misc ...
Submitted: 15 Aug 2007 8:55 Modified: 23 Jan 2008 18:20
Reporter: Timothy Smith Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Embedded Library ( libmysqld ) Severity:S2 (Serious)
Version:5.1 OS:Any
Assigned to: Alexey Botchkov CPU Architecture:Any

[15 Aug 2007 8:55] Timothy Smith
Description:
Several test cases cause mysqltest to crash when run with --embedded-server --ps-protocol: cache_innodb func_misc innodb_mysql query_cache query_cache_merge view_query_cache

The tests pass with --embedded-server, and with --ps-protocol, but not with both at the same time.

How to repeat:
Built with BUILD/compile-pentium-debug-max on Linux.

$ ./mtr --embedded-server --ps-protocol cache_innodb
Requesting build thread... got 200
Logging: ./mtr --embedded-server --ps-protocol cache_innodb
MySQL Version 5.1.22
<cut>
main.cache_innodb              [ fail ]

ERROR: mysqltest returned unexpected code 139, it has probably crashed

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

Suggested fix:
Unfortunately I don't see anything helpful in var/log/*, and the --gdb option doesn't work with --embedded-server.  I didn't investigate futher to see where it's crashing.
[12 Nov 2007 7:34] 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/37558

ChangeSet@1.2637, 2007-11-12 11:28:56+04:00, holyfoot@mysql.com +4 -0
  Bug #30430 crash:./mtr --embedded-server --ps-protocol cache_innodb func_misc...
  
  PS-protocol data is stored in different format - the MYSQL_RECORDS->data
  contains the link to the record content, not to array of the links to
  the field's contents. So we have to handle it separately for
  embedded-server query cache.
[30 Nov 2007 13:29] Alexander Barkov
http://lists.mysql.com/commits/37558 - ok to push
[30 Nov 2007 18:23] 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/39006

ChangeSet@1.2637, 2007-11-30 22:17:11+04:00, holyfoot@mysql.com +4 -0
  Bug #30430 crash:./mtr --embedded-server --ps-protocol cache_innodb func_misc...
  
  PS-protocol data is stored in different format - the MYSQL_RECORDS->data
  contains the link to the record content, not to array of the links to
  the field's contents. So we have to handle it separately for
  embedded-server query cache.
[14 Dec 2007 8:18] Bugs System
Pushed into 5.1.23-rc
[14 Dec 2007 8:21] Bugs System
Pushed into 6.0.5-alpha
[23 Jan 2008 18:20] Paul DuBois
Noted in 5.1.23, 6.0.5 changelogs.

With libmysqld, use of prepared statements and the query cache at the
same time caused problems.