Stalling frequently on startup (not-responding)

[Mke]

Over the past weeks / since V6 I have found that PSU is frequently failing to start correctly - becoming non-responsive - something that was previously a rare occurrence.

It starts up with the following processes active
.

StallOnStartup .png (7.17 KiB) Viewed 299 times

.
Stalls normally occur within a couple of seconds with the progress bar stopping. Occasionally the 'Verification Service' finishes and then it stalls with just the 'Verifying' service running. Sometimes a 'no change found for selected files' message pops up before the stall, sometimes it stalls with the message still on display, sometimes it doesn't appear.

Prompted by failure 1 in the list below, I've just opened and closed PSU 20 times (doing nothing within it), ending it when non-responsive via Task Manager, with the following results:

1 - Stalled during 'Verification Service'
2 - Stalled during 'Verification Service'
3 - Stalled during 'Verification Service'
4 - Stalled during 'Verifying'
5 - OK
6 - OK
7 - Stalled during 'Verifying'
8 - OK
9 - OK
10 - OK
11 - OK
12 - Stalled during 'Verification Service'
13 - OK
14 - OK
15 - Stalled during 'Verification Service'
16 - Stalled during 'Verification Service'
17 - Stalled during 'Verification Service'
18 - Stalled during 'Verification Service'
19 - Stalled during 'Verifying'
20 - OK

SQLite v3625 Windows 8.1

[Hert]

It starts with these processes??? Very odd.
That means that these are pending jobs.

Did you try to let it run to complete and not kill it? Are you sure it’s stalled? Did you check processor usage?

[Mke]

As the services running more-or-less coincided with V6 - I couldn't swear that it was at exactly the same time - I had assumed that it was a new function. When it starts without hanging it still runs those two services, but only for a couple of seconds while the interface settles.

I've tried leaving it with both services 'running' - for 15 minutes in the example below - but it seems entirely inactive.
.

StallOnStartup2.png (26.85 KiB) Viewed 243 times

.
I also just left it running after the first of those services stopped, with just the second running, for 9 hours overnight. For the first half hour or so it was using CPU at between 7% and 9%. After a couple of hours the CUP had fallen to between 0.1% and 0 (no more than running the progress bar?), where it remained. This morning I was able to click on a couple of images before it became entirely non-responsive.

[Hert]

Can you run this script and share the result:

tnx

Code: Select all

var
  ADs: TDBXOMClientDataSet;
begin
  ADs := PublicCatalog.NewDataset;
  try
    ADs.CommandText := 'select count(*) as idCnt from idJob';
    ADs.OpenSet;

    Say(ADs.FieldValue('idCnt'));

    ADs.CloseSet;
  finally
    PublicCatalog.FreeDataset(ADs);
  end;
end;

[Hert]

Did you get a chance to run this script?