Bug #36966 mysqldump.test fails in pushbuild
Submitted: 26 May 2008 14:14 Modified: 8 May 2009 19:41
Reporter: Ingo Strüwing Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: mysqldump Command-line Client Severity:S3 (Non-critical)
Version:6.0 tree OS:Any
Assigned to: Sergey Vojtovich CPU Architecture:Any
Tags: pushbuild, sporadic, test failure

[26 May 2008 14:14] Ingo Strüwing 
Description:
Seen on sqpsrv2 on 6.0-engines-merge:

main.mysqldump                 [ fail ]

mysqldump: Couldn't find table: "non_existing"
mysqldump: Got error: 1356: View 'test.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them when using LOCK TABLES
mysqldump: Couldn't execute 'SHOW FIELDS FROM `v1`': View 'test.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
mysqldump: user2 has insufficent privileges to SHOW CREATE PROCEDURE `sp1`!
--- /data0/pushbuild/pb/mysql-6.0-engines/131/mysql-6.0.6-alpha-pb131/mysql-test/r/mysqldump.result	2008-05-05 14:39:33.000000000 +0300
+++ /data0/pushbuild/pb/mysql-6.0-engines/131/mysql-6.0.6-alpha-pb131/mysql-test/r/mysqldump.reject	2008-05-05 15:14:39.000000000 +0300
@@ -13,12 +13,6 @@
 		<key Table="t1" Non_unique="1" Key_name="a" Seq_in_index="1" Column_name="a" Collation="A" Null="YES" Index_type="BTREE" Comment="" Index_Comment="" />
 	</table_structure>
 	<table_data name="t1">
-	<row>
-		<field name="a">1</field>
-	</row>
-	<row>
-		<field name="a">2</field>
-	</row>
 	</table_data>
 </database>
 </mysqldump>

mysqltest: Result content mismatch

I will disable the test case. Please re-enable after fix.

How to repeat:
See pushbuild
[26 May 2008 20:50] Sveta Smirnova 
Thank you for the report.

I can not repeat described behavior with binaries compiled with help of script BUILD/compile-pentium64-debug-max. Please indicate your compilation options.
[27 May 2008 7:44] Ingo Strüwing 
I do not know what exact options pushbuild uses. I think the test fails randomly. So it is questionable if you can repeat it.

I suggest to assign it to someone who just re-enables the test case and sets "can't repeat".
[27 May 2008 13:02] Sveta Smirnova 
Thank you for the feedback.

Closed as "Can't repeat"
[27 May 2008 13:28] Ingo Strüwing 
Ok, but did you re-enable the test case as I suggested?
[27 May 2008 13:36] Sveta Smirnova 
Yes, from the start. How could I verify it with disabled test? :)
[27 May 2008 14:04] Ingo Strüwing 
I see. But to which team tree did you push the patch that re-enables the test case? I don't see it in the main tree, nor in 6.0-engines-merge.
[27 May 2008 14:39] Sveta Smirnova 
I can not push patches to any tree except my local copy.
[21 Apr 2009 8:34] Sergey Vojtovich 
Stealing this bug. At least it is affecting all trees starting 5.0.

Please re-triage this bug. Both effort to fix and risk to fix are negligible.

mysqldump.test is designed to run with concurrent inserts disabled. It is disabling concurrent inserts at the very beginning of the test case, and re-enables them at the bottom of the test. But for some reason (likely incorrect merge) we enable concurrent inserts in the middle of the test.

For additional information see BUG#36618.
[21 Apr 2009 9:00] 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/72548

2729 Sergey Vojtovich	2009-04-21
      BUG#36966 - mysqldump.test fails in pushbuild
      
      mysqldump.test is designed to run with concurrent inserts
      disabled. It is disabling concurrent inserts at the very
      beginning of the test case, and re-enables them at the
      bottom of the test. But for some reason (likely incorrect
      merge) we enable concurrent inserts in the middle of the test.
      
      The problem is fixed by enabling concurrent inserts only
      at the bottom of the test case.
      modified:
        mysql-test/r/mysqldump.result
        mysql-test/t/mysqldump.test
[5 May 2009 18:53] Bugs System 
Pushed into 5.0.82 (revid:davi.arnaut@sun.com-20090505184158-dvmedh8n472y8np5) (version source revid:davi.arnaut@sun.com-20090505184158-dvmedh8n472y8np5) (merge vers: 5.0.82) (pib:6)
[5 May 2009 19:41] Bugs System 
Pushed into 5.1.35 (revid:davi.arnaut@sun.com-20090505190206-9xmh7dlc6kom8exp) (version source revid:davi.arnaut@sun.com-20090505190206-9xmh7dlc6kom8exp) (merge vers: 5.1.35) (pib:6)
[6 May 2009 14:12] Bugs System 
Pushed into 6.0.12-alpha (revid:svoj@sun.com-20090506125450-yokcmvqf2g7jhujq) (version source revid:svoj@sun.com-20090421100028-jtmn0hcxtol1ly7z) (merge vers: 6.0.11-alpha) (pib:6)
[8 May 2009 19:41] Paul DuBois 
Test case changes. No changelog entry needed.
[15 Jun 2009 8:28] Bugs System 
Pushed into 5.1.35-ndb-6.3.26 (revid:jonas@mysql.com-20090615074202-0r5r2jmi83tww6sf) (version source revid:jonas@mysql.com-20090615070837-9pccutgc7repvb4d) (merge vers: 5.1.35-ndb-6.3.26) (pib:6)
[15 Jun 2009 9:07] Bugs System 
Pushed into 5.1.35-ndb-7.0.7 (revid:jonas@mysql.com-20090615074335-9hcltksp5cu5fucn) (version source revid:jonas@mysql.com-20090615072714-rmfkvrbbipd9r32c) (merge vers: 5.1.35-ndb-7.0.7) (pib:6)
[15 Jun 2009 9:48] Bugs System 
Pushed into 5.1.35-ndb-6.2.19 (revid:jonas@mysql.com-20090615061520-sq7ds4yw299ggugm) (version source revid:jonas@mysql.com-20090615054654-ebgpz7elwu1xj36j) (merge vers: 5.1.35-ndb-6.2.19) (pib:6)