Hi, We run sqlite with PRAGMA synchronous=OFF.
Now we suffered from a 'hard reboot' because a sysadmin unplugged the power cable :( Is it possible to repair when you see after that: OrderCallbackStorage::checkDatabaseIntegrity: row 1 [*** in database main *** On tree page 413956 cell 2: Rowid 2178413 out of order (min less than parent min of 3012692) On tree page 422781 cell 0: Rowid 2178406 out of order (min less than parent min of 2178415) On tree page 422438 cell 2: Rowid 2178399 out of order (min less than parent min of 2178406) On tree page 334618 cell 2: Rowid 2178385 out of order (min less than parent min of 2178475) On tree page 697766 cell 1: Rowid 2178383 out of order (min less than parent min of 2178387) On tree page 720566 cell 2: Rowid 2178379 out of order (min less than parent min of 2178384) On tree page 422724 cell 1: Rowid 2178374 out of order (min less than parent min of 2178473) On tree page 325009 cell 1: Rowid 2178372 out of order (min less than parent min of 2178375) On tree page 422681 cell 0: Rowid 2178362 out of order (min less than parent min of 2178373) On tree page 194104 cell 2: Rowid 2178354 out of order (min less than parent min of 3012756) On tree page 438849 cell 1: Rowid 2178347 out of order (min less than parent min of 2178356) On tree page 422447 cell 2: Rowid 2178334 out of order (min less than parent min of 2178348) On tree page 422743 cell 2: Rowid 2178328 out of order (min less than parent min of 2178336) On tree page 236562 cell 2: Rowid 2178322 out of order (min less than parent min of 2178345) On tree page 311214 cell 0: 2nd reference to page 271619 On tree page 311214 cell 1: 2nd reference to page 275817 On tree page 311214 cell 2: 2nd reference to page 91403 On tree page 311214 cell 3: 2nd reference to page 292601 On tree page 311214 cell 4: Child page depth differs On tree page 311214 cell 7: 2nd reference to page 160638 On tree page 311214 cell 7: Child page depth differs On tree page 311214 cell 8: 2nd reference to page 273835 On tree page 311214 cell 9: 2nd reference to page 274642 On tree page 422924 cell 1: Rowid 2178314 out of order (min less than parent min of 2178390) On tree page 476820 cell 2: Rowid 2178304 out of order (min less than parent min of 2178367) On tree page 622874 cell 0: 2nd reference to page 230945 On tree page 622874 cell 1: Child page depth differs On tree page 701236 cell 2: Rowid 2178312 out of order (max larger than parent max of 0) On tree page 767658 cell 2: Rowid 2178267 out of order (max larger than parent max of 0) On tree page 472626 cell 1: 2nd reference to page 150955 On tree page 472626 cell 1: Child page depth differs On tree page 472626 cell 2: Child page depth differs On tree page 688043 cell 0: 2nd reference to page 245840 On tree page 688043 cell 1: Child page depth differs On tree page 248418 cell 0: 2nd reference to page 100017 On tree page 248418 cell 1: 2nd reference to page 125810 On tree page 248418 cell 2: 2nd reference to page 59456 On tree page 248418 cell 3: Child page depth differs On tree page 248418 cell 4: 2nd reference to page 46971 On tree page 248418 cell 4: Child page depth differs On page 248418 at right child: 2nd reference to page 64328 On tree page 894475 cell 15: Child page depth differs On tree page 894475 cell 16: Child page depth differs On tree page 677958 cell 1: 2nd reference to page 966321 On tree page 677958 cell 1: Child page depth differs On tree page 677958 cell 2: 2nd reference to page 775609 On tree page 677958 cell 3: 2nd reference to page 1078447 On tree page 677958 cell 4: 2nd reference to page 652046 On tree page 677958 cell 5: Child page depth differs On tree page 677958 cell 6: 2nd reference to page 726491 On tree page 677958 cell 6: Child page depth differs On tree page 677958 cell 7: 2nd reference to page 1007385 On tree page 677958 cell 8: 2nd reference to page 902320 On tree page 677958 cell 9: 2nd reference to page 826098 On tree page 677958 cell 10: 2nd reference to page 650238 On page 677958 at right child: 2nd reference to page 910835 On tree page 699269 cell 2: Rowid 2178222 out of order (max larger than parent max of 0) On tree page 748653 cell 1: Rowid 2178303 out of order (max larger than parent max of 0) On tree page 621479 cell 1: 2nd reference to page 1033527 On tree page 621479 cell 1: Child page depth differs On tree page 621479 cell 2: Child page depth differs On tree page 651448 cell 9: 2nd reference to page 710853 On tree page 651448 cell 9: Child page depth differs On tree page 651448 cell 10: Child page depth differs On tree page 469407 cell 9: 2nd reference to page 293922 On tree page 469407 cell 9: Child page depth differs On tree page 469407 cell 10: Child page depth differs On tree page 853029 cell 1: 2nd reference to page 922049 On tree page 853029 cell 1: Child page depth differs On tree page 853029 cell 2: Child page depth differs Page 21261 is never used Page 29169 is never used Page 44115 is never used Page 54336 is never used Page 70427 is never used Page 99542 is never used Page 118025 is never used Page 153747 is never used Page 186604 is never used Page 265329 is never used Page 275903 is never used Page 287350 is never used Page 296334 is never used Page 317820 is never used Page 320269 is never used Page 327684 is never used Page 338733 is never used Page 387439 is never used Page 415814 is never used Page 423147 is never used Page 464773 is never used Page 470944 is never used Page 533737 is never used Page 566530 is never used Page 568144 is never used Page 568859 is never used Page 587978 is never used Page 606340 is never used Page 607341 is never used Page 608111 is never used] Regards, Gunnar
