Big repo that doesn't exist


#1

Hi,

Seafile Pro 6.3.12

when I log in as seafile admin, the statistics show that we have 7127 libraries with 4858658 files. I wanted to know, who owns so many files, so I looked at the database table seafile-db.RepoFileCount. It shows one repo with 2576753 files. Now I wanted to find out the owner of the repo, but the repo doesn’t appear in the RepoOwner table. It only shows up in the RepoSize table with a size of 19 GB. Then I tried a seaf-fsck, but the repo doesn’t exist.

$ ./seaf-fsck.sh 6e544797-5e87-40a0-a7de-c488784196ff

Starting seaf-fsck, please wait ...

[07/05/19 09:49:26] fsck.c(602): Running fsck for repo 6e544797-5e87-40a0-a7de-c488784196ff.
[07/05/19 09:49:26] fsck.c(611): Repo 6e544797 doesn't exist.
[07/05/19 09:49:26] fsck.c(666): Fsck finished for repo 6e544797.

These are the db entries where the repo appears (RepoSize, RepoFileCount, GCID):

+------+--------------------------------------+-------------+------------------------------------------+
| id   | repo_id                              | size        | head_id                                  |
+------+--------------------------------------+-------------+------------------------------------------+
| 2269 | 6e544797-5e87-40a0-a7de-c488784196ff | 19872998096 | ae1f881c35861f181d2bca9d31a4b2bfcce8d8b8 |
+------+--------------------------------------+-------------+------------------------------------------+
+------+--------------------------------------+------------+
| id   | repo_id                              | file_count |
+------+--------------------------------------+------------+
| 1695 | 6e544797-5e87-40a0-a7de-c488784196ff |    2576753 |
+------+--------------------------------------+------------+
+------+--------------------------------------+--------------------------------------+
| id   | repo_id                              | gc_id                                |
+------+--------------------------------------+--------------------------------------+
| 2247 | 6e544797-5e87-40a0-a7de-c488784196ff | 618fbaf1-6936-4a42-b9dc-9e54a64aca3e |
+------+--------------------------------------+--------------------------------------+

How can this be? How can I solve the problem?

Thanks,
Dirk


#2

In the admin Libraries web interface, you should see the file number, size, and owner of each library directly. There is no need of such complications.
If it doesn’t show up as a library, it could be possible that it is a sub-folder. As the user sync the sub-folder, so it appears to be a library.


#3

Unfortunately, you can only search the libraries by name. And skipping the pages with 7000+ libraries until the right one appears takes a very long time. I made a text search for the repo_id in my database backup and I only found the three entries above.


#4

If you use the audit feature, you can open the URL like: https://your-seafile-url.de/sys/log/fileaudit/?repo_id=6e544797-5e87-40a0-a7de-c488784196ff&

There you should be able to see the user and name of the library.


#5

Thanks for the hint, but I have disabled auditing.