← Back to team overview

maria-developers team mailing list archive

Re: MariaDB + PBXT

 

Paul McCullagh <paul.mccullagh@xxxxxxxxxxxxx> writes:

> On Apr 6, 2009, at 1:17 PM, Kristian Nielsen wrote:

>> Just let me know if you need more help/information on these failures.
>
> Yes, thanks. I would like to get these fixed.

I have attached a log of running the test suite on my machine. This is an
Ubuntu Hardy 64-bit OS running on an Intel Q6600 quad-core CPU. It was built
with BUILD/compile-pentium64-debug-max from your maria-pbxt branch.

Let me know if you need further information. Also, I should be able to help
more once I get a buildbot slave up running the pbxt tests.

> OK, I will push it.

Great, thanks.

 - Kristian.

Script started on 2009-04-07T11:56:10 CEST
]0;knielsen@loke: ~/devel/maria/my/maria-pbxtknielsen@loke:~/devel/maria/my/maria-pbxt$ (cd mysql-test && perl mysql-test-run 
.pl --mysqld=--default-storage-engine=pbxt --suite=pbxt --force)-force)-force)s--force)k--force)i--force)p--force)-force)force)--force)--force)--force)--force)r--force)e--force)p--force)e--force)a--force)t--force)--force)--force)--force)--force)t--force)r--force)y--force)=--force)1--force) --force)-force)-force)m--force)a--force)x--force)-force) t--force)
)e--force)s--force)t--force)-force)f--force)a--force)i--force)
l--force)
=--force)
0--force)
 --force)


Logging: mysql-test-run.pl  --mysqld=--default-storage-engine=pbxt --suite=pbxt --retry=1 --max-test-fail=0 --force

MySQL Version 5.1.32

Using default engine 'pbxt'

Checking supported features...

 - skipping ndbcluster, mysqld not compiled with ndbcluster

 - skipping SSL

 - binaries are debug compiled

Collecting tests...

vardir: /home/knielsen/devel/maria/my/maria-pbxt/mysql-test/var

Checking leftover processes...

Removing old var directory...

Creating var directory '/home/knielsen/devel/maria/my/maria-pbxt/mysql-test/var'...

Installing system database...

Using server port 53722

Removing slot 251 used by missing process 31016

Removing slot 250 used by missing process 31015

worker[1] Using MTR_BUILD_THREAD 250, with reserved ports 12500..12509

worker[1]  - 'localhost:12500' was not free

worker[1] mysql-test-run: *** ERROR: Some port(s) was not free



==============================================================================



TEST                                      RESULT   TIME (ms)

------------------------------------------------------------



