[MCOL-3247] Plugin doesn't close connection with ExeMgr Created: 2019-04-12  Updated: 2019-10-28  Resolved: 2019-09-19

Status: Closed
Project: MariaDB ColumnStore
Component/s: MDB Plugin
Affects Version/s: 1.4
Fix Version/s: 1.4.0

Type: Bug Priority: Major
Reporter: Roman Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Problem/Incident
is caused by MCOL-1101 Move system variables into plugin Closed
Sprint: 2019-04, 2019-05, 2019-06

 Description   

The recent runs of the test006 demonstrates the regression after MCOL-1101. ExeMgr couldn't close the server thread b/c ExeMgr have some bytes in the out streamand nobody reads it b/c Plugin code already finishes w/o reading stream out.

 Comments   
Comment by Roman [ 2019-04-16 ]

To test the fix one should run test006 and monitor ExeMgr thread utilization. Before the fix the threads number raises to more then 1.5k. Both develop-1.2 and this fixed version uses about 300 threads during test006.

Please review the fix.

Comment by Daniel Lee (Inactive) [ 2019-09-19 ]

Build verified: 1.4.0-1

[root@localhost ~]# cat /data/qa/release/1.4.0-1/centos7/gitversionInfo.txt
engine commit:
975463c

Regression test: develop branch

1. execute test006
2. as soon as MCS was restarted, check ExeMgr process ID
ps -ef |grep -i exemgr
3. use 'top' command to view ExeMgr process
top -H -p [pid]

The thread count was up to 186 for my test

Note: Need to execute test000 before test006 so that required tables will be created,

Generated at Thu Feb 08 02:41:19 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.