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

mysql_fetch didn't end with MYSQL_NO_DATA from statement

    XMLWordPrintable

    Details

      Description

      Run this testcase with --ps-protocol

       
      CREATE TABLE t1 (
        i INT ZEROFILL,
        i0 INT(0) ZEROFILL,
        i1 INT(1) ZEROFILL,
        i20 INT(20) ZEROFILL,
        t TINYINT ZEROFILL,
        t0 TINYINT(0) ZEROFILL,
        t1 TINYINT(1) ZEROFILL,
        t20 TINYINT(20) ZEROFILL,
        s SMALLINT ZEROFILL,
        s0 SMALLINT(0) ZEROFILL,
        s1 SMALLINT(1) ZEROFILL,
        s20 SMALLINT(20) ZEROFILL,
        m MEDIUMINT ZEROFILL,
        m0 MEDIUMINT(0) ZEROFILL,
        m1 MEDIUMINT(1) ZEROFILL,
        m20 MEDIUMINT(20) ZEROFILL,
        b BIGINT ZEROFILL,
        b0 BIGINT(0) ZEROFILL,
        b1 BIGINT(1) ZEROFILL,
        b20 BIGINT(20) ZEROFILL,
        pk INT AUTO_INCREMENT PRIMARY KEY
      ) ENGINE=myisam;
      SHOW COLUMNS IN t1;
      INSERT INTO t1 (i,i0,i1,i20,t,t0,t1,t20,s,s0,s1,s20,m,m0,m1,m20,b,b0,b1,b20) VALUES (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20);
      INSERT INTO t1 (i,i0,i1,i20,t,t0,t1,t20,s,s0,s1,s20,m,m0,m1,m20,b,b0,b1,b20) VALUES (0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
      INSERT INTO t1 (i,i0,i1,i20,t,t0,t1,t20,s,s0,s1,s20,m,m0,m1,m20,b,b0,b1,b20) VALUES (2147483647,2147483647,2147483647,2147483647,127,127,127,127,32767,32767,32767,32767,8388607,8388607,8388607,8388607,9223372036854775807,9223372036854775807,9223372036854775807,9223372036854775807);
      SELECT i,i0,i1,i20,t,t0,t1,t20,s,s0,s1,s20,m,m0,m1,m20,b,b0,b1,b20 FROM t1;
       
      drop table t1;
      

      And you will get

      CURRENT_TEST: main.a
      mysqltest: At line 29: mysql_fetch didn't end with MYSQL_NO_DATA from statement: error: 101
      

      Initially, I observed this when running rocksdb.col_opt_zerofil test with --ps-protocol.
      There, I also get messages like this:

      /home/psergey/dev-git/10.2-mariarocks-r4/client/mysqltest: Out of memory (Needed 2779097088 bytes)
      

      THis is also repeatable with Facebook/MySQL-5.6, see
      https://github.com/facebook/mysql-5.6/issues/750

        Attachments

          Activity

            People

            Assignee:
            georg Georg Richter
            Reporter:
            psergey Sergei Petrunia
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: