Bug 31104 - PostgresRDBMSAdapter leaves locks in table URI
Summary: PostgresRDBMSAdapter leaves locks in table URI
Status: RESOLVED FIXED
Alias: None
Product: Slide
Classification: Unclassified
Component: Stores (show other bugs)
Version: 2.1
Hardware: Other other
: P3 normal (vote)
Target Milestone: ---
Assignee: Slide Developer List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-09-07 18:34 UTC by Steve Vaughan
Modified: 2004-11-16 19:05 UTC (History)
0 users


Attachments
Diff for PostgresRDBMSAdapter.java (842 bytes, patch)
2004-09-07 18:36 UTC, Steve Vaughan 		Details | Diff
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Steve Vaughan 2004-09-07 18:34:55 UTC 
The removeLock method attempts to perform two statements:
1) delete from LOCKS where LOCK_ID = URI.URI_ID and URI.URI_STRING=?
2) delete from URI where URI_ID = LOCKS.LOCK_ID and URI_STRING=?

The second statement never deletes a row since the row for containing the 
LOCK_ID was deleted in the first statement.
Comment 1 Steve Vaughan 2004-09-07 18:36:41 UTC 
Created attachment 12664 [details]
Diff for PostgresRDBMSAdapter.java
Comment 2 Oliver Zeigermann 2004-09-08 05:04:48 UTC 
Patch applied in CVS Head and 2.1 release branch