Menu

#31 Error on lock_contention_v15.php when only one lock

v1.0_(example)
closed
nobody
report (2)
1
2013-02-11
2013-02-11
No

The insertion is temp table #blk_max generate an error, if only 1 lock in the period.

The correction is in line 69 of lock_contention_v15.php
Before :
-- sav last row found
insert into #blk_max values (@savBlockedBy,@savts,@savWT)
After :
-- sav last row found
if (@savBlockedBy is not null)
insert into #blk_max values (@savBlockedBy,@savts,@savWT)

Discussion

  • Jean-Paul Martin

    • status: open --> closed
     
  • Jean-Paul Martin

    Ok thanks, I fixed it in 2.7.8

     

Anonymous
Anonymous

Add attachments
Cancel





MongoDB Logo MongoDB