Compacting thumbnail database takes a long time

Hert
Posts: 6356
Joined: 13 Sep 03 7:24

Re: Compacting thumbnail database takes a long time

Post by Hert » 23 Dec 19 19:10

Build 2607 can be downloaded from the website.
This is a User-to-User forum which means that users post questions here for other users.
Feature requests, change suggestions, or bugs can be logged in the ticketing system

Larry56
Posts: 388
Joined: 05 Jul 10 6:57

Re: Compacting thumbnail database takes a long time

Post by Larry56 » 23 Dec 19 20:34

Thank you, Hert. Just ran compact and both are much faster. My first test today had the same time as v5.1.0.2446. And the two other file extensions are not there.

User avatar
G8DHE
Posts: 236
Joined: 21 Aug 17 13:58

Re: Compacting thumbnail database takes a long time

Post by G8DHE » 23 Dec 19 20:38

Likewise but only on my test databases so far, hopefully get a break to set it going on the main database tomorrow.

Edit: and yes on the Master database as well, much faster thanks Hert. and please enjoy a Merry Xmas, many thanks for the work you put in on the software.
Geoff Mather (G8DHE)

Mikki
Posts: 112
Joined: 08 May 05 9:59
Location: Denmark

Re: Compacting thumbnail database takes a long time

Post by Mikki » 27 Dec 19 8:58

Excellent - Build 2607 solved the problem!

BR
Mikki

User avatar
G8DHE
Posts: 236
Joined: 21 Aug 17 13:58

Re: Compacting thumbnail database takes a long time

Post by G8DHE » 27 Dec 19 10:43

Spoke to soon, it seemed to work the first time on both .db's, now it just hangs on .cat.db and eventually totally freezes. Its fine when working on the thumbs.db.
No error messages or panels, it appears to create a file in a temp folder that looks going by the size to be a copy or compacted copy of the .db, this then disappears but nothing else happens until it freezes with no cpu activity and the progress bar freezes its motion.
Geoff Mather (G8DHE)

User avatar
G8DHE
Posts: 236
Joined: 21 Aug 17 13:58

Re: Compacting thumbnail database takes a long time

Post by G8DHE » 27 Dec 19 14:30

Weird, worrying even, I restored back to a backup taken directly after running a compact using the version 2607.
Just to check all was OK I ran a Compact on the .cat.db again after restoring.
It to has frozen, after using Task Manager in Windows 10 to see what was going on -
it appears to have a child process involving Microsoft Passport listed ?? Not something I was expecting to see ! ???
Have never used MS Passport to my knowledge so I am bemused, is it something in use within PSU ?
Image
Geoff Mather (G8DHE)

Larry56
Posts: 388
Joined: 05 Jul 10 6:57

Re: Compacting thumbnail database takes a long time

Post by Larry56 » 27 Dec 19 18:34

Just ran compact again and it completed both the catalog and thumbnail in about the same time as my last compacting. In this case I ran compact catalog and thumbnail individually and not the both option and everything is running fine.

User avatar
G8DHE
Posts: 236
Joined: 21 Aug 17 13:58

Re: Compacting thumbnail database takes a long time

Post by G8DHE » 27 Dec 19 18:47

Tks for the report Larry56, most intrigued now as to what is happening. beginning to wonder if there is a problem with the .cat.db. Nothing untoward is happening when I use the system itself merely the problems when compacting.
Geoff Mather (G8DHE)

KeesdH
Posts: 40
Joined: 26 Jun 08 19:53

Re: Compacting thumbnail database takes a long time

Post by KeesdH » 29 Dec 19 13:55

G8DHE wrote:
27 Dec 19 10:43
Spoke to soon, it seemed to work the first time on both .db's, now it just hangs on .cat.db and eventually totally freezes. Its fine when working on the thumbs.db.
No error messages or panels, it appears to create a file in a temp folder that looks going by the size to be a copy or compacted copy of the .db, this then disappears but nothing else happens until it freezes with no cpu activity and the progress bar freezes its motion.
Same issue here. Compacting the thumbnail db works abeit slowly. Compacting the cat.db just does not work and PSU hangs.

Any news on this issue?

Hert
Posts: 6356
Joined: 13 Sep 03 7:24

Re: Compacting thumbnail database takes a long time

Post by Hert » 29 Dec 19 23:03

KeesdH; In 2607, the compacting is identical in speed of versions before build 2592 because the change was reverted.
Did you already install build 2607?
This is a User-to-User forum which means that users post questions here for other users.
Feature requests, change suggestions, or bugs can be logged in the ticketing system

KeesdH
Posts: 40
Joined: 26 Jun 08 19:53

Re: Compacting thumbnail database takes a long time

Post by KeesdH » 30 Dec 19 12:39

Hi Hert,

I am running 2607. I tried again this morning. PSU is running for over three hours now just compacting the cat.db and using 0.2% cpu. Will abort the process now.

Mikki
Posts: 112
Joined: 08 May 05 9:59
Location: Denmark

Re: Compacting thumbnail database takes a long time

Post by Mikki » 30 Dec 19 14:01

Hi all
First compression made after upgrading to build 2607 went fairly quick. But now, second compression, is taking more than 2 thous and is still running...
BR
Mikki

Hert
Posts: 6356
Joined: 13 Sep 03 7:24

Re: Compacting thumbnail database takes a long time

Post by Hert » 30 Dec 19 14:41

Also in build 2616?
This is a User-to-User forum which means that users post questions here for other users.
Feature requests, change suggestions, or bugs can be logged in the ticketing system

KeesdH
Posts: 40
Joined: 26 Jun 08 19:53

Re: Compacting thumbnail database takes a long time

Post by KeesdH » 30 Dec 19 16:17

Just tried 2616.
Given the 8% cpu and 8% diskaccess and after a while the journal file comming up something seems to happen. After a probably normal period of time PSU came back, however with the error message "database table is locked". Not sure if the compacting has worked out.

Hert
Posts: 6356
Joined: 13 Sep 03 7:24

Re: Compacting thumbnail database takes a long time

Post by Hert » 30 Dec 19 17:16

Yes, the compact did finish. It is finished as soon as the journal file disappears
This is a User-to-User forum which means that users post questions here for other users.
Feature requests, change suggestions, or bugs can be logged in the ticketing system

Post Reply