innodb.innodb_defrag_stats_many_tables 'innodb' w1 [ fail ]

        Test ended at 2017-10-13 23:42:06

CURRENT_TEST: innodb.innodb_defrag_stats_many_tables

mysqltest: At line 51: query 'INSERT INTO t_$count VALUES (1), (2)' failed: 1114: The table 't_461' is full

The result from queries just before the failure was:

< snip >

SET @start_flush_log_at_trx_commit = @@global.innodb_flush_log_at_trx_commit;

SET @@global.innodb_flush_log_at_trx_commit=2;

SET @start_innodb_defragment_stats_accuracy = @@global.innodb_defragment_stats_accuracy;

SET @@global.innodb_defragment_stats_accuracy = 80;

CREATE TABLE t1 (a INT NOT NULL PRIMARY KEY AUTO_INCREMENT, b VARCHAR(256), KEY SECOND(a, b)) ENGINE=INNODB;

INSERT INTO t1 VALUES(1, REPEAT('A', 256));

INSERT INTO t1 (b) SELECT b from t1;

INSERT INTO t1 (b) SELECT b from t1;

INSERT INTO t1 (b) SELECT b from t1;

INSERT INTO t1 (b) SELECT b from t1;

INSERT INTO t1 (b) SELECT b from t1;

INSERT INTO t1 (b) SELECT b from t1;

INSERT INTO t1 (b) SELECT b from t1;

INSERT INTO t1 (b) SELECT b from t1;

INSERT INTO t1 (b) SELECT b from t1;

INSERT INTO t1 (b) SELECT b from t1;

INSERT INTO t1 (b) SELECT b from t1;

select stat_value > 0 from mysql.innodb_index_stats where table_name like '%t1%' and stat_name = 'n_page_split';

stat_value > 0

Create 505 table to overflow the table cache.

More results from queries before failure can be found in /mnt/buildbot/build/mariadb-10.2.10/mysql-test/var/1/log/innodb_defrag_stats_many_tables.log

 - skipping '/mnt/buildbot/build/mariadb-10.2.10/mysql-test/var/1/log/innodb.innodb_defrag_stats_many_tables-innodb/'

worker[1] > Restart  - not started