Index is still being built

If you are having a problem using Vault, post a message here.

Moderator: SourceGear

Post Reply
mbennett
Posts: 2
Joined: Fri Feb 26, 2016 11:35 am

Index is still being built

Post by mbennett » Fri Feb 26, 2016 11:46 am

Using Vault 9.0.0

I turned on indexing yesterday so that Find In Files would work, but this evening I'm still getting the error message "The repository's index is currently being built".

Looking in C:\Windows\Temp\SGVaultIndex the log file only contains the six lines

21/12/2015 09:40:56 <generic>: GetEntryAssembly() returned null; not logging assembly name
21/12/2015 09:40:56 <generic>: SourceGear Index Service started.
24/02/2016 17:57:17 <generic>: GetEntryAssembly() returned null; not logging assembly name
24/02/2016 17:57:17 <generic>: SourceGear Index Service started.
25/02/2016 10:47:07 <generic>: Repoistory 6 is in the process of building. This subsequent request will be ignored.
25/02/2016 10:53:48 <generic>: Started index build for repository "6"

It's now 26/02/2016 17:41

The CPU on the server is running at close to 100% with 50% of that being taken by IIS Worker Process, SQL Server taking most of the rest.

The sgvaultindex.mdf file has grown to 2.6GB and is still growing.
The sgvault.mdf file is 7.8GB

Is the indexing still working? Do I just need to wait longer?

Mike

Beth
Posts: 8550
Joined: Wed Jun 21, 2006 8:24 pm
Location: SourceGear
Contact:

Re: Index is still being built

Post by Beth » Mon Feb 29, 2016 11:09 am

It looks like the index is still building. It's a slow process.
Beth Kieler
SourceGear Technical Support

mbennett
Posts: 2
Joined: Fri Feb 26, 2016 11:35 am

Re: Index is still being built

Post by mbennett » Fri Aug 18, 2017 3:34 am

I'd forgotten all about the index until today. Attempting to use the Find in Files option results in the message:

An error occurred in Find in Files. Server Error: [3000] - The repository's index status is not currently enabled.

Going to the Admin console and selecting Find in Files shows a red message at the top:

An unknown status was retrieved for the Planet FM Enterprise repository ( repository id: 6 ). Please contact Technical Support.

The On and Suspend buttons are greyed out. I've tried clicking Off and checking Purge Index data then clicking save, but this makes not difference.

The last lines in vautlindexservice log are as follows:

