MySQL Bugs: #53461: MTR test backup_compression fails if Blackhole not statically linked

Bug #53461	MTR test backup_compression fails if Blackhole not statically linked
Submitted:	6 May 2010 10:23	Modified:	26 May 2010 17:35
Reporter:	Olav Sandstå	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Tests: Backup	Severity:	S3 (Non-critical)
Version:	6.0.14	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
When running the MTR backup test "backup_compression" against a MySQL server that does not have the Blackhole storage engine statically linked the test fails with the following error message:

 CREATE TABLE db3.t1(c INT) ENGINE= BLACKHOLE;
+Warnings:
+Warning        1286    Unknown storage engine 'BLACKHOLE'
+Warning        1266    Using storage engine MyISAM for table 't1'

How to repeat:
1. Use the source code from mysql-6.0-codebase

2. Compile without linking the Blackhole storage engine statically into the MySQL server process. Eg.:

     cmake . -DWITH_DEBUG=1 -DWITH_INNOBASE_STORAGE_ENGINE=1
     make

   This will build Blackhole as a plugin.

3. Run the test:

     cd mysql_test
     ./mtr backup_compression

Suggested fix:
Alternative solutions:

a. do not run the test if blackhole storage engine is not statically included in the mysqld process.

b. Try to load the blackhole plugin if it is available

c. Move the blackhole dependent tests to a separate test

Solution a. can be implemented by adding:

--source include/have_blackhole.inc

at the top of the test.

Isn't this a bug in the test and not a bug in the server?

I think it is bug in the way we run tests, not in the product itself. Setting category to Tests/Backup.

Looks like bug fixed now?

I get:

backup.backup_compression                [ skipped ]  Need blackhole engine

and there is "--source include/have_blackhole.inc" in the test.

Rafal, could you please confirm?

I confirm that this test is fixed in mysql-next-mr-backup tree.

Thank you for the feedback.

Setting to closed.