Hello everyone.
I was trying to run some heavy Genero 4GL jobs on the DB server via a shared memory connection.

Some ran fine but other jobs crashed almost immedately (while in a cursor loop) with error

$ finderr -25587
-25587    Network receive failed.

A system call has failed. Perform a DISCONNECT and then check the
status of the server. See the system administrator for assistance.

What does this mean when using a shmem connection? 
It looks like the application was disconnected?

Thx in advance,
-S

------------------------------
Snorri Bergmann
------------------------------

No, nothing in online.log.

------------------------------
Snorri Bergmann
------------------------------

Original Message:
Sent: Wed December 18, 2024 07:22 AM
From: Marcus Haarmann
Subject: Error -25587 using a shared memory connection.

Anything in online.log ?

MARCUS HAARMANN

Weird, and 25587 apparently being a rare error.

Any signs of sessions having been terminated (onmode -z, maybe induced by some server side config - session limit)?

------------------------------
Andreas Legner
Informix Dev
HCL Software
------------------------------

Thanks Andreas.
No, there are no signs of onmode -z and there are no session limits whatsoever.

I am now running one job locally via onsoctcp. It seems much faster than from a different client machine.
Will I see major performance benefits with shared mem compared to that?

------------------------------
Snorri Bergmann
------------------------------

Original Message:
Sent: Wed December 18, 2024 07:58 AM
From: Andreas Legner
Subject: Error -25587 using a shared memory connection.

Weird, and 25587 apparently being a rare error.

Any signs of sessions having been terminated (onmode -z, maybe induced by some server side config - session limit)?

------------------------------
Andreas Legner
Informix Dev
HCL Software
------------------------------

Just in case, check if you've defined QUERY_TIMEOUT environment session option. This can close sessions automativaly.

QUERY_TIMEOUT session environment option

Ibm		remove preview
QUERY_TIMEOUT session environment option Use the QUERY_TIMEOUT environment option of the SET ENVIRONMENT statement to limit the amount of clock time a query may take before being interrupted internally. View this on Ibm >

------------------------------
Vicente Salvador Cubedo
Software Architect
DEISTER, S.A.
Barcelona
+34 932063298
------------------------------

Original Message:
Sent: Wed December 18, 2024 08:34 AM
From: Snorri Bergmann
Subject: Error -25587 using a shared memory connection.

Thanks Andreas.
No, there are no signs of onmode -z and there are no session limits whatsoever.

I am now running one job locally via onsoctcp. It seems much faster than from a different client machine.
Will I see major performance benefits with shared mem compared to that?

------------------------------
Snorri Bergmann
------------------------------


Original Message:
Sent: Wed December 18, 2024 07:58 AM
From: Andreas Legner
Subject: Error -25587 using a shared memory connection.

Weird, and 25587 apparently being a rare error.

Any signs of sessions having been terminated (onmode -z, maybe induced by some server side config - session limit)?

------------------------------
Andreas Legner
Informix Dev
HCL Software

Thanks Vicente.

No, this parameter is not set at all. 

Regs,

-S

------------------------------
Snorri Bergmann
------------------------------

Original Message:
Sent: Thu December 19, 2024 04:42 AM
From: Vicente Salvador Cubedo
Subject: Error -25587 using a shared memory connection.

Just in case, check if you've defined QUERY_TIMEOUT environment session option. This can close sessions automativaly.

QUERY_TIMEOUT session environment option

Ibm		remove preview
QUERY_TIMEOUT session environment option Use the QUERY_TIMEOUT environment option of the SET ENVIRONMENT statement to limit the amount of clock time a query may take before being interrupted internally. View this on Ibm >

------------------------------
Vicente Salvador Cubedo
Software Architect
DEISTER, S.A.
Barcelona
+34 932063298
------------------------------


Original Message:
Sent: Wed December 18, 2024 08:34 AM
From: Snorri Bergmann
Subject: Error -25587 using a shared memory connection.

Thanks Andreas.
No, there are no signs of onmode -z and there are no session limits whatsoever.

I am now running one job locally via onsoctcp. It seems much faster than from a different client machine.
Will I see major performance benefits with shared mem compared to that?

------------------------------
Snorri Bergmann


Original Message:
Sent: Wed December 18, 2024 07:58 AM
From: Andreas Legner
Subject: Error -25587 using a shared memory connection.

Weird, and 25587 apparently being a rare error.

Any signs of sessions having been terminated (onmode -z, maybe induced by some server side config - session limit)?

------------------------------
Andreas Legner
Informix Dev
HCL Software

No "mode" needs to be turned ON
This is NOT a connectivity setting issue

It's almost certainly:  Server-side resource exhaustion or session termination during heavy processing

------------------------------
Salomi Gaddam
------------------------------

Original Message:
Sent: Wed December 18, 2024 08:17 AM
From: Paul Watson
Subject: Error -25587 using a shared memory connection.

Can you onmode -I 25587 ?

Cheers

Paul

Paul Watson

Oninit LLC

+1-913-387-7529

www.oninit.com

Oninit®️ is a registered trademark of Oninit LLC