Stalling frequently on startup (not-responding)

Post Reply
Mke
Posts: 578
Joined: 15 Jun 14 15:39

Stalling frequently on startup (not-responding)

Post by Mke » 25 Mar 21 17:44

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
StallOnStartup .png (7.17 KiB) Viewed 298 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
Posts: 6775
Joined: 13 Sep 03 7:24

Re: Stalling frequently on startup (not-responding)

Post by Hert » 25 Mar 21 21:59

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
Posts: 578
Joined: 15 Jun 14 15:39

Re: Stalling frequently on startup (not-responding)

Post by Mke » 26 Mar 21 11:18

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
StallOnStartup2.png (26.85 KiB) Viewed 242 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
Posts: 6775
Joined: 13 Sep 03 7:24

Re: Stalling frequently on startup (not-responding)

Post by Hert » 26 Mar 21 12:49

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
Posts: 6775
Joined: 13 Sep 03 7:24

Re: Stalling frequently on startup (not-responding)

Post by Hert » 02 Apr 21 12:02

Did you get a chance to run this script?

Post Reply