Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for src/wal.h
2024-11-16
| ||
18:37 | [a1ec57934a] part of check-in [17360660bb] Clean up the implementation now that it only has to deal with the much simplier concept of COMMIT AND CONTINUE TRANSACTION. (check-in: [17360660bb] user: drh branch: commit-and-continue, size: 6273) | |
2024-11-15
| ||
17:28 | [3289ab8741] part of check-in [a905bd5dd6] Another approach at implementing COMMIT AND BEGIN. (check-in: [a905bd5dd6] user: drh branch: commit-and-continue, size: 6232) | |
2024-10-04
| ||
14:11 | [8c59ee7a83] part of check-in [bbbd3d9be8] Add further logging intended for use in analyzing COMMIT performance. (check-in: [bbbd3d9be8] user: dan branch: bedrock-commit-instr, size: 6888) | |
2023-08-21
| ||
18:31 | [8d02ab8c2a] part of check-in [4d8df0c426] Merge latest changes from the wal2 branch into this one. (check-in: [4d8df0c426] user: dan branch: bedrock, size: 6828) | |
18:03 | [e9aeb67102] part of check-in [76a99a2c40] Merge the latest trunk enhancements into the begin-concurrent branch. (check-in: [76a99a2c40] user: drh branch: begin-concurrent, size: 6579) | |
18:02 | [97b8a99033] part of check-in [135bf72c6b] Merge latest trunk changes into this branch. (check-in: [135bf72c6b] user: dan branch: wal2, size: 6287) | |
15:29 | [ba252daaa9] part of check-in [0462a2612d] ifdef adjustments so that SQLITE_OMIT_WAL works with SQLITE_USE_SEH. (check-in: [0462a2612d] user: drh branch: trunk, size: 6127) | |
2023-08-11
| ||
19:38 | [bd964b8871] part of check-in [cb3cf9bab0] Merge latest trunk changes, including support for handling of structured-exceptions in MSVC builds, with this branch. (check-in: [cb3cf9bab0] user: dan branch: begin-concurrent, size: 6556) | |
19:36 | [dcb0533cae] part of check-in [331f2f3e5d] Merge latest wal2 changes, including support for handling of structured-exceptions in MSVC builds, with this branch. (check-in: [331f2f3e5d] user: dan branch: bedrock, size: 6805) | |
2023-08-10
| ||
18:58 | [a3e64f463a] part of check-in [fd58c61624] Experimental merge of the wal-shm-exceptions and wal2 branches. (check-in: [fd58c61624] user: dan branch: wal2-shm-exceptions, size: 6264) | |
2023-06-19
| ||
18:16 | [dd2cd9880f] part of check-in [4b08d4dad6] Add the sqlite3_commit_status() API. For querying a connection for (a) the ranges of wal/wal2 frames written after a successful commit, and (b) the conflicting frame following a failed commit of a BEGIN CONCURRENT transaction. (check-in: [4b08d4dad6] user: dan branch: bedrock, size: 6742) | |
2022-12-19
| ||
18:42 | [11692a4e45] part of check-in [44dd01e315] Hack for special gettimeofday() instrumentation of "PRAGMA schema_version". (check-in: [44dd01e315] user: dan branch: schema-version-instr, size: 6795) | |
2021-09-10
| ||
21:28 | [04a9e53121] part of check-in [fdb20e9ee4] If an EXCEPTION_IN_PAGE_ERROR exception is caught, make the underlying OS error code available via sqlite3_system_errno(). (check-in: [fdb20e9ee4] user: dan branch: wal-shm-exceptions, size: 6104) | |
2020-05-18
| ||
19:55 | [7a733af13b] part of check-in [5dc355ccf6] Merge latest trunk changes into this branch. (check-in: [5dc355ccf6] user: dan branch: begin-concurrent-pnu-wal2, size: 6743) | |
17:18 | [d01234e828] part of check-in [16b1eca922] Merge latest trunk changes into this branch. (check-in: [16b1eca922] user: dan branch: wal2, size: 6201) | |
15:41 | [7ffe787437] part of check-in [9e4a7b3ed8] Merge latest trunk changes into this branch. (check-in: [9e4a7b3ed8] user: dan branch: begin-concurrent, size: 6493) | |
2020-05-06
| ||
19:14 | [c3aa7825bf] part of check-in [105d6c9bbc] Block on the WRITER lock when attempting to run recovery. (check-in: [105d6c9bbc] user: dan branch: setlk-deadlock-changes, size: 6041) | |
2020-05-05
| ||
20:30 | [484890eaae] part of check-in [d6f819a9e6] Unless upgrading an existing read transaction, have ENABLE_SETLK_TIMEOUT builds attempt to use a blocking lock when opening a write transaction on a wal mode database. (check-in: [d6f819a9e6] user: dan branch: setlk-deadlock-changes, size: 6021) | |
2020-05-04
| ||
19:42 | [642f789652] part of check-in [553423c231] Changes to avoid deadlock in SQLITE_ENABLE_SETLK_TIMEOUT builds. (check-in: [553423c231] user: dan branch: setlk-deadlock-changes, size: 5918) | |
2019-01-02
| ||
19:46 | [c1a0f32c17] part of check-in [86685679b4] Merge changes from begin-concurrent-wal2. Also modify the unix-excl shm-locks on this branch so that it is not an error to attempt to release an EXCLUSIVE lock that is not held. (check-in: [86685679b4] user: dan branch: begin-concurrent-pnu-wal2, size: 6610) | |
2018-12-29
| ||
20:47 | [86a71244ad] part of check-in [1625887c02] Merge latest begin-concurrent changes with this branch. (check-in: [1625887c02] user: dan branch: begin-concurrent-wal2, size: 6520) | |
20:42 | [ac2100eeda] part of check-in [48ca30f9d7] Fix a problem causing a corrupt pager-cache if an OOM or IO error was encountered while committing a concurrent transacation. (check-in: [48ca30f9d7] user: dan branch: begin-concurrent, size: 6360) | |
2018-12-18
| ||
18:01 | [4ef31f6def] part of check-in [a2c618c0a4] Merge the wal2 feature into this branch. (check-in: [a2c618c0a4] user: dan branch: begin-concurrent-pnu-wal2, size: 6605) | |
2018-12-05
| ||
17:20 | [c398e0269e] part of check-in [bf309107df] Fix a problem causing "PRAGMA journal_mode" to report the wrong journal mode (wal instead of wal2) under some circumstances. (check-in: [bf309107df] user: dan branch: begin-concurrent-wal2, size: 6515) | |
17:14 | [d2a69695c8] part of check-in [1d8d4f6896] Fix a problem causing "PRAGMA journal_mode" to report the wrong journal mode (wal instead of wal2) under some circumstances. (check-in: [1d8d4f6896] user: dan branch: wal2, size: 6068) | |
2018-12-03
| ||
20:49 | [b42fc8081c] part of check-in [b7281a1caa] Merge the wal2 and begin-concurrent code. Both features work, but not at the same time. (check-in: [b7281a1caa] user: dan branch: begin-concurrent-wal2, size: 6356) | |
2018-12-01
| ||
20:14 | [fc6113057f] part of check-in [7a44fa5a35] Sync this branch with the latest trunk. (check-in: [7a44fa5a35] user: dan branch: wal2, size: 5909) | |
2018-10-09
| ||
22:50 | [bc4bdd9ee9] part of check-in [ddf6a54ef3] Merge changes for the 3.25.0 release. (check-in: [ddf6a54ef3] user: drh branch: apple-osx, size: 6013) | |
2018-09-28
| ||
20:58 | [f325a5856b] part of check-in [86750c927c] Merge latest trunk into this branch. (check-in: [86750c927c] user: dan branch: begin-concurrent, size: 6355) | |
2018-08-06
| ||
17:12 | [606292549f] part of check-in [051ac01520] Allow sqlite3_snapshot_open() to be called to change the snapshot after a read transaction is already open on database. (check-in: [051ac01520] user: dan branch: exp-snapshot-open, size: 5908) | |
2017-10-04
| ||
20:57 | [b6063e6be1] part of check-in [e2fc5c814c] Add experimental mode that uses two wal files. Activated using "PRAGMA journal_mode = wal2". (check-in: [e2fc5c814c] user: dan branch: wal2, size: 5798) | |
2017-09-09
| ||
06:10 | [bada900780] part of check-in [6a0b9d9d4e] Merge trunk enhancements (check-in: [6a0b9d9d4e] user: drh branch: apple-osx, size: 5902) | |
2017-08-28
| ||
17:19 | [1713fefe45] part of check-in [d53108e763] Merge recent enhancements from trunk. (check-in: [d53108e763] user: drh branch: begin-concurrent, size: 6244) | |
2017-08-25
| ||
01:14 | [8de5d2d3de] part of check-in [bf65dae8d4] Update the mechanism used to keep track of what kind of syncing to do for WAL transaction commits and checkpoint operations. Use the checkpoint-style of syncing to sync the header of a new or restarted WAL file. (check-in: [bf65dae8d4] user: drh branch: wal-sync-refactor, size: 5797) | |
2017-05-29
| ||
19:23 | [1ea51dc499] part of check-in [9ad846e57b] Instead of a root page number, log the object (table or index) name if a page level locking conflict is detected. (check-in: [9ad846e57b] user: dan branch: begin-concurrent, size: 6265) | |
2017-05-23
| ||
19:23 | [79378c5cd2] part of check-in [5b9d498f6e] Add experimental new API sqlite3_wal_info(). (check-in: [5b9d498f6e] user: dan branch: begin-concurrent, size: 6258) | |
2017-05-08
| ||
20:15 | [739d92494e] part of check-in [b733afc1d0] Add some support for wal mode to the hack on this branch. (check-in: [b733afc1d0] user: dan branch: server-edition, size: 5905) | |
2017-01-09
| ||
06:33 | [8659519a24] part of check-in [d0e212d08f] Upgrade this branch to 3.16 plus the various fixes that appeared after its release. (check-in: [d0e212d08f] user: dan branch: begin-concurrent, size: 6168) | |
2016-11-26
| ||
20:44 | [1598818fe9] part of check-in [41a3af5443] Merge all recent trunk changes, and especially the new sqlite3_snapshot_recover() interface. (check-in: [41a3af5443] user: drh branch: apple-osx, size: 5923) | |
2016-11-18
| ||
20:49 | [06b2a0b599] part of check-in [174a6076a8] Add experimental sqlite3_snapshot_recover() API. (check-in: [174a6076a8] user: dan branch: serializable-snapshot, size: 5818) | |
2016-11-04
| ||
19:09 | [8fed212c25] part of check-in [0e5ffd9123] Merge recent trunk changes, including all the fixes that appeared in version 3.15.1. (check-in: [0e5ffd9123] user: drh branch: apple-osx, size: 5881) | |
2016-08-12
| ||
16:21 | [bf03a23da3] part of check-in [8a5f41c7b1] Have wal file checkpoints exit early if the sqlite3_interrupt() API function is called. (check-in: [8a5f41c7b1] user: dan branch: interruptible-checkpoint, size: 5776) | |
2016-08-11
| ||
19:12 | [520cb6942a] part of check-in [d9f8918c5b] Merge version 3.14 plus some subsequent patches (including the page-cache performance patch) from trunk. (check-in: [d9f8918c5b] user: drh branch: begin-concurrent, size: 6039) | |
2016-07-25
| ||
17:31 | [f38853cd77] part of check-in [e98cefb17d] Merge 3.14 alpha changes from trunk. (check-in: [e98cefb17d] user: drh branch: apple-osx, size: 5794) | |
2016-07-09
| ||
16:14 | [6dd221ed38] part of check-in [5471aca015] Fix various internal #defines to conform to new C-language naming restrictions, specifically that private-use macros names must not begin with "_". (check-in: [5471aca015] user: drh branch: trunk, size: 5689) | |
2016-01-14
| ||
15:46 | [327e94c3e3] part of check-in [fccc5f20c3] Merge the latest enhancements and fixes from trunk. (check-in: [fccc5f20c3] user: dan branch: begin-concurrent, size: 6024) | |
15:03 | [29c2a284dd] part of check-in [d85774e0dc] Merge the latest enhancements and fixes from trunk. (check-in: [d85774e0dc] user: drh branch: apple-osx, size: 5779) | |
2016-01-08
| ||
02:27 | [2f7c831cf3] part of check-in [a02ace9a74] Add the experimental SQLITE_FCNTL_JOURNAL_POINTER file control for obtaining the sqlite3_file pointer associated with a rollback journal or WAL file. (check-in: [a02ace9a74] user: drh branch: file-control-journal, size: 5674) | |
2015-12-16
| ||
19:55 | [e3ae126b25] part of check-in [cb22efaf50] Merge recent enhancements from trunk. (check-in: [cb22efaf50] user: drh branch: begin-concurrent, size: 5877) | |
2015-12-11
| ||
12:53 | [074df251e1] part of check-in [7e7b240645] Merge recent trunk enhancements, and in particular the snapshot interface. (check-in: [7e7b240645] user: drh branch: apple-osx, size: 5632) | |
2015-12-05
| ||
20:51 | [907943dfde] part of check-in [0715eb00aa] Add untested implementations of experimental APIs sqlite3_snapshot_get(), _open() and _free(). (check-in: [0715eb00aa] user: dan branch: snapshot-get, size: 5527) | |
2015-09-03
| ||
15:17 | [361b16891d] part of check-in [f8ae9bfd05] Changes from ENABLE_CONCURRENT (default off) to OMIT_CONCURRENT (default on). This is not a clear-cut decision and might be changed back. (check-in: [f8ae9bfd05] user: drh branch: begin-concurrent, size: 5701) | |
2015-09-01
| ||
17:48 | [ec78c30388] part of check-in [5ed2a445a1] Fixes so that it builds without warnings both with and without SQLITE_ENABLE_CONCURRENT. (check-in: [5ed2a445a1] user: drh branch: begin-concurrent, size: 5673) | |
2015-08-24
| ||
06:43 | [903ef67e17] part of check-in [4460764ea8] Fix another problem involving unlocked transactions and wal-file restarts. (check-in: [4460764ea8] user: dan branch: begin-concurrent, size: 5461) | |
2015-08-21
| ||
20:11 | [a701096b9b] part of check-in [53aaeea6c9] Fix many minor issues in the unlocked transaction code. (check-in: [53aaeea6c9] user: dan branch: begin-concurrent, size: 5462) | |
2015-08-19
| ||
20:27 | [5aaed8ca6c] part of check-in [3bbc31d515] When committing an unlocked transaction, relocate newly allocated database pages within the file to avoid conflicting with committed transactions. There are lots of things still to fix in this code. (check-in: [3bbc31d515] user: dan branch: begin-concurrent, size: 5573) | |
2015-07-29
| ||
12:14 | [cd7ea52439] part of check-in [0b9718426e] Only allow UNLOCKED transactions to commit if none of the pages read by the transaction have been modified since it was opened. (check-in: [0b9718426e] user: dan branch: begin-concurrent, size: 5518) | |
2015-07-27
| ||
19:31 | [5188cd8539] part of check-in [8079421604] Add an experimental "BEGIN UNLOCKED" command. (check-in: [8079421604] user: dan branch: begin-concurrent, size: 5574) | |
2014-10-20
| ||
16:24 | [0d3ba0c3f1] part of check-in [0bf1301aac] Have the ota extension perform an incremental checkpoint after generating the wal file. (check-in: [0bf1301aac] user: dan branch: ota-update, size: 5861) | |
2014-09-16
| ||
20:02 | [e25f9d383f] part of check-in [decaccc37c] Clarify the effects of the pager_ota_mode pragma. Add tests and fixes for the same. (check-in: [decaccc37c] user: dan branch: ota-update, size: 5403) | |
2014-09-02
| ||
19:59 | [237bc4484f] part of check-in [2954ab5010] Add an experimental extension for applying bulk updates to databases. (check-in: [2954ab5010] user: dan branch: ota-update, size: 5489) | |
2014-05-08
| ||
23:01 | [6b3a67ecd7] part of check-in [9411d7dc6f] Initial attempt to merge in all trunk changes over the previous 1.5 years. This check-in compiles but there are compiler warnings and "make test" segfaults after only running a few test modules. (check-in: [9411d7dc6f] user: drh branch: apple-osx, size: 5456) | |
2013-05-02
| ||
17:37 | [df01efe09c] part of check-in [b81e87e72b] Minor fixes for compilation with SQLITE_OMIT_WAL defined. (check-in: [b81e87e72b] user: dan branch: trunk, size: 5351) | |
2013-03-23
| ||
21:00 | [a4d3da523d] part of check-in [1431be9557] Replace the sqlite3_io_methods.xMremap interface with sqlite3_io_methods.xFetch and xUnfetch. (check-in: [1431be9557] user: dan branch: experimental-mmap, size: 5300) | |
2013-03-22
| ||
18:20 | [d99ce512ac] part of check-in [d190ddabc3] Allow the database file to be memory mapped in wal mode. (check-in: [d190ddabc3] user: dan branch: experimental-mmap, size: 5312) | |
2012-05-09
| ||
22:36 | [ce626f1f90] part of check-in [6547929410] Added support for SQLITE_ENABLE_PERSIST_WAL compile time macro, retrieving lastErrno from WAL file and setting last errno when writes fail due to space constraints (check-in: [6547929410] user: adam branch: apple-osx, size: 5438) | |
2012-03-05
| ||
16:39 | [a8ade3069a] part of check-in [504bf49086] Pull in all the latest trunk changes. (check-in: [504bf49086] user: drh branch: apple-osx, size: 5338) | |
2012-02-24
| ||
14:33 | [29c197540b] part of check-in [3130275c64] Add #ifdef SQLITE_ENABLE_ZIPVFS around those bits of code that are only used by ZIPVFS. (check-in: [3130275c64] user: drh branch: trunk, size: 5333) | |
2012-02-23
| ||
15:35 | [9a300673e8] part of check-in [786e24dc56] Add the sqlite3PagerWalFramesize() function to pager.c. This is used by zipvfs. (check-in: [786e24dc56] user: dan branch: trunk, size: 5298) | |
2012-01-03
| ||
21:54 | [313ef1ffc4] part of check-in [8a048423f0] Pull all the latest trunk changes over into the apple-osx branch. (check-in: [8a048423f0] user: drh branch: apple-osx, size: 5067) | |
2011-12-30
| ||
10:54 | [eaa00b9a40] part of check-in [26a513a8d2] Minor changes to fix compilation with SQLITE_OMIT_WAL and SQLITE_OMIT_WSD defined. (check-in: [26a513a8d2] user: dan branch: trunk, size: 5062) | |
2011-12-16
| ||
21:26 | [42f8313f7a] part of check-in [9799241f7d] Enhance the WAL header sync so that it honors the various synchronous pragmas, settings, and device characteristics. (check-in: [9799241f7d] user: drh branch: wal-header-sync, size: 5062) | |
2011-06-24
| ||
20:47 | [e75d87752b] part of check-in [34f0efa2b1] Merging local changes to apple-osx (check-in: [34f0efa2b1] user: adam branch: apple-osx, size: 4813) | |
2011-05-19
| ||
02:34 | [0835021ae2] part of check-in [5791232778] Bring the apple-wal-readonly branch up to date with the latest changes in apple-osx, and especially the fix for disappearing WAL transactions. (check-in: [5791232778] user: drh branch: apple-wal-readonly, size: 4813) | |
2011-05-16
| ||
21:00 | [66b40bd91b] part of check-in [db7e500f69] Enhance WAL mode so that the WAL file honors the journal size limit set by PRAGMA journal_size_limit. (check-in: [db7e500f69] user: drh branch: trunk, size: 4808) | |
2011-05-11
| ||
14:57 | [c1e05cdf3d] part of check-in [671ba5fc59] Only open a read-only connection to shared-memory if the "readonly_shm=1" option is specified as part of the database file URI (and if a read-write connection fails). (check-in: [671ba5fc59] user: dan branch: wal-readonly, size: 4706) | |
2010-11-18
| ||
12:11 | [7a5fbb0011] part of check-in [72787c010c] Modify the interface to the blocking wal-checkpoint functionality. (check-in: [72787c010c] user: dan branch: blocking-checkpoint, size: 4701) | |
2010-11-16
| ||
18:56 | [d5bbc11242] part of check-in [7e3fc2c833] Add experimental command "PRAGMA wal_blocking_checkpoint", which uses the busy-handler to block until all readers have finished in order to ensure the next writer will be able to wrap around to the start of the log file. (check-in: [7e3fc2c833] user: dan branch: blocking-checkpoint, size: 4451) | |
2010-11-01
| ||
17:38 | [c1aac6593a] part of check-in [8dd5c69198] If a database file with the WAL flag set is opened in exclusive-locking mode, use heap memory to store the wal-index instead of shared-memory. (check-in: [8dd5c69198] user: dan branch: trunk, size: 4310) | |
2010-08-03
| ||
06:42 | [96669b645e] part of check-in [0a636798bd] Incremental checkin on pager state refactoring. (check-in: [0a636798bd] user: dan branch: experimental, size: 4015) | |
2010-06-28
| ||
11:23 | [906c857605] part of check-in [3b68cb9c65] Fix some errors when compiling with SQLITE_OMIT_WAL. (check-in: [3b68cb9c65] user: dan branch: trunk, size: 4034) | |
2010-06-02
| ||
18:59 | [4ace252624] part of check-in [6b4aed6aae] Fix a problem with rolling back to a savepoint opened before the writer decided to wrap the log file. (check-in: [6b4aed6aae] user: dan branch: trunk, size: 3985) | |
2010-05-30
| ||
19:55 | [1c1c9feb62] part of check-in [ef3ba7a17f] Initial code for incremental checkpoint in WAL mode. This check-in compiles on unix and runs as long as you do not engage WAL mode. WAL mode crashes and burns. Consider this check-in a baseline implementation for getting the new capability up and running. (check-in: [ef3ba7a17f] user: drh branch: wal-incr-ckpt, size: 3985) | |
2010-05-24
| ||
13:57 | [111c6f3efd] part of check-in [8a53f12c83] Change the checksum used in WAL files so that each frames checksum depends on the content of the WAL header and all frame headers and content up to and including the frame to which the checksum is attached. (check-in: [8a53f12c83] user: dan branch: trunk, size: 3975) | |
2010-05-12
| ||
18:01 | [434f76f512] part of check-in [2b00152c1a] Refactoring the VFS-SHM methods used by WAL. This version compiles and runs non-WAL test cases but crashes and burns on wal.test. (check-in: [2b00152c1a] user: drh branch: wal-refactor, size: 3936) | |
2010-05-11
| ||
12:19 | [32f36b2a82] part of check-in [71e7b1cf9f] Changes so that WAL and exclusive-locking mode work together. (check-in: [71e7b1cf9f] user: dan branch: trunk, size: 4016) | |
2010-05-04
| ||
14:47 | [b4c42014b5] part of check-in [1a391f3c55] Fix problems with recovering wal files that use a page-size other than the default. (check-in: [1a391f3c55] user: dan branch: trunk, size: 3843) | |
2010-05-01
| ||
16:40 | [d6d4a68091] part of check-in [9b230c43df] Support compile-time option SQLITE_OMIT_WAL, for building without WAL support. (check-in: [9b230c43df] user: dan branch: wal, size: 3772) | |
2010-04-30
| ||
09:52 | [c3f347ba8f] part of check-in [a8f958be80] Fix a couple of assert() statements in os_unix.c and wal.c. Combine sqlite3WalIsDirty() with sqlite3WalUndo(). (check-in: [a8f958be80] user: dan branch: wal, size: 3143) | |
2010-04-29
| ||
22:34 | [d0a7048e68] part of check-in [62db5fa3b6] Refactor wal.c to use the VFS. This check-in compiles and links and works ok as long as you leave WAL turned off, but WAL does not work. (check-in: [62db5fa3b6] user: drh branch: wal, size: 3254) | |
2010-04-28
| ||
14:42 | [c60781e78e] part of check-in [bbc385111b] Rename the sqlite3_log_hook() to sqlite3_wal_hook(). Added comments to wal.h. (check-in: [bbc385111b] user: drh branch: wal, size: 3242) | |
2010-04-26
| ||
16:57 | [812101dd76] part of check-in [6a944f028d] Fixes for problems with small caches and SAVEPOINT rollback in WAL mode. (check-in: [6a944f028d] user: dan branch: wal, size: 2415) | |
00:19 | Renamed and modified src/log.h → src/wal.h. [1a34bb7164] part of check-in [56fe5d7624] Change the names of the log.c and log.h source files to wal.c and wal.h. (check-in: [56fe5d7624] user: drh branch: wal, size: 2326) | |