Welcome to the FogBugz Knowledge Exchange

Question

1

Every day or two I get a report of this error when I'm using FogBugz 7: "Fogbugz failed to commit the session object to the database". This has been going on since upgrading to Fogbugz 7 I believe. I only have a handful of regular users and no-one has reported any problems using the site so I've been dismissing the errors. Any ideas what would cause this, or what I could investigate?

The stack trace below is what we also see with each one.

3/3/2010 5:01 PM (GMT-08:00): Wasabi.Runtime.WasabiException (0x80004005): Could not update; currently locked.
SQL:  UPDATE FBLock SET dtExpires = ?, fBrokeLock = IIF(sKey = '',0,1), sKey = ? WHERE sLock = ?  AND (sKey = '' OR sKey IS NULL OR dtExpires < ? OR dtExpires IS NULL) 
Params: DSSD
1: 3/4/2010 1:01:18 AM
2: 7jda5ao1sggn720ldvgaleghsmsj36
3: SessionWriteLock_cok3u1gissl74m4vtem3pvi25911m0
4: 3/4/2010 1:01:13 AM
 ---> System.Data.OleDb.OleDbException: Could not update; currently locked.
  at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)
  at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
  at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
  at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
  at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
  at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
  at Wasabi.Runtime.ADO.Command.ExecuteNonQuery() in c:\src\Wasabi\Wasabi.Runtime\ADO\Command.cs:line 94
  at FogCreek.FogBugz.CCmd.ExecuteNonQuery(Nullable`1 nCacheClearLevel) in c:\src\FogBugz\distribution\src-Website\CCmd.was:line 236
  at Wasabi.Runtime.Error.Raise(Int32 number, String source, String description, String helpfile, Nullable`1 helpcontext) in c:\src\Wasabi\Wasabi.Runtime\Error.cs:line 88
  at FogCreek.FogBugz.CCmd.ExecuteNonQuery(Nullable`1 nCacheClearLevel) in c:\src\FogBugz\distribution\src-Website\CCmd.was:line 245
  at FogCreek.FogBugz.CLock.GetLock(String sLock, Int32 cSecondsValid, Boolean& fBrokeLock, Nullable`1 fForceTake) in c:\src\FogBugz\distribution\src-Website\CLock.was:line 40
  at FogCreek.FogBugz.CLock.GetLockOrSpin(String sLock, Int32 cSecondsValid, Boolean& fBrokeLock, Int32 cSecondsSpin) in c:\src\FogBugz\distribution\src-Website\CLock.was:line 70
  at FogCreek.FogBugz.CDbSession.GetWriteLock(String sSessionId) in c:\src\FogBugz\distribution\src-Website\CDbSession.was:line 349
  at FogCreek.FogBugz.CDbSession.Commit() in c:\src\FogBugz\distribution\src-Website\CDbSession.was:line 194
  at FogCreek.FogBugz.__Global.DbSessionCommit() in c:\src\FogBugz\distribution\src-Website\webCleanupHandler.was:line 48

Case FC1862628

edited Mar 8 2010 at 16:53

adambox♦♦
19.2k●12●41

asked Mar 5 2010 at 21:21

James Holland
13●2

I have this problem too. – André Mar 8 2010 at 13:57

adambox · Accepted Answer · 2010-03-08 16:48:57Z UTC

0

I have opened a case to investigate this error.

answered Mar 8 2010 at 16:48

adambox♦♦
19.2k●12●41

	Great thx. Should I mark this as the accepted answer or will you post any resolution to this question? – James Holland Mar 9 2010 at 23:39
	Sure, you should see an update here when the case is resolved. If you see more of these and get the Internal Error page where you can submit the exception with your email address, go ahead and do so so we can track how often it's occurring. – adambox♦ Mar 10 2010 at 15:28

Matt Simmons · Answer 2 · 2010-09-09 18:06:49Z UTC

Can we get a bump on this? I got this today:

FogBugz failed to commit the session object to the database. - Hide Notification
9/1/2010 2:20 PM (GMT-04:00): Wasabi.Runtime.WasabiException (0x80004005): Could not update; currently locked.
SQL:  UPDATE FBLock SET dtExpires = ?, fBrokeLock = IIF(sKey = '',0,1), sKey = ? WHERE sLock = ?  AND (sKey = '' OR sKey IS NULL OR dtExpires < ? OR dtExpires IS NULL) 
Params: DSSD
1: 9/1/2010 6:20:29 PM
2: ql3qmvo78t6ff08k3e2h0unq8n2i26
3: SessionWriteLock_tk4co7ek1i042lje5gd9s7vl3che0n
4: 9/1/2010 6:20:24 PM
 ---> System.Data.OleDb.OleDbException: Could not update; currently locked.
  at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)
  at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
  at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
  at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
  at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
  at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
  at Wasabi.Runtime.ADO.Command.ExecuteNonQuery() in c:\src\Wasabi\Wasabi.Runtime\ADO\Command.cs:line 94
  at FogCreek.FogBugz.CCmd.ExecuteNonQuery(Nullable`1 nCacheClearLevel) in c:\src\FogBugz\distribution\src-Website\CCmd.was:line 237
  at Wasabi.Runtime.Error.Raise(Int32 number, String source, String description, String helpfile, Nullable`1 helpcontext) in c:\src\Wasabi\Wasabi.Runtime\Error.cs:line 88
  at FogCreek.FogBugz.CCmd.ExecuteNonQuery(Nullable`1 nCacheClearLevel) in c:\src\FogBugz\distribution\src-Website\CCmd.was:line 247
  at FogCreek.FogBugz.CLock.GetLock(String sLock, Int32 cSecondsValid, Boolean& fBrokeLock, Nullable`1 fForceTake) in c:\src\FogBugz\distribution\src-Website\CLock.was:line 40
  at FogCreek.FogBugz.CLock.GetLockOrSpin(String sLock, Int32 cSecondsValid, Boolean& fBrokeLock, Int32 cSecondsSpin) in c:\src\FogBugz\distribution\src-Website\CLock.was:line 70
  at FogCreek.FogBugz.CDbSession.GetWriteLock(String sSessionId) in c:\src\FogBugz\distribution\src-Website\CDbSession.was:line 349
  at FogCreek.FogBugz.CDbSession.Commit() in c:\src\FogBugz\distribution\src-Website\CDbSession.was:line 194
  at FogCreek.FogBugz.__Global.DbSessionCommit() in c:\src\FogBugz\distribution\src-Website\webCleanupHandler.was:line 49

Any explanation for this error: FogBugz failed to commit the session object to the database?

2 Answers