Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-27160

main.long_unique failed on ppc64el on Ubuntu 21.10 autopkgtest

    XMLWordPrintable

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

          Activity

            People

              marko Marko Mäkelä
              otto Otto Kekäläinen
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.