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

No route to host (os error 113) while executing perf test #92

Closed
flaneur2020 opened this issue Jul 13, 2022 · 1 comment
Closed

No route to host (os error 113) while executing perf test #92

flaneur2020 opened this issue Jul 13, 2022 · 1 comment

Comments

@flaneur2020
Copy link
Member

https://github.com/datafuselabs/databend-perf/runs/7313539246?check_suite_focus=true

2022/07/13 02:47:07 webapi.doRequest POST url=https://test.datafusecloud.com/v1/query req={"sql":"SELECT IATA_CODE_Reporting_Airline AS Carrier, count() FROM default.ontime WHERE DepDelay\u003e10 AND Year = 2007 GROUP BY Carrier ORDER BY count() DESC;"} resp={"id":"e9e5911a-183a-4a90-98b6-672ccd2d6602","session_id":"ef563545-1050-4e34-87ea-3a65c312e377","schema":{"fields":[{"name":"Carrier","default_expr":null,"data_type":{"type":"String"}},{"name":"count()","default_expr":null,"data_type":{"type":"UInt64"}}],"metadata":{}},"data":[["WN",296451],["AA",179769],["MQ",152292],["OO",147019],["US",140199],["UA",135061],["XE",108571],["EV",104055],["NW",102205],["DL",98427],["CO",81039],["YV",79553],["FL",64583],["OH",60532],["AS",54326],["B6",53716],["9E",48578],["F9",24100],["AQ",6764],["HA",4059]],"state":"Succeeded","error":null,"stats":{"scan_progress":{"rows":14000000,"bytes":224000112},"write_progress":{"rows":0,"bytes":0},"result_progress":{"rows":20,"bytes":368},"running_time_ms":351.568896},"stats_uri":"/v1/query/e9e5911a-183a-4a90-98b6-672ccd2d6602","final_uri":"/v1/query/e9e5911a-183a-4a90-98b6-672ccd2d6602/final","next_uri":null,"kill_uri":"/v1/query/e9e5911a-183a-4a90-98b6-672ccd2d6602/kill"}
2022/07/13 02:47:08 webapi.doRequest POST url=https://test.datafusecloud.com/v1/query req={"sql":"SELECT IATA_CODE_Reporting_Airline AS Carrier, count() FROM default.ontime WHERE DepDelay\u003e10 AND Year = 2007 GROUP BY Carrier ORDER BY count() DESC;"} resp={"id":"68b1627f-32c5-4d5f-8587-db1552ffc8ef","session_id":"241713b9-b325-4e97-b72d-d0c96b321c87","schema":{"fields":[],"metadata":{}},"data":[],"state":"Running","error":null,"stats":{"scan_progress":{"rows":14000000,"bytes":224000112},"write_progress":{"rows":0,"bytes":0},"result_progress":{"rows":0,"bytes":0},"running_time_ms":1025.676934},"stats_uri":"/v1/query/68b1627f-32c5-4d5f-8587-db1552ffc8ef","final_uri":"/v1/query/68b1627f-32c5-4d5f-8587-db1552ffc8ef/final","next_uri":"/v1/query/68b1627f-32c5-4d5f-8587-db1552ffc8ef/page/0","kill_uri":"/v1/query/68b1627f-32c5-4d5f-8587-db1552ffc8ef/kill"}
2022/07/13 02:51:56 webapi.doRequest POST url=https://test.datafusecloud.com/v1/query req={"sql":"SELECT IATA_CODE_Reporting_Airline AS Carrier, count() FROM default.ontime WHERE DepDelay\u003e10 AND Year = 2007 GROUP BY Carrier ORDER BY count() DESC;"} resp={"id":"647b9ae6-e0d6-4728-b146-3a1597b3c15c","session_id":"b8d757b2-3629-4351-a7a5-690a069be57e","schema":{"fields":[],"metadata":{}},"data":[],"state":"Running","error":null,"stats":{"scan_progress":{"rows":0,"bytes":0},"write_progress":{"rows":0,"bytes":0},"result_progress":{"rows":0,"bytes":0},"running_time_ms":1340.341515},"stats_uri":"/v1/query/647b9ae6-e0d6-4728-b146-3a1597b3c15c","final_uri":"/v1/query/647b9ae6-e0d6-4728-b146-3a1597b3c15c/final","next_uri":"/v1/query/647b9ae6-e0d6-4728-b146-3a1597b3c15c/page/0","kill_uri":"/v1/query/647b9ae6-e0d6-4728-b146-3a1597b3c15c/kill"}
2022/07/13 02:51:58 finish warm up 3 for query Q4 : SELECT IATA_CODE_Reporting_Airline AS Carrier, count() FROM default.ontime WHERE DepDelay>10 AND Year = 2007 GROUP BY Carrier ORDER BY count() DESC;
2022/07/13 02:51:58 the 0 time to run query Q4 : SELECT IATA_CODE_Reporting_Airline AS Carrier, count() FROM default.ontime WHERE DepDelay>10 AND Year = 2007 GROUP BY Carrier ORDER BY count() DESC;
2022/07/13 02:51:59 webapi.doRequest POST url=https://test.datafusecloud.com/v1/query req={"sql":"SELECT IATA_CODE_Reporting_Airline AS Carrier, count() FROM default.ontime WHERE DepDelay\u003e10 AND Year = 2007 GROUP BY Carrier ORDER BY count() DESC;"} resp={"id":"274d3950-3c0b-48a4-a408-9898d9f9d466","session_id":"cd346487-996b-4443-b55e-9c0[334](https://github.com/datafuselabs/databend-perf/runs/7313539246?check_suite_focus=true#step:6:335)5ef64e","schema":{"fields":[],"metadata":{}},"data":[],"state":"Running","error":null,"stats":{"scan_progress":{"rows":0,"bytes":0},"write_progress":{"rows":0,"bytes":0},"result_progress":{"rows":0,"bytes":0},"running_time_ms":1035.5629470000001},"stats_uri":"/v1/query/274d3950-3c0b-48a4-a408-9898d9f9d466","final_uri":"/v1/query/274d3950-3c0b-48a4-a408-9898d9f9d466/final","next_uri":"/v1/query/274d3950-3c0b-48a4-a408-9898d9f9d466/page/0","kill_uri":"/v1/query/274d3950-3c0b-48a4-a408-9898d9f9d466/kill"}
2022/07/13 02:52:01 the 0 time result has error query has error: &{Code:1038 Message:can not connect to http://10.1.88.192:9191/, error: tonic::transport::error::Error: transport error source: error trying to connect: tcp connect error: No route to host (os error 113) source: tcp connect error: No route to host (os error 113) source: No route to host (os error 113) Kind:}, stats: <nil>
2022/07/13 02:52:01 the 1 time to run query Q4 : SELECT IATA_CODE_Reporting_Airline AS Carrier, count() FROM default.ontime WHERE DepDelay>10 AND Year = 2007 GROUP BY Carrier ORDER BY count() DESC;
2022/07/13 02:52:02 webapi.doRequest POST url=https://test.datafusecloud.com/v1/query req={"sql":"SELECT IATA_CODE_Reporting_Airline AS Carrier, count() FROM default.ontime WHERE DepDelay\u003e10 AND Year = 2007 GROUP BY Carrier ORDER BY count() DESC;"} resp={"id":"c054c0b2-dc2b-4a0c-ac63-232c658dfa92","session_id":"8c9c5ca2-e847-43ae-a020-cc625c412276","schema":{"fields":[],"metadata":{}},"data":[],"state":"Running","error":null,"stats":{"scan_progress":{"rows":0,"bytes":0},"write_progress":{"rows":0,"bytes":0},"result_progress":{"rows":0,"bytes":0},"running_time_ms":1033.3019530000001},"stats_uri":"/v1/query/c054c0b2-dc2b-4a0c-ac63-232c658dfa92","final_uri":"/v1/query/c054c0b2-dc2b-4a0c-ac63-232c658dfa92/final","next_uri":"/v1/query/c054c0b2-dc2b-4a0c-ac63-232c658dfa92/page/0","kill_uri":"/v1/query/c054c0b2-dc2b-4a0c-ac63-232c658dfa92/kill"}
2022/07/13 02:52:04 the 1 time result has error query has error: &{Code:1038 Message:can not connect to http://10.1.105.210:9191/, error: tonic::transport::error::Error: transport error source: error trying to connect: tcp connect error: No route to host (os error 113) source: tcp connect error: No route to host (os error 113) source: No route to host (os error 113) Kind:}, stats: <nil>
2022/07/13 02:52:04 the 2 time to run query Q4 : SELECT IATA_CODE_Reporting_Airline AS Carrier, count() FROM default.ontime WHERE DepDelay>10 AND Year = 2007 GROUP BY Carrier ORDER BY count() DESC;
2022/07/13 02:52:05 webapi.doRequest POST url=https://test.datafusecloud.com/v1/query req={"sql":"SELECT IATA_CODE_Reporting_Airline AS Carrier, count() FROM default.ontime WHERE DepDelay\u003e10 AND Year = 2007 GROUP BY Carrier ORDER BY count() DESC;"} resp={"id":"e02f5010-cbf2-4cdf-92c5-fe59ac240c10","session_id":"20b9c7e4-8caa-4e7b-af8f-4cf0406e8444","schema":{"fields":[],"metadata":{}},"data":[],"state":"Running","error":null,"stats":{"scan_progress":{"rows":0,"bytes":0},"write_progress":{"rows":0,"bytes":0},"result_progress":{"rows":0,"bytes":0},"running_time_ms":1035.120751},"stats_uri":"/v1/query/e02f5010-cbf2-4cdf-92c5-fe59ac240c10","final_uri":"/v1/query/e02f5010-cbf2-4cdf-92c5-fe59ac240c10/final","next_uri":"/v1/query/e02f5010-cbf2-4cdf-92c5-fe59ac240c10/page/0","kill_uri":"/v1/query/e02f5010-cbf2-4cdf-92c5-fe59ac240c10/kill"}
2022/07/13 02:52:07 the 2 time result has error query has error: &{Code:1038 Message:can not connect to http://10.1.113.118:9191/, error: tonic::transport::error::Error: transport error source: error trying to connect: tcp connect error: No route to host (os error 113) source: tcp connect error: No route to host (os error 113) source: No route to host (os error 113) Kind:}, stats: <nil>
2022/07/13 02:52:07 the 3 time to run query Q4 : SELECT IATA_CODE_Reporting_Airline AS Carrier, count() FROM default.ontime WHERE DepDelay>10 AND Year = 2007 GROUP BY Carrier ORDER BY count() DESC;
2022/07/13 02:52:09 webapi.doRequest POST url=https://test.datafusecloud.com/v1/query req={"sql":"SELECT IATA_CODE_Reporting_Airline AS Carrier, count() FROM default.ontime WHERE DepDelay\u003e10 AND Year = 2007 GROUP BY Carrier ORDER BY count() DESC;"} resp={"id":"87280ff5-b4f1-4baa-89fb-2f6ef408d9b6","session_id":"64364c3c-f7c6-46bc-a69e-a10e088a6023","schema":{"fields":[],"metadata":{}},"data":[],"state":"Running","error":null,"stats":{"scan_progress":{"rows":0,"bytes":0},"write_progress":{"rows":0,"bytes":0},"result_progress":{"rows":0,"bytes":0},"running_time_ms":1033.769738},"stats_uri":"/v1/query/87280ff5-b4f1-4baa-89fb-2f6ef408d9b6","final_uri":"/v1/query/87280ff5-b4f1-4baa-89fb-2f6ef408d9b6/final","next_uri":"/v1/query/87280ff5-b4f1-4baa-89fb-2f6ef408d9b6/page/0","kill_uri":"/v1/query/87280ff5-b4f1-4baa-89fb-2f6ef408d9b6/kill"}
2022/07/13 02:52:11 the 3 time result has error query has error: &{Code:1038 Message:can not connect to http://10.1.88.192:9191/, error: tonic::transport::error::Error: transport error source: error trying to connect: tcp connect error: No route to host (os error 113) source: tcp connect error: No route to host (os error 113) source: No route to host (os error 113) Kind:}, stats: <nil>
2022/07/13 02:52:11 the 4 time to run query Q4 : SELECT IATA_CODE_Reporting_Airline AS Carrier, count() FROM default.ontime WHERE DepDelay>10 AND Year = 2007 GROUP BY Carrier ORDER BY count() DESC;
2022/07/13 02:52:12 webapi.doRequest POST url=https://test.datafusecloud.com/v1/query req={"sql":"SELECT IATA_CODE_Reporting_Airline AS Carrier, count() FROM default.ontime WHERE DepDelay\u003e10 AND Year = 2007 GROUP BY Carrier ORDER BY count() DESC;"} resp={"id":"9d1654c1-3d27-4e59-acc6-64157795f7d5","session_id":"bc59cc97-647c-424a-aa2c-3278deb93499","schema":{"fields":[],"metadata":{}},"data":[],"state":"Running","error":null,"stats":{"scan_progress":{"rows":0,"bytes":0},"write_progress":{"rows":0,"bytes":0},"result_progress":{"rows":0,"bytes":0},"running_time_ms":1035.648265},"stats_uri":"/v1/query/9d1654c1-3d27-4e59-acc6-64157795f7d5","final_uri":"/v1/query/9d1654c1-3d27-4e59-acc6-64157795f7d5/final","next_uri":"/v1/query/9d1654c1-3d27-4e59-acc6-64157795f7d5/page/0","kill_uri":"/v1/query/9d1654c1-3d27-4e59-acc6-64157795f7d5/kill"}
2022/07/13 02:52:14 the 4 time result has error query has error: &{Code:1038 Message:can not connect to http://10.1.113.118:9191/, error: tonic::transport::error::Error: transport error source: error trying to connect: tcp connect error: No route to host (os error 113) source: tcp connect error: No route to host (os error 113) source: No route to host (os error 113) Kind:}, stats: <nil>
2022/07/13 02:52:14 the 5 time to run query Q4 : SELECT IATA_CODE_Reporting_Airline AS Carrier, count() FROM default.ontime WHERE DepDelay>10 AND Year = 2007 GROUP BY Carrier ORDER BY count() DESC;
2022/07/13 02:52:15 webapi.doRequest POST url=https://test.datafusecloud.com/v1/query req={"sql":"SELECT IATA_CODE_Reporting_Airline AS Carrier, count() FROM default.ontime WHERE DepDelay\u003e10 AND Year = 2007 GROUP BY Carrier ORDER BY count() DESC;"} resp={"id":"7302107a-50c0-4235-882c-f70b90741ff3","session_id":"7d6d077c-8c07-457d-a4b1-2403a44bf1d1","schema":{"fields":[],"metadata":{}},"data":[],"state":"Running","error":null,"stats":{"scan_progress":{"rows":0,"bytes":0},"write_progress":{"rows":0,"bytes":0},"result_progress":{"rows":0,"bytes":0},"running_time_ms":1037.361202},"stats_uri":"/v1/query/7302107a-50c0-4235-882c-f70b90741ff3","final_uri":"/v1/query/7302107a-50c0-4235-882c-f70b90741ff3/final","next_uri":"/v1/query/7302107a-50c0-4235-882c-f70b90741ff3/page/0","kill_uri":"/v1/query/7302107a-50c0-4235-882c-f70b90741ff3/kill"}
2022/07/13 02:52:17 the 5 time result has error query has error: &{Code:1038 Message:can not connect to http://10.1.124.12:9191/, error: tonic::transport::error::Error: transport error source: error trying to connect: tcp connect error: No route to host (os error 113) source: tcp connect error: No route to host (os error 113) source: No route to host (os error 113) Kind:}, stats: <nil>
2022/07/13 02:52:17 the 6 time to run query Q4 : SELECT IATA_CODE_Reporting_Airline AS Carrier, count() FROM default.ontime WHERE DepDelay>10 AND Year = 2007 GROUP BY Carrier ORDER BY count() DESC;
2022/07/13 02:52:18 webapi.doRequest POST url=https://test.datafusecloud.com/v1/query req={"sql":"SELECT IATA_CODE_Reporting_Airline AS Carrier, count() FROM default.ontime WHERE DepDelay\u003e10 AND Year = 2007 GROUP BY Carrier ORDER BY count() DESC;"} resp={"id":"3e0640b2-4785-4429-819c-a9c3797e1890","session_id":"aba1fb06-30af-4c68-a998-d04365c833a8","schema":{"fields":[],"metadata":{}},"data":[],"state":"Running","error":null,"stats":{"scan_progress":{"rows":0,"bytes":0},"write_progress":{"rows":0,"bytes":0},"result_progress":{"rows":0,"bytes":0},"running_time_ms":1036.750172},"stats_uri":"/v1/query/3e0640b2-4785-4429-819c-a9c3797e1890","final_uri":"/v1/query/3e0640b2-4785-4429-819c-a9c3797e1890/final","next_uri":"/v1/query/3e0640b2-4785-4429-819c-a9c3797e1890/page/0","kill_uri":"/v1/query/3e0640b2-4785-4429-819c-a9c3797e1890/kill"}
2022/07/13 02:52:28 the 6 time result has error query has error: &{Code:1038 Message:can not connect to http://10.1.107.63:9191/, error: tonic::transport::error::Error: transport error source: error trying to connect: tcp connect error: No route to host (os error 113) source: tcp connect error: No route to host (os error 113) source: No route to host (os error 113) Kind:}, stats: <nil>
2022/07/13 02:52:28 the 7 time to run query Q4 : SELECT IATA_CODE_Reporting_Airline AS Carrier, count() FROM default.ontime WHERE DepDelay>10 AND Year = 2007 GROUP BY Carrier ORDER BY count() DESC;
2022/07/13 02:52:29 webapi.doRequest POST url=https://test.datafusecloud.com/v1/query req={"sql":"SELECT IATA_CODE_Reporting_Airline AS Carrier, count() FROM default.ontime WHERE DepDelay\u003e10 AND Year = 2007 GROUP BY Carrier ORDER BY count() DESC;"} resp={"id":"9ebc4628-cf63-43ff-915e-2cb21b077125","session_id":"848b7555-5cc5-4418-972d-ae39a32ed93c","schema":{"fields":[],"metadata":{}},"data":[],"state":"Running","error":null,"stats":{"scan_progress":{"rows":0,"bytes":0},"write_progress":{"rows":0,"bytes":0},"result_progress":{"rows":0,"bytes":0},"running_time_ms":1031.7258869999998},"stats_uri":"/v1/query/9ebc4628-cf63-43ff-915e-2cb21b077125","final_uri":"/v1/query/9ebc4628-cf63-43ff-915e-2cb21b077125/final","next_uri":"/v1/query/9ebc4628-cf63-43ff-915e-2cb21b077125/page/0","kill_uri":"/v1/query/9ebc4628-cf63-43ff-915e-2cb21b077125/kill"}
2022/07/13 02:52:31 the 7 time result has error query has error: &{Code:1038 Message:can not connect to http://10.1.67.71:9191/, error: tonic::transport::error::Error: transport error source: error trying to connect: tcp connect error: No route to host (os error 113) source: tcp connect error: No route to host (os error 113) source: No route to host (os error 113) Kind:}, stats: <nil>
2022/07/13 02:52:31 the 8 time to run query Q4 : SELECT IATA_CODE_Reporting_Airline AS Carrier, count() FROM default.ontime WHERE DepDelay>10 AND Year = 2007 GROUP BY Carrier ORDER BY count() DESC;
2022/07/13 02:52:32 webapi.doRequest POST url=https://test.datafusecloud.com/v1/query req={"sql":"SELECT IATA_CODE_Reporting_Airline AS Carrier, count() FROM default.ontime WHERE DepDelay\u003e10 AND Year = 2007 GROUP BY Carrier ORDER BY count() DESC;"} resp={"id":"07d31206-0bb6-4493-823a-17a9843bc5f3","session_id":"b37ee994-1423-48a4-bd1c-60fa6fbed852","schema":{"fields":[],"metadata":{}},"data":[],"state":"Running","error":null,"stats":{"scan_progress":{"rows":0,"bytes":0},"write_progress":{"rows":0,"bytes":0},"result_progress":{"rows":0,"bytes":0},"running_time_ms":1035.87[352](https://github.com/datafuselabs/databend-perf/runs/7313539246?check_suite_focus=true#step:6:353)99999998},"stats_uri":"/v1/query/07d31206-0bb6-4493-823a-17a9843bc5f3","final_uri":"/v1/query/07d31206-0bb6-4493-823a-17a9843bc5f3/final","next_uri":"/v1/query/07d31206-0bb6-4493-823a-17a9843bc5f3/page/0","kill_uri":"/v1/query/07d31206-0bb6-4493-823a-17a9843bc5f3/kill"}
2022/07/13 02:52:41 the 8 time result has error query has error: &{Code:1038 Message:can not connect to http://10.1.90.67:9191/, error: tonic::transport::error::Error: transport error source: error trying to connect: tcp connect error: No route to host (os error 113) source: tcp connect error: No route to host (os error 113) source: No route to host (os error 113) Kind:}, stats: <nil>
2022/07/13 02:52:41 the 9 time to run query Q4 : SELECT IATA_CODE_Reporting_Airline AS Carrier, count() FROM default.ontime WHERE DepDelay>10 AND Year = 2007 GROUP BY Carrier ORDER BY count() DESC;
2022/07/13 02:52:42 webapi.doRequest POST url=https://test.datafusecloud.com/v1/query req={"sql":"SELECT IATA_CODE_Reporting_Airline AS Carrier, count() FROM default.ontime WHERE DepDelay\u003e10 AND Year = 2007 GROUP BY Carrier ORDER BY count() DESC;"} resp={"id":"cef96421-d6ba-4f7e-ace7-92b8298abc0e","session_id":"c8b18255-3b93-4ee3-a56d-5038ace2b3ae","schema":{"fields":[],"metadata":{}},"data":[],"state":"Running","error":null,"stats":{"scan_progress":{"rows":0,"bytes":0},"write_progress":{"rows":0,"bytes":0},"result_progress":{"rows":0,"bytes":0},"running_time_ms":1034.959242},"stats_uri":"/v1/query/cef96421-d6ba-4f7e-ace7-92b8298abc0e","final_uri":"/v1/query/cef96421-d6ba-4f7e-ace7-92b8298abc0e/final","next_uri":"/v1/query/cef96421-d6ba-4f7e-ace7-92b8298abc0e/page/0","kill_uri":"/v1/query/cef96421-d6ba-4f7e-ace7-92b8298abc0e/kill"}
2022/07/13 02:52:44 the 9 time result has error query has error: &{Code:1038 Message:can not connect to http://10.1.124.203:9191/, error: tonic::transport::error::Error: transport error source: error trying to connect: tcp connect error: No route to host (os error 113) source: tcp connect error: No route to host (os error 113) source: No route to host (os error 113) Kind:}, stats: <nil>
panic: test case failed 10 times
@flaneur2020 flaneur2020 mentioned this issue Jul 13, 2022
Open
@flaneur2020
Copy link
Member Author

this PR can fix this issue: https://github.com/datafuselabs/databend/pull/7246/files

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@flaneur2020