Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
10.0, 10.1, 10.2
-
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