> How is sqlbreak() (which I am guessing is used to implement the interrupt functionality in dbaccess) working at the tcp level? Is there some kind of OOB data being sent?
Yes, it uses "TCP Urgent Mechanism", here is a link to the (fairly old) RFC doc:
https://datatracker.ietf.org/doc/html/rfc6093
------------------------------
Vladimir Kolobrodov
------------------------------
Original Message:
Sent: Thu December 08, 2022 09:00 AM
From: Øyvind Gjerstad
Subject: Unable to interrupt SQL queries in some cases
We have some problems where we are not able to interrupt queries in dbaccess with certain combinations of clients and servers. Could it be due to some traffic passing a firewall in the network? How is sqlbreak() (which I am guessing is used to implement the interrupt functionality in dbaccess) working at the tcp level? Is there some kind of OOB data being sent?
This is with IDS 14.10.FC7, RHEL 8.4 on server side, dbaccess 14.10.FC1, Linux RHEL 7.9 on client side.
I suspect we only see this if the traffic passes through a firewall, because this does not affect all combinations of clients and servers.
------------------------------
Øyvind Gjerstad
Developer/Architect
PostNord AS
------------------------------
#Informix