[WD27] 64 bit Service hangs randomly

Re: [WD27] 64 bit Service hangs randomly

Michael Drechsel — Wed, 17 May 2023 11:24:56 +0200

OK, I solved it. In one of my functions I used Error() , I Looks Like the Service stops then.

Re: [WD27] 64 bit Service hangs randomly

mixgh — Tue, 16 May 2023 14:49:05 +0200

I had something similar and even though I made sure I cleaned up memory it would still hang after a while. So I put in code to let it shutdown after 12 hours and configured the scheduler to restart it soon after that.

Since then, for anything that has to be run at 5-minute intervals or more, I use the scheduler. Your case can be a combination.

issah

Re: [WD27] 64 bit Service hangs randomly

Michael Drechsel — Mon, 08 May 2023 14:00:42 +0200

HI Guenther,

its a virtual machine in a cluster of 3 hosts, with all UPS and so on.

Re: [WD27] 64 bit Service hangs randomly

gpredl — Mon, 08 May 2023 06:49:59 +0200

Hi Michael, random errors out of nowhere, just my ... lots of our customers are bakeries and they have big refrigerators for their goods, air conditioners, deep freezers and so on. Whenever such a machine starts, it sends a short series of spikes into the mains and into their computers. I don't leave house anymore for those rather frequent complaints, I just recommend buying a UPS (= USV) for connecting the computer. Regularily, those errors are gone with this cure.

Re: [WD27] 64 bit Service hangs randomly

Michael Drechsel — Sun, 07 May 2023 22:47:45 +0200

Hi AI,

hCloseconnection I already used and I put HClose() in the code.

PLz cross the fingers that it works.

thx

Re: [WD27] 64 bit Service hangs randomly

Al — Sun, 07 May 2023 17:14:57 +0200

Hello Michael,

Is it time to try crazy options like a periodic HClose(myfile) and/or HCloseConnection() and then re-open the file or connection.
The refresh may work or if they fail, you might get an actual error message.

Regards
Al

Re: [WD27] 64 bit Service hangs randomly

Michael Drechsel — Sun, 07 May 2023 16:48:51 +0200

marcov Wrote:
-------------------------------------------------------

> works seamlessly with an attached database?

Yes.

It´s a funfact. I have another service (also WD27) running at the same machine which works perfect without any issues 24*7.

I don´t know what the problem is.

Meanwhile I found out (with my little logfile) that it hangs (when it hangs) always at the same point, after a

hreadfirst (myfile).

It runs 2 days and then ***bang**** it crashes. Memory consumption ~1,2 MB. No errors, no execeptions.

Re: [WD27] 64 bit Service hangs randomly

gpredl — Fri, 05 May 2023 10:56:50 +0200

Hi marcov,

did you inform PC Soft Free Tech Support? If so, what did they say?

Re: [WD27] 64 bit Service hangs randomly

marcov — Fri, 05 May 2023 10:27:55 +0200

hi,

i've been struggling for weeks with a similar problem, WD26/27/28 seems to lose connection to mysql after 1-2 days of service work, i had to add everywhere on error EndService(esFailure)
so the service can be restarted automatically using the windows features.
Does anyone have experience with a service that works seamlessly with an attached database?

Re: [WD27] 64 bit Service hangs randomly

Michael Drechsel — Tue, 02 May 2023 16:48:42 +0200

Hi Guenter,

its WD27, no memory leak.

Re: [WD27] 64 bit Service hangs randomly

Michael Drechsel — Tue, 02 May 2023 16:47:56 +0200

JP Wrote:
-------------------------------------------------------
> If possible could you write a simple log file
> (text file) of the key steps in the service
> program. At each key step, update the log with the
> step name, date, and time. And possibly other info
> like memory etc. This will then show you exactly
> where the service is hanging up, i.e. what the
> last thing it could do was done. I use logs that
> write both the before-action-entry and an
> after-action entry so I can be sure which action
> was started but not completed.

Yes, that was indeed my next idea. I found a way to activate a logging without change the program:

I found this in the help:

Activation without modifying the application, via a specific fileTo do so, create a file named .WX beside the executable of the application. This file must contain the following lines:

[LOG]
Active=<0/1>
File=
Option=

Has anybody experience with that ? I can´t get it to work, no file has created.

Re: [WD27] 64 bit Service hangs randomly

JP — Tue, 02 May 2023 16:14:19 +0200

If possible could you write a simple log file (text file) of the key steps in the service program. At each key step, update the log with the step name, date, and time. And possibly other info like memory etc. This will then show you exactly where the service is hanging up, i.e. what the last thing it could do was done. I use logs that write both the before-action-entry and an after-action entry so I can be sure which action was started but not completed.

Re: [WD27] 64 bit Service hangs randomly

gpredl — Tue, 02 May 2023 16:05:19 +0200

Hi Michael,

is it a memory leak?? Which version of WINDEV?

[WD27] 64 bit Service hangs randomly

Michael Drechsel — Tue, 02 May 2023 13:29:06 +0200

Hi,

I have build a 64 bit service at a windows server 2012 r2.

Most of the time it does nothing. It runs every 10 seconds and check some values.

Unfortunately it hangs after 1 or 2 days. A restart of the service fails, I have to kill the process before.

I tried everythink without luck. And I have no idea how to debug the issue.

Any ideas ?