[ 
https://issues.apache.org/jira/browse/IMPALA-12795?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17815880#comment-17815880
 ] 

Quanlong Huang commented on IMPALA-12795:
-----------------------------------------

Reproduced the issue by looping the test with other concurrent tests. The 
CREATE DATABASE statement is finished in the catalog operations page:
{noformat}
"finished_catalog_operations": [{
  "catalog_op_name": "CREATE_DATABASE", "thread_id": 53,
  "query_id": "ed4127bb5ac21d6a:4bcdb98e00000000", "client_ip": "127.0.0.1",
  "coordinator": "ccycloud.quanlong-debug.root.comops.site", "user": "root", 
"target_name": "test_catalog_operation_fields_4747ceb3",
  "start_time": "2024-02-08 08:30:16.949", "finish_time": "2024-02-08 
08:30:16.968",
  "duration": "19ms", "status": "FINISHED",  "details": ""}, ...{noformat}
But it could still in the list of in-flight queries in the queries page:
{noformat}
"in_flight_queries": [
  {"effective_user": "root", "default_db": "tpch_nested_parquet",
   "stmt": "select\n  nation,\n  o_year,\n  sum(amount) as sum_profit\nfrom(\n  
select\n    n_name as nation,\n    year(o_orderdate) as o_year,\n    
l_extendedprice * (1 - l_discount) - ps_supplycost * l_quantity as amount\n  
from\n    customer.c_orders o,\n    o.o_lineite...",
   "stmt_type": "QUERY", "start_time": "2024-02-08 08:30:04.993", "end_time": 
"1969-12-31 16:00:00.000", "duration": "12s025ms", "queued_duration": "0",    
"mem_usage": "678.51 MB",    "mem_est": "4.05 GB",    "progress": "5 / 7 
(71.4286%)",    "query_progress": "5 / 10 (  50%)",    "bytes_read": "109.40 
MB",    "bytes_sent": "40.74 MB",    "state": "RUNNING",    "rows_fetched": 0,  
  "query_id": "aa4db7ea8e26b817:8c0a5be500000000",    "last_event": "First 
dynamic filter received",    "waiting": false,    "executing": true,    
"waiting_time": "12s007ms",    "resource_pool": "default-pool"},

  {"effective_user": "root", "default_db": "default", "stmt": "CREATE DATABASE 
`test_catalog_operation_fields_4747ceb3`", "stmt_type": "DDL", 
   "start_time": "2024-02-08 08:30:16.946", "end_time": "2024-02-08 
08:30:17.001", "duration": "54.909ms",
   "queued_duration": "0",    "mem_usage": "0",    "mem_est": "0",    
"progress": "N/A",    "query_progress": "N/A",    "bytes_read": "0",    
"bytes_sent": "0",    "state": "FINISHED",    "rows_fetched": 1,    "query_id": 
"ed4127bb5ac21d6a:4bcdb98e00000000",    "last_event": "Unregister query",    
"waiting": true,    "executing": false,    "waiting_time": "18ms",    
"resource_pool": ""   }, ...{noformat}

> TestWebPage.test_catalog_operation_fields is flaky
> --------------------------------------------------
>
>                 Key: IMPALA-12795
>                 URL: https://issues.apache.org/jira/browse/IMPALA-12795
>             Project: IMPALA
>          Issue Type: Bug
>            Reporter: Quanlong Huang
>            Assignee: Quanlong Huang
>            Priority: Critical
>
> Saw the test failed in an internal job:
> {noformat}
> webserver/test_web_pages.py:942: in test_catalog_operation_fields
>     assert matched
> E   assert False{noformat}
> That means the CREATE DATABASE statement was not found in the coordinator 
> webUI.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to