+ perl ./mysql-test-run.pl --parallel=auto --force --retry=1 --suite-timeout=900 --testcase-timeout=30 --mysqld=--binlog-format=mixed --force-restart --shutdown-timeout=60 --max-test-fail=5 --skip-ssl --big-test --mem --suite=spider,spider/bg --max-test-fail=999
Logging: ./mysql-test-run.pl  --parallel=auto --force --retry=1 --suite-timeout=900 --testcase-timeout=30 --mysqld=--binlog-format=mixed --force-restart --shutdown-timeout=60 --max-test-fail=5 --skip-ssl --big-test --mem --suite=spider,spider/bg --max-test-fail=999
Using binlog format 'mixed'
vardir: /builddir/build/BUILD/mariadb-10.3.13/mysql-test/var
Checking leftover processes...
Removing old var directory...
BUILDSTDERR: mysql-test-run: WARNING: Found non pid file 'mysqld.err' in '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/run'
BUILDSTDERR: mysql-test-run: WARNING: Found non pid file 'mytest.log' in '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/run'
Creating var directory '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var'...
 - symlinking 'var' to '/dev/shm/var_32_Kvam'
Checking supported features...
MariaDB Version 10.3.13-MariaDB
 - skipping SSL
Using suites: spider,spider/bg
Collecting tests...
Installing system database...
Using parallel: 1
==============================================================================
TEST                                      RESULT   TIME (ms) or COMMENT
--------------------------------------------------------------------------
worker[1] Using MTR_BUILD_THREAD 32, with reserved ports 10640..10659
spider/bg.spider3_fixes                  [ fail ]
        Test ended at 2019-02-25 17:34:10
CURRENT_TEST: spider/bg.spider3_fixes
mysqltest: At line 162: query 'SELECT MAX(id) FROM t1' failed: 128: Out of memory (Needed 3062619176 bytes)
The result from queries just before the failure was:
< snip >
1
spider_bg_direct_sql('SET SESSION AUTO_INCREMENT_OFFSET = 2', '',
'srv "s_2_1"')
1
spider_bg_direct_sql('SET SESSION AUTO_INCREMENT_OFFSET = 3', '',
'srv "s_2_2"')
1
CREATE TABLE t1 (
id int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (id)
) SLAVE1_1_ENGINE SLAVE1_1_CHARSET SLAVE1_1_COMMENT_INCREMENT1_1
CREATE TABLE t2 (
id int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (id)
) SLAVE1_1_ENGINE SLAVE1_1_CHARSET SLAVE1_1_COMMENT_INCREMENT1_1
INSERT INTO t1 () VALUES ();
SELECT LAST_INSERT_ID();
LAST_INSERT_ID()
777
SELECT MAX(id) FROM t1;
More results from queries before failure can be found in /builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider3_fixes.log
 - saving '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider/bg.spider3_fixes/' to '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/bg.spider3_fixes/'
***Warnings generated in error logs during shutdown after running tests: spider/bg.spider3_fixes
2019-02-25 17:34:09 33 [ERROR] mysqld: Out of memory (Needed 3062619176 bytes)
spider/bg.spider3_fixes_part             [ fail ]
        Test ended at 2019-02-25 17:34:12
CURRENT_TEST: spider/bg.spider3_fixes_part
mysqltest: At line 196: query 'SELECT MAX(id) FROM t1' failed: 128: Out of memory (Needed 3062803496 bytes)
The result from queries just before the failure was:
< snip >
1
spider_bg_direct_sql('SET SESSION AUTO_INCREMENT_OFFSET = 2', '',
'srv "s_2_1"')
1
spider_bg_direct_sql('SET SESSION AUTO_INCREMENT_OFFSET = 3', '',
'srv "s_2_2"')
1
CREATE TABLE t1 (
id int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (id)
) SLAVE1_1_ENGINE SLAVE1_1_CHARSET SLAVE1_1_COMMENT_INCREMENT1_P_1
CREATE TABLE t2 (
id int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (id)
) SLAVE1_1_ENGINE SLAVE1_1_CHARSET SLAVE1_1_COMMENT_INCREMENT1_P_1
INSERT INTO t1 () VALUES ();
SELECT LAST_INSERT_ID();
LAST_INSERT_ID()
777
SELECT MAX(id) FROM t1;
More results from queries before failure can be found in /builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider3_fixes_part.log
 - saving '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider/bg.spider3_fixes_part/' to '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/bg.spider3_fixes_part/'
***Warnings generated in error logs during shutdown after running tests: spider/bg.spider3_fixes_part
2019-02-25 17:34:12 34 [ERROR] mysqld: Out of memory (Needed 3062803496 bytes)
spider/bg.spider_fixes                   [ fail ]
        Test ended at 2019-02-25 17:34:14
CURRENT_TEST: spider/bg.spider_fixes
mysqltest: At line 155: query 'SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l
WHERE a < 5 ORDER BY a DESC LIMIT 3' failed: 128: Out of memory (Needed 3062737968 bytes)
The result from queries just before the failure was:
< snip >
c DATETIME,
PRIMARY KEY(a)
) MASTER_1_ENGINE2 MASTER_1_CHARSET2
INSERT INTO tb_l (a, b, c) VALUES
(1, 'a', '2008-08-01 10:21:39'),
(2, 'b', '2000-01-01 00:00:00'),
(3, 'e', '2007-06-04 20:03:11'),
(4, 'd', '2003-11-30 05:01:03'),
(5, 'c', '2001-12-31 23:59:59');
DROP TABLE IF EXISTS ta_l;
CREATE TABLE ta_l (
PRIMARY KEY(a)
) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT_2_1
INSERT INTO ta_l SELECT a, b, c FROM tb_l;
2.13
select table with "order by desc" and "<"
connection master_1;
SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l
WHERE a < 5 ORDER BY a DESC LIMIT 3;
More results from queries before failure can be found in /builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider_fixes.log
Warnings from just before the error:
Error 128 Out of memory (Needed 3062737968 bytes)
 - saving '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider/bg.spider_fixes/' to '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/bg.spider_fixes/'
***Warnings generated in error logs during shutdown after running tests: spider/bg.spider_fixes
2019-02-25 17:34:14 33 [ERROR] mysqld: Out of memory (Needed 3062737968 bytes)
spider/bg.spider_fixes_part              [ fail ]
        Test ended at 2019-02-25 17:34:16
CURRENT_TEST: spider/bg.spider_fixes_part
mysqltest: At line 167: query 'SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l2 WHERE a > 1
ORDER BY a' failed: 128: Out of memory (Needed 3063102512 bytes)
The result from queries just before the failure was:
< snip >
) MASTER_1_ENGINE2 MASTER_1_CHARSET2
INSERT INTO tb_l (a, b, c) VALUES
(1, 'a', '2008-08-01 10:21:39'),
(2, 'b', '2000-01-01 00:00:00'),
(3, 'e', '2007-06-04 20:03:11'),
(4, 'd', '2003-11-30 05:01:03'),
(5, 'c', '2001-12-31 23:59:59');
2.17
partition with sort
connection master_1;
CREATE TABLE ta_l2 (
a INT,
b CHAR(1),
c DATETIME,
PRIMARY KEY(a)
) MASTER_1_ENGINE MASTER_1_COMMENT2_P_2_1
INSERT INTO ta_l2 SELECT a, b, c FROM tb_l;
SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l2 WHERE a > 1
ORDER BY a;
More results from queries before failure can be found in /builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider_fixes_part.log
 - saving '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider/bg.spider_fixes_part/' to '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/bg.spider_fixes_part/'
***Warnings generated in error logs during shutdown after running tests: spider/bg.spider_fixes_part
2019-02-25 17:34:16 33 [ERROR] mysqld: Out of memory (Needed 3063102512 bytes)
2019-02-25 17:34:16 34 [ERROR] mysqld: Out of memory (Needed 3063102512 bytes)
spider/bg.basic_sql                      [ fail ]
        Test ended at 2019-02-25 17:34:18
CURRENT_TEST: spider/bg.basic_sql
mysqltest: At line 159: query 'SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l ORDER BY a' failed: 128: Out of memory (Needed 3063061552 bytes)
The result from queries just before the failure was:
< snip >
DROP TABLE IF EXISTS tb_l;
CREATE TABLE tb_l (
a INT,
b CHAR(1),
c DATETIME,
PRIMARY KEY(a)
) MASTER_1_ENGINE2 MASTER_1_CHARSET2
INSERT INTO tb_l (a, b, c) VALUES
(1, 'a', '2008-08-01 10:21:39'),
(2, 'b', '2000-01-01 00:00:00'),
(3, 'e', '2007-06-04 20:03:11'),
(4, 'd', '2003-11-30 05:01:03'),
(5, 'c', '2001-12-31 23:59:59');
DROP TABLE IF EXISTS ta_l;
CREATE TABLE ta_l (
PRIMARY KEY(a)
) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT_2_1
SELECT a, b, c FROM tb_l
connection master_1;
SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l ORDER BY a;
More results from queries before failure can be found in /builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/basic_sql.log
Warnings from just before the error:
Error 128 Out of memory (Needed 3063061552 bytes)
 - saving '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider/bg.basic_sql/' to '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/bg.basic_sql/'
***Warnings generated in error logs during shutdown after running tests: spider/bg.basic_sql
2019-02-25 17:34:18 31 [ERROR] mysqld: Out of memory (Needed 3063061552 bytes)
spider/bg.basic_sql_part                 [ fail ]
        Test ended at 2019-02-25 17:34:21
CURRENT_TEST: spider/bg.basic_sql_part
mysqltest: At line 195: query 'SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l2 ORDER BY a' failed: 128: Out of memory (Needed 3063073840 bytes)
The result from queries just before the failure was:
< snip >
a INT,
b CHAR(1),
c DATETIME,
PRIMARY KEY(a)
) MASTER_1_ENGINE2 MASTER_1_CHARSET2
INSERT INTO tb_l (a, b, c) VALUES
(1, 'f', '2008-07-01 10:21:39'),
(2, 'g', '2000-02-01 00:00:00'),
(3, 'j', '2007-05-04 20:03:11'),
(4, 'i', '2003-10-30 05:01:03'),
(5, 'h', '2001-10-31 23:59:59');
create table with partition and select test
connection master_1;
CREATE TABLE ta_l2 (
PRIMARY KEY(a)
) MASTER_1_ENGINE MASTER_1_COMMENT_P_2_1
SELECT a, b, c FROM tb_l
connection master_1;
SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l2 ORDER BY a;
More results from queries before failure can be found in /builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/basic_sql_part.log
Warnings from just before the error:
Error 128 Out of memory (Needed 3063073840 bytes)
 - saving '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider/bg.basic_sql_part/' to '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/bg.basic_sql_part/'
***Warnings generated in error logs during shutdown after running tests: spider/bg.basic_sql_part
2019-02-25 17:34:20 31 [ERROR] mysqld: Out of memory (Needed 3063073840 bytes)
2019-02-25 17:34:20 10 [Warning] Sort aborted, host: localhost, user: root, thread: 10, query: SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l2 ORDER BY a
2019-02-25 17:34:20 32 [ERROR] mysqld: Out of memory (Needed 3063073840 bytes)
spider/bg.direct_aggregate               [ fail ]
        Test ended at 2019-02-25 17:34:23
CURRENT_TEST: spider/bg.direct_aggregate
mysqltest: At line 130: query 'SELECT COUNT(*) FROM ta_l' failed: 128: Out of memory (Needed 3062848552 bytes)
The result from queries just before the failure was:
< snip >
DROP TABLE IF EXISTS ta_l;
CREATE TABLE ta_l (
a INT,
b CHAR(1),
c DATETIME,
PRIMARY KEY(a)
) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT_2_1
INSERT INTO ta_l (a, b, c) VALUES
(1, 'a', '2008-08-01 10:21:39'),
(2, 'b', '2000-01-01 00:00:00'),
(3, 'e', '2007-06-04 20:03:11'),
(4, 'd', '2003-11-30 05:01:03'),
(5, 'c', '2001-12-31 23:59:59');
direct_aggregating test
connection master_1;
SHOW STATUS LIKE 'Spider_direct_aggregate';
Variable_name	Value
Spider_direct_aggregate	0
SELECT COUNT(*) FROM ta_l;
More results from queries before failure can be found in /builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/direct_aggregate.log
Warnings from just before the error:
Error 128 Out of memory (Needed 3062848552 bytes)
 - saving '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider/bg.direct_aggregate/' to '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/bg.direct_aggregate/'
