[MDEV-12640] TokuDB big tests fail in buildbot Created: 2017-04-29  Updated: 2023-11-29  Resolved: 2023-11-29

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - TokuDB, Tests
Affects Version/s: 10.0, 10.1, 10.2
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Unassigned
Resolution: Won't Fix Votes: 0
Labels: None


 Description   

http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest-big/builds/809/steps/test_1/logs/stdio

tokudb.change_column_all_1000_10         w2 [ fail ]
 
        Test ended at 2017-04-20 15:59:57
 
 
 
CURRENT_TEST: tokudb.change_column_all_1000_10
 
mysqltest: At line 24516: query 'ALTER TABLE t CHANGE COLUMN g g BLOB NOT NULL' failed: 2013: Lost connection to MySQL server during query
 
 
 
The result from queries just before the failure was:
 
< snip >
 
INSERT INTO t VALUES (1622009861,11883,'N1ea0m8QGX92Q4kAMbdCdkFzQNfC39pP','sI8TKZnpcHNaUse','6psd4oSteosKr6ygNoWS4BtjmGqtSR0b1NvZx7nfrnijuq6hoEWiCSUcehcDPl2lNe','87yjbJbI','5','GZ',9);
 
CREATE TABLE ti (a INT NOT NULL, b SMALLINT UNSIGNED NOT NULL, c CHAR(34) NOT NULL, d VARCHAR(30), e VARBINARY(68), f VARCHAR(20), g TINYBLOB NOT NULL, h TINYBLOB NOT NULL, id BIGINT NOT NULL, KEY(b), KEY(e), PRIMARY KEY(id)) ENGINE=myisam;
 
INSERT INTO ti SELECT * FROM t;
 
ALTER TABLE t CHANGE COLUMN a a INT NOT NULL;
 
ALTER TABLE ti CHANGE COLUMN a a INT NOT NULL;
 
INSERT INTO t VALUES (-473425405,26738,'VddKn00ahqe48DPyzBA0Hu4gCthg0H5oD','yz2FQp','SPYufQBkCLG4G5xtnQTQaSrMoLARJAR9','vDpmTGuJJNkBFf03Swd','R','f5',10);
 
INSERT INTO ti VALUES (-473425405,26738,'VddKn00ahqe48DPyzBA0Hu4gCthg0H5oD','yz2FQp','SPYufQBkCLG4G5xtnQTQaSrMoLARJAR9','vDpmTGuJJNkBFf03Swd','R','f5',10);
 
ALTER TABLE t CHANGE COLUMN c c CHAR(35) NOT NULL;
 
ALTER TABLE ti CHANGE COLUMN c c CHAR(35) NOT NULL;
 
INSERT INTO t VALUES (1161110428,61043,'NeCjNg6pCZNKdBra1dRn75','CtwADfoEfm8XU','9ptf6RTkFO2djK1z47a7uAm7K1','7tnPcdADBwwv3B4if3v','9C','q',11);
 
INSERT INTO ti VALUES (1161110428,61043,'NeCjNg6pCZNKdBra1dRn75','CtwADfoEfm8XU','9ptf6RTkFO2djK1z47a7uAm7K1','7tnPcdADBwwv3B4if3v','9C','q',11);
 
ALTER TABLE t CHANGE COLUMN d d VARCHAR(256);
 
ALTER TABLE ti CHANGE COLUMN d d VARCHAR(256);
 
INSERT INTO t VALUES (648568010,477,'RrKi1WbPTCq4SyPQ9uPOzfC8FH','CyaASNrQUGt8Dkx4JP8gGyeyqJVwK1o6VCfBBd4EoAT','M5QQomxGQJ83BCKyLJqGPUvzIB5LwwfMLM8CN2vITboSuraojbV0RDrT0z27dOE','sbBZthqVtZs0X010D','PP','wb',12);
 
INSERT INTO ti VALUES (648568010,477,'RrKi1WbPTCq4SyPQ9uPOzfC8FH','CyaASNrQUGt8Dkx4JP8gGyeyqJVwK1o6VCfBBd4EoAT','M5QQomxGQJ83BCKyLJqGPUvzIB5LwwfMLM8CN2vITboSuraojbV0RDrT0z27dOE','sbBZthqVtZs0X010D','PP','wb',12);
 
