Missing resellers on migration.

[Pablo_Medina]

Hello:
We have a problem migrating from 11.0.9 to a different server running 12.0.18. Our Plesk 11 server is running great since years ago. We have 3 resellers there, say reseller1 with 17 domains, reseller2 with 13 domains and reseller3 with 250 domains.

First, we executed a complete server migration with:
/usr/local/psa/bin/migrate -m -host xxx.xxx.xxx.xxx -password xxxxxx -ip-mapping /root/migration-mapping.txt -skip-license -replace-existing-objects true

The process ran properly, but in the end we've found reseller1 and reseller2 were NOT migrated. No errors were reported tho.

While investigating this issue we have found:

1) "/usr/local/psa/bin/migrate --list-resellers" returns only reseller3. So it looks like reseller1 and reseller2 are not "seen" by the migrate utility.

2) /usr/local/psa/bin/migrate -mr reseller1 returns:
Migration started at: 2015-06-03 04:21:11
The following clients not exist: reseller1

3) /usr/local/psa/bin/migrate --list-subscriptions returns the 250 subscriptions of reseller3, but no single mention to reseller1 and reseller2 subscriptions.

In short, reseller1 and reseller2 are invisible for the migration utility. Both missing resellers are ok, enabled and active in our Plesk 11 server.
We are now stuck on the migration process and wondering if this could be a bug in the migrate utility? or some inconsistence in our Plesk 11?

Any help would be greatly appreciated.

 

[IgorG]

Try to run

# /usr/local/psa/bin/migrate --list-resellers

And check possible error messages in /var/log/plesk/PMM/migration-2015-06-04-xxxxxx/backup.log

 

[Pablo_Medina]

Thanks!!
This is what i get:

[25582]: 2015-06-04 11:04:09 WARN 9fd31626-1fef-4078-80fb-e35643005d3e reseller reseller1 is skipped from backup due to error: Cannot dump client 'reseller1' of type 'reseller', parent 'reseller3' type 'reseller' not supported! at PleskX.pm line 1267.

[25582]: 2015-06-04 11:04:09 WARN 51c9fad8-94d1-4ae9-8d73-7047cfd08694 reseller reseller2 is skipped from backup due to error: Cannot dump client 'reseller2' of type 'reseller', parent 'reseller3' type 'reseller' not supported! at PleskX.pm line 1267.

Looking for info about this right now. Will update ASAP.

 

[Pablo_Medina]

Interesting:

select id,parent_id, vendor_id,type from clients where type='reseller';
+-----+-----------+-----------+-----------+
| id | parent_id | vendor_id | type |
+-----+-----------+-----------+-----------+
| 64 | 110 | 110 | reseller1 |
| 110 | 1 | 1 | reseller3 |
| 307 | 110 | 110 | reseller2 |
+-----+-----------+-----------+-----------+

So both reseller1 and reseller2 have the id of reseller3 as parent_id. Should i change parent_id to 1 (admin) in both records manually?

 

[IgorG]

Yes, it looks like database inconsistency. You can try to correct it but I suggest you contact Odin Support Team.

 

[Pablo_Medina]

Will do it.

Thanks for your help.

 

[IgorG]

BTW, all resellers must have admin as vendor (vendor_id = 1).