/ 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/wal2.test

2019-04-15
14:59
Merge the latest enhancements from trunk. file: [6af203a0] check-in: [7c328e88] user: drh branch: begin-concurrent, size: 36314
14:49
Bring in the latest enhancements from trunk. file: [cf6a3136] check-in: [378230ae] user: drh branch: apple-osx, size: 38409
2019-04-12
16:25
Test case changes so that they work with both Tcl8.6 and Tcl8.7. file: [537f59e5] check-in: [7b771405] user: drh branch: trunk, size: 37171
2018-03-02
17:40
Merge latest trunk changes into this branch. file: [a225bafa] check-in: [36801eff] user: dan branch: begin-concurrent, size: 36235
2018-01-15
21:59
Merge the enhancements associated with the first 3.22.0 beta. file: [a8f30a87] check-in: [c9d2ec51] user: drh branch: apple-osx, size: 38330
2018-01-13
13:21
Fix various problems in test scripts preventing "make test" from passing on F2FS file-systems with the "atomic-write" feature. Cherrypick of [56d93d07]. file: [028f0219] check-in: [6a296d4d] user: dan branch: branch-3.19, size: 36908
13:07
Fix various problems in test scripts preventing "make test" from passing on F2FS file-systems with the "atomic-write" feature. file: [155b9efa] check-in: [56d93d07] user: dan branch: f2fs-test-fixes, size: 37092
2017-11-14
20:36
Merge the patch that enables reading a read-only WAL-mode database, without any special query parameters, as long as the -shm and -wal files are on disk. file: [de1182f5] check-in: [8c2a769c] user: drh branch: apple-osx, size: 38180
2017-11-07
15:43
On unix, if the *-shm file cannot be opened for read/write access, open it read-only and proceed as if the readonly_shm=1 URI option were specified. file: [2d81ffe2] check-in: [ba718754] user: dan branch: readonly-wal-recovery, size: 36942
2017-11-02
18:57
Fix test cases in wal2.test broken by the locking change in the previous commit. file: [4c44bbe4] check-in: [f569c351] user: dan branch: readonly-wal-recovery, size: 36942
2017-09-09
06:10
Merge trunk enhancements file: [798688af] check-in: [6a0b9d9d] user: drh branch: apple-osx, size: 37996
2017-08-28
17:19
Merge recent enhancements from trunk. file: [3055879e] check-in: [d53108e7] user: drh branch: begin-concurrent, size: 35901
2017-08-25
01:14
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. file: [6ac39b94] check-in: [bf65dae8] user: drh branch: wal-sync-refactor, size: 36758
2017-07-07
22:39
Fix test cases in wal2.test due to the fact that Darwin checks to see if the SHM file is writable before attempting to open in read/write. file: [62450517] check-in: [6b618b18] user: drh branch: apple-osx, size: 37996
2016-03-21
15:54
Merge all recent changes from trunk. file: [7effe771] check-in: [8ee7d346] user: drh branch: begin-concurrent, size: 35901
2016-03-18
00:58
Merge recent enhancements from trunk. file: [72286d11] check-in: [ec052b4f] user: drh branch: apple-osx, size: 37742
2016-03-17
23:56
Fix some test cases so that they work under the Apple configuration. file: [56b0bc95] check-in: [399c6076] user: drh branch: trunk, size: 36758
2016-03-16
19:34
Merge the latest enhancements from trunk. file: [e3493f22] check-in: [a7978ab6] user: drh branch: begin-concurrent, size: 35820
2016-03-08
16:35
Merge changes from trunk, especially the SQLITE_DEFAULT_SYNCHRONOUS enhancements. file: [7373f207] check-in: [29741941] user: drh branch: apple-osx, size: 37661
15:14
If SQLITE_DEFAULT_WAL_SYNCHRONOUS is not the same value as SQLITE_DEFAULT_SYNCHRONOUS and the application has not run "PRAGMA synchronous", then set synchronous to the SQLITE_DEFAULT_WAL_SYNCHRONOUS setting when entering WAL mode for the first time. file: [25ae059e] check-in: [5791407b] user: drh branch: default-synchronous, size: 36677
2015-08-25
16:01
Test that if a corrupt wal-index header is encountered when attempting to commit a concurrent transaction, SQLITE_BUSY_SNAPSHOT is returned to the caller. file: [dc801f6d] check-in: [c746e0bd] user: dan branch: begin-concurrent, size: 35792
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: [703b87c2] check-in: [9411d7dc] user: drh branch: apple-osx, size: 37767
2014-05-01
10:19
Update a test case in wal2.test that explicitly corrupts a checksum in the wal file to account for the fact that the first byte of said checksum may initially be 0xFF. file: [1f841d20] check-in: [2b935bde] user: dan branch: trunk, size: 36649
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: [a8e3963a] check-in: [ca3fdfd4] user: drh branch: trunk, size: 36323
2012-08-31
14:10
Merge in latest trunk changes. file: [b7150084] check-in: [bc9b9cd0] user: dan branch: apple-osx, size: 37465
2012-08-25
10:01
Fix all known instances of 'repeated the' style typos in comments. No changes to code. file: [d4b470f1] check-in: [9b19b847] user: mistachkin branch: trunk, size: 36347
2012-07-17
17:46
Cherrypick [8c9ee1d78f] and [e416359633] from trunk: Ensure that there is always at least one aReadMark slot usable by an unprivileged reader while a checkpoint is running. Also, if one or more transactions are recovered from a log file, initialize one of the aReadMark slots to contain mxFrame as part of the recovery process. file: [583ce660] check-in: [65035912] user: drh branch: apple-osx, size: 37469
14:37
Ensure that there is always at least one aReadMark slot usable by an unprivileged reader while a checkpoint is running. Also, if one or more transactions are recovered from a log file, initialize one of the aReadMark slots to contain mxFrame as part of the recovery process. file: [7ca81472] check-in: [e4163596] user: dan branch: trunk, size: 36351
2012-05-12
14:59
Merge trunk changes with apple-osx branch. file: [0f616db5] check-in: [bf57f0fb] user: dan branch: apple-osx, size: 37400
2012-05-11
23:01
Fix the wal2.test script so that it works on big-endian machines. file: [d5021064] check-in: [c4ab72f7] user: drh branch: trunk, size: 36282
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: [3e151660] check-in: [65479294] user: adam branch: apple-osx, size: 37314
2012-04-02
23:35
Merge in latest changes, autologging options, read only file system wal support, test config conditionalization, WAL frame write prebuffering file: [ea811f7b] check-in: [d51c086e] user: adam branch: apple-osx, size: 37027
2012-02-13
20:16
On unix, ignore the umask when creating journal files. That way, journal files will have exactly the same permissions as the original database and any process that has permission to write to the database can also recover hot journals. file: [8871e7fd] check-in: [84b32460] user: drh branch: trunk, size: 36196
2011-12-19
10:07
Modify test cases to account for the ZERO_DAMAGE change. file: [f11883dd] check-in: [68684495] user: dan branch: statvfs, size: 36105
2011-12-16
21:26
Enhance the WAL header sync so that it honors the various synchronous pragmas, settings, and device characteristics. file: [29e2cbe8] check-in: [9799241f] user: drh branch: wal-header-sync, size: 35874
2011-08-23
18:06
Merge latest trunk changes into the apple-osx branch. file: [cc834aa5] check-in: [c5f7977b] user: dan branch: apple-osx, size: 36799
2011-08-12
16:30
Merge latest trunk changes into experimental branch. file: [ad641259] check-in: [7e515055] user: dan branch: experimental, size: 35567
11:59
Add tests to improve coverage of vdbesort.c. file: [ceba91f0] check-in: [87a15917] user: dan branch: experimental, size: 35651
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: [a2caa432] check-in: [9007586f] user: mistachkin branch: winopen-retry-logic, size: 35555
2011-06-25
16:35
Fix test cases so that they work with SQLITE_DEFAULT_WAL_SAFETYLEVEL defined. file: [aaeac9c0] check-in: [8f8b373e] user: dan branch: apple-osx, size: 36871
2011-06-24
20:47
Merging local changes to apple-osx file: [6c65a48c] check-in: [34f0efa2] user: adam branch: apple-osx, size: 35847
2011-05-05
15:52
Merge the latest trunk changes into the apple-osx branch. file: [24239bb8] check-in: [f9b149e5] user: drh branch: apple-osx, size: 35708
2011-04-15
20:18
Updates to test code in os_win to bring winSync inline with unixSync (test code only). Updated a few test scripts to account for dirsync counting issues on Windows. file: [aa0fb231] check-in: [8f99c5bf] user: shaneh branch: trunk, size: 35639
2011-04-04
13:11
Merge in the latest changes from trunk. file: [885142e5] check-in: [6d78a25d] user: drh branch: apple-osx, size: 35438
2011-04-01
19:14
Changes to wal tests so that they work with DEFAULT_AUTOVACUUM defined. file: [e561a8c6] check-in: [b477852f] user: dan branch: trunk, size: 35369
2011-02-02
19:17
Fix minor problems with the output of "PRAGMA wal_checkpoint". In both code and tests. file: [57a21844] check-in: [aef61036] user: dan branch: trunk, size: 35250
16:34
Merge in the blocking-checkpoint enhancement, including the new sqlite3_wal_checkpoint_v2() interface and the PRAGMA wal_checkpoint(full) statement. file: [c9b23c97] check-in: [bac7342c] user: drh branch: trunk, size: 35238
2010-12-07
15:49
Merge in all changes to the trunk through version 3.7.4rc3. file: [65587c92] check-in: [d2ccf7fc] user: drh branch: apple-osx, size: 35291
2010-11-20
12:01
Extra tests for "PRAGMA checkpoint_fullfsync". file: [3de79785] check-in: [e38c81cc] user: dan branch: trunk, size: 35222
2010-11-19
23:50
Merge all the latest changes from the trunk into the apple-osx branch. file: [ca023e64] check-in: [c8bc057c] user: drh branch: apple-osx, size: 33791
18:48
Add tests for "PRAGMA checkpoint_fullfsync". file: [f4ad3095] check-in: [765aa1b8] user: dan branch: trunk, size: 33723
2010-11-18
16:14
Update test cases to account for the change in the previous commit. file: [894d55dd] check-in: [ae089ec8] user: dan branch: blocking-checkpoint, size: 32081
2010-11-09
20:08
Add "PRAGMA checkpoint_fullfsync". Similar to "PRAGMA fullfsync", but enables full fsyncs only during checkpoint operations. Update: This change was added to the trunk by check-in [a069867301de3ca2e17] file: [03f5f0e1] check-in: [756589ad] user: dan branch: apple-osx-exp, size: 33668
2010-11-01
17:38
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. file: [c794b8b2] check-in: [8dd5c691] user: dan branch: trunk, size: 32064
2010-08-18
00:24
Merge the 3.7.1 pre-release snapshot changes as of 2010-08-18 into the apple-osx branch. file: [998e1807] check-in: [866e9286] user: drh branch: apple-osx, size: 32010
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: [86d38974] check-in: [5e2ee7db] user: adam branch: apple-osx, size: 31840
2010-08-03
18:29
Merge trunk changes into experimental branch. file: [223f3e14] check-in: [15368a9f] user: dan branch: experimental, size: 31941
2010-08-02
14:32
Experimental refactoring of the Pager object state. This version is surely buggy. file: [8581b133] check-in: [03a24051] user: dan branch: experimental, size: 31867
10:59
Modify wal2.test to disable tests requiring TCL 8.5 if the test harness is compiled using TCL 8.4. file: [8dcebda4] check-in: [016486c7] user: drh branch: trunk, size: 31847
2010-07-15
18:20
Changes to wal.c so that SQLite can read even if the WAL file is opened read-only, provided the wal-index (shm file) is opened read/write. file: [fa6dc445] check-in: [932d19da] user: dan branch: trunk, size: 31771
2010-07-14
18:10
Fix an assert() failure in wal2.test caused by messing with the contents of shared memory. file: [7c50a38a] check-in: [9f452514] user: dan branch: trunk, size: 31771
16:37
Test the libraries response to read-only or unreadable database, WAL and wal-index files. If a WAL file cannot be opened in read/write mode, return SQLITE_CANTOPEN to the caller. file: [9a05210e] check-in: [45bb84c6] user: dan branch: trunk, size: 31453
14:48
On unix, try to create the *-wal and *-shm files with the same permissions as the associated database file. file: [b26d04c3] check-in: [e5d180ee] user: dan branch: trunk, size: 28489
07:06
Test that a corrupted WAL hash-table does not put the library into an infinite loop. file: [85775a7f] check-in: [c73886ed] user: dan branch: trunk, size: 27085
2010-07-07
13:54
Make sure the schema is loaded before preparing a "PRAGMA journal_mode" command. This helps it return meaningful results when it is the first command executed by a new database connection. file: [f4e96e3b] check-in: [ef126e77] user: dan branch: trunk, size: 25799
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: [9f2c2a00] check-in: [8d0f8a7f] user: dan branch: trunk, size: 25820
2010-06-22
15:18
Add codec support to wal mode. file: [7ea1426f] check-in: [393741eb] user: dan branch: trunk, size: 24100
13:46
Some changes to test scripts related to codec enabled versions of sqlite. file: [fac65993] check-in: [85dd51a7] user: dan branch: trunk, size: 24262
2010-06-11
19:04
Experimental change to the xShmXXX parts of the VFS interface. file: [f9dce93a] check-in: [ca68472d] user: dan branch: experimental, size: 24097
2010-06-09
14:45
Shift the meaning of aReadMark[] back so that +1 offset from mxFrame is removed. Add the new READMARK_NOT_USED value (0xffffffff) instead of zero to signal an aReadMark[] that is not in use. file: [854a2b40] check-in: [c576827d] user: drh branch: trunk, size: 24476
11:02
Fix for race condition in WAL locking code. file: [329cf990] check-in: [7c102c7b] user: dan branch: mistake, size: 24786
2010-06-07
06:11
Add a couple of extra coverage tests for wal.c. file: [f70bbe26] check-in: [cfe60254] user: dan branch: trunk, size: 24428
2010-06-04
18:38
Clarify an assert in sqlite3WalExclusiveMode(). file: [743d9b86] check-in: [25585069] user: dan branch: trunk, size: 24099
12:22
Add test for the code that detects an inconsistent pair of wal-index headers to wal2.test. file: [c90d2036] check-in: [157feba1] user: dan branch: trunk, size: 22571
2010-06-03
09:25
Enhancements to test_vfs.c and walfault.test. file: [1dcbbe59] check-in: [ac0de2f3] user: dan branch: trunk, size: 20692
2010-06-02
16:39
Updated wal2.test for windows testing. file: [a2146846] check-in: [c3606f39] user: shaneh branch: trunk, size: 20698
2010-06-01
07:51
Fixes to the test cases in wal2.test. file: [a7c0265e] check-in: [cd5fbcbc] user: dan branch: wal-incr-ckpt, size: 20689
2010-05-31
16:41
Avoid dropping the checkpoint lock after a recovery run as a precursor to a checkpoint operation. file: [6c1596e2] check-in: [cc25cfa0] user: dan branch: wal-incr-ckpt, size: 18504
2010-05-29
06:18
Minor changes to checksum related test cases. file: [c58bb5b2] check-in: [60c22bde] user: dan branch: trunk, size: 17900
2010-05-24
17:00
Fix the wal2.test script so that it works in auto_vacuum mode. file: [a10f52b4] check-in: [6a818afb] user: drh branch: trunk, size: 17719
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: [d9a50d1b] check-in: [8a53f12c] user: dan branch: trunk, size: 17692
2010-05-21
16:23
Correct an off-by-one bug in the previous commit. file: [053c9ea9] check-in: [75a1130d] user: dan branch: trunk, size: 17561
15:31
Remove entries from wal-index hash tables when a rollback or savepoint rollback occurs. file: [6033cec9] check-in: [36795c2b] user: dan branch: trunk, size: 16359
2010-05-20
23:51
Add a new xShmBarrier method to the VFS - a shared-memory fence operation. Implement the same in both unix and win32. Use it to make the WAL subsystem more robust. file: [c9f470f7] check-in: [1bd011c9] user: drh branch: trunk, size: 15667
21:21
Make use of the extra information in the WAL header and frame header to enhance robustness. file: [ed0d5057] check-in: [9580ecb7] user: drh branch: trunk, size: 15665
2010-05-14
08:39
Add xShmXXX methods to test_osinst.c. file: [03059bc4] check-in: [b8a9b37a] user: dan branch: trunk, size: 15655
2010-05-12
06:54
Remove a branch made redundant by the earlier exclusive-mode changes. file: [2eba114f] check-in: [c501b2ed] user: dan branch: trunk, size: 15389
2010-05-11
12:19
Changes so that WAL and exclusive-locking mode work together. file: [913fc65e] check-in: [71e7b1cf] user: dan branch: trunk, size: 15102
2010-05-06
18:48
Instead of transitioning to RECOVER state from CHECKPOINT when a recovery is required, perform the recovery while holding the CHECKPOINT lock. file: [0f53c711] check-in: [bb0b6021] user: dan branch: trunk, size: 10163
18:27
If recovery is run before a checkpoint, change back to a CHECKPOINT lock before performing the actual checkpoint. file: [8057c4ee] check-in: [dc98ee16] user: dan branch: trunk, size: 10180
18:04
Only pass -1 as the size parameter to xShmGet when the caller does not care what size mapping is returned. Only call xShmSize when the underlying allocation (not the mapping) should be resized. file: [1d5b761f] check-in: [637f51dd] user: dan branch: trunk, size: 9420
13:36
Unset a tcl variable before reusing it in wal.test. file: [4a8e2041] check-in: [e83efb23] user: dan branch: trunk, size: 8616
12:15
Add tests for some lock-contention cases. file: [d56139ed] check-in: [f0fcb9c9] user: dan branch: trunk, size: 8617
11:32
Add test cases to test the libraries handling of corrupt wal-index headers. file: [cf110b32] check-in: [9465b267] user: dan branch: trunk, size: 6913 Added