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