Error: "A database error has occured (FailDBInsert)"

[jrasch]

When attempting to create a label with our Continuous Integration tool BuildMaster, we received the error: "A database error has occured (FailDBInsert)" in the error log. When performing the same operation within the GUI, we got the same error.

Looking at the error in the %WINDIR%/Temp/sgvault/sgvault.log file, we saw:

Code: Select all

----8/22/2012 11:14:07 AM    testuser--INEDOBLDSV1(192.168.44.61)--SSL Disabled	System.Data.SqlClient.SqlException: Could not allocate space for object 'dbo.tblfsobjectlabelviews'.'idxfsobjectlabelviewslabelidtreelevelfullpathhashparentpathhash' in database 'sgvault' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
...

The recommended fix for this is to enable auto-growth on the database. Ours was enabled, but unfortunately after 1000s of commits and labels, our sgvault database size has grown to 4GB.

Since this particular database instance was SQL Server 2008 Express, the database would fail when attempting to expand because there is a 4GB limit to database under this engine.

Upgrading to SQL Server 2008 R2 Standard resolved the issue. Hope this helps!

[lbauer]

Thanks for the info. Glad you were able to recover from this error.

the 'PRIMARY' filegroup is full

This error can mean SQL Server has run out of disk space or SQL Express has met its size limit.

For SQL Express 2005 and 2008 users: SQL Server Express 2008 R2 has a 10 GB database size limit.
If your database exceeds that size, then SQL Server standard would be needed.