Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[Bug]: "Error 20503 (HY000): stream closed" #10604

Closed
1 task done
xuoutput opened this issue Jul 12, 2023 · 44 comments
Closed
1 task done

[Bug]: "Error 20503 (HY000): stream closed" #10604

xuoutput opened this issue Jul 12, 2023 · 44 comments
Assignees
@daviszhen
Labels
kind/bug Something isn't working needs-triage severity/s0 Extreme impact: Cause the application to break down and seriously affect the use
Milestone
1.1.0

Comments

@xuoutput
Copy link

xuoutput commented Jul 12, 2023 •
edited
Loading

Is there an existing issue for the same bug?

  • I have checked the existing issues.

Environment

- Version or commit-id (nightly-8911e24d):
- Hardware parameters:
- OS type:
- Others:

Actual Behavior

Encountered an error when importing data from AliCloud

drop table if exists t1;
create table t1(
clo1 tinyint,
clo2 smallint,
clo3 int,
clo4 bigint,
clo5 tinyint unsigned,
clo6 smallint unsigned,
clo7 int unsigned,
clo8 bigint unsigned,
col9 float,
col10 double,
col11 varchar(255),
col12 Date,
col13 DateTime,
col14 timestamp,
col15 bool,
col16 decimal(5,2),
col17 text,
col18 json,
col19 blob,
col20 binary(255),
col21 varbinary(255)
);

load data url s3option {"bucket"='hx-load-data',"filepath"='1w_20_columns_load_data.csv',"access_key_id"="xxx","secret_access_key"="xx","compression"="auto","endpoint"='oss-cn-shanghai.aliyuncs.com',} into table hx1.t1 FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' PARALLEL "TRUE";

response

{
    "code": "OK",
    "msg": "OK",
    "data": {
        "statement_id": "aefdd596-2077-11ee-be0d-f280ed056939",
        "db_name": "hx1",
        "status": "failed",
        "err_msg": "Error 20503 (HY000): stream closed"
    },
    "request_id": "cfb17950-bf14-4eab-887d-1f8b6318643f"
}

数据demo