ALTER TABLE t CHANGE COLUMN f f VARCHAR(256);
 
ALTER TABLE ti CHANGE COLUMN f f VARCHAR(256);
 
INSERT INTO t VALUES (770900515,6019,'oG4BsbT46PkwqwTKs39o91SWlUznJXR0B','kdS8gLHCLys9b','njKmGm2P0EFVIExVJdSHjk7I6iUfyeEzfxGFisPNtEf','lbrWvWmn8N','w','Gn',13);
 
INSERT INTO ti VALUES (770900515,6019,'oG4BsbT46PkwqwTKs39o91SWlUznJXR0B','kdS8gLHCLys9b','njKmGm2P0EFVIExVJdSHjk7I6iUfyeEzfxGFisPNtEf','lbrWvWmn8N','w','Gn',13);
 
ALTER TABLE t CHANGE COLUMN g g BLOB NOT NULL;
 
 
 
More results from queries before failure can be found in /mnt/buildbot/build/mariadb-10.1.23/mysql-test/var/2/log/change_column_all_1000_10.log
 
 
 
 
 
Server [mysqld.1 - pid: 2028, winpid: 2028, exit: 256] failed during test run
 
Server log from this test:
 
----------SERVER LOG START-----------
 
----------SERVER LOG END-------------

tokudb.change_column_all_1000_10, tokudb.rows-32m-rand-insert, tokudb.rows-32m-seq-insert, tokudb.hotindex-insert-bigchar, tokudb.change_column_bin, tokudb.hotindex-update-1 are affected

 Comments   
Comment by Alice Sherepa [ 2017-11-06 ]

http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest-big/builds/1301/steps/test_1/logs/stdio

tokudb.rows-32m-rand-insert              w2 [ fail ]
 
        Test ended at 2017-11-04 07:37:02
 
 
 
CURRENT_TEST: tokudb.rows-32m-rand-insert
 
mysqltest: At line 26: query 'insert ignore into t (id,v) values (floor(rand()*$maxid),repeat('a',($maxblob-4)*rand()))' failed: 2013: Lost connection to MySQL server during query
 
 
 
The result from queries just before the failure was:
 
< snip >
 
insert ignore into t (id,v) values (floor(rand()*1000),repeat('a',(32*1024*1024-4)*rand()));
 
insert ignore into t (id,v) values (floor(rand()*1000),repeat('a',(32*1024*1024-4)*rand()));
 
insert ignore into t (id,v) values (floor(rand()*1000),repeat('a',(32*1024*1024-4)*rand()));
 
insert ignore into t (id,v) values (floor(rand()*1000),repeat('a',(32*1024*1024-4)*rand()));
 
insert ignore into t (id,v) values (floor(rand()*1000),repeat('a',(32*1024*1024-4)*rand()));
 
insert ignore into t (id,v) values (floor(rand()*1000),repeat('a',(32*1024*1024-4)*rand()));
 
insert ignore into t (id,v) values (floor(rand()*1000),repeat('a',(32*1024*1024-4)*rand()));
 
insert ignore into t (id,v) values (floor(rand()*1000),repeat('a',(32*1024*1024-4)*rand()));
 
insert ignore into t (id,v) values (floor(rand()*1000),repeat('a',(32*1024*1024-4)*rand()));
 
insert ignore into t (id,v) values (floor(rand()*1000),repeat('a',(32*1024*1024-4)*rand()));
 
insert ignore into t (id,v) values (floor(rand()*1000),repeat('a',(32*1024*1024-4)*rand()));
 
insert ignore into t (id,v) values (floor(rand()*1000),repeat('a',(32*1024*1024-4)*rand()));
 
insert ignore into t (id,v) values (floor(rand()*1000),repeat('a',(32*1024*1024-4)*rand()));
 
insert ignore into t (id,v) values (floor(rand()*1000),repeat('a',(32*1024*1024-4)*rand()));
 
