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.
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| Link |
This issue is caused by |
| Link | This issue relates to TODO-3120 [ TODO-3120 ] |
| Link |
This issue is caused by |
| Assignee | Yuchen Pei [ JIRAUSER52627 ] | Roel Van de Paar [ roel ] |
| Summary |
Highly sporadic hang, likely on SHOW CREATE SERVER with |
Highly sporadic hang, likely on SHOW CREATE SERVER |
| Description |
The following testcase:
{code:sql} 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; {code} Which has grammar only compatible after [~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. |
The following testcase:
{code:sql} 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; {code} 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. |