WHM Transfer Tool Issue-Unable to Abort

[stephlee2004]

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.

 

[cPanelMichael]

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.

 

[stephlee2004]

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.

 

[stephlee2004]

Here is the session I've been trying to abort. It is from 5-17-2017.

 

[cPanelMichael]

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.

 

[uk01]

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.

 

[cPanelMichael]

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.

 

[uk01]

Thanks I'm ticket ID 8668443

 

[Daniel Franqueira]

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

 

[uk01]

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.

 

[cPanelMichael]

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.

 

[uk01]

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.

 

[uk01]

ps the error about sqllite tables was exactly what I had when contacting cpanel support initially, so it's the same

 

[Kent Brockman]

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

 

[stoderash]

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:
[email protected] /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

 

[kamello]

Kent Brockman is right!! Thanks man... this work perfect for me.

 

[Uppii]

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.

 

[tons]

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!

 

[cPRex]

@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.

 

[tons]

@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?