Re: [fossil-users] Different file count after FOSSIL REBUILD --COMPRESS

[Stephan Beal]

On Mon, Apr 8, 2019 at 12:36 AM Tony Papadimitriou  wrote:

> (Apologies if this message appears twice – I’m having some SMTP issues.)
>

This mailing list isn't used any more. The forum is now the preferred
channel:

https://fossil-scm.org/forum


>  I attempted to minimize storage by running “fossil reb --compress” on
> various fossils.  Only one result was unexpected.
> Below is a copy of the db --db-check before and after a REBUILD with
> –-COMPRESS option.  The ‘after’ is counting one file less.
>
> 1. What could be the reason for that (4299 files instead of 4300)?
>

Possibly a shunned artifact.

2. Is there some way to find out which file is missing by comparing to a
> backup?
>

You can use use sqlite's "ATTACH" command to attach both the new and old
DBs and do a SELECT to find the extra blob.uuid entry in the older copy.
There's a CONTENT() SQL function (via fossil's built-in copy of the sqlite
shell) to get the full, uncompressed content of a blob, but it outputs
using sqlite's hex-encoded mode, and i'm not sure how to get it unencoded:

echo "select content('rid:1')" | fossil sqlite3 -R repofile

replacing 'rid:1' with the UUID of the newly-missing artifact.

3. Is it safe to assume (based on the db –db-check command) that the repo
> is not corrupt in any way?
>

Definitely.

-- 
- stephan beal
https://wanderinghorse.net/home/stephan/

"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
those who insist on a perfect world, freedom will have to do." -- Bigby Wolf
___
fossil-users mailing list
fossil-users@lists.fossil-scm.org
http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users

[fossil-users] Different file count after FOSSIL REBUILD --COMPRESS

[Tony Papadimitriou]

(Apologies if this message appears twice – I’m having some SMTP issues.)

I attempted to minimize storage by running “fossil reb --compress” on various 
fossils.  Only one result was unexpected.
Below is a copy of the db --db-check before and after a REBUILD with –-COMPRESS 
option.  The ‘after’ is counting one file less.

1. What could be the reason for that (4299 files instead of 4300)?
2. Is there some way to find out which file is missing by comparing to a backup?
3. Is it safe to assume (based on the db –db-check command) that the repo is 
not corrupt in any way?

Thank you.

--

c:\pp\progs>f db -db-check
project-name:  pascal
repository-size:   23283200 bytes (23.3MB)
artifact-count:7618 (stored as 3187 full text and 4431 delta blobs)
artifact-sizes:57645 average, 1479020 max, 439082200 bytes (439.1MB) total
compression-ratio: 18:1
check-ins: 1016
files: 4300 across all branches
wiki-pages:5 (9 changes)
tickets:   16 (26 changes)
events:2
tag-changes:   24
latest-change: 2019-03-23 07:56:37 - about 15 days ago
project-age:   1894 days or approximately 5.19 years.
project-id:006b33ce7cb4bad7c65266e30a729257676ec318
schema-version:2015-01-24
fossil-version:2018-01-22 23:35:07 [8360bd000d] [1.37] (msc-18.00)
sqlite-version:2018-01-22 18:45:57 [0c55d17973] (3.22.0)
database-stats:45475 pages, 512 bytes/pg, 0 free pages, UTF-8, delete mode
database-check:ok

c:\pp\progs>f reb --compress
  100.0% complete...
Extra delta compression... done
Vacuuming the database... done

c:\pp\progs>f db -db-check
project-name:  pascal
repository-size:   22311424 bytes (22.3MB)
artifact-count:7618 (stored as 3158 full text and 4460 delta blobs)
artifact-sizes:57645 average, 1479020 max, 439082200 bytes (439.1MB) total
compression-ratio: 19:1
check-ins: 1016
files: 4299 across all branches
wiki-pages:5 (9 changes)
tickets:   16 (26 changes)
events:2
tag-changes:   24
latest-change: 2019-03-23 07:56:37 - about 15 days ago
project-age:   1894 days or approximately 5.19 years.
project-id:006b33ce7cb4bad7c65266e30a729257676ec318
schema-version:2015-01-24
fossil-version:2018-01-22 23:35:07 [8360bd000d] [1.37] (msc-18.00)
sqlite-version:2018-01-22 18:45:57 [0c55d17973] (3.22.0)
database-stats:43577 pages, 512 bytes/pg, 0 free pages, UTF-8, delete mode
database-check:ok___
fossil-users mailing list
fossil-users@lists.fossil-scm.org
http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users