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

Tim Armstrong commented on IMPALA-9667:
---------------------------------------

I'm still seeing this issue occasionally. I looked at the debug JSON dumps and 
it seems to be lingering sessions from test_insert_mem_limit - we got lucky and 
the current db for the session is a unique database:

{noformat}
sessions: "{\n    \"__common__\": {\n        \"process-name\": \"impalad\",\n   
     \"navbar\": [\n            {\n                \"link\": \"/\",\n           
     \"title\": \"/\"\n            },\n            {\n                \"link\": 
\"/admission\",\n                \"title\": \"/admission\"\n            },\n    
        {\n                \"link\": \"/backends\",\n                \"title\": 
\"/backends\"\n            },\n            {\n                \"link\": 
\"/catalog\",\n                \"title\": \"/catalog\"\n            },\n        
    {\n                \"link\": \"/hadoop-varz\",\n                \"title\": 
\"/hadoop-varz\"\n            },\n            {\n                \"link\": 
\"/jmx\",\n                \"title\": \"/jmx\"\n            },\n            {\n 
               \"link\": \"/log_level\",\n                \"title\": 
\"/log_level\"\n            },\n            {\n                \"link\": 
\"/logs\",\n                \"title\": \"/logs\"\n            },\n            
{\n                \"link\": \"/memz\",\n                \"title\": \"/memz\"\n 
           },\n            {\n                \"link\": \"/metrics\",\n         
       \"title\": \"/metrics\"\n            },\n            {\n                
\"link\": \"/profile_docs\",\n                \"title\": \"/profile_docs\"\n    
        },\n            {\n                \"link\": \"/queries\",\n            
    \"title\": \"/queries\"\n            },\n            {\n                
\"link\": \"/rpcz\",\n                \"title\": \"/rpcz\"\n            },\n    
        {\n                \"link\": \"/sessions\",\n                \"title\": 
\"/sessions\"\n            },\n            {\n                \"link\": 
\"/threadz\",\n                \"title\": \"/threadz\"\n            },\n        
    {\n                \"link\": \"/varz\",\n                \"title\": 
\"/varz\"\n            }\n        ]\n    },\n    \"sessions\": [\n        {\n   
         \"type\": \"BEESWAX\",\n            \"inflight_queries\": 0,\n         
   \"total_queries\": 1,\n            \"user\": \"jenkins\",\n            
\"delegated_user\": \"\",\n            \"session_id\": 
\"1149c369d5c2498e:3acc68db6e8c5493\",\n            \"network_address\": 
\"::1:49920\",\n            \"default_database\": 
\"test_insert_mem_limit_779b190f\",\n            \"start_time\": \"2020-04-30 
02:05:12\",\n            \"start_time_sort\": 1588237512130,\n            
\"last_accessed\": \"2020-04-30 02:05:12\",\n            
\"last_accessed_sort\": 1588237512144,\n            \"session_timeout\": 0,\n   
         \"expired\": false,\n            \"closed\": false,\n            
\"ref_count\": 0\n        },\n        {\n            \"type\": \"BEESWAX\",\n   
         \"inflight_queries\": 0,\n            \"total_queries\": 2,\n          
  \"user\": \"jenkins\",\n            \"delegated_user\": \"\",\n            
\"session_id\": \"104a87f0a3bf340b:da28517659228ab6\",\n            
\"network_address\": \"::1:49844\",\n            \"default_database\": 
\"test_insert_mem_limit_2992c487\",\n            \"start_time\": \"2020-04-30 
02:04:12\",\n            \"start_time_sort\": 1588237452111,\n            
\"last_accessed\": \"2020-04-30 02:04:18\",\n            
\"last_accessed_sort\": 1588237458113,\n            \"session_timeout\": 0,\n   
         \"expired\": false,\n            \"closed\": false,\n            
\"ref_count\": 0\n        },\n        {\n            \"type\": \"BEESWAX\",\n   
         \"inflight_queries\": 0,\n            \"total_queries\": 5,\n          
  \"user\": \"jenkins\",\n            \"delegated_user\": \"\",\n            
\"session_id\": \"2c445909d9769c1e:556ca757cce79eb9\",\n            
\"network_address\": \"::1:49812\",\n            \"default_database\": 
\"test_insert_mem_limit_2aa81cd8\",\n            \"start_time\": \"2020-04-30 
02:03:44\",\n            \"start_time_sort\": 1588237424105,\n            
\"last_accessed\": \"2020-04-30 02:04:00\",\n            
\"last_accessed_sort\": 1588237440232,\n            \"session_timeout\": 0,\n   
         \"expired\": false,\n            \"closed\": false,\n            
\"ref_count\": 0\n        }\n    ],\n    \"num_sessions\": 3,\n    
\"num_active\": 3,\n    \"num_inactive\": 0\n}"
{noformat}

> TestImpalaShellInteractive failing as session not correctly closed
> ------------------------------------------------------------------
>
>                 Key: IMPALA-9667
>                 URL: https://issues.apache.org/jira/browse/IMPALA-9667
>             Project: IMPALA
>          Issue Type: Bug
>            Reporter: Andrew Sherman
>            Assignee: David Knupp
>            Priority: Critical
>
> TestImpalaShellInteractive.test_reconnect and 
> TestImpalaShellInteractive.test_ddl_queries_are_closed fail waiting for 
> metric value 'impala-server.num-open-beeswax-sessions' to be 0.
> The tests actually fail with 
> {code}
> E   TypeError: not all arguments converted during string formatting
> {code}
> which is the result of [IMPALA-9666]



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

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

Reply via email to