13/07/2017 11:32:40 <generic>: File: $/Visual Studio/Visual Studio 2013/Shared/BusinessObjects/Code/LabelsConst.cs (1569216) in the delta does not exist in the tree cache.. The File List "30H^IL!D.5~A" contains 0 other files. The indexed repository data for "Planet FM Enterprise" (6) may be out of date for this folder.
13/07/2017 11:32:40 <generic>: File ID:1569216 TreeCache File List "C:\Windows\Temp\SGVaultIndex\cache\AF077DB8-C92D-4D8A-A721-56C0249D9214\admin\3\0\30H^IL!D.5~A".
13/07/2017 11:32:41 <generic>: During a work request UPDATE, the Repository.Update or Repository.Serialize calls threw an exception. [VaultClientOperationsLib.PluginException_CacheFileList: The file list cache file is incorrect for the this folder ($/_Snapshots/Version 10.62.1/Customers/S0718/SBS Accounts Interface/Code). Cache File: C:\Windows\Temp\SGVaultIndex\cache\AF077DB8-C92D-4D8A-A721-56C0249D9214\admin\F\4\F4HFSFGE.5~A Cache File Version: 10, but expected Version: 12
at VaultClientOperationsLib.PluginFolder.LoadFileList(String strAbsFileListCacheFile)
at VaultClientOperationsLib.PluginFolder.LoadFileListIfOld(String strAbsFileListCacheFile)
at VaultClientOperationsLib.PluginFolder.BeforeUpdateFolderDelta(VaultFolderDelta fd)
at VaultClientOperationsLib.VaultClientFolder.Update(VaultFolderDelta fd, String deltaFolderPath, ArrayList deletedObjects, ArrayList addedObjects, TreeCache treeCache, Object objItemData)
at VaultClientOperationsLib.VaultClientFolder.Update(VaultFolderDelta fd, String deltaFolderPath, ArrayList deletedObjects, ArrayList addedObjects, TreeCache treeCache, Object objItemData)
at VaultClientOperationsLib.VaultClientFolder.Update(VaultFolderDelta fd, String deltaFolderPath, ArrayList deletedObjects, ArrayList addedObjects, TreeCache treeCache, Object objItemData)
at VaultClientOperationsLib.VaultClientFolder.Update(VaultFolderDelta fd, String deltaFolderPath, ArrayList deletedObjects, ArrayList addedObjects, TreeCache treeCache, Object objItemData)
at VaultClientOperationsLib.VaultClientFolder.Update(VaultFolderDelta fd, String deltaFolderPath, ArrayList deletedObjects, ArrayList addedObjects, TreeCache treeCache, Object objItemData)
at VaultClientOperationsLib.VaultClientFolder.Update(VaultFolderDelta fd, String deltaFolderPath, ArrayList deletedObjects, ArrayList addedObjects, TreeCache treeCache, Object objItemData)
at VaultClientOperationsLib.VaultClientFolder.Update(VaultFolderDelta fd, String deltaFolderPath, ArrayList deletedObjects, ArrayList addedObjects, TreeCache treeCache, Object objItemData)
at VaultClientOperationsLib.PluginRepository.Update(VaultRepositoryDelta delta, Boolean bClearFileListCache)
at VaultIndexService.IndexServiceProcessWorkerThread.HandleRequest_UpdateIndex_Initialize(VaultIndexManager vim, PluginRepositoryConnection repConn, IndexServiceUpdateIndexData updtIndexData)] The file list cache file is incorrect for the this folder ($/_Snapshots/Version 10.62.1/Customers/S0718/SBS Accounts Interface/Code). Cache File: C:\Windows\Temp\SGVaultIndex\cache\AF077DB8-C92D-4D8A-A721-56C0249D9214\admin\F\4\F4HFSFGE.5~A Cache File Version: 10, but expected Version: 12
at VaultClientOperationsLib.PluginFolder.LoadFileList(String strAbsFileListCacheFile)
at VaultClientOperationsLib.PluginFolder.LoadFileListIfOld(String strAbsFileListCacheFile)
at VaultClientOperationsLib.PluginFolder.BeforeUpdateFolderDelta(VaultFolderDelta fd)
at VaultClientOperationsLib.VaultClientFolder.Update(VaultFolderDelta fd, String deltaFolderPath, ArrayList deletedObjects, ArrayList addedObjects, TreeCache treeCache, Object objItemData)
at VaultClientOperationsLib.VaultClientFolder.Update(VaultFolderDelta fd, String deltaFolderPath, ArrayList deletedObjects, ArrayList addedObjects, TreeCache treeCache, Object objItemData)
at VaultClientOperationsLib.VaultClientFolder.Update(VaultFolderDelta fd, String deltaFolderPath, ArrayList deletedObjects, ArrayList addedObjects, TreeCache treeCache, Object objItemData)
at VaultClientOperationsLib.VaultClientFolder.Update(VaultFolderDelta fd, String deltaFolderPath, ArrayList deletedObjects, ArrayList addedObjects, TreeCache treeCache, Object objItemData)
at VaultClientOperationsLib.VaultClientFolder.Update(VaultFolderDelta fd, String deltaFolderPath, ArrayList deletedObjects, ArrayList addedObjects, TreeCache treeCache, Object objItemData)
at VaultClientOperationsLib.VaultClientFolder.Update(VaultFolderDelta fd, String deltaFolderPath, ArrayList deletedObjects, ArrayList addedObjects, TreeCache treeCache, Object objItemData)
at VaultClientOperationsLib.VaultClientFolder.Update(VaultFolderDelta fd, String deltaFolderPath, ArrayList deletedObjects, ArrayList addedObjects, TreeCache treeCache, Object objItemData)
at VaultClientOperationsLib.PluginRepository.Update(VaultRepositoryDelta delta, Boolean bClearFileListCache)
at VaultIndexService.IndexServiceProcessWorkerThread.HandleRequest_UpdateIndex_Initialize(VaultIndexManager vim, PluginRepositoryConnection repConn, IndexServiceUpdateIndexData updtIndexData)

13/07/2017 16:20:17 <generic>: PluginFolder::Read - The repository Planet FM Enterprise includes cache file (C:\Windows\Temp\SGVaultIndex\cache\AF077DB8-C92D-4D8A-A721-56C0249D9214\admin\7\G\7GLGN3@D.5~A) for folder $/Delphi 7/Library/Code/Library for version 1447, but the Tree Cache indicates the folder version is 1446. The cache is invalid.
13/07/2017 16:20:17 <generic>: Failed to load the repository id 6. Requesting a new repository structure from the server http://127.0.0.1/VaultService [Revision -1].
13/07/2017 16:55:10 <generic>: The Indexing service tried to process TxID "134078" for repository "6". However, the cached repository has a revision of "134079" and the txid from indexedrepositories in the datbase has a revision of "134005". The Index Service disabled indexing in this repository as an index rebuild may be required. Please contact SourceGear Technical Support.
14/07/2017 20:39:43 <generic>: SimpleLogger finalized
17/07/2017 08:49:38 <generic>: GetEntryAssembly() returned null; not logging assembly name
17/07/2017 08:49:38 <generic>: SourceGear Index Service started.
02/08/2017 14:06:48 <generic>: GetEntryAssembly() returned null; not logging assembly name
02/08/2017 14:06:49 <generic>: SourceGear Index Service started.
04/08/2017 10:09:38 <generic>: GetEntryAssembly() returned null; not logging assembly name
04/08/2017 10:09:38 <generic>: SourceGear Index Service started.
11/08/2017 19:41:10 <generic>: SimpleLogger finalized
14/08/2017 08:34:38 <generic>: GetEntryAssembly() returned null; not logging assembly name
14/08/2017 08:34:38 <generic>: SourceGear Index Service started.


Using Vault 9.0.0 (452)

Beth
Posts: 8550
Joined: Wed Jun 21, 2006 8:24 pm
Location: SourceGear
Contact:

Re: Index is still being built

Post by Beth » Fri Aug 18, 2017 8:21 am

Was there a database restore at any time since February?

As far as the error in the database, it looks like Vault got past it. If you turn it off now, it will take some time for Vault to purge the contents of the database. After you click Save, what does the screen look like. Can you refresh it and then send me a screenshot? You can black out the URL or confidential information.
Beth Kieler
SourceGear Technical Support

Post Reply