Skip to content

Instantly share code, notes, and snippets.

@lightandshadow68
Created October 28, 2014 18:31
Show Gist options
  • Save lightandshadow68/c7dd2ebacef2d00adff9 to your computer and use it in GitHub Desktop.
Save lightandshadow68/c7dd2ebacef2d00adff9 to your computer and use it in GitHub Desktop.
<CBL_FMDatabase: 0x7fd8b2c26880> executeQuery: SELECT sequence, revid, deleted FROM revs WHERE doc_id=? AND current ORDER BY sequence DESC
obj: 5887
>>>>>>>>>>>>>>>>>>>>>>>>> 7 total Conflicts for: f8ee7974-9558-4ba4-ba94-6a7ce98c58b4
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: SAVEPOINT cbl_1
14:15:00.826| CBLDatabase: Begin transaction (level 1)...
14:15:00.826| CBLDatabase: PUT rev={f8ee7974-9558-4ba4-ba94-6a7ce98c58b4 #(null) DEL}, prevRevID=114-b119801ccce39c63560dd7a3576a38ea, allowConflict=0
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: SAVEPOINT cbl_2
14:15:00.827| CBLDatabase: Begin transaction (level 2)...
<CBL_FMDatabase: 0x7fd8b2c26880> executeQuery: SELECT revid, deleted FROM revs WHERE doc_id=? and current=1 ORDER BY deleted asc, revid desc LIMIT 2
obj: 5887
<CBL_FMDatabase: 0x7fd8b2c26880> executeQuery: SELECT sequence FROM revs WHERE doc_id=? AND revid=? AND current=1 LIMIT 1
obj: 5887
obj: 114-b119801ccce39c63560dd7a3576a38ea
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: INSERT INTO revs (doc_id, revid, parent, current, deleted, no_attachments, json) VALUES (?, ?, ?, ?, ?, ?, ?)
obj: 5887
obj: 115-698c1511ee8c77131b082613d29c6e3c
obj: 29560
obj: 1
obj: 1
obj: 1
obj: <7b226173 7369676e 6564546f 223a2263 39316161 6264332d 64376536 2d343635 642d6164 63392d32 36303636 30346335 65653222 2c226261 7365223a 22746173 6b222c22 636f6d70 6c657469 6f6e5065 7263656e 74223a31 30302c22 63726561 74656441 74223a22 32303134 2d30342d 30335432 303a3437 3a30352b 30303a30 30222c22 63726561 74656442 79223a22 63393161 61626433 2d643765 362d3436 35642d61 6463392d 32363036 36303463 35656532 222c2264 75654461 7465223a 22323031 342d3034 2d303454 30333a35 393a3539 2b30303a 3030222c 22696422 3a226638 65653739 37342d39 3535382d 34626134 2d626139 342d3661 37636539 38633538 6234222c 22696e69 7469616c 5461736b 223a2263 39373931 3465612d 39636134 2d343936 652d6134 32372d62 39323636 63653530 39386622 2c226973 456d6572 67656e63 79223a74 7275652c 226c6f63 6174696f 6e223a22 68696c74 6f6e5f61 6e61746f 6c65222c 226c6f63 6174696f 6e526f6f 74223a22 68696c74 6f6e5f61 6e61746f 6c65222c 226d6172 6b657222 3a7b2267 656f6d65 74727922 3a7b2263 6f6f7264 696e6174 6573223a 5b33322e 38303034 30313537 34313036 35392c2d 39362e38 32373731 38363135 35333139 325d2c22 74797065 223a2250 6f696e74 227d2c22 74797065 223a2246 65617475 7265227d 2c226f62 6a656374 6976654d 65746122 3a7b7d2c 226f626a 65637469 76655465 7874223a 224d6169 6e204669 72652054 61736b22 2c227061 72656e74 223a6e75 6c6c2c22 7072696f 72697479 223a302c 22707269 6f726974 794f6666 73657422 3a302e32 2c227375 67676573 74656457 6f726b54 79706544 65746169 6c4e616d 65223a6e 756c6c2c 22746173 6b73223a 5b223039 64626137 35622d66 3533332d 34323136 2d613830 332d3135 33303536 66323839 6532222c 22633937 39313465 612d3963 61342d34 3936652d 61343237 2d623932 36366365 35303938 66222c22 66323530 33373033 2d323232 652d3462 31392d39 6564622d 37343061 64383634 33623262 225d2c22 74797065 223a2274 61736b2d 70726f6a 65637422 2c22776f 726b5479 7065223a 22776f72 6b747970 652d6669 72652d6c 6966652d 73616665 7479222c 22776f72 6b547970 65446574 61696c22 3a22776f 726b7479 70652d66 6972652d 6c696665 2d736166 6574792d 776f726b 74797065 64657461 696c2d66 6972652d 616c6172 6d227d>
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: UPDATE revs SET current=0 WHERE sequence=?
obj: 29560
<CBL_FMDatabase: 0x7fd8b2c26880> executeQuery: SELECT revid, deleted FROM revs WHERE doc_id=? and current=1 ORDER BY deleted asc, revid desc LIMIT 2
obj: 5887
14:15:00.831| CBLDatabase: Commit transaction (level 2)
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: RELEASE cbl_2
14:15:00.831| CBLDatabase: Added: {f8ee7974-9558-4ba4-ba94-6a7ce98c58b4 #115-698c1511ee8c77131b082613d29c6e3c DEL} (seq=30060)
>>>>>>>>>>>>>>>>>>>>>>>>>> Saved non-current revsion number 0 of documment: f8ee7974-9558-4ba4-ba94-6a7ce98c58b4 error:(null)
14:15:00.831| CBLDatabase: PUT rev={f8ee7974-9558-4ba4-ba94-6a7ce98c58b4 #(null) DEL}, prevRevID=114-b119801ccce39c63560dd7a3576a38ea, allowConflict=0
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: SAVEPOINT cbl_2
14:15:00.832| CBLDatabase: Begin transaction (level 2)...
<CBL_FMDatabase: 0x7fd8b2c26880> executeQuery: SELECT revid, deleted FROM revs WHERE doc_id=? and current=1 ORDER BY deleted asc, revid desc LIMIT 2
obj: 5887
<CBL_FMDatabase: 0x7fd8b2c26880> executeQuery: SELECT sequence FROM revs WHERE doc_id=? AND revid=? AND current=1 LIMIT 1
obj: 5887
obj: 114-b119801ccce39c63560dd7a3576a38ea
<CBL_FMDatabase: 0x7fd8b2c26880> executeQuery: SELECT revid, deleted, sequence, no_attachments FROM revs WHERE revs.doc_id=? and current=1 and deleted=0 ORDER BY revid DESC LIMIT 1
obj: 5887
14:15:00.833| CBLDatabase: Abort transaction (level 2)
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: ROLLBACK TO cbl_2
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: RELEASE cbl_2
>>>>>>>>>>>>>>>>>>>>>>>>>> Saved non-current revsion number 1 of documment: f8ee7974-9558-4ba4-ba94-6a7ce98c58b4 error:409 conflict
14:15:00.833| CBLDatabase: PUT rev={f8ee7974-9558-4ba4-ba94-6a7ce98c58b4 #(null) DEL}, prevRevID=114-b119801ccce39c63560dd7a3576a38ea, allowConflict=0
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: SAVEPOINT cbl_2
14:15:00.833| CBLDatabase: Begin transaction (level 2)...
<CBL_FMDatabase: 0x7fd8b2c26880> executeQuery: SELECT revid, deleted FROM revs WHERE doc_id=? and current=1 ORDER BY deleted asc, revid desc LIMIT 2
obj: 5887
<CBL_FMDatabase: 0x7fd8b2c26880> executeQuery: SELECT sequence FROM revs WHERE doc_id=? AND revid=? AND current=1 LIMIT 1
obj: 5887
obj: 114-b119801ccce39c63560dd7a3576a38ea
<CBL_FMDatabase: 0x7fd8b2c26880> executeQuery: SELECT revid, deleted, sequence, no_attachments FROM revs WHERE revs.doc_id=? and current=1 and deleted=0 ORDER BY revid DESC LIMIT 1
obj: 5887
14:15:00.835| CBLDatabase: Abort transaction (level 2)
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: ROLLBACK TO cbl_2
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: RELEASE cbl_2
>>>>>>>>>>>>>>>>>>>>>>>>>> Saved non-current revsion number 2 of documment: f8ee7974-9558-4ba4-ba94-6a7ce98c58b4 error:409 conflict
14:15:00.835| CBLDatabase: PUT rev={f8ee7974-9558-4ba4-ba94-6a7ce98c58b4 #(null) DEL}, prevRevID=114-b119801ccce39c63560dd7a3576a38ea, allowConflict=0
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: SAVEPOINT cbl_2
14:15:00.835| CBLDatabase: Begin transaction (level 2)...
<CBL_FMDatabase: 0x7fd8b2c26880> executeQuery: SELECT revid, deleted FROM revs WHERE doc_id=? and current=1 ORDER BY deleted asc, revid desc LIMIT 2
obj: 5887
<CBL_FMDatabase: 0x7fd8b2c26880> executeQuery: SELECT sequence FROM revs WHERE doc_id=? AND revid=? AND current=1 LIMIT 1
obj: 5887
obj: 114-b119801ccce39c63560dd7a3576a38ea
<CBL_FMDatabase: 0x7fd8b2c26880> executeQuery: SELECT revid, deleted, sequence, no_attachments FROM revs WHERE revs.doc_id=? and current=1 and deleted=0 ORDER BY revid DESC LIMIT 1
obj: 5887
14:15:00.837| CBLDatabase: Abort transaction (level 2)
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: ROLLBACK TO cbl_2
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: RELEASE cbl_2
>>>>>>>>>>>>>>>>>>>>>>>>>> Saved non-current revsion number 3 of documment: f8ee7974-9558-4ba4-ba94-6a7ce98c58b4 error:409 conflict
14:15:00.837| CBLDatabase: PUT rev={f8ee7974-9558-4ba4-ba94-6a7ce98c58b4 #(null) DEL}, prevRevID=114-b119801ccce39c63560dd7a3576a38ea, allowConflict=0
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: SAVEPOINT cbl_2
14:15:00.883| CBLDatabase: Begin transaction (level 2)...
<CBL_FMDatabase: 0x7fd8b2c26880> executeQuery: SELECT revid, deleted FROM revs WHERE doc_id=? and current=1 ORDER BY deleted asc, revid desc LIMIT 2
obj: 5887
<CBL_FMDatabase: 0x7fd8b2c26880> executeQuery: SELECT sequence FROM revs WHERE doc_id=? AND revid=? AND current=1 LIMIT 1
obj: 5887
obj: 114-b119801ccce39c63560dd7a3576a38ea
<CBL_FMDatabase: 0x7fd8b2c26880> executeQuery: SELECT revid, deleted, sequence, no_attachments FROM revs WHERE revs.doc_id=? and current=1 and deleted=0 ORDER BY revid DESC LIMIT 1
obj: 5887
14:15:00.885| CBLDatabase: Abort transaction (level 2)
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: ROLLBACK TO cbl_2
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: RELEASE cbl_2
>>>>>>>>>>>>>>>>>>>>>>>>>> Saved non-current revsion number 4 of documment: f8ee7974-9558-4ba4-ba94-6a7ce98c58b4 error:409 conflict
14:15:00.886| CBLDatabase: PUT rev={f8ee7974-9558-4ba4-ba94-6a7ce98c58b4 #(null) DEL}, prevRevID=114-b119801ccce39c63560dd7a3576a38ea, allowConflict=0
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: SAVEPOINT cbl_2
14:15:00.886| CBLDatabase: Begin transaction (level 2)...
<CBL_FMDatabase: 0x7fd8b2c26880> executeQuery: SELECT revid, deleted FROM revs WHERE doc_id=? and current=1 ORDER BY deleted asc, revid desc LIMIT 2
obj: 5887
<CBL_FMDatabase: 0x7fd8b2c26880> executeQuery: SELECT sequence FROM revs WHERE doc_id=? AND revid=? AND current=1 LIMIT 1
obj: 5887
obj: 114-b119801ccce39c63560dd7a3576a38ea
<CBL_FMDatabase: 0x7fd8b2c26880> executeQuery: SELECT revid, deleted, sequence, no_attachments FROM revs WHERE revs.doc_id=? and current=1 and deleted=0 ORDER BY revid DESC LIMIT 1
obj: 5887
14:15:00.888| CBLDatabase: Abort transaction (level 2)
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: ROLLBACK TO cbl_2
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: RELEASE cbl_2
>>>>>>>>>>>>>>>>>>>>>>>>>> Saved non-current revsion number 5 of documment: f8ee7974-9558-4ba4-ba94-6a7ce98c58b4 error:409 conflict
14:15:00.889| CBLDatabase: PUT rev={f8ee7974-9558-4ba4-ba94-6a7ce98c58b4 #(null)}, prevRevID=114-b119801ccce39c63560dd7a3576a38ea, allowConflict=0
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: SAVEPOINT cbl_2
14:15:00.889| CBLDatabase: Begin transaction (level 2)...
<CBL_FMDatabase: 0x7fd8b2c26880> executeQuery: SELECT revid, deleted FROM revs WHERE doc_id=? and current=1 ORDER BY deleted asc, revid desc LIMIT 2
obj: 5887
<CBL_FMDatabase: 0x7fd8b2c26880> executeQuery: SELECT sequence FROM revs WHERE doc_id=? AND revid=? AND current=1 LIMIT 1
obj: 5887
obj: 114-b119801ccce39c63560dd7a3576a38ea
<CBL_FMDatabase: 0x7fd8b2c26880> executeQuery: SELECT revid, deleted, sequence, no_attachments FROM revs WHERE revs.doc_id=? and current=1 and deleted=0 ORDER BY revid DESC LIMIT 1
obj: 5887
14:15:00.890| CBLDatabase: Abort transaction (level 2)
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: ROLLBACK TO cbl_2
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: RELEASE cbl_2
>>>>>>>>>>>>>>>>>>>>>>>>>> Saved current revsion number 6 of documment: f8ee7974-9558-4ba4-ba94-6a7ce98c58b4 error:409 conflict
14:15:00.891| CBLDatabase: Commit transaction (level 1)
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: RELEASE cbl_1
Staring Compact
<CBL_FMDatabase: 0x7fd8b2c26880> executeQuery: SELECT value FROM info WHERE key=?
obj: max_revs
14:15:00.893| CBLDatabase: Pruning revisions to max depth 20...
<CBL_FMDatabase: 0x7fd8b2c26880> executeQuery: SELECT doc_id, MIN(revid), MAX(revid) FROM revs GROUP BY doc_id
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: SAVEPOINT cbl_1
14:15:00.975| CBLDatabase: Begin transaction (level 1)...
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 3765
obj: 2-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 5479
obj: 12-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 3679
obj: 10-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 3030
obj: 5-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 2840
obj: 22-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 4597
obj: 2-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 4346
obj: 538-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 5809
obj: 123-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 5368
obj: 32-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 2962
obj: 5-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 4572
obj: 9-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 5472
obj: 8-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 5723
obj: 6-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 5888
obj: 20-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 2980
obj: 40-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 1076
obj: 44-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 5802
obj: 133-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 4400
obj: 34-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 1388
obj: 5-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 4608
obj: 2-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 4357
obj: 27-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 4314
obj: 42-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 3561
obj: 4-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 5404
obj: 6-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 2869
obj: 11-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 1069
obj: 9-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 1381
obj: 39-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 2238
obj: 5-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 4601
obj: 2-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 4368
obj: 95-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 5623
obj: 7-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 1919
obj: 3-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 4533
obj: 28-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 4594
obj: 2-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 1937
obj: 6-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 2898
obj: 10-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 1141
obj: 2-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 2959
obj: 26-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 4569
obj: 9-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 8
obj: 2-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 1324
obj: 4-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 3332
obj: 959-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 2830
obj: 34-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 1385
obj: 8-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 5799
obj: 63-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 4605
obj: 2-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 4268
obj: 3-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 2866
obj: 8-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 4598
obj: 2-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 5810
obj: 92-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 2963
obj: 8-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 4573
obj: 9-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 5889
obj: 70-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 3336
obj: 22525-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 3544
obj: 4-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 1389
obj: 14-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 2895
obj: 19-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 2852
obj: 58-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 2956
obj: 23-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 4566
obj: 9-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 5803
obj: 55-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 1070
obj: 12-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 2827
obj: 2-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 3035
obj: 2-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 3139
obj: 8-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 5796
obj: 219-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 4602
obj: 2-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 5312
obj: 36-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 2906
obj: 73-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 4265
obj: 123-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 2863
obj: 7-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 1357
obj: 9-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 2967
obj: 44-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 5789
obj: 47-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 2838
obj: 6-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 4595
obj: 2-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 3548
obj: 4-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 4570
obj: 9-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 9
obj: 11-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 3480
obj: 4-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 2978
obj: 90-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 4588
obj: 3-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 3333
obj: 538-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 5488
obj: 44-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 1490
obj: 67-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 4606
obj: 2-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 5800
obj: 80-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 3057
obj: 4-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 4667
obj: 18-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 5836
obj: 2331-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 3283
obj: 39-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 2989
obj: 58-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 4599
obj: 2-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 5309
obj: 331-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 4574
obj: 9-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 3337
obj: 6-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 5700
obj: 20-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 3043
obj: 21-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 2853
obj: 13-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 2957
obj: 13-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 4567
obj: 9-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 3269
obj: 72-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 2975
obj: 19-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 2828
obj: 26-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 2932
obj: 5-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 5485
obj: 10-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 1487
obj: 27-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 4603
obj: 2-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 5460
obj: 19-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 2907
obj: 28-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 4474
obj: 18-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 5478
obj: 4-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 1419
obj: 24-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 2925
obj: 25-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 5790
obj: 342-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 4596
obj: 2-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 1082
obj: 9-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 5471
obj: 6-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 4571
obj: 9-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 1308
obj: 4-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 5887
obj: 122-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 2850
obj: 4-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 5464
obj: 44-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 4564
obj: 9-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 4600
obj: 2-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 3657
obj: 19-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 3259
obj: 103-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 4471
obj: 20-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 4575
obj: 9-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 1918
obj: 23-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 4593
obj: 2-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 2940
obj: 35-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 3797
obj: 16-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 1391
obj: 5-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 1330
obj: 35-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 5805
obj: 126-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 4568
obj: 9-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 4170
obj: 184-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 2915
obj: 14-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 5676
obj: 12-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 2976
obj: 17-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 1323
obj: 5-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 3435
obj: 34-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 4898
obj: 4-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 1488
obj: 101-
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM revs WHERE doc_id=? AND revid < ? AND current=0
obj: 4604
obj: 2-
14:15:01.834| CBLDatabase: Commit transaction (level 1)
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: RELEASE cbl_1
14:15:01.857| CBLDatabase: Deleting JSON of old revisions...
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: UPDATE revs SET json=null WHERE current=0
14:15:01.912| Deleting old attachments...
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: DELETE FROM attachments WHERE sequence IN (SELECT sequence from revs WHERE current=0 AND json IS null)
<CBL_FMDatabase: 0x7fd8b2c26880> executeQuery: SELECT DISTINCT key FROM attachments
14:15:01.990| Deleted 0 attachments
14:15:01.991| Flushing SQLite WAL...
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: PRAGMA wal_checkpoint(RESTART)
14:15:01.991| Vacuuming SQLite database...
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: VACUUM
14:15:02.455| Closing and re-opening database...
14:15:02.455| CBLDatabase: Open /Users/scott/Library/Developer/CoreSimulator/Devices/54BC342D-298E-4247-9973-1AB61BD0626F/data/Containers/Data/Application/C8196830-119B-4E4D-A32D-679DE86ABF9A/Library/Application Support/CouchbaseLite/scope_c91aabd3-d7e6-465d-adc9-2606604c5ee2.cblite (flags=200006)
<CBL_FMDatabase: 0x7fd8b2c26880> executeUpdate: PRAGMA foreign_keys = ON
14:15:02.456| ...Finished database compaction.
Finished Compact
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment