Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
N/A
-
None
Description
The following testcase:
USE test; |
INSTALL PLUGIN spider SONAME 'ha_spider.so'; |
CREATE USER spider@localhost IDENTIFIED BY ''; |
SHOW CREATE SERVER srv; |
CREATE SERVER s3 FOREIGN DATA WRAPPER mysql OPTIONS (HOST 'localhost', PORT 3307); |
SHOW CREATE SERVER srv; |
SELECT * FROM mysql.servers; |
ALTER SERVER s3 OPTIONS (HOST '192.168.0.3', PORT 3306); |
CREATE OR REPLACE SERVER srv FOREIGN DATA WRAPPER foo OPTIONS (HOST "LOCALHOST", PORT "12345"); |
DROP SERVER s5000; |
CREATE TABLE t1_s3 (c INT) ENGINE=Spider COMMENT='WRAPPER "mysql", SRV "s3", TABLE "t2"'; |
SHOW CREATE SERVER srv; |
Will hang, very sporadically. Reduction has proven challeging given delay in waiting for hangs combined with high sporadicity.
ycp Work is ongoing on attempting to get a better testcase, but perhaps you may know where the issue could be in the code and double check?
Trying to run the testcase as provided is guaranteed to fail: time between occurences can be 8+ hours, even with many threads.