database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-08-10 01:02:56 +03:00
Code Activity
30,720 Commits 1,570 Branches 184 Tags
bedrock
Commit Graph

578 Commits

Author SHA1 Message Date
drh
9214c1efe8 Extra comments on the sqlite3OsShmMap() call in walBeginUnlocked(). No 
changes to code.

FossilOrigin-Name: 033ee92bf4d5dc57f5cb8fd02d1154ae06f2d3261d214e7191a82c70c8ffebf7
 2017-11-08 19:26:27 +00:00
drh
7e45e3a5d7 Change the name of SQLITE_READONLY_CANTLOCK to SQLITE_READONLY_CANTINIT. 
FossilOrigin-Name: 6d7f94faa7e6de62f82bc6cac019508a9c1ffd6fa1d14f52fa93e9c06afdd32f
 2017-11-08 17:32:12 +00:00
dan
6c9d8f640b Update an assert in wal.c. 
FossilOrigin-Name: 94527b897bac66d100ca92161f18b6f0e0768dd77ebcb06e3fb106f0e0e380ee
 2017-11-07 21:25:15 +00:00
dan
08ecefc5b1 Handle the race condition that may occur if another process connects and then 
checkpoints and truncates the wal file while a readonly-shm client is building
its heap-memory wal-index.

FossilOrigin-Name: 5a6703fc3f2174b3e9a624c7272ae013b73c42d6c97ffa62b58553efdb54e3bc
 2017-11-07 21:15:07 +00:00
dan
8706485d1a Merge latest trunk changes into this branch. 
FossilOrigin-Name: 7f217edab4575554f657d38e2a1bc6b3f577998fdbecb04eb200aeb8b8406581
 2017-11-06 20:02:08 +00:00
dan
ab54838452 Add further test cases for the new code on this branch. And a couple of fixes. 
FossilOrigin-Name: 71af9acb227a91d9ad8798c9d0b12d6967e863d050f5cb1fddb45f25ee1f47db
 2017-11-06 19:49:34 +00:00
dan
cbd3321978 Add further tests for the code added on this branch. 
FossilOrigin-Name: a6716fcde38b28b8a03b40f9d16f78a57ec20f60cf391ff553692641cb7f0d3f
 2017-11-04 21:06:35 +00:00
dan
11caf4f4b7 In cases where a readonly_shm client cannot take the DMS lock on the *-shm 
file, have it parse the wal file and create a wal-index to access it in heap
memory.

FossilOrigin-Name: 18b268433d739486eac1b04947bd418655e4bc56e8dc63ffa558aa4552a32e30
 2017-11-04 18:10:03 +00:00
dan
dea5ce36f5 Avoid locking shm-lock WAL_READ_LOCK(0) during recovery. Doing this allows 
recovery to proceed while a readonly_shm connection in unlocked mode has an
ongoing read transaction.

FossilOrigin-Name: 5190d84a296b7cf716ef43bf7b6d4d351ef1a4d650de37dc01a5ab333da7c05d
 2017-11-02 11:12:03 +00:00
dan
92c02da33e If a readonly_shm connection cannot map the *-shm file because no other 
process is holding the DMS lock, have it read from the database file only,
ignoring any content in the wal file.

FossilOrigin-Name: ce5d13c2de69b73378637d4f7e109714f7cd17bf1d1ad995e0be442d517ed1b3
 2017-11-01 20:59:28 +00:00
drh
183f0aa6c4 Fix a minor comment typo. No changes to code. 
FossilOrigin-Name: 5f79e6d9c3d44b0cc7cf805429006f7b29a69e8d863b58472172a56b29a7bb4e
 2017-10-31 12:06:29 +00:00
drh
07dae088b9 Clarify some comments describing the WAL index file. No changes to code. 
FossilOrigin-Name: 3be3aad9ecbe33060cfa9c6059b9206ed221d1fd72a69c355a9387f9f4e075e7
 2017-10-30 20:44:36 +00:00
dan
40927fd61e Add a header comment to wal.c describing the differences between wal and wal2 
mode.

FossilOrigin-Name: 9c80cd202f1c966929b279e18f19c663912686fcf92f03b85a02b9c7e55a0fc6
 2017-10-09 19:49:08 +00:00
dan
50182fa846 Ignore the *-wal2 file if the *-wal file is zero bytes in size. 
FossilOrigin-Name: f7360fad51f224f347bb7d263eb89056b27461c278309e00e575a0e8898c9f40
 2017-10-07 19:55:37 +00:00
dan
bfcf8d6d67 Fix a bug in recovering wal2 mode databases introduced by the previous commit. 
FossilOrigin-Name: 9e1502e1b650217efc361732a3dfe686caa2e6352d040c73865f1faf09bf4591
 2017-10-06 14:08:39 +00:00
