Terminal output:
=
=
=
=
=
=
========================================================================
TEST RESULT TIME (ms)
------------------------------------------------------------
worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
backup.backup_myisam [ fail ] Found warnings/
errors in server log file!
Test ended at 2009-07-31 20:35:35
mysqltest: Logging to ''.
mysqltest: Results saved in ''.
mysqltest: Connecting to server localhost:13000 (socket /Users/Joe/
gSoC/mysql-repo/mysql/mysql-test/var/tmp/mysqld.1.sock) as 'root',
connection 'default', attempt 0 ...
mysqltest: ... Connected.
mysqltest: Start processing test commands from './include/check-
warnings.test' ...
file_name line
/Users/Joe/gSoC/mysql-repo/mysql/mysql-test/var/log/mysqld.1.err
Warning: Table: ./mysqltest/
@0J@00a4@0J@00b6@0J@00bc@0J@1R@0I@00a3@0J@00a5 is open on delete
^ Found warnings!!
mysqltest: ... Done processing test commands.
mysqltest: Test has succeeded!
ok
- saving '/Users/Joe/gSoC/mysql-repo/mysql/mysql-test/var/log/
backup.backup_myisam/' to '/Users/Joe/gSoC/mysql-repo/mysql/mysql-test/
var/log/backup.backup_myisam/'
------------------------------------------------------------
The servers were restarted 0 times
Spent 0.000 of 8 seconds executing testcases
mysql-test-run: WARNING: Got errors/warnings while running tests,
please examine '/Users/Joe/gSoC/mysql-repo/mysql/mysql-test/var/log/
warnings' for details.
Failed 1/1 tests, 0.00% were successful.
Failing test(s): backup.backup_myisam
The log files in var/log may give you some hint of what went wrong.
If you want to report this error, please read first the documentation
at http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html
mysql-test-run: *** ERROR: there were failing test cases
Macintosh-55:mysql-test Joe$
Warning File:
-----------------------------------------------
backup.backup_myisam
mysqltest: Logging to ''.
mysqltest: Results saved in ''.
mysqltest: Connecting to server localhost:13000 (socket /Users/Joe/
gSoC/mysql-repo/mysql/mysql-test/var/tmp/mysqld.1.sock) as 'root',
connection 'default', attempt 0 ...
mysqltest: ... Connected.
mysqltest: Start processing test commands from './include/check-
warnings.test' ...
file_name line
/Users/Joe/gSoC/mysql-repo/mysql/mysql-test/var/log/mysqld.1.err
Warning: Table: ./mysqltest/
@0J@00a4@0J@00b6@0J@00bc@0J@1R@0I@00a3@0J@00a5 is open on delete
^ Found warnings!!
mysqltest: ... Done processing test commands.
mysqltest: Test has succeeded!
ok
mysqld.err.warnings
Suspicious lines from /Users/Joe/gSoC/mysql-repo/mysql/mysql-test/var/
log/mysqld.1.err
Warning: Table: ./mysqltest/
@0J@00a4@0J@00b6@0J@00bc@0J@1R@0I@00a3@0J@00a5 is open on delete
backup_myisam.log
USE test;
DROP DATABASE IF EXISTS mysql_db1;
#
# Bug#40944 - Backup: crash after myisampack
#
CREATE DATABASE mysql_db1;
CREATE TABLE mysql_db1.t1 (c1 VARCHAR(5), c2 int);
CREATE INDEX i1 ON mysql_db1.t1 (c1, c2);
INSERT INTO mysql_db1.t1 VALUES ('A',1);
INSERT INTO mysql_db1.t1 SELECT * FROM mysql_db1.t1;
INSERT INTO mysql_db1.t1 SELECT * FROM mysql_db1.t1;
INSERT INTO mysql_db1.t1 SELECT * FROM mysql_db1.t1;
INSERT INTO mysql_db1.t1 SELECT * FROM mysql_db1.t1;
INSERT INTO mysql_db1.t1 SELECT * FROM mysql_db1.t1;
INSERT INTO mysql_db1.t1 SELECT * FROM mysql_db1.t1;
INSERT INTO mysql_db1.t1 SELECT * FROM mysql_db1.t1;
FLUSH TABLE mysql_db1.t1;
BACKUP DATABASE mysql_db1 to 'bup_myisam.bak';
backup_id
#
RESTORE FROM 'bup_myisam.bak' OVERWRITE;
backup_id
#
SELECT COUNT(*) FROM mysql_db1.t1 WHERE c2 < 5;
COUNT(*)
128
DROP TABLE mysql_db1.t1;
DROP DATABASE mysql_db1;
#
# Bug#38045 - Backup, MyISAM and file system encoding
#
CREATE DATABASE mysqltest;
USE mysqltest;
CREATE TABLE `äöüߣå` (id SERIAL);
BACKUP DATABASE mysqltest TO 'bup_myisam.bak';
backup_id
#
DROP TABLE `äöüߣå`;
USE test;
DROP DATABASE mysqltest;
Hope this is enough of the output files and the terminal output. If
it is not what you need please let me know and I will try and find the
file.
Joe
On Jul 31, 2009, at 4:08 AM, Ingo Strüwing wrote:
> Hi Joseph,
>
> Joseph Lukas, 30.07.2009 19:56:
>
> ...
>> There is one other error I do not know why it is there. I do not
>> believe it is my code though since the error it generates. The
>> test is
>> backup_myisam.test as it seems the tests inside run fine but the
>> part
>> where it drops the test table causes an error.
>>
>> USE test;
>> DROP DATABASE mysqltest;
>> --remove_file $MYSQLD_BACKUPDIR/bup_myisam.bak
>>
>> When it moves to drop the table at the end the warning declares it as
>> still in use. The statement though says USE test and should have
>> switched the database and allowed the removal of mysqltest. That is
>> what
>> the log file stated whether I read it right I do not know and could
>> be
>> an issue with my code.
> ...
>
>
> I would like to see the output of the test run, including the error
> message and "The result from queries just before the failure".
>
> Regards
> Ingo
> --
> Ingo Strüwing, Database Group
> Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten
> Geschäftsführer: Thomas Schröder, Wolfgang Engels, Wolf Frenkel
> Vorsitzender des Aufsichtsrates: Martin Häring HRB München 161028
