[ https://issues.apache.org/jira/browse/SPARK-33946?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
pin_zhang updated SPARK-33946: ------------------------------ Description: Test with hive setting: * hive.server2.idle.session.timeout=60000 * hive.server2.session.check.interval=10000 * hive.server2.thrift.max.worker.threads=2 * hive.server2.thrift.min.worker.threads=1 1. Connect with user test1 and hold the connection. 2. Wait 1 minute, Connect with user test2 3. Seen from web ui http://localhost:4040/sqlserver/, wait session for test1 finished 4. Connect with user test3, connect was refused Task has been rejected by ExecutorService 10 times till timedout, reason: java.util.concurrent.RejectedExecutionException: Task org.apache.thrift.server.TThreadPoolServer$WorkerProcess@71b1ea28 rejected from java.util.concurrent.ThreadPoolExecutor@716d9872[Running, pool size = 2, active threads = 2, queued tasks = 0, completed tasks = 2] Seems the session was not removed, while UI show finished time for session was: Test with hive setting: * hive.server2.idle.session.timeout=60000 * hive.server2.session.check.interval=10000 * hive.server2.thrift.max.worker.threads=2 * hive.server2.thrift.min.worker.threads=1 1. Connect with user test1 and hold the connection. 2. Wait 1 minute, Connect to user test2 3. Seen from web ui http://localhost:4040/sqlserver/, session for test1 finished 4. Connect with user test3, connect was refused Task has been rejected by ExecutorService 10 times till timedout, reason: java.util.concurrent.RejectedExecutionException: Task org.apache.thrift.server.TThreadPoolServer$WorkerProcess@71b1ea28 rejected from java.util.concurrent.ThreadPoolExecutor@716d9872[Running, pool size = 2, active threads = 2, queued tasks = 0, completed tasks = 2] Seems the session was not removed, while UI show finished time for session > Cannot connect to spark hive after session timeout > -------------------------------------------------- > > Key: SPARK-33946 > URL: https://issues.apache.org/jira/browse/SPARK-33946 > Project: Spark > Issue Type: Bug > Components: SQL > Affects Versions: 2.3.1 > Reporter: pin_zhang > Priority: Major > > Test with hive setting: > * hive.server2.idle.session.timeout=60000 > * hive.server2.session.check.interval=10000 > * hive.server2.thrift.max.worker.threads=2 > * hive.server2.thrift.min.worker.threads=1 > 1. Connect with user test1 and hold the connection. > 2. Wait 1 minute, Connect with user test2 > 3. Seen from web ui http://localhost:4040/sqlserver/, wait session for > test1 finished > 4. Connect with user test3, connect was refused > Task has been rejected by ExecutorService 10 times till timedout, reason: > java.util.concurrent.RejectedExecutionException: Task > org.apache.thrift.server.TThreadPoolServer$WorkerProcess@71b1ea28 rejected > from java.util.concurrent.ThreadPoolExecutor@716d9872[Running, pool size = 2, > active threads = 2, queued tasks = 0, completed tasks = 2] > Seems the session was not removed, while UI show finished time for session > -- This message was sent by Atlassian Jira (v8.3.4#803005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org