Corrupt Repository

scw · Post by **scw** » Tue Oct 16, 2007 4:49 pm

Vault client is version 3.1.6.3658
Vault server is version 3.1.6.3658

When trying to checkout a file from 1 repository we get the following error:

Check out failed for $/<path/filename>: A invalid tree error has occured.

When running the vault admin tool and trying to check the properties of this repository we get an unhandled excpetion:

VaultServiceAPILib.VaultSoapException 1110:
FailDBNoValidRepository
at Vault Service.VaultAdminService.GetRepositoryProperties(Int32 nRepId, VaulRepositoryInfo_vfInfo)

Any admin tasks for this repository seem to fail, but all our other repositories seem to work correctly.

Help ???

lbauer · Post by **lbauer** » Wed Oct 17, 2007 7:01 am

What errors are reported in the Vault Server log file (sgvault.log in %windir%\temp\sgvault).

Does an IIS reset on the Vault Server machine set things right?

Do you have a recent good backup of your database?

scw · Post by **scw** » Wed Oct 17, 2007 10:59 pm

When attempting to check out a file there are no errors in the log:

----18/10/2007 5:53:21 p.m. scott.biz--BIZWORKS01(172.29.35.8)--SSL Disabled Getting repository Structure-> Rep ID: 11 Base: 28023 Target: -1
----18/10/2007 5:53:21 p.m. scott.biz--BIZWORKS01(172.29.35.8)--SSL Disabled TreeManager: cache matches repository revision and folder security hasn't changed. Returning cached tree, revID 28023
----18/10/2007 5:53:21 p.m. scott.biz--BIZWORKS01(172.29.35.8)--SSL Disabled VaultServiceAPI::GetRepositoryTreeDelta() UserID:2 RepID:11 Base:28023 Target:28023 Calling VaultRepUtil.DiffRepTrees() - in-memory tree diff.
----18/10/2007 5:53:21 p.m. scott.biz--BIZWORKS01(172.29.35.8)--SSL Disabled GetRepositoryStructure returned: Success
----18/10/2007 5:53:21 p.m. scott.biz--BIZWORKS01(172.29.35.8)--SSL Disabled Getting list of checkout changes.
----18/10/2007 5:53:21 p.m. scott.biz--BIZWORKS01(172.29.35.8)--SSL Disabled GetCheckOutListChanges returned: Success
----18/10/2007 5:53:21 p.m. scott.biz--BIZWORKS01(172.29.35.8)--SSL Disabled Checking out Files
----18/10/2007 5:53:21 p.m. scott.biz--BIZWORKS01(172.29.35.8)--SSL Disabled TreeManager: cache matches repository revision and folder security hasn't changed. Returning cached tree, revID 28023
----18/10/2007 5:53:21 p.m. scott.biz--BIZWORKS01(172.29.35.8)--SSL Disabled CheckOutFiles: Transaction Started
----18/10/2007 5:53:21 p.m. scott.biz--BIZWORKS01(172.29.35.8)--SSL Disabled CheckOutFiles: Transaction Committed
----18/10/2007 5:53:21 p.m. scott.biz--BIZWORKS01(172.29.35.8)--SSL Disabled CheckOutFiles returned:Success
----18/10/2007 5:53:21 p.m. scott.biz--BIZWORKS01(172.29.35.8)--SSL Disabled Getting list of checkout changes.
----18/10/2007 5:53:21 p.m. scott.biz--BIZWORKS01(172.29.35.8)--SSL Disabled GetCheckOutListChanges returned: Success

The messages in the Vault client are:

[18/10/2007 5:47:15 p.m.] Checking out file $/Engage2006/Bizworks.Engage.Core/Contacts/CRM/CRMOrganisation.vb
[18/10/2007 5:47:15 p.m.] Check out failed for $/Engage2006/Bizworks.Engage.Core/Contacts/CRM/CRMOrganisation.vb: A invalid tree error has occured.
[18/10/2007 5:47:15 p.m.] Checked out file $/Engage2006/Bizworks.Engage.Core/Contacts/CRM/CRMOrganisation.vb

When trying to access the properties of the repository using the admin tool again there is no error in the log file, in fact there seems to be no activity in the log file for this operation at all:

----18/10/2007 5:46:58 p.m. admin--bizworkssvr(172.29.35.4)--SSL Disabled Login
----18/10/2007 5:46:58 p.m. admin--bizworkssvr(172.29.35.4)--SSL Disabled GetUserOptions returned: Success
----18/10/2007 5:46:58 p.m. admin--bizworkssvr(172.29.35.4)--SSL Disabled GetRepositories returned: Success

The server logging level is set to Debug.

We have restarted the server with no change in behaviour, and yes we have a good backup but because it is only one repository work has been progressing with the other repositories so we dont want to rollback to the last backup.

Is there some cache location for the server that I can clear or a tool to run to verify the tree in the repository?

lbauer · Post by **lbauer** » Thu Oct 18, 2007 6:43 am

If restarting IIS does not fix the tree problem, then there is an inconsistency in the database that needs to be repaired.

We may need to see a copy of your database. Contact support@SourceGear.com Attn: Linda and we will take the next steps.