REALLY URGENT: Repository Lost

This forum is now locked, since Gold Support is no longer offered.

Moderator: SourceGear

aluetjen
Posts: 40
Joined: Wed May 19, 2004 1:00 am
Location: Germany, Karlsruhe
Contact:

REALLY URGENT: Repository Lost

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
update4u Software AG

jclausius
Posts: 3702
Joined: Tue Dec 16, 2003 1:17 pm
Location: SourceGear
Contact:

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
Jeff Clausius
SourceGear

jclausius
Posts: 3702
Joined: Tue Dec 16, 2003 1:17 pm
Location: SourceGear
Contact:

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 )
Jeff Clausius
SourceGear

aluetjen
Posts: 40
Joined: Wed May 19, 2004 1:00 am
Location: Germany, Karlsruhe
Contact:

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
update4u Software AG

aluetjen
Posts: 40
Joined: Wed May 19, 2004 1:00 am
Location: Germany, Karlsruhe
Contact:

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
Last edited by aluetjen on Fri Jun 24, 2005 10:23 am, edited 1 time in total.
update4u Software AG

aluetjen
Posts: 40
Joined: Wed May 19, 2004 1:00 am
Location: Germany, Karlsruhe
Contact:

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
update4u Software AG

aluetjen
Posts: 40
Joined: Wed May 19, 2004 1:00 am
Location: Germany, Karlsruhe
Contact:

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
update4u Software AG

jclausius
Posts: 3702
Joined: Tue Dec 16, 2003 1:17 pm
Location: SourceGear
Contact:

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);
Jeff Clausius
SourceGear

aluetjen
Posts: 40
Joined: Wed May 19, 2004 1:00 am
Location: Germany, Karlsruhe
Contact:

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
update4u Software AG

jclausius
Posts: 3702
Joined: Tue Dec 16, 2003 1:17 pm
Location: SourceGear
Contact:

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;
Jeff Clausius
SourceGear

aluetjen
Posts: 40
Joined: Wed May 19, 2004 1:00 am
Location: Germany, Karlsruhe
Contact:

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

Ok, done. It showed me 6 files.
update4u Software AG

aluetjen
Posts: 40
Joined: Wed May 19, 2004 1:00 am
Location: Germany, Karlsruhe
Contact:

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
update4u Software AG

jclausius
Posts: 3702
Joined: Tue Dec 16, 2003 1:17 pm
Location: SourceGear
Contact:

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.
Jeff Clausius
SourceGear

aluetjen
Posts: 40
Joined: Wed May 19, 2004 1:00 am
Location: Germany, Karlsruhe
Contact:

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

We successfully restored the repository.

Again, thank you very much.

Regards, Alex
update4u Software AG

jclausius
Posts: 3702
Joined: Tue Dec 16, 2003 1:17 pm
Location: SourceGear
Contact:

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.
Jeff Clausius
SourceGear

Locked