When performing a VPS migration in Virtualizor, you may encounter this error:
Task not updated on Master from last 30 minutes
This issue is caused by a mismatch between task IDs on the Master and Slave servers. Specifically, the Master is expecting task updates from the Slave using an actid (Auto Increment ID) that is higher than the Slaveās current counter.
Hereās how to fix it using phpMyAdmin ā no terminal access required.
ā Step-by-Step Fix (Using phpMyAdmin)
1ļøā£ On the Master Server
-
Log in to phpMyAdmin.
-
Select the
virtualizordatabase. -
Click the SQL tab.
-
Run this query:
š Replace
SLAVE_IDwith the actual ID of the slave server (from Virtualizor panel: Servers > Manage Servers).š This returns the highest task ID the Master expects from the Slave.
2ļøā£ On the Slave Server
-
Log in to phpMyAdmin.
-
Select the
virtualizordatabase. -
Click the SQL tab.
-
Run this query:
This shows the current highest task ID on the Slave.
3ļøā£ Check the Result
-
If the Slave’s
actidis less than the Master’sslaveactid, the Slave canāt send valid updates. -
This is what causes the migration task to freeze.
4ļøā£ Fix the Auto Increment on Slave
You need to set the Slaveās task table AUTO_INCREMENT to one more than the Masterās slaveactid.
ā Example:
-
If Master shows
MAX(slaveactid) = 2001, set Slaveās AUTO_INCREMENT to2002.
Two ways to do this:
Option A: Using GUI
-
In the Slave’s
phpMyAdmin, open thetaskstable. -
Go to the Structure tab.
-
Find the
actidfield ā Click Change. -
Set Auto Increment to the new value.
-
Save the change.
Option B: Run this SQL on the Slave:
(Adjust 2002 to the correct value as per your case.)
š Final Step: Resync Cron Jobs
If you have SSH access, run:
On Slave:
On Master:
If you donāt have SSH, Virtualizorās background cron will sync it automatically in a few minutes.
š Thatās It!
Youāve successfully fixed the task ID desynchronization. Your VPS migration should now proceed without being stuck.