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
This is not the issue of upgrade SERP. But serverip.dat in this case contains the value: 192.168.88.12:1301, so this is local IP of the server with SERP. Anyway I don't understand what do you me...
15:30 14 Jan 2025
Brittany McGrath
reply ...
05:10 14 Jan 2025