Re: [Maria-developers] MariaDB + PBXT

Paul McCullagh <paul.mccullagh@primebase.org> 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