How to terminate running transfers

Symptoms

Transfers can't be terminated or hang indefinitely.

Description 

Transfers still have active sessions regardless of their status and can not be aborted from the WHM interface.

Workaround

1. Identify the unfinished transfer's session ID:

-bash-4.2# sqlite3 /var/cpanel/transfer_sessions/whmxfer.sqlite "select sessionid from sessions where state != '100'" cpthisisatestcopya202007210601035ab

2. Change the session's state:

-bash-4.2# sqlite3 /var/cpanel/transfer_sessions/whmxfer.sqlite "update sessions set state='100', endtime=date('now') where sessionid='1054056copya201407021337529eG8A76iJY'"

The states can be seen in this Perl module:

-bash-4.1# /usr/local/cpanel/3rdparty/bin/perl -MWhostmgr::Transfers::SessionBase -MData::Dumper -e 'our %codes = %Whostmgr::Transfers::SessionBase::SESSION_STATES; foreach (sort keys %codes){print "$_ $codes{$_}\n"};' 
ABORTED 150 
ABORTING 60 
COMPLETED 100 
FAILED 200 
PAUSED 70 
PAUSING 50 
PENDING 0 
REACHEDMAXMEM 10 
RUNNING 20