Progress 9.1C : Server blocked during 10 mns

[Arnaud]

Hello,

On a server progress (9.1c), a process block a server every morning, at 7:35 AM exactly.
At this moment, the cpu usage is near 100%.
And, I don't know how to know what happen.
During this block, all users can't access to progress database.
And this, every morning.
Logs says :
06:30:08 SRV 2: Démarré sur le port 3006 utilisant tcp, pid 349. (5646)
It is this pid who takes all ressource at 7:35am.
But, in logs, nothing at 7:35.

An idea ?
Thanks,
Arnaud

 

[yz6x]

Hi Arnaud,

Since you have already identified the process being
responsible for the increase of the CPU load :
-> 06:30:08 SRV 2: Démarré sur le port 3006 utilisant tcp, pid 349. (5646)
it is important to know what this process is...
This is the remote server process which is being started by the
database broker process on the incoming remote client connection request.
What happened is that there was an Progress session either started
by some interactive client, or a batch process (perhaps started through
cron, or Windows scheduller - you didn't specify the OS) that connected
to the database as the remote client (therefore using -H -S ).
That session started executing some queries or massive updates that
caused this remote server to peak with CPU usage. If you take a look into
the database log file, then you should be able to see which users were
connected to the SRV2 within that time frame and that should give you
a good start in determining what is causing this behavior.

HTH

 

[Arnaud]

Hello,

Thanks for this response.
I will try to determine the cause of this thing.
Good day,