Miranda NG Official Community Forum

Forum for English speaking Miranda NG users => Support/Help => Topic started by: zlotowinfo on 30 05 2020, 17:17:38

Title: compacting: database error, database archivisation freezing program
Post by: zlotowinfo on 30 05 2020, 17:17:38

compacting database:
always with error

database archivisation:
freezing program & archivised file has half size

must archivising by myself

version v 0.95.12 build #23047 (19a91f4807) x64

Title: Re: compacting: database error, database archivisation freezing program
Post by: ghazan on 03 06 2020, 08:05:46

The preferrable variant is to restore the most recent database backup that could be compacted. If you don't have one, I'd recommend you to create a new profile & export the old one completely into it using service mode. To do that specify Import as the service plugin in the profile creation dialog:
(https://i.imgur.com/PwKnKpP.png)

Title: Re: compacting: database error, database archivisation freezing program
Post by: zlotowinfo on 03 06 2020, 11:20:45

Its helped, but archive still too big.
I removed from history all except last year but archive still 15MB


Now deleted almost all messages & still 12MB

Title: Re: compacting: database error, database archivisation freezing program
Post by: ghazan on 03 06 2020, 13:06:11

zlotowinfo,
There's such thing like granularity, i.e. the amount of disk allocated for each table in a profile. Right now it's set to 2MB, so if there's one record, you get a profile of 2MB length. More records in another tables - more slices 2MB each.

Title: Re: compacting: database error, database archivisation freezing program
Post by: zlotowinfo on 03 06 2020, 13:24:31

I think you trying to tell me about constants size of each record in database.

Is there posibility to clean up contacts without messages?

Title: Re: compacting: database error, database archivisation freezing program
Post by: ghazan on 03 06 2020, 15:50:28

zlotowinfo,
no, that's not about record size, that's a space segment aka slice which is filled further with pages of data or indexes.
there're six segments in each profile