/ File History
Login

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

History of test/wal2.test

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