main.ps_ddl flaky (12 failures over 100 runs)

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'

Environment

x86_64 GNU/Linux (kernel based on 2.6.38)

Status

Assignee

Elena Stepanova

Reporter

Andrew Ford

Labels

None

Fix versions

Affects versions

Priority

Minor
Configure