***Warnings generated in error logs during shutdown after running tests: spider/bg.direct_aggregate
2019-02-25 17:34:22 31 [ERROR] mysqld: Out of memory (Needed 3062848552 bytes)
spider/bg.direct_aggregate_part          [ fail ]
        Test ended at 2019-02-25 17:34:26
CURRENT_TEST: spider/bg.direct_aggregate_part
mysqltest: At line 136: query 'SELECT COUNT(*) FROM ta_l2' failed: 128: Out of memory (Needed 3062631464 bytes)
The result from queries just before the failure was:
< snip >
USE auto_test_remote2;
test select 1
connection master_1;
SELECT 1;
1
1
with partition test
connection master_1;
CREATE TABLE ta_l2 (
a INT,
b CHAR(1),
c DATETIME,
PRIMARY KEY(a)
) MASTER_1_ENGINE MASTER_1_COMMENT2_P_2_1
SHOW STATUS LIKE 'Spider_direct_aggregate';
Variable_name	Value
Spider_direct_aggregate	0
SELECT COUNT(*) FROM ta_l2;
More results from queries before failure can be found in /builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/direct_aggregate_part.log
 - saving '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider/bg.direct_aggregate_part/' to '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/bg.direct_aggregate_part/'
***Warnings generated in error logs during shutdown after running tests: spider/bg.direct_aggregate_part
2019-02-25 17:34:25 31 [ERROR] mysqld: Out of memory (Needed 3062631464 bytes)
2019-02-25 17:34:25 10 [ERROR] Got error 128 when reading table './auto_test_local/ta_l2'
2019-02-25 17:34:25 32 [ERROR] mysqld: Out of memory (Needed 3062631464 bytes)
spider/bg.direct_update                  [ fail ]
        Test ended at 2019-02-25 17:34:28
CURRENT_TEST: spider/bg.direct_update
mysqltest: At line 130: query 'SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l ORDER BY a' failed: 128: Out of memory (Needed 3062983728 bytes)
The result from queries just before the failure was:
< snip >
DROP TABLE IF EXISTS ta_l;
CREATE TABLE ta_l (
a INT,
b CHAR(1),
c DATETIME,
PRIMARY KEY(a)
) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT_2_1
INSERT INTO ta_l (a, b, c) VALUES
(1, 'a', '2008-08-01 10:21:39'),
(2, 'b', '2000-01-01 00:00:00'),
(3, 'e', '2007-06-04 20:03:11'),
(4, 'd', '2003-11-30 05:01:03'),
(5, 'c', '2001-12-31 23:59:59');
direct_updating test
connection master_1;
SHOW STATUS LIKE 'Spider_direct_update';
Variable_name	Value
Spider_direct_update	0
SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l ORDER BY a;
More results from queries before failure can be found in /builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/direct_update.log
Warnings from just before the error:
Error 128 Out of memory (Needed 3062983728 bytes)
 - saving '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider/bg.direct_update/' to '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/bg.direct_update/'
***Warnings generated in error logs during shutdown after running tests: spider/bg.direct_update
2019-02-25 17:34:27 31 [ERROR] mysqld: Out of memory (Needed 3062983728 bytes)
spider/bg.direct_update_part             [ fail ]
        Test ended at 2019-02-25 17:34:31
CURRENT_TEST: spider/bg.direct_update_part
mysqltest: At line 136: query 'SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l2 ORDER BY a' failed: 128: Out of memory (Needed 3062672432 bytes)
The result from queries just before the failure was:
< snip >
USE auto_test_remote2;
test select 1
connection master_1;
SELECT 1;
1
1
with partition test
connection master_1;
CREATE TABLE ta_l2 (
a INT,
b CHAR(1),
c DATETIME,
PRIMARY KEY(a)
) MASTER_1_ENGINE MASTER_1_COMMENT2_P_2_1
SHOW STATUS LIKE 'Spider_direct_update';
Variable_name	Value
Spider_direct_update	0
SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l2 ORDER BY a;
More results from queries before failure can be found in /builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/direct_update_part.log
Warnings from just before the error:
Error 128 Out of memory (Needed 3062672432 bytes)
 - saving '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider/bg.direct_update_part/' to '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/bg.direct_update_part/'
***Warnings generated in error logs during shutdown after running tests: spider/bg.direct_update_part
2019-02-25 17:34:30 31 [ERROR] mysqld: Out of memory (Needed 3062672432 bytes)
2019-02-25 17:34:30 10 [Warning] Sort aborted, host: localhost, user: root, thread: 10, query: SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l2 ORDER BY a
2019-02-25 17:34:30 32 [ERROR] mysqld: Out of memory (Needed 3062672432 bytes)
spider/bg.function                       [ fail ]
        Test ended at 2019-02-25 17:34:33
CURRENT_TEST: spider/bg.function
mysqltest: At line 87: query 'insert into t1 select a + 1 from t1' failed: 5: Out of memory (Needed 3062922280 bytes)
The result from queries just before the failure was:
< snip >
USE auto_test_remote;
connection child2_2;
DROP DATABASE IF EXISTS auto_test_remote2;
CREATE DATABASE auto_test_remote2;
USE auto_test_remote2;
test select 1
connection master_1;
SELECT 1;
1
1
in()
connection master_1;
CREATE TABLE t1 (
a VARCHAR(255),
PRIMARY KEY(a)
) MASTER_1_ENGINE MASTER_1_CHARSET3 MASTER_1_COMMENT_TEXT_PK1_1
insert into t1 values ('1');
insert into t1 select a + 1 from t1;
More results from queries before failure can be found in /builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/function.log
 - saving '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider/bg.function/' to '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/bg.function/'
***Warnings generated in error logs during shutdown after running tests: spider/bg.function
2019-02-25 17:34:32 10 [ERROR] mysqld: Out of memory (Needed 3062922280 bytes)
spider/bg.ha                             [ fail ]
        Test ended at 2019-02-25 17:34:36
CURRENT_TEST: spider/bg.ha
mysqltest: At line 225: query 'SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l ORDER BY a' failed: 128: Out of memory (Needed 3062910000 bytes)
The result from queries just before the failure was:
< snip >
create table test
connection master_1;
DROP TABLE IF EXISTS ta_l;
CREATE TABLE ta_l (
a INT,
b CHAR(1),
c DATETIME,
PRIMARY KEY(a)
) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT_HA_2_1
INSERT INTO ta_l (a, b, c) VALUES
(1, 'a', '2008-08-01 10:21:39'),
(2, 'b', '2000-01-01 00:00:00'),
(3, 'e', '2007-06-04 20:03:11'),
(4, 'd', '2003-11-30 05:01:03'),
(5, 'c', '2001-12-31 23:59:59');
select test
connection master_1;
SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l ORDER BY a;
More results from queries before failure can be found in /builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/ha.log
Warnings from just before the error:
Error 128 Out of memory (Needed 3062910000 bytes)
 - saving '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider/bg.ha/' to '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/bg.ha/'
***Warnings generated in error logs during shutdown after running tests: spider/bg.ha
2019-02-25 17:34:35 31 [ERROR] mysqld: Out of memory (Needed 3062910000 bytes)
spider/bg.ha_part                        [ fail ]
        Test ended at 2019-02-25 17:34:39
CURRENT_TEST: spider/bg.ha_part
mysqltest: At line 266: query 'SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l2 ORDER BY a' failed: 128: Out of memory (Needed 3062508592 bytes)
The result from queries just before the failure was:
< snip >
create table with partition test
connection master_1;
DROP TABLE IF EXISTS ta_l2;
CREATE TABLE ta_l2 (
a INT,
b CHAR(1),
c DATETIME,
PRIMARY KEY(a)
) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT_HA_P_2_1
INSERT INTO ta_l2 (a, b, c) VALUES
(1, 'a', '2008-08-01 10:21:39'),
(2, 'b', '2000-01-01 00:00:00'),
(3, 'e', '2007-06-04 20:03:11'),
(4, 'd', '2003-11-30 05:01:03'),
(5, 'c', '2001-12-31 23:59:59');
select test
connection master_1;
SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l2 ORDER BY a;
More results from queries before failure can be found in /builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/ha_part.log
Warnings from just before the error:
Error 128 Out of memory (Needed 3062508592 bytes)
 - saving '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider/bg.ha_part/' to '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/bg.ha_part/'
***Warnings generated in error logs during shutdown after running tests: spider/bg.ha_part
2019-02-25 17:34:38 32 [ERROR] mysqld: Out of memory (Needed 3062508592 bytes)
2019-02-25 17:34:38 10 [Warning] Sort aborted, host: localhost, user: root, thread: 10, query: SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l2 ORDER BY a
2019-02-25 17:34:38 33 [ERROR] mysqld: Out of memory (Needed 3062508592 bytes)
spider/bg.vp_fixes                       [ pass ]    151
spider.spider3_fixes                     [ fail ]
        Test ended at 2019-02-25 17:34:46
CURRENT_TEST: spider.spider3_fixes
mysqltest: At line 162: query 'SELECT MAX(id) FROM t1' failed: 5: Out of memory (Needed 3062590504 bytes)
The result from queries just before the failure was:
< snip >
1
spider_bg_direct_sql('SET SESSION AUTO_INCREMENT_OFFSET = 2', '',
'srv "s_2_1"')
1
spider_bg_direct_sql('SET SESSION AUTO_INCREMENT_OFFSET = 3', '',
'srv "s_2_2"')
1
CREATE TABLE t1 (
id int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (id)
) SLAVE1_1_ENGINE SLAVE1_1_CHARSET SLAVE1_1_COMMENT_INCREMENT1_1
CREATE TABLE t2 (
id int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (id)
) SLAVE1_1_ENGINE SLAVE1_1_CHARSET SLAVE1_1_COMMENT_INCREMENT1_1
INSERT INTO t1 () VALUES ();
SELECT LAST_INSERT_ID();
LAST_INSERT_ID()
777
SELECT MAX(id) FROM t1;
More results from queries before failure can be found in /builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider3_fixes.log
 - saving '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider.spider3_fixes/' to '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider.spider3_fixes/'
***Warnings generated in error logs during shutdown after running tests: spider.spider3_fixes
2019-02-25 17:34:45 11 [ERROR] mysqld: Out of memory (Needed 3062590504 bytes)
spider.spider3_fixes_part                [ fail ]
        Test ended at 2019-02-25 17:34:49
CURRENT_TEST: spider.spider3_fixes_part
mysqltest: At line 196: query 'SELECT MAX(id) FROM t1' failed: 5: Out of memory (Needed 3062176808 bytes)
The result from queries just before the failure was:
< snip >
1
spider_bg_direct_sql('SET SESSION AUTO_INCREMENT_OFFSET = 2', '',
'srv "s_2_1"')
1
spider_bg_direct_sql('SET SESSION AUTO_INCREMENT_OFFSET = 3', '',
'srv "s_2_2"')
1
CREATE TABLE t1 (
id int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (id)
) SLAVE1_1_ENGINE SLAVE1_1_CHARSET SLAVE1_1_COMMENT_INCREMENT1_P_1
CREATE TABLE t2 (
id int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (id)
) SLAVE1_1_ENGINE SLAVE1_1_CHARSET SLAVE1_1_COMMENT_INCREMENT1_P_1
INSERT INTO t1 () VALUES ();
SELECT LAST_INSERT_ID();
LAST_INSERT_ID()
777
SELECT MAX(id) FROM t1;
More results from queries before failure can be found in /builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider3_fixes_part.log
 - saving '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider.spider3_fixes_part/' to '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider.spider3_fixes_part/'