insert ignore into t (id,v) values (floor(rand()*1000),repeat('a',(32*1024*1024-4)*rand()));
 
insert ignore into t (id,v) values (floor(rand()*1000),repeat('a',(32*1024*1024-4)*rand()));
 
insert ignore into t (id,v) values (floor(rand()*1000),repeat('a',(32*1024*1024-4)*rand()));
 
insert ignore into t (id,v) values (floor(rand()*1000),repeat('a',(32*1024*1024-4)*rand()));
 
insert ignore into t (id,v) values (floor(rand()*1000),repeat('a',(32*1024*1024-4)*rand()));
 
insert ignore into t (id,v) values (floor(rand()*1000),repeat('a',(32*1024*1024-4)*rand()));
 
 
 
More results from queries before failure can be found in /mnt/buildbot/build/mariadb-10.1.29/mysql-test/var/2/log/rows-32m-rand-insert.log


CURRENT_TEST: tokudb.rows-32m-rand-insert
 
==1672==ERROR: AddressSanitizer failed to allocate 0x3c53000 (63254528) bytes of LargeMmapAllocator (errno: 12)

http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest-big/builds/1301/steps/test_2/logs/stdio

CURRENT_TEST: tokudb.rows-32m-seq-insert
 
mysqltest: At line 26: query 'insert into t (v) values (repeat('a',($maxblob-4)*rand()))' failed: 2013: Lost connection to MySQL server during query
 
 
 
The result from queries just before the failure was:
 
SET DEFAULT_STORAGE_ENGINE='tokudb';
 
drop table if exists t;
 
create table t (id int not null auto_increment primary key, v longblob not null);
 
select @@max_allowed_packet into @my_max_allowed_packet;
 
set global max_allowed_packet=100000000;
 
insert into t (v) values (repeat('a',(32*1024*1024-4)*rand()));
 
insert into t (v) values (repeat('a',(32*1024*1024-4)*rand()));
 
insert into t (v) values (repeat('a',(32*1024*1024-4)*rand()));
 
insert into t (v) values (repeat('a',(32*1024*1024-4)*rand()));
 
insert into t (v) values (repeat('a',(32*1024*1024-4)*rand()));
 
insert into t (v) values (repeat('a',(32*1024*1024-4)*rand()));
 
insert into t (v) values (repeat('a',(32*1024*1024-4)*rand()));
 
insert into t (v) values (repeat('a',(32*1024*1024-4)*rand()));
 
insert into t (v) values (repeat('a',(32*1024*1024-4)*rand()));
 
insert into t (v) values (repeat('a',(32*1024*1024-4)*rand()));
 
insert into t (v) values (repeat('a',(32*1024*1024-4)*rand()));
 
 
 
 
 
Server [mysqld.1 - pid: 1855, winpid: 1855, exit: 256] failed during test run
 
Server log from this test:
 
----------SERVER LOG START-----------
 
==1856==ERROR: AddressSanitizer failed to allocate 0x332a000 (53649408) bytes of LargeMmapAllocator (errno: 12)
 
==1856==Process memory map follows:
 
	0x00007fff7000-0x00008fff7000	
	0x00008fff7000-0x02008fff7000	
	0x02008fff7000-0x10007fff8000	
	0x558acfc12000-0x558ad197e000	/mnt/buildbot/build/mariadb-10.1.29/sql/mysqld
 
	0x558ad1b7e000-0x558ad1c2a000	/mnt/buildbot/build/mariadb-10.1.29/sql/mysqld
 
	0x558ad1c2a000-0x558ad1e80000	/mnt/buildbot/build/mariadb-10.1.29/sql/mysqld
 
	0x558ad1e80000-0x558ad271f000	
	0x600000000000-0x602000000000

Comment by Oleksandr Byelkin [ 2018-07-17 ]

It goes with debugger (no way to catch it so far), despite debug sync file after each write debug log is not stable, maximum what I saw was ending writing a record, but more frequent it ends inside the procedure. Probably rashea some other thread (not sure).

Generated at Thu Feb 08 07:59:18 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.