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!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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:
    38,658
    Likes Received:
    1,425
    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.
     
  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:
    38,658
    Likes Received:
    1,425
    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.
     
  6. uk01

    uk01 Well-Known Member

    Joined:
    Dec 31, 2009
    Messages:
    72
    Likes Received:
    5
    Trophy Points:
    58
    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:
    38,658
    Likes Received:
    1,425
    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.
     
  8. uk01

    uk01 Well-Known Member

    Joined:
    Dec 31, 2009
    Messages:
    72
    Likes Received:
    5
    Trophy Points:
    58
  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:
    72
    Likes Received:
    5
    Trophy Points:
    58
    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:
    38,658
    Likes Received:
    1,425
    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.
     
  12. uk01

    uk01 Well-Known Member

    Joined:
    Dec 31, 2009
    Messages:
    72
    Likes Received:
    5
    Trophy Points:
    58
    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:
    72
    Likes Received:
    5
    Trophy Points:
    58
    ps the error about sqllite tables was exactly what I had when contacting cpanel support initially, so it's the same
     
Loading...

Share This Page