REALLY URGENT: Repository Lost

aluetjen · Post by **aluetjen** » Fri Jun 24, 2005 10:24 am

Yes, we updated server to 3.07 and currently forcing to update clients also

.

Post by **jclausius** » Fri Jun 24, 2005 10:31 am

The clients are not as important as the server.

Please note, in Vault 3.0.7, the race condition is not eliminated, and you may need to restart the server in case the condition comes up again.

This problem is fixed in the Vault 3.1 Beta 1 & Beta 2 servers.

aluetjen · Post by **aluetjen** » Wed Jun 29, 2005 4:25 am

Hi,
after we succesfully restored our repository we now have problems with single files. You can check out this files and do an undocheckout, but you cannot checkin any changes. Other files work as expected.
We get the following error in a dialog:
A database error has occured (FailDBInsert)
and after that another dialog:
The Check In/Commit transaction failed. See the message pane for details.
And this in the message pane:
[29.06.2005 12:19:53] Server unavailable for transaction end
[29.06.2005 12:19:53] An exception was encountered during the transaction. Exception: Exception of type System.Exception was thrown. at VaultClientOperationsLib.ClientInstance.Commit(ChangeSetItemColl givenItems, Boolean keepCheckedOut, Boolean removeLocalCopy, Boolean bIsImport, DateTime dateImport, Int32 nUserIDImport, Int64& nRevID)
[29.06.2005 12:19:53] Transaction failed
[29.06.2005 12:20:02] Transaction failed
You also cannot delete the files, they are simple blocked for every action.
Thank you for any help.

Post by **jclausius** » Wed Jun 29, 2005 7:06 am

What does the server log say? Does it have anything to do with object versions?

I had asked about a list of object IDs. Do you still have them?

Also, when you ran the scripts, there is a section here that re-syncrhonizes the versions - http://support.sourcegear.com/viewtopic ... 4057#15501
Did everything from this script update correctly?

aluetjen · Post by **aluetjen** » Wed Jun 29, 2005 8:00 am

I just tried to set the serverlogs to debug and having some problems with that. There are no new entries in the log after setting to debug.
For your other questions:
Yes we have the objectIds from friday and yes the files with the problems are on that list.
The script runs without any errors, but it has output with a list of files. They are the files with the problems.
I still have this output.

Post by **jclausius** » Wed Jun 29, 2005 8:08 am

If you have the object ids, let's run a check on one of them. Pick out a number, and then run the following query (substituting an objectid from your list). What are the results?

DECLARE @objid bigint
SET @objid = <PICK AN OBJID>

SELECT o.objid, o.lastobjversion, MAX(v.objversion) FROM sgvault.dbo.tblfsobjects o INNER JOIN sgvault.dbo.tblfsobjectversions v ON (o.objid = v.objid) WHERE o.objid = @objid GROUP BY o.objid, o.lastobjversion

aluetjen · Post by **aluetjen** » Wed Jun 29, 2005 8:08 am

This is the list of files:
55022 vostapenko SPSAffectedFragment.ascx.cs 16073 7 24 2005-06-24 14:17:01.863 2005-06-24 14:17:02.457 16073 2 1 166598 162914

55133 vostapenko SelectUser.ascx.cs 16073 7 24 2005-06-24 14:17:01.863 2005-06-24 14:17:02.457 16073 6 1 166602 164824

55136 vostapenko UserFinish.ascx.cs 16073 7 24 2005-06-24 14:17:01.863 2005-06-24 14:17:02.457 16073 5 1 166601 164790

55546 vostapenko SelectRole.ascx.cs 16073 7 24 2005-06-24 14:17:01.863 2005-06-24 14:17:02.457 16073 3 1 166599 164823

55550 vostapenko NewRoleFinish.ascx.cs 16073 7 24 2005-06-24 14:17:01.863 2005-06-24 14:17:02.457 16073 4 1 166600 164817

56623 vostapenko NotificationSubscriptions.aspx 16073 7 24 2005-06-24 14:17:01.863 2005-06-24 14:17:02.457 16073 1 1 166597 165149

and the output from the script (sorry it was a list of ObjectIDs and not files):

55550

56623

54980

55022

55534

55019

55122

55136

55546

55133

55018

Post by **jclausius** » Wed Jun 29, 2005 8:10 am

