main.alter_table-big fails --with-debug on 11.0

[Aleksandr Kuzminsky]

Percona Server is configure --with-debug option

main.alter_table-big [ fail ]
        Test ended at 2010-06-06 19:42:56

CURRENT_TEST: main.alter_table-big
--- /mnt/data1/home/buildbot/slaves/percona-server-51-11/sm1u02/build/Percona-Server/mysql-test/r/alter_table-big.result 2010-05-06 18:58:36.000000000 +0300
+++ /mnt/data1/home/buildbot/slaves/percona-server-51-11/sm1u02/build/Percona-Server/mysql-test/r/alter_table-big.reject 2010-06-07 05:42:56.000000000 +0300
@@ -6,6 +6,8 @@
 create table t2 (i int);
 alter table t1 disable keys;
 insert into t1 values (RAND()*1000, RAND()*1000, RAND()*1000);
+Warnings:
+Note 1592 Statement may not be safe to log in statement format.
 reset master;
 set session debug="+d,sleep_alter_enable_indexes";
 alter table t1 enable keys;;

mysqltest: Result content mismatch

[Aleksandr Kuzminsky (akuzminsky)]

The test fails on stock MySQL as well http://bugs.mysql.com/bug.php?id=54336

[Peter Zaitsev (pz-percona)]

Alexandr,

Is this test only repeatable if server is compiled --with-debug ?
If so you have not mentioned it in MySQL Bug report

On Tue, Jun 8, 2010 at 6:38 AM, Aleksandr Kuzminsky <
<email address hidden>> wrote:

> The test fails on stock MySQL as well
> http://bugs.mysql.com/bug.php?id=54336
>
> ** Bug watch added: MySQL Bug System #54336
> http://bugs.mysql.com/bug.php?id=54336
>
> --
> main.alter_table-big fails --with-debug on 11.0
> https://bugs.launchpad.net/bugs/590627
> You received this bug notification because you are a member of Percona
> developers, which is the registrant for Percona Server.
>
> Status in Percona Server with XtraDB: New
>
> Bug description:
> Percona Server is configure --with-debug option
>
> main.alter_table-big [ fail ]
> Test ended at 2010-06-06 19:42:56
>
> CURRENT_TEST: main.alter_table-big
> ---
> /mnt/data1/home/buildbot/slaves/percona-server-51-11/sm1u02/build/Percona-Server/mysql-test/r/alter_table-big.result
> 2010-05-06 18:58:36.000000000 +0300
> +++
> /mnt/data1/home/buildbot/slaves/percona-server-51-11/sm1u02/build/Percona-Server/mysql-test/r/alter_table-big.reject
> 2010-06-07 05:42:56.000000000 +0300
> @@ -6,6 +6,8 @@
> create table t2 (i int);
> alter table t1 disable keys;
> insert into t1 values (RAND()*1000, RAND()*1000, RAND()*1000);
> +Warnings:
> +Note 1592 Statement may not be safe to log in statement format.
> reset master;
> set session debug="+d,sleep_alter_enable_indexes";
> alter table t1 enable keys;;
>
> mysqltest: Result content mismatch
>
>
>

--
Peter Zaitsev, CEO, Percona Inc.
Tel: [phone] ext 501 Skype: peter_zaitsev
24/7 Emergency Line [phone] ext 911

Percona Training Workshops
http://www.percona.com/training/

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-2531