Graph
graph TD
A_0["#0: ProxyQuery-start"]
A_1["#1: ProxyQuery send request failed"]
A_2["#2: access-log (cost=0.65s)"]
style A_1 fill:#ff6666,stroke:#000000,stroke-width:1px
Start --> A_0 --> A_1 --> A_2 --> End
Show: 3 lines. More...
#0
2026-02-11T02:21:24.358606246Z
{log_app="webapi",log_type="std",pod_name="webapi-7cfd7c7b96-4v6vw",pod_namespace="cloud-platform"}
info
{"level":"info","msg":"ProxyQuery-start","query":"","remote_addr":"2400:56a0:2c2:5ce0:1fba:a43b:b009:b3af","request_id":"a2ef125c84887ed28e24c6ed805e519f","request_method":"POST","request_uri":"/v1/query","service":"databend-gateway","tenantId":"tnc7yee14","time":"2026-02-11T02:21:24Z","warehouse":"default"}
{"level":"info","msg":"ProxyQuery-start","query":"","remote_addr":"2400:56a0:2c2:5ce0:1fba:a43b:b009:b3af","request_id":"a2ef125c84887ed28e24c6ed805e519f","request_method":"POST","request_uri":"/v1/query","service":"databend-gateway","tenantId":"tnc7yee14","time":"2026-02-11T02:21:24Z","warehouse":"default"}
#1
2026-02-11T02:21:24.368280491Z
{log_app="webapi",log_type="std",pod_name="webapi-7cfd7c7b96-4v6vw",pod_namespace="cloud-platform"}
error
{"error":"Post \"http://gateway.silver.svc.internal.datafusecloud.com:80/v1/query\": dial tcp: lookup gateway.silver.svc.internal.datafusecloud.com on 172.20.0.10:53: no such host","gateway":"gateway.silver.svc.internal.datafusecloud.com:80","level":"error","msg":"ProxyQuery send request failed","query":"","remote_addr":"2400:56a0:2c2:5ce0:1fba:a43b:b009:b3af","request_body":"{\"sql\":\"SELECT *,*,*,*,*,*,* FROM `default`.`tttt1` limit 2000\",\"session\":{\"catalog\":\"default\",\"database\":\"default\",\"internal\":\"{\\\"last_node_id\\\":\\\"9Mag89IhXMNbbdvOYvg4j1\\\",\\\"last_query_ids\\\":[\\\"5edc333d6d4b453f903247583a2b794d\\\"]}\",\"need_keep_alive\":false,\"need_sticky\":false,\"role\":\"account_admin\",\"settings\":{},\"txn_state\":\"AutoCommit\"},\"string_fields\":true}","request_id":"a2ef125c84887ed28e24c6ed805e519f","request_method":"POST","request_uri":"/v1/query","service":"databend-gateway","tenantId":"tnc7yee14","time":"2026-02-11T02:21:24Z","url":"http://gateway.silver.svc.internal.datafusecloud.com:80/v1/query","warehouse":"default"}
{"error":"Post \"http://gateway.silver.svc.internal.datafusecloud.com:80/v1/query\": dial tcp: lookup gateway.silver.svc.internal.datafusecloud.com on 172.20.0.10:53: no such host","gateway":"gateway.silver.svc.internal.datafusecloud.com:80","level":"error","msg":"ProxyQuery send request failed","query":"","remote_addr":"2400:56a0:2c2:5ce0:1fba:a43b:b009:b3af","request_body":"{\"sql\":\"SELECT *,*,*,*,*,*,* FROM `default`.`tttt1` limit 2000\",\"session\":{\"catalog\":\"default\",\"database\":\"default\",\"internal\":\"{\\\"last_node_id\\\":\\\"9Mag89IhXMNbbdvOYvg4j1\\\",\\\"last_query_ids\\\":[\\\"5edc333d6d4b453f903247583a2b794d\\\"]}\",\"need_keep_alive\":false,\"need_sticky\":false,\"role\":\"account_admin\",\"settings\":{},\"txn_state\":\"AutoCommit\"},\"string_fields\":true}","request_id":"a2ef125c84887ed28e24c6ed805e519f","request_method":"POST","request_uri":"/v1/query","service":"databend-gateway","tenantId":"tnc7yee14","time":"2026-02-11T02:21:24Z","url":"http://gateway.silver.svc.internal.datafusecloud.com:80/v1/query","warehouse":"default"}
#2
2026-02-11T02:21:24.369047448Z
{log_app="webapi",log_type="std",pod_name="webapi-7cfd7c7b96-4v6vw",pod_namespace="cloud-platform"}
info
{"account_email":"chenxiaoyu@databend.com","account_id":151,"elapsed":651,"latency":"651.504879ms","level":"info","msg":"access-log","query":"","remote_addr":"172.71.8.9","request_body":"{\"queryTextRange\":{\"startOffset\":2140,\"endOffset\":2193},\"queryText\":\"CREATE OR REPLACE TASK task_111\\n WAREHOUSE='system' \\n SCHEDULE = USING CRON '0 0 * * * *' 'UTC'\\nAS SELECT 111;\\n\\nCREATE STREAM databend_books_changes2 ON TABLE databend_books;\\n\\nCREATE OR REPLACE TASK task_222\\n WAREHOUSE='system' \\n SCHEDULE = USING CRON '1 0 * * * *' 'UTC'\\nAS SELECT 222;\\n\\nCREATE OR REPLACE TASK task_333\\n WAREHOUSE='system' \\n AFTER 'task_111'\\nAS SELECT 333;\\n\\nCREATE OR \\nREPLACE TASK task_444 WAREHOUSE='system' AFTER 'task_333' AS\\nSELECT 333;\\n\\nSHOW TASKS;\\n\\n\\nALTER TASK task_222 SET WAREHOUSE='bohu-small';\\n\\ndrop task __taskflow_localtest___2_t3_ListTaskFlowVersions;\\n\\nDROP TASK __taskflow_1_22;\\nDROP TASK __taskflow_1_11;\\nDROP TASK __taskflow_3_11;\\nDROP TASK smallfish_test1;\\n\\nALTER TASK __taskflow_1_11 RESUME;\\nALTER TASK __taskflow_1_11 SUSPEND;\\n\\nCREATE TABLE orders (\\n order_id INT,\\n product_name VARCHAR,\\n quantity INT,\\n order_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP\\n);\\n\\nselect1 aa from xx.db;\\n\\nCREATE STREAM order_changes ON TABLE orders;\\n\\nSHOW FULL STREAMS;\\n\\nselect title as `标题`, '中文内容啊啊' as t, '001234' as t, author from books;\\n\\nshow CONNECTIONS;\\nshow STAGES;\\n\\ndesc stage bohu_20231;\\n\\nshow ROLES;\\n\\n\\n\\nCREATE TABLE IF NOT EXISTS `default`.`test_book` (\\n `Index` VARCHAR NULL DEFAULT 'aaa',\\n `CustomerId` VARCHAR NULL DEFAULT 'bbb',\\n `FirstName` VARCHAR NULL DEFAULT '',\\n `LastName` VARCHAR NULL DEFAULT '',\\n `Company` VARCHAR NULL DEFAULT '',\\n `City` VARCHAR NULL DEFAULT '',\\n `Country` VARCHAR NULL DEFAULT '',\\n `Phone1` VARCHAR NULL DEFAULT '',\\n `Phone2` VARCHAR NULL DEFAULT '',\\n `Email` VARCHAR NULL DEFAULT '',\\n `SubscriptionDate` VARCHAR NULL DEFAULT '',\\n `Website` VARCHAR NULL DEFAULT ''\\n);\\n\\nCOPY INTO `default`.`test_book` (`Index`,`CustomerId`,`FirstName`,`LastName`,`Company`,`City`,`Country`,`Phone1`,`Phone2`,`Email`,`SubscriptionDate`,`Website`)\\n FROM 's3://smallfish-bk/testdata/book1.csv'\\n CONNECTION = (\\n ACCESS_KEY_ID = 'AKIA53WT5ZIAJNFRSA57'\\n SECRET_ACCESS_KEY = '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'\\n )\\n FILE_FORMAT = ( TYPE = CSV, FIELD_DELIMITER = ',', RECORD_DELIMITER = '\\\\n', SKIP_HEADER = 1 );\\n\\n\\nSELECT count(*) FROM `default`.`tttt1` ;\\nSELECT *,*,*,*,*,*,* FROM `default`.`tttt1` limit 2000;\\n\\n BEGIN;\\n select 11111;\\n select 22222;\\n COMMIT;\\n\\n BEGIN; select 3333; select 444; COMMIT;\\n\\n\\nshow SETTINGS like '%result%';\\n\\nshow tables1 like '%csv%';\\n\\nSELECT * FROM TASK_HISTORY();\\n\\nSHOW ROLES;\\nSHOW USERS;\\nSHOW GRANTS;\\n\\nSHOW GRANTS FOR USER 'chenxiaoyu@databend.com';\\nSHOW GRANTS FOR ROLE 'aaa_test_role1';\\nSHOW GRANTS OF ROLE account_admin;\\nSHOW GRANTS ON DATABASE default;\\n\\nSHOW WAREHOUSES;\\n\\n-- ALTER WAREHOUSE \u003cwarehouse_name\u003e SET TAG \u003ctag_name\u003e = '\u003ctag_value\u003e' [ , \u003ctag_name\u003e = '\u003ctag_value\u003e' ... ]\\n\\nALTER WAREHOUSE 'default' SET TAG 'owner'='smallfish1';\\n\\nALTER WAREHOUSE 'default' SET TAG 'k1'='aa';\\nALTER WAREHOUSE 'default' UNSET TAG 'env';\",\"stringFields\":true,\"queryID\":\"9878e43f36c24148a0fe167fc8769c50\",\"session\":{\"catalog\":\"default\",\"database\":\"default\",\"role\":\"account_admin\",\"settings\":{},\"txn_state\":\"AutoCommit\",\"need_sticky\":false,\"need_keep_alive\":false,\"internal\":\"{\\\"last_node_id\\\":\\\"9Mag89IhXMNbbdvOYvg4j1\\\",\\\"last_query_ids\\\":[\\\"5edc333d6d4b453f903247583a2b794d\\\"]}\"}}","request_id":"a2ef125c84887ed28e24c6ed805e519f","request_method":"POST","request_uri":"/api/v1/worksheets/2526/execute","status":500,"time":"2026-02-11T02:21:24Z","user_agent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36"}
{"account_email":"chenxiaoyu@databend.com","account_id":151,"elapsed":651,"latency":"651.504879ms","level":"info","msg":"access-log","query":"","remote_addr":"172.71.8.9","request_body":"{\"queryTextRange\":{\"startOffset\":2140,\"endOffset\":2193},\"queryText\":\"CREATE OR REPLACE TASK task_111\\n WAREHOUSE='system' \\n SCHEDULE = USING CRON '0 0 * * * *' 'UTC'\\nAS SELECT 111;\\n\\nCREATE STREAM databend_books_changes2 ON TABLE databend_books;\\n\\nCREATE OR REPLACE TASK task_222\\n WAREHOUSE='system' \\n SCHEDULE = USING CRON '1 0 * * * *' 'UTC'\\nAS SELECT 222;\\n\\nCREATE OR REPLACE TASK task_333\\n WAREHOUSE='system' \\n AFTER 'task_111'\\nAS SELECT 333;\\n\\nCREATE OR \\nREPLACE TASK task_444 WAREHOUSE='system' AFTER 'task_333' AS\\nSELECT 333;\\n\\nSHOW TASKS;\\n\\n\\nALTER TASK task_222 SET WAREHOUSE='bohu-small';\\n\\ndrop task __taskflow_localtest___2_t3_ListTaskFlowVersions;\\n\\nDROP TASK __taskflow_1_22;\\nDROP TASK __taskflow_1_11;\\nDROP TASK __taskflow_3_11;\\nDROP TASK smallfish_test1;\\n\\nALTER TASK __taskflow_1_11 RESUME;\\nALTER TASK __taskflow_1_11 SUSPEND;\\n\\nCREATE TABLE orders (\\n order_id INT,\\n product_name VARCHAR,\\n quantity INT,\\n order_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP\\n);\\n\\nselect1 aa from xx.db;\\n\\nCREATE STREAM order_changes ON TABLE orders;\\n\\nSHOW FULL STREAMS;\\n\\nselect title as `标题`, '中文内容啊啊' as t, '001234' as t, author from books;\\n\\nshow CONNECTIONS;\\nshow STAGES;\\n\\ndesc stage bohu_20231;\\n\\nshow ROLES;\\n\\n\\n\\nCREATE TABLE IF NOT EXISTS `default`.`test_book` (\\n `Index` VARCHAR NULL DEFAULT 'aaa',\\n `CustomerId` VARCHAR NULL DEFAULT 'bbb',\\n `FirstName` VARCHAR NULL DEFAULT '',\\n `LastName` VARCHAR NULL DEFAULT '',\\n `Company` VARCHAR NULL DEFAULT '',\\n `City` VARCHAR NULL DEFAULT '',\\n `Country` VARCHAR NULL DEFAULT '',\\n `Phone1` VARCHAR NULL DEFAULT '',\\n `Phone2` VARCHAR NULL DEFAULT '',\\n `Email` VARCHAR NULL DEFAULT '',\\n `SubscriptionDate` VARCHAR NULL DEFAULT '',\\n `Website` VARCHAR NULL DEFAULT ''\\n);\\n\\nCOPY INTO `default`.`test_book` (`Index`,`CustomerId`,`FirstName`,`LastName`,`Company`,`City`,`Country`,`Phone1`,`Phone2`,`Email`,`SubscriptionDate`,`Website`)\\n FROM 's3://smallfish-bk/testdata/book1.csv'\\n CONNECTION = (\\n ACCESS_KEY_ID = 'AKIA53WT5ZIAJNFRSA57'\\n SECRET_ACCESS_KEY = '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'\\n )\\n FILE_FORMAT = ( TYPE = CSV, FIELD_DELIMITER = ',', RECORD_DELIMITER = '\\\\n', SKIP_HEADER = 1 );\\n\\n\\nSELECT count(*) FROM `default`.`tttt1` ;\\nSELECT *,*,*,*,*,*,* FROM `default`.`tttt1` limit 2000;\\n\\n BEGIN;\\n select 11111;\\n select 22222;\\n COMMIT;\\n\\n BEGIN; select 3333; select 444; COMMIT;\\n\\n\\nshow SETTINGS like '%result%';\\n\\nshow tables1 like '%csv%';\\n\\nSELECT * FROM TASK_HISTORY();\\n\\nSHOW ROLES;\\nSHOW USERS;\\nSHOW GRANTS;\\n\\nSHOW GRANTS FOR USER 'chenxiaoyu@databend.com';\\nSHOW GRANTS FOR ROLE 'aaa_test_role1';\\nSHOW GRANTS OF ROLE account_admin;\\nSHOW GRANTS ON DATABASE default;\\n\\nSHOW WAREHOUSES;\\n\\n-- ALTER WAREHOUSE \u003cwarehouse_name\u003e SET TAG \u003ctag_name\u003e = '\u003ctag_value\u003e' [ , \u003ctag_name\u003e = '\u003ctag_value\u003e' ... ]\\n\\nALTER WAREHOUSE 'default' SET TAG 'owner'='smallfish1';\\n\\nALTER WAREHOUSE 'default' SET TAG 'k1'='aa';\\nALTER WAREHOUSE 'default' UNSET TAG 'env';\",\"stringFields\":true,\"queryID\":\"9878e43f36c24148a0fe167fc8769c50\",\"session\":{\"catalog\":\"default\",\"database\":\"default\",\"role\":\"account_admin\",\"settings\":{},\"txn_state\":\"AutoCommit\",\"need_sticky\":false,\"need_keep_alive\":false,\"internal\":\"{\\\"last_node_id\\\":\\\"9Mag89IhXMNbbdvOYvg4j1\\\",\\\"last_query_ids\\\":[\\\"5edc333d6d4b453f903247583a2b794d\\\"]}\"}}","request_id":"a2ef125c84887ed28e24c6ed805e519f","request_method":"POST","request_uri":"/api/v1/worksheets/2526/execute","status":500,"time":"2026-02-11T02:21:24Z","user_agent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36"}