Details
Description
While uploading Mariadb 10.5.13 to Ubuntu 21.10 Impish the following failure in autopkgtests (that runs the mtr among others) was noticed on platform ppc64el:
main.long_unique w1 [ fail ]
|
Test ended at 2021-12-02 15:01:58
|
|
CURRENT_TEST: main.long_unique
|
mysqltest: At line 409: query 'insert into t1 values(concat(repeat('sachin',10000000),'1'),concat(repeat('sachin',10000000),'1'),
|
concat(repeat('sachin',10000000),'1'))' failed: 2013: Lost connection to MySQL server during query
|
|
The result from queries just before the failure was:
|
< snip >
|
Field Type Null Key Default Extra
|
a longblob YES UNI NULL
|
b longblob YES MUL NULL
|
c longblob YES NULL
|
show create table t1;
|
Table Create Table
|
t1 CREATE TABLE `t1` (
|
`a` longblob DEFAULT NULL,
|
`b` longblob DEFAULT NULL,
|
`c` longblob DEFAULT NULL,
|
UNIQUE KEY `a` (`a`) USING HASH,
|
UNIQUE KEY `b` (`b`,`c`) USING HASH
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1
|
show keys from t1;
|
Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment
|
t1 0 a 1 a A NULL NULL NULL YES HASH
|
t1 0 b 1 b A NULL NULL NULL YES HASH
|
t1 0 b 2 c A NULL NULL NULL YES HASH
|
insert into t1 values(concat(repeat('sachin',10000000),'1'),concat(repeat('sachin',10000000),'1'),
|
concat(repeat('sachin',10000000),'1'));
|
|
More results from queries before failure can be found in /tmp/tmp.P0sky4MUVI/var/1/log/long_unique.log
|
|
|
Server [mysqld.1 - pid: 4618, winpid: 4618, exit: 256] failed during test run
|
Server log from this test:
|
----------SERVER LOG START-----------
|
----------SERVER LOG END-------------
|
For more details please see https://bugs.launchpad.net/ubuntu/+source/mariadb-10.5/+bug/1951709/comments/5
Attachments
Issue Links
- relates to
-
MDEV-371 Unique indexes for blobs
- Closed