One question npvr.db size and maybe a feature request.

[mvallevand]

Ok now we will now attempt the fix the last command was just the test

sqlite3 npvr.db3 .dump > backup.sql

ren npvr.db3 npvr.db3.old

sqlite3 npvr.db3 < backup.sql

Martin

[joaosz]

Backup the file before trying to fix it.

ok


That's the result's pragma integrity_check:


"*** in database main ***
On tree page 55372 cell 67: 2nd reference to page 74945
On tree page 133810 cell 62: 2nd reference to page 74874
On tree page 133810 cell 42: 2nd reference to page 74871
On tree page 133810 cell 41: 2nd reference to page 74872
On tree page 133810 cell 40: 2nd reference to page 74873
On tree page 133810 cell 39: 2nd reference to page 74875
On tree page 133810 cell 38: 2nd reference to page 74876
On tree page 1236 cell 5: 2nd reference to page 74978
On tree page 1236 cell 5: Child page depth differs
Page 74960: btreeInitPage() returns error code 11
On tree page 5436 cell 78: 2nd reference to page 74959
On tree page 5436 cell 77: 2nd reference to page 74958

Searching in the web, I think I've found a solution:

Using DB Browser Lite to export the database to a SQL file and re importing the SQL file to create a new npvr.db3 file.

Replace the new file on the NextPVR's server and reboot.

The vacuum routine did well and everything else appears to be fine.

The file's size = 7mb

Here's the new log to check.

[mvallevand]

I think that is want my sqlite3 backup and restore would have done.

Martin

[joaosz]

Ok now we will now attempt the fix the last command was just the test

sqlite3 npvr.db3 .dump > backup.sql

ren npvr.db3 npvr.db3.old

sqlite3 npvr.db3 < backup.sql

Martin

I did that using the DB Lite Browser, It's more friendly.

Anyway I'd write down the commands above.

Thanks for the help.

João

[sub]

Great.

That fixed the issue:

2020-04-21 21:55:09.860 [DEBUG][9] Doing database vacuum
2020-04-21 21:55:10.272 [DEBUG][9] vacuuming done