***Warnings generated in error logs during shutdown after running tests: spider.spider3_fixes_part
2019-02-25 17:34:48 11 [ERROR] mysqld: Out of memory (Needed 3062176808 bytes)
spider.spider_fixes                      [ fail ]
        Test ended at 2019-02-25 17:34:52
CURRENT_TEST: spider.spider_fixes
mysqltest: At line 155: query 'SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l
WHERE a < 5 ORDER BY a DESC LIMIT 3' failed: 5: Out of memory (Needed 3062193200 bytes)
The result from queries just before the failure was:
< snip >
c DATETIME,
PRIMARY KEY(a)
) MASTER_1_ENGINE2 MASTER_1_CHARSET2
INSERT INTO tb_l (a, b, c) VALUES
(1, 'a', '2008-08-01 10:21:39'),
(2, 'b', '2000-01-01 00:00:00'),
(3, 'e', '2007-06-04 20:03:11'),
(4, 'd', '2003-11-30 05:01:03'),
(5, 'c', '2001-12-31 23:59:59');
DROP TABLE IF EXISTS ta_l;
CREATE TABLE ta_l (
PRIMARY KEY(a)
) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT_2_1
INSERT INTO ta_l SELECT a, b, c FROM tb_l;
2.13
select table with "order by desc" and "<"
connection master_1;
SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l
WHERE a < 5 ORDER BY a DESC LIMIT 3;
More results from queries before failure can be found in /builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider_fixes.log
 - saving '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider.spider_fixes/' to '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider.spider_fixes/'
***Warnings generated in error logs during shutdown after running tests: spider.spider_fixes
2019-02-25 17:34:50 11 [ERROR] mysqld: Out of memory (Needed 3062193200 bytes)
spider.spider_fixes_part                 [ fail ]
        Test ended at 2019-02-25 17:34:55
CURRENT_TEST: spider.spider_fixes_part
mysqltest: At line 167: query 'SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l2 WHERE a > 1
ORDER BY a' failed: 5: Out of memory (Needed 3062885424 bytes)
The result from queries just before the failure was:
< snip >
) MASTER_1_ENGINE2 MASTER_1_CHARSET2
INSERT INTO tb_l (a, b, c) VALUES
(1, 'a', '2008-08-01 10:21:39'),
(2, 'b', '2000-01-01 00:00:00'),
(3, 'e', '2007-06-04 20:03:11'),
(4, 'd', '2003-11-30 05:01:03'),
(5, 'c', '2001-12-31 23:59:59');
2.17
partition with sort
connection master_1;
CREATE TABLE ta_l2 (
a INT,
b CHAR(1),
c DATETIME,
PRIMARY KEY(a)
) MASTER_1_ENGINE MASTER_1_COMMENT2_P_2_1
INSERT INTO ta_l2 SELECT a, b, c FROM tb_l;
SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l2 WHERE a > 1
ORDER BY a;
More results from queries before failure can be found in /builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider_fixes_part.log
 - saving '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider.spider_fixes_part/' to '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider.spider_fixes_part/'
***Warnings generated in error logs during shutdown after running tests: spider.spider_fixes_part
2019-02-25 17:34:53 11 [ERROR] mysqld: Out of memory (Needed 3062885424 bytes)
spider.auto_increment                    [ fail ]
        Test ended at 2019-02-25 17:34:58
CURRENT_TEST: spider.auto_increment
mysqltest: At line 98: query 'INSERT INTO tbl_a () VALUES ()' failed: 5: Out of memory (Needed 3062713384 bytes)
The result from queries just before the failure was:
< snip >
CHILD2_1_CREATE_TABLES
TRUNCATE TABLE mysql.general_log;
connection master_1;
DROP TABLE IF EXISTS tbl_a;
CREATE TABLE tbl_a (
col_a INT NOT NULL AUTO_INCREMENT,
col_b VARCHAR(20) DEFAULT 'defg',
col_c INT NOT NULL DEFAULT 100,
PRIMARY KEY(col_a)
) MASTER_1_ENGINE MASTER_1_AUTO_INCREMENT_2_1 MASTER_1_COMMENT_2_1
SHOW CREATE TABLE tbl_a;
Table	Create Table
tbl_a	CREATE TABLE `tbl_a` (
  `col_a` int(11) NOT NULL AUTO_INCREMENT,
  `col_b` varchar(20) DEFAULT 'defg',
  `col_c` int(11) NOT NULL DEFAULT 100,
  PRIMARY KEY (`col_a`)
) ENGINE=SPIDER AUTO_INCREMENT=20 DEFAULT CHARSET=latin1 COMMENT='database "auto_test_remote", table "tbl_a", srv "s_2_1", aim "0"'
INSERT INTO tbl_a () VALUES ();
INSERT INTO tbl_a () VALUES ();
More results from queries before failure can be found in /builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/auto_increment.log
 - saving '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider.auto_increment/' to '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider.auto_increment/'
***Warnings generated in error logs during shutdown after running tests: spider.auto_increment
2019-02-25 17:34:56 11 [ERROR] mysqld: Out of memory (Needed 3062713384 bytes)
spider.basic_sql                         [ fail ]
        Test ended at 2019-02-25 17:35:01
CURRENT_TEST: spider.basic_sql
mysqltest: At line 159: query 'SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l ORDER BY a' failed: 5: Out of memory (Needed 3063008304 bytes)
The result from queries just before the failure was:
< snip >
DROP TABLE IF EXISTS tb_l;
CREATE TABLE tb_l (
a INT,
b CHAR(1),
c DATETIME,
PRIMARY KEY(a)
) MASTER_1_ENGINE2 MASTER_1_CHARSET2
INSERT INTO tb_l (a, b, c) VALUES
(1, 'a', '2008-08-01 10:21:39'),
(2, 'b', '2000-01-01 00:00:00'),
(3, 'e', '2007-06-04 20:03:11'),
(4, 'd', '2003-11-30 05:01:03'),
(5, 'c', '2001-12-31 23:59:59');
DROP TABLE IF EXISTS ta_l;
CREATE TABLE ta_l (
PRIMARY KEY(a)
) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT_2_1
SELECT a, b, c FROM tb_l
connection master_1;
SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l ORDER BY a;
More results from queries before failure can be found in /builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/basic_sql.log
 - saving '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider.basic_sql/' to '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider.basic_sql/'
***Warnings generated in error logs during shutdown after running tests: spider.basic_sql
2019-02-25 17:35:00 11 [ERROR] mysqld: Out of memory (Needed 3063008304 bytes)
spider.basic_sql_part                    [ fail ]
        Test ended at 2019-02-25 17:35:04
CURRENT_TEST: spider.basic_sql_part
mysqltest: At line 195: query 'SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l2 ORDER BY a' failed: 5: Out of memory (Needed 3063077936 bytes)
The result from queries just before the failure was:
< snip >
a INT,
b CHAR(1),
c DATETIME,
PRIMARY KEY(a)
) MASTER_1_ENGINE2 MASTER_1_CHARSET2
INSERT INTO tb_l (a, b, c) VALUES
(1, 'f', '2008-07-01 10:21:39'),
(2, 'g', '2000-02-01 00:00:00'),
(3, 'j', '2007-05-04 20:03:11'),
(4, 'i', '2003-10-30 05:01:03'),
(5, 'h', '2001-10-31 23:59:59');
create table with partition and select test
connection master_1;
CREATE TABLE ta_l2 (
PRIMARY KEY(a)
) MASTER_1_ENGINE MASTER_1_COMMENT_P_2_1
SELECT a, b, c FROM tb_l
connection master_1;
SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l2 ORDER BY a;
More results from queries before failure can be found in /builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/basic_sql_part.log
 - saving '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider.basic_sql_part/' to '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider.basic_sql_part/'
***Warnings generated in error logs during shutdown after running tests: spider.basic_sql_part
2019-02-25 17:35:03 11 [ERROR] mysqld: Out of memory (Needed 3063077936 bytes)
2019-02-25 17:35:03 11 [Warning] Sort aborted, host: localhost, user: root, thread: 11, query: SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l2 ORDER BY a
spider.checksum_table_with_quick_mode_3  [ fail ]
        Test ended at 2019-02-25 17:35:07
CURRENT_TEST: spider.checksum_table_with_quick_mode_3
--- /builddir/build/BUILD/mariadb-10.3.13/storage/spider/mysql-test/spider/r/checksum_table_with_quick_mode_3.result	2019-02-20 07:59:13.000000000 +0000
+++ /builddir/build/BUILD/mariadb-10.3.13/storage/spider/mysql-test/spider/r/checksum_table_with_quick_mode_3.reject	2019-02-25 17:35:06.388739362 +0000
@@ -43,7 +43,7 @@
 connection master_1;
 CHECKSUM TABLE tbl_a EXTENDED;
 Table	Checksum
-auto_test_local.tbl_a	1061386331
+auto_test_local.tbl_a	0
 connection child2_1;
 SELECT argument FROM mysql.general_log WHERE argument LIKE '%select %';
 argument
mysqltest: Result length mismatch
 - skipping '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider.checksum_table_with_quick_mode_3/'
***Warnings generated in error logs during shutdown after running tests: spider.checksum_table_with_quick_mode_3
2019-02-25 17:35:06 11 [ERROR] mysqld: Out of memory (Needed 3062221864 bytes)
spider.direct_aggregate                  [ fail ]
        Test ended at 2019-02-25 17:35:10
CURRENT_TEST: spider.direct_aggregate
mysqltest: At line 130: query 'SELECT COUNT(*) FROM ta_l' failed: 5: Out of memory (Needed 3063032872 bytes)
The result from queries just before the failure was:
< snip >
DROP TABLE IF EXISTS ta_l;
CREATE TABLE ta_l (
a INT,
b CHAR(1),
c DATETIME,
PRIMARY KEY(a)
) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT_2_1
INSERT INTO ta_l (a, b, c) VALUES
(1, 'a', '2008-08-01 10:21:39'),
(2, 'b', '2000-01-01 00:00:00'),
(3, 'e', '2007-06-04 20:03:11'),
(4, 'd', '2003-11-30 05:01:03'),
(5, 'c', '2001-12-31 23:59:59');
direct_aggregating test
connection master_1;
SHOW STATUS LIKE 'Spider_direct_aggregate';
Variable_name	Value
Spider_direct_aggregate	0
SELECT COUNT(*) FROM ta_l;
More results from queries before failure can be found in /builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/direct_aggregate.log
 - skipping '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider.direct_aggregate/'
***Warnings generated in error logs during shutdown after running tests: spider.direct_aggregate
2019-02-25 17:35:09 11 [ERROR] mysqld: Out of memory (Needed 3063032872 bytes)
spider.direct_aggregate_part             [ fail ]
        Test ended at 2019-02-25 17:35:13
CURRENT_TEST: spider.direct_aggregate_part
mysqltest: At line 136: query 'SELECT COUNT(*) FROM ta_l2' failed: 5: Out of memory (Needed 3062598696 bytes)
The result from queries just before the failure was:
< snip >
USE auto_test_remote2;
test select 1
connection master_1;
SELECT 1;
1
1
with partition test
connection master_1;
CREATE TABLE ta_l2 (
a INT,
b CHAR(1),
c DATETIME,
PRIMARY KEY(a)
) MASTER_1_ENGINE MASTER_1_COMMENT2_P_2_1
SHOW STATUS LIKE 'Spider_direct_aggregate';
Variable_name	Value
Spider_direct_aggregate	0
SELECT COUNT(*) FROM ta_l2;
More results from queries before failure can be found in /builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/direct_aggregate_part.log
 - skipping '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider.direct_aggregate_part/'
