[MDEV-3811] main.ps_ddl flaky (12 failures over 100 runs) Created: 2012-10-17  Updated: 2012-12-10  Resolved: 2012-12-10

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 5.5.27
Fix Version/s: 5.5.28

Type: Bug Priority: Minor
Reporter: Andrew Ford Assignee: Elena Stepanova
Resolution: Fixed Votes: 0
Labels: None
Environment:

x86_64 GNU/Linux (kernel based on 2.6.38)


 Description   

main.ps_ddl does not pass consistently. Prepared statement view->temporary table transition in particular. It is more flaky with -DCMAKE_BUILD_TYPE=Debug (fails roughly twice as often).

MariaDB Version 5.5.27-MariaDB-debug
Installing system database...

  • skipping ndbcluster
  • skipping SSL, mysqld not compiled with SSL
  • binaries are debug compiled
    Collecting tests...
    Using server port 37374

==============================================================================

TEST RESULT TIME (ms) or COMMENT
--------------------------------------------------------------------------

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019
main.ps_ddl [ fail ]
Test ended at 2012-10-17 09:05:19

CURRENT_TEST: main.ps_ddl
— /usr/local/google/home/andrewford/mariadb/mariadb55/mysql-test/r/ps_ddl.result 2012-10-10 10:32:19.475265252 -0700
+++ /usr/local/google/home/andrewford/mariadb/mariadb55/mysql-test/r/ps_ddl.reject 2012-10-17 09:05:19.721286104 -0700
@@ -781,7 +781,7 @@
create temporary table t1 (a int);
execute stmt;
table_name
-t1
+NULL
call p_verify_reprepare_count(0);
SUCCESS

mysqltest: Result length mismatch

Warnings from just before the error:
Note 1051 Unknown table 'test.v1'

 Comments   
Comment by Elena Stepanova [ 2012-11-09 ]

Hi Andrew,

Could you please specify

  • whether you build from release or LP source, and in the latter case – which revision;
  • the exact flavor of Linux you are running the tests on;
  • if there are any non-default build options apart from CMAKE_BUILD_TYPE;
  • the full MTR command line you use to run the tests.

So far I couldn't reproduce the problem.

Comment by Andrew Ford [ 2012-11-21 ]

I download the source tarball from https://downloads.mariadb.org/mariadb/5.5.27/

It is based on Ubuntu, but has a custom kernel and some custom packages.

<in root of clean tarball>:
cmake -DCMAKE_BUILD_TYPE=Debug .
make
cd mysql-test
SUCCESS=0
for i in

{1..100}

; do ./mysql-test-run.pl main.ps_ddl && SUCCESS=$(($SUCCESS+1)); done
echo $SUCCESS

<prints something around 84 (varies)>

Comment by Elena Stepanova [ 2012-11-24 ]

Thanks.
The reason I couldn't reproduce it on the current maria/5.5 tree is that it was actually fixed right after 5.5.27 release, in this revision: http://bazaar.launchpad.net/~maria-captains/maria/5.5/revision/3528

Could you please try 5.5.28 release to see if you observe the problem there?

Comment by Elena Stepanova [ 2012-12-10 ]

Please feel free to re-open if you find out it's still reproducible in your environment.

Generated at Thu Feb 08 06:51:23 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.