OK. Go ahead and pick one. Let's see if these files were updated.

aluetjen · Post by **aluetjen** » Wed Jun 29, 2005 8:11 am

This is the result of your select:

objid lastobjversion
-------------------- -------------------- --------------------
56623 1 1

Post by **jclausius** » Wed Jun 29, 2005 8:24 am

That looks OK. If you try to do an action on that file, and it fails there should be something in the server's log. What does that say?

aluetjen · Post by **aluetjen** » Wed Jun 29, 2005 8:34 am

That is actually a problem. I just checked and there is no loggin since friday last week. I think that was the time when we updated the server. Any ideas? I already set log level to debug, reset the iis and back again. No effect.

Post by **jclausius** » Wed Jun 29, 2005 8:42 am

So a current sgvault.log is nowhere to be found? Are you running Vault server as an impersonated user?

aluetjen · Post by **aluetjen** » Wed Jun 29, 2005 8:54 am

Good hint! Not enough rights on the folder.
This is a snippet from the log with the failed transaction:
----29.06.2005 16:51:08 mascher--10.1.60.248(10.1.60.248)--SSL Enabled BeginTx beginning transaction
----29.06.2005 16:51:08 mascher--10.1.60.248(10.1.60.248)--SSL Enabled BeginTx returned: Success
----29.06.2005 16:51:08 mascher--10.1.60.248(10.1.60.248)--SSL Enabled VaultLib.VaultRequestCheckIn returned: Success
----29.06.2005 16:51:08 mascher--10.1.60.248(10.1.60.248)--SSL Enabled Receiving an uploaded file.
----29.06.2005 16:51:08 mascher--10.1.60.248(10.1.60.248)--SSL Enabled VaultFileUpload.aspx encountered: Success
----29.06.2005 16:51:08 mascher--10.1.60.248(10.1.60.248)--SSL Enabled Ending transaction
----29.06.2005 16:51:08 mascher--10.1.60.248(10.1.60.248)--SSL Enabled Cannot insert duplicate key row in object 'tblfsobjectversions' with unique index 'idxfsobjectversionversions'.
The statement has been terminated.
----29.06.2005 16:51:08 mascher--10.1.60.248(10.1.60.248)--SSL Enabled Could not create bubble folders: Error in the application.
----29.06.2005 16:51:08 mascher--10.1.60.248(10.1.60.248)--SSL Enabled VaultLib.VaultResponseCheckIn returned: Success
----29.06.2005 16:51:08 mascher--10.1.60.248(10.1.60.248)--SSL Enabled EndTxFailDBInsert
----29.06.2005 16:51:10 mascher--10.1.60.248(10.1.60.248)--SSL Enabled Getting repository Structure.
----29.06.2005 16:51:10 mascher--10.1.60.248(10.1.60.248)--SSL Enabled VaultServiceAPI::GetRepositoryTreeDelta() UserID:3 RepID:7 Base:16291 Target:16291 Calling VaultRepUtil.DiffRepTrees() - in-memory tree diff.
----29.06.2005 16:51:10 mascher--10.1.60.248(10.1.60.248)--SSL Enabled GetRepositoryStructure returned: Success
----29.06.2005 16:51:10 mascher--10.1.60.248(10.1.60.248)--SSL Enabled Getting list of checkout changes.
----29.06.2005 16:51:20 mascher--10.1.60.248(10.1.60.248)--SSL Enabled VaultServiceAPI::GetCheckoutListChanges() Status:0 UserID:3 RepID:7 FolderSecurity:True BaseList:23792 Target List:23793 RefreshFlag:False
----29.06.2005 16:51:20 mascher--10.1.60.248(10.1.60.248)--SSL Enabled GetCheckOutListChanges returned: Success

Post by **jclausius** » Wed Jun 29, 2005 9:00 am

Is this file in a shared folder? Or is one of the parents to root shared?

aluetjen · Post by **aluetjen** » Wed Jun 29, 2005 9:10 am

No, it is not.
But as I tried to view the properties of the containing folders I got an error on one of the folders:
----29.06.2005 17:06:37 mascher--10.1.60.248(10.1.60.248)--SSL Enabled Data is Null. This method or property cannot be called on Null values.
this folder contains all files that have problems in different folders.