dan
24f1b25c7b Fix frame overwriting in wal2 mode. 
FossilOrigin-Name: a4b02bc9388226da21b3837a20c6c7eb0d13854dde62b7136e04f4978528dc71
 2017-10-06 13:43:42 +00:00
dan
3400e78f38 Fix test case failures on this branch. 
FossilOrigin-Name: 16decc13af908087fb8aa34eeccf43e8da1b8f2e4b808028986d1ef08134c72c
 2017-10-05 18:14:46 +00:00
dan
055cc1e431 Add experimental mode that uses two wal files. Activated using "PRAGMA 
journal_mode = wal2".

FossilOrigin-Name: e2fc5c814cf6862d536aacb9eca66ecd31ba7e3e3033fa4c5564d533f4a18dfc
 2017-10-04 20:57:14 +00:00
dan
21f2bafd9b Experimental change so that snapshot transactions always lock the wal file - 
preventing writers or truncate-checkpointers from wrapping it.

FossilOrigin-Name: d71eeaab9ecdeed772047498b781be1f0be0655af284b94cf676bb408ceea8b1
 2017-09-23 07:46:54 +00:00
drh
b25057c291 Merge recent enhancements from trunk. 
FossilOrigin-Name: d53108e76307fb24ef1d8f75fe82c180f5588ad8e65eeceace92f4cecadfa452
 2017-08-28 17:19:35 +00:00
drh
daaae7b9d1 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.

FossilOrigin-Name: bf65dae8d4297c57ac63228ccf0100f9fabf2fb600438c9f2e10a29c4b118168
 2017-08-25 01:14:43 +00:00
drh
9c6e07d2fa Fix an incorrect hyperlink in a comment. 
FossilOrigin-Name: 25292b9a4eb5efc7db551da0b3c9cfd7e79da1594ee14729de44090e188c2b2a
 2017-08-24 20:54:42 +00:00
dan
6aab028db0 Fix a problem allowing a conflicting transaction to be committed in the case 
where more than one 32KB shared-memory page has been written to since the
transaction was started.

FossilOrigin-Name: 38dd9b50fe260d853cbc2551bc1bb60ddf5752f0456e0da3afe4cbf728c891d8
 2017-08-11 21:16:23 +00:00
drh
0a2afca904 Fix compiler warnings. 
FossilOrigin-Name: 44c760d150b494ddd88382360cfcc4734fec936ed620f88b9df33ea7215c2fc2
 2017-07-20 19:08:35 +00:00
dan
995b2457e2 Instead of a root page number, log the object (table or index) name if a page 
level locking conflict is detected.

FossilOrigin-Name: 9ad846e57bd427adc7c29768cabca18905f7f978168e0642a5917d894fda8bfd
 2017-05-29 19:23:56 +00:00
dan
7fff2e1cb9 Enhance the log messages emitted when a page conflict is detected. 
FossilOrigin-Name: 92618492b048867af38922825f3d094eaaa2dd919b1ed2f7372483cc53f892bf
 2017-05-29 14:27:37 +00:00
dan
aa59505ae8 Add experimental new API sqlite3_wal_info(). 
FossilOrigin-Name: 5b9d498f6e9de6ee2ab86370c02c28a2a8b83d717b96d23b1fc52107677e45a2
 2017-05-23 19:23:45 +00:00
dan
e32c7c2b64 Upgrade this branch to 3.16 plus the various fixes that appeared after its 
release.

FossilOrigin-Name: d0e212d08f82dfb5e42a156b3e2bb03dd8e21258
 2017-01-09 06:33:50 +00:00
drh
bc88711d08 Enclose the sqlite3WalSnapshotRecover() routine within 
FossilOrigin-Name: e7be3183eb25e0f9f04b9e251ff37fa5e50cc1a7
 2016-11-22 21:11:59 +00:00
dan
93f5113290 Remove the requirement to open the wal file before sqlite3_snapshot_recover() 
is called. Also add some comments to new functions.

FossilOrigin-Name: 28393c413cc4505b94411730e728583c5d4baaae
 2016-11-19 18:31:37 +00:00
dan
6a9e7f16eb Fix a problem causing sqlite3_snapshot_recover() to return 
SQLITE_IOERR_SHORT_READ.

FossilOrigin-Name: 525f75fa9fd4a95acc3fb3b0a01dabe2be39b383
 2016-11-19 16:35:53 +00:00
dan
5b4009f637 Fix a bug in sqlite3_snapshot_recover() that could cause subsequent read 
transactions to use out-of-data cache entries.

FossilOrigin-Name: 9abeb7980a34cec11a3420e14ad98a4ec0d9c599
 2016-11-19 14:53:22 +00:00
