1. C:\sqlite> sqlite3.exe library.db
  2. SQLite version 3.8.7 2014-10-17 11:24:17
  3. Enter ".help" for usage hints.
  4. sqlite> pragma integrity_check;
  5. *** in database main ***
  6. On tree page 5 cell 86: 2nd reference to page 1352
  7. On tree page 5 cell 86: Child page depth differs
  8. On tree page 5 cell 87: 2nd reference to page 1563
  9. On tree page 5 cell 88: Child page depth differs
  10. Page 8552: Rowid 872617 out of order (min less than parent min of 872767)
  11. Page 7836: Rowid 236003 out of order (min less than parent max of 874066)
  12. On tree page 7745 cell 138: 2nd reference to page 7836
  13. On tree page 7745 cell 138: Child page depth differs
  14. On tree page 7745 cell 139: Child page depth differs
  15. Page 8323 is never used
  16. Page 9381 is never used
  17. row 5094 missing from index idx_ChildrenIds
  18. row 5094 missing from index sqlite_autoindex_ChildrenIds_1
  19. row 5095 missing from index idx_ChildrenIds
  20. row 5095 missing from index sqlite_autoindex_ChildrenIds_1
  21. row 5304 missing from index idx_ChildrenIds
  22. row 5304 missing from index sqlite_autoindex_ChildrenIds_1
  23. row 5305 missing from index idx_ChildrenIds
  24. row 5305 missing from index sqlite_autoindex_ChildrenIds_1
  25. row 5306 missing from index idx_ChildrenIds
  26. row 5306 missing from index sqlite_autoindex_ChildrenIds_1
  27. row 5307 missing from index idx_ChildrenIds
  28. row 5307 missing from index sqlite_autoindex_ChildrenIds_1
  29. row 5308 missing from index idx_ChildrenIds
  30. row 5308 missing from index sqlite_autoindex_ChildrenIds_1
  31. row 5309 missing from index idx_ChildrenIds
  32. row 5309 missing from index sqlite_autoindex_ChildrenIds_1
  33. row 5310 missing from index idx_ChildrenIds
  34. row 5310 missing from index sqlite_autoindex_ChildrenIds_1
  35. row 5311 missing from index idx_ChildrenIds
  36. row 5311 missing from index sqlite_autoindex_ChildrenIds_1
  37. row 5312 missing from index idx_ChildrenIds
  38. row 5312 missing from index sqlite_autoindex_ChildrenIds_1
  39. row 5313 missing from index idx_ChildrenIds
  40. row 5313 missing from index sqlite_autoindex_ChildrenIds_1
  41. row 5314 missing from index idx_ChildrenIds
  42. row 5314 missing from index sqlite_autoindex_ChildrenIds_1
  43. row 5315 missing from index idx_ChildrenIds
  44. row 5315 missing from index sqlite_autoindex_ChildrenIds_1
  45. row 5316 missing from index idx_ChildrenIds
  46. row 5316 missing from index sqlite_autoindex_ChildrenIds_1
  47. row 5317 missing from index idx_ChildrenIds
  48. row 5317 missing from index sqlite_autoindex_ChildrenIds_1
  49. row 5318 missing from index idx_ChildrenIds
  50. row 5318 missing from index sqlite_autoindex_ChildrenIds_1
  51. row 5319 missing from index idx_ChildrenIds
  52. row 5319 missing from index sqlite_autoindex_ChildrenIds_1
  53. row 5320 missing from index idx_ChildrenIds
  54. row 5320 missing from index sqlite_autoindex_ChildrenIds_1
  55. row 5321 missing from index idx_ChildrenIds
  56. row 5321 missing from index sqlite_autoindex_ChildrenIds_1
  57. row 5322 missing from index idx_ChildrenIds
  58. row 5322 missing from index sqlite_autoindex_ChildrenIds_1
  59. row 5323 missing from index idx_ChildrenIds
  60. row 5323 missing from index sqlite_autoindex_ChildrenIds_1
  61. row 5324 missing from index idx_ChildrenIds
  62. row 5324 missing from index sqlite_autoindex_ChildrenIds_1
  63. row 5325 missing from index idx_ChildrenIds
  64. row 5325 missing from index sqlite_autoindex_ChildrenIds_1
  65. row 5387 missing from index idx_ChildrenIds
  66. row 5388 missing from index idx_ChildrenIds
  67. row 5389 missing from index idx_ChildrenIds
  68. row 5390 missing from index idx_ChildrenIds
  69. row 5391 missing from index idx_ChildrenIds
  70. row 5392 missing from index idx_ChildrenIds
  71. row 5393 missing from index idx_ChildrenIds
  72. row 5394 missing from index idx_ChildrenIds
  73. row 5395 missing from index idx_ChildrenIds
  74. row 5396 missing from index idx_ChildrenIds
  75. row 5397 missing from index idx_ChildrenIds
  76. row 5398 missing from index idx_ChildrenIds
  77. row 5399 missing from index idx_ChildrenIds
  78. row 5400 missing from index idx_ChildrenIds
  79. row 5438 missing from index idx_ChildrenIds
  80. row 5438 missing from index sqlite_autoindex_ChildrenIds_1
  81. row 5439 missing from index idx_ChildrenIds
  82. row 5439 missing from index sqlite_autoindex_ChildrenIds_1
  83. row 5440 missing from index idx_ChildrenIds
  84. row 5440 missing from index sqlite_autoindex_ChildrenIds_1
  85. row 5441 missing from index idx_ChildrenIds
  86. row 5441 missing from index sqlite_autoindex_ChildrenIds_1
  87. row 5442 missing from index idx_ChildrenIds
  88. row 5442 missing from index sqlite_autoindex_ChildrenIds_1
  89. row 5443 missing from index idx_ChildrenIds
  90. row 5443 missing from index sqlite_autoindex_ChildrenIds_1
  91. row 5444 missing from index idx_ChildrenIds
  92. row 5444 missing from index sqlite_autoindex_ChildrenIds_1
  93. row 5445 missing from index idx_ChildrenIds
  94. row 5445 missing from index sqlite_autoindex_ChildrenIds_1
  95. row 5446 missing from index idx_ChildrenIds
  96. row 5446 missing from index sqlite_autoindex_ChildrenIds_1
  97. row 5447 missing from index idx_ChildrenIds
  98. row 5447 missing from index sqlite_autoindex_ChildrenIds_1
  99. row 5448 missing from index idx_ChildrenIds
  100. row 5448 missing from index sqlite_autoindex_ChildrenIds_1
  101. row 5449 missing from index idx_ChildrenIds
  102. row 5449 missing from index sqlite_autoindex_ChildrenIds_1
  103. row 5450 missing from index idx_ChildrenIds
  104. row 5450 missing from index sqlite_autoindex_ChildrenIds_1
  105. row 5451 missing from index idx_ChildrenIds
  106. sqlite>

MediaBrowser 3 library.db corrupted