I am working with 5.7.19-17.

I modified the code a little bit with the following patch:

==============patch==============================
--- a/storage/innobase/lock/lock0lock.cc
+++ b/storage/innobase/lock/lock0lock.cc
@@ -51,6 +51,27 @@ Created 5/7/1996 Heikki Tuuri
 
 #include <set>
 
+extern "C" LEX_CSTRING thd_query_unsafe(MYSQL_THD thd);
+
+static void inline print_info_if_supremum(
+  const buf_block_t*   block,
+       ulint                   heap_no,
+  ulint                        mode) {
+
+  const char *query = current_thd ? thd_query_unsafe(current_thd).str : "";
+
+  if (!query)
+    query = "";
+
+  if (heap_no == PAGE_HEAP_NO_SUPREMUM) {
+    ib::info() << ">>>>>>>> supremum is locked for page "
+               << block->page.id.page_no()
+               << ", mode " << mode
+               << ", query: " << query;
+  }
+
+}
+
 /* Flag to enable/disable deadlock detector. */
 my_bool        innobase_deadlock_detect = TRUE;
 
@@ -2058,6 +2079,8 @@ lock_rec_lock(
              || mode - (LOCK_MODE_MASK & mode) == 0);
        ut_ad(dict_index_is_clust(index) || !dict_index_is_online_ddl(index));
 
