Maintenance hangs server
David Smerdel
4-3-18
Hello

Since updating a customer to 8.4, there are problems with one of the maintenances they are using.
There is a maintenance which reads some data from one (or more) files and creates some records in the database.
It worked flawlessly in 8.3, but now it hangs the server when it finishes its work.

Looking at hansa.log, it even gets as far as writing "Duration 0.37 seconds" in the log, the files get deleted (as per code)....afterwards, the server stops responding. It can be restarted normally (meaning, without resorting to kill -9).

If it can't find any files to process, nothing happens and the server doesn't hang.

Has there been some fundamental change in 8.4, or is this a bug?

The code goes something like this:

global
updating procedure GetSomeDataMn()
begin
record DataVc DAr;

OpenFile("datafile.txt");
while (TestEOF==false) begin

    RecordNew(DAr);
//some code for filling the record
    RecordStore(DAr,true);

if (NextImportLine(true)) then begin end;
end;
CloseFile;
Delete_file("datafile.txt");
   
return;
end;
Leave Comment
You can subscribe to notifications for this post by selecting the 'star' icon on the top right corner of the post.
Latest Posts
Piotr Wycichowski
Is it something when a user tried to use any of AI commands in SERP? /Piotr W....
10:07 8 Nov 2024
Brittany McGrath
Thank you for your post Lilian. I see this post has been submitted twice and the second post is being addressed so I will close this duplicate. Thank you. ...
09:41 5 Nov 2024