***Warnings generated in error logs during shutdown after running tests: spider.direct_aggregate_part
2019-02-25 17:35:12 11 [ERROR] mysqld: Out of memory (Needed 3062598696 bytes)
2019-02-25 17:35:12 11 [ERROR] Got error 128 when reading table './auto_test_local/ta_l2'
spider.direct_join                       [ fail ]
        Test ended at 2019-02-25 17:35:16
CURRENT_TEST: spider.direct_join
mysqltest: At line 158: query 'SELECT a.a, c.b, c.c FROM tbl_a a, tbl_b b, tbl_c c WHERE a.a = b.a and a.a = c.a ORDER BY a.b DESC LIMIT 1,2' failed: 5: Out of memory (Needed 3062725680 bytes)
The result from queries just before the failure was:
< snip >
b CHAR(1) DEFAULT 'c',
c DATETIME DEFAULT '1999-10-10 10:10:10'
) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT5_2_1
CREATE TABLE tbl_c (
a INT AUTO_INCREMENT,
b INT DEFAULT 10,
c INT DEFAULT 11,
PRIMARY KEY(a),
KEY idx1(b),
KEY idx2(c)
) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT4_2_1
insert into tbl_a values (1,'a','2000/01/01'),(2,'b','2000/01/02'),(3,'c','2000/01/03'),(4,'d','2000/01/04'),(5,'e','2000/01/05');
insert into tbl_b values (1,'a','2000/01/01'),(2,'b','2000/01/02'),(3,'c','2000/01/03'),(4,'d','2000/01/04'),(5,'e','2000/01/05');
insert into tbl_c values (1,10,100),(2,20,200),(3,30,300),(4,40,400),(5,50,500);
select test
connection child2_1;
TRUNCATE TABLE mysql.general_log;
connection master_1;
SELECT a.a, c.b, c.c FROM tbl_a a, tbl_b b, tbl_c c WHERE a.a = b.a and a.a = c.a ORDER BY a.b DESC LIMIT 1,2;
More results from queries before failure can be found in /builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/direct_join.log
 - skipping '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider.direct_join/'
***Warnings generated in error logs during shutdown after running tests: spider.direct_join
2019-02-25 17:35:15 11 [ERROR] mysqld: Out of memory (Needed 3062725680 bytes)
spider.direct_join_using                 [ fail ]
        Test ended at 2019-02-25 17:35:19
CURRENT_TEST: spider.direct_join_using
mysqltest: At line 158: query 'SELECT a.a, c.b, c.c FROM tbl_a a join tbl_b b using(a) join tbl_c c using(a) ORDER BY a.b DESC' failed: 5: Out of memory (Needed 3063004208 bytes)
The result from queries just before the failure was:
< snip >
b CHAR(1) DEFAULT 'c',
c DATETIME DEFAULT '1999-10-10 10:10:10'
) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT5_2_1
CREATE TABLE tbl_c (
a INT AUTO_INCREMENT,
b INT DEFAULT 10,
c INT DEFAULT 11,
PRIMARY KEY(a),
KEY idx1(b),
KEY idx2(c)
) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT4_2_1
insert into tbl_a values (1,'a','2000/01/01'),(2,'b','2000/01/02'),(3,'c','2000/01/03'),(4,'d','2000/01/04'),(5,'e','2000/01/05');
insert into tbl_b values (1,'a','2000/01/01'),(2,'b','2000/01/02'),(3,'c','2000/01/03'),(4,'d','2000/01/04'),(5,'e','2000/01/05');
insert into tbl_c values (1,10,100),(2,20,200),(3,30,300),(4,40,400),(5,50,500);
select test
connection child2_1;
TRUNCATE TABLE mysql.general_log;
connection master_1;
SELECT a.a, c.b, c.c FROM tbl_a a join tbl_b b using(a) join tbl_c c using(a) ORDER BY a.b DESC;
More results from queries before failure can be found in /builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/direct_join_using.log
 - skipping '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider.direct_join_using/'
***Warnings generated in error logs during shutdown after running tests: spider.direct_join_using
2019-02-25 17:35:18 11 [ERROR] mysqld: Out of memory (Needed 3063004208 bytes)
spider.direct_left_join                  [ fail ]
        Test ended at 2019-02-25 17:35:22
CURRENT_TEST: spider.direct_left_join
mysqltest: At line 158: query 'SELECT a.a, c.b, c.c FROM tbl_a a left join tbl_b b on a.a = b.a left join tbl_c c on a.a = c.a ORDER BY a.b DESC' failed: 5: Out of memory (Needed 3062406192 bytes)
The result from queries just before the failure was:
< snip >
b CHAR(1) DEFAULT 'c',
c DATETIME DEFAULT '1999-10-10 10:10:10'
) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT5_2_1
CREATE TABLE tbl_c (
a INT AUTO_INCREMENT,
b INT DEFAULT 10,
c INT DEFAULT 11,
PRIMARY KEY(a),
KEY idx1(b),
KEY idx2(c)
) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT4_2_1
insert into tbl_a values (1,'a','2000/01/01'),(2,'b','2000/01/02'),(3,'c','2000/01/03'),(4,'d','2000/01/04'),(5,'e','2000/01/05');
insert into tbl_b values (1,'a','2000/01/01'),(2,'b','2000/01/02'),(3,'c','2000/01/03'),(4,'d','2000/01/04'),(5,'e','2000/01/05');
insert into tbl_c values (1,10,100),(2,20,200),(3,30,300),(4,40,400),(5,50,500);
select test
connection child2_1;
TRUNCATE TABLE mysql.general_log;
connection master_1;
SELECT a.a, c.b, c.c FROM tbl_a a left join tbl_b b on a.a = b.a left join tbl_c c on a.a = c.a ORDER BY a.b DESC;
More results from queries before failure can be found in /builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/direct_left_join.log
 - skipping '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider.direct_left_join/'
***Warnings generated in error logs during shutdown after running tests: spider.direct_left_join
2019-02-25 17:35:21 11 [ERROR] mysqld: Out of memory (Needed 3062406192 bytes)
spider.direct_left_join_nullable         [ fail ]
        Test ended at 2019-02-25 17:35:25
CURRENT_TEST: spider.direct_left_join_nullable
mysqltest: At line 173: query 'SELECT a.a, c.b, c.c, d.a FROM tbl_d a left join tbl_c b on a.a = b.a left join tbl_b c on b.c = c.c left join tbl_a d on c.b = d.b ORDER BY a.a DESC' failed: 5: Out of memory (Needed 3062791216 bytes)
The result from queries just before the failure was:
< snip >
c DATETIME DEFAULT '1999-10-10 10:10:10',
KEY idx0(a),
KEY idx1(b),
KEY idx2(c)
) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT3_2_1
CREATE TABLE tbl_d (
a INT DEFAULT 10,
b CHAR(1) DEFAULT 'c',
c DATETIME DEFAULT '1999-10-10 10:10:10'
) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT2_2_1
insert into tbl_a values (1,'a','2000/01/01'),(2,'b','2000/01/02');
insert into tbl_b values (1,'a','2000/01/01'),(2,'b','2000/01/02'),(3,'c','2000/01/03');
insert into tbl_c values (1,'a','2000/01/01'),(2,'b','2000/01/02'),(3,'c','2000/01/03'),(4,'d','2000/01/04');
insert into tbl_d values (1,'a','2000/01/01'),(2,'b','2000/01/02'),(3,'c','2000/01/03'),(4,'d','2000/01/04'),(5,'e','2000/01/05');
select test
connection child2_1;
TRUNCATE TABLE mysql.general_log;
connection master_1;
SELECT a.a, c.b, c.c, d.a FROM tbl_d a left join tbl_c b on a.a = b.a left join tbl_b c on b.c = c.c left join tbl_a d on c.b = d.b ORDER BY a.a DESC;
More results from queries before failure can be found in /builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/direct_left_join_nullable.log
 - skipping '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider.direct_left_join_nullable/'
***Warnings generated in error logs during shutdown after running tests: spider.direct_left_join_nullable
2019-02-25 17:35:24 11 [ERROR] mysqld: Out of memory (Needed 3062791216 bytes)
spider.direct_left_right_join_nullable   [ fail ]
        Test ended at 2019-02-25 17:35:28
CURRENT_TEST: spider.direct_left_right_join_nullable
mysqltest: At line 173: query 'SELECT a.a, c.b, c.c, d.a FROM tbl_a a left join tbl_b b on a.a = b.a left join tbl_c c on b.c = c.c right join tbl_d d on c.b = d.b ORDER BY d.a DESC' failed: 5: Out of memory (Needed 3063098416 bytes)
The result from queries just before the failure was:
< snip >
c DATETIME DEFAULT '1999-10-10 10:10:10',
KEY idx0(a),
KEY idx1(b),
KEY idx2(c)
) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT3_2_1
CREATE TABLE tbl_d (
a INT DEFAULT 10,
b CHAR(1) DEFAULT 'c',
c DATETIME DEFAULT '1999-10-10 10:10:10'
) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT2_2_1
insert into tbl_a values (1,'a','2000/01/01'),(2,'b','2000/01/02');
insert into tbl_b values (1,'a','2000/01/01'),(2,'b','2000/01/02'),(3,'c','2000/01/03');
insert into tbl_c values (1,'a','2000/01/01'),(2,'b','2000/01/02'),(3,'c','2000/01/03'),(4,'d','2000/01/04');
insert into tbl_d values (1,'a','2000/01/01'),(2,'b','2000/01/02'),(3,'c','2000/01/03'),(4,'d','2000/01/04'),(5,'e','2000/01/05');
select test
connection child2_1;
TRUNCATE TABLE mysql.general_log;
connection master_1;
SELECT a.a, c.b, c.c, d.a FROM tbl_a a left join tbl_b b on a.a = b.a left join tbl_c c on b.c = c.c right join tbl_d d on c.b = d.b ORDER BY d.a DESC;
More results from queries before failure can be found in /builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/direct_left_right_join_nullable.log
 - skipping '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider.direct_left_right_join_nullable/'
***Warnings generated in error logs during shutdown after running tests: spider.direct_left_right_join_nullable
2019-02-25 17:35:27 11 [ERROR] mysqld: Out of memory (Needed 3063098416 bytes)
spider.direct_left_right_left_join_nullable [ fail ]
        Test ended at 2019-02-25 17:35:31
CURRENT_TEST: spider.direct_left_right_left_join_nullable
mysqltest: At line 173: query 'SELECT a.a, c.b, c.c, d.a FROM tbl_a a left join tbl_b b on a.a = b.a right join tbl_c c on b.c = c.c left join tbl_d d on c.b = d.b ORDER BY d.a DESC' failed: 5: Out of memory (Needed 3063106608 bytes)
The result from queries just before the failure was:
< snip >
c DATETIME DEFAULT '1999-10-10 10:10:10',
KEY idx0(a),
KEY idx1(b),
KEY idx2(c)
) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT3_2_1
CREATE TABLE tbl_d (
a INT DEFAULT 10,
b CHAR(1) DEFAULT 'c',
c DATETIME DEFAULT '1999-10-10 10:10:10'
) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT2_2_1
insert into tbl_a values (1,'a','2000/01/01'),(2,'b','2000/01/02');
insert into tbl_b values (1,'a','2000/01/01'),(2,'b','2000/01/02'),(3,'c','2000/01/03');
insert into tbl_c values (1,'a','2000/01/01'),(2,'b','2000/01/02'),(3,'c','2000/01/03'),(4,'d','2000/01/04');
insert into tbl_d values (1,'a','2000/01/01'),(2,'b','2000/01/02'),(3,'c','2000/01/03'),(4,'d','2000/01/04'),(5,'e','2000/01/05');
select test
connection child2_1;
TRUNCATE TABLE mysql.general_log;
connection master_1;
SELECT a.a, c.b, c.c, d.a FROM tbl_a a left join tbl_b b on a.a = b.a right join tbl_c c on b.c = c.c left join tbl_d d on c.b = d.b ORDER BY d.a DESC;
More results from queries before failure can be found in /builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/direct_left_right_left_join_nullable.log
 - skipping '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider.direct_left_right_left_join_nullable/'
