Bug #37800 main.ps_ddl and main.ps_ddl1 fail randomly on windows

• Submitted: 2 Jul 2008 10:52
• Modified: 11 Feb 2009 17:49
• Reporter: Alexander Nozdrin
• Status: Duplicate
• Category: MySQL Server: Information schema
• Severity: S3 (Non-critical)
• Version: 6.0-BK
• OS: Any
• CPU Architecture: Any
• Tags: pushbuild, sporadic, test failure

[2 Jul 2008 10:52] Alexander Nozdrin

Description:
mysqltest: At line 289: query 'call p_verify_reprepare_count(0)' failed: 1: Can't create/write to file 'c:\tmp\pbtmp-ps_stm-101\#sql_1300_0.MYD' (Errcode: 13)

The result from queries just before the failure was:
< snip >
deallocate prepare stmt;
drop view t1;
drop table t2;
=====================================================================
Some freestyle tests
=====================================================================
create temporary table t1 as select 1 as a;
create procedure p1()
begin
drop temporary table t1;
end|
create function f1() returns int
begin
call p1();
return 1;
end|
prepare stmt from "select f1() as my_column, a from t1";
execute stmt;
ERROR HY000: Can't reopen table: 't1'
call p_verify_reprepare_count(0);

How to repeat:
https://intranet.mysql.com/secure/pushbuild/xref.pl?testname=main.ps_ddl1

[3 Jul 2008 6:48] Alexander Nozdrin

Symptoms:
---------------------------------------------------------------------
mysqltest: At line 1216: query 'call p_verify_reprepare_count(1)' failed: 1: Can't create/write to file 'c:\tmp\pbtmp-ps_row-102\#sql_d08_0.MYD' (Errcode: 13)

The result from queries just before the failure was:
< snip >
create table t_27420_100(a int);
insert into t_27420_100 values (1), (2);
create table t_27420_101(a int);
insert into t_27420_101 values (1), (2);
create view v_27420 as select t_27420_100.a X, t_27420_101.a Y
from t_27420_100, t_27420_101
where t_27420_100.a=t_27420_101.a;
prepare stmt from "select * from v_27420";
execute stmt;
X	Y
1	1
2	2
call p_verify_reprepare_count(0);
SUCCESS

drop view v_27420;
create table v_27420(X int, Y int);
execute stmt;
X	Y
call p_verify_reprepare_count(1);
---------------------------------------------------------------------

https://intranet.mysql.com/secure/pushbuild/xref.pl?startdate=&enddate=&dir=&plat=&testtyp...

[1 Oct 2008 6:03] Alexander Nozdrin

See also Bug#39750.

[11 Feb 2009 17:49] Alexander Nozdrin

Closed as a duplicate of Bug#39750.