Could not allocate space for object tblfileinfo

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

Moderator: SourceGear

Post Reply
smo
Posts: 2
Joined: Fri Mar 31, 2006 8:58 am

Could not allocate space for object tblfileinfo

Post by smo » Fri Mar 31, 2006 9:04 am

I've been doing some load testing and i've manged to kill the app without too much difficulty.
I cannot add any more files despite having only 1.73GB of data in around 5000 files (in one repository with many subfolders).
Is there some kind of hard limit around 2GB for the vault DB?
Specific error details as follows:

----1/04/2006 12:47:04 AM admin--myPC(192.168.2.3)--SSL Disabled EndTx (Revision - 0) returned: FailDBFileStream
----1/04/2006 12:47:04 AM admin--myPC(192.168.2.3)--SSL Disabled AddFile: $/MOVIES/eb1002_512.avi returned: FailDBFileStream
----1/04/2006 12:47:15 AM admin--myPC(192.168.2.3)--SSL Disabled Logout
----1/04/2006 12:47:26 AM admin--myPC(192.168.2.3)--SSL Disabled Login
----1/04/2006 12:47:48 AM admin--myPC(192.168.2.3)--SSL Disabled System.Data.SqlClient.SqlException: Could not allocate space for object 'tblfileinfo' in database 'sgvault' because the 'PRIMARY' filegroup is full.
The statement has been terminated.

lbauer
Posts: 9736
Joined: Tue Dec 16, 2003 1:25 pm
Location: SourceGear

Post by lbauer » Fri Mar 31, 2006 11:18 am

A Vault database can be as large as allowed in SQL Server. We've worked with customers who have Vault databases larger than 100 GB.

What version of SQL Server are you using? MSDE 2000 and SQL Server Express 2005 have database size limits.
Linda Bauer
SourceGear
Technical Support Manager

smo
Posts: 2
Joined: Fri Mar 31, 2006 8:58 am

Problem solved

Post by smo » Fri Mar 31, 2006 8:21 pm

When you're right, you're right.
Test machine had msde installed as the default instance. have migrated up to 2k5 dev edition and we're moving along swimmingly at 40GB and growing.

thx muchly.

Post Reply