Total: 5, Show 5 lines
2026-02-11T02:20:04.402197261Z
{log_app="webapi",log_type="std",pod_name="webapi-7cfd7c7b96-4v6vw",pod_namespace="cloud-platform"}
account_email: chenxiaoyu@databend.com
account_id: 151
app_name: webapi
cluster_name: global-silver
elapsed: 1494
latency: 1.494922329s
level: info
log_app: webapi
log_type: std
msg: access-log
pod_name: webapi-7cfd7c7b96-4v6vw
pod_namespace: cloud-platform
remote_addr: 172.71.8.9
request_body: {"queryTextRange":{"startOffset":2140,"endOffset":2182},"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`;\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 <warehouse_name> SET TAG <tag_name> = '<tag_value>' [ , <tag_name> = '<tag_value>' ... ]\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":"eb22f378d7f94695823fe61950486f18","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\":[\"2cab2e55284048f2a1a5d9b6752a0682\"]}"}}
request_id: 3a076545d1df1922840c01bfe67ef5d3
request_method: POST
request_uri: /api/v1/worksheets/2526/execute
status: 500
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
2026-02-11T02:20:04.402197261Z
{log_app="webapi",log_type="access-log",pod_name="webapi-7cfd7c7b96-4v6vw",pod_namespace="cloud-platform"}
account_email: chenxiaoyu@databend.com
account_id: 151
app_name: webapi
cluster_name: global-silver
elapsed: 1494
latency: 1.494922329s
latency_ms: 1.49s
level: info
log_app: webapi
log_type: access-log
msg: access-log
pod_name: webapi-7cfd7c7b96-4v6vw
pod_namespace: cloud-platform
remote_addr: 172.71.8.9
request_body: {"queryTextRange":{"startOffset":2140,"endOffset":2182},"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`;\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 <warehouse_name> SET TAG <tag_name> = '<tag_value>' [ , <tag_name> = '<tag_value>' ... ]\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":"eb22f378d7f94695823fe61950486f18","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\":[\"2cab2e55284048f2a1a5d9b6752a0682\"]}"}}
request_id: 3a076545d1df1922840c01bfe67ef5d3
request_method: POST
request_uri: /api/v1/worksheets/2526/execute
status: 500
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
2026-02-11T02:20:04.401052166Z
{log_app="webapi",log_type="std",pod_name="webapi-7cfd7c7b96-4v6vw",pod_namespace="cloud-platform"}
app_name: webapi
cluster_name: global-silver
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
log_app: webapi
log_type: std
msg: ProxyQuery send request failed
pod_name: webapi-7cfd7c7b96-4v6vw
pod_namespace: cloud-platform
remote_addr: 2400:56a0:2c2:5ce0:1fba:a43b:b009:b3af
request_body: {"sql":"SELECT *,*,*,*,*,*,* FROM `default`.`tttt1`","session":{"catalog":"default","database":"default","internal":"{\"last_node_id\":\"9Mag89IhXMNbbdvOYvg4j1\",\"last_query_ids\":[\"2cab2e55284048f2a1a5d9b6752a0682\"]}","need_keep_alive":false,"need_sticky":false,"role":"account_admin","settings":{},"txn_state":"AutoCommit"},"string_fields":true}
request_id: 3a076545d1df1922840c01bfe67ef5d3
request_method: POST
request_uri: /v1/query
service: databend-gateway
tenantId: tnc7yee14
url: http://gateway.silver.svc.internal.datafusecloud.com:80/v1/query
warehouse: default
2026-02-11T02:20:04.401052166Z
{log_app="webapi",log_type="error-log",pod_name="webapi-7cfd7c7b96-4v6vw",pod_namespace="cloud-platform"}
app_name: webapi
cluster_name: global-silver
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
log_app: webapi
log_type: error-log
msg: ProxyQuery send request failed
pod_name: webapi-7cfd7c7b96-4v6vw
pod_namespace: cloud-platform
remote_addr: 2400:56a0:2c2:5ce0:1fba:a43b:b009:b3af
request_body: {"sql":"SELECT *,*,*,*,*,*,* FROM `default`.`tttt1`","session":{"catalog":"default","database":"default","internal":"{\"last_node_id\":\"9Mag89IhXMNbbdvOYvg4j1\",\"last_query_ids\":[\"2cab2e55284048f2a1a5d9b6752a0682\"]}","need_keep_alive":false,"need_sticky":false,"role":"account_admin","settings":{},"txn_state":"AutoCommit"},"string_fields":true}
request_id: 3a076545d1df1922840c01bfe67ef5d3
request_method: POST
request_uri: /v1/query
service: databend-gateway
tenantId: tnc7yee14
url: http://gateway.silver.svc.internal.datafusecloud.com:80/v1/query
warehouse: default
2026-02-11T02:20:04.391090014Z
{log_app="webapi",log_type="std",pod_name="webapi-7cfd7c7b96-4v6vw",pod_namespace="cloud-platform"}
app_name: webapi
cluster_name: global-silver
level: info
log_app: webapi
log_type: std
msg: ProxyQuery-start
pod_name: webapi-7cfd7c7b96-4v6vw
pod_namespace: cloud-platform
remote_addr: 2400:56a0:2c2:5ce0:1fba:a43b:b009:b3af
request_id: 3a076545d1df1922840c01bfe67ef5d3
request_method: POST
request_uri: /v1/query
service: databend-gateway
tenantId: tnc7yee14
warehouse: default