WHM Transfer Tool Issue-Unable to Abort
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.
-
Hello, Please try aborting the transfer session with the following command for the corresponding WHM API 1 function: whmapi1 abort_transfer_session transfer_session_id=exampleservercopya20140206192428NtyW
You can obtain the transfer session ID via "WHM >> Review Transfers and Restores". Thank you.0 -
Hello Please try aborting the transfer session with the following command for the corresponding WHM API 1 function:
whmapi1 abort_transfer_session transfer_session_id=exampleservercopya20140206192428NtyW
You can obtain the transfer session ID via "WHM >> Review Transfers and Restores". Thank you.
When I do this, I get the following error.0 -
Here is the session I've been trying to abort. It is from 5-17-2017. 0 -
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. 0 -
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. 0 -
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. 0 -
Thanks I'm ticket ID 8668443 0 -
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 0 -
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. 0 -
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: 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.0 -
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. 0 -
ps the error about sqllite tables was exactly what I had when contacting cpanel support initially, so it's the same 0 -
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 0 -
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 0 -
Kent Brockman is right!! Thanks man... this work perfect for me. 0 -
For me this work fine: How to clear a Cpanel/WHM transfer session which is not able to abort directly from WHM If you cannot abort a transfer you can clear a session by typing the following using SSH: /usr/local/cpanel/3rdparty/bin/sqlite3 /var/cpanel/transfer_sessions/whmxfer.sqlite "update sessions set state='100', endtime=date('now') where sessionid='X'" Where X is the session id. Hope this helps others in the same boat. Best regards. 0 -
For me this work fine: How to clear a Cpanel/WHM transfer session which is not able to abort directly from WHM If you cannot abort a transfer you can clear a session by typing the following using SSH: /usr/local/cpanel/3rdparty/bin/sqlite3 /var/cpanel/transfer_sessions/whmxfer.sqlite "update sessions set state='100', endtime=date('now') where sessionid='X'" Where X is the session id. Hope this helps others in the same boat. Best regards.
Excuse me, I would like to know if this command is a safe command that won't break any other thing at the server. By the way, should I have to erase or clean something else after stop a failed transfer? Thank you!0 -
@tons - that command is used to clear a transfer session from the WHM interface, so it is completely safe to run. It would depend on why the transfer failed. If you received a failure notice in the WHM interface, the tools are smart enough to clean up after themselves in most cases. If the failure was caused by a sudden issue, such as a server reboot or power loss, you may need to take some manual intervention, but that is unlikey. 0 -
@cPRex - Thank you so much for your answer, appreciated! I would like to ask you more, if you know; how I can be sure that the "Abort" process went well after the process stuck and it didn't show any "finish" comfirmation of that process. ---> Screenshot Could you give me some clues or any advice in order to clear everything and start from zero, please? 0 -
Does it still say "Aborting" on the page or has it moved on to aborted? If the page has hung, it might be best to submit a ticket to our team so we can check things on the system directly. 0
Please sign in to leave a comment.
Comments
20 comments