***Warnings generated in error logs during shutdown after running tests: spider.direct_left_right_left_join_nullable
2019-02-25 17:35:30 11 [ERROR] mysqld: Out of memory (Needed 3063106608 bytes)
spider.direct_right_join                 [ fail ]
        Test ended at 2019-02-25 17:35:34
CURRENT_TEST: spider.direct_right_join
mysqltest: At line 158: query 'SELECT a.a, c.b, c.c FROM tbl_a a right join tbl_b b on a.a = b.a right join tbl_c c on a.a = c.a ORDER BY a.b DESC' failed: 5: Out of memory (Needed 3062148144 bytes)
The result from queries just before the failure was:
< snip >
b CHAR(1) DEFAULT 'c',
c DATETIME DEFAULT '1999-10-10 10:10:10'
) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT5_2_1
CREATE TABLE tbl_c (
a INT AUTO_INCREMENT,
b INT DEFAULT 10,
c INT DEFAULT 11,
PRIMARY KEY(a),
KEY idx1(b),
KEY idx2(c)
) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT4_2_1
insert into tbl_a values (1,'a','2000/01/01'),(2,'b','2000/01/02'),(3,'c','2000/01/03'),(4,'d','2000/01/04'),(5,'e','2000/01/05');
insert into tbl_b values (1,'a','2000/01/01'),(2,'b','2000/01/02'),(3,'c','2000/01/03'),(4,'d','2000/01/04'),(5,'e','2000/01/05');
insert into tbl_c values (1,10,100),(2,20,200),(3,30,300),(4,40,400),(5,50,500);
select test
connection child2_1;
TRUNCATE TABLE mysql.general_log;
connection master_1;
SELECT a.a, c.b, c.c FROM tbl_a a right join tbl_b b on a.a = b.a right join tbl_c c on a.a = c.a ORDER BY a.b DESC;
More results from queries before failure can be found in /builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/direct_right_join.log
 - skipping '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider.direct_right_join/'
***Warnings generated in error logs during shutdown after running tests: spider.direct_right_join
2019-02-25 17:35:33 11 [ERROR] mysqld: Out of memory (Needed 3062148144 bytes)
spider.direct_right_join_nullable        [ fail ]
        Test ended at 2019-02-25 17:35:37
CURRENT_TEST: spider.direct_right_join_nullable
mysqltest: At line 173: query 'SELECT a.a, c.b, c.c, d.a FROM tbl_a a right join tbl_b b on a.a = b.a right join tbl_c c on b.c = c.c right join tbl_d d on c.b = d.b ORDER BY d.a DESC' failed: 5: Out of memory (Needed 3062430768 bytes)
The result from queries just before the failure was:
< snip >
c DATETIME DEFAULT '1999-10-10 10:10:10',
KEY idx0(a),
KEY idx1(b),
KEY idx2(c)
) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT3_2_1
CREATE TABLE tbl_d (
a INT DEFAULT 10,
b CHAR(1) DEFAULT 'c',
c DATETIME DEFAULT '1999-10-10 10:10:10'
) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT2_2_1
insert into tbl_a values (1,'a','2000/01/01'),(2,'b','2000/01/02');
insert into tbl_b values (1,'a','2000/01/01'),(2,'b','2000/01/02'),(3,'c','2000/01/03');
insert into tbl_c values (1,'a','2000/01/01'),(2,'b','2000/01/02'),(3,'c','2000/01/03'),(4,'d','2000/01/04');
insert into tbl_d values (1,'a','2000/01/01'),(2,'b','2000/01/02'),(3,'c','2000/01/03'),(4,'d','2000/01/04'),(5,'e','2000/01/05');
select test
connection child2_1;
TRUNCATE TABLE mysql.general_log;
connection master_1;
SELECT a.a, c.b, c.c, d.a FROM tbl_a a right join tbl_b b on a.a = b.a right join tbl_c c on b.c = c.c right join tbl_d d on c.b = d.b ORDER BY d.a DESC;
More results from queries before failure can be found in /builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/direct_right_join_nullable.log
 - skipping '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider.direct_right_join_nullable/'
***Warnings generated in error logs during shutdown after running tests: spider.direct_right_join_nullable
2019-02-25 17:35:36 11 [ERROR] mysqld: Out of memory (Needed 3062430768 bytes)
spider.direct_right_left_join_nullable   [ fail ]
        Test ended at 2019-02-25 17:35:40
CURRENT_TEST: spider.direct_right_left_join_nullable
mysqltest: At line 173: query 'SELECT a.a, c.b, c.c, d.a FROM tbl_a a right join tbl_b b on a.a = b.a right join tbl_c c on b.c = c.c left join tbl_d d on c.b = d.b ORDER BY d.a DESC' failed: 5: Out of memory (Needed 3062262832 bytes)
The result from queries just before the failure was:
< snip >
c DATETIME DEFAULT '1999-10-10 10:10:10',
KEY idx0(a),
KEY idx1(b),
KEY idx2(c)
) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT3_2_1
CREATE TABLE tbl_d (
a INT DEFAULT 10,
b CHAR(1) DEFAULT 'c',
c DATETIME DEFAULT '1999-10-10 10:10:10'
) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT2_2_1
insert into tbl_a values (1,'a','2000/01/01'),(2,'b','2000/01/02');
insert into tbl_b values (1,'a','2000/01/01'),(2,'b','2000/01/02'),(3,'c','2000/01/03');
insert into tbl_c values (1,'a','2000/01/01'),(2,'b','2000/01/02'),(3,'c','2000/01/03'),(4,'d','2000/01/04');
insert into tbl_d values (1,'a','2000/01/01'),(2,'b','2000/01/02'),(3,'c','2000/01/03'),(4,'d','2000/01/04'),(5,'e','2000/01/05');
select test
connection child2_1;
TRUNCATE TABLE mysql.general_log;
connection master_1;
SELECT a.a, c.b, c.c, d.a FROM tbl_a a right join tbl_b b on a.a = b.a right join tbl_c c on b.c = c.c left join tbl_d d on c.b = d.b ORDER BY d.a DESC;
More results from queries before failure can be found in /builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/direct_right_left_join_nullable.log
 - skipping '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider.direct_right_left_join_nullable/'
***Warnings generated in error logs during shutdown after running tests: spider.direct_right_left_join_nullable
2019-02-25 17:35:39 11 [ERROR] mysqld: Out of memory (Needed 3062262832 bytes)
spider.direct_right_left_right_join_nullable [ fail ]
        Test ended at 2019-02-25 17:35:43
CURRENT_TEST: spider.direct_right_left_right_join_nullable
mysqltest: At line 173: query 'SELECT a.a, c.b, c.c, d.a FROM tbl_a a right join tbl_b b on a.a = b.a left join tbl_c c on b.c = c.c right join tbl_d d on c.b = d.b ORDER BY d.a DESC' failed: 5: Out of memory (Needed 3062336560 bytes)
The result from queries just before the failure was:
< snip >
c DATETIME DEFAULT '1999-10-10 10:10:10',
KEY idx0(a),
KEY idx1(b),
KEY idx2(c)
) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT3_2_1
CREATE TABLE tbl_d (
a INT DEFAULT 10,
b CHAR(1) DEFAULT 'c',
c DATETIME DEFAULT '1999-10-10 10:10:10'
) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT2_2_1
insert into tbl_a values (1,'a','2000/01/01'),(2,'b','2000/01/02');
insert into tbl_b values (1,'a','2000/01/01'),(2,'b','2000/01/02'),(3,'c','2000/01/03');
insert into tbl_c values (1,'a','2000/01/01'),(2,'b','2000/01/02'),(3,'c','2000/01/03'),(4,'d','2000/01/04');
insert into tbl_d values (1,'a','2000/01/01'),(2,'b','2000/01/02'),(3,'c','2000/01/03'),(4,'d','2000/01/04'),(5,'e','2000/01/05');
select test
connection child2_1;
TRUNCATE TABLE mysql.general_log;
connection master_1;
SELECT a.a, c.b, c.c, d.a FROM tbl_a a right join tbl_b b on a.a = b.a left join tbl_c c on b.c = c.c right join tbl_d d on c.b = d.b ORDER BY d.a DESC;
More results from queries before failure can be found in /builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/direct_right_left_right_join_nullable.log
 - skipping '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider.direct_right_left_right_join_nullable/'
***Warnings generated in error logs during shutdown after running tests: spider.direct_right_left_right_join_nullable
2019-02-25 17:35:42 11 [ERROR] mysqld: Out of memory (Needed 3062336560 bytes)
spider.direct_update                     [ fail ]
        Test ended at 2019-02-25 17:35:46
CURRENT_TEST: spider.direct_update
mysqltest: At line 130: query 'SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l ORDER BY a' failed: 5: Out of memory (Needed 3062381616 bytes)
The result from queries just before the failure was:
< snip >
DROP TABLE IF EXISTS ta_l;
CREATE TABLE ta_l (
a INT,
b CHAR(1),
c DATETIME,
PRIMARY KEY(a)
) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT_2_1
INSERT INTO ta_l (a, b, c) VALUES
(1, 'a', '2008-08-01 10:21:39'),
(2, 'b', '2000-01-01 00:00:00'),
(3, 'e', '2007-06-04 20:03:11'),
(4, 'd', '2003-11-30 05:01:03'),
(5, 'c', '2001-12-31 23:59:59');
direct_updating test
connection master_1;
SHOW STATUS LIKE 'Spider_direct_update';
Variable_name	Value
Spider_direct_update	0
SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l ORDER BY a;
More results from queries before failure can be found in /builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/direct_update.log
 - skipping '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider.direct_update/'
***Warnings generated in error logs during shutdown after running tests: spider.direct_update
2019-02-25 17:35:45 11 [ERROR] mysqld: Out of memory (Needed 3062381616 bytes)
spider.direct_update_part                [ fail ]
        Test ended at 2019-02-25 17:35:49
CURRENT_TEST: spider.direct_update_part
mysqltest: At line 136: query 'SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l2 ORDER BY a' failed: 5: Out of memory (Needed 3062545456 bytes)
The result from queries just before the failure was:
< snip >
USE auto_test_remote2;
test select 1
connection master_1;
SELECT 1;
1
1
with partition test
connection master_1;
CREATE TABLE ta_l2 (
a INT,
b CHAR(1),
c DATETIME,
PRIMARY KEY(a)
) MASTER_1_ENGINE MASTER_1_COMMENT2_P_2_1
SHOW STATUS LIKE 'Spider_direct_update';
Variable_name	Value
Spider_direct_update	0
SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l2 ORDER BY a;
More results from queries before failure can be found in /builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/direct_update_part.log
 - skipping '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider.direct_update_part/'
***Warnings generated in error logs during shutdown after running tests: spider.direct_update_part
2019-02-25 17:35:48 11 [ERROR] mysqld: Out of memory (Needed 3062545456 bytes)
2019-02-25 17:35:48 11 [Warning] Sort aborted, host: localhost, user: root, thread: 11, query: SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l2 ORDER BY a
spider.function                          [ fail ]
        Test ended at 2019-02-25 17:35:52
CURRENT_TEST: spider.function
mysqltest: At line 87: query 'insert into t1 select a + 1 from t1' failed: 5: Out of memory (Needed 3062832168 bytes)
The result from queries just before the failure was:
< snip >
USE auto_test_remote;
connection child2_2;
DROP DATABASE IF EXISTS auto_test_remote2;
CREATE DATABASE auto_test_remote2;
USE auto_test_remote2;
test select 1
connection master_1;
SELECT 1;
1
1
in()
connection master_1;
CREATE TABLE t1 (
a VARCHAR(255),
PRIMARY KEY(a)
) MASTER_1_ENGINE MASTER_1_CHARSET3 MASTER_1_COMMENT_TEXT_PK1_1
insert into t1 values ('1');
insert into t1 select a + 1 from t1;
More results from queries before failure can be found in /builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/function.log
 - skipping '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider.function/'
