/ File History
Login

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

History of ext/rbu/sqlite3rbu.c

2019-05-10
20:44
Add tests for the RBU module. file: [8741c0ee] check-in: [a194e536] user: dan branch: trunk, size: 169088
2019-05-08
21:14
Add another test case to cover a previously uncovered branch in the RBU module. file: [311fe2c2] check-in: [30392985] user: dan branch: trunk, size: 169110
18:49
Add tests to improve code coverage of the RBU module. file: [65794a32] check-in: [ecb56b75] user: dan branch: trunk, size: 169096
2019-05-07
16:28
Remove some redundant code from sqlite3rbu.c. Add test cases for RBU vacuum. file: [ec93d28c] check-in: [7b051698] user: dan branch: rbu-opt, size: 169262
2019-05-06
20:40
Optimize further cases of restarting an RBU vacuum. file: [e2669fb2] check-in: [6b3261bf] user: dan branch: rbu-opt, size: 167256
2019-05-04
20:04
Optimize some cases of restarting an RBU vacuum. file: [03d4acab] check-in: [cdc09867] user: dan branch: rbu-opt, size: 164356
2019-04-13
14:07
Fixes for harmless compiler warnings. file: [f222350c] check-in: [c28c973a] user: drh branch: trunk, size: 161263
2019-04-11
16:54
Fix RBU so that it does not write rows that should be excluded into partial indexes (corrupting the database). file: [3f21eda2] check-in: [31eb27f4] user: dan branch: trunk, size: 161208
2019-02-19
17:45
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. file: [d0627582] check-in: [12517d1b] user: drh branch: trunk, size: 159182
2019-01-03
15:17
Fix a problem with the second and subsequent sqlite3rbu_savestate() calls made on an RBU vacuum handle. file: [d643661c] check-in: [bef216df] user: dan branch: trunk, size: 159156
2018-12-10
08:41
Fix a problem with using "<db>-vacuum" (the default) as the state database when resuming an RBU vacuum. file: [f722ed41] check-in: [c878d741] user: dan branch: trunk, size: 159080
2018-10-25
11:55
Speed up xAccess() calls made on an RBU VFS when there are lots of open connections. Cherrypick of [310b4b65]. file: [4eea9238] check-in: [fda8fdb0] user: dan branch: branch-3.22, size: 158434
2018-10-01
17:33
Speed up xAccess() calls made on an RBU VFS when there are lots of open connections. file: [71f8c099] check-in: [310b4b65] user: dan branch: trunk, size: 158938
2018-04-28
18:20
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. file: [f438fea8] check-in: [564ae829] user: dan branch: trunk, size: 157386
2018-03-22
17:13
Fix an RBU problem causing errors when updating tables with default collation sequences that require quoting (e.g. COLLATE "ICU_root-u-kn-on"). file: [f6e9ca38] check-in: [eb4f452e] user: dan branch: trunk, size: 156882
2017-10-05
11:29
Disable the delta checksum verification in RBU by default. Reenable it using -DRBU_ENABLE_DELTA_CKSUM, if desired. file: [64bd08c1] check-in: [d22c99b6] user: drh branch: trunk, size: 156882
2017-09-05
16:24
Add experimental API sqlite3rbu_temp_size_limit(). For limiting the amount of temporary disk space RBU uses. file: [a1a303de] check-in: [7fdd6298] user: dan branch: trunk, size: 156677
2017-08-03
15:43
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. file: [920941a6] check-in: [7676b39b] user: dan branch: trunk, size: 154767
2017-06-13
16:52
Fix sqlite3rbu_close() so that the pzErrmsg parameter may be passed NULL. file: [d1438580] check-in: [c433672d] user: dan branch: trunk, size: 154686
2017-03-03
16:51
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. file: [2a89efba] check-in: [915a9a28] user: dan branch: trunk, size: 154615
2017-03-02
16:56
Fix another RBU case similar to the previous. This one for systems where the sector-size is larger than the page-size. file: [cba23db3] check-in: [4012bb3a] user: dan branch: trunk, size: 154252
14:51
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. file: [3c2dfd3f] check-in: [edee6a80] user: dan branch: trunk, size: 152890
2017-01-17
10:41
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. file: [bb0de6cd] check-in: [681d96eb] user: dan branch: trunk, size: 152463
2017-01-13
18:24
Fix a problem preventing resumption of RBU operations after recovering from a process or system failure that occurs during the incremental-checkpoint phase. file: [4ca89fbe] check-in: [97914266] user: dan branch: trunk, size: 151612
2016-08-11
18:05
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(). file: [e074c387] check-in: [ed406d31] user: dan branch: trunk, size: 151611
2016-07-01
12:39
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. file: [948677ee] check-in: [92e7df0f] user: dan branch: rbu-state-api, size: 151052
2016-06-13
19:58
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". file: [3d35b1dc] check-in: [0230ca17] user: drh branch: trunk, size: 150022
2016-06-01
10:37
Fix an issue preventing RBU vacuum from working with virtual tables. file: [a37a7dfb] check-in: [3bd85fa5] user: dan branch: trunk, size: 150025
2016-04-25
19:25
Update the RBU vacuum code so that databases that use custom collation sequences can be vacuumed. file: [bf366259] check-in: [7dd48c10] user: dan branch: trunk, size: 149920
2016-04-21
16:44
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. file: [20922328] check-in: [6e4ac704] user: dan branch: rbu-vacuum, size: 149921
15:26
Fix a problem in rbu vacuum on tables with a large sqlite_master table. file: [8310553b] check-in: [23eac52e] user: dan branch: rbu-vacuum, size: 149394
2016-04-20
20:08
Add a documentation comment for sqlite3rbu_vacuum() to sqlite3rbu.h. file: [80ab6865] check-in: [da5c753d] user: dan branch: rbu-vacuum, size: 149397
17:47
Add fault injection tests for rbu vacuum. Fix some problems revealed by the same. file: [cc44505e] check-in: [f042fdd1] user: dan branch: rbu-vacuum, size: 148546
2016-04-19
19:27
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. file: [a6c02a67] check-in: [74ffea76] user: dan branch: rbu-vacuum, size: 148280
17:11
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. file: [0447a8a3] check-in: [ca021ba8] user: dan branch: rbu-vacuum, size: 146847
16:20
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). file: [d269d60b] check-in: [00b2f4b0] user: dan branch: rbu-vacuum, size: 146475
2016-04-18
21:00
Another fix to rbu vacuum for a zipvfs case. file: [ac4621fc] check-in: [29407d70] user: dan branch: rbu-vacuum, size: 146254
18:18
Fix some zipvfs related problems in RBU vacuum. file: [372ed3aa] check-in: [d76f4aaa] user: dan branch: rbu-vacuum, size: 146082
2016-04-16
19:02
Changes so that rbu vacuum works with zipvfs databases. file: [721c6c11] check-in: [bae7f875] user: dan branch: rbu-vacuum, size: 144333
17:53
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". file: [471b4055] check-in: [dc19aacc] user: dan branch: rbu-vacuum, size: 144341
2016-04-15
20:46
Add the experimental sqlite3rbu_vacuum() API function. For opening an RBU handle that rebuilds a database from scratch. file: [79b8be4a] check-in: [0216b48f] user: dan branch: rbu-vacuum, size: 144262
2016-04-12
20:05
More harmless compiler warning fixes. file: [9097f1d9] check-in: [ab69527c] user: mistachkin branch: warnings, size: 137526
2016-03-19
17:09
Fix a problem detecting invalid values in the rbu_control column of an rbu database table. file: [007fc4db] check-in: [a1132dd9] user: dan branch: rbu-percent-progress, size: 137517
2016-03-18
20:12
Add further tests for sqlite3rbu_bp_progress(). Fix a problem in handling WITHOUT ROWID tables in the same. file: [edeb8f90] check-in: [65e02368] user: dan branch: rbu-percent-progress, size: 137490
18:56
Change the name of the new API on this branch to "sqlite3_bp_progress". Add tests and documentation for the same. file: [6b7dc899] check-in: [1a1b69e8] user: dan branch: rbu-percent-progress, size: 137215
10:29
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. file: [c89f1e59] check-in: [bf823217] user: dan branch: rbu-percent-progress, size: 135262
2016-03-17
21:06
Add an API to indicate the percentage progress of an rbu update. file: [9bcf35b2] check-in: [ffc58d2c] user: dan branch: rbu-percent-progress, size: 135210
2016-03-08
16:02
Remove an unused goto label in the RBU extension. file: [5956f8be] check-in: [2179a106] user: drh branch: trunk, size: 130640
2016-03-07
17:39
Add a new row type to RBU (a peer of insert, update and delete) - "delete then insert". file: [0d901d77] check-in: [169311c8] user: dan branch: rbu-delete-then-insert, size: 130652
2016-02-19
15:17
Fix a couple of harmless warnings generated by clang. file: [371e8bf0] check-in: [a1a3ff1f] user: drh branch: trunk, size: 130163
2016-01-14
13:22
Fix harmless compiler warnings in RBU and add RBU to the autoconf and windows makefiles. file: [bea95419] check-in: [fabe78c5] user: drh branch: trunk, size: 130162
2015-10-08
17:35
In the RBU extension, use MoveFile() instead of rename() on Windows CE. file: [ea47de61] check-in: [df9ef61f] user: mistachkin branch: trunk, size: 130086
2015-08-28
16:41
Fix compiler warnings in rbu code. file: [4ba82bd8] check-in: [0fdc36fe] user: dan branch: trunk, size: 128815
2015-08-19
08:34
When updating a zipvfs database with RBU, set journal_mode=off to prevent the upper-level pager from creating a large temporary file. file: [1650e682] check-in: [dec14a39] user: dan branch: trunk, size: 128732
2015-08-13
18:26
Add the sqlite3rbu_savestate() function to the rbu extension. To force rbu to save its state to disk without closing the sqlite3rbu* handle. file: [08fddeae] check-in: [851a875a] user: dan branch: trunk, size: 128250
11:46
Avoid invoking system call unlink() directly from RBU code. Use the xDelete method of the default VFS instead. file: [e2ebcebf] check-in: [ee966af8] user: dan branch: trunk, size: 127542
2015-08-08
22:47
Fix compiler warnings and remove unreachable code. file: [07cef198] check-in: [be190fe7] user: drh branch: warnings, size: 127502
15:13
Update RBU to avoid repreparing a statement immediately after it is prepared. file: [df8658bc] check-in: [1d75a41b] user: dan branch: trunk, size: 127506
2015-07-31
19:52
Add support for "fossil deltas" to RBU and "sqldiff --rbu". file: [ffabbb80] check-in: [e26ef165] user: dan branch: trunk, size: 127506
2015-07-30
11:38
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. file: [75409b33] check-in: [287aa306] user: dan branch: trunk, size: 120004
2015-07-24
21:19
Enable the RBU extension to compile cleanly on Windows using MSVC. file: [dbd7e4b3] check-in: [cca79fdc] user: mistachkin branch: trunk, size: 118666
18:58
Allow the RBU module to read data from appropriately named SQL views created within the RBU database. file: [7a0ca8fc] check-in: [45c6a760] user: dan branch: trunk, size: 118611
2015-07-23
20:44
Change the name of the OTA extension to RBU: Resumable Bulk Update. file: [d37e1ca2] check-in: [017c5019] user: drh branch: trunk, size: 118598 Renamed from ext/ota/sqlite3ota.c