Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

WHM Transfer Tool Issue-Unable to Abort

Discussion in 'Data Protection' started by stephlee2004, May 31, 2017.

Tags:
  1. stephlee2004

    stephlee2004 Registered

    Joined:
    May 31, 2017
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Midwest
    cPanel Access Level:
    Website Owner
    I'm running version 64 of cPanel. Server CENTOS 6.9 x86_64 virtuozzo.

    The transfer tool is stuck running, and I'm unable to abort it. When I hit the abort button it states, "Alert, Failed to abort the session." Since I'm unable to kill the transfer, it is also not allowing my server to update. Please help.
     

    Attached Files:

  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,367
    Likes Received:
    1,857
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    Please try aborting the transfer session with the following command for the corresponding WHM API 1 function:

    Code:
    whmapi1 abort_transfer_session transfer_session_id=exampleservercopya20140206192428NtyW
    You can obtain the transfer session ID via "WHM >> Review Transfers and Restores".

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. stephlee2004

    stephlee2004 Registered

    Joined:
    May 31, 2017
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Midwest
    cPanel Access Level:
    Website Owner
    Hello
    When I do this, I get the following error.
     

    Attached Files:

  4. stephlee2004

    stephlee2004 Registered

    Joined:
    May 31, 2017
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Midwest
    cPanel Access Level:
    Website Owner
    Here is the session I've been trying to abort. It is from 5-17-2017.
     

    Attached Files:

  5. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,367
    Likes Received:
    1,857
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    Could you open a support ticket using the link in my signature so we can take a closer look? You can post the ticket number here so we can update this thread with the outcome.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  6. uk01

    uk01 Well-Known Member

    Joined:
    Dec 31, 2009
    Messages:
    118
    Likes Received:
    11
    Trophy Points:
    68
    How did you resolve this? We have the same error.

    whmapi1 abort_transfer_session transfer_session_id=ssd4cheetahspabacku20170615162808xaM
    command: abort_transfer_session
    reason: "API failure: (XID 9pmkr5) The system received an error from the “SQLite” database “/var/cpanel/transfer_sessions/ssd4cheetahspabacku20170615162808xaM/db.sqlite”: SQLITE_ERROR (no such table: session)"
    result: 0
    version: 1

    Our cpanel cannot update due to a session in "running sessions". Abort fails, we've also tried a kill etc from the other forum posts, but it says "no process" exists.

    If we delete the sessions from var/cpanel/transfersessions they come back.
     
  7. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,367
    Likes Received:
    1,857
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello @uk01,

    Feel free to open a support ticket using the link in my signature so we can take a closer look at the affected system.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  8. uk01

    uk01 Well-Known Member

    Joined:
    Dec 31, 2009
    Messages:
    118
    Likes Received:
    11
    Trophy Points:
    68
  9. Daniel Franqueira

    Daniel Franqueira Registered

    Joined:
    Jul 25, 2017
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Brasil
    cPanel Access Level:
    Root Administrator
    Hi. How this problem was fixed? I'm having this very same issue.

    # whmapi1 abort_transfer_session transfer_session_id=sshddfnetbrcopya2017072312345Eqbzkm
    ---
    metadata:
    command: abort_transfer_session
    reason: "API failure: (XID grz6nt) The system received an error from the “SQLite” database “/var/cpanel/transfer_sessions/sshddfnetbrcopya2017072312345Eqbzkm/db.sqlite”: SQLITE_ERROR (no such table: session)"
    result: 0
    version: 1
     
    #9 Daniel Franqueira, Jul 25, 2017
    Last edited by a moderator: Jul 26, 2017
  10. uk01

    uk01 Well-Known Member

    Joined:
    Dec 31, 2009
    Messages:
    118
    Likes Received:
    11
    Trophy Points:
    68
    Hi cpanel support resolved the issue on the above ticket number.
    They said "After reviewing your server I did confirm that the transfer had failed, but did not clear from the queue data. I was able to manually remove the transfer from your queue".
    If you open a ticket they should do the same for you.
    I'm not sure how they did it, they may post here when they read this.
     
  11. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,367
    Likes Received:
    1,857
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    In ticket 8668443, the transfers were already listed as complete in WHM, and the solution was to move the /var/cpanel/update_blocks.config file out of the way:

    Code:
    mv -v /var/cpanel/update_blocks.config{,-bak}
    However, feel free to open a support ticket and we can take a closer look to verify why the session has not successfully aborted on your system.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  12. uk01

    uk01 Well-Known Member

    Joined:
    Dec 31, 2009
    Messages:
    118
    Likes Received:
    11
    Trophy Points:
    68
    In mine the session hadn't aborted aswell + it wouldn't let me remove it. The update block was because it wouldn't update CPanel while there was an "active" session.
     
  13. uk01

    uk01 Well-Known Member

    Joined:
    Dec 31, 2009
    Messages:
    118
    Likes Received:
    11
    Trophy Points:
    68
    ps the error about sqllite tables was exactly what I had when contacting cpanel support initially, so it's the same
     
  14. Kent Brockman

    Kent Brockman Well-Known Member

    Joined:
    Jan 20, 2008
    Messages:
    1,181
    Likes Received:
    7
    Trophy Points:
    168
    Location:
    Buenos Aires, Argentina
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello. I was having the same issue, and for anyone who this could help, I did the following:

    Step #1:
    Rename this file: mv -v /var/cpanel/update_blocks.config{,-bak}
    The update blocker warning just gone by doing this, but the transfers were still present.

    Step #2: Delete the folders at var/cpanel/transfer_sessions
    This just erase the logs

    Step #3: Force WHM to forget the sessions. Empty the database at var/cpanel/transfer_sessions/whmxfer.sqlite
    In my case, running Windows 10, I used the freeware tool "DB Browser for SQLite", which allowed me to empty the database. Then reuploaded the file and everything was ok. Went to Cpanel > Upgrade to Latest Version, and it just worked like a charm.

    Hope this helps others in the same boat.
    Best regards
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  15. stoderash

    stoderash Registered

    Joined:
    Jun 12, 2018
    Messages:
    1
    Likes Received:
    2
    Trophy Points:
    3
    Location:
    Canada
    cPanel Access Level:
    DataCenter Provider
    Kent Brockman is on the right track. I needed one additional trick not found in the forums though.
    use CPANEL's version of sqlite3, not the default system one.

    I did it from command prompt this way:

    I got an error trying to read the db when doing "sqlite .whmxfer.sqlite"
    sqlite> .tables
    Error: file is encrypted or is not a database

    Use the CPANEL version of sqlite3 and it works fine though:
    root@whm4 /var/cpanel/transfer_sessions # /usr/local/cpanel/3rdparty/bin/sqlite3 whmxfer.sqlite
    sqlite> .headers on
    sqlite> select * from sessions;
    sessionid|initiator|creator|pid|version|target_host|source_host|state|starttime|endtime
    ...
    sqlite> delete from sessions where sessionid='abcdefg'
    sqlite> .quit
     
    Kent Brockman and cPanelMichael like this.
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice