Hello,
I am getting some errors when I run the Database Checker script. I was able to remedy a few of the topmost errors, but I do not see documentation for what I am experiencing. I have tried poking around in the database to see if I can find any relations to link the errors to clients but I'm totally stuck.
We are running: 10.4.4 Update #49, Ubuntu 10.4.4-32bit...
When I run this script http://kb.parallels.com/114791
I get this:
I don't know what to expect, but the system (Plesk) does quirky things, I figured I would give this a shot. I can reveal that the first group of numbers (56, 57, 58, 59, 60, 61, 62, 64, 65, 66, 67, 88) are domains we have no limits on, mostly for admin / playground stuff. They are all under the same reseller and have an unlimited plan, they work just fine so I am not worried about them.
When we get into the service permissions, I get lost and have no idea how to resolve, or even associate those with a client, the other errors are even more cryptic to me. Anyone know how to deal with this?
Thanks!
I am getting some errors when I run the Database Checker script. I was able to remedy a few of the topmost errors, but I do not see documentation for what I am experiencing. I have tried poking around in the database to see if I can find any relations to link the errors to clients but I'm totally stuck.
We are running: 10.4.4 Update #49, Ubuntu 10.4.4-32bit...
When I run this script http://kb.parallels.com/114791
I get this:
Code:
List of records in [psa.domains.id WHERE parentDomainId=0 AND htype = 'vrt_hst' AND webspace_id=0] that miss a matching record in [psa.Subscriptions.object_id WHERE object_type='domain']
56, 57, 58, 59, 60, 61, 62, 64, 65, 66, 67, 88
List of records in [psa.smb_userServicePermissions.servicePermissionId] that miss a matching record in [psa.smb_servicePermissions.id]
37, 39, 41, 43, 47, 49, 53, 55
List of records in [psa.smb_servicePermissions.id] that miss a matching record in [psa.smb_servicePermissionAccounts.servicePermissionId]
1, 7, 8, 22, 24, 25, 50, 51, 56, 57, 70, 71, 82, 83, 86, 87, 88, 89, 94, 95, 96, 99, 100, 103, 104, 105, 106
List of records in [psa.smb_apsPackagesCategories.packageId] that exceed N in 1:N (N=1) relation to [psa.smb_apsPackages.id]
28 [count in table psa.smb_apsPackages:1; count in table psa.smb_apsPackagesCategories:5]
34 [count in table psa.smb_apsPackages:1; count in table psa.smb_apsPackagesCategories:3]
List of records in [psa.smb_apsProvisions.contextId] that miss a matching record in [psa.smb_apsContexts.id]
2, 2, 2, 11, 11, 11, 16, 16, 16, 17, 17, 17, 18, 18, 18, 20, 20, 20, 29, 29, 29, 33, 33, 33, 49, 49, 49
List of records in [psa.smb_apsResources.contextId] that miss a matching record in [psa.smb_apsContexts.id]
2, 2, 2, 11, 11, 11, 11, 16, 16, 16, 16, 17, 17, 17, 17, 18, 18, 18, 18, 20, 20, 20, 20, 29, 29, 29, 29, 33, 33, 33, 49, 49, 49
List of records in [psa.apsContextsApplications.apsContextId] that exceed N in 1:N (N=1) relation to [psa.apsContexts.id]
9 [count in table psa.apsContexts:1; count in table psa.apsContextsApplications:2]
23 [count in table psa.apsContexts:1; count in table psa.apsContextsApplications:2]
List of records in [psa.apsResources.registryId] that exceed N in 1:N (N=1) relation to [apsc.aps_resource_requirement.uid]
8cd41be5-3575-4ceb-be4a-8f9f3b850da1 [count in table apsc.aps_resource_requirement:1; count in table psa.apsResources:2]
f4546e3c-a911-432b-ab79-2a5ed142a355 [count in table apsc.aps_resource_requirement:1; count in table psa.apsResources:2]
17bff839-c3e1-4d82-a757-6d1792c14a2f [count in table apsc.aps_resource_requirement:1; count in table psa.apsResources:2]
55640cad-deaa-417f-8475-0aba11d56562 [count in table apsc.aps_resource_requirement:1; count in table psa.apsResources:2]
077c7137-50d3-4d84-ab3b-a6a92a82ac1e [count in table apsc.aps_resource_requirement:1; count in table psa.apsResources:2]
aafc5071-36b6-4042-b2a4-30b53b638675 [count in table apsc.aps_resource_requirement:1; count in table psa.apsResources:2]
339421a5-2540-40e7-b968-0610aee9882a [count in table apsc.aps_resource_requirement:1; count in table psa.apsResources:2]
3fdf20e4-6c6a-4373-83ae-c85d215178a2 [count in table apsc.aps_resource_requirement:1; count in table psa.apsResources:2]
03ac1816-d216-4b8f-8417-6380d435a4b1 [count in table apsc.aps_resource_requirement:1; count in table psa.apsResources:2]
b4640b0c-3ed0-4f35-8751-8435306aa14e [count in table apsc.aps_resource_requirement:1; count in table psa.apsResources:2]
2deaeed7-68dc-433d-bb77-346c7393100e [count in table apsc.aps_resource_requirement:1; count in table psa.apsResources:2]
5c2591fd-1add-426e-b4af-17e73e4bb47b [count in table apsc.aps_resource_requirement:1; count in table psa.apsResources:2]
8af5e4cb-5b4d-4d29-8383-3d8fedfcf58b [count in table apsc.aps_resource_requirement:1; count in table psa.apsResources:2]
a0ac29e5-fcaa-4ad2-959d-ac5c0a3047ce [count in table apsc.aps_resource_requirement:1; count in table psa.apsResources:2]
c0aad079-315a-4f98-ad4e-a4a9f2b11874 [count in table apsc.aps_resource_requirement:1; count in table psa.apsResources:2]
7affd0f1-df97-46d2-b9d3-51bf0490f416 [count in table apsc.aps_resource_requirement:1; count in table psa.apsResources:2]
bdbd0a11-1ec0-4a55-a368-7104abd6c669 [count in table apsc.aps_resource_requirement:1; count in table psa.apsResources:2]
50297c3a-f9fa-44b3-8bc1-a5674d1679a4 [count in table apsc.aps_resource_requirement:1; count in table psa.apsResources:2]
e888a2c4-57c2-4bfe-a9ad-d95c6883638f [count in table apsc.aps_resource_requirement:1; count in table psa.apsResources:2]
4d6c96f9-d611-47c9-a612-584377421c10 [count in table apsc.aps_resource_requirement:1; count in table psa.apsResources:2]
aeca95db-6058-4f67-96ae-0b48bb37290c [count in table apsc.aps_resource_requirement:1; count in table psa.apsResources:2]
6599c907-a3a2-4c11-b21b-8f31fe5c3688 [count in table apsc.aps_resource_requirement:1; count in table psa.apsResources:2]
66a0aeb1-e22b-49d7-8ee8-1f818476d2c5 [count in table apsc.aps_resource_requirement:1; count in table psa.apsResources:2]
d58c1990-34b7-488b-be27-3ef19c0bb584 [count in table apsc.aps_resource_requirement:1; count in table psa.apsResources:2]
d4ce50f4-21e2-4d00-8e60-77ad44e3a933 [count in table apsc.aps_resource_requirement:1; count in table psa.apsResources:2]
01afa1a2-c551-4e79-95d1-c50b98627cb0 [count in table apsc.aps_resource_requirement:1; count in table psa.apsResources:2]
856b6f55-0bdf-4346-b01a-7286d0432635 [count in table apsc.aps_resource_requirement:1; count in table psa.apsResources:2]
I don't know what to expect, but the system (Plesk) does quirky things, I figured I would give this a shot. I can reveal that the first group of numbers (56, 57, 58, 59, 60, 61, 62, 64, 65, 66, 67, 88) are domains we have no limits on, mostly for admin / playground stuff. They are all under the same reseller and have an unlimited plan, they work just fine so I am not worried about them.
When we get into the service permissions, I get lost and have no idea how to resolve, or even associate those with a client, the other errors are even more cryptic to me. Anyone know how to deal with this?
Thanks!