A database error has occured (FailDBReader)

kasti · Post by **kasti** » Mon Feb 28, 2005 8:55 am

Hi,

After upgrading to vault 3.0.3, we get the following error when a client connects to a repository:

A database error has occured (FailDBReader)

In the server log, the following messages are shown (user/ip x'ed out):

----2/28/2005 3:36:42 PM XXXXXXX--YYYYYYYYYYY--SSL Disabled Violation of PRIMARY KEY constraint 'PK__#targetcheckoutl__11D56EA6'. Cannot insert duplicate key in object '#targetcheckoutlistitems____________________________________________________________________________________________000100000024'.
----2/28/2005 3:36:42 PM XXXXXXX--YYYYYYYYYYY--SSL Disabled GetCheckOutListChanges returned: FailDBReader

Here is the log with server set to debug log level:

# SourceGear Vault Server
System Started
Version 3.0.3.2828
Cache Level = 1
DataBase Buffer Size (KB) = 768
LogFile Path = d:\VaultLog
Log Level = Debug
Archive Log = Weekly
ReverseDNS Lookup = False
Maximum HTTP Request Length = 102400
Overwrite Log on Startup = False
Session Timeout = 4320
Active Directory Domain =
SGVault Working Directory = d:\VaultWork
SGVault Server URL =
Identity = RDE-SW\vaultsql
----2/28/2005 3:51:01 PM XXXXXXX--YYYYYYYYY--SSL Disabled Login
----2/28/2005 3:51:01 PM XXXXXXX--YYYYYYYYY--SSL Disabled GetUserList returned: Success
----2/28/2005 3:51:02 PM XXXXXXX--YYYYYYYYY--SSL Disabled GetUserOptions returned: Success
----2/28/2005 3:51:02 PM XXXXXXX--YYYYYYYYY--SSL Disabled GetRepositories returned: Success
----2/28/2005 3:51:02 PM XXXXXXX--YYYYYYYYY--SSL Disabled Getting repository Structure.
----2/28/2005 3:51:15 PM XXXXXXX--YYYYYYYYY--SSL Disabled VaultServiceAPI::GetRepositoryTreeDelta() UserID:2 RepID:2 Base:0 Target:3701 Calling VaultRepUtil.DiffRepTrees() - in-memory tree diff.
----2/28/2005 3:51:15 PM XXXXXXX--YYYYYYYYY--SSL Disabled VaultServiceAPI::PrepareTreeDeltaForTransport() nNumDeltaNodes:6794 Base:0 Target:3701
----2/28/2005 3:51:15 PM XXXXXXX--YYYYYYYYY--SSL Disabled GetRepositoryStructure returned: Success
----2/28/2005 3:51:15 PM XXXXXXX--YYYYYYYYY--SSL Disabled VaultFileDownload starting
----2/28/2005 3:51:16 PM XXXXXXX--YYYYYYYYY--SSL Disabled GetLatest wrote 0 bytes to the Response Stream
----2/28/2005 3:51:16 PM XXXXXXX--YYYYYYYYY--SSL Disabled Ending download process
----2/28/2005 3:51:16 PM XXXXXXX--YYYYYYYYY--SSL Disabled EndDownloadProcess returned: Success
----2/28/2005 3:51:16 PM XXXXXXX--YYYYYYYYY--SSL Disabled Getting list of checkout changes.
----2/28/2005 3:51:16 PM XXXXXXX--YYYYYYYYY--SSL Disabled Violation of PRIMARY KEY constraint 'PK__#targetcheckoutl__4F88885C'. Cannot insert duplicate key in object '#targetcheckoutlistitems____________________________________________________________________________________________000100000026'.
----2/28/2005 3:51:16 PM XXXXXXX--YYYYYYYYY--SSL Disabled VaultServiceAPI::GetCheckoutListChanges() Status:1104 UserID:2 RepID:2 FolderSecurity:True BaseList:0 Target List:972 RefreshFlag:False
----2/28/2005 3:51:16 PM XXXXXXX--YYYYYYYYY--SSL Disabled GetCheckOutListChanges returned: FailDBReader

1. This problem occurs for any user except Admin where no problems have been seen.
2. This problem only occurs in one repository (out of 3). The others work fine
3. Deleting Cache directories does not help
4. restarting vault / sql server does not help

Any quick help will be appreciated as we can not get to the database.

Thanks,
Herbert.

Post by **jclausius** » Mon Feb 28, 2005 9:17 am

Hang on.... I need to check the primary key here.

Post by **jclausius** » Mon Feb 28, 2005 9:19 am

What version of Vault did you upgrade from?

kasti · Post by **kasti** » Mon Feb 28, 2005 9:40 am

Hi Jeff,

I can not say 100% i think it was 3.0.1 but could have been 3.0.2.

Hope this is enough info,

Thanks,
Herbert.

Post by **jclausius** » Mon Feb 28, 2005 10:18 am

I just sent you a private message, did you receive this?

Post by **jclausius** » Mon Feb 28, 2005 2:22 pm

This was fixed in Vault 3.0.4, which is now available for download.