-36,2252,1648548068,-5223094309310121545,52,16542,1377996574,8416373688230771983,2.9442,6.9561,"/MN?OPQR.STU-_+=VWXYZabcdefghigklmnopqrstuvwxyz012345678","7169-08-26","7392-02-09 14:33:13","1973-06-26 16:29:34","false","121.98","ABCDEF,GHI,G;KL/MN?OPQR.STU-_+=VWXYZabcd",{"k57781": "57781"},"ghigklmnopqrst","12","lmn"
98,8382,-829027812,9200483975135707231,125,47186,1884448149,14268488301280820815,1.3860,8.4781,"-_+=VWXYZabcdefghigklmnopqrstuvwxyz01234","8251-04-13","4408-11-11 15:48:50","2000-12-17 08:45:39","false","291.83","U-_+=VWXYZabcdefghigklmnopqr",{"k34806": "34806"},"klmnopqr","45","mno"
-53,-29338,-2090889803,-1507737132599558737,65,6170,1619810558,10707841513899819543,7.0604,2.7388,",GHI,G;KL/MN?OPQR.STU-_+=","2351-06-20","1208-04-23 17:05:06","1989-07-30 06:46:23","false","983.12","/MN?OPQR.STU-_+=VWXYZabcdefghigklm",{"k64671": "64671"},"igklm","12","rst"
-121,-12017,619240806,-4850516862685882693,185,40656,3855567954,7415464745388155563,3.0890,8.8580,"STU-_+=","3887-10-14","1945-07-23 13:12:46","2035-10-07 10:06:45","false","203.02","MN?OPQR.STU-_+=VWXYZabcdefghigklmnopqrstuvwxyz012345678",{"k86785": "86785"},"higklm","34","cde"
-53,-20481,-507717694,-8412147987550541692,142,46539,1157765274,6493421613884864069,3.9728,7.5923,"CDEF,GHI,G;KL/MN?OPQR.STU-_+=VWXYZabcdefghigklmnopqrstuvwxyz012","6543-04-28","4234-09-12 10:50:05","1982-02-04 01:01:34","true","404.26","MN?OPQR.STU-_+=VWXYZabcdefghigklmnopqrst",{"k86335": "86335"},"higklmnop","12","def"
35,17564,540876293,-5871980562095064599,142,12827,1252401855,9353859604194041779,4.6342,7.5964,"QR.STU-_+=VWXYZabcdefghigklmnopqrstuvwxyz012","7449-02-03","6555-10-08 12:08:49","1995-06-04 19:25:53","true","685.41","_+=VWXYZabcdefghigklmn",{"k12936": "12936"},"higklmno","34","pqr"
-68,-16387,1082584279,37181637747877057,220,54251,415085421,232874395819505019,1.6568,2.7844,"_+=VWXYZabcdefghigklm","1279-01-21","7544-12-02 15:04:03","2004-05-01 19:26:00","true","100.69","STU-_+=VWXYZab",{"k84882": "84882"},"klmnopqrstuvwxy","67","ghi"
-43,-10158,59662402,936434042829987390,161,18119,3222705688,4478627362726455227,9.5259,8.0559,"KL/MN?OPQR.STU-_+=VWXYZabcdefghigklmnopqrstuvwxyz","2178-04-23","7606-02-26 11:38:44","1984-12-18 12:07:16","true","502.68","L/MN?OPQR.STU-_+=VWXYZabcdefghigklmno",{"k75948": "75948"},"gklmnop","34","lmn"
-36,5006,226715371,8453159872278765066,238,22432,1927422254,16250733743135201096,8.7503,6.3043,";KL/MN?OPQR.STU-_+=VWXYZabc","1015-01-14","2780-04-01 23:58:32","2025-12-14 21:15:10","false","737.45","+=VWXYZabcdefghigklmnopq",{"k88156": "88156"},"ghigklmnopqr","67","fgh"
56,-27775,-928833414,4737206696791615930,166,62564,3148474332,3530265430859828944,1.8764,1.9374,"MN?OPQR.STU-_+=VWXYZabcdefghigklmnopqrstuvwxyz0123456","4457-08-09","4911-12-03 00:29:08","1996-08-01 21:05:48","true","295.43","?OPQR.STU-_+=VWXYZabcdefghigklmnopqrs",{"k15994": "15994"},"higklmnopqrstu","34","klm"
7,21523,1907171137,-854498723181470507,186,28681,2350848388,6907383283129517099,7.6236,0.6180,"TU-_+=VWXYZabcdefghigklmnopq","1929-12-28","4166-07-31 21:31:35","1984-01-21 07:03:04","false","153.92","BCDEF,GHI,G;KL/MN?OPQR.STU-_+=VWXYZabcdefghigklmnopqrstu",{"k26282": "26282"},"ghigklmnopqrstu","67","abc"
-56,11371,-953093536,5544944336839060551,215,9834,1813489652,7085395978868865055,9.4906,7.5943,"/MN?OPQR.STU-_+=VWXYZabcdefgh","4591-12-18","3569-11-15 07:35:56","1997-12-14 07:24:07","true","982.05","/MN?OPQR.STU-_+=VWXYZabcdefghigklmnopqrstuvwxyz0123",{"k33771": "33771"},"fghigklmn","45","stu"
-15,-32461,-932268545,-7387055727089983570,153,63252,4239287505,8889945261381080252,6.5403,8.0739,"-_+=VWXY","3918-05-10","6701-01-09 17:14:21","2021-06-21 09:22:39","false","661.33","+=VWXYZabcdefghigklmnopqrstuvwxyz01234",{"k68129": "68129"},"ghigk","34","lmn"
29,17412,650487614,2984841256093477533,220,4447,742923087,363464835168682318,9.7840,5.4391,"TU-_+=VWXYZabcdefghi","8749-01-28","5137-06-23 14:54:28","1980-07-25 06:34:49","false","546.87",".STU-_+=VWXYZabcdefghigklmn",{"k13349": "13349"},"higklmnopq","23","abc"
-67,19663,-411260898,-8153689352206821121,157,64592,2764995014,18036330245094965725,4.3891,9.1096,".STU-_+=VWX","1897-08-11","9127-11-20 20:45:47","2012-12-15 10:16:31","true","148.20","/MN?OPQR.STU-_+=VWXYZabcdefghigklmnopqrstuvwxyz0123456",{"k10521": "10521"},"ghigklmnopqr","67","cde"
57,-16375,1309236647,-6831838970148491529,227,55128,772390271,12892009388852359279,5.5782,9.6961,"EF,GHI,G;KL/MN?OPQR.STU-_+=VWXYZabcdefghigklmnopqrstuv","5075-02-15","1747-04-20 13:01:52","2033-06-20 22:35:12","false","429.27","G;KL/MN?OPQR.STU-_+=VWXYZabcdefghigklmnopqrstuvwxyz0123456",{"k54290": "54290"},"igklmnopq","56","ghi"
104,23311,1544322979,9099042185003517162,159,1821,2097802099,8571135834299386992,6.5082,2.7486,"KL/MN?OPQR.STU-_+=VWXYZabcdefghi","2963-09-23","4628-03-26 17:39:30","2034-09-28 20:27:25","true","805.16","=VWXYZabcdefghigklmnopqrstuvwxyz",{"k28447": "28447"},"ghigklmnopqrs","67","gkl"
-77,-3368,90805563,-1645704659175497488,60,33958,341470073,657000604281234834,3.1884,3.8982,";KL/MN?OPQR.STU-_+=VWXYZabcdefghigklmnopqrstuv","5341-06-02","2327-05-11 16:33:36","2031-01-11 21:59:29","false","496.42","PQR.STU-_+=VWXYZa",{"k55854": "55854"},"gklmnopqrstuvw","34","rst"
-66,-13238,922255900,782418592585278058,125,23342,3622320026,5002214360205891844,1.6306,5.9424,"STU-_+=VWXYZabcdefghigklmnopqrstuvwxyz01234","4212-07-24","9188-05-13 20:18:40","2023-06-03 14:37:38","false","273.37","U-_+=VWXYZabcdefghigklmnopqrs",{"k74589": "74589"},"klmno","45","opq"
-38,32039,-285438924,2359057859181392955,8,56246,3750581886,3306382242612756026,5.1914,3.6087,"DEF,GHI,G;KL/MN?OPQR.STU-_+=VWXYZabcdef","6487-06-10","3038-05-14 08:36:46","2005-07-20 05:56:25","false","223.84","DEF,GHI,G;KL/MN?OPQR.STU-_+=VWXYZabcde",{"k31826": "31826"},"klmnopqr","23","klm"
-58,25596,1484982038,-4459154564064570013,69,61553,3130832717,3545110131231166298,6.6631,0.6343,"L/MN?OPQR.STU-_+=VWXYZabcdefghigk","7551-06-14","3522-01-20 08:56:14","2024-12-13 01:06:10","true","694.46","PQR.STU-_+=VWXYZabcdefgh",{"k96067": "96067"},"gklmnopqrstuvw","12","nop"
93,25873,1303437935,2785138527440086881,19,25497,1934634275,17651204729135866413,8.8488,8.7126,"DEF,GHI,G;KL/MN?OPQR.STU-_+=VWXYZabcdefghigkl","6235-06-14","1331-11-10 22:37:39","2031-09-20 20:51:31","false","773.28","G;KL/MN?OPQR.STU-_+=VWXYZabcdefghigk",{"k34611": "34611"},"fghigklmnopqr","45","klm"

