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

[joaosz]

My npvr.db's size keeps growing. My file is over 400 mb. What's causing it?

One feature request. A setting to clean the database without losing the setup.

Thanks for the NextPVR. 

João.

[sub]

If you restart the NextPVR Service, does it shrink?

There is a database "vacuum" operation that happens any time the application is restarted, which reclaims any unused space and should shrink the database.

[joaosz]

If you restart the NextPVR Service, does it shrink?

There is a database "vacuum" operation that happens any time the application is restarted, which reclaims any unused space and should shrink the database

Nope, I didn't noticed that.

I will attach the log as soon as possible.

[joaosz]

If you restart the NextPVR Service, does it shrink?

There is a database "vacuum" operation that happens any time the application is restarted, which reclaims any unused space and should shrink the database

Nope, I didn't noticed that.

I will attach the log as soon as possible.

Here's my log.

If you need the npvr file please let me know.

Thanks

João

[sub]

It looks like it is trying to shrink your database, but the file is somehow corrupt.

2020-04-21 06:56:21.315 [DEBUG][9] Doing database vacuum
2020-04-21 06:56:21.480 [ERROR][9] Unexpected error doing DBHouseCleaning: SQLite Error 11: 'database disk image is malformed'.

[joaosz]

It looks like it is trying to shrink your database, but the file is somehow corrupt.

2020-04-21 06:56:21.315 [DEBUG][9] Doing database vacuum
2020-04-21 06:56:21.480 [ERROR][9] Unexpected error doing DBHouseCleaning: SQLite Error 11: 'database disk image is malformed'.

Ok. Is there a way to backup the channel's list with the epg's mapping? A m3u list to restore in a new installation of NextPVR?

Thanks!

[mvallevand]

I see you are running from C:\Program Files(x86)\NPVR do you have two copies of NextPVR installed, with another one in C:\Program Files\NextPVR

Before doing anything serious I would try and fix the file from the command line by downloading sqlite3, stopping the server and running

sqlite3 npvr.db3 "pragma integrity_check"

Check for disk space too.

Martin

[sub]

Backup the file before trying to fix it.

[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
On tree page 5436 cell 76: 2nd reference to page 74957
On tree page 5436 cell 75: 2nd reference to page 74956
On tree page 5436 cell 74: 2nd reference to page 74955
On tree page 5436 cell 73: 2nd reference to page 74954
On tree page 5436 cell 72: 2nd reference to page 74953
On tree page 5436 cell 71: 2nd reference to page 74952
On tree page 5436 cell 70: 2nd reference to page 74951
On tree page 5436 cell 69: 2nd reference to page 74950
On tree page 5436 cell 68: 2nd reference to page 74949
On tree page 5436 cell 67: 2nd reference to page 74948
On tree page 5436 cell 66: 2nd reference to page 74947
On tree page 5436 cell 65: 2nd reference to page 74946
On tree page 74943 cell 2: Rowid 18033040 out of order
On tree page 5436 cell 63: Rowid 18033044 out of order
On tree page 5436 cell 63: 2nd reference to page 74942
On tree page 5436 cell 62: 2nd reference to page 74941
On tree page 5436 cell 61: 2nd reference to page 74940
On tree page 5436 cell 60: 2nd reference to page 74939
On tree page 5436 cell 59: 2nd reference to page 74938
On tree page 5436 cell 58: 2nd reference to page 74937
On tree page 5436 cell 57: 2nd reference to page 74936
On tree page 5436 cell 56: 2nd reference to page 74935
On tree page 5436 cell 55: 2nd reference to page 74934
On tree page 5436 cell 54: 2nd reference to page 74933
On tree page 5436 cell 53: 2nd reference to page 74932
On tree page 5436 cell 52: 2nd reference to page 74931
On tree page 5436 cell 51: 2nd reference to page 74930
On tree page 5436 cell 50: 2nd reference to page 74929
On tree page 5436 cell 49: 2nd reference to page 74928
On tree page 5436 cell 48: 2nd reference to page 74927
On tree page 5436 cell 47: 2nd reference to page 74926
On tree page 5436 cell 46: 2nd reference to page 74925
On tree page 5436 cell 45: 2nd reference to page 74924
On tree page 5436 cell 44: 2nd reference to page 74923
On tree page 5436 cell 43: 2nd reference to page 74922
On tree page 5436 cell 42: 2nd reference to page 74921
On tree page 5436 cell 41: 2nd reference to page 74920
On tree page 5436 cell 40: 2nd reference to page 74919
On tree page 5436 cell 39: 2nd reference to page 74918
On tree page 5436 cell 38: 2nd reference to page 74917
On tree page 5436 cell 37: 2nd reference to page 74916
On tree page 5436 cell 36: 2nd reference to page 74915
On tree page 5436 cell 35: 2nd reference to page 74914
On tree page 5436 cell 34: 2nd reference to page 74913
On tree page 5436 cell 33: 2nd reference to page 74912
On tree page 5436 cell 32: 2nd reference to page 74911
On tree page 5436 cell 31: 2nd reference to page 74910
On tree page 5436 cell 30: 2nd reference to page 74909
On tree page 5436 cell 29: 2nd reference to page 74908
On tree page 5436 cell 28: 2nd reference to page 74907
On tree page 5436 cell 27: 2nd reference to page 74906
On tree page 5436 cell 26: 2nd reference to page 74905
On tree page 5436 cell 25: 2nd reference to page 74904
On tree page 5436 cell 24: 2nd reference to page 74903
On tree page 5436 cell 23: 2nd reference to page 74902
On tree page 5436 cell 22: 2nd reference to page 74901
On tree page 5436 cell 21: 2nd reference to page 74900
On tree page 5436 cell 20: 2nd reference to page 74899
On tree page 5436 cell 19: 2nd reference to page 74898
On tree page 5436 cell 18: 2nd reference to page 74897
On tree page 5436 cell 17: 2nd reference to page 74896
On tree page 5436 cell 16: 2nd reference to page 74895
On tree page 5436 cell 15: 2nd reference to page 74894
On tree page 5436 cell 14: 2nd reference to page 74893
On tree page 5436 cell 13: 2nd reference to page 74892
On tree page 5436 cell 12: 2nd reference to page 74891
On tree page 5436 cell 11: 2nd reference to page 74890
On tree page 5436 cell 10: 2nd reference to page 74889
On tree page 5436 cell 9: 2nd reference to page 74888
On tree page 5436 cell 8: 2nd reference to page 74886
On tree page 5436 cell 7: 2nd reference to page 74885
On tree page 5436 cell 6: 2nd reference to page 74884
On tree page 5436 cell 5: 2nd reference to page 74883
On tree page 5436 cell 4: 2nd reference to page 74882
On tree page 5436 cell 3: 2nd reference to page 74880
On tree page 5436 cell 2: 2nd reference to page 74879
On tree page 5436 cell 1: 2nd reference to page 74878
On tree page 5436 cell 0: 2nd reference to page 74877
On tree page 1236 cell 4: Child page depth differs
On tree page 5336 cell 3: 2nd reference to page 74730
Page 366 is never used
Page 367 is never used
Page 370 is never used
Page 371 is never used
Page 372 is never used
Page 373 is never used
Page 374 is never used
Page 375 is never used

[joaosz]

I  see you are running from C:\Program Files(x86)\NPVR  do you have two copies of NextPVR installed, with another one in C:\Program Files\NextPVR

Before doing anything serious I would try and fix the file from the command line by downloading sqlite3, stopping the server and running

sqlite3 npvr.db3 "pragma integrity_check"

Check for disk space too.

Martin

Thanks for helping.

I changed the program's local but only one instance running.