[Maria-discuss] Test failures in my build of MariaDB 10.5.4
I am building MariaDB 10.5.4 from source with the cmake options shown below. I am running mtr with --skip-test-list=unstable-tests, but still seeing multiple failures: Failing test(s): csv.read_only main.flush_logs_not_windows main.mysqld--help perfschema.bad_option unit.conc_charset I can copy and paste many sections of the stdout.log and specific files, but wanted to ask if this is the right forum to pursue these. These seem pretty core (main.mysqld--help, which reported ‘mysqltest: Result length mismatch‘ after a small unified diff output showing only some numeric value differing), so I’m not sure why I would be getting these. Thanks. Guidance appreciated. - Chris Cmake I used to build: cmake -DBUILD_CONFIG=mysql_release -DAWS_SDK_EXTERNAL_PROJECT=OFF -DCMAKE_INSTALL_PREFIX:PATH=/usr \ -DINSTALL_LAYOUT=RPM -DINSTALL_PLUGINDIR=lib64/plugin -DINSTALL_SYSCONFDIR="" -DINSTALL_MYSQLTESTDIR="" \ -DWITH_EMBEDDED_SERVER=NO -DWITH_JEMALLOC=OFF -DWITH_PCRE=auto -DWITH_SSL=system -DWITH_ZLIB=system \ -DWITH_WSREP=OFF -DPLUGIN_WSREP_INFO=NO -DPLUGIN_AUTH_TEST_PLUGIN=NO -DPLUGIN_FUNC_TEST=NO \ -DPLUGIN_TYPE_TEST=NO -DPLUGIN_TEST_SQL_DISCOVERY=NO -DPLUGIN_TEST_VERSIONING=NO -DPLUGIN_BLACKHOLE=NO \ -DPLUGIN_CONNECT=NO -DPLUGIN_EXAMPLE=NO -DPLUGIN_EXAMPLE_KEY_MANAGEMENT=NO -DPLUGIN_FTEXAMPLE=NO \ -DPLUGIN_FEDERATED=NO -DPLUGIN_FEDERATEDX=NO -DPLUGIN_MROONGA=NO -DMRN_GROONGA_EMBED=OFF -DPLUGIN_S3=NO \ -DPLUGIN_SPIDER=NO -DPLUGIN_SPHINX=NO -DPLUGIN_TOKUDB=NO -DPLUGIN_ROCKSDB=NO -DCMAKE_BUILD_TYPE=Debug
Hi, Chris! Yes, it's the correct forum. maria-developers@lists.launchpad.net would be an even better match, but this is good enough, no need to repost. And, yes, please post relevant parts of the log, including diffs. On Aug 06, Chris Ross (cross2) wrote:
I am building MariaDB 10.5.4 from source with the cmake options shown below. I am running mtr with --skip-test-list=unstable-tests, but still seeing multiple failures:
Failing test(s): csv.read_only main.flush_logs_not_windows main.mysqld--help perfschema.bad_option unit.conc_charset
I can copy and paste many sections of the stdout.log and specific files, but wanted to ask if this is the right forum to pursue these. These seem pretty core (main.mysqld--help, which reported ‘mysqltest: Result length mismatch‘ after a small unified diff output showing only some numeric value differing), so I’m not sure why I would be getting these.
Thanks. Guidance appreciated.
- Chris
Cmake I used to build:
cmake -DBUILD_CONFIG=mysql_release -DAWS_SDK_EXTERNAL_PROJECT=OFF -DCMAKE_INSTALL_PREFIX:PATH=/usr \ -DINSTALL_LAYOUT=RPM -DINSTALL_PLUGINDIR=lib64/plugin -DINSTALL_SYSCONFDIR="" -DINSTALL_MYSQLTESTDIR="" \ -DWITH_EMBEDDED_SERVER=NO -DWITH_JEMALLOC=OFF -DWITH_PCRE=auto -DWITH_SSL=system -DWITH_ZLIB=system \ -DWITH_WSREP=OFF -DPLUGIN_WSREP_INFO=NO -DPLUGIN_AUTH_TEST_PLUGIN=NO -DPLUGIN_FUNC_TEST=NO \ -DPLUGIN_TYPE_TEST=NO -DPLUGIN_TEST_SQL_DISCOVERY=NO -DPLUGIN_TEST_VERSIONING=NO -DPLUGIN_BLACKHOLE=NO \ -DPLUGIN_CONNECT=NO -DPLUGIN_EXAMPLE=NO -DPLUGIN_EXAMPLE_KEY_MANAGEMENT=NO -DPLUGIN_FTEXAMPLE=NO \ -DPLUGIN_FEDERATED=NO -DPLUGIN_FEDERATEDX=NO -DPLUGIN_MROONGA=NO -DMRN_GROONGA_EMBED=OFF -DPLUGIN_S3=NO \ -DPLUGIN_SPIDER=NO -DPLUGIN_SPHINX=NO -DPLUGIN_TOKUDB=NO -DPLUGIN_ROCKSDB=NO -DCMAKE_BUILD_TYPE=Debug
Regards, Sergei VP of MariaDB Server Engineering and security@mariadb.org
Thanks Sergei. Attached is a trimmed version of the var/stdout.log from the recent mtr run. Let me know if there is other ancillary data for any of these tests that I can also provide. - Chris On 8/6/20, 13:04, "Sergei Golubchik" <serg@mariadb.org> wrote: Hi, Chris! Yes, it's the correct forum. maria-developers@lists.launchpad.net would be an even better match, but this is good enough, no need to repost. And, yes, please post relevant parts of the log, including diffs. On Aug 06, Chris Ross (cross2) wrote: > I am building MariaDB 10.5.4 from source with the cmake options shown > below. I am running mtr with --skip-test-list=unstable-tests, but > still seeing multiple failures: > > Failing test(s): csv.read_only main.flush_logs_not_windows > main.mysqld--help perfschema.bad_option unit.conc_charset > > I can copy and paste many sections of the stdout.log and specific > files, but wanted to ask if this is the right forum to pursue these. > These seem pretty core (main.mysqld--help, which reported ‘mysqltest: > Result length mismatch‘ after a small unified diff output showing only > some numeric value differing), so I’m not sure why I would be getting > these. > > Thanks. Guidance appreciated. > > - Chris > > Cmake I used to build: > > cmake -DBUILD_CONFIG=mysql_release -DAWS_SDK_EXTERNAL_PROJECT=OFF -DCMAKE_INSTALL_PREFIX:PATH=/usr \ > -DINSTALL_LAYOUT=RPM -DINSTALL_PLUGINDIR=lib64/plugin -DINSTALL_SYSCONFDIR="" -DINSTALL_MYSQLTESTDIR="" \ > -DWITH_EMBEDDED_SERVER=NO -DWITH_JEMALLOC=OFF -DWITH_PCRE=auto -DWITH_SSL=system -DWITH_ZLIB=system \ > -DWITH_WSREP=OFF -DPLUGIN_WSREP_INFO=NO -DPLUGIN_AUTH_TEST_PLUGIN=NO -DPLUGIN_FUNC_TEST=NO \ > -DPLUGIN_TYPE_TEST=NO -DPLUGIN_TEST_SQL_DISCOVERY=NO -DPLUGIN_TEST_VERSIONING=NO -DPLUGIN_BLACKHOLE=NO \ > -DPLUGIN_CONNECT=NO -DPLUGIN_EXAMPLE=NO -DPLUGIN_EXAMPLE_KEY_MANAGEMENT=NO -DPLUGIN_FTEXAMPLE=NO \ > -DPLUGIN_FEDERATED=NO -DPLUGIN_FEDERATEDX=NO -DPLUGIN_MROONGA=NO -DMRN_GROONGA_EMBED=OFF -DPLUGIN_S3=NO \ > -DPLUGIN_SPIDER=NO -DPLUGIN_SPHINX=NO -DPLUGIN_TOKUDB=NO -DPLUGIN_ROCKSDB=NO -DCMAKE_BUILD_TYPE=Debug Regards, Sergei VP of MariaDB Server Engineering and security@mariadb.org
Hi, Chris! On Aug 06, Chris Ross (cross2) wrote:
Thanks Sergei. Attached is a trimmed version of the var/stdout.log from the recent mtr run. Let me know if there is other ancillary data for any of these tests that I can also provide.
- Chris
Checking supported features... MariaDB Version 10.5.4-MariaDB-debug - SSL connections supported - binaries are debug compiled Using suites: main-,archive-,binlog-,binlog_encryption-,client-,csv-,compat/oracle-,compat/mssql-,encryption-,federated-,funcs_1-,funcs_2-,gcol-,handler-,heap-,innodb-,innodb_fts-,innodb_gis-,innodb_i_s-,innodb_zip-,json-,maria-,mariabackup-,multi_source-,optimizer_unfixed_bugs-,parts-,perfschema-,plugins-,roles-,rpl-,stress-,sys_vars-,sql_sequence-,unit-,vcol-,versioning-,period-,sequence,sql_discovery,disks,metadata_lock_info,query_response_time,type_inet,user_variables Collecting tests... Installing system database... worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019
==============================================================================
TEST RESULT TIME (ms) or COMMENT --------------------------------------------------------------------------
csv.read_only [ fail ] Test ended at 2020-08-06 03:50:10
CURRENT_TEST: csv.read_only --- /Volume/home/admin/mariadb-10.5.4/mysql-test/suite/csv/read_only.result 2020-06-23 15:10:16.000000000 +0000 +++ /Volume/home/admin/mariadb-10.5.4/mysql-test/suite/csv/read_only.reject 2020-08-06 03:50:10.317359127 +0000 @@ -6,27 +6,23 @@ TABLE_SCHEMA test TABLE_NAME t1 TABLE_TYPE BASE TABLE -ENGINE NULL -VERSION NULL -ROW_FORMAT NULL -TABLE_ROWS NULL -AVG_ROW_LENGTH NULL -DATA_LENGTH NULL -MAX_DATA_LENGTH NULL -INDEX_LENGTH NULL -DATA_FREE NULL +ENGINE CSV +VERSION 10 +ROW_FORMAT Fixed +TABLE_ROWS 2 +AVG_ROW_LENGTH 0 +DATA_LENGTH 0 +MAX_DATA_LENGTH 0 +INDEX_LENGTH 0 +DATA_FREE 0
This test is doing chmod 0400 $datadir/test/t1.CSM; chmod 0400 $datadir/test/t1.CSV; and then tries to open the table (in RW mode). Normally this should fail, but not in your case. Are you using a filesystem that doesn't enforce file permissions?
main.fix_priv_tables [ pass ] 452 main.flush_logs_not_windows [ fail ] Test ended at 2020-08-06 03:52:29
CURRENT_TEST: main.flush_logs_not_windows mysqltest: At line 10: query 'flush logs' succeeded - should have failed with errno 1004...
same here. chmod u-w and and attempt to write.
The result from queries just before the failure was: flush logs;
- saving '/Volume/home/admin/mariadb-10.5.4/mysql-test/var/log/main.flush_logs_not_windows/' to '/Volume/home/admin/mariadb-10.5.4/mysql-test/var/log/main.flush_logs_not_windows/' main.flush_table [ pass ] 4057
[ ... ]
main.mysql_tzinfo_to_sql_symlink [ pass ] 45 main.mysqld--help 'unix' [ fail ] Test ended at 2020-08-06 03:54:43
CURRENT_TEST: main.mysqld--help --- /Volume/home/admin/mariadb-10.5.4/mysql-test/main/mysqld--help.result 2020-06-23 15:10:16.000000000 +0000 +++ /Volume/home/admin/mariadb-10.5.4/mysql-test/main/mysqld--help.reject 2020-08-06 03:54:43.067329670 +0000 @@ -1797,10 +1797,10 @@ sync-relay-log-info 10000 sysdate-is-now FALSE system-versioning-alter-history ERROR -table-cache 421 +table-cache 2000 table-definition-cache 400 -table-open-cache 421 -table-open-cache-instances 1 +table-open-cache 2000 +table-open-cache-instances 8
this happens if setrlimit(RLIMIT_NOFILE) fails to set the limit.
tc-heuristic-recover OFF tcp-keepalive-interval 0 tcp-keepalive-probes 0
mysqltest: Result length mismatch
I didn't look further, the environment looks sufficiently non-standard already. These tests, above, they are skipped on Windown and when run as a root user. But, apparently, it's not enough to cover your case. We can add more precondition checks to skip these tests as needed, but you'll have to tell us what those precondition checks should be :) Regards, Sergei VP of MariaDB Server Engineering and security@mariadb.org
participants (2)
-
Chris Ross (cross2) -
Sergei Golubchik