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

59 check-ins using file src/main.c version 5f857e9f

2010-06-03
09:25
Enhancements to test_vfs.c and walfault.test. check-in: ac0de2f3 user: dan tags: trunk
09:17
If an error (OOM or SQLITE_FULL error) occurs while executing an SQL statement and a statement-transaction is automatically rolled back as a result, if a second error occurs during the statement rollback do a full transaction rollback instead. Otherwise the client can be left with an inconsistent cache. This can affect both WAL and rollback modes. check-in: eb80ddc6 user: dan tags: trunk
09:01
If a malloc fails while allocating a savepoint object at the pager level, do not try to roll that savepoint back later on. check-in: 91cb08ff user: dan tags: trunk
2010-06-02
20:38
When a lock fails due to an I/O error (not an SQLITE_BUSY) then the checkpoint should fail. check-in: c6eb0a27 user: drh tags: trunk
18:59
Fix a problem with rolling back to a savepoint opened before the writer decided to wrap the log file. check-in: 6b4aed6a user: dan tags: trunk
17:15
If an error occurs while writing frames to the log to commit a transaction, do not mark the pages as clean in the cache. Otherwise, the subsequent rollback does not roll them back (leaving the client to continue with a cache that makes it appear that the transaction was committed - inconsistent with the database on disk). check-in: cb571c1b user: dan tags: trunk
16:40
Added implementation of vfslog_time() for Windows testing. check-in: b3109f85 user: shaneh tags: trunk
16:39
Updated wal2.test for windows testing. check-in: c3606f39 user: shaneh tags: trunk
15:59
Make sure the directory used by os_unix.c for shared-memory files is always the same, regardless of individual client permissions and environment variable settings. check-in: f97bd520 user: drh tags: trunk
15:43
When walTryBeginRead() encounters an I/O error trying to set a lock (as opposed to SQLITE_BUSY) be sure to propagate that error back up the call stack. check-in: aa2c2b67 user: drh tags: trunk
14:45
Changes to make WAL more robust against SHM locking failures and OOM errors. check-in: ebf40413 user: drh tags: trunk
14:43
In the rowhash.test, make sure global variables are cleared prior to use. check-in: 28efe0a4 user: drh tags: trunk
12:58
Undo one of the "const" markers from the previous check-in because the value needs to be changable, even if it is not actually ever changed in the current implementation. check-in: c24ac356 user: drh tags: trunk
05:53
Add some 'const' markers to static data that is really constant. check-in: e7073e23 user: dan tags: trunk
2010-06-01
21:02
The shared-memory used by WAL on linux now really is shared memory in /dev/shm. On other unix flavors, the file is in a temporary directory rather than in the same directory as the database. check-in: fc18c4aa user: drh tags: trunk
19:15
Changes to the way faults are injected into xShmXXX VFS calls. check-in: 716d99f3 user: dan tags: trunk
17:46
Change the OOM and IO error test cases in walfault.test so that each test case runs both types of error simulation. check-in: b627e153 user: dan tags: trunk
15:44
Delay the decision to restart the log file until data is actually ready to be written to the log file (instead of at the start of a write transaction). check-in: b1abfaaf user: dan tags: trunk
15:24
The incremental checkpoint feature is not perfect yet, but it is working well enough to merge it into the trunk. check-in: 1d3e569e user: drh tags: trunk
14:30
Merge with [15abbc3416]. Closed-Leaf check-in: f4b9003a user: dan tags: wal-incr-ckpt
14:12
If an attempt to get a read-lock on the WAL fails with SQLITE_BUSY_RECOVER, call the busy-handler at the btree level. check-in: ce644965 user: dan tags: wal-incr-ckpt
13:17
Fix a bug introduced by the previous check-in but only seen if SQLITE_ENABLE_EXPENSIVE_ASSERTS is turned on. check-in: 9c9ec899 user: drh tags: wal-incr-ckpt
12:58
Fix an off-by-one boundary-value issue in walCleanupHash(). check-in: f039552e user: drh tags: wal-incr-ckpt
11:08
Do not hold the shared-memory mutex in os_unix.c if returning NULL. check-in: 9622dd46 user: dan tags: wal-incr-ckpt
10:44
If the checkpoint fails to obtain an exclusive lock on one of the read-lock bytes, do not consider this an error. check-in: 9e95e357 user: dan tags: wal-incr-ckpt
07:51
Fixes to the test cases in wal2.test. check-in: cd5fbcbc user: dan tags: wal-incr-ckpt
01:08
Comment edits and cleanup in wal.c. No functional code changes. check-in: e8e666ab user: drh tags: wal-incr-ckpt
00:28
Attempt to get the filectrl.test script running. check-in: e46a8f2b user: drh tags: wal-incr-ckpt
00:03
Fix os_unix.c so that it will compile and build on a Mac. check-in: bc707c83 user: drh tags: wal-incr-ckpt
2010-05-31
20:28
Fix issues with locking_mode=EXCLUSIVE in WAL. check-in: 8deba0ce user: drh tags: wal-incr-ckpt
18:24
Add an "isInit" field in the wal-index header that must be non-zero for a valid header. Use this to detect an uninitialized wal-index. check-in: a16fde19 user: drh tags: wal-incr-ckpt
16:56
Fix an inconsistent #ifdef in wal.c. Fix os_unix.c so that it does not allow moving an SHM lock directly exclusive to shared without going through unlocked. check-in: 552658da user: drh tags: wal-incr-ckpt
16:41
Avoid dropping the checkpoint lock after a recovery run as a precursor to a checkpoint operation. check-in: cc25cfa0 user: dan tags: wal-incr-ckpt
16:17
Zero the checkpoint header as the last step of successful WAL recovery. Avoid an unnecessary lock/unlock in WalBeginReadTransaction. check-in: db3509c5 user: dan tags: wal-incr-ckpt
16:10
Get the new xShmLock interface design working on os_win.c. check-in: 149a7082 user: drh tags: wal-incr-ckpt
14:39
Make sure WAL alway requests enough shared-memory space. check-in: 138f1283 user: drh tags: wal-incr-ckpt
14:28
Remove the tests that enable tracing based on the existance of the "vdbe_*" files when in SQLITE_DEBUG mode. check-in: cdbb4e7c user: drh tags: wal-incr-ckpt
14:18
Update another test case in wal.test. check-in: 99fde69e user: dan tags: wal-incr-ckpt
13:11
Change WAL test cases to account for the improved concurrency in the new checkpoint logic. check-in: 2d6f2485 user: drh tags: wal-incr-ckpt
12:30
Do not fail a checkpoint just because active readers prevent backfill. check-in: 9aa4243e user: drh tags: wal-incr-ckpt
12:15
Add WALTRACE() macros to help with debugging and analysis. check-in: 765c3318 user: drh tags: wal-incr-ckpt
12:02
Another minor fix to checkpoint on the WAL branch. check-in: 853f1e3f user: dan tags: wal-incr-ckpt
11:39
Fix a bug in checkpoint introduced by [181ceb32ea]. check-in: b499dbc8 user: dan tags: wal-incr-ckpt
11:16
Fix some asserts and other things in the new WAL branch. check-in: 181ceb32 user: dan tags: wal-incr-ckpt
06:38
Changes to the way one of the WAL/OOM tests works. check-in: 15abbc34 user: dan tags: trunk
01:41
WAL runs but quickly deadlocks. check-in: ace58acb user: drh tags: wal-incr-ckpt
2010-05-30
19:55
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: ef3ba7a1 user: drh tags: wal-incr-ckpt
2010-05-29
08:40
Add tests to fkey2.test to check that ON CONFLICT clauses do not affect SQLite's behaviour when an FK constraint is violated. check-in: e9e5b100 user: dan tags: trunk
06:18
Minor changes to checksum related test cases. check-in: 60c22bde user: dan tags: trunk
2010-05-28
11:16
Add a test to walcksum.test to stress the checksum calculation. check-in: 778d0c17 user: dan tags: trunk
2010-05-26
17:31
Make sure the wal-index mapping is always large enough to cover the entire active area of the wal-index. check-in: 42705bab user: drh tags: trunk
15:06
Change the semantics of xShmGet() such that it will never increase the size of shared memory. xShmSize() must be used to grow the size of shared memory. A shared memory segment size cannot be shrunk (except by dropping it). check-in: 72de0073 user: drh tags: trunk
2010-05-25
15:53
Updated header comments in wal.c. No functional code changes. check-in: 687632a6 user: drh tags: trunk
15:23
Add a busy-handler to a test case in walthread.test to prevent errors. check-in: d3d348aa user: dan tags: trunk
13:49
Modify walcrash2.test so that it works with DEFAULT_AUTOVACUUM=1. check-in: 77438882 user: dan tags: trunk
13:40
Update header comments in wal.c to correctly describe the WAL file format. Update the locking region offsets in os_unix.c and os_win.c and add assert() statement to verify that the locking region offsets are correct. check-in: 40030c07 user: drh tags: trunk
10:50
If a writer exits unexpectedly in the middle of a transaction, have the following writer remove any wal-index hash-table entries left by the interrupted transaction. check-in: ed77556a user: dan tags: trunk
02:24
Remove unreachable code associated with WAL from the pager. check-in: 54c1718e user: drh tags: trunk
2010-05-24
20:27
OOM errors during an auto-checkpoint are benign. check-in: 3d252ce5 user: drh tags: trunk