1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

How to kill database cloning on Plesk.

Discussion in 'Plesk 11.x for Linux' started by PolM, Feb 11, 2013.

  1. PolM

    PolM New Pleskian

    19
     
    Joined:
    Jun 21, 2009
    Messages:
    3
    Likes Received:
    0
    Hello, I have a database Clone process on progress for more than 5 days. The process is locked, and I can't start another clone process while it's on progress. How can I kill that process? I tryed restarting plesk, and restarting the server but doesn't work.
    I'm on Plesk 11.0.9 Update #35 on DEBIAN 6.0.5
    Thank's for all.
     
  2. PolM

    PolM New Pleskian

    19
     
    Joined:
    Jun 21, 2009
    Messages:
    3
    Likes Received:
    0
    Solved

    http://blogs.reliablepenguin.com/2012/06/16/plesk-howto-clear-hung-database-copy



    Recent versions of Plesk include a Make a Copy feature for databases. Unfortunately, on occasion the copy will fail but the copy task will not be removed. Then youll see a message like this every time you go to the affected database in Plesk.

    You can view a list of the current tasks with the following command from a root ssh login:

    echo "select * from longtasks" | \
    mysql --password=`cat /etc/psa/.psa.shadow` -u admin psa

    You can clear the task by running the following command:

    echo "delete from longtasks" | \
    mysql --password=`cat /etc/psa/.psa.shadow` -u admin psa
     
Loading...