REALLY URGENT: Repository Lost

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

Hi,

I just lost my main Vault repository!

It simply no more appears in Vault Admin or Vault Client. There are no error/warning log entries.

You can imaging that fast help would be really appreciated!

Thank You!

Regards, Alex

Post by **jclausius** » Fri Jun 24, 2005 9:09 am

Alex:

What version of the server are you running? Is it Vault 3.0.7 or Vault 3.1 Beta?

Is it safe to assume it is a version before Vault 3.0.7?

I'm going to ask some questions based on this posting - http://support.sourcegear.com/viewtopic.php?t=4057

Jeff

Post by **jclausius** » Fri Jun 24, 2005 9:09 am

We'll start off with the results of these queries:

1) SELECT repid, name, currenttxid FROM sgvault.dbo.tblrepositories

2) SELECT x.repid, x.txid FROM sgvault.dbo.tblfulltreerevisionfolders x WHERE EXISTS ( SELECT y.repid FROM sgvault.dbo.tblrepositories y WHERE y.repid = x.repid AND y.currenttxid = x.txid )

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

> Is it safe to assume it is a version before Vault 3.0.7?

We are running 3.02

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

SELECT repid, name, currenttxid FROM sgvault.dbo.tblrepositories

3 ... 16076
4 ... 15628
5 ... 5
6 ... 8962
7 ... 16073 <-- Lost repository
8 ... 5598
9 ... 5775

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

SELECT x.repid, x.txid FROM sgvault.dbo.tblfulltreerevisionfolders x WHERE EXISTS ( SELECT y.repid FROM sgvault.dbo.tblrepositories y WHERE y.repid = x.repid AND y.currenttxid = x.txid )

3 16076
4 15628
5 5
6 8962
8 5598
9 5775

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

DECLARE @repid [bigint];
SET @repid = 7;

SELECT MAX(txid) FROM sgvault.dbo.tblfulltreerevisionfolders WHERE repid = @repid;

SELECT t.* FROM sgvault.dbo.tbltransactions t WHERE t.repid = @repid AND t.txid >=
(SELECT MAX(txid) FROM sgvault.dbo.tblfulltreerevisionfolders WHERE repid = @repid);

16072

16072 7 2 2005-06-24 14:16:50.347 2005-06-24 14:16:51.207
16073 7 24 2005-06-24 14:17:01.863 2005-06-24 14:17:02.457

Post by **jclausius** » Fri Jun 24, 2005 9:22 am

OK. Step 2

DECLARE @repid [bigint];
SET @repid = 7;

SELECT MAX(txid) FROM sgvault.dbo.tblfulltreerevisionfolders WHERE repid = @repid;

SELECT t.* FROM sgvault.dbo.tbltransactions t WHERE t.repid = @repid AND t.txid >=
(SELECT MAX(txid) FROM sgvault.dbo.tblfulltreerevisionfolders WHERE repid = @repid);

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

Yep, here it is:

16072

16072 7 2 2005-06-24 14:16:50.347 2005-06-24 14:16:51.207
16073 7 24 2005-06-24 14:17:01.863 2005-06-24 14:17:02.457

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

Step 3 from the previous thread

Let's get an idea of files were changed. You don't need to report this back, but use this information to inform users they will need to re-commit their changes. Also keep the object ids around for confirmation after we're done.

DECLARE @lasttxid [bigint], @repid [int];
SELECT @repid = 7, @lasttxid = 16072;

SELECT v.objid, u.login, n.name, t.*, td.* FROM sgvault.dbo.tbltransactions t
INNER JOIN sgvault.dbo.tbltransactiondetails td ON (td.txid = t.txid)
INNER JOIN sgvault.dbo.tblfsobjectversions v ON (v.objverid =
td.itemobjverid) INNER JOIN sgvault.dbo.tblfsobjectversionnames n ON (n.vernameid = v.vernameid) INNER JOIN sgvault.dbo.tblusers u ON (u.userid = t.userid) WHERE t.repid = @repid and t.txid > @lasttxid;

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

Ok, done. It showed me 6 files.

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

I'll follow from now the steps pointed out in the thread you referenced.

Thank you for your fast assistance!

With the best regards,

Alex

Post by **jclausius** » Fri Jun 24, 2005 9:42 am

I'll be monitoring *this* thread to check on your progress.

BTW, when you've completed, please make you update the server to Vault 3.0.7 or the Vault 3.1 Beta 2 server.

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

We successfully restored the repository.

Again, thank you very much.

Regards, Alex

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

Great news. The big thing now is to make sure the server is up to Vault 3.0.7 or Vault 3.1 Beta 2.