mysql-test-run: *** ERROR: Test suite aborted

]0;knielsen@loke: ~/devel/maria/my/maria-pbxtknielsen@loke:~/devel/maria/my/maria-pbxt$ (cd mysql-test && perl mysql-test-run.
.pl --mysqld=--default-storage-engine=pbxt --suite=pbxt --retry=1 --max-test-fail
l=0 --force)Mperl mysql-test-run.pl --mysqld=--default-storage-engine=pbxt --suite=pbxt --retry=1 --max-test-fai[1@lTperl mysql-test-run.pl --mysqld=--default-storage-engine=pbxt --suite=pbxt --retry=1 --max-test-fa[1@iRperl mysql-test-run.pl --mysqld=--default-storage-engine=pbxt --suite=pbxt --retry=1 --max-test-f[1@a_perl mysql-test-run.pl --mysqld=--default-storage-engine=pbxt --suite=pbxt --retry=1 --max-test-[1@fBperl mysql-test-run.pl --mysqld=--default-storage-engine=pbxt --suite=pbxt --retry=1 --max-test[1@-Uperl mysql-test-run.pl --mysqld=--default-storage-engine=pbxt --suite=pbxt --retry=1 --max-tes[1@tIperl mysql-test-run.pl --mysqld=--default-storage-engine=pbxt --suite=pbxt --retry=1 --max-te[1@sLperl mysql-test-run.pl --mysqld=--default-storage-engine=pbxt --suite=pbxt --retry=1 --max-t[1@eDperl mysql-test-run.pl --mysqld=--default-storage-engine=pbxt --suite=pbxt --retry=1 --max-[1@t_perl mysql-test-run.pl --mysqld=--default-storage-engine=pbxt --suite=pbxt --retry=1 --max[1@-Tperl mysql-test-run.pl --mysqld=--default-storage-engine=pbxt --suite=pbxt --retry=1 --ma[1@xHperl mysql-test-run.pl --mysqld=--default-storage-engine=pbxt --suite=pbxt --retry=1 --m[1@aRperl mysql-test-run.pl --mysqld=--default-storage-engine=pbxt --suite=pbxt --retry=1 --[1@mEperl mysql-test-run.pl --mysqld=--default-storage-engine=pbxt --suite=pbxt --retry=1 -[1@-Aperl mysql-test-run.pl --mysqld=--default-storage-engine=pbxt --suite=pbxt --retry=1 [1@-Dperl mysql-test-run.pl --mysqld=--default-storage-engine=pbxt --suite=pbxt --retry=1[1@ =perl mysql-test-run.pl --mysqld=--default-storage-engine=pbxt --suite=pbxt --retry=[1@14perl mysql-test-run.pl --mysqld=--default-storage-engine=pbxt --suite=pbxt --retry[1@= perl mysql-test-run.pl --mysqld=--default-storage-engine=pbxt --suite=pbxt --retr[1@y





Logging: mysql-test-run.pl  --mysqld=--default-storage-engine=pbxt --suite=pbxt --retry=1 --max-test-fail=0 --force

MySQL Version 5.1.32

Using default engine 'pbxt'

Checking supported features...

 - skipping ndbcluster, mysqld not compiled with ndbcluster

 - skipping SSL

 - binaries are debug compiled

Collecting tests...

vardir: /home/knielsen/devel/maria/my/maria-pbxt/mysql-test/var

Checking leftover processes...

Removing old var directory...

Creating var directory '/home/knielsen/devel/maria/my/maria-pbxt/mysql-test/var'...

Installing system database...

Using server port 38380

worker[1] Using MTR_BUILD_THREAD 4, with reserved ports 10040..10049



==============================================================================



TEST                                      RESULT   TIME (ms)

------------------------------------------------------------



pbxt.alias                               [ pass ]    568

pbxt.alter_table                         [ pass ]  10930

pbxt.analyze                             [ pass ]    639

pbxt.ansi                                [ pass ]    483

pbxt.auto_increment                      [ pass ]   4424

pbxt.bench_count_distinct                [ pass ]   1459

pbxt.bigint                              [ pass ]   1136

pbxt.binary                              [ pass ]   1489

pbxt.bool                                [ pass ]    484

pbxt.bulk_replace                        [ pass ]    423

pbxt.case                                [ pass ]    627

pbxt.cast                                [ pass ]    693

pbxt.check                               [ pass ]  17179

pbxt.client_xml                          [ pass ]    868

pbxt.comments                            [ pass ]      9

pbxt.compare                             [ pass ]    516

pbxt.connect                             [ pass ]   5577

pbxt.constraints                         [ pass ]    643

pbxt.contributors                        [ pass ]      1

pbxt.count_distinct                      [ pass ]   1126

pbxt.count_distinct2                     [ pass ]  19475

pbxt.count_distinct3                     [ pass ]  87243

pbxt.create                              [ pass ]   3779

pbxt.date_formats                        [ pass ]    775

pbxt.default                             [ pass ]    538

pbxt.delete                              [ pass ]    941

pbxt.derived                             [ pass ]  17188

pbxt.dirty_close                         [ pass ]    602

pbxt.distinct                            [ pass ]   2857

pbxt.drop                                [ pass ]    810

pbxt.empty_table                         [ pass ]    481

pbxt.errors                              [ pass ]    487

pbxt.explain                             [ pass ]    544

pbxt.flush                               [ pass ]   4543

pbxt.flush_read_lock_kill                [ pass ]   2426

pbxt.flush_table                         [ pass ]   6665

pbxt.foreign_key                         [ pass ]    608

pbxt.func_concat                         [ pass ]    517

pbxt.func_crypt                          [ pass ]    476

pbxt.func_date_add                       [ pass ]    518

pbxt.func_default                        [ pass ]    488

pbxt.func_equal                          [ pass ]    512

pbxt.func_gconcat                        [ pass ]   2996

pbxt.func_group                          [ pass ]   4495

pbxt.func_if                             [ pass ]   1064

pbxt.func_in                             [ pass ]  14332

pbxt.func_isnull                         [ pass ]    473

pbxt.func_like                           [ pass ]    769

pbxt.func_math                           [ pass ]    590

pbxt.func_misc                           [ pass ]  12841

pbxt.func_op                             [ pass ]    485

pbxt.func_regexp                         [ pass ]   1188

pbxt.func_sapdb                          [ pass ]    838

pbxt.func_set                            [ pass ]   1649

pbxt.func_str                            [ pass ]   2876

pbxt.func_system                         [ pass ]    656

pbxt.func_timestamp                      [ pass ]    461

pbxt.gcc296                              [ pass ]     11

pbxt.grant                               [ pass ]   1825

pbxt.grant_cache                         [ pass ]    619

pbxt.greedy_optimizer                    [ pass ]    930

pbxt.group_by                            [ pass ]   2977

pbxt.group_min_max                       [ pass ]   4352

pbxt.having                              [ pass ]   1865

pbxt.heap                                [ pass ]   1710

pbxt.heap_auto_increment                 [ pass ]     32

pbxt.heap_btree                          [ pass ]    248

pbxt.heap_hash                           [ pass ]    712

pbxt.help                                [ pass ]    561

pbxt.insert                              [ pass ]   6400

pbxt.insert_select                       [ pass ]   1080

pbxt.insert_update                       [ pass ]    731

pbxt.join                                [ pass ]   2102

pbxt.join_crash                          [ pass ]     54

pbxt.join_nested                         [ pass ]   2500

pbxt.join_outer                          [ pass ]   2928

pbxt.key                                 [ pass ]   2037

pbxt.key_cache                           [ pass ]    787

pbxt.key_diff                            [ pass ]   1008

pbxt.key_primary                         [ pass ]    474

pbxt.keywords                            [ pass ]    481

pbxt.limit                               [ pass ]    595

pbxt.lock                                [ pass ]    834

pbxt.lock_multi                          [ pass ]  24898

pbxt.lowercase_table_grant               [ fail ]

        Test ended at 2009-04-07 12:04:42



CURRENT_TEST: pbxt.lowercase_table_grant

--- /home/knielsen/devel/maria/my/maria-pbxt/mysql-test/suite/pbxt/r/lowercase_table_grant.result	2009-04-06 13:33:10.000000000 +0300

+++ /home/knielsen/devel/maria/my/maria-pbxt/mysql-test/suite/pbxt/r/lowercase_table_grant.reject	2009-04-07 13:04:42.000000000 +0300

@@ -4,19 +4,19 @@

 show grants for mysqltest_1@localhost;

 Grants for mysqltest_1@localhost

 GRANT USAGE ON *.* TO 'mysqltest_1'@'localhost'

-GRANT ALL PRIVILEGES ON `mysqltest`.* TO 'mysqltest_1'@'localhost'

+GRANT ALL PRIVILEGES ON `MySQLtest`.* TO 'mysqltest_1'@'localhost'

 select * from db where user = 'mysqltest_1';

 Host	Db	User	Select_priv	Insert_priv	Update_priv	Delete_priv	Create_priv	Drop_priv	Grant_priv	References_priv	Index_priv	Alter_priv	Create_tmp_table_priv	Lock_tables_priv	Create_view_priv	Show_view_priv	Create_routine_priv	Alter_routine_priv	Execute_priv	Event_priv	Trigger_priv

-localhost	mysqltest	mysqltest_1	Y	Y	Y	Y	Y	Y	N	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y

+localhost	MySQLtest	mysqltest_1	Y	Y	Y	Y	Y	Y	N	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y

 update db set db = 'MYSQLtest' where db = 'mysqltest' and user = 'mysqltest_1' and host = 'localhost';

 flush privileges;

 show grants for mysqltest_1@localhost;

 Grants for mysqltest_1@localhost

 GRANT USAGE ON *.* TO 'mysqltest_1'@'localhost'

-GRANT ALL PRIVILEGES ON `mysqltest`.* TO 'mysqltest_1'@'localhost'

+GRANT ALL PRIVILEGES ON `MySQLtest`.* TO 'mysqltest_1'@'localhost'

 select * from db where user = 'mysqltest_1';

 Host	Db	User	Select_priv	Insert_priv	Update_priv	Delete_priv	Create_priv	Drop_priv	Grant_priv	References_priv	Index_priv	Alter_priv	Create_tmp_table_priv	Lock_tables_priv	Create_view_priv	Show_view_priv	Create_routine_priv	Alter_routine_priv	Execute_priv	Event_priv	Trigger_priv

-localhost	MYSQLtest	mysqltest_1	Y	Y	Y	Y	Y	Y	N	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y

+localhost	MySQLtest	mysqltest_1	Y	Y	Y	Y	Y	Y	N	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y

 delete from db where db = 'MYSQLtest' and user = 'mysqltest_1' and host = 'localhost';

 flush privileges;

 drop user mysqltest_1@localhost;



mysqltest: Result content mismatch



 - saving '/home/knielsen/devel/maria/my/maria-pbxt/mysql-test/var/log/pbxt.lowercase_table_grant/' to '/home/knielsen/devel/maria/my/maria-pbxt/mysql-test/var/log/pbxt.lowercase_table_grant/'

pbxt.lowercase_table_qcache              [ fail ]

        Test ended at 2009-04-07 12:04:44



CURRENT_TEST: pbxt.lowercase_table_qcache

mysqltest: At line 15: query 'drop database mysqltest' failed: 1008: Can't drop database 'mysqltest'; database doesn't exist



The result from queries just before the failure was:

set GLOBAL query_cache_size=1355776;

drop database if exists MySQLtesT;

create database MySQLtesT;

create table MySQLtesT.t1 (a int);

select * from MySQLtesT.t1;

a

show status like "Qcache_queries_in_cache";

Variable_name	Value

Qcache_queries_in_cache	1



 - saving '/home/knielsen/devel/maria/my/maria-pbxt/mysql-test/var/log/pbxt.lowercase_table_qcache/' to '/home/knielsen/devel/maria/my/maria-pbxt/mysql-test/var/log/pbxt.lowercase_table_qcache/'

pbxt.lowercase_view                      [ fail ]

        Test ended at 2009-04-07 12:04:45



CURRENT_TEST: pbxt.lowercase_view

mysqltest: At line 13: query 'create view ViE as select * from TAb' failed: 1146: Table 'MySQLTest.TAb' doesn't exist



The result from queries just before the failure was:

drop table if exists t1Aa,t2Aa,v1Aa,v2Aa;

drop view if exists t1Aa,t2Aa,v1Aa,v2Aa;

drop database if exists MySQLTest;

create database MySQLTest;

use MySQLTest;

create table TaB (Field int);



 - saving '/home/knielsen/devel/maria/my/maria-pbxt/mysql-test/var/log/pbxt.lowercase_view/' to '/home/knielsen/devel/maria/my/maria-pbxt/mysql-test/var/log/pbxt.lowercase_view/'

pbxt.metadata                            [ pass ]    622

pbxt.multi_statement                     [ pass ]    576

pbxt.multi_update                        [ pass ]  96440

pbxt.mysql_protocols                     [ pass ]    133

pbxt.mysqlshow                           [ pass ]    892

pbxt.mysqlslap                           [ pass ]  42133

pbxt.negation_elimination                [ pass ]    578

pbxt.null                                [ pass ]    964

pbxt.null_key                            [ pass ]   1254

pbxt.odbc                                [ pass ]    603

pbxt.olap                                [ pass ]   1564

pbxt.order_by                            [ pass ]   3086

pbxt.order_fill_sortbuf                  [ pass ]   5426

pbxt.overflow                            [ pass ]     15

pbxt.partition_charset                   [ pass ]    671

pbxt.partition_error                     [ pass ]    556

pbxt.partition_grant                     [ pass ]   1171

pbxt.partition_hash                      [ pass ]    909

pbxt.partition_list                      [ pass ]   1825

pbxt.partition_order                     [ pass ]   6756

pbxt.partition_pruning                   [ pass ]  65172

pbxt.partition_range                     [ pass ]  12475

pbxt.pbxt_assertions                     [ pass ]    645

pbxt.pbxt_bugs                           [ fail ]

        Test ended at 2009-04-07 12:09:04



CURRENT_TEST: pbxt.pbxt_bugs

mysqltest: At line 924: query 'LOAD DATA LOCAL INFILE 'suite/pbxt/t/load_unique_error1.inc' REPLACE INTO TABLE t1 FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (@c1,c2) SET c1 = @c1 % 2' failed: 2: File 'suite/pbxt/t/load_unique_error1.inc' not found (Errcode: 2)



The result from queries just before the failure was:

< snip >

SELECT c1 FROM t2;

c1

-2147483648

-2147483648

-2147483648

-2147483648

-2147483648

-2147483648

-2147483648

-2147483648

-2147483648

-2147483648

-2147483648

-2147483648

-2147483648

-3

10

2147483647

DROP TABLE IF EXISTS t1;

CREATE TABLE t1 (c1 INTEGER NOT NULL PRIMARY KEY, c2 VARCHAR(255));



More results from queries before failure can be found in /home/knielsen/devel/maria/my/maria-pbxt/mysql-test/var/log/pbxt_bugs.log



 - saving '/home/knielsen/devel/maria/my/maria-pbxt/mysql-test/var/log/pbxt.pbxt_bugs/' to '/home/knielsen/devel/maria/my/maria-pbxt/mysql-test/var/log/pbxt.pbxt_bugs/'

pbxt.pbxt_locking                        [ pass ]   3768

pbxt.pbxt_my_fail2                       [ pass ]    508

pbxt.pbxt_ref_int                        [ pass ]   2685

pbxt.pbxt_transactions                   [ pass ]   6459

pbxt.pbxt_updates                        [ pass ]    637

pbxt.perror                              [ pass ]     22

pbxt.preload                             [ pass ]   1668

pbxt.ps_10nestset                        [ pass ]   1128

pbxt.ps_11bugs                           [ pass ]    733

pbxt.ps_1general                         [ pass ]   2865

pbxt.ps_grant                            [ pass ]     54

pbxt.range                               [ pass ]   3107

pbxt.read_only                           [ pass ]   5471

pbxt.rename                              [ pass ]   1032

pbxt.renamedb                            [ pass ]     10

pbxt.replace                             [ pass ]    572

pbxt.rollback                            [ pass ]     18

pbxt.schema                              [ pass ]     11

pbxt.select                              [ pass ]  23776

pbxt.select_found                        [ pass ]    881

pbxt.select_safe                         [ pass ]    601

pbxt.skip_grants                         [ pass ]    769

pbxt.skip_name_resolve                   [ pass ]      8

pbxt.sql_mode                            [ pass ]    681

pbxt.status                              [ pass ]   1087

pbxt.subselect                           [ pass ]  74544

pbxt.sum_distinct                        [ pass ]   1318

pbxt.temp_table                          [ pass ]   1092

pbxt.truncate                            [ pass ]    623

pbxt.type_binary                         [ pass ]    925

pbxt.type_bit                            [ pass ]   1651

pbxt.type_date                           [ pass ]    875

pbxt.type_datetime                       [ pass ]    839

pbxt.type_decimal                        [ pass ]   1510

pbxt.type_enum                           [ pass ]   3115

pbxt.type_float                          [ pass ]   1247

pbxt.type_nchar                          [ pass ]    553

pbxt.type_newdecimal                     [ pass ]   1830

pbxt.type_ranges                         [ pass ]   1287

pbxt.type_set                            [ pass ]    568

pbxt.type_time                           [ pass ]    470

pbxt.type_timestamp                      [ pass ]   1737

pbxt.type_uint                           [ pass ]    446

pbxt.type_year                           [ pass ]    542

pbxt.udf                                 [ fail ]

        Test ended at 2009-04-07 12:11:59



CURRENT_TEST: pbxt.udf

mysqltest: At line 18: query 'CREATE FUNCTION metaphon RETURNS STRING SONAME "$UDF_EXAMPLE_LIB"' failed: 1126: Can't open shared library 'udf_example.so' (errno: 22 (null))



The result from queries just before the failure was:

drop table if exists t1;



 - saving '/home/knielsen/devel/maria/my/maria-pbxt/mysql-test/var/log/pbxt.udf/' to '/home/knielsen/devel/maria/my/maria-pbxt/mysql-test/var/log/pbxt.udf/'

pbxt.union                               [ pass ]   4344

pbxt.update                              [ pass ]   1556

pbxt.user_var                            [ pass ]    896

pbxt.view_grant                          [ pass ]   2588

pbxt.view_query_cache                    [ pass ]    809

pbxt.xml                                 [ pass ]    328

pbxt.consistent_snapshot                 [ pass ]     64

pbxt.endspace                            [ pass ]    733

pbxt.lock_tables_lost_commit             [ pass ]     25

pbxt.lowercase_table2                    [ skipped ]  Test requires: 'lowercase2'

mysql-test-run: *** ERROR: Test suite failure.

]0;knielsen@loke: ~/devel/maria/my/maria-pbxtknielsen@loke:~/devel/maria/my/maria-pbxt$ exit


Script done on 2009-04-07T12:43:35 CEST

Follow ups

References