Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
79 events for the month beginning 2010-04-01 by user dan
Following month ↑
2010-04-30
| ||
17:05 | Fix a problem with resizing the wal-index mapping after the mapping has been extended by an external process. (check-in: 79d356fe user: dan tags: wal) | |
16:50 | Fix a problem with calculating the required size of the wal-index when appending frames. (check-in: 9526b111 user: dan tags: wal) | |
16:41 | Fix a problem in the previous commit. Both unixShm.lockState and unixShm.readLock should be set to READ when downgrading from a WRITE to a READ lock (check-in: 90119fec user: dan tags: wal) | |
16:38 | Fix a bug whereby upgrading from a READ_FULL to a WRITE lock, and then back to a read lock was dropping all WAL locks. (check-in: 55f5af5e user: dan tags: wal) | |
16:24 | Reapply commits [837d82a929] and [c05e7dca17] that were accidentally overwritten. (check-in: 598de527 user: dan tags: wal) | |
16:19 | Add xShmXXX() methods to the test VFS in test_devsym.test. (check-in: 1d203424 user: dan tags: wal) | |
15:49 | When closing a WAL connection, attempt an exclusive lock on the database file. If the lock is obtained, checkpoint the database and delete the wal and wal-index files. (check-in: c05e7dca user: dan tags: wal) | |
15:24 | If a reader attempts to upgrade to a writer, but is not reading the most recent database snapshot, return SQLITE_BUSY. (check-in: 837d82a9 user: dan tags: wal) | |
11:43 | Add a missing walIndexUnmap() call to the checkpoint code. Change a couple of SQLITE_CANTOPEN constants to SQLITE_CANTOPEN_BKPT. (check-in: 1f9e8c5c user: dan tags: wal) | |
10:24 | Fix an assert() in sqlite3WalRead(). (check-in: 2e7a0050 user: dan tags: wal) | |
10:06 | Add missing mutexes to unixShmClose(). (check-in: a4741cb5 user: dan tags: wal) | |
09:52 | Fix a couple of assert() statements in os_unix.c and wal.c. Combine sqlite3WalIsDirty() with sqlite3WalUndo(). (check-in: a8f958be user: dan tags: wal) | |
09:32 | Add a missing walIndexUnmap() to sqlite3WalSnapshotOpen(). (check-in: 72b95fde user: dan tags: wal) | |
06:02 | Merge latest bugfix into wal branch. (check-in: 265e66e6 user: dan tags: wal) | |
06:00 | • Closed ticket [c39ff61c]: Erroneous FK constraint failure when reusing statement plus 2 other changes (artifact: 07e0b188 user: dan) | |
05:59 | • Edit [f660be615a0c1f46|f660be61]: Timestamp 2010-04-30 05:57:56. (artifact: c81af780 user: dan) | |
05:57 | Zero the "immediate FK constraint counter" associated with a statement object when sqlite3_reset() is called. Fix for [c39ff61c43]. (check-in: f660be61 user: dan tags: trunk) | |
2010-04-29
| ||
22:58 | • Edit [f660be615a0c1f46|f660be61]: Timestamp 2010-04-30 07:57:56. (artifact: 471f0782 user: dan) | |
22:55 | • Add attachment fk_bug.c to ticket [c39ff61c] (artifact: ea580399 user: dan) | |
22:53 | • New ticket [c39ff61c] Erroneous FK constraint failure when reusing statement. (artifact: 0e827cda user: dan) | |
14:58 | Close all open database connections at the end of wal.test. (check-in: 3cc55a75 user: dan tags: wal) | |
14:53 | • Edit [d1cadeed4eea20d8|d1cadeed]: Edit check-in comment. Timestamp 2010-04-29 14:51:33. (artifact: aa69ba77 user: dan) | |
14:51 | Fix a bug in the WAL checkpoint code causing SQLite to use an inconsistent cache in a subsequent transaction. (check-in: d1cadeed user: dan tags: wal) | |
08:47 | Add tests to walthread.test. (check-in: 9e891e75 user: dan tags: wal) | |
2010-04-28
| ||
18:17 | Add a test to walthread.test for changing between WAL and rollback modes. (check-in: da229e44 user: dan tags: wal) | |
17:49 | Merge two "wal" leaves. (check-in: 13d2d5a6 user: dan tags: wal) | |
17:48 | Change walthread.test so that tests can be run with either multiple threads or multiple processes. (check-in: 25f85f68 user: dan tags: wal) | |
2010-04-27
| ||
19:13 | • Edit [be44349d2b790fb4|be44349d]: Edit check-in comment. Timestamp 2010-04-27 18:43:17. (artifact: fbda362c user: dan) | |
18:49 | Merge two "wal" leaves. (check-in: 8c2d43ba user: dan tags: wal) | |
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. (check-in: be44349d user: dan tags: wal) | |
14:37 | Fix a problem with identifying a corrupt database in WAL mode. (check-in: c8658da4 user: dan tags: wal) | |
06:49 | Run trans.test and avtrans.test as part of the "wal" permutation. (check-in: c8893310 user: dan tags: wal) | |
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. (check-in: b51a5f8b user: dan tags: wal) | |
2010-04-26
| ||
17:42 | Do not attempt to set journal_mode=wal on :memory: or temp file databases. (check-in: 30d01344 user: dan tags: wal) | |
16:57 | Fixes for problems with small caches and SAVEPOINT rollback in WAL mode. (check-in: 6a944f02 user: dan tags: wal) | |
12:39 | Add the "wal" permutation to run existing test files savepoint.test and savepoint2.test in WAL mode. (check-in: 205e5d8a user: dan tags: wal) | |
10:40 | Add mutexes to fix a race condition in wal.c. This isn't a very good fix. (check-in: 3d159939 user: dan tags: wal) | |
2010-04-24
| ||
19:07 | Add comment explaining checksum mechanism. (check-in: 3e9ef515 user: dan tags: wal) | |
18:44 | Fix bugs in WAL mode rollback. (check-in: 31215969 user: dan tags: wal) | |
14:33 | Merge with [0291ed974d]. Merge with [0291ed974d]. Merge with [0291ed974d]. (check-in: a352f628 user: dan tags: wal) | |
04:53 | Merge with [e79dac3c2f]. (check-in: 1e793d3a user: dan tags: wal) | |
04:49 | Reserve some space at the start of the log-summary file to apply locks to. (check-in: a031aa1f user: dan tags: wal) | |
2010-04-23
| ||
19:15 | Fixes and tests for backup of a WAL database. (check-in: 480d12db user: dan tags: wal) | |
11:44 | Add very simple test cases for backup and VACUUM of WAL databases. More to come. (check-in: 1077d813 user: dan tags: wal) | |
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. (check-in: 5d6d4423 user: dan tags: wal) | |
06:27 | Further tests and changes related to switching between WAL and rollback modes. (check-in: 12363184 user: dan tags: wal) | |
2010-04-21
| ||
18:37 | Tests for (and changes to) the code to switch between WAL and rollback modes. (check-in: 9f4f933f user: dan tags: wal) | |
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. (check-in: 33cabf27 user: dan tags: wal) | |
06:19 | Minor changes to test cases to account for the fact that databases with read/write versions of 2 are now understood. (check-in: 278ed41e user: dan tags: wal) | |
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. (check-in: 96bef18c user: dan tags: wal) | |
2010-04-19
| ||
18:03 | Add the sqlite3_log_hook() interface for scheduling checkpoints. (check-in: 9bda6014 user: dan tags: wal) | |
2010-04-17
| ||
18:50 | Add some comments regarding file-locks to log.c. (check-in: 9d51c3b7 user: dan tags: wal) | |
17:34 | Do not sync any files in wal mode if "PRAGMA synchronous=off" is set. If files are synced, pass either SQLITE_SYNC_FULL or SQLITE_SYNC_NORMAL to the xSync() callback as configured by "PRAGMA fullfsync". (check-in: 0ae91b00 user: dan tags: wal) | |
15:45 | Merge with trunk commit [3e646e3f4c]. (check-in: 43463970 user: dan tags: wal) | |
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. (check-in: 9bc9b684 user: dan tags: wal) | |
12:31 | Enhancements to wal-mode locking scheme. (check-in: 8549c286 user: dan tags: wal) | |
2010-04-16
| ||
13:59 | Change the log file format to include a small (12 byte) header at the start of the file. (check-in: 9865d14d user: dan tags: wal) | |
11:30 | Fix bug in log recovery (last frame in log was being ignored). Also remove an incorrect assert statement. (check-in: 67d2a89e user: dan tags: wal) | |
2010-04-15
| ||
16:45 | Allow writers to write dirty pages to the log mid-transaction in order to free memory. (check-in: ecd828f9 user: dan tags: wal) | |
14:28 | • New ticket [02a8e81d] LIMIT clause on sub-select in FROM clause of a SELECT in a UNION ALL interpreted incorrectly. (artifact: 5b18826a user: dan) | |
13:33 | Merge two leaves on the WAL branch. (check-in: c9ed66cc user: dan tags: wal) | |
10:58 | Change the way checksums are calculated. (check-in: 84955c2e user: dan tags: wal) | |
2010-04-14
| ||
18:50 | Add tests and fix bugs in WAL locking mechanism. (check-in: c18077f2 user: dan tags: wal) | |
18:06 | Add tests to check inter-process WAL locking. (check-in: 9435f313 user: dan tags: wal) | |
15:49 | Improve the logLockRegion() function in log.c. (check-in: 5e9dd3bd user: dan tags: wal) | |
11:23 | Fixes for locking issues in WAL mode. (check-in: a9617eff user: dan tags: wal) | |
2010-04-13
| ||
19:27 | Add experimental locking scheme. (check-in: 3f958e87 user: dan tags: wal) | |
11:56 | Remove old code to interpret an argument (no longer used) to "PRAGMA checkpoint". (check-in: 27dc5977 user: dan tags: wal) | |
11:45 | Fix other problems in the WAL test scripts. (check-in: dcb31181 user: dan tags: wal) | |
11:35 | Fix test script issues preventing walthread.test from running. (check-in: d90b1dde user: dan tags: wal) | |
11:18 | Fix a pager bug introduced by the wal code. (check-in: 4a0b29dc user: dan tags: wal) | |
06:20 | Sync wal branch with [012cf101bf]. (check-in: 9d690f24 user: dan tags: wal) | |
06:18 | Test that the rollback-hook is invoked if a commit-hook implementation returns non-zero (causing a rollback). Remove documentation comment that says otherwise from sqlite.h.in. (check-in: 012cf101 user: dan tags: trunk) | |
2010-04-12
| ||
19:05 | Add "log.h", which should have been part of the previous commit. (check-in: 8de9f010 user: dan tags: wal) | |
19:00 | Import experimental write-ahead-logging code. (check-in: 409d61ba user: dan tags: wal) | |
17:10 | • Edit [51a6139508246986|51a61395]: Edit check-in comment. Timestamp 2010-04-12 17:08:45. (artifact: 5072fa36 user: dan) | |
17:09 | • Edit [51a6139508246986|51a61395]: Edit check-in comment. Timestamp 2010-04-12 17:08:45. (artifact: cf186cd3 user: dan) | |
17:08 | Fix a problem where a process in exclusive mode could delete a hot-journal file without rolling it back from within sqlite3_close() or DETACH. This problem was introduced by commits from the past few days; it is not present in any release. (check-in: 51a61395 user: dan tags: trunk) | |
2010-04-07
| ||
07:57 | Add file test_demovfs.c, containing a simple VFS implementation that demonstrates how writes to the journal file may be safely buffered by the VFS layer to improve performance on some embedded systems. (check-in: af3b72d9 user: dan tags: trunk) | |