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

binlog.load_data_stm_view failed in buildbot with wrong result

    XMLWordPrintable

Details

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

    Description

      http://buildbot.askmonty.org/buildbot/builders/kvm-rpm-centos73-ppc64/builds/5562

      binlog.load_data_stm_view 'stmt'         w2 [ fail ]
              Test ended at 2018-08-04 03:31:14
       
      CURRENT_TEST: binlog.load_data_stm_view
      --- /usr/share/mysql-test/suite/binlog/r/load_data_stm_view.result	2018-08-04 00:10:09.000000000 +0000
      +++ /dev/shm/var/2/log/load_data_stm_view.reject	2018-08-04 03:31:14.650246888 +0000
      @@ -9,6 +9,67 @@
       include/show_binlog_events.inc
       Log_name	Pos	Event_type	Server_id	End_log_pos	Info
       master-bin.000001	#	Gtid	#	#	GTID #-#-#
      +master-bin.000001	#	Query	#	#	use `test`; CREATE TABLE t1 (`tinyint` TINYINT,
      +`smallint` SMALLINT,
      +`mediumint` MEDIUMINT,
      +`integer` INTEGER,
      +`bigint` BIGINT,
      +`utinyint` TINYINT UNSIGNED,
      +`usmallint` SMALLINT UNSIGNED,
      +`umediumint` MEDIUMINT UNSIGNED,
      +`uinteger` INTEGER UNSIGNED,
      +`ubigint` BIGINT UNSIGNED,
      +`double` DOUBLE,
      +`float` FLOAT,
      +`real` REAL(30,2),
      +`decimal` DECIMAL(30,2)) ENGINE = MyISAM
      +master-bin.000001	#	Gtid	#	#	BEGIN GTID #-#-#
      +master-bin.000001	#	Query	#	#	use `test`; INSERT INTO t1 VALUES (18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615,18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615)
      +master-bin.000001	#	Query	#	#	COMMIT
      +master-bin.000001	#	Gtid	#	#	GTID #-#-#
      +master-bin.000001	#	Query	#	#	use `test`; TRUNCATE t1
      +master-bin.000001	#	Gtid	#	#	BEGIN GTID #-#-#
      +master-bin.000001	#	User var	#	#	@`positive`=18446744073709551615
      +master-bin.000001	#	Query	#	#	use `test`; INSERT INTO t1 VALUES (@positive,
      +@positive,
      +@positive,
      +@positive,
      +@positive,
      +@positive,
      +@positive,
      +@positive,
      +@positive,
      +@positive,
      +@positive,
      +@positive,
      +@positive,
      +@positive)
      +master-bin.000001	#	Query	#	#	COMMIT
      +master-bin.000001	#	Gtid	#	#	BEGIN GTID #-#-#
      +master-bin.000001	#	Query	#	#	use `test`; INSERT INTO t1 VALUES (-9223372036854775808, -9223372036854775808, -9223372036854775808, -9223372036854775808, -9223372036854775808, -9223372036854775808, -9223372036854775808,-9223372036854775808, -9223372036854775808, -9223372036854775808, -9223372036854775808, -9223372036854775808, -9223372036854775808, -9223372036854775808)
      +master-bin.000001	#	Query	#	#	COMMIT
      +master-bin.000001	#	Gtid	#	#	GTID #-#-#
      +master-bin.000001	#	Query	#	#	use `test`; TRUNCATE t1
      +master-bin.000001	#	Gtid	#	#	BEGIN GTID #-#-#
      +master-bin.000001	#	User var	#	#	@`negative`=-9223372036854775808
      +master-bin.000001	#	Query	#	#	use `test`; INSERT INTO t1 VALUES (@negative,
      +@negative,
      +@negative,
      +@negative,
      +@negative,
      +@negative,
      +@negative,
      +@negative,
      +@negative,
      +@negative,
      +@negative,
      +@negative,
      +@negative,
      +@negative)
      +master-bin.000001	#	Query	#	#	COMMIT
      +master-bin.000001	#	Gtid	#	#	GTID #-#-#
      +master-bin.000001	#	Query	#	#	use `test`; DROP TABLE `t1` /* generated by server */
      +master-bin.000001	#	Gtid	#	#	GTID #-#-#
       master-bin.000001	#	Query	#	#	use `test`; create table t1 (i int, j int)
       master-bin.000001	#	Gtid	#	#	GTID #-#-#
       master-bin.000001	#	Query	#	#	use `test`; CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select i from t1
       
      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.