Re: Server Process "Frozen"-ish

Thanks, Jeff. -- Cannon.Smith Synergy Farm Solutions Inc. Hill Spring, AB Canada 403-626-3236 > On Oct 27, 2017, at 1:02 PM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Ours are normal, non-built servers.

Re: Server Process "Frozen"-ish

Ours are normal, non-built servers. -- Jeffrey Kain jeffrey.k...@gmail.com > On Oct 27, 2017, at 2:02 PM, Cannon Smith via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > For those that have experiences this issue, has anyone experienced it on a > server that wasn’t a “built” server? All mine are

Re: Server Process "Frozen"-ish

For those that have experiences this issue, has anyone experienced it on a server that wasn’t a “built” server? All mine are built servers. -- Cannon.Smith Synergy Farm Solutions Inc. Hill Spring, AB Canada 403-626-3236

Re: Server Process "Frozen"-ish

We had another server do this this morning. It had stopped on DELAY PROCESS again, so I tried the RESUME PROCESS idea. It did get the process going again. However, some of the Administration Window UI was not updating properly. After the process resumed, the UI still didn’t update properly so

Re: Server Process "Frozen"-ish

Yes. On Oct 27, 2017, at 3:23 AM, Epperlein, Lutz (agendo) via 4D_Tech <4d_tech@lists.4d.com> wrote: >> I am confident that 4D will find this bug and get it fixed. If it takes 6 >> months, then my >> upgrade plans will be on hold for 6 months. I’m in no hurry to upgrade right >> now. > > Is

RE: Server Process "Frozen"-ish

> I am confident that 4D will find this bug and get it fixed. If it takes 6 > months, then my > upgrade plans will be on hold for 6 months. I’m in no hurry to upgrade right > now. Is there a case (TAOW or anywhere) in progress? I'm afraid that this discussion on the list doesn't lead to a

Re: Server Process "Frozen"-ish

On Oct 26, 2017, at 1:48 PM, David Conley wrote: > FWIW, I’ve implemented a method which issues a resume process command for > each of my stored procedures. I invoke it via a new process command using > the On Backup Shutdown command. My backups run once per day so it gives me a > clean way

Re: Server Process "Frozen"-ish

That's pretty clever. On Thu, Oct 26, 2017 at 7:35 AM, BTB-David via 4D_Tech <4d_tech@lists.4d.com > wrote: > Tim, > > FWIW, I’ve implemented a method which issues a resume process command for > each of my stored procedures. I invoke it via a new process command using > the On Backup Shutdown

Re: Server Process "Frozen"-ish

Tim, FWIW, I’ve implemented a method which issues a resume process command for each of my stored procedures. I invoke it via a new process command using the On Backup Shutdown command. My backups run once per day so it gives me a clean way of resuming those procedures each day after the

Re: Server Process "Frozen"-ish

On Thu, Oct 26, 2017 at 7:45 AM, Timothy Penner via 4D_Tech < 4d_tech@lists.4d.com> wrote: Thanks for chiming in. Given the number and nature of the people reporting this bug, it's clearly a real bug. Can you give us some insight into what efforts 4D is making internally to track this down and

Re: Server Process "Frozen"-ish

On Oct 25, 2017, at 3:45 PM, Timothy Penner wrote: > I just want to add that one of the main benefits of the Forums > (http://forums.4d.com) is that it is also used by the 4D Engineers and they > do monitor, read, and participate in the discussions. So posting on the > forums

RE: Server Process "Frozen"-ish

Hi Tim, > This is how a programming forum is supposed to work. People contributing > ideas and sharing experiences. I think we are getting close to nailing down > where 4D engineers need to look to solve this problem. > I just want to add that one of the main benefits of the Forums

Re: Server Process "Frozen"-ish

> On Oct 25, 2017, at 6:55 AM, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> > wrote: > >> Anyway, I'm wondering if the problem is when either Tickcount, Milliseconds >> or another internal 4D time measure overflows into negative territory. I >> have no idea internally what measure 4D uses

Re: Server Process "Frozen"-ish

On Oct 25, 2017, at 11:38 AM, Keith White wrote: > Wondered if you saw my guess/conjecture previously posted on this subject > (not that it's much help !)...:- > > OK, so we think this is due to DELAY PROCESS. > > The change to DELAY PROCESS somewhere in 4D v15 was to change from a Longint >

Re: Server Process "Frozen"-ish

I went to another machine and found out some more info. This appears to be a random problem which makes it difficult to reproduce and track down. Here is what I can summarize on the problem: 1) There isn’t a direct correlation to the Server UI window becoming unresponsive vs the delay process

Re: Server Process "Frozen"-ish

Interesting. I did some more digging and here is what I’ve found. I have 13 Macs that run up to 10 databases on each machine of differing 4D versions (usually 4Dv13.4, 4Dv15R5 and 4Dv16.0) - all are 32 bit. I focused on 2. Machine 1 - uptime 158 days I have 10 databases running on this

Re: Server Process "Frozen"-ish

Did you also see the 4D Server UI stop updating? I'm referring to the server monitor user interface that graphs the CPU time, etc. When this has happened to our mirror servers, those graphs stop updating. The server can still be manipulated, but those graphs don't update and the stored

Re: Server Process "Frozen"-ish

Hi Keith, Yes, that’s why I was curious about the machine up time. It would be curious if it was close to 24.86 days, for example. -- Cannon.Smith Synergy Farm Solutions Inc. Hill Spring, AB Canada 403-626-3236 > On Oct 25, 2017, at 8:34 AM, Keith White via

Re: Server Process "Frozen"-ish

Hi David and Canon Wondered if you saw my guess/conjecture previously posted on this subject (not that it's much help !)...:- OK, so we think this is due to DELAY PROCESS. The change to DELAY PROCESS somewhere in 4D v15 was to change from a Longint to Real. But the problems didn't start

Re: Server Process "Frozen"-ish

Hi David, Good to have more information—thanks! I’m curious, do you know what the machine up time was when it stalled? Thanks. -- Cannon.Smith Synergy Farm Solutions Inc. Hill Spring, AB Canada 403-626-3236 > On Oct 25, 2017, at 7:57 AM, BTB-David via

Re: Server Process "Frozen"-ish

I can confirm that this is caused by the delay process. In fact, all of my server processes that use delay process stopped on the same day. They had different levels of delay times set. As per your suggestion, I went into Runtime Explorer on the Server and typed resume process (pid) and they

Re: Server Process "Frozen"-ish

Hi OK, so we think this is due to DELAY PROCESS. The change to DELAY PROCESS somewhere in 4D v15 was to change from a Longint to Real. But the problems didn't start until v16, I think that's right. Anyway, I'm wondering if the problem is when either Tickcount, Milliseconds or another

Re: Server Process "Frozen"-ish

Thanks Jeff and Bernd. -- Cannon.Smith Synergy Farm Solutions Inc. Hill Spring, AB Canada 403-626-3236 > On Oct 19, 2017, at 12:24 AM, Bernd Fröhlich via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Almost exactly the same setup over here.

Re: Server Process "Frozen"-ish

Hey Cannon - we had this happen twice last week... once each on our two mirror servers a few days apart. The journal integration stored procedure wakes up every 60 seconds and integrates whatever files have accumulated. This just stopped. Also the 4D Server animated user interface for CPU use

RE: Server Process "Frozen"-ish

Hi Cannon, If I am reading this correctly, you have a process that was delayed using DELAY PROCESS and it should have already woken up after 1 second but it was still delayed several hours later - is that right? Not sure if this will help you at all, but if you can locate the process number

Re: Server Process "Frozen"-ish

I _could_ try that. But my turn around time to send a new build to customers is measured in months. And if I only try this with one customer’s server, it may not happen for weeks. How would I know if it solved it? The trouble with this particular bug is that it has been very hard to reproduce.

Re: Server Process "Frozen"-ish

On Oct 18, 2017, at 5:54 PM, Cannon Smith wrote: > Just an update on this issue. Last week I was able to release a new version > of our software to all of our customers and I included some extra logging for > this issue. Yesterday we had a customer report the problem. Here’s what I > found. >

Re: Server Process "Frozen"-ish

Cannon, Thanks for being so systematic about tracking down this problem and keeping the list informed. ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html

Re: Server Process "Frozen"-ish

Just an update on this issue. Last week I was able to release a new version of our software to all of our customers and I included some extra logging for this issue. Yesterday we had a customer report the problem. Here’s what I found. First, a bit about the process that I’ve seen freeze the

Re: Server Process "Frozen"-ish

Dani, We’ve had the same problem. After switching from v15 to v16 (both 64bit) the server crashed regularly upon creation of PDF documents with PDF Creator. We planned to move the batch generation of those pdf docs to a separate client, but forgot to change some settings causing some types of

Re: Server Process "Frozen"-ish

This one in particular may take awhile. It took about 16 days for us to see the issue for the first time. Who knows when it will happen again? So more people watching for this issue should shorten the amount of time needed to get this identified. -- Jeffrey Kain jeffrey.k...@gmail.com > On

Re: Server Process "Frozen"-ish

On Sep 15, 2017, at 2:00 PM, Jeffrey Kain wrote: > I opened a case on the taow today - just FYI. I forgot to say that in my last post. I think this is the best way to handle this bug. If they have a half dozen cases opened all with the same problem, that should make them take notice. So

Re: Server Process "Frozen"-ish

> On Sep 14, 2017, at 7:05 PM, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > This is a big problem that must get addressed and fixed or it will do harm to > v16’s reputation. I was planning on upgrading one of my clients to v16 in a > few months. That is not going to happen now.

Re: Server Process "Frozen"-ish

I opened a case on the taow today - just FYI. > On Sep 14, 2017, at 8:05 PM, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Then I’d call and speak to Add and get him involved in this. He knows you. > And you can tell him that others — like Jeff Kain — are experiencing the same >

Re: Server Process "Frozen"-ish

On Sep 14, 2017, at 2:00 PM, Cannon Smith wrote: > Hmm, v16.2 eh? There goes our hope that it was fixed in that version. > > Is anyone having this happen regularly enough that they can turn on some > logging to see, for example, what the last command that ran was? Hi Cannon, I’d called 4D

Re: Server Process "Frozen"-ish

Hmm, v16.2 eh? There goes our hope that it was fixed in that version. Is anyone having this happen regularly enough that they can turn on some logging to see, for example, what the last command that ran was? -- Cannon.Smith Synergy Farm Solutions Inc. Hill Spring, AB Canada 403-626-3236

Re: Server Process "Frozen"-ish

> Le 14 sept. 2017 à 03:58, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > Houston, er, Clichy -- we have a problem here. Call Le Pecq, they left Clichy from a while ;-) -- Arnaud de Montard ** 4D

Re: Server Process "Frozen"-ish

Cannon Smith: > Thanks for the idea. I did try that before to see if I could jumpstart the > process, but unfortunately it doesn’t work. 4D thinks the process is already > there. And it it there. It just doesn’t seem to be executing. Yep, same here. I do have a method that would start the

Re: Server Process "Frozen"-ish

Just saw this happen to our production server tonight. We have a stored procedure that simply calls New Log File every few minutes. About an hour ago it just stopped working. The process is still there in the process list, and nothing else seems wrong with the server, but this very simple stored

Re: Server Process "Frozen"-ish

Steve, I have a few that I've been running for a long time. #1 is a method that manages sending emails. Emails created by users and the system go into a que and then are sent by the server. The method just sits and runs every few minutes. Another one runs every few minutes to update the current

RE: Server Process "Frozen"-ish

On Sep 13, 2017, at 4:48 PM, Stephen J. Orth wrote: > I've given up trying to write and use stored procedures, the Server is just > too fragile. I'd be open to anyone telling me you can really use stored > procedures in a "hard core" way without completely killing all connected > users

Re: Server Process "Frozen"-ish

er 13, 2017 3:34 PM > To: 4D iNug Technical <4d_tech@lists.4d.com> > Cc: Arnaud de Montard <arn...@init5.fr> > Subject: Re: Server Process "Frozen"-ish > > >> Le 13 sept. 2017 à 18:46, Nigel Greenlee via 4D_Tech <4d_tech@lists.4d.com> >>

RE: Server Process "Frozen"-ish

n...@lists.4d.com] On Behalf Of Arnaud de Montard via 4D_Tech Sent: Wednesday, September 13, 2017 3:34 PM To: 4D iNug Technical <4d_tech@lists.4d.com> Cc: Arnaud de Montard <arn...@init5.fr> Subject: Re: Server Process "Frozen"-ish > Le 13 sept. 2017 à 18:46, Nigel Greenle