dan
1158498dce Add experimental sqlite3_snapshot_recover() API. 
FossilOrigin-Name: 174a6076a8d7bebe5efebf55f3fdc5d87c589cc7
 2016-11-18 20:49:43 +00:00
drh
ba6eb8769f Experimental changes toward making snapshots serializable. 
FossilOrigin-Name: b6a81fa1fc1fb78a65894129851a4ec3986640de
 2016-11-15 17:37:56 +00:00
dan
4a5bad572a Fix a problem with switching from wal to rollback mode when 
SQLITE_DBCONFIG_NO_CKPT_ON_CLOSE is configured.

FossilOrigin-Name: 46e0016207b8e7df2ae6c7491fd0f3c2926eed21
 2016-11-11 17:08:51 +00:00
dan
298af02308 Add the SQLITE_DBCONFIG_NO_CKPT_ON_CLOSE sqlite3_dbconfig() option - for 
disabling SQLite's default checkpoint-on-close behaviour.

FossilOrigin-Name: 093d2fc2288b75c15ccf877bfa0e622d3918a562
 2016-10-31 16:16:49 +00:00
dan
7fb8990688 Have wal file checkpoints exit early if the sqlite3_interrupt() API function is called. 
FossilOrigin-Name: 8a5f41c7b1718507524adef1a2730e99cf53270a
 2016-08-12 16:21:15 +00:00
drh
3d4ad18cbe Merge version 3.14 plus some subsequent patches (including the page-cache 
performance patch) from trunk.

FossilOrigin-Name: d9f8918c5b7b6c8540b3f433142e1b4aa4433885
 2016-08-11 19:12:25 +00:00
dan
fe912510ea Fix an obscure problem with transactions written in "PRAGMA synchronous=full" mode on systems that do not support POWERSAFE_OVERWRITE causing an xSync() call to be omitted if the last frame written by a transaction is aligned to a sector boundary. This means that if a power failure or OS crash occurs very soon after such a transaction is committed, it may be lost following system recovery. 
FossilOrigin-Name: 37de3eab67f12ae1ce5bc8d5e541c64fc6b1fd80
 2016-05-24 16:20:51 +00:00
drh
76cb74da4d Merge all recent enhancements from trunk. 
FossilOrigin-Name: 1f709fbf931e4d75848fc90532e2bc67ccd47cd4
 2016-04-20 12:16:05 +00:00
dan
ad2d5baf1f Add the sqlite3_snapshot_cmp() API. 
FossilOrigin-Name: c698a21af740ca1019c3a771fb83e569cd6bf23e
 2016-04-11 19:59:52 +00:00
drh
03206c433c Merge the latest enhancements from trunk. 
FossilOrigin-Name: a7978ab6d26b865f55c6b3e86ba3a24777a3c1f0
 2016-03-16 19:34:45 +00:00
drh
32c49904a6 Add the SQLITE_NOMEM_BKPT macro to enhance the ability to debug OOM errors. 
Only effective with compiling with SQLITE_DEBUG.

FossilOrigin-Name: 9b3454762d142113f5923d754ca6bd2edefbd362
 2016-02-15 18:15:15 +00:00
drh
93f88ebbb1 Merge version 3.11.0 
FossilOrigin-Name: c393ddc71a041a711f8eaa6fbd75371309df5602
 2016-02-15 17:44:45 +00:00
drh
8e0cea1a5d Make sure the codec is invoked when overwriting existing frames of the 
WAL file.  Yikes!

FossilOrigin-Name: f694e60a79024967a3f4574e3928f0b28589d381
 2016-02-15 15:06:47 +00:00
mistachkin
fad3039c51 Enhance ability to debug out-of-memory errors. 
FossilOrigin-Name: 6a9c4a3ebfb7cc0738ef6634440ccab44a21ff28
 2016-02-13 23:43:46 +00:00
dan
f687ba597f Merge the latest enhancements and fixes from trunk. 
FossilOrigin-Name: fccc5f20c360fa17c3692a9f1fc1d16612632a7f
 2016-01-14 15:46:31 +00:00
drh
31a2313fa8 Add the SQLITE_FCNTL_JOURNAL_POINTER file control. 
FossilOrigin-Name: ad3daa5427672d2d236939ad3285b765f4601801
 2016-01-13 18:12:44 +00:00
drh
869aaf0941 Make sure all bytes of the WAL file are initialized even if the checksums are 
not being computed until commit due to WAL overwrite.

FossilOrigin-Name: 1f44a9bdc1577aed088d9b91882527228015dcd3
 2016-01-12 02:28:19 +00:00
drh
8997087a00 Improved testability. 
FossilOrigin-Name: e83d3a2a4e06665e8a056f63063bd6df03f063b9
 2016-01-11 00:52:32 +00:00