Expected Behavior

query ok

Steps to Reproduce

No response

Additional information

No response
@xuoutput xuoutput added kind/bug Something isn't working needs-triage labels Jul 12, 2023
@DanielZhangQD DanielZhangQD added the severity/s0 Extreme impact: Cause the application to break down and seriously affect the use label Jul 12, 2023
@jianwan0214
Copy link
Contributor

还没看

@domingozhang domingozhang added this to the 1.0.0 milestone Jul 19, 2023
@daviszhen
Copy link
Contributor

还没看

@daviszhen
Copy link
Contributor

还在搞环境

1 similar comment
@daviszhen
Copy link
Contributor

还在搞环境

@daviszhen
Copy link
Contributor

今天没复现出来。

@daviszhen
Copy link
Contributor

今天没看

@daviszhen
Copy link
Contributor

还没看

6 similar comments
@daviszhen
Copy link
Contributor

还没看

@daviszhen
Copy link
Contributor

还没看

@daviszhen
Copy link
Contributor

还没看

@daviszhen
Copy link
Contributor

还没看

@daviszhen
Copy link
Contributor

还没看

@daviszhen
Copy link
Contributor

还没看

@daviszhen
Copy link
Contributor

需要一个访问oss-cn-shanghai.aliyuncs.com上面数据的key。

@daviszhen
Copy link
Contributor

接在10898 之后。

1 similar comment
@daviszhen
Copy link
Contributor

接在10898 之后。

@daviszhen
Copy link
Contributor

排在930/1117之后

@daviszhen
Copy link
Contributor

还没看

2 similar comments
@daviszhen
Copy link
Contributor

还没看

@daviszhen
Copy link
Contributor

还没看

@sukki37 sukki37 removed this from the 1.0.0 milestone Aug 18, 2023
@sukki37 sukki37 added this to the 1.1.0 milestone Aug 18, 2023
@daviszhen
Copy link
Contributor

等环境

1 similar comment
@daviszhen
Copy link
Contributor

daviszhen commented Aug 19, 2023 •
edited
Loading

等环境

@daviszhen
Copy link
Contributor

还没看

11 similar comments
@daviszhen
Copy link
Contributor

还没看

@daviszhen
Copy link
Contributor

还没看

@daviszhen
Copy link
Contributor

还没看

@daviszhen
Copy link
Contributor

还没看

@daviszhen
Copy link
Contributor

还没看

@daviszhen
Copy link
Contributor

还没看

@daviszhen
Copy link
Contributor

还没看

@daviszhen
Copy link
Contributor

还没看

@daviszhen
Copy link
Contributor

还没看

@daviszhen
Copy link
Contributor

还没看

@daviszhen
Copy link
Contributor

还没看

@daviszhen
Copy link
Contributor

还没看。

@daviszhen
Copy link
Contributor

还没看

7 similar comments
@daviszhen
Copy link
Contributor

还没看

@daviszhen
Copy link
Contributor

还没看

@daviszhen
Copy link
Contributor

还没看

@daviszhen
Copy link
Contributor

还没看

@daviszhen
Copy link
Contributor

还没看

@daviszhen
Copy link
Contributor

还没看

@daviszhen
Copy link
Contributor

还没看

@daviszhen
Copy link
Contributor

dup with #11834

@sukki37 sukki37 closed this as completed Oct 18, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@daviszhen daviszhen

Labels
kind/bug Something isn't working needs-triage severity/s0 Extreme impact: Cause the application to break down and seriously affect the use
Projects
None yet
Milestone
1.1.0
Development

No branches or pull requests
7 participants
@xuoutput @jianwan0214 @DanielZhangQD @daviszhen @sukki37 @domingozhang @matrix-meow