diff options
author | drh <drh@noemail.net> | 2001-09-16 00:13:26 +0000 |
---|---|---|
committer | drh <drh@noemail.net> | 2001-09-16 00:13:26 +0000 |
commit | b19a2bc6036e680d4e7d995049be5dcba96cae7f (patch) | |
tree | fb42fcfe8bcb49e0cce93f61d6fd888698798f93 /notes/notes1.txt | |
parent | 872ff86f2c0ee7b171c46609f49af16a0cc31b9c (diff) | |
download | sqlite-b19a2bc6036e680d4e7d995049be5dcba96cae7f.tar.gz sqlite-b19a2bc6036e680d4e7d995049be5dcba96cae7f.zip |
Disclaimed copyright. Preparing for release 2.0. (CVS 250)
FossilOrigin-Name: 4e926efe2b59adfec4086eb1d2ba830238facb4c
Diffstat (limited to 'notes/notes1.txt')
-rw-r--r-- | notes/notes1.txt | 55 |
1 files changed, 0 insertions, 55 deletions
diff --git a/notes/notes1.txt b/notes/notes1.txt deleted file mode 100644 index 951711ea3..000000000 --- a/notes/notes1.txt +++ /dev/null @@ -1,55 +0,0 @@ -unlocked -> read - - 1. If the journal file exists - A. Open the journal file for exclusive access - i) return SQLITE_BUSY - B. Get a write lock on the database - i) close the journal file - ii) return SQLITE_PROTOCOL_ERROR - C. playback the journal - D. close and delete the journal file - E. drop the write lock on the database - 2. Get a read lock on the database file. - A. return SQLITE_BUSY - 3. return SQLITE_OK - -read -> unlocked - - 1. Drop the read lock on the database file - 2. Invalidate all pages in the cache - 3. return SQLITE_OK - -read -> write - - 1. Create the journal file and open for exclusive access - A. return SQLITE_BUSY - 2. Drop the read lock on the database - 3. Get a write lock on the database - A. Get a read lock on the database - i) return SQLITE_PROTOCOL_ERROR - B. Delete the journal - C. return SQLITE_BUSY - 4. return SQLITE_OK - -write -> read (commit) - - 1. Sync the journal - 2. Write all dirty pages - A. playback journal - B. Reload or invalidate all pages in cache - 3. Sync the database - 4. Drop the write lock on the database - 5. Get a read lock on the database - A. return SQLITE_PROTOCOL_ERROR - 6. Delete the journal - 7. return SQLITE_OK - -write -> read (rollback) - - 1. Playback the journal - 2. Drop the write lock on the database - 3. Get a read lock on the database - A. return SQLITE_PROTOCOL_ERROR - 4. Delete the journal - 5. Reload or invalidate all pages in cache - 6. SQLITE_FULL |