Re: Server Process "Frozen"-ish

> Le 13 sept. 2017 à 18:46, Nigel Greenlee via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > [...] > > Just a workaround suggestion.. I use something very similar (a table describing what job to do + when to start). From the ages were I understood that I was unable to write an error free

Re: Server Process "Frozen"-ish

Hi Nigel, Thanks for the idea. I did try that before to see if I could jumpstart the process, but unfortunately it doesn’t work. 4D thinks the process is already there. And it it there. It just doesn’t seem to be executing. -- Cannon.Smith Synergy Farm Solutions Inc. Hill Spring, AB Canada

Re: Server Process "Frozen"-ish

I have server side processes that run in the background. Because i like to start as little as necessary at startup my code ‘automatically’ starts the process. So in my code(where it writes the jobs into a table for the server to process). After the client side(or server side) has written a

Re: Server Process "Frozen"-ish

Old network layer on the Windows platform. That’s where most of it is happening. There is about 35 servers involved. New network layer on the Mac platform (different product). Just one server—it’s just an in house database. -- Cannon.Smith Synergy Farm Solutions Inc. Hill Spring, AB Canada

Re: Server Process "Frozen"-ish

Hi, We have run into issues where the server is running on windows 64bit and it is producing PDFs using PDF Creator directly. Our solution was to move away from doing that and using php and FPDF to create the PDFs instead. Dani > On Sep 11, 2017, at 12:43 AM, Bernd Fröhlich via 4D_Tech >

