List:Internals« Previous MessageNext Message »
From:Joseph Lukas Date:August 1 2009 12:50am
Subject:Re: case types
View as plain text  


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

Thread
case typesJoseph Lukas30 Jul
  • Re: case typesIngo Strüwing31 Jul
    • Re: case typesJoseph Lukas1 Aug
  • Re: case typesSergei Golubchik31 Jul