# Rebuild Database

**URL:** <https://forum.manager.io/t/rebuild-database/41344>\
**Category:** Uncategorized\
**Created:** [June 4, 2022, 5:43pm UTC](https://forum.manager.io/t/rebuild-database/41344 "2022-06-04T17:43:05Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![maldroubi](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/maldroubi/32/19323_2.png) [@maldroubi](https://forum.manager.io/u/maldroubi)\
**Post date:** [June 4, 2022, 5:43pm UTC](https://forum.manager.io/t/rebuild-database/41344/1 "2022-06-04T17:43:05Z")

</div>

once I do rebuild database ( vacuum ) this error came up:

\*\*\* in database main \*\*\* On tree page 48582 cell 6: Rowid 16711 out of order

row 3659 missing from index Objects\_ContentType

row 3659 missing from index sqlite\_autoindex\_Objects\_1

wrong # of entries in index sqlite\_autoindex\_Objects\_1

any solution ???

---

<div class="post-metadata">

**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\
**Post date:** [June 4, 2022, 8:31pm UTC](https://forum.manager.io/t/rebuild-database/41344/2 "2022-06-04T20:31:09Z")

</div>

These are sqlite errors and it means the database is corrupted.

If you have [sqlite command line tool](https://www.sqlite.org/cli.html), then you can usually fix this by entering this command:

> sqlite3 broken.manager “.recover” | sqlite3 new.manager

`broken.manager` is filename of your corrupted Manager database.

---

<div class="post-metadata">

**Author:** ![maldroubi](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/maldroubi/32/19323_2.png) [@maldroubi](https://forum.manager.io/u/maldroubi)\
**Post date:** [June 5, 2022, 11:16am UTC](https://forum.manager.io/t/rebuild-database/41344/3 "2022-06-05T11:16:36Z")

</div>

I am appreciate your concern. I am Mac user and I have limited info about the sqlite3.  
the corrupted database at the download folder and I use terminal to run the sqlite3  
but I couldn’t succeed.

---

<div class="post-metadata">

**Author:** ![maldroubi](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/maldroubi/32/19323_2.png) [@maldroubi](https://forum.manager.io/u/maldroubi)\
**Post date:** [June 5, 2022, 6:45pm UTC](https://forum.manager.io/t/rebuild-database/41344/4 "2022-06-05T18:45:27Z")

</div>

> [@lubos](#):
>
> sqlite3 broken.manager “.recover” | sqlite3 new.manager

its done on windows. Perfect @lubos

---

<div class="post-metadata">

**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\
**Post date:** [July 5, 2026, 8:13pm UTC](https://forum.manager.io/t/rebuild-database/41344/5 "2026-07-05T20:13:13Z")

</div>

Uncategorized topics older than 3 years with no recent activity