Re: Server Process "Frozen"-ish

Cannon Smith: > I’ve seen something odd since upgrading our customers to v16.1 a few months > ago. This is on 64-bit server, both platforms. There are a few background > processes that continually run on the servers, waking up every few seconds to > see if there is work to be done. This has

Re: Server Process "Frozen"-ish

On Sep 8, 2017, at 5:05 PM, Cannon Smith via 4D_Tech <4d_tech@lists.4d.com> wrote: > > I’ve seen something odd since upgrading our customers to v16.1 a few months > ago. This is on 64-bit server, both platforms. There are a few background > processes that continually run on the servers, waking

Re: Server Process "Frozen"-ish

New network layer on both platforms? > On Sep 8, 2017, at 5:05 PM, Cannon Smith via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I’ve seen something odd since upgrading our customers to v16.1 a few months > ago. This is on 64-bit server, both platforms.

Re: Server Process "Frozen"-ish

Hi Milan, Thanks for the idea, but no, I’m not using GRAPH anywhere. It isn’t just one particular process that does this, either. I’ve seen three different processes do it—all three different code paths. One just updates a bunch of records, one checks with a web service for a small piece of

Re: Server Process "Frozen"-ish

On Sep 8, 2017, at 23:22, Cannon Smith via 4D_Tech <4d_tech@lists.4d.com> wrote: > > I jumped from v15.x where it was working fine to v16.1. Since you’re at v15 > r5, maybe it was something that was introduced in one of the v15 R releases. Are you using GRAPH command in that process? I handled

Re: Server Process "Frozen"-ish

Okay. I guess it’s nice to know I’m not the only one seeing this. Sorry for you guys, though! :-) -- Cannon.Smith Synergy Farm Solutions Inc. Hill Spring, AB Canada 403-626-3236 > On Sep 8, 2017, at 3:33 PM, BTB-David wrote: > > I would

Re: Server Process "Frozen"-ish

Cannon, I would say about that yes. We have several server processes and only one gets called to our attention for not working. No one complains about the others and I haven’t looked into it to see if they have stopped too and no one noticed or if they are still happily working. I’ve been

Re: Server Process "Frozen"-ish

Steve, I am seeing it in v15R5 as well as v16.0 build 16.209177. We plan on our next release to be on v16.2 but we’re not there yet. Thanks! David Conley By The Book, Inc. Office: 815-234-7530 Direct Line: 815-406-5502 Fax: 815-234-7532 http://www.bythebook.com > On Sep 8, 2017, at 4:23

RE: Server Process "Frozen"-ish

iNug Technical <4d_tech@lists.4d.com> Cc: Stephen J. Orth <s.o...@the-aquila-group.com> Subject: Re: Server Process "Frozen"-ish I jumped from v15.x where it was working fine to v16.1. Since you’re at v15 r5, maybe it was something that was introduced in one of the v15

Re: Server Process "Frozen"-ish

Hi David, How about timing? Just once every two-three months per server like us? Thanks. -- Cannon.Smith Synergy Farm Solutions Inc. Hill Spring, AB Canada 403-626-3236 > On Sep 8, 2017, at 3:19 PM, BTB-David via 4D_Tech <4d_tech@lists.4d.com> > wrote: > >

Re: Server Process "Frozen"-ish

I jumped from v15.x where it was working fine to v16.1. Since you’re at v15 r5, maybe it was something that was introduced in one of the v15 R releases. I haven’t posted anything before because I don’t have much that is concrete, but it has happened enough to know something is going on.

Re: Server Process "Frozen"-ish

We started seeing the same problem when we upgraded to v15R5 too. A process that ran for years on older versions just like Cannon described just stopped doing it’s thing. A reboot resolves it. We are seeing it on 32 bit server Mac & Windows. Thanks! David Conley By The Book, Inc. Office: