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

rpl.rpl_insert_id failed in buildbot with wrong result

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Fix
    • 10.1
    • N/A
    • Replication, Tests
    • None

    Description

      http://buildbot.askmonty.org/buildbot/builders/kvm-deb-stretch-ppc64le/builds/1654/steps/mtr/logs/stdio

      rpl.rpl_insert_id 'innodb_plugin,stmt'   w3 [ fail ]
              Test ended at 2018-01-23 17:38:24
       
      CURRENT_TEST: rpl.rpl_insert_id
      --- /usr/share/mysql/mysql-test/suite/rpl/r/rpl_insert_id.result	2018-01-23 08:58:08.000000000 -0500
      +++ /dev/shm/var/3/log/rpl_insert_id.reject	2018-01-23 17:38:24.766359198 -0500
      @@ -71,11 +71,6 @@
       13
       select * from t2 ORDER BY b;
       b	c
      -5	0
      -6	10
      -7	11
      -8	12
      -9	13
       drop table t1;
       drop table t2;
       #
      @@ -102,7 +97,6 @@
       1
       select * from t2;
       a
      -1
       drop table t1;
       drop table t2;
       #
      @@ -180,17 +174,8 @@
       3	5
       select * from t1;
       id	last_id
      -1	0
      -2	1
      -3	2
      -4	1
      -5	4
      -6	3
       select * from t2;
       id	last_id
      -1	3
      -2	4
      -3	5
       drop function bug15728;
       drop function bug15728_insert;
       drop table t1,t2;
      @@ -215,7 +200,6 @@
       delete from t1 where b <> 100;
       select * from t1 order by n;
       n	b
      -1	100
       replace into t1 values(null,100),(null,350);
       select * from t1 order by n;
       n	b
      @@ -223,8 +207,6 @@
       3	350
       select * from t1 order by n;
       n	b
      -2	100
      -3	350
       insert into t1 values (NULL,400),(3,500),(NULL,600) on duplicate key UPDATE n=1000;
       select * from t1 order by n;
       n	b
      @@ -234,10 +216,6 @@
       1001	600
       select * from t1 order by n;
       n	b
      -2	100
      -4	400
      -1000	350
      -1001	600
       drop table t1;
       create table t1 (n int primary key auto_increment not null,
       b int, unique(b)) engine=myisam;
      @@ -249,7 +227,6 @@
       delete from t1 where b <> 100;
       select * from t1 order by n;
       n	b
      -1	100
       insert into t1 values(null,100),(null,350) on duplicate key update n=2;
       select * from t1 order by n;
       n	b
      @@ -257,8 +234,6 @@
       3	350
       select * from t1 order by n;
       n	b
      -2	100
      -3	350
       drop table t1;
       CREATE TABLE t1 (a INT NOT NULL PRIMARY KEY AUTO_INCREMENT, b INT,
       UNIQUE(b)) ENGINE=myisam;
      @@ -269,8 +244,6 @@
       2	2
       SELECT * FROM t1 ORDER BY a;
       a	b
      -1	10
      -2	2
       drop table t1;
       CREATE TABLE t1 (
       id bigint(20) unsigned NOT NULL auto_increment,
      @@ -311,12 +284,6 @@
       6	6	f	6f
       SELECT * FROM t1 ORDER BY id;
       id	field_1	field_2	field_3
      -1	1	a	1a
      -2	2	b	2b
      -3	3	c	3c
      -4	4	d	4d
      -5	5	e	5e
      -6	6	f	6f
       drop table t1, t2;
       DROP PROCEDURE IF EXISTS p1;
       DROP TABLE IF EXISTS t1, t2;
      @@ -347,10 +314,8 @@
       1	0
       SELECT * FROM t1 ORDER BY id;
       id	last_id
      -0	1
       SELECT * FROM t2 ORDER BY id;
       id	last_id
      -1	0
       DROP PROCEDURE p1;
       DROP TABLE t1, t2;
       DROP PROCEDURE IF EXISTS p1;
      @@ -428,30 +393,9 @@
       16
       SELECT * FROM t1;
       i	j
      -1	-1
      -2	0
      -3	0
      -4	0
      -5	0
      -6	0
      -7	0
      -8	3
      -9	3
      -10	3
      -11	3
      -12	3
      -13	8
      -14	-1
      -15	13
      -16	0
       17	0
       SELECT * FROM t2;
       i
      -2
      -3
      -5
      -6
      -16
       DROP PROCEDURE p1;
       DROP FUNCTION f1;
       DROP FUNCTION f2;
      @@ -493,11 +437,8 @@
       8	0
       select * from t1 order by id;
       id
      -0
       select * from t2 order by id;
       id	last_id
      -4	0
      -8	0
       drop table t1;
       drop function insid;
       truncate table t2;
      @@ -519,10 +460,8 @@
       1	3
       select * from t1 order by n;
       n	b
      -1	10
       select * from t2 order by id;
       id	last_id
      -1	3
       drop table t1, t2;
       drop procedure foo;
       SET @@global.concurrent_insert= @old_concurrent_insert;
       
      mysqltest: Result length mismatch
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            elenst Elena Stepanova
            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.