***Warnings generated in error logs during shutdown after running tests: spider.function
2019-02-25 17:35:51 11 [ERROR] mysqld: Out of memory (Needed 3062832168 bytes)
spider.ha                                [ fail ]
        Test ended at 2019-02-25 17:35:55
CURRENT_TEST: spider.ha
mysqltest: At line 225: query 'SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l ORDER BY a' failed: 5: Out of memory (Needed 3063045168 bytes)
The result from queries just before the failure was:
< snip >
create table test
connection master_1;
DROP TABLE IF EXISTS ta_l;
CREATE TABLE ta_l (
a INT,
b CHAR(1),
c DATETIME,
PRIMARY KEY(a)
) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT_HA_2_1
INSERT INTO ta_l (a, b, c) VALUES
(1, 'a', '2008-08-01 10:21:39'),
(2, 'b', '2000-01-01 00:00:00'),
(3, 'e', '2007-06-04 20:03:11'),
(4, 'd', '2003-11-30 05:01:03'),
(5, 'c', '2001-12-31 23:59:59');
select test
connection master_1;
SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l ORDER BY a;
More results from queries before failure can be found in /builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/ha.log
 - skipping '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider.ha/'
***Warnings generated in error logs during shutdown after running tests: spider.ha
2019-02-25 17:35:54 11 [ERROR] mysqld: Out of memory (Needed 3063045168 bytes)
spider.ha_part                           [ fail ]
        Test ended at 2019-02-25 17:35:58
CURRENT_TEST: spider.ha_part
mysqltest: At line 266: query 'SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l2 ORDER BY a' failed: 5: Out of memory (Needed 3062176816 bytes)
The result from queries just before the failure was:
< snip >
create table with partition test
connection master_1;
DROP TABLE IF EXISTS ta_l2;
CREATE TABLE ta_l2 (
a INT,
b CHAR(1),
c DATETIME,
PRIMARY KEY(a)
) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT_HA_P_2_1
INSERT INTO ta_l2 (a, b, c) VALUES
(1, 'a', '2008-08-01 10:21:39'),
(2, 'b', '2000-01-01 00:00:00'),
(3, 'e', '2007-06-04 20:03:11'),
(4, 'd', '2003-11-30 05:01:03'),
(5, 'c', '2001-12-31 23:59:59');
select test
connection master_1;
SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l2 ORDER BY a;
More results from queries before failure can be found in /builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/ha_part.log
 - skipping '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider.ha_part/'
***Warnings generated in error logs during shutdown after running tests: spider.ha_part
2019-02-25 17:35:57 11 [ERROR] mysqld: Out of memory (Needed 3062176816 bytes)
2019-02-25 17:35:57 11 [Warning] Sort aborted, host: localhost, user: root, thread: 11, query: SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s') FROM ta_l2 ORDER BY a
spider.partition_cond_push               [ fail ]
        Test ended at 2019-02-25 17:36:01
CURRENT_TEST: spider.partition_cond_push
mysqltest: At line 157: query 'SELECT value FROM tbl_a WHERE value < 100' failed: 5: Out of memory (Needed 3062991912 bytes)
The result from queries just before the failure was:
< snip >
TRUNCATE TABLE mysql.general_log;
connection child2_3;
CHILD2_3_DROP_TABLES
CHILD2_3_CREATE_TABLES
TRUNCATE TABLE mysql.general_log;
connection master_1;
DROP TABLE IF EXISTS tbl_a;
DROP TABLE IF EXISTS tbl_b;
CREATE TABLE tbl_a (
value int NOT NULL
) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT_2_1
INSERT INTO tbl_a (value) VALUES (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
INSERT INTO tbl_a (value) VALUES (10),(11),(12),(13),(14),(15),(16),(17),(18),(19);
INSERT INTO tbl_a (value) VALUES (20),(21),(22),(23),(24),(25),(26),(27),(28),(29);
select test
connection child2_1;
TRUNCATE TABLE mysql.general_log;
connection master_1;
SELECT value FROM tbl_a WHERE value < 100;
More results from queries before failure can be found in /builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/partition_cond_push.log
 - skipping '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider.partition_cond_push/'
***Warnings generated in error logs during shutdown after running tests: spider.partition_cond_push
2019-02-25 17:36:00 11 [ERROR] mysqld: Out of memory (Needed 3062991912 bytes)
spider.partition_fulltext                [ fail ]
        Test ended at 2019-02-25 17:36:04
CURRENT_TEST: spider.partition_fulltext
mysqltest: At line 161: query 'SELECT pkey, words FROM tbl_a WHERE match(words) against('+ghi' in boolean mode)' failed: 5: Out of memory (Needed 3062357040 bytes)
The result from queries just before the failure was:
< snip >
connection child2_3;
CHILD2_3_DROP_TABLES
CHILD2_3_CREATE_TABLES
TRUNCATE TABLE mysql.general_log;
connection master_1;
DROP TABLE IF EXISTS tbl_a;
DROP TABLE IF EXISTS tbl_b;
CREATE TABLE tbl_a (
pkey int NOT NULL,
words text NOT NULL,
PRIMARY KEY (pkey),
FULLTEXT (words)
) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT_2_1
INSERT INTO tbl_a (pkey, words) VALUES (0, 'abc'),(1, 'def'),(2, 'ghi'),(3, 'jkl'),(4, 'mno'),(5, 'pqr'),(6, 'stu'),(7, 'vwx');
select test
connection child2_1;
TRUNCATE TABLE mysql.general_log;
connection master_1;
SELECT pkey, words FROM tbl_a WHERE match(words) against('+ghi' in boolean mode);
More results from queries before failure can be found in /builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/partition_fulltext.log
 - skipping '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider.partition_fulltext/'
***Warnings generated in error logs during shutdown after running tests: spider.partition_fulltext
2019-02-25 17:36:03 11 [ERROR] mysqld: Out of memory (Needed 3062357040 bytes)
2019-02-25 17:36:03 11 [ERROR] Got error 128 when reading table './auto_test_local/tbl_a'
spider.partition_join_pushdown_for_single_partition [ fail ]
        Test ended at 2019-02-25 17:36:07
CURRENT_TEST: spider.partition_join_pushdown_for_single_partition
mysqltest: At line 159: query 'SELECT sum(a.value), count(b.value2) FROM tbl_a a, tbl_b b WHERE a.value = b.value2 AND a.value = 5' failed: 5: Out of memory (Needed 3062393896 bytes)
The result from queries just before the failure was:
< snip >
CHILD2_3_DROP_TABLES
CHILD2_3_DROP_TABLES2
CHILD2_3_CREATE_TABLES
CHILD2_3_CREATE_TABLES2
TRUNCATE TABLE mysql.general_log;
connection master_1;
DROP TABLE IF EXISTS tbl_a;
DROP TABLE IF EXISTS tbl_b;
CREATE TABLE tbl_a (
value int NOT NULL,
PRIMARY KEY(value)
) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT_2_1
CREATE TABLE tbl_b (
value2 int NOT NULL,
PRIMARY KEY(value2)
) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT_2_2
insert into tbl_a values (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);
insert into tbl_b values (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);
connection master_1;
SELECT sum(a.value), count(b.value2) FROM tbl_a a, tbl_b b WHERE a.value = b.value2 AND a.value = 5;
More results from queries before failure can be found in /builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/partition_join_pushdown_for_single_partition.log
 - skipping '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider.partition_join_pushdown_for_single_partition/'
***Warnings generated in error logs during shutdown after running tests: spider.partition_join_pushdown_for_single_partition
2019-02-25 17:36:06 11 [ERROR] mysqld: Out of memory (Needed 3062393896 bytes)
2019-02-25 17:36:06 11 [ERROR] Got error 128 when reading table './auto_test_local/tbl_a'
spider.partition_mrr                     [ fail ]
        Test ended at 2019-02-25 17:36:10
CURRENT_TEST: spider.partition_mrr
mysqltest: At line 170: query 'SELECT a.pkey FROM tbl_a a, tbl_b b WHERE a.pkey = b.pkey' failed: 5: Out of memory (Needed 3062864936 bytes)
The result from queries just before the failure was:
< snip >
CREATE TABLE tbl_a (
pkey int NOT NULL,
PRIMARY KEY (pkey)
) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT_2_1
CREATE TABLE tbl_b (
pkey int NOT NULL,
PRIMARY KEY (pkey)
) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT_2_2
INSERT INTO tbl_a (pkey) VALUES (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
INSERT INTO tbl_a (pkey) VALUES (10),(11),(12),(13),(14),(15),(16),(17),(18),(19);
INSERT INTO tbl_a (pkey) VALUES (20),(21),(22),(23),(24),(25),(26),(27),(28),(29);
INSERT INTO tbl_b (pkey) VALUES (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
INSERT INTO tbl_b (pkey) VALUES (10),(11),(12),(13),(14),(15),(16),(17),(18),(19);
INSERT INTO tbl_b (pkey) VALUES (20),(21),(22),(23),(24),(25),(26),(27),(28),(29);
select test
connection child2_1;
TRUNCATE TABLE mysql.general_log;
connection master_1;
SELECT a.pkey FROM tbl_a a, tbl_b b WHERE a.pkey = b.pkey;
More results from queries before failure can be found in /builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/partition_mrr.log
 - skipping '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider.partition_mrr/'
***Warnings generated in error logs during shutdown after running tests: spider.partition_mrr
2019-02-25 17:36:09 11 [ERROR] mysqld: Out of memory (Needed 3062864936 bytes)
2019-02-25 17:36:09 11 [ERROR] Got error 128 when reading table './auto_test_local/tbl_a'
spider.quick_mode_0                      [ pass ]    214
spider.quick_mode_1                      [ fail ]
        Test ended at 2019-02-25 17:36:18
CURRENT_TEST: spider.quick_mode_1
mysqltest: At line 126: query 'SELECT a.pkey FROM tbl_a a, tbl_b b WHERE a.pkey = b.pkey' failed: 5: Out of memory (Needed 3062930472 bytes)
The result from queries just before the failure was:
< snip >
PRIMARY KEY (pkey)
) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT_2_1
CREATE TABLE tbl_b (
pkey int NOT NULL,
PRIMARY KEY (pkey)
) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT_2_2
INSERT INTO tbl_a (pkey) VALUES (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
INSERT INTO tbl_a (pkey) VALUES (10),(11),(12),(13),(14),(15),(16),(17),(18),(19);
INSERT INTO tbl_a (pkey) VALUES (20),(21),(22),(23),(24),(25),(26),(27),(28),(29);
INSERT INTO tbl_b (pkey) VALUES (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
INSERT INTO tbl_b (pkey) VALUES (10),(11),(12),(13),(14),(15),(16),(17),(18),(19);
INSERT INTO tbl_b (pkey) VALUES (20),(21),(22),(23),(24),(25),(26),(27),(28),(29);
select test 1
connection child2_1;
TRUNCATE TABLE mysql.general_log;
connection child2_2;
TRUNCATE TABLE mysql.general_log;
connection master_1;
SELECT a.pkey FROM tbl_a a, tbl_b b WHERE a.pkey = b.pkey;
More results from queries before failure can be found in /builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/quick_mode_1.log
 - skipping '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider.quick_mode_1/'
***Warnings generated in error logs during shutdown after running tests: spider.quick_mode_1
2019-02-25 17:36:16 11 [ERROR] mysqld: Out of memory (Needed 3062930472 bytes)
2019-02-25 17:36:16 11 [ERROR] Got error 128 when reading table './auto_test_local/tbl_a'
spider.quick_mode_2                      [ fail ]
        Test ended at 2019-02-25 17:36:24
CURRENT_TEST: spider.quick_mode_2
mysqltest: At line 126: query 'SELECT a.pkey FROM tbl_a a, tbl_b b WHERE a.pkey = b.pkey' failed: 2013: Lost connection to MySQL server during query
The result from queries just before the failure was:
< snip >
PRIMARY KEY (pkey)
) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT_2_1
CREATE TABLE tbl_b (
pkey int NOT NULL,
PRIMARY KEY (pkey)
) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT_2_2
INSERT INTO tbl_a (pkey) VALUES (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
INSERT INTO tbl_a (pkey) VALUES (10),(11),(12),(13),(14),(15),(16),(17),(18),(19);
INSERT INTO tbl_a (pkey) VALUES (20),(21),(22),(23),(24),(25),(26),(27),(28),(29);
INSERT INTO tbl_b (pkey) VALUES (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
INSERT INTO tbl_b (pkey) VALUES (10),(11),(12),(13),(14),(15),(16),(17),(18),(19);
INSERT INTO tbl_b (pkey) VALUES (20),(21),(22),(23),(24),(25),(26),(27),(28),(29);
select test 1
connection child2_1;
TRUNCATE TABLE mysql.general_log;
connection child2_2;
TRUNCATE TABLE mysql.general_log;
connection master_1;
SELECT a.pkey FROM tbl_a a, tbl_b b WHERE a.pkey = b.pkey;
More results from queries before failure can be found in /builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/quick_mode_2.log
Server [mysqld.1.1 - pid: 22503, winpid: 22503, exit: 256] failed during test run
Server log from this test:
----------SERVER LOG START-----------
2019-02-25 17:36:18 0 [Note] /builddir/build/BUILD/mariadb-10.3.13/sql/mysqld (mysqld 10.3.13-MariaDB-log) starting as process 22504 ...
2019-02-25 17:36:18 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 4186)
2019-02-25 17:36:18 0 [Warning] Changed limits: max_open_files: 1024  max_connections: 151 (was 151)  table_cache: 421 (was 2000)
2019-02-25 17:36:18 0 [Note] Plugin 'BLACKHOLE' is disabled.
2019-02-25 17:36:18 0 [Note] Plugin 'ARCHIVE' is disabled.
2019-02-25 17:36:18 0 [Note] Plugin 'FEDERATED' is disabled.
2019-02-25 17:36:18 0 [Note] Plugin 'SEQUENCE' is disabled.
2019-02-25 17:36:18 0 [Note] InnoDB: Using Linux native AIO
2019-02-25 17:36:18 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-02-25 17:36:18 0 [Note] InnoDB: Uses event mutexes
2019-02-25 17:36:18 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-02-25 17:36:18 0 [Note] InnoDB: Number of pools: 1
2019-02-25 17:36:18 0 [Note] InnoDB: Using generic crc32 instructions
2019-02-25 17:36:18 0 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M
2019-02-25 17:36:18 0 [Note] InnoDB: Completed initialization of buffer pool
2019-02-25 17:36:18 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-02-25 17:36:18 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-02-25 17:36:18 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-02-25 17:36:18 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-02-25 17:36:18 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2019-02-25 17:36:18 0 [Note] InnoDB: Waiting for purge to start
2019-02-25 17:36:18 0 [Note] InnoDB: 10.3.13 started; log sequence number 1642387; transaction id 34
2019-02-25 17:36:18 0 [Note] InnoDB: Loading buffer pool(s) from /dev/shm/var_32_Kvam/mysqld.1.1/data/ib_buffer_pool
2019-02-25 17:36:18 0 [Note] InnoDB: Buffer pool(s) load completed at 190225 17:36:18
2019-02-25 17:36:18 0 [Note] Plugin 'INNODB_SYS_DATAFILES' is disabled.
2019-02-25 17:36:18 0 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled.
2019-02-25 17:36:18 0 [Note] Plugin 'INNODB_LOCKS' is disabled.
2019-02-25 17:36:18 0 [Note] Plugin 'INNODB_MUTEXES' is disabled.
2019-02-25 17:36:18 0 [Note] Plugin 'INNODB_CMPMEM' is disabled.
2019-02-25 17:36:18 0 [Note] Plugin 'INNODB_CMP_PER_INDEX' is disabled.
2019-02-25 17:36:18 0 [Note] Plugin 'INNODB_CMP' is disabled.
2019-02-25 17:36:18 0 [Note] Plugin 'INNODB_FT_DELETED' is disabled.
2019-02-25 17:36:18 0 [Note] Plugin 'INNODB_CMP_RESET' is disabled.
2019-02-25 17:36:18 0 [Note] Plugin 'INNODB_LOCK_WAITS' is disabled.
2019-02-25 17:36:18 0 [Note] Plugin 'INNODB_TABLESPACES_ENCRYPTION' is disabled.
2019-02-25 17:36:18 0 [Note] Plugin 'INNODB_BUFFER_PAGE_LRU' is disabled.
2019-02-25 17:36:18 0 [Note] Plugin 'INNODB_SYS_FIELDS' is disabled.
2019-02-25 17:36:18 0 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled.
2019-02-25 17:36:18 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-02-25 17:36:18 0 [Note] Plugin 'INNODB_SYS_COLUMNS' is disabled.
2019-02-25 17:36:18 0 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled.
2019-02-25 17:36:18 0 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.
2019-02-25 17:36:18 0 [Note] Plugin 'user_variables' is disabled.
2019-02-25 17:36:18 0 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled.
2019-02-25 17:36:18 0 [Note] Plugin 'INNODB_SYS_FOREIGN_COLS' is disabled.
2019-02-25 17:36:18 0 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled.
2019-02-25 17:36:18 0 [Note] Plugin 'INNODB_BUFFER_POOL_STATS' is disabled.
2019-02-25 17:36:18 0 [Note] Plugin 'INNODB_TRX' is disabled.
2019-02-25 17:36:18 0 [Note] Plugin 'INNODB_SYS_FOREIGN' is disabled.
2019-02-25 17:36:18 0 [Note] Plugin 'INNODB_SYS_TABLES' is disabled.
2019-02-25 17:36:18 0 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled.
2019-02-25 17:36:18 0 [Note] Plugin 'INNODB_FT_CONFIG' is disabled.
2019-02-25 17:36:18 0 [Note] Plugin 'INNODB_BUFFER_PAGE' is disabled.
2019-02-25 17:36:18 0 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled.
2019-02-25 17:36:18 0 [Note] Plugin 'INNODB_METRICS' is disabled.
2019-02-25 17:36:18 0 [Note] Plugin 'INNODB_SYS_INDEXES' is disabled.
2019-02-25 17:36:18 0 [Note] Plugin 'INNODB_SYS_VIRTUAL' is disabled.
2019-02-25 17:36:18 0 [Note] Plugin 'INNODB_TABLESPACES_SCRUBBING' is disabled.
2019-02-25 17:36:18 0 [Note] Plugin 'INNODB_SYS_SEMAPHORE_WAITS' is disabled.
2019-02-25 17:36:18 0 [Warning] /builddir/build/BUILD/mariadb-10.3.13/sql/mysqld: unknown variable 'loose-feedback-debug-startup-interval=20'
2019-02-25 17:36:18 0 [Warning] /builddir/build/BUILD/mariadb-10.3.13/sql/mysqld: unknown variable 'loose-feedback-debug-first-interval=60'
2019-02-25 17:36:18 0 [Warning] /builddir/build/BUILD/mariadb-10.3.13/sql/mysqld: unknown variable 'loose-feedback-debug-interval=60'
2019-02-25 17:36:18 0 [Warning] /builddir/build/BUILD/mariadb-10.3.13/sql/mysqld: unknown option '--loose-pam-debug'
2019-02-25 17:36:18 0 [Warning] /builddir/build/BUILD/mariadb-10.3.13/sql/mysqld: unknown variable 'loose_handlersocket_port=20000'
2019-02-25 17:36:18 0 [Warning] /builddir/build/BUILD/mariadb-10.3.13/sql/mysqld: unknown variable 'loose_handlersocket_port_wr=20001'
2019-02-25 17:36:18 0 [Warning] /builddir/build/BUILD/mariadb-10.3.13/sql/mysqld: unknown variable 'loose_handlersocket_threads=2'
2019-02-25 17:36:18 0 [Warning] /builddir/build/BUILD/mariadb-10.3.13/sql/mysqld: unknown variable 'loose_handlersocket_threads_wr=1'
2019-02-25 17:36:18 0 [Warning] /builddir/build/BUILD/mariadb-10.3.13/sql/mysqld: unknown variable 'loose_handlersocket_support_merge_table=0'
2019-02-25 17:36:18 0 [Warning] /builddir/build/BUILD/mariadb-10.3.13/sql/mysqld: unknown variable 'loose_handlersocket_direct_update_mode=2'
2019-02-25 17:36:18 0 [Warning] /builddir/build/BUILD/mariadb-10.3.13/sql/mysqld: unknown variable 'loose_handlersocket_unlimited_boundary=65536'
2019-02-25 17:36:18 0 [Warning] /builddir/build/BUILD/mariadb-10.3.13/sql/mysqld: unknown variable 'loose_handlersocket_bulk_insert=0'
2019-02-25 17:36:18 0 [Warning] /builddir/build/BUILD/mariadb-10.3.13/sql/mysqld: unknown variable 'loose_handlersocket_bulk_insert_timeout=0'
2019-02-25 17:36:18 0 [Warning] /builddir/build/BUILD/mariadb-10.3.13/sql/mysqld: unknown variable 'loose_handlersocket_general_log=1'
2019-02-25 17:36:18 0 [Warning] /builddir/build/BUILD/mariadb-10.3.13/sql/mysqld: unknown variable 'loose_handlersocket_timeout=30'
2019-02-25 17:36:18 0 [Warning] /builddir/build/BUILD/mariadb-10.3.13/sql/mysqld: unknown variable 'loose_handlersocket_close_table_interval=2'
2019-02-25 17:36:18 0 [Warning] /builddir/build/BUILD/mariadb-10.3.13/sql/mysqld: unknown variable 'loose-debug-sync-timeout=300'
2019-02-25 17:36:18 0 [Note] Server socket created on IP: '127.0.0.1'.
2019-02-25 17:36:18 0 [Note] Reading of all Master_info entries succeded
2019-02-25 17:36:18 0 [Note] Added new Master_info '' to hash table
2019-02-25 17:36:18 0 [Note] /builddir/build/BUILD/mariadb-10.3.13/sql/mysqld: ready for connections.
Version: '10.3.13-MariaDB-log'  socket: '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/tmp/mysqld.1.1.sock'  port: 10640  MariaDB Server
2019-02-25 17:36:20 11 [ERROR] mysqld: Out of memory (Needed 3062565928 bytes)
2019-02-25 17:36:20 11 [ERROR] Got error 128 when reading table './auto_test_local/tbl_a'
190225 17:36:20 [ERROR] mysqld got signal 11 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
To report this bug, see https://mariadb.com/kb/en/reporting-bugs
We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed, 
something is definitely wrong and this may fail.
Server version: 10.3.13-MariaDB-log
key_buffer_size=1048576
read_buffer_size=131072
max_used_connections=2
max_threads=153
thread_count=29
It is possible that mysqld could use up to 
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 61975 K  bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
Thread pointer: 0xac7072d8
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0xae4f4cc4 thread_stack 0x49000
/builddir/build/BUILD/mariadb-10.3.13/sql/mysqld(my_print_stacktrace+0x24)[0xebf140]
/builddir/build/BUILD/mariadb-10.3.13/sql/mysqld(handle_fatal_signal+0x590)[0x983620]
/lib/libc.so.6(__default_sa_restorer+0x0)[0xb6811bd0]
/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/plugins/ha_spider.so(_Z21spider_bulk_alloc_memP21st_spider_transactionjPKcS2_mmz+0xb4)[0xad288e2c]
/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/plugins/ha_spider.so(_Z22spider_db_store_resultP9ha_spideriP5TABLE+0x3b0)[0xad24a834]
/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/plugins/ha_spider.so(_Z22spider_db_before_queryP14st_spider_connPi+0x178)[0xad24b664]
/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/plugins/ha_spider.so(_Z15spider_db_queryP14st_spider_connPKcjiPi+0x50)[0xad24b700]
/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/plugins/ha_spider.so(_ZN15spider_db_mbase8rollbackEPi+0x38)[0xad2aef7c]
/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/plugins/ha_spider.so(_Z18spider_db_rollbackP14st_spider_conn+0x58)[0xad246310]
/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/plugins/ha_spider.so(_Z15spider_rollbackP10handlertonP3THDb+0x104)[0xad242c9c]
/builddir/build/BUILD/mariadb-10.3.13/sql/mysqld(_Z17ha_rollback_transP3THDb+0x108)[0x986ab4]
/builddir/build/BUILD/mariadb-10.3.13/sql/mysqld(_Z19trans_rollback_stmtP3THD+0x68)[0x88b6bc]
/builddir/build/BUILD/mariadb-10.3.13/sql/mysqld(_Z21mysql_execute_commandP3THD+0x348)[0x79e9b4]
/builddir/build/BUILD/mariadb-10.3.13/sql/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x270)[0x7a6e10]
/builddir/build/BUILD/mariadb-10.3.13/sql/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x1ec0)[0x7a9e60]
/builddir/build/BUILD/mariadb-10.3.13/sql/mysqld(_Z10do_commandP3THD+0x18c)[0x7aa990]
/builddir/build/BUILD/mariadb-10.3.13/sql/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x220)[0x87dfe0]
/builddir/build/BUILD/mariadb-10.3.13/sql/mysqld(handle_one_connection+0x48)[0x87e248]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0xac715d28): SELECT a.pkey FROM tbl_a a, tbl_b b WHERE a.pkey = b.pkey
Connection ID (thread ID): 11
Status: NOT_KILLED
Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
Writing a core file at /builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/mysqld.1.1/data/
----------SERVER LOG END-------------
 - skipping '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider.quick_mode_2/'
***Warnings generated in error logs during shutdown after running tests: spider.quick_mode_2
2019-02-25 17:36:20 11 [ERROR] mysqld: Out of memory (Needed 3062565928 bytes)
2019-02-25 17:36:20 11 [ERROR] Got error 128 when reading table './auto_test_local/tbl_a'
190225 17:36:20 [ERROR] mysqld got signal 11 ;
Attempting backtrace. You can use the following information to find out
spider.quick_mode_3                      [ fail ]
        Test ended at 2019-02-25 17:36:27
CURRENT_TEST: spider.quick_mode_2
mysqltest: At line 126: query 'SELECT a.pkey FROM tbl_a a, tbl_b b WHERE a.pkey = b.pkey' failed: 2013: Lost connection to MySQL server during query
The result from queries just before the failure was:
< snip >
PRIMARY KEY (pkey)
) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT_2_1
CREATE TABLE tbl_b (
pkey int NOT NULL,
PRIMARY KEY (pkey)
) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT_2_2
INSERT INTO tbl_a (pkey) VALUES (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
INSERT INTO tbl_a (pkey) VALUES (10),(11),(12),(13),(14),(15),(16),(17),(18),(19);
INSERT INTO tbl_a (pkey) VALUES (20),(21),(22),(23),(24),(25),(26),(27),(28),(29);
INSERT INTO tbl_b (pkey) VALUES (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
INSERT INTO tbl_b (pkey) VALUES (10),(11),(12),(13),(14),(15),(16),(17),(18),(19);
INSERT INTO tbl_b (pkey) VALUES (20),(21),(22),(23),(24),(25),(26),(27),(28),(29);
select test 1
connection child2_1;
TRUNCATE TABLE mysql.general_log;
connection child2_2;
TRUNCATE TABLE mysql.general_log;
connection master_1;
SELECT a.pkey FROM tbl_a a, tbl_b b WHERE a.pkey = b.pkey;
More results from queries before failure can be found in /builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/quick_mode_2.log
CURRENT_TEST: spider.quick_mode_3
mysqltest: At line 126: query 'SELECT a.pkey FROM tbl_a a, tbl_b b WHERE a.pkey = b.pkey' failed: 5: Out of memory (Needed 3062602792 bytes)
The result from queries just before the failure was:
< snip >
PRIMARY KEY (pkey)
) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT_2_1
CREATE TABLE tbl_b (
pkey int NOT NULL,
PRIMARY KEY (pkey)
) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT_2_2
INSERT INTO tbl_a (pkey) VALUES (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
INSERT INTO tbl_a (pkey) VALUES (10),(11),(12),(13),(14),(15),(16),(17),(18),(19);
INSERT INTO tbl_a (pkey) VALUES (20),(21),(22),(23),(24),(25),(26),(27),(28),(29);
INSERT INTO tbl_b (pkey) VALUES (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
INSERT INTO tbl_b (pkey) VALUES (10),(11),(12),(13),(14),(15),(16),(17),(18),(19);
INSERT INTO tbl_b (pkey) VALUES (20),(21),(22),(23),(24),(25),(26),(27),(28),(29);
select test 1
connection child2_1;
TRUNCATE TABLE mysql.general_log;
connection child2_2;
TRUNCATE TABLE mysql.general_log;
connection master_1;
SELECT a.pkey FROM tbl_a a, tbl_b b WHERE a.pkey = b.pkey;
More results from queries before failure can be found in /builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/quick_mode_3.log
 - skipping '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider.quick_mode_3/'
***Warnings generated in error logs during shutdown after running tests: spider.quick_mode_3
2019-02-25 17:36:26 11 [ERROR] mysqld: Out of memory (Needed 3062602792 bytes)
2019-02-25 17:36:26 11 [ERROR] Got error 128 when reading table './auto_test_local/tbl_a'
spider.show_system_tables                [ pass ]     96
spider.slave_trx_isolation               [ fail ]
        Test ended at 2019-02-25 17:36:35
CURRENT_TEST: spider.slave_trx_isolation
mysqltest: At line 123: query 'SELECT pkey FROM tbl_a ORDER BY pkey' failed: 5: Out of memory (Needed 3062500392 bytes)
The result from queries just before the failure was:
< snip >
SELECT argument FROM mysql.general_log WHERE argument LIKE '%set %';
argument
set session time_zone = '+00:00'
SET NAMES utf8
set session transaction isolation level read committed;set session autocommit = 1;start transaction
SELECT argument FROM mysql.general_log WHERE argument LIKE '%set %'
SELECT pkey FROM tbl_a ORDER BY pkey;
pkey
0
1
2
3
4
5
6
7
8
9
connection slave1_1;
SELECT pkey FROM tbl_a ORDER BY pkey;
More results from queries before failure can be found in /builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/slave_trx_isolation.log
 - skipping '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider.slave_trx_isolation/'
***Warnings generated in error logs during shutdown after running tests: spider.slave_trx_isolation
2019-02-25 17:36:33 9 [ERROR] mysqld: Out of memory (Needed 3062500392 bytes)
spider.timestamp                         [ fail ]
        Test ended at 2019-02-25 17:36:38
CURRENT_TEST: spider.timestamp
mysqltest: At line 174: query 'SELECT *, unix_timestamp(col_ts) FROM tbl_a' failed: 5: Out of memory (Needed 3062627376 bytes)
The result from queries just before the failure was:
< snip >
Ambiguous DST values for MET time zone that result in the
same UTC timestamp
INSERT INTO tbl_a VALUES (2, '2018-03-25 02:00:00', '2018-03-25 02:00:00');
INSERT INTO tbl_a VALUES (3, '2018-03-25 02:30:00', '2018-03-25 02:30:00');
Ambiguous DST values for MET time zone in the 2:00 am to 3:00 am hour
that occur twice when transitioning from DST to standard time
SET @@timestamp=1540686600;
INSERT INTO tbl_a VALUES (4, now(), now());
SET @@timestamp=1540690200;
INSERT INTO tbl_a VALUES (5, now(), now());
Max value
SET @@timestamp=2147483647;
INSERT INTO tbl_a VALUES (6, now(), now());
SET @@timestamp=0;
SELECTs
connection child2_1;
TRUNCATE TABLE mysql.general_log;
connection master_1;
SELECT *, unix_timestamp(col_ts) FROM tbl_a;
More results from queries before failure can be found in /builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/timestamp.log
 - skipping '/builddir/build/BUILD/mariadb-10.3.13/mysql-test/var/log/spider.timestamp/'
***Warnings generated in error logs during shutdown after running tests: spider.timestamp
2019-02-25 17:36:36 11 [ERROR] mysqld: Out of memory (Needed 3062627376 bytes)
spider.vp_fixes                          [ pass ]    158
--------------------------------------------------------------------------
The servers were restarted 50 times
Spent 0.619 of 159 seconds executing testcases
Completed: Failed 47/51 tests, 7.84% were successful.
Failing test(s): spider/bg.spider3_fixes spider/bg.spider3_fixes_part spider/bg.spider_fixes spider/bg.spider_fixes_part spider/bg.basic_sql spider/bg.basic_sql_part spider/bg.direct_aggregate spider/bg.direct_aggregate_part spider/bg.direct_update spider/bg.direct_update_part spider/bg.function spider/bg.ha spider/bg.ha_part spider.spider3_fixes spider.spider3_fixes_part spider.spider_fixes spider.spider_fixes_part spider.auto_increment spider.basic_sql spider.basic_sql_part spider.checksum_table_with_quick_mode_3 spider.direct_aggregate spider.direct_aggregate_part spider.direct_join spider.direct_join_using spider.direct_left_join spider.direct_left_join_nullable spider.direct_left_right_join_nullable spider.direct_left_right_left_join_nullable spider.direct_right_join spider.direct_right_join_nullable spider.direct_right_left_join_nullable spider.direct_right_left_right_join_nullable spider.direct_update spider.direct_update_part spider.function spider.ha spider.ha_part spider.partition_cond_push spider.partition_fulltext spider.partition_join_pushdown_for_single_partition spider.partition_mrr spider.quick_mode_1 spider.quick_mode_2 spider.quick_mode_3 spider.slave_trx_isolation spider.timestamp
The log files in var/log may give you some hint of what went wrong.
If you want to report this error, please read first the documentation
at http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html
Errors/warnings were found in logfiles during server shutdown after running the
following sequence(s) of tests:
    spider/bg.spider3_fixes
    spider/bg.spider3_fixes_part
    spider/bg.spider_fixes
    spider/bg.spider_fixes_part
    spider/bg.basic_sql
    spider/bg.basic_sql_part
    spider/bg.direct_aggregate
    spider/bg.direct_aggregate_part
    spider/bg.direct_update
    spider/bg.direct_update_part
    spider/bg.function
    spider/bg.ha
    spider/bg.ha_part
    spider.spider3_fixes
    spider.spider3_fixes_part
    spider.spider_fixes
    spider.spider_fixes_part
    spider.auto_increment
    spider.basic_sql
    spider.basic_sql_part
    spider.checksum_table_with_quick_mode_3
    spider.direct_aggregate
    spider.direct_aggregate_part
    spider.direct_join
    spider.direct_join_using
    spider.direct_left_join
    spider.direct_left_join_nullable
    spider.direct_left_right_join_nullable
    spider.direct_left_right_left_join_nullable
    spider.direct_right_join
    spider.direct_right_join_nullable
    spider.direct_right_left_join_nullable
    spider.direct_right_left_right_join_nullable
    spider.direct_update
    spider.direct_update_part
    spider.function
    spider.ha
    spider.ha_part
    spider.partition_cond_push
    spider.partition_fulltext
    spider.partition_join_pushdown_for_single_partition
    spider.partition_mrr
    spider.quick_mode_1
    spider.quick_mode_2
    spider.quick_mode_3
    spider.slave_trx_isolation
    spider.timestamp
BUILDSTDERR: mysql-test-run: *** ERROR: there were failing test cases
+ :
+ exit 0