๐ŸŒ AIๆœ็ดข & ไปฃ็† ไธป้กต
  1. 6fcff07 If the sqlite3_wal_checkpoint() API is passed a NULL pointer in place of a database name, attempt to checkpoint all attached databases. by dan ยท 16 years ago wal
  2. b033d8b Make sure the mutex is held while calling sqlite3ApiExit() in by drh ยท 16 years ago
  3. 87c1fe1 Have sqlite3_wal_checkpoint() populate the database handle error message and error code (as returned by sqlite3_errmsg() and sqlite3_errcode()). by dan ยท 16 years ago
  4. 5a299f9 Add the "PRAGMA wal_autocheckpoint" command. Rename "PRAGMA checkpoint" to "PRAGMA wal_checkpoint". by dan ยท 16 years ago
  5. 11398e5 Merge two wal leaves. by dan ยท 16 years ago
  6. 586b9c8 Add the sqlite3_wal_checkpoint() and sqlite3_wal_autocheckpoint() APIs. by dan ยท 16 years ago
  7. 2d536e1 Change the SHM interface so that it does not take the name of the shared by drh ยท 16 years ago
  8. f72a875 Remove the xShmPush and xShmPull methods from the VFS. by drh ยท 16 years ago
  9. bee6f4e Define an invariant to guarantee deadlock-free operation of SHM in os_unix.c by drh ยท 16 years ago
  10. 77b95a3 Rework mutexes on the SHM implemention for os_unix to avoid a deadlock during by drh ยท 16 years ago
  11. 5cf5353 Support compile-time option SQLITE_OMIT_WAL, for building without WAL support. by dan ยท 16 years ago
  12. 057f1ec Fix a typo in the walmode.test test script introducted yesterday. by drh ยท 16 years ago
  13. 7aba8fd Fix the sqlite3_mutex_alloc() interface to return NULL (not segfault) when by drh ยท 16 years ago
  14. bb16ff7 Add test case demonstrating deadlock during recovery of very large log files. No fix yet. by dan ยท 16 years ago
  15. d80b233 Do not allow journal_mode=WAL if the underlying VFS does not support xShmOpen. by drh ยท 16 years ago
  16. 27d52b2 Merge in changes from the trunk. by drh ยท 16 years ago
  17. be837bd Avoid assertion faults in queries using indices with redundant columns. by drh ยท 16 years ago
  18. 6dea324 Change the SHM VFS logic in os_unix.c so that it does not hold an exclusive by drh ยท 16 years ago
  19. 1b48aa4 Remove some obsolete debugging parameters. by drh ยท 16 years ago
  20. fe05aa1 Fix a problem with resizing the wal-index mapping after the mapping has been extended by an external process. by dan ยท 16 years ago
  21. c9d53db Fix a problem with calculating the required size of the wal-index when appending frames. by dan ยท 16 years ago
  22. 400df2e In the debugging output for SHM-LOCK in os_unix.c, use symbolic names by drh ยท 16 years ago
  23. 43a56b8 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 by dan ยท 16 years ago
  24. 78daa5a 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. by dan ยท 16 years ago
  25. 30c8629 Reapply commits [837d82a929] and [c05e7dca17] that were accidentally overwritten. by dan ยท 16 years ago
  26. 6ddb4bf Add xShmXXX() methods to the test VFS in test_devsym.test. by dan ยท 16 years ago
  27. 49156b2 Correctly record the fact that the SHM lock reached PENDING if it did so by drh ยท 16 years ago
  28. d749084 Fix a couple uninitialized variables in the xShmLock method of the unix VFS. by drh ยท 16 years ago
  29. a7ad518 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. by dan ยท 16 years ago
  30. 6045461 If a reader attempts to upgrade to a writer, but is not reading the most recent database snapshot, return SQLITE_BUSY. by dan ยท 16 years ago
  31. 5530b76 Separate the concepts of underlying storage size and mapped size in the by drh ยท 16 years ago
  32. 87bfb51 Add a missing walIndexUnmap() call to the checkpoint code. Change a couple of SQLITE_CANTOPEN constants to SQLITE_CANTOPEN_BKPT. by dan ยท 16 years ago
  33. 1bc6171 Fix an assert() in sqlite3WalRead(). by dan ยท 16 years ago
  34. e93808d Add missing mutexes to unixShmClose(). by dan ยท 16 years ago
  35. 4c97b53 Fix a couple of assert() statements in os_unix.c and wal.c. Combine sqlite3WalIsDirty() with sqlite3WalUndo(). by dan ยท 16 years ago
  36. ba51590 Add a missing walIndexUnmap() to sqlite3WalSnapshotOpen(). by dan ยท 16 years ago
  37. 5047af4 Merge latest bugfix into wal branch. by dan ยท 16 years ago
  38. 79e6c78 The first 6 WAL tests now work. It's a start. by drh ยท 16 years ago
  39. 6908343 Zero the "immediate FK constraint counter" associated with a statement object when sqlite3_reset() is called. Fix for [c39ff61c43]. by dan ยท 16 years ago
  40. 7ed91f2 Refactor wal.c to use the VFS. This check-in compiles and links and works by drh ยท 16 years ago
  41. 31cbbba Untested implementation of the shared-memory dead-man-switch. by drh ยท 16 years ago
  42. 7b69440 Progress towards a VFS that will support WAL. Locking code is in place by drh ยท 16 years ago
  43. 185cca6 Close all open database connections at the end of wal.test. by dan ยท 16 years ago
  44. 31c0390 Fix a but in the WAL checkpoint code causing SQLite to use an inconsistent cache in a subsequent transaction. by dan ยท 16 years ago
  45. b4e3a6f Add tests to walthread.test. by dan ยท 16 years ago
  46. e45d442 Add a test to walthread.test for changing between WAL and rollback modes. by dan ยท 16 years ago
  47. f032f53 Merge two "wal" leaves. by dan ยท 16 years ago
  48. 5e0ce87 Change walthread.test so that tests can be run with either multiple threads or multiple processes. by dan ยท 16 years ago
  49. 9beb158 Changes to the interface design for the xShmLock method of the VFS. by drh ยท 16 years ago
  50. 833bf96 Rename the sqlite3_log_hook() to sqlite3_wal_hook(). Added comments to wal.h. by drh ยท 16 years ago
  51. 4b64c1e Merge two "wal" leaves. by dan ยท 16 years ago
  52. 8b348af 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. by dan ยท 16 years ago
  53. 8b5444b Fix a problem with identifying a corrupt database in WAL mode. by dan ยท 16 years ago
  54. af75c86 Add the xShmRelease() method to the VFS. The os_unix.c implementation of by drh ยท 16 years ago
  55. e106de6 Run trans.test and avtrans.test as part of the "wal" permutation. by dan ยท 16 years ago
  56. 31f98fc 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. by dan ยท 16 years ago
  57. 29d4bec Merge in recent changes from the trunk by drh ยท 16 years ago
  58. 8c6f666 Optimization: Convert an ORDER BY clause into a no-op if the query also by drh ยท 16 years ago
  59. e180c29 Do not attempt to set journal_mode=wal on :memory: or temp file databases. by dan ยท 16 years ago
  60. 93791ea Change the default_cache_size pragma to always store a positive value. by drh ยท 16 years ago
  61. c6d2b4a Identify the SQLite version meta-value entry in the db-header output of showdb. by drh ยท 16 years ago
  62. 4cd78b4 Fixes for problems with small caches and SAVEPOINT rollback in WAL mode. by dan ยท 16 years ago
  63. 7ecc147 Further enhancements to the showdb utility: A page number followed by "b" by drh ยท 16 years ago
  64. 562cedb Enhancements to the showdb.c utility program. Automatically detect the by drh ยท 16 years ago
  65. 71cb518 Add the "wal" permutation to run existing test files savepoint.test and savepoint2.test in WAL mode. by dan ยท 16 years ago
  66. cd11fb2 Add mutexes to fix a race condition in wal.c. This isn't a very good fix. by dan ยท 16 years ago
  67. c438efd Change the names of the log.c and log.h source files to wal.c and wal.h. by drh ยท 16 years ago
  68. f2424c5 Begin moving WAL-specific I/O into the VFS. This checkin contains VFS by drh ยท 16 years ago
  69. a474184 Remove an unreachable branch from the function initialization logic. by drh ยท 16 years ago
  70. 56d9591 Add comment explaining checksum mechanism. by dan ยท 16 years ago
  71. 74d6cd8 Fix bugs in WAL mode rollback. by dan ยท 16 years ago
  72. 9de7943 Merge with [0291ed974d]. Merge with [0291ed974d]. Merge with [0291ed974d]. by dan ยท 16 years ago
  73. 545f587 When commands such as ALTER TABLE and VACUUM use SQL internally, make sure by drh ยท 16 years ago
  74. 4f08d4b Merge with [e79dac3c2f]. by dan ยท 16 years ago
  75. ff20701 Reserve some space at the start of the log-summary file to apply locks to. by dan ยท 16 years ago
  76. 3306c4a Fixes and tests for backup of a WAL database. by dan ยท 16 years ago
  77. 9a6e897 Merge of notify.c changes from experimental. by shaneh ยท 16 years ago
  78. d5c99c3 Add very simple test cases for backup and VACUUM of WAL databases. More to come. by dan ยท 16 years ago
  79. ce4f05f Create a version of the log checksummer that works on big-endian platforms. Remove the 512KB size limit on the log-summary. by dan ยท 16 years ago
  80. ede6eb8 Further tests and changes related to switching between WAL and rollback modes. by dan ยท 16 years ago
  81. b978002 Tests for (and changes to) the code to switch between WAL and rollback modes. by dan ยท 16 years ago
  82. a470aeb 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. by dan ยท 16 years ago
  83. 28e5386 Minor changes to test cases to account for the fact that databases with read/write versions of 2 are now understood. by dan ยท 16 years ago
  84. e04dc88 Use the read and write version fields of the database header to mark a database as operating in wal-mode. by dan ยท 16 years ago
  85. 8d22a17 Add the sqlite3_log_hook() interface for scheduling checkpoints. by dan ยท 16 years ago
  86. 54934f4 Add some comments regarding file-locks to log.c. by dan ยท 16 years ago
  87. c511878 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". by dan ยท 16 years ago
  88. 335c0fa It is possible for sqlite3.pUnlockConnection to be non-NULL when by drh ยท 16 years ago
  89. dea0a85 Merge with trunk commit [3e646e3f4c]. by dan ยท 16 years ago
  90. 6703239 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. by dan ยท 16 years ago
  91. 3674bfd Change sqlite3_step() so that it automatically calls sqlite3_reset() instead by drh ยท 16 years ago
  92. 3de777f Enhancements to wal-mode locking scheme. by dan ยท 16 years ago
  93. 4b93f6b Changes for branch coverage of notify.c. Fixed quirk of by shaneh ยท 16 years ago
  94. 97a3135 Change the log file format to include a small (12 byte) header at the start of the file. by dan ยท 16 years ago
  95. 4a4b01d Fix bug in log recovery (last frame in log was being ignored). Also remove an incorrect assert statement. by dan ยท 16 years ago
  96. f391327 Disable query flattening when the outer query is a compound SELECT and by drh ยท 16 years ago
  97. 4cc6fb6 Allow writers to write dirty pages to the log mid-transaction in order to free memory. by dan ยท 16 years ago
  98. bb2e9c9 Merge two leaves on the WAL branch. by dan ยท 16 years ago
  99. ed808ac The query planner fix of check-in [33b1f584ef] should have been on the trunk. by drh ยท 16 years ago
  100. 521a72b Fix a problem in the result set size estimation logic of the query planner - by drh ยท 16 years ago