Unstable tests fullstack-test2/ddl/flashback/flashback_database.test

[JaySon-Huang]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

2. What did you expect to see? (Required)

3. What did you see instead (Required)

[2023-12-12T13:23:18.666Z] fullstack-test2/ddl/flashback/flashback_database.test: Running
[2023-12-12T13:23:33.477Z]   File: fullstack-test2/ddl/flashback/flashback_database.test
[2023-12-12T13:23:33.477Z]   Error line: 115
[2023-12-12T13:23:33.477Z]   Error: set session tidb_isolation_read_engines='tiflash'; select * from d1_new.t1 order by a;
[2023-12-12T13:23:33.477Z]   Result:
[2023-12-12T13:23:33.477Z]     <nothing>
[2023-12-12T13:23:33.477Z]   Expected:
[2023-12-12T13:23:33.477Z]     +------+------+
[2023-12-12T13:23:33.477Z]     | a    | b    |
[2023-12-12T13:23:33.477Z]     +------+------+
[2023-12-12T13:23:33.477Z]     |    1 | NULL |
[2023-12-12T13:23:33.477Z]     |    2 |    2 |
[2023-12-12T13:23:33.477Z]     +------+------+

https://ci.pingcap.net/job/tiflash-ghpr-integration-tests/15401/artifact/fullstack-test2-logs.tar.gz
https://ci.pingcap.net/job/tiflash-ghpr-integration-tests/15396/artifact/fullstack-test2-logs.tar.gz

4. What is your TiFlash version? (Required)

master

ref #8450

[JaySon-Huang]

[2023-12-15T08:10:44.558Z]   File: fullstack-test2/ddl/flashback/flashback_database.test
[2023-12-15T08:10:44.559Z]   Error line: 162
[2023-12-15T08:10:44.559Z]   Error: set session tidb_isolation_read_engines='tiflash'; select * from d1_new.t2 order by id;
[2023-12-15T08:10:44.559Z]   Result:
[2023-12-15T08:10:44.559Z]     id   name    b
[2023-12-15T08:10:44.559Z]     1    abc NULL
[2023-12-15T08:10:44.559Z]     2    cde NULL
[2023-12-15T08:10:44.559Z]   Expected:
[2023-12-15T08:10:44.559Z]     +----+------+------+
[2023-12-15T08:10:44.559Z]     | id | name | b    |
[2023-12-15T08:10:44.559Z]     +----+------+------+
[2023-12-15T08:10:44.559Z]     |  1 | abc  | NULL |
[2023-12-15T08:10:44.559Z]     |  2 | cde  | NULL |
[2023-12-15T08:10:44.559Z]     | 53 | efg  | NULL |
[2023-12-15T08:10:44.559Z]     +----+------+------+

https://ci.pingcap.net/blue/organizations/jenkins/tiflash-ghpr-integration-tests/detail/tiflash-ghpr-integration-tests/15471/pipeline/121

[JaySon-Huang]

Reopen because it meets another corner case:

"Create database" and "Region snapshot" come after the database has been dropped.