Database Checker Help

[CoreyC]

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:

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!