+  print_info_if_supremum(block, heap_no, mode);
+
        /* We try a simplified and faster subroutine for the most
        common cases */
        switch (lock_rec_lock_fast(impl, mode, block, heap_no, index, thr)) {

=================patch=============================


This patch outputs some info to error log on supremum page lock.

Then I modified the above test case, just added header, footer and the ability to change isolation level:


====================test=========================
--source include/master-slave.inc
--source include/have_innodb.inc
--source include/have_binlog_format_mixed.inc

#--let $isolation_level=REPEATABLE READ
--let $isolation_level=READ COMMITTED

--connection slave

--eval SET TRANSACTION ISOLATION LEVEL $isolation_level;

--connection master

--eval SET TRANSACTION ISOLATION LEVEL $isolation_level;

CREATE TABLE t1 (t1_pk DECIMAL(20,0) PRIMARY KEY , t1_blob BLOB) ENGINE=InnoDB;

INSERT INTO t1 VALUES (10000, REPEAT("a", 2165));
INSERT INTO t1 VALUES (20000, REPEAT("a", 2165));
INSERT INTO t1 VALUES (30000, REPEAT("a", 2165));
INSERT INTO t1 VALUES (40000, REPEAT("a", 2165));
INSERT INTO t1 VALUES (50000, REPEAT("a", 2165));
INSERT INTO t1 VALUES (60000, REPEAT("a", 2165));
INSERT INTO t1 VALUES (70000, REPEAT("a", 2165));
INSERT INTO t1 VALUES (80000, REPEAT("a", 2165));
INSERT INTO t1 VALUES (90000, REPEAT("a", 2165));
INSERT INTO t1 VALUES (100000, REPEAT("a", 2165));
INSERT INTO t1 VALUES (110000, REPEAT("a", 2165));
INSERT INTO t1 VALUES (120000, REPEAT("a", 2165));
INSERT INTO t1 VALUES (130000, REPEAT("a", 2165));
INSERT INTO t1 VALUES (140000, REPEAT("a", 2165));
INSERT INTO t1 VALUES (150000, REPEAT("a", 2165));
INSERT INTO t1 VALUES (160000, REPEAT("a", 2165));
INSERT INTO t1 VALUES (170000, REPEAT("a", 2165));
INSERT INTO t1 VALUES (180000, REPEAT("a", 2165));
INSERT INTO t1 VALUES (190000, REPEAT("a", 2165));
INSERT INTO t1 VALUES (200000, REPEAT("a", 2165));
INSERT INTO t1 VALUES (210000, REPEAT("a", 2165));

DELETE FROM t1 WHERE t1_pk IN (90000, 80000);

CREATE TABLE t2 (t2_pk INT PRIMARY KEY, t1_pk DECIMAL(20,0),
  FOREIGN KEY (t1_pk) REFERENCES t1 (t1_pk)) ENGINE=InnoDB;

--connect(con2,localhost,root)
XA START '2';
INSERT INTO t1 VALUES (85000, NULL);

#-- We are inserting a value between 80000,100000

--connection master
XA START '1';
INSERT INTO t2 VALUES (1, 100000);

#-- This causes an S lock on 100000

XA END '1';
XA PREPARE '1';

--connection con2
XA END '2';
XA PREPARE '2';

--connection con2
XA COMMIT '2';

--connection master
XA COMMIT '1';

--sync_slave_with_master

--connection master
DROP TABLE t2;
DROP TABLE t1;

--source include/rpl_end.inc
======================test=============================

My goal was to see what supremum's are locked for the following options:

"binlog_format=MIXED, tx_isolation=READ COMMITTED : the events will be logged in RBR and replication will not break. There will be no supremum pseudo-record S locks"

I use the following command line to run the test:

./mtr --force --max-test-fail=1 --parallel=1 --debug-server lp-1735555

to see the output of the injected code the following commands can be used:

echo "master"; fgrep '>>>>>>>>' var/log/mysqld.1.err; echo "slave"; fgrep '>>>>>>>>' var/log/mysqld.2.err

The "lock-wait-timeout" error is not stable. I can repeat it only with mtr --repeat=20 options, so usually the first several times the test finished with success and then fails.


The output which I see for the "success" case:

============success output====================
master
2017-12-12T16:41:12.187081Z 0 [Note] InnoDB: >>>>>>>> supremum is locked for page 11, mode 3, query:
2017-12-12T16:41:12.261063Z 0 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 2, query:
2017-12-12T16:41:12.278305Z 0 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 2, query:
2017-12-12T16:41:12.278400Z 0 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 2, query:
2017-12-12T16:41:12.285368Z 0 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 2, query:
2017-12-12T16:41:12.285997Z 0 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 2, query:
2017-12-12T16:41:12.286218Z 0 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 2, query:
2017-12-12T16:41:12.287009Z 0 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 2, query:
2017-12-12T16:41:12.287344Z 0 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 2, query:
2017-12-12T16:41:12.589188Z 5 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: RESET MASTER
2017-12-12T16:41:12.669696Z 8 [Note] InnoDB: >>>>>>>> supremum is locked for page 276, mode 3, query: CREATE TABLE t1 (t1_pk DECIMAL(20,0) PRIMARY KEY , t1_blob BLOB) ENGINE=InnoDB
2017-12-12T16:41:12.669762Z 8 [Note] InnoDB: >>>>>>>> supremum is locked for page 275, mode 3, query: CREATE TABLE t1 (t1_pk DECIMAL(20,0) PRIMARY KEY , t1_blob BLOB) ENGINE=InnoDB
2017-12-12T16:41:12.670909Z 8 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: CREATE TABLE t1 (t1_pk DECIMAL(20,0) PRIMARY KEY , t1_blob BLOB) ENGINE=InnoDB
2017-12-12T16:41:12.671303Z 8 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: CREATE TABLE t1 (t1_pk DECIMAL(20,0) PRIMARY KEY , t1_blob BLOB) ENGINE=InnoDB
2017-12-12T16:41:12.671503Z 8 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: CREATE TABLE t1 (t1_pk DECIMAL(20,0) PRIMARY KEY , t1_blob BLOB) ENGINE=InnoDB
2017-12-12T16:41:12.671672Z 8 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: CREATE TABLE t1 (t1_pk DECIMAL(20,0) PRIMARY KEY , t1_blob BLOB) ENGINE=InnoDB
2017-12-12T16:41:12.674200Z 0 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query:
2017-12-12T16:41:12.675444Z 0 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query:
2017-12-12T16:41:12.687507Z 8 [Note] InnoDB: >>>>>>>> supremum is locked for page 276, mode 3, query: CREATE TABLE t2 (t2_pk INT PRIMARY KEY, t1_pk DECIMAL(20,0),
2017-12-12T16:41:12.687559Z 8 [Note] InnoDB: >>>>>>>> supremum is locked for page 275, mode 3, query: CREATE TABLE t2 (t2_pk INT PRIMARY KEY, t1_pk DECIMAL(20,0),
2017-12-12T16:41:12.689312Z 8 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: CREATE TABLE t2 (t2_pk INT PRIMARY KEY, t1_pk DECIMAL(20,0),
2017-12-12T16:41:12.689918Z 8 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: CREATE TABLE t2 (t2_pk INT PRIMARY KEY, t1_pk DECIMAL(20,0),
2017-12-12T16:41:12.690100Z 8 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: CREATE TABLE t2 (t2_pk INT PRIMARY KEY, t1_pk DECIMAL(20,0),
2017-12-12T16:41:12.690266Z 8 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: CREATE TABLE t2 (t2_pk INT PRIMARY KEY, t1_pk DECIMAL(20,0),
2017-12-12T16:41:12.690429Z 8 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: CREATE TABLE t2 (t2_pk INT PRIMARY KEY, t1_pk DECIMAL(20,0),
2017-12-12T16:41:12.690590Z 8 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: CREATE TABLE t2 (t2_pk INT PRIMARY KEY, t1_pk DECIMAL(20,0),
2017-12-12T16:41:12.690755Z 8 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: CREATE TABLE t2 (t2_pk INT PRIMARY KEY, t1_pk DECIMAL(20,0),
2017-12-12T16:41:12.690940Z 8 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: CREATE TABLE t2 (t2_pk INT PRIMARY KEY, t1_pk DECIMAL(20,0),
2017-12-12T16:41:12.693330Z 8 [Note] InnoDB: >>>>>>>> supremum is locked for page 5, mode 2, query: INSERT INTO t2 VALUES (1, 100000)
2017-12-12T16:41:12.701107Z 8 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: DROP TABLE t2
2017-12-12T16:41:12.701976Z 8 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: DROP TABLE t2
2017-12-12T16:41:12.702763Z 8 [Note] InnoDB: >>>>>>>> supremum is locked for page 273, mode 3, query: DROP TABLE t2
2017-12-12T16:41:12.702951Z 8 [Note] InnoDB: >>>>>>>> supremum is locked for page 270, mode 3, query: DROP TABLE t2
2017-12-12T16:41:12.702981Z 8 [Note] InnoDB: >>>>>>>> supremum is locked for page 271, mode 2, query: DROP TABLE t2
2017-12-12T16:41:12.703453Z 8 [Note] InnoDB: >>>>>>>> supremum is locked for page 11, mode 2, query: DROP TABLE t2
2017-12-12T16:41:12.703563Z 8 [Note] InnoDB: >>>>>>>> supremum is locked for page 12, mode 3, query: DROP TABLE t2
2017-12-12T16:41:12.703843Z 8 [Note] InnoDB: >>>>>>>> supremum is locked for page 11, mode 3, query: DROP TABLE t2
2017-12-12T16:41:12.704024Z 8 [Note] InnoDB: >>>>>>>> supremum is locked for page 10, mode 3, query: DROP TABLE t2
2017-12-12T16:41:12.704184Z 8 [Note] InnoDB: >>>>>>>> supremum is locked for page 8, mode 3, query: DROP TABLE t2
2017-12-12T16:41:12.704297Z 8 [Note] InnoDB: >>>>>>>> supremum is locked for page 275, mode 3, query: DROP TABLE t2
2017-12-12T16:41:12.704404Z 8 [Note] InnoDB: >>>>>>>> supremum is locked for page 276, mode 3, query: DROP TABLE t2
2017-12-12T16:41:12.704905Z 8 [Note] InnoDB: >>>>>>>> supremum is locked for page 278, mode 3, query: DROP TABLE t2
2017-12-12T16:41:12.705060Z 8 [Note] InnoDB: >>>>>>>> supremum is locked for page 282, mode 3, query: DROP TABLE t2
2017-12-12T16:41:12.706013Z 8 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: DROP TABLE t1
2017-12-12T16:41:12.708205Z 8 [Note] InnoDB: >>>>>>>> supremum is locked for page 278, mode 3, query: DROP TABLE t1
2017-12-12T16:41:12.708294Z 8 [Note] InnoDB: >>>>>>>> supremum is locked for page 282, mode 3, query: DROP TABLE t1
slave
2017-12-12T16:41:12.223650Z 0 [Note] InnoDB: >>>>>>>> supremum is locked for page 11, mode 3, query: 
2017-12-12T16:41:12.245553Z 0 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 2, query: 
2017-12-12T16:41:12.262189Z 0 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 2, query: 
2017-12-12T16:41:12.262285Z 0 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 2, query: 
2017-12-12T16:41:12.276356Z 0 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 2, query: 
2017-12-12T16:41:12.276998Z 0 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 2, query: 
2017-12-12T16:41:12.277220Z 0 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 2, query:
2017-12-12T16:41:12.277951Z 0 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 2, query:
2017-12-12T16:41:12.278186Z 0 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 2, query:
2017-12-12T16:41:12.577703Z 4 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: RESET MASTER
2017-12-12T16:41:12.673576Z 7 [Note] InnoDB: >>>>>>>> supremum is locked for page 276, mode 3, query: CREATE TABLE t1 (t1_pk DECIMAL(20,0) PRIMARY KEY , t1_blob BLOB) ENGINE=InnoDB
2017-12-12T16:41:12.673633Z 7 [Note] InnoDB: >>>>>>>> supremum is locked for page 275, mode 3, query: CREATE TABLE t1 (t1_pk DECIMAL(20,0) PRIMARY KEY , t1_blob BLOB) ENGINE=InnoDB
2017-12-12T16:41:12.674627Z 7 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: CREATE TABLE t1 (t1_pk DECIMAL(20,0) PRIMARY KEY , t1_blob BLOB) ENGINE=InnoDB
2017-12-12T16:41:12.674935Z 7 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: CREATE TABLE t1 (t1_pk DECIMAL(20,0) PRIMARY KEY , t1_blob BLOB) ENGINE=InnoDB
2017-12-12T16:41:12.675133Z 7 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: CREATE TABLE t1 (t1_pk DECIMAL(20,0) PRIMARY KEY , t1_blob BLOB) ENGINE=InnoDB
2017-12-12T16:41:12.675337Z 7 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: CREATE TABLE t1 (t1_pk DECIMAL(20,0) PRIMARY KEY , t1_blob BLOB) ENGINE=InnoDB
2017-12-12T16:41:12.678018Z 0 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query:
2017-12-12T16:41:12.680092Z 0 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query:
2017-12-12T16:41:12.692699Z 7 [Note] InnoDB: >>>>>>>> supremum is locked for page 276, mode 3, query: CREATE TABLE t2 (t2_pk INT PRIMARY KEY, t1_pk DECIMAL(20,0),
2017-12-12T16:41:12.692752Z 7 [Note] InnoDB: >>>>>>>> supremum is locked for page 275, mode 3, query: CREATE TABLE t2 (t2_pk INT PRIMARY KEY, t1_pk DECIMAL(20,0),
2017-12-12T16:41:12.694810Z 7 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: CREATE TABLE t2 (t2_pk INT PRIMARY KEY, t1_pk DECIMAL(20,0),
2017-12-12T16:41:12.695570Z 7 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: CREATE TABLE t2 (t2_pk INT PRIMARY KEY, t1_pk DECIMAL(20,0),
2017-12-12T16:41:12.695782Z 7 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: CREATE TABLE t2 (t2_pk INT PRIMARY KEY, t1_pk DECIMAL(20,0),
2017-12-12T16:41:12.695954Z 7 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: CREATE TABLE t2 (t2_pk INT PRIMARY KEY, t1_pk DECIMAL(20,0),
2017-12-12T16:41:12.696124Z 7 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: CREATE TABLE t2 (t2_pk INT PRIMARY KEY, t1_pk DECIMAL(20,0),
2017-12-12T16:41:12.696295Z 7 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: CREATE TABLE t2 (t2_pk INT PRIMARY KEY, t1_pk DECIMAL(20,0),
2017-12-12T16:41:12.696464Z 7 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: CREATE TABLE t2 (t2_pk INT PRIMARY KEY, t1_pk DECIMAL(20,0),
2017-12-12T16:41:12.696635Z 7 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: CREATE TABLE t2 (t2_pk INT PRIMARY KEY, t1_pk DECIMAL(20,0),
2017-12-12T16:41:12.698486Z 7 [Note] InnoDB: >>>>>>>> supremum is locked for page 5, mode 2, query: INSERT INTO t2 VALUES (1, 100000)
2017-12-12T16:41:12.706262Z 7 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: DROP TABLE `t2` /* generated by server */
2017-12-12T16:41:12.707094Z 7 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: DROP TABLE `t2` /* generated by server */
2017-12-12T16:41:12.708259Z 7 [Note] InnoDB: >>>>>>>> supremum is locked for page 273, mode 3, query: DROP TABLE `t2` /* generated by server */
2017-12-12T16:41:12.708444Z 7 [Note] InnoDB: >>>>>>>> supremum is locked for page 270, mode 3, query: DROP TABLE `t2` /* generated by server */
2017-12-12T16:41:12.708474Z 7 [Note] InnoDB: >>>>>>>> supremum is locked for page 271, mode 2, query: DROP TABLE `t2` /* generated by server */
2017-12-12T16:41:12.708916Z 7 [Note] InnoDB: >>>>>>>> supremum is locked for page 11, mode 2, query: DROP TABLE `t2` /* generated by server */
2017-12-12T16:41:12.709023Z 7 [Note] InnoDB: >>>>>>>> supremum is locked for page 12, mode 3, query: DROP TABLE `t2` /* generated by server */
2017-12-12T16:41:12.709298Z 7 [Note] InnoDB: >>>>>>>> supremum is locked for page 11, mode 3, query: DROP TABLE `t2` /* generated by server */
2017-12-12T16:41:12.709487Z 7 [Note] InnoDB: >>>>>>>> supremum is locked for page 10, mode 3, query: DROP TABLE `t2` /* generated by server */
2017-12-12T16:41:12.709645Z 7 [Note] InnoDB: >>>>>>>> supremum is locked for page 8, mode 3, query: DROP TABLE `t2` /* generated by server */
2017-12-12T16:41:12.709757Z 7 [Note] InnoDB: >>>>>>>> supremum is locked for page 275, mode 3, query: DROP TABLE `t2` /* generated by server */
2017-12-12T16:41:12.709863Z 7 [Note] InnoDB: >>>>>>>> supremum is locked for page 276, mode 3, query: DROP TABLE `t2` /* generated by server */
2017-12-12T16:41:12.709954Z 7 [Note] InnoDB: >>>>>>>> supremum is locked for page 278, mode 3, query: DROP TABLE `t2` /* generated by server */
2017-12-12T16:41:12.710093Z 7 [Note] InnoDB: >>>>>>>> supremum is locked for page 282, mode 3, query: DROP TABLE `t2` /* generated by server */
2017-12-12T16:41:12.710980Z 7 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: DROP TABLE `t1` /* generated by server */
2017-12-12T16:41:12.713121Z 7 [Note] InnoDB: >>>>>>>> supremum is locked for page 278, mode 3, query: DROP TABLE `t1` /* generated by server */
2017-12-12T16:41:12.713208Z 7 [Note] InnoDB: >>>>>>>> supremum is locked for page 282, mode 3, query: DROP TABLE `t1` /* generated by server */
=======================success output=========================

i.e. there is no S-lock for "INSERT INTO t2..." statement.

The output for the fail is the following:

=====================fail output==========
master
2017-12-12T16:45:08.126593Z 0 [Note] InnoDB: >>>>>>>> supremum is locked for page 11, mode 3, query:
2017-12-12T16:45:08.197859Z 0 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 2, query:
2017-12-12T16:45:08.214508Z 0 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 2, query:
2017-12-12T16:45:08.214603Z 0 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 2, query: 
2017-12-12T16:45:08.221567Z 0 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 2, query: 
2017-12-12T16:45:08.222197Z 0 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 2, query: 
2017-12-12T16:45:08.222418Z 0 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 2, query: 
2017-12-12T16:45:08.223052Z 0 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 2, query: 
2017-12-12T16:45:08.223307Z 0 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 2, query: 
2017-12-12T16:45:08.558970Z 5 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: RESET MASTER
2017-12-12T16:45:08.638371Z 8 [Note] InnoDB: >>>>>>>> supremum is locked for page 276, mode 3, query: CREATE TABLE t1 (t1_pk DECIMAL(20,0) PRIMARY KEY , t1_blob BLOB) ENGINE=InnoDB
2017-12-12T16:45:08.638428Z 8 [Note] InnoDB: >>>>>>>> supremum is locked for page 275, mode 3, query: CREATE TABLE t1 (t1_pk DECIMAL(20,0) PRIMARY KEY , t1_blob BLOB) ENGINE=InnoDB
2017-12-12T16:45:08.639399Z 8 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: CREATE TABLE t1 (t1_pk DECIMAL(20,0) PRIMARY KEY , t1_blob BLOB) ENGINE=InnoDB
2017-12-12T16:45:08.639686Z 8 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: CREATE TABLE t1 (t1_pk DECIMAL(20,0) PRIMARY KEY , t1_blob BLOB) ENGINE=InnoDB
2017-12-12T16:45:08.639914Z 8 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: CREATE TABLE t1 (t1_pk DECIMAL(20,0) PRIMARY KEY , t1_blob BLOB) ENGINE=InnoDB
2017-12-12T16:45:08.640079Z 8 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: CREATE TABLE t1 (t1_pk DECIMAL(20,0) PRIMARY KEY , t1_blob BLOB) ENGINE=InnoDB
2017-12-12T16:45:08.642214Z 0 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: 
2017-12-12T16:45:08.644236Z 0 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: 
2017-12-12T16:45:08.656225Z 8 [Note] InnoDB: >>>>>>>> supremum is locked for page 276, mode 3, query: CREATE TABLE t2 (t2_pk INT PRIMARY KEY, t1_pk DECIMAL(20,0),
2017-12-12T16:45:08.656277Z 8 [Note] InnoDB: >>>>>>>> supremum is locked for page 275, mode 3, query: CREATE TABLE t2 (t2_pk INT PRIMARY KEY, t1_pk DECIMAL(20,0),
2017-12-12T16:45:08.658070Z 8 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: CREATE TABLE t2 (t2_pk INT PRIMARY KEY, t1_pk DECIMAL(20,0),
2017-12-12T16:45:08.658678Z 8 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: CREATE TABLE t2 (t2_pk INT PRIMARY KEY, t1_pk DECIMAL(20,0),
2017-12-12T16:45:08.658880Z 8 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: CREATE TABLE t2 (t2_pk INT PRIMARY KEY, t1_pk DECIMAL(20,0),
2017-12-12T16:45:08.659045Z 8 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: CREATE TABLE t2 (t2_pk INT PRIMARY KEY, t1_pk DECIMAL(20,0),
2017-12-12T16:45:08.659235Z 8 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: CREATE TABLE t2 (t2_pk INT PRIMARY KEY, t1_pk DECIMAL(20,0),
2017-12-12T16:45:08.659414Z 8 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: CREATE TABLE t2 (t2_pk INT PRIMARY KEY, t1_pk DECIMAL(20,0),
2017-12-12T16:45:08.659607Z 8 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: CREATE TABLE t2 (t2_pk INT PRIMARY KEY, t1_pk DECIMAL(20,0),
2017-12-12T16:45:08.659798Z 8 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: CREATE TABLE t2 (t2_pk INT PRIMARY KEY, t1_pk DECIMAL(20,0),
2017-12-12T16:45:08.662233Z 8 [Note] InnoDB: >>>>>>>> supremum is locked for page 5, mode 2, query: INSERT INTO t2 VALUES (1, 100000)
slave
2017-12-12T16:45:08.158843Z 0 [Note] InnoDB: >>>>>>>> supremum is locked for page 11, mode 3, query: 
2017-12-12T16:45:08.234648Z 0 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 2, query: 
2017-12-12T16:45:08.251726Z 0 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 2, query: 
2017-12-12T16:45:08.251825Z 0 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 2, query: 
2017-12-12T16:45:08.259350Z 0 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 2, query: 
2017-12-12T16:45:08.260019Z 0 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 2, query: 
2017-12-12T16:45:08.260250Z 0 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 2, query: 
2017-12-12T16:45:08.260913Z 0 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 2, query: 
2017-12-12T16:45:08.261148Z 0 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 2, query: 
2017-12-12T16:45:08.547449Z 4 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: RESET MASTER
2017-12-12T16:45:08.642087Z 7 [Note] InnoDB: >>>>>>>> supremum is locked for page 276, mode 3, query: CREATE TABLE t1 (t1_pk DECIMAL(20,0) PRIMARY KEY , t1_blob BLOB) ENGINE=InnoDB
2017-12-12T16:45:08.642143Z 7 [Note] InnoDB: >>>>>>>> supremum is locked for page 275, mode 3, query: CREATE TABLE t1 (t1_pk DECIMAL(20,0) PRIMARY KEY , t1_blob BLOB) ENGINE=InnoDB
2017-12-12T16:45:08.643216Z 7 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: CREATE TABLE t1 (t1_pk DECIMAL(20,0) PRIMARY KEY , t1_blob BLOB) ENGINE=InnoDB
2017-12-12T16:45:08.643555Z 7 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: CREATE TABLE t1 (t1_pk DECIMAL(20,0) PRIMARY KEY , t1_blob BLOB) ENGINE=InnoDB
2017-12-12T16:45:08.643748Z 7 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: CREATE TABLE t1 (t1_pk DECIMAL(20,0) PRIMARY KEY , t1_blob BLOB) ENGINE=InnoDB
2017-12-12T16:45:08.643952Z 7 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: CREATE TABLE t1 (t1_pk DECIMAL(20,0) PRIMARY KEY , t1_blob BLOB) ENGINE=InnoDB
2017-12-12T16:45:08.646202Z 0 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query:
2017-12-12T16:45:08.648104Z 0 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query:
2017-12-12T16:45:08.661656Z 7 [Note] InnoDB: >>>>>>>> supremum is locked for page 276, mode 3, query: CREATE TABLE t2 (t2_pk INT PRIMARY KEY, t1_pk DECIMAL(20,0),
2017-12-12T16:45:08.661717Z 7 [Note] InnoDB: >>>>>>>> supremum is locked for page 275, mode 3, query: CREATE TABLE t2 (t2_pk INT PRIMARY KEY, t1_pk DECIMAL(20,0),
2017-12-12T16:45:08.664067Z 7 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: CREATE TABLE t2 (t2_pk INT PRIMARY KEY, t1_pk DECIMAL(20,0),
2017-12-12T16:45:08.664780Z 7 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: CREATE TABLE t2 (t2_pk INT PRIMARY KEY, t1_pk DECIMAL(20,0),
2017-12-12T16:45:08.665053Z 7 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: CREATE TABLE t2 (t2_pk INT PRIMARY KEY, t1_pk DECIMAL(20,0),
2017-12-12T16:45:08.665225Z 7 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: CREATE TABLE t2 (t2_pk INT PRIMARY KEY, t1_pk DECIMAL(20,0),
2017-12-12T16:45:08.665401Z 7 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: CREATE TABLE t2 (t2_pk INT PRIMARY KEY, t1_pk DECIMAL(20,0),
2017-12-12T16:45:08.665576Z 7 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: CREATE TABLE t2 (t2_pk INT PRIMARY KEY, t1_pk DECIMAL(20,0),
2017-12-12T16:45:08.665741Z 7 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: CREATE TABLE t2 (t2_pk INT PRIMARY KEY, t1_pk DECIMAL(20,0),
2017-12-12T16:45:08.665903Z 7 [Note] InnoDB: >>>>>>>> supremum is locked for page 3, mode 3, query: CREATE TABLE t2 (t2_pk INT PRIMARY KEY, t1_pk DECIMAL(20,0),
2017-12-12T16:45:08.667206Z 7 [Note] InnoDB: >>>>>>>> supremum is locked for page 5, mode 2, query: INSERT INTO t2 VALUES (1, 100000)
========================fail output===========================

Here we can see supremum S-lock, but I don't see supremum X-lock. Probably the fail or success depends on data layout inside the page and we need more determinate test case.