MySQL Bugs: #40702: skip_name_resolve fails sporadically on pushbuild

Bug #40702	skip_name_resolve fails sporadically on pushbuild
Submitted:	13 Nov 2008 15:17	Modified:	18 Mar 2009 14:37
Reporter:	Sven Sandberg	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Tests: Server	Severity:	S7 (Test Cases)
Version:	5.1-rpl, 6.0-rpl	OS:	Any
Assigned to:	Dmitry Lenev	CPU Architecture:	Any
Tags:	pushbuild, show processlist, skip_name_resolve, sporadic, test failure

Description:
pushbuild failure:

main.skip_name_resolve                   [ fail ]

CURRENT_TEST: main.skip_name_resolve
--- /data0/pushbuild/pb/bzr_mysql-5.1-rpl/68/mysql-5.1.30-pb68/mysql-test/r/skip_name_resolve.result	2008-10-13 20:25:58.000000000 +0300
+++ /data0/pushbuild/pb/bzr_mysql-5.1-rpl/68/mysql-5.1.30-pb68/mysql-test/r/skip_name_resolve.reject	2008-10-13 20:48:58.000000000 +0300
@@ -10,5 +10,6 @@
 #
 show processlist;
 Id	User	Host	db	Command	Time	State	Info
+<id>	root	<host>	NULL	<command>	<time>	<state>	<info>
 <id>	root	<host>	test	<command>	<time>	<state>	<info>
 <id>	root	<host>	test	<command>	<time>	<state>	<info>

mysqltest: Result length mismatch

 - saving '/dev/shm/var-n_mix-110/3/log/main.skip_name_resolve/' to '/dev/shm/var-n_mix-110/log/main.skip_name_resolve/'

Retrying test, attempt(2/3)...

How to repeat:
https://intranet.mysql.com/secure/pushbuild/showpush.pl?dir=bzr_mysql-5.1-rpl&order=68 sapsrv2/n_mix
xref: http://tinyurl.com/5zvawj

Suggested fix:
The reason is that the test uses SHOW PROCESSLIST. In 5.1-rpl, the server is not restarted every test, so threads started in the previous test case can show up in the result file, causing a test failure.

A fix is to disable output for the SHOW PROCESSLIST.

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/68096

2757 Dmitry Lenev	2009-03-03
      Fix for bug #40702 "skip_name_resolve fails sporadically on
      pushbuild".
      
      Under new MTR the server is not restarted for every test, so
      threads started in the previous test case can show up in the
      results of SHOW PROCESSLIST statement in this test, causing a
      test failure.
      
      Since we are not really interested in results of SHOW PROCESSLIST
      in this test but rather in fact that server doesn't crash when
      executing this statement this fix simply disables output of this
      statement.
     @ mysql-test/r/skip_name_resolve.result
        Disable SHOW PROCESSLIST output to make test immune to threads
        started in previous test cases.
     @ mysql-test/t/skip_name_resolve.test
        Disable SHOW PROCESSLIST output to make test immune to threads
        started in previous test cases.

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/68233

2828 Dmitry Lenev	2009-03-04
      Fix for bug #40702 "skip_name_resolve fails sporadically on
      pushbuild".
      
      Under new MTR the server is not restarted for every test, so
      threads started in the previous test case can show up in the
      results of SHOW PROCESSLIST statement in this test, causing a
      test failure.
      
      Since we are not really interested in results of SHOW PROCESSLIST
      in this test but rather in fact that server doesn't crash when
      executing this statement this fix simply disables output of this
      statement.
     @ mysql-test/r/skip_name_resolve.result
        Disable SHOW PROCESSLIST output to make test immune to threads
        started in previous test cases.
     @ mysql-test/t/skip_name_resolve.test
        Disable SHOW PROCESSLIST output to make test immune to threads
        started in previous test cases.

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/68235

3103 Dmitry Lenev	2009-03-04 [merge]
      Merged fix for bug #40702 "skip_name_resolve fails
      sporadically on pushbuild" into 6.0.

Fix for this bug was queued into mysql-5.1-bugteam and mysql-6.0-bugteam trees.

For the record. This bug report describes an issue with one of our tests and does not exposes any problems inside server.

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/68340

2833 He Zhenxing	2009-03-05 [merge]
      Auto merge

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/68341

3102 He Zhenxing	2009-03-05 [merge]
      Auto merge

Pushed into 5.1.33 (revid:joro@sun.com-20090313111355-7bsi1hgkvrg8pdds) (version source revid:zhou.li@sun.com-20090311061050-ihp0g77znonq1tuq) (merge vers: 5.1.33) (pib:6)

Test case changes. No changelog entry needed.

Setting report to NDI pending push into 6.0.x.

Pushed into 6.0.11-alpha (revid:joro@sun.com-20090318122208-1b5kvg6zeb4hxwp9) (version source revid:matthias.leich@sun.com-20090310140952-gwtoq87wykhji3zi) (merge vers: 6.0.11-alpha) (pib:6)

Test case changes. No changelog entry needed.

Pushed into 5.1.34-ndb-6.2.18 (revid:jonas@mysql.com-20090508185236-p9b3as7qyauybefl) (version source revid:jonas@mysql.com-20090508100057-30ote4xggi4nq14v) (merge vers: 5.1.33-ndb-6.2.18) (pib:6)

Pushed into 5.1.34-ndb-6.3.25 (revid:jonas@mysql.com-20090509063138-1u3q3v09wnn2txyt) (version source revid:jonas@mysql.com-20090508175813-s6yele2z3oh6o99z) (merge vers: 5.1.33-ndb-6.3.25) (pib:6)

Pushed into 5.1.34-ndb-7.0.6 (revid:jonas@mysql.com-20090509154927-im9a7g846c6u1hzc) (version source revid:jonas@mysql.com-20090509073226-09bljakh9eppogec) (merge vers: 5.1.33-ndb-7.0.6) (pib:6)