/ File History
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

History of test/wal.test

2019-01-17
15:47
Sync up with the latest enhancements on trunk. file: [0d42851f] check-in: [475a179a] user: drh branch: apple-osx, size: 44096
2018-12-27
16:49
Increase test coverage of wal.c provided by permutation "coverage-wal" on this branch. file: [a233cd47] check-in: [2f7f893a] user: dan branch: wal2, size: 43116
2018-12-06
18:58
Experiment with using an atomic CPU primitive instead of a mutex for intra-process locking with the unix-excl VFS. file: [cdf0ca6c] check-in: [8f4cb9dd] user: dan branch: mutexfree-shmlock, size: 43125
2016-03-15
12:45
Merge updates from trunk - FTS5 fixes and enhancemenets to the tests scripts so that they work with SEE. file: [83635d42] check-in: [f41a7361] user: drh branch: apple-osx, size: 43970
2016-03-14
18:34
Many more test cases fixed. Only a few remain. file: [613efec0] check-in: [99b9d7ee] user: drh branch: see-testing, size: 42999
2016-02-05
14:29
Merge OOM handling optimizations and PRAGMA synchronous=EXTRA as well as other enhancements from trunk. file: [21c1bc3c] check-in: [201fcbee] user: drh branch: apple-osx, size: 43919
2016-02-04
17:31
Avoid running some particularly time-consuming tests as part of veryquick.test. file: [0148c8b3] check-in: [f465944b] user: dan branch: trunk, size: 42948
2016-01-11
12:49
Merge enhancements from trunk, and in particular the WAL overwrite feature. file: [40cc49c5] check-in: [79125ec9] user: drh branch: apple-osx, size: 46651
2016-01-09
23:55
All WAL frame overwrites even if there are active savepoints. This is safe because a ROLLBACK TO will cause all reverted pages to be rewritten to the WAL file prior to COMMIT. file: [65bfc68f] check-in: [99b31a6b] user: drh branch: wal-overwrite-frames, size: 45609
16:39
If a single page is written to the wal file more than once, have each subsequent copy overwrite the original frame. file: [351bd83d] check-in: [5d113aef] user: dan branch: wal-overwrite-frames, size: 45415
2015-08-28
02:12
Merge trunk enhancements into the apple-osx branch. Most tests works, but there are yet a few issues to be resolved. file: [cfbc6bbd] check-in: [da864658] user: drh branch: apple-osx, size: 46457
2015-07-25
03:10
Disable the page cache bulk allocation for the shrink.test and wal.test modules. file: [dbfc482e] check-in: [3418f1f1] user: drh branch: trunk, size: 45415
2015-03-20
20:30
Where possible insert the set of new keys for each index in sorted order within "INSERT INTO ... SELECT" statements. file: [d4b6ab9c] check-in: [0a7f2051] user: dan branch: insert-select-opt, size: 45395
2014-10-20
16:24
Have the ota extension perform an incremental checkpoint after generating the wal file. file: [d7bb2fee] check-in: [0bf1301a] user: dan branch: ota-update, size: 45366
2014-05-08
23:01
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. file: [0ae50480] check-in: [9411d7dc] user: drh branch: apple-osx, size: 46397
2014-04-04
14:12
Ensure the "PRAGMA journal_mode=WAL" works coming from any other journal_mode with ATTACH-ed databases. file: [885f32b2] check-in: [e54330b4] user: drh branch: trunk, size: 45355
2013-12-19
16:26
Make sure errors encountered while initializing extensions such as FTS4 get reported out from sqlite3_open(). This fixes a bug introduced by check-in [9d347f547e7ba9]. Also remove lots of forgotten "breakpoint" commands left in test scripts over the years. file: [40073e54] check-in: [ca3fdfd4] user: drh branch: trunk, size: 45002
2013-11-05
13:33
Standardize the error messages generated by constraint failures to a format of "$TYPE constraint failed: $DETAIL". This involves many changes to the expected output of test cases. file: [a59d00ea] check-in: [54b22192] user: drh branch: omit-rowid, size: 45013
2013-05-15
18:34
Fixes to allow testfixture to be compiled with SQLITE_OMIT_VIRTUAL_TABLE defined. file: [3a6ebdf0] check-in: [00231fb0] user: dan branch: trunk, size: 45005
2013-04-29
08:58
Adjust a WAL test result due to changes in the corresponding return code name. file: [e6dcf26e] check-in: [9272009f] user: mistachkin branch: winOsTrace, size: 45041
2013-04-15
17:03
Refactoring the mmap interface. The controlling pragma is now "mmap_size" instead of "mmap_limit". Also change SQLITE_CONFIG_MMAP_LIMIT and SQLITE_FCNTL_MMAP_LIMIT to SQLITE_CONFIG_MMAP_SIZE and SQLITE_FCNTL_MMAP_SIZE, respecctively. The default mmap_size is now always 0, meaning that memory mapped I/O is off by default. There is a new compile-time option SQLITE_MAX_MMAP_SIZE that determines a hard upper bound on the mmap_size. Setting SQLITE_MAX_MMAP_SIZE to zero disables the memory-mapped I/O logic and causes it to be omitted from the build. An extra argument is added to SQLITE_CONFIG_MMAP_SIZE that can optionally lower the SQLITE_MAX_MMAP_SIZE at start-time. The SQLITE_MAX_MMAP_SIZE is zero for platforms where we know that it does not work, meaning that it cannot be turned on by mistake on those platforms. file: [0b4837cd] check-in: [ea1404a1] user: drh branch: trunk, size: 45023
2013-04-10
23:48
Add new primary error codes SQLITE_NOTICE and SQLITE_WARNING for use with sqlite3_log(). Add new extended error codes SQLITE_NOTICE_RECOVER_WAL and SQLITE_NOTICE_RECOVER_ROLLBACK to use with sqlite3_log() messages that occur on each recovery. file: [20fb8d0f] check-in: [be7d2c54] user: drh branch: trunk, size: 45025
2013-04-08
20:47
Disable the use of memory-mapped I/O if the SQLITE_DISABLE_MMAP macro is defined. Automatically define this macro for OpenBSD and QNX. Other systems are likely to be added to the disabled list over time. file: [b934b757] check-in: [8a4314a3] user: drh branch: trunk, size: 45021
2013-04-02
18:31
Change an assert in pager.c to acknowledge that it is possible for sqlite3PagerRollback() to return SQLITE_CORRUPT. file: [62454b2c] check-in: [d641d3d2] user: dan branch: experimental-mmap, size: 45298
2013-03-27
19:53
Modify various test cases so that they work if the file is extended in units of the system page-size. file: [0fe084a9] check-in: [0e3d5119] user: dan branch: two-mappings, size: 45087
2013-03-26
01:07
Previous check-in accidently left mmap turned off by default. This checkin fixes that. Unfortunately, shared.test is now segfaulting. All other veryquick tests appear to work, however. file: [bbd98ac0] check-in: [a850c731] user: drh branch: experimental-mmap, size: 44991
2013-03-22
20:15
Update wal mode tests so that they work with the mmap test permutation. file: [5baa9a0e] check-in: [f7295872] user: dan branch: experimental-mmap, size: 44989
2012-06-08
01:13
Merge trunk changes into the apple-osx branch. file: [5759631b] check-in: [9d1b8515] user: drh branch: apple-osx, size: 45969
2012-05-17
21:04
Merge updates from trunk. file: [a040047d] check-in: [224c65e4] user: mistachkin branch: winrt, size: 44927
2012-05-12
14:59
Merge trunk changes with apple-osx branch. file: [b03ffe24] check-in: [bf57f0fb] user: dan branch: apple-osx, size: 45911
2012-05-11
20:43
Fix a bug in the wal.test script so that it works on big-endian systems. file: [b3d28d65] check-in: [40fe9088] user: drh branch: trunk, size: 44869
2012-05-09
22:36
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 file: [3b7e0c1a] check-in: [65479294] user: adam branch: apple-osx, size: 45830
2012-03-19
16:21
Merge latest trunk changes into apple-osx branch. file: [9c29891c] check-in: [f999197b] user: dan branch: apple-osx, size: 44977
2012-03-08
20:22
Merge and manually resolve testing updates from trunk. file: [99394a4c] check-in: [5eecdb44] user: mistachkin branch: winrt, size: 44846
20:00
On Windows, make sure the current directory value used by the test suite is 'normalized' to what the parent command shell sees. Also, clean the test directories used by the quota2.test file. file: [2fbf4bbd] check-in: [82bcd7ec] user: mistachkin branch: trunk, size: 44788
2012-03-05
22:52
Add compile-time define to indicate if the VFS supports the concept of a current directory (as WinCE and WinRT do not). Avoid using the GetTempPath and GetFullPathName APIs on WinRT. Some tests still need adjustments. file: [396be040] check-in: [86c049a1] user: mistachkin branch: winrt, size: 44842
2012-01-03
21:54
Pull all the latest trunk changes over into the apple-osx branch. file: [ed0d04a5] check-in: [8a048423] user: drh branch: apple-osx, size: 44973
2011-12-19
10:07
Modify test cases to account for the ZERO_DAMAGE change. file: [edefe316] check-in: [68684495] user: dan branch: statvfs, size: 44784
00:31
Some fixes to the test suite so that it works with ZERO_DAMAGE set to true. Still lots more problems remain. file: [626ada15] check-in: [41891b23] user: drh branch: statvfs, size: 44537
2011-12-08
21:08
Merge the latest trunk changes into the apple-osx branch. file: [0f543839] check-in: [59e0d4f3] user: drh branch: apple-osx, size: 45122
2011-11-12
16:46
Remove a couple of incorrect assert statements so that the test suite will run with -DSQLITE_DEFAULT_CACHE_SIZE=0. file: [c743be78] check-in: [87614b62] user: drh branch: trunk, size: 44553
2011-08-23
18:06
Merge latest trunk changes into the apple-osx branch. file: [fa19bdb3] check-in: [c5f7977b] user: dan branch: apple-osx, size: 45061
2011-08-02
00:57
Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried. file: [e11da8d5] check-in: [9007586f] user: mistachkin branch: winopen-retry-logic, size: 44492
2011-06-25
16:35
Fix test cases so that they work with SQLITE_DEFAULT_WAL_SAFETYLEVEL defined. file: [c2df96d6] check-in: [8f8b373e] user: dan branch: apple-osx, size: 45264
2011-04-09
18:13
Pull all the latest trunk changes into the apple-osx branch. file: [3ff61047] check-in: [4eaef4ad] user: drh branch: apple-osx, size: 44744
2011-04-07
05:17
Fix test script attach4.test so that it works with type 1 VFS implementations (no wal). And wal.test so that it work with a small default pager cache size. file: [5617ad30] check-in: [29c7b425] user: dan branch: trunk, size: 44695
2011-04-06
19:15
Fix a benign inaccuracy in the os_unix.c SQLITE_FCNTL_SIZE_HINT code. file: [bac92a13] check-in: [61a6ccbe] user: dan branch: trunk, size: 44664
2011-04-05
22:10
Merge the latest trunk changes into the apple-osx branch. file: [d5754f56] check-in: [c77a767c] user: drh branch: apple-osx, size: 44730
16:09
When committing a WAL transaction, do not write any pages to the WAL file with page numbers greater than the size of the database image in pages. file: [084b0869] check-in: [311d0b61] user: dan branch: trunk, size: 44681
2011-04-04
13:11
Merge in the latest changes from trunk. file: [f30615b9] check-in: [6d78a25d] user: drh branch: apple-osx, size: 43413
2011-04-01
19:14
Changes to wal tests so that they work with DEFAULT_AUTOVACUUM defined. file: [973a4747] check-in: [b477852f] user: dan branch: trunk, size: 43364
2010-11-18
19:28
Fixes for SQLITE_BUSY handling in blocking checkpoint code. file: [f060cae4] check-in: [4c663a4d] user: dan branch: blocking-checkpoint, size: 43334
16:14
Update test cases to account for the change in the previous commit. file: [dea22218] check-in: [ae089ec8] user: dan branch: blocking-checkpoint, size: 43323
2010-08-24
01:08
Merge changes through release 3.7.2 into the apple-osx branch. file: [d83c3d22] check-in: [415c448d] user: drh branch: apple-osx, size: 43276
2010-08-18
15:25
Disable the SQLITE_MAX_PAGE_SIZE compile time option (it is now always set to 65536). Fix some other problems in test files. file: [70227190] check-in: [56cc883d] user: dan branch: trunk, size: 43227
14:54
Fix issue with wal.test on Windows. file: [d3fa8ceb] check-in: [3497f54a] user: shaneh branch: trunk, size: 43191
00:24
Merge the 3.7.1 pre-release snapshot changes as of 2010-08-18 into the apple-osx branch. file: [06430c11] check-in: [866e9286] user: drh branch: apple-osx, size: 43222
00:09
Updating apple-osx with minor source fixes, database truncate and replace private calls and a bunch of conditionalization for tests running in different environments file: [93cbc7a8] check-in: [5e2ee7db] user: adam branch: apple-osx, size: 41434
2010-08-17
14:52
Invoke sqlite3_log() whenever one or more frames are recovered from a WAL file. file: [58479435] check-in: [e05089aa] user: dan branch: trunk, size: 43173
2010-08-16
19:23
Add tests for different page sizes to wal.test. Including 64K pages. file: [a63947f7] check-in: [d95bcc05] user: dan branch: trunk, size: 42225
2010-08-12
02:41
Increase the maximum page size from 32k to 64k. file: [0369e9ef] check-in: [45362437] user: drh branch: trunk, size: 41401
2010-06-23
15:55
Add a version number to the wal-index header. If SQLite encounters a version number in either the wal or wal-index files that it does not understand, the operation is abandoned and SQLITE_CANTOPEN returned. file: [1891e6f7] check-in: [8d0f8a7f] user: dan branch: trunk, size: 41385
2010-06-22
13:46
Some changes to test scripts related to codec enabled versions of sqlite. file: [621a61ae] check-in: [85dd51a7] user: dan branch: trunk, size: 41463
2010-06-15
19:07
Rationalize a common pattern in tcl test cases into proc do_multiclient_test. file: [55c3fae8] check-in: [efe44564] user: dan branch: trunk, size: 41298
2010-06-07
14:28
Refactor some of the global variables and commands used by tester.tcl. file: [0a599c3c] check-in: [c2edf8e1] user: dan branch: trunk, size: 42661
2010-06-02
18:59
Fix a problem with rolling back to a savepoint opened before the writer decided to wrap the log file. file: [bfec6145] check-in: [6b4aed6a] user: dan branch: trunk, size: 42662
2010-05-31
14:18
Update another test case in wal.test. file: [a54d9be9] check-in: [99fde69e] user: dan branch: wal-incr-ckpt, size: 41939
13:11
Change WAL test cases to account for the improved concurrency in the new checkpoint logic. file: [24fb9f0e] check-in: [2d6f2485] user: drh branch: wal-incr-ckpt, size: 41894
12:30
Do not fail a checkpoint just because active readers prevent backfill. file: [b965dc25] check-in: [9aa4243e] user: drh branch: wal-incr-ckpt, size: 42534
2010-05-24
13:57
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. file: [be8ef043] check-in: [8a53f12c] user: dan branch: trunk, size: 42837
10:39
Change the WAL file format to support two kinds of checksums - one that is fast to calculate on little-endian architectures and another that is fast on big-endian architectures. A flag in the wal-header indicates which the file uses. file: [3b8ad018] check-in: [65ba804d] user: dan branch: trunk, size: 42789
2010-05-20
21:21
Make use of the extra information in the WAL header and frame header to enhance robustness. file: [90afd254] check-in: [9580ecb7] user: drh branch: trunk, size: 42676
16:45
Convert the wal-header and frame-header to 24 bytes. Extra information in both headers is designed to enhance robustness after crashes, though the extra information is currently unused. This is a snapshot of a work in progress. file: [1ea87f3b] check-in: [66970643] user: drh branch: trunk, size: 42654
2010-05-19
19:09
Fix a bug in the new checkpoint computation. Also update the checkpoint algorithm in the test scripts to align with the new implementation. file: [4724adbf] check-in: [8b6056f2] user: drh branch: trunk, size: 42594
2010-05-11
02:46
Updates to WAL TCL test scripts to support running on Windows. file: [7a100918] check-in: [6a563080] user: shaneh branch: trunk, size: 42647
2010-05-07
13:52
Fix a recently introduced problem in wal.test. file: [de63d85e] check-in: [79b52d0f] user: dan branch: trunk, size: 42594
12:49
Change wal.test and walhook.test so that they work with DEFAULT_AUTOVACUUM=1 builds. file: [02d97e02] check-in: [4cde9290] user: dan branch: trunk, size: 42583
06:59
Fix a problem with checkpointing large log files created by an external process. file: [45fd4e9e] check-in: [8f94bde5] user: dan branch: trunk, size: 42292
2010-05-06
17:28
Fix a bug whereby an old snapshot could be checkpointed (and subsequent transactions discarded) if the last connection to disconnect from a WAL database happended to be holding an out-of-date wal-index header. file: [f0b78497] check-in: [d0c0034b] user: dan branch: trunk, size: 39943
13:36
Unset a tcl variable before reusing it in wal.test. file: [7dda3fc1] check-in: [e83efb23] user: dan branch: trunk, size: 38359
2010-05-04
15:20
Add a test case to verify that log files containing pages that are not a power-of-two bytes in size are handled correctly. file: [f0b33101] check-in: [c2bf693f] user: dan branch: trunk, size: 38327
14:47
Fix problems with recovering wal files that use a page-size other than the default. file: [2b3626a6] check-in: [1a391f3c] user: dan branch: trunk, size: 38311
10:36
Test that the correct number of padding frames are appended to the log file after committing a transaction in synchronous=FULL mode. file: [511c6309] check-in: [a60104aa] user: dan branch: trunk, size: 34141
2010-05-03
15:58
Have sqlite3_wal_checkpoint() handle a zero-length string in the same way as a NULL pointer. Fix "PRAGMA wal_checkpoint" so that it checkpoints all attached databases. file: [0223196f] check-in: [7fecd21f] user: dan branch: trunk, size: 31151
12:14
Have sqlite3_wal_checkpoint() populate the database handle error message and error code (as returned by sqlite3_errmsg() and sqlite3_errcode()). file: [0c7c059c] check-in: [ff234cf5] user: dan branch: wal, size: 28945
11:05
Add the "PRAGMA wal_autocheckpoint" command. Rename "PRAGMA checkpoint" to "PRAGMA wal_checkpoint". file: [9f142c65] check-in: [714e5947] user: dan branch: wal, size: 27179
2010-05-01
16:40
Support compile-time option SQLITE_OMIT_WAL, for building without WAL support. file: [4ff92f36] check-in: [9b230c43] user: dan branch: wal, size: 27095
2010-04-30
17:28
Remove some obsolete debugging parameters. file: [830fc2d7] check-in: [a012aed4] user: drh branch: wal, size: 27055
2010-04-29
14:58
Close all open database connections at the end of wal.test. file: [67f1b8ec] check-in: [3cc55a75] user: dan branch: wal, size: 27008
14:51
Fix a bug in the WAL checkpoint code causing SQLite to use an inconsistent cache in a subsequent transaction. file: [d6fa4631] check-in: [d1cadeed] user: dan branch: wal, size: 26970
2010-04-27
18:43
Add a test to check that a checkpointer releases its locks before returning, even if it has been prevented by a conflicting lock from checkpointing the database. file: [bc99b165] check-in: [be44349d] user: dan branch: wal, size: 25501
05:42
Fix a problem that occurs when one process causes the log-summary file to grow and then a second process attempts to read the database. file: [fbf7a911] check-in: [b51a5f8b] user: dan branch: wal, size: 24812
2010-04-26
16:57
Fixes for problems with small caches and SAVEPOINT rollback in WAL mode. file: [b5d5fe1b] check-in: [6a944f02] user: dan branch: wal, size: 23912
10:40
Add mutexes to fix a race condition in wal.c. This isn't a very good fix. file: [7d44c2ee] check-in: [3d159939] user: dan branch: wal, size: 22083
2010-04-24
18:44
Fix bugs in WAL mode rollback. file: [8dcfd1ce] check-in: [31215969] user: dan branch: wal, size: 22041
2010-04-22
19:14
Create a version of the log checksummer that works on big-endian platforms. Remove the 512KB size limit on the log-summary. file: [fcb5ec1f] check-in: [5d6d4423] user: dan branch: wal, size: 20287
2010-04-21
18:37
Tests for (and changes to) the code to switch between WAL and rollback modes. file: [fd0e5914] check-in: [9f4f933f] user: dan branch: wal, size: 19508
11:43
If, after obtaining a SHARED lock, there exists a *-wal file in the file-system, use WAL mode. This is necessary to recover from a crash that damages the first page of the database file. file: [9ee40257] check-in: [33cabf27] user: dan branch: wal, size: 19508
2010-04-20
18:53
Use the read and write version fields of the database header to mark a database as operating in wal-mode. file: [273c0006] check-in: [96bef18c] user: dan branch: wal, size: 19570
2010-04-17
15:42
In synchronous=normal mode, do not sync the log after every transaction. In synchronous=full mode, sync the log and add any extra frames required to avoid blast-radius related problems after each transaction. file: [a56ff378] check-in: [9bc9b684] user: dan branch: wal, size: 19257
12:31
Enhancements to wal-mode locking scheme. file: [5fa3cdf2] check-in: [8549c286] user: dan branch: wal, size: 19134
2010-04-16
13:59
Change the log file format to include a small (12 byte) header at the start of the file. file: [bb1fa35f] check-in: [9865d14d] user: dan branch: wal, size: 19057
11:30
Fix bug in log recovery (last frame in log was being ignored). Also remove an incorrect assert statement. file: [ff3c1014] check-in: [67d2a89e] user: dan branch: wal, size: 18751
2010-04-15
16:45
Allow writers to write dirty pages to the log mid-transaction in order to free memory. file: [b0b6c02b] check-in: [ecd828f9] user: dan branch: wal, size: 17349
2010-04-14
18:50
Add tests and fix bugs in WAL locking mechanism. file: [8f480128] check-in: [c18077f2] user: dan branch: wal, size: 14869
18:06
Add tests to check inter-process WAL locking. file: [812dde0a] check-in: [9435f313] user: dan branch: wal, size: 13016
11:23
Fixes for locking issues in WAL mode. file: [a4be3c7a] check-in: [a9617eff] user: dan branch: wal, size: 10024
2010-04-13
11:56
Remove old code to interpret an argument (no longer used) to "PRAGMA checkpoint". file: [d5916b3a] check-in: [27dc5977] user: dan branch: wal, size: 15550
11:45
Fix other problems in the WAL test scripts. file: [5dc92880] check-in: [dcb31181] user: dan branch: wal, size: 15562
11:35
Fix test script issues preventing walthread.test from running. file: [2c279aad] check-in: [d90b1dde] user: dan branch: wal, size: 15492
2010-04-12
19:00
Import experimental write-ahead-logging code. file: [653a870a] check-in: [409d61ba] user: dan branch: wal, size: 14969 Added