/ All files named "ext/rbu/sqlite3rbu.c"
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

History for ext/rbu/sqlite3rbu.c

2020-07-29
16:18
[660e5048] part of check-in [a80ae2c9] Dozens and dozens of typo fixes in comments. This change adds no value to the end product and is disruptive, so it is questionable whether or not it will ever land on trunk. (check-in: [a80ae2c9] user: drh branch: typos, size: 170557)
2020-06-19
15:24
[05c457c2] part of check-in [7a876209] Extend the refactoring into extensions. Clean up stray newlines. (check-in: [7a876209] user: drh branch: trunk, size: 170556)
2020-01-11
16:08
[77a47f32] part of check-in [bcb43d11] Redesign for better legacy compatibility. Add the sqlite3_uri_key() interface. (check-in: [bcb43d11] user: drh branch: enhanced-uri, size: 170556)
2019-12-20
20:03
[4e9a59aa] part of check-in [0b9d8a12] Fix a bad interaction between RBU and [df51ae19]. (check-in: [0b9d8a12] user: dan branch: trunk, size: 171265)
2019-08-13
15:11
[f3a3e09f] part of check-in [8c44b02f] Fix a problem with RBU function sqlite3rbu_bp_progress() when used during an RBU vacuum. (check-in: [8c44b02f] user: dan branch: trunk, size: 171265)
2019-08-09
01:11
[4261ba8d] part of check-in [1b85442b] Fix more compiler warnings. (check-in: [1b85442b] user: drh branch: trunk, size: 171200)
2019-07-26
20:33
[b254d13a] part of check-in [6bfa44da] Update RBU so that it supports indexes on expressions. (check-in: [6bfa44da] user: dan branch: trunk, size: 171196)
16:16
[38c57eca] part of check-in [e1ccf211] Fix RBU handling of partial indexes with comments embedded in their CREATE INDEX statements. (check-in: [e1ccf211] user: dan branch: trunk, size: 169408)
2019-05-10
20:44
[8741c0ee] part of check-in [a194e536] Add tests for the RBU module. (check-in: [a194e536] user: dan branch: trunk, size: 169088)
2019-05-08
21:14
[311fe2c2] part of check-in [30392985] Add another test case to cover a previously uncovered branch in the RBU module. (check-in: [30392985] user: dan branch: trunk, size: 169110)
18:49
[65794a32] part of check-in [ecb56b75] Add tests to improve code coverage of the RBU module. (check-in: [ecb56b75] user: dan branch: trunk, size: 169096)
2019-05-07
16:28
[ec93d28c] part of check-in [7b051698] Remove some redundant code from sqlite3rbu.c. Add test cases for RBU vacuum. (check-in: [7b051698] user: dan branch: rbu-opt, size: 169262)
2019-05-06
20:40
[e2669fb2] part of check-in [6b3261bf] Optimize further cases of restarting an RBU vacuum. (check-in: [6b3261bf] user: dan branch: rbu-opt, size: 167256)
2019-05-04
20:04
[03d4acab] part of check-in [cdc09867] Optimize some cases of restarting an RBU vacuum. (check-in: [cdc09867] user: dan branch: rbu-opt, size: 164356)
2019-04-13
14:07
[f222350c] part of check-in [c28c973a] Fixes for harmless compiler warnings. (check-in: [c28c973a] user: drh branch: trunk, size: 161263)
2019-04-11
16:54
[3f21eda2] part of check-in [31eb27f4] Fix RBU so that it does not write rows that should be excluded into partial indexes (corrupting the database). (check-in: [31eb27f4] user: dan branch: trunk, size: 161208)
2019-02-19
17:45
[d0627582] part of check-in [12517d1b] Fix a potential memory leak in RBU if the rbu_fossil_delta() SQL function is misused. Misuse never happens in a working RBU system, so this is not a particularly important fix. (check-in: [12517d1b] user: drh branch: trunk, size: 159182)
2019-01-03
15:17
[d643661c] part of check-in [bef216df] Fix a problem with the second and subsequent sqlite3rbu_savestate() calls made on an RBU vacuum handle. (check-in: [bef216df] user: dan branch: trunk, size: 159156)
2018-12-10
08:41
[f722ed41] part of check-in [c878d741] Fix a problem with using "<db>-vacuum" (the default) as the state database when resuming an RBU vacuum. (check-in: [c878d741] user: dan branch: trunk, size: 159080)
2018-10-25
11:55
[4eea9238] part of check-in [fda8fdb0] Speed up xAccess() calls made on an RBU VFS when there are lots of open connections. Cherrypick of [310b4b65]. (check-in: [fda8fdb0] user: dan branch: branch-3.22, size: 158434)
2018-10-01
17:33
[71f8c099] part of check-in [310b4b65] Speed up xAccess() calls made on an RBU VFS when there are lots of open connections. (check-in: [310b4b65] user: dan branch: trunk, size: 158938)
2018-04-28
18:20
[f438fea8] part of check-in [564ae829] Fix an RBU problem causing spurious SQLITE_CONSTRAINT errors when restarting an RBU update in which more than one source table writes to a single target database table. (check-in: [564ae829] user: dan branch: trunk, size: 157386)
2018-03-22
17:13
[f6e9ca38] part of check-in [eb4f452e] Fix an RBU problem causing errors when updating tables with default collation sequences that require quoting (e.g. COLLATE "ICU_root-u-kn-on"). (check-in: [eb4f452e] user: dan branch: trunk, size: 156882)
2017-10-05
11:29
[64bd08c1] part of check-in [d22c99b6] Disable the delta checksum verification in RBU by default. Reenable it using -DRBU_ENABLE_DELTA_CKSUM, if desired. (check-in: [d22c99b6] user: drh branch: trunk, size: 156882)
2017-09-05
16:24
[a1a303de] part of check-in [7fdd6298] Add experimental API sqlite3rbu_temp_size_limit(). For limiting the amount of temporary disk space RBU uses. (check-in: [7fdd6298] user: dan branch: trunk, size: 156677)
2017-08-03
15:43
[920941a6] part of check-in [7676b39b] Fix some problems in RBU test cases. Also update RBU source code to better handle the trivial case where an RBU update is applied to a database zero pages in size. (check-in: [7676b39b] user: dan branch: trunk, size: 154767)
2017-06-13
16:52
[d1438580] part of check-in [c433672d] Fix sqlite3rbu_close() so that the pzErrmsg parameter may be passed NULL. (check-in: [c433672d] user: dan branch: trunk, size: 154686)
2017-03-03
16:51
[2a89efba] part of check-in [915a9a28] Before beginning an incremental checkpoint in RBU, sync the directory containing the target database file. This ensures that the new directory entry created by renaming the *-oal file to *-wal is synced to disk. (check-in: [915a9a28] user: dan branch: trunk, size: 154615)
2017-03-02
16:56
[cba23db3] part of check-in [4012bb3a] Fix another RBU case similar to the previous. This one for systems where the sector-size is larger than the page-size. (check-in: [4012bb3a] user: dan branch: trunk, size: 154252)
14:51
[3c2dfd3f] part of check-in [edee6a80] When saving the state of an RBU update in the incremental-checkpoint phase, sync the database file. Otherwise, if a power failure occurs and the RBU update resumed following system recovery, the database may become corrupt. (check-in: [edee6a80] user: dan branch: trunk, size: 152890)
2017-01-17
10:41
[bb0de6cd] part of check-in [681d96eb] Fix a problem that could cause a spurious SQLITE_NOMEM error when attempting to resume an RBU operation if the previous client failed right after completing the incremental checkpoint. Also a "cannot vacuum wal db" error that could occur when resuming an RBU vacuum if an error (OOM or IO error) occurs during the incremental checkpoint. (check-in: [681d96eb] user: dan branch: trunk, size: 152463)
2017-01-13
18:24
[4ca89fbe] part of check-in [97914266] Fix a problem preventing resumption of RBU operations after recovering from a process or system failure that occurs during the incremental-checkpoint phase. (check-in: [97914266] user: dan branch: trunk, size: 151612)
2016-08-11
18:05
[e074c387] part of check-in [ed406d31] Add the "modeof=<filename>" URI parameter to os_unix.c - used to specify a file to copy permissions from when a new database is created. Also allow passing NULL as the second parameter to sqlite3rbu_vacuum(). (check-in: [ed406d31] user: dan branch: trunk, size: 151611)
2016-07-01
12:39
[948677ee] part of check-in [92e7df0f] Add the sqlite3rbu_state() API. Used to determine the current state (creating OAL, ready to move OAL, incremental-checkpoint, finished or error) of an RBU operation. (check-in: [92e7df0f] user: dan branch: rbu-state-api, size: 151052)
2016-06-13
19:58
[3d35b1dc] part of check-in [0230ca17] Fix RBU so that it builds with -DSQLITE_ENABLE_8_3_NAMES. Fix "PRAGMA compile_options" for SQLITE_ENABLE_8_3_NAMES such that it reports the numeric setting: "1" or "2". (check-in: [0230ca17] user: drh branch: trunk, size: 150022)
2016-06-01
10:37
[a37a7dfb] part of check-in [3bd85fa5] Fix an issue preventing RBU vacuum from working with virtual tables. (check-in: [3bd85fa5] user: dan branch: trunk, size: 150025)
2016-04-25
19:25
[bf366259] part of check-in [7dd48c10] Update the RBU vacuum code so that databases that use custom collation sequences can be vacuumed. (check-in: [7dd48c10] user: dan branch: trunk, size: 149920)
2016-04-21
16:44
[20922328] part of check-in [6e4ac704] If a call to sqlite3rbu_close() on an rbu handle opened by sqlite3rbu_vacuum() returns other than SQLITE_OK, delete the contents of the rbu_state table. This ensures that if an RBU vacuum operation either completes successfully or encounters an error, the next call to sqlite3rbu_vacuum() with the same parameters starts a new RBU vacuum operation. (check-in: [6e4ac704] user: dan branch: rbu-vacuum, size: 149921)
15:26
[8310553b] part of check-in [23eac52e] Fix a problem in rbu vacuum on tables with a large sqlite_master table. (check-in: [23eac52e] user: dan branch: rbu-vacuum, size: 149394)
2016-04-20
20:08
[80ab6865] part of check-in [da5c753d] Add a documentation comment for sqlite3rbu_vacuum() to sqlite3rbu.h. (check-in: [da5c753d] user: dan branch: rbu-vacuum, size: 149397)
17:47
[cc44505e] part of check-in [f042fdd1] Add fault injection tests for rbu vacuum. Fix some problems revealed by the same. (check-in: [f042fdd1] user: dan branch: rbu-vacuum, size: 148546)
2016-04-19
19:27
[a6c02a67] part of check-in [74ffea76] Updates to ensure the values of PRAGMA settings like "page_size", "auto_vacuum", "user_version" and "application_id" are not lost when a database is RBU vacuumed. (check-in: [74ffea76] user: dan branch: rbu-vacuum, size: 148280)
17:11
[0447a8a3] part of check-in [ca021ba8] When an RBU vacuum is started on a db identified using a URI filename, pass the same URI parameters when creating the new version of the db. This ensures that RBU vacuum works with password protected databases. (check-in: [ca021ba8] user: dan branch: rbu-vacuum, size: 146847)
16:20
[d269d60b] part of check-in [00b2f4b0] Detect attempts to use rbu vacuum on a wal mode database (not allowed). And attempts to write to a database in the middle of an rbu vacuum (which prevents the vacuum from resuming). (check-in: [00b2f4b0] user: dan branch: rbu-vacuum, size: 146475)
2016-04-18
21:00
[ac4621fc] part of check-in [29407d70] Another fix to rbu vacuum for a zipvfs case. (check-in: [29407d70] user: dan branch: rbu-vacuum, size: 146254)
18:18
[372ed3aa] part of check-in [d76f4aaa] Fix some zipvfs related problems in RBU vacuum. (check-in: [d76f4aaa] user: dan branch: rbu-vacuum, size: 146082)
2016-04-16
19:02
[721c6c11] part of check-in [bae7f875] Changes so that rbu vacuum works with zipvfs databases. (check-in: [bae7f875] user: dan branch: rbu-vacuum, size: 144333)
17:53
[471b4055] part of check-in [dc19aacc] Avoid creating any extra files ("<target>-vacuum") when running an RBU vacuum. Ensure that the OAL file created is "<target>-oal", not "<target>-vacuum-oal". (check-in: [dc19aacc] user: dan branch: rbu-vacuum, size: 144341)
2016-04-15
20:46
[79b8be4a] part of check-in [0216b48f] Add the experimental sqlite3rbu_vacuum() API function. For opening an RBU handle that rebuilds a database from scratch. (check-in: [0216b48f] user: dan branch: rbu-vacuum, size: 144262)
2016-04-12
20:05
[9097f1d9] part of check-in [ab69527c] More harmless compiler warning fixes. (check-in: [ab69527c] user: mistachkin branch: warnings, size: 137526)
2016-03-19
17:09
[007fc4db] part of check-in [a1132dd9] Fix a problem detecting invalid values in the rbu_control column of an rbu database table. (check-in: [a1132dd9] user: dan branch: rbu-percent-progress, size: 137517)
2016-03-18
20:12
[edeb8f90] part of check-in [65e02368] Add further tests for sqlite3rbu_bp_progress(). Fix a problem in handling WITHOUT ROWID tables in the same. (check-in: [65e02368] user: dan branch: rbu-percent-progress, size: 137490)
18:56
[6b7dc899] part of check-in [1a1b69e8] Change the name of the new API on this branch to "sqlite3_bp_progress". Add tests and documentation for the same. (check-in: [1a1b69e8] user: dan branch: rbu-percent-progress, size: 137215)
10:29
[c89f1e59] part of check-in [bf823217] Add tests for the changes on this branch. Fix a problem with calls to the new progress indicator API made after an rbu update has been resumed. (check-in: [bf823217] user: dan branch: rbu-percent-progress, size: 135262)
2016-03-17
21:06
[9bcf35b2] part of check-in [ffc58d2c] Add an API to indicate the percentage progress of an rbu update. (check-in: [ffc58d2c] user: dan branch: rbu-percent-progress, size: 135210)
2016-03-08
16:02
[5956f8be] part of check-in [2179a106] Remove an unused goto label in the RBU extension. (check-in: [2179a106] user: drh branch: trunk, size: 130640)
2016-03-07
17:39
[0d901d77] part of check-in [169311c8] Add a new row type to RBU (a peer of insert, update and delete) - "delete then insert". (check-in: [169311c8] user: dan branch: rbu-delete-then-insert, size: 130652)
2016-02-19
15:17
[371e8bf0] part of check-in [a1a3ff1f] Fix a couple of harmless warnings generated by clang. (check-in: [a1a3ff1f] user: drh branch: trunk, size: 130163)
2016-01-14
13:22
[bea95419] part of check-in [fabe78c5] Fix harmless compiler warnings in RBU and add RBU to the autoconf and windows makefiles. (check-in: [fabe78c5] user: drh branch: trunk, size: 130162)
2015-10-08
17:35
[ea47de61] part of check-in [df9ef61f] In the RBU extension, use MoveFile() instead of rename() on Windows CE. (check-in: [df9ef61f] user: mistachkin branch: trunk, size: 130086)
2015-08-28
16:41
[4ba82bd8] part of check-in [0fdc36fe] Fix compiler warnings in rbu code. (check-in: [0fdc36fe] user: dan branch: trunk, size: 128815)
2015-08-19
08:34
[1650e682] part of check-in [dec14a39] When updating a zipvfs database with RBU, set journal_mode=off to prevent the upper-level pager from creating a large temporary file. (check-in: [dec14a39] user: dan branch: trunk, size: 128732)
2015-08-13
18:26
[08fddeae] part of check-in [851a875a] Add the sqlite3rbu_savestate() function to the rbu extension. To force rbu to save its state to disk without closing the sqlite3rbu* handle. (check-in: [851a875a] user: dan branch: trunk, size: 128250)
11:46
[e2ebcebf] part of check-in [ee966af8] Avoid invoking system call unlink() directly from RBU code. Use the xDelete method of the default VFS instead. (check-in: [ee966af8] user: dan branch: trunk, size: 127542)
2015-08-08
22:47
[07cef198] part of check-in [be190fe7] Fix compiler warnings and remove unreachable code. (check-in: [be190fe7] user: drh branch: warnings, size: 127502)
15:13
[df8658bc] part of check-in [1d75a41b] Update RBU to avoid repreparing a statement immediately after it is prepared. (check-in: [1d75a41b] user: dan branch: trunk, size: 127506)
2015-07-31
19:52
[ffabbb80] part of check-in [e26ef165] Add support for "fossil deltas" to RBU and "sqldiff --rbu". (check-in: [e26ef165] user: dan branch: trunk, size: 127506)
2015-07-30
11:38
[75409b33] part of check-in [287aa306] Allow RBU tables to be named "data[0-9]*_<target>" instead of strictly "data_<target>". Also update RBU so that it always processes data tables in order sorted by name. (check-in: [287aa306] user: dan branch: trunk, size: 120004)
2015-07-24
21:19
[dbd7e4b3] part of check-in [cca79fdc] Enable the RBU extension to compile cleanly on Windows using MSVC. (check-in: [cca79fdc] user: mistachkin branch: trunk, size: 118666)
18:58
[7a0ca8fc] part of check-in [45c6a760] Allow the RBU module to read data from appropriately named SQL views created within the RBU database. (check-in: [45c6a760] user: dan branch: trunk, size: 118611)
2015-07-23
20:44
Renamed ext/ota/sqlite3ota.c → ext/rbu/sqlite3rbu.c. [d37e1ca2] part of check-in [017c5019] Change the name of the OTA extension to RBU: Resumable Bulk Update. (check-in: [017c5019] user: drh branch: trunk, size: 118598)