View Single Post
Old 01-17-2022, 12:34 AM   #2406
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 24,905
Karma: 47303824
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
Quote:
Originally Posted by ownedbycats View Post
What exactly does the "page #### is never used" error (corrupt database) actually mean? Compressing the database fixed it.
It means an internal page mapping is out of sync. Basically, one place has pointer say that a page in the file is used, but, none of the tables or indexes are actually using the page. Here, "page" is basically the unit of allocation of disk space in the file. It should be safe to ignore.

The compress, or VACUUM, rebuilds the file. So, it cleans up any unused space.
davidfor is offline