fliegerhermi
Regular Pleskian
Hi!
I installed plesk 12.5 on a debian minimal machine, which should work just fine according to the manual.
Some minor problems have been solved, but now I seem to be having a database inconsistency on a productive system. That is unacceptable!
What I have done:
1) Installed Plesk, didn't change anything in the database manually
2) Migrated a few customers
3) Deleted some of the migrated subscriptions because I didn't have access to the NS-entries.
4) Migrated them again
Migration returned the following error:
Warning: Restore customer "xxxxxx"
Failed deployment of domain xxxxx.com
Warning:
Execution of /opt/psa/admin/plib/api-cli/domain.php --create xxxxxx.com -owner xxxxx-do-not-apply-skeleton -notify false -guid 66d0c552-93eb-47f5-9276-4937fcfab733 -creation-date 2015-04-03 -ip 84.200.17.45 -ignore-nonexistent-options failed with return code 1. Stderr is An error occurred during domain creation: mailmng-outgoing failed: ERRORutgoing:UNIQUE constraint failed: domains.name
Warning: Restore user account "[email protected]"
Internal server error: There is no DSMail service for domain with id = 92
I ran the plesk consistency checker (http://kb.odin.com/en/114791) which returned a bunch of errors:
List of records in [psa.mail.dom_id] that miss a matching record in [psa.domains.id]
66, 66, 77, 77, 77
List of records in [psa.DomainServices.dom_id] that miss a matching record in [psa.domains.id]
11, 29, 66, 77
Caught exception: MySQL query failed: Table 'psa.domainaliases' doesn't exist at running query "SELECT id FROM dns_zone WHERE id<>1 and id not in (select dns_zone_id from domainaliases);"
Caught exception: MySQL query failed: Table 'psa.domainaliases' doesn't exist at running query "SELECT id FROM dns_zone WHERE id<>1 and id not in (select dns_zone_id from domainaliases);"
ERROR: Table "domainaliases" is not found in database "psa"!
ERROR: Table "domainaliases" is not found in database "psa"!
ERROR: Table "domainaliases" is not found in database "psa"!
ERROR: Table "domainaliases" is not found in database "psa"!
List of records in [psa.Subscriptions.object_id WHERE object_type='domain'] that miss a matching record in [psa.domains.id WHERE parentDomainId=0 AND htype = 'vrt_hst' AND webspace_id=0]
19, 35, 38, 41, 42, 43, 44, 56, 57, 60, 61, 92
List of records in [psa.Subscriptions.id] that miss a matching record in [psa.PlansSubscriptions.subscription_id]
2, 58, 67, 68, 69, 70, 71, 72, 74, 75
List of records in [psa.smb_servicePermissionAccounts.servicePermissionId] that exceed N in 1:N (N=1) relation to [psa.smb_servicePermissions.id]
2 [count in table psa.smb_servicePermissions:1; count in table psa.smb_servicePermissionAccounts:23]
List of records in [psa.smb_servicePermissions.id] that miss a matching record in [psa.smb_servicePermissionAccounts.servicePermissionId]
1, 5, 6
ERROR: Table "smb_apsImportedResources" is not found in database "psa"!
ERROR: Table "smb_apsImportedResources" is not found in database "psa"!
ERROR: Table "siteapppackages_apscategories" is not found in database "psa"!
List of records in [apsc.aps_registry_object.uid WHERE type='aps.resource'] that miss a matching record in [psa.smb_apsInstances.registryResourceId]
f2056b0d-1601-4299-9db7-481d0d43a452, 6865e909-5446-4e03-88c0-af63054addcb
List of records in [apsc.aps_registry_object.uid WHERE type='aps.resource'] that miss a matching record in [psa.smb_serviceInstances.externalId WHERE serviceProviderId=(SELECT id FROM smb_serviceProviders WHERE classname='Smb_Service_Provider_Aps')]
f2056b0d-1601-4299-9db7-481d0d43a452, 6865e909-5446-4e03-88c0-af63054addcb
So basically when you delete something garbage remains in the database which results in errors later on. I'm sorry to say that, but that is a basic system function that should really work. If it doesn't plesk 12.5 should go back to testing stage.
There's absolutly no chance for a user mistake since I've done everything in your panel (Not in the console, nor in the database).
I'd be thankful for any help. Messing in the database will result in more problems and doesn't solve the issue for the future. THanks!
PS: No thanks I don't want to buy support for 150$, because it is a system malfunction!
I installed plesk 12.5 on a debian minimal machine, which should work just fine according to the manual.
Some minor problems have been solved, but now I seem to be having a database inconsistency on a productive system. That is unacceptable!
What I have done:
1) Installed Plesk, didn't change anything in the database manually
2) Migrated a few customers
3) Deleted some of the migrated subscriptions because I didn't have access to the NS-entries.
4) Migrated them again
Migration returned the following error:
Warning: Restore customer "xxxxxx"
Failed deployment of domain xxxxx.com
Warning:
Execution of /opt/psa/admin/plib/api-cli/domain.php --create xxxxxx.com -owner xxxxx-do-not-apply-skeleton -notify false -guid 66d0c552-93eb-47f5-9276-4937fcfab733 -creation-date 2015-04-03 -ip 84.200.17.45 -ignore-nonexistent-options failed with return code 1. Stderr is An error occurred during domain creation: mailmng-outgoing failed: ERRORutgoing:UNIQUE constraint failed: domains.name
Warning: Restore user account "[email protected]"
Internal server error: There is no DSMail service for domain with id = 92
I ran the plesk consistency checker (http://kb.odin.com/en/114791) which returned a bunch of errors:
List of records in [psa.mail.dom_id] that miss a matching record in [psa.domains.id]
66, 66, 77, 77, 77
List of records in [psa.DomainServices.dom_id] that miss a matching record in [psa.domains.id]
11, 29, 66, 77
Caught exception: MySQL query failed: Table 'psa.domainaliases' doesn't exist at running query "SELECT id FROM dns_zone WHERE id<>1 and id not in (select dns_zone_id from domainaliases);"
Caught exception: MySQL query failed: Table 'psa.domainaliases' doesn't exist at running query "SELECT id FROM dns_zone WHERE id<>1 and id not in (select dns_zone_id from domainaliases);"
ERROR: Table "domainaliases" is not found in database "psa"!
ERROR: Table "domainaliases" is not found in database "psa"!
ERROR: Table "domainaliases" is not found in database "psa"!
ERROR: Table "domainaliases" is not found in database "psa"!
List of records in [psa.Subscriptions.object_id WHERE object_type='domain'] that miss a matching record in [psa.domains.id WHERE parentDomainId=0 AND htype = 'vrt_hst' AND webspace_id=0]
19, 35, 38, 41, 42, 43, 44, 56, 57, 60, 61, 92
List of records in [psa.Subscriptions.id] that miss a matching record in [psa.PlansSubscriptions.subscription_id]
2, 58, 67, 68, 69, 70, 71, 72, 74, 75
List of records in [psa.smb_servicePermissionAccounts.servicePermissionId] that exceed N in 1:N (N=1) relation to [psa.smb_servicePermissions.id]
2 [count in table psa.smb_servicePermissions:1; count in table psa.smb_servicePermissionAccounts:23]
List of records in [psa.smb_servicePermissions.id] that miss a matching record in [psa.smb_servicePermissionAccounts.servicePermissionId]
1, 5, 6
ERROR: Table "smb_apsImportedResources" is not found in database "psa"!
ERROR: Table "smb_apsImportedResources" is not found in database "psa"!
ERROR: Table "siteapppackages_apscategories" is not found in database "psa"!
List of records in [apsc.aps_registry_object.uid WHERE type='aps.resource'] that miss a matching record in [psa.smb_apsInstances.registryResourceId]
f2056b0d-1601-4299-9db7-481d0d43a452, 6865e909-5446-4e03-88c0-af63054addcb
List of records in [apsc.aps_registry_object.uid WHERE type='aps.resource'] that miss a matching record in [psa.smb_serviceInstances.externalId WHERE serviceProviderId=(SELECT id FROM smb_serviceProviders WHERE classname='Smb_Service_Provider_Aps')]
f2056b0d-1601-4299-9db7-481d0d43a452, 6865e909-5446-4e03-88c0-af63054addcb
So basically when you delete something garbage remains in the database which results in errors later on. I'm sorry to say that, but that is a basic system function that should really work. If it doesn't plesk 12.5 should go back to testing stage.
There's absolutly no chance for a user mistake since I've done everything in your panel (Not in the console, nor in the database).
I'd be thankful for any help. Messing in the database will result in more problems and doesn't solve the issue for the future. THanks!
PS: No thanks I don't want to buy support for 150$, because it is a system malfunction!