innodb_fts.sync_block test unstable due to slow query log nondeterminism
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
MySQL Server |
Unknown
|
Unknown
|
||||
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.5 |
Invalid
|
Undecided
|
Unassigned | |||
5.6 |
Fix Released
|
Low
|
Laurynas Biveinis | |||
5.7 |
Fix Released
|
Low
|
Laurynas Biveinis |
Bug Description
Copy of https:/
innodb_
...
--- /mnt/workspace/
+++ /mnt/workspace/
@@ -30,6 +30,11 @@
# slow log results should only contain INSERT INTO t1.
SELECT sql_text FROM mysql.slow_log WHERE query_time >= '00:00:02';
sql_text
+CREATE TABLE t1 (
+FTS_DOC_ID BIGINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
+title VARCHAR(200),
+FULLTEXT(title)
+) ENGINE = InnoDB
INSERT INTO t1(title) VALUES('mysql database')
SET GLOBAL debug="
TRUNCATE TABLE mysql.slow_log;
@@ -56,6 +61,11 @@
# slow log results should be empty here.
SELECT sql_text FROM mysql.slow_log WHERE query_time >= '00:00:02';
sql_text
+CREATE TABLE t1 (
+FTS_DOC_ID BIGINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
+title VARCHAR(200),
+FULLTEXT(title)
+) ENGINE = InnoDB
SET GLOBAL debug="
TRUNCATE TABLE mysql.slow_log;
DROP TABLE t1,t2;
tags: | added: ci upstream |
https:/ /github. com/percona/ percona- server/ pull/1374 /github. com/percona/ percona- server/ pull/1375
https:/