/ Timeline
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.

74 check-ins using file src/sqliteInt.h version 9819b456

2010-05-14
16:34
Pull in all the latest changes from the trunk. Update the win32 SHM methods to work with the new interface design. Closed-Leaf check-in: 4b69f2cd user: drh tags: wal-win32
14:52
Simplifications to the SHM implementation in os_unix.c, taking advantage of the removal of the LinuxThreads mess. check-in: d1debe5d user: drh tags: trunk
12:43
Simplify os_unix.c by removing support for LinuxThreads. Linux systems must either use NPTL or else not share database connections across threads. check-in: e294b696 user: drh tags: trunk
11:30
Change the OSTRACEn() macro to OSTRACE(()). Also rename some internal fields and variables in os_unix.c to be more meaningful and searchable. check-in: 5fe529f2 user: drh tags: trunk
10:43
Fix test_osinst.c so that it does not depend on gettimeofday() unless SQLITE_OS_UNIX is defined and NO_GETTOD is not defined. check-in: 2a4014b7 user: dan tags: trunk
08:39
Add xShmXXX methods to test_osinst.c. check-in: b8a9b37a user: dan tags: trunk
2010-05-13
20:19
Make debugging elements of the sqlite3_mutex object volatile and make them only appear when compiling with SQLITE_DEBUG. Ticket [51914f6acd2cb462]. check-in: e823c60c user: drh tags: trunk
15:44
Allow sqlite3WalCheckpoint() to be called even if the WAL is in the SQLITE_SHM_READ state, as sometimes happens after an error. check-in: 175b296f user: drh tags: trunk
09:40
Remerge mistaken test_osinst.c changes. check-in: e8c10d3c user: dan tags: trunk
09:32
Fix mistake in test_osinst.c. Closed-Leaf check-in: 4c3e1378 user: dan tags: mistake
09:11
Make sure xShmGet is never called while already holding the shared-memory segment. check-in: 92ebdbc5 user: drh tags: trunk
08:53
The refactored of VFS SHM primitives are now working so merge the wal-refactor branch back into the trunk. check-in: bce21c18 user: drh tags: trunk
08:33
Change the xShmSize() implementation in os_unix.c so that it will only increase and never decrease the size of a shared-memory segment. Closed-Leaf check-in: 149d2ae4 user: drh tags: wal-refactor
07:08
Fix for a segfault that can follow a malloc failure. check-in: 3cab9022 user: dan tags: wal-refactor
06:19
Modify the VFS in test_vfs.c to match the refactoring of the xShmXXX methods. check-in: 25e72f81 user: dan tags: wal-refactor
2010-05-12
19:02
(Moved to the mistake branch due to compile errors in test_osinst.c.) Change the vfs instrumentation code in test_osinst.c to make it easier to deploy. Add a vtab implementation for reading the binary log file format. check-in: ee13c884 user: dan tags: mistake
18:30
Fix for the test_devsym.c test module for the VFS-SHM refactoring. check-in: 49d62933 user: drh tags: wal-refactor
18:10
A couple simple fixes to get wal.test mostly working. check-in: c7445812 user: drh tags: wal-refactor
18:01
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: 2b00152c user: drh tags: wal-refactor
17:14
Updates to WAL support in os_win.c: pulled in latest changes from src/os_unix.c; updated tracing; misc. improvements. check-in: 76504726 user: shaneh tags: wal-win32
13:50
Remove the OP_Variable optimization of check-in [48b77b04935d894] since it can lead to malfunctions as described in ticket [26ff0c82d1e90]. check-in: 7838163d user: drh tags: trunk
06:54
Remove a branch made redundant by the earlier exclusive-mode changes. check-in: c501b2ed user: dan tags: trunk
2010-05-11
16:29
Have os_unix.c use the suffix "-wal-index" for wal-index files instead of "-wal-inde". check-in: 885e854e user: dan tags: trunk
14:00
When an attempt to change journal_mode fails due to locks, be sure to leave internal structures in a consistent state. check-in: cf3d1e0b user: drh tags: trunk
12:19
Changes so that WAL and exclusive-locking mode work together. check-in: 71e7b1cf user: dan tags: trunk
02:49
Initial port of WAL VFS support from os_unix.c to os_win.c. check-in: 111ad59f user: shaneh tags: wal-win32
02:46
Updates to WAL TCL test scripts to support running on Windows. check-in: 6a563080 user: shaneh tags: trunk
2010-05-10
19:51
Fix an off-by-one error while constructing the name of the mmap file for the wal-index under os_unix.c. check-in: 6e3735f7 user: drh tags: trunk
18:10
Merge [96d6eaf4d2] and [40b0a6357b]. check-in: c67756c4 user: dan tags: trunk
17:29
Fix an uninitialized variable in OSX proxy locking. check-in: 96d6eaf4 user: drh tags: trunk
14:46
Modify the format of the wal-index to use a hash table to index log file segments. check-in: 40b0a635 user: dan tags: trunk
14:10
If an ATTACH command fails due to OP_JournalMode but still attaches the database, make sure VACUUM still detaches it when done. check-in: 6ecdc7ba user: drh tags: trunk
11:20
Enhance the OP_JournalMode opcode with an ignore-errors option and use that option the ATTACH command. check-in: 0bdea4cf user: drh tags: trunk
2010-05-07
20:34
When running a checkpoint while in locking_mode=EXCLUSIVE, be sure to move the wal-index lock to UNLOCK from READ prior to promoting to CHECKPOINT. check-in: be114bdf user: drh tags: trunk
20:02
Change the xShmOpen() method of the VFS to take the database file name as its argument, not the WAL file name. Also fix some unrelated compiler warnings. check-in: a65c2939 user: drh tags: trunk
18:23
Additional tweaks to API documentation. No functional code changes. check-in: e1230782 user: drh tags: trunk
13:57
Updates to documentation on the C interfaces supporting WAL. No functional changes to code. check-in: 681ba20c user: drh tags: trunk
13:52
Fix a recently introduced problem in wal.test. check-in: 79b52d0f user: dan tags: trunk
12:49
Change wal.test and walhook.test so that they work with DEFAULT_AUTOVACUUM=1 builds. check-in: 4cde9290 user: dan tags: trunk
09:43
Test another IO error case in wal.c. check-in: 8b3b5ab8 user: dan tags: trunk
06:59
Fix a problem with checkpointing large log files created by an external process. check-in: 8f94bde5 user: dan tags: trunk
05:46
Since walIndexTryHdr() can no longer encounter any error conditions, change tehe function signature so that it does not return an error code. This removes unreachable branches from other code. check-in: 061a282c user: dan tags: trunk
00:28
Another attempt to fix permutations.test so that it excludes WAL tests from the journaltest permutation. check-in: 58c40442 user: drh tags: trunk
2010-05-06
22:21
Remove savepoint6.test from the set of tests run by journaltest since savepoint6.test uses journal_mode=WAL. check-in: 811b45a9 user: drh tags: trunk
21:37
The PRAGMA journal_mode=WAL; command now makes WAL the default journal mode for new databases added with ATTACH, so the behavior is consistent with the other journal modes. check-in: c3520460 user: drh tags: trunk
20:19
Make sure to do a clean shutdown of the library upon existing the shell in order to remove WAL files. check-in: c1762dda user: drh tags: trunk
19:55
Exclude all WAL tests from the journaltest permutation. check-in: 46c97d7e user: drh tags: trunk
19:20
Changes to support SQLITE_OMIT_WAL. check-in: 32a8501d user: shaneh tags: trunk
19:04
Updates to the VFS SHM locking documentation. check-in: 9927ce42 user: drh tags: trunk
18:48
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 tags: trunk
18:27
If recovery is run before a checkpoint, change back to a CHECKPOINT lock before performing the actual checkpoint. check-in: dc98ee16 user: dan tags: trunk
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. check-in: 637f51dd user: dan tags: trunk
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. check-in: d0c0034b user: dan tags: trunk
16:06
After throwing an error to say that one cannot change into WAL mode within a tranactions, do not then go and change into WAL mode. check-in: 56a17dae user: drh tags: trunk
15:56
Further coverage tests. check-in: 98a9713e user: dan tags: trunk
15:36
Update configure scripts for WAL support. check-in: 2edc5129 user: shaneh tags: trunk
14:42
Add tests to cover a couple of branches in wal.c. check-in: 429f437f user: dan tags: trunk
13:36
Unset a tcl variable before reusing it in wal.test. check-in: e83efb23 user: dan tags: trunk
12:15
Add tests for some lock-contention cases. check-in: f0fcb9c9 user: dan tags: trunk
11:56
Remove the noop-mutex implementations of mutex_held() and mutex_notheld() since they are both unreachable. check-in: 6767b62a user: drh tags: trunk
11:55
Add two text files containing pager design notes to the doc/ subfolder. check-in: ed817fc8 user: drh tags: trunk
11:32
Add test cases to test the libraries handling of corrupt wal-index headers. check-in: 9465b267 user: dan tags: trunk
07:43
Add tests for handling errors returned by xShm VFS methods. check-in: fbbcacb1 user: dan tags: trunk
2010-05-05
20:00
Change the behavior of the sqlite3_wal_hook() callback. It should now return SQLITE_OK or an error code and the error code is propagated back up the stack. If a checkpoint is desired, the callback should invoke sqlite3_wal_callback() itself. check-in: 1b14195e user: drh tags: trunk
19:09
Further simplifications to the SHM locking logic. Remove the SQLITE_SHM_QUERY option. Unify the WRITE to READ and RECOVER to READ transitions. check-in: e9bfa6e4 user: drh tags: trunk
19:04
Test the handling of errors returned by the xShmXXX() APIs. check-in: 72663123 user: dan tags: trunk
18:46
Do not compare page sizes on source and destination of backup until transactions are started and the page sizes are locked. This is a fix to check-in [7bd44794c4]. check-in: ec715778 user: drh tags: trunk
18:20
Simplifications to the SHM locking implementation in os_unix.c. check-in: 9de05bfb user: drh tags: trunk
16:23
Prohibit backup if the destination is using WAL and has a different page size from the source. check-in: 7bd44794 user: drh tags: trunk
15:33
When closing a WAL database, if the exclusive lock on the database file is obtained and the database successfully checkpointed, delete the wal-index file from the file system. check-in: 2ac5d96c user: dan tags: trunk
04:11
Make sure the page size of the main database is fixed following a failed VACUUM attempt. Otherwise, two consecutive failed VACUUM attempts with attempted page_size changes on encrypted or WAL databases could result in database corruption. check-in: 208e7d5d user: drh tags: trunk
03:39
Do not attempt to modify the page_size when running VACUUM on a WAL database. check-in: 58a1a59b user: drh tags: trunk
00:22
Get the previous mutex fix working with SQLITE_DEBUG and with the amalgamation. check-in: df19928f user: drh tags: trunk
00:05
When the in single-threaded mode, the sqlite3_mutex_alloc() interface still returns a non-NULL value. The mutex doesn't do anything, but it tests non-NULL. This way, extensions (or VFSes) that use sqlite3_mutex_alloc() can tell the difference between an OOM error and mutexes being disabled. check-in: 451fd175 user: drh tags: trunk