On Thursday, May 18, 2023 at 3:36:07 p.m. UTC-4, Eric Bathalon wrote:
> Le jeudi 18 mai 2023 à 14:48:11 UTC-4, Randall a écrit :
> > On Thursday, May 18, 2023 at 1:43:07 p.m. UTC-4, Eric Bathalon wrote:
> > > Le jeudi 18 mai 2023 à 11:33:24 UTC-4, Eric Bathalon a écrit :
> > > > Le jeudi 18 mai 2023 à 11:21:43 UTC-4, Randall a écrit :
> > > > > On Thursday, May 18, 2023 at 8:23:48 a.m. UTC-4, Eric Bathalon wrote:
> > > > > > Le mardi 16 mai 2023 à 08:21:36 UTC-4, Eric Bathalon a écrit :
> > > > > > > Hi all, I am trying make rsync (3.2.4 for the moment) between 2 HPNS
> > > > > > > It works if I use rsync from an ubuntu server to my HPNS.
> > > > > > > It works if I sync locally from the same HPNS to sync 2 directories for example.
> > > > > > > But when I am trying between my 2 HPNS I am still getting either:
> > > > > > >
> > > > > > > rsync: connection unexpectedly closed (0 bytes received so far) [Receiver] rsync error: error in rsync protocol data stream (code 12) at io.c(228) [Receiver=v3.2.4] rsync: connection unexpectedly closed (0 bytes received so far) [sender] rsync error: error in rsync protocol data stream (code 12) at io.c(228) [sender=v3.2.4]
> > > > > > >
> > > > > > > or SSH: rsync: is your shell clean?
> > > > > > >
> > > > > > > Added export SUPPRESSCLIENTBANNER=TRUE to my profile I tried multiple syntax options without success.
> > > > > > >
> > > > > > > If anyone have some hints
> > > > > > > Thanks in advance !
> > > > > > HPNS 1 is running L22.09 with SSH L02_05SEP2022
> > > > > > HPNS 2 is running L20.10 with SSH L02_15OCT2020
> > > > > >
> > > > > > I can connect SSH on both servers using the user IDs I am using to test my rsync with. (Either a super user or an super.super alias) over OutsideView & Putty or from a linux server directly on the OSS side.
> > > > > > The only modification I made is from my linux server that I need to use a .ssh/config to set Ciphers and HostKeyAlgo but outside of that, I can connect via SSH or use SFTP between both HPNS without issues.
> > > > > > I am using the same users for all my tests
> > > > > >
> > > > > > Servers are giving the same errors whatever the role (sender or receiver)
> > > > > > HPNS 1 --> HPNS 2
> > > > > > HPNS 2 --> HPNS 1
> > > > > > same same
> > > > > Are you trying to use rsyncd on the remote HPNS? If so, do you have port forwarding enabled in SSH? Also, have you set the SHELL-ENVIRONMENT for your user? Login shells (putty/outside view/etc..) automatically load your .profile, but other SSH shell connections do not and require the SHELL-ENVIRONMENT to define your env.
> > > > I am not trying to use the Daemon. I will look for the SHELL-ENVIRONMENT I am not sure about that !
> > > I set one for my user on both system pointing for now on /etc/profile ... but same behavior for rsync
> > > I am using the following syntax from hpns1: /usr/bin/rsync --stats --progress -avz -e/usr/bin/ssh -S \$ssh00 /home/super/me/test/* hpns2:/home/super/me/test/
> > I'm not sure about this working. The OpenSSH process has communication issues on NonStop and does not always work - I'm not sure why; however, it also cannot be located in /usr/bin as far as I know, as that is considered a man in the middle potential problem. The object is hard-coded to be in /usr/local/bin/ssh for the 1.0.2q OpenSSL build. You might have more success using NonStop SSH as a client/server in this case. /G/system/zssh/sshoss is the program for the client. You can also go to GNSC directly for help making SSHOSS work.
> There is a misunderstanding. I am using Nonstop builtin SSH and my ssh is a link to /G/system/zssh/sshoss. Anyway, since my path is including /usr/local/bin I move rsync and nonstop ssh under /usr/local/bin/... same result. I am just wondering if it should work between 2 HPNS or it is the same problem that we have with scp that is only working as a server and not as a client...

If you are using NonStop SSH as a client, you should be taking this up with GNSC. Seriously.
. X-Received: by 2002:a05:6214:5609:b0:635:e24b:d5c7 with SMTP id mg9-20020a056214560900b00635e24bd5c7mr1427qvb.1.1688068597117;
Thu, 29 Jun 2023 12:56:37 -0700 (PDT)
X-Received: by 2002:a05:6870:5153:b0:1b0:9d7d:3488 with SMTP id
z19-20020a056870515300b001b09d7d3488mr736717oak.8.1688068596884; Thu, 29 Jun
2023 12:56:36 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!usenet.blueworldhosting.com!diablo1.usenet.blueworldhosting.com!peer02.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.sys.tandem
Date: Thu, 29 Jun 2023 12:56:36 -0700 (PDT)
Injection-Info: google-groups.googlegroups.com; posting-host4.238.179.63; posting-accountg0wAwoAAADOV3gkkdRS8XLUeis767Vq
NNTP-Posting-Host: 134.238.179.63
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <d428e141-ca41-4daa-a169-566ad5de35a2n@googlegroups.com>
Subject: Enscribe File and Slack space
From: "wilso...@gmail.com" <wilsonjohna@gmail.com>
Injection-Date: Thu, 29 Jun 2023 19:56:37 +0000
Content-Type: text/plain; charset="UTF-8"
X-Received-Bytes: 1577
Xref: retrobbs comp.sys.tandem:761

Hi All -

I am curious if anyone can shed some light on how slack space works on a key sequenced Enscribe file. I looked in the manuals and see small references, but not a great explanation.

If slack is removed from a file using something like FUP RELOAD, that appears to reduce the file size. (Smaller files are typically a good thing.)

However, does this also mean that the subsequent writes to that file will now need to allocate blocks of space prior to inserting a record? If so, I would assume this would decrease the disk I/O efficiency?

Thanks for any insights!

.
X-Received: by 2002:ae9:df43:0:b0:767:420d:cec2 with SMTP id t64-20020ae9df43000000b00767420dcec2mr34862qkf.5.1691781329068;
Fri, 11 Aug 2023 12:15:29 -0700 (PDT)
X-Received: by 2002:a17:902:f68f:b0:1bb:cd10:823f with SMTP id
l15-20020a170902f68f00b001bbcd10823fmr1029519plg.5.1691781328682; Fri, 11 Aug
2023 12:15:28 -0700 (PDT)
Path: i2pn2.org!i2pn.org!usenet.blueworldhosting.com!diablo1.usenet.blueworldhosting.com!peer02.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.sys.tandem
Date: Fri, 11 Aug 2023 12:15:28 -0700 (PDT)
Injection-Info: google-groups.googlegroups.com; posting-hoste.125.102.200; posting-account=0NHiHgoAAAC-mY8P0yk1bd3zDKN8t6jB
NNTP-Posting-Host: 65.125.102.200
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <e10c4470-30c4-437b-916e-47ac03f30f43n@googlegroups.com>
Subject: SQL Cursor skipping records
From: =?UTF-8?B?QWRhbSDigJxBZGFtbGl2aW5saWZl4oCdIEthbWFs?= <abolkini@gmail.com>
Injection-Date: Fri, 11 Aug 2023 19:15:29 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
X-Received-Bytes: 2491
Xref: retrobbs comp.sys.tandem:761

I have a SQL cursor that is used to retrieve records from parts table. The program is designed to return no more than 5000 records per read, then it closed the cursor.

In case if there are more records than 5000, it saves off record number 5001 and use it to reopen the cursor and get the rest of the records.

The issue appears to be not all records is returned on the second read.

The cursor look like this

EXEC SQL DECLARE QUERY_PARTS_COUNT CURSOR FOR
SELECT COMPANY
, WAREHOUSE
, REPORT_NUMBER
, SOURCE_OF_SUPPLY
, PART_NUM
, BIN_LOC

FROM =PARTS FOR BROWSE ACCESS
WHERE COMPANY = :SEARCH-COMPANY AND
WAREHOUSE = :SEARCH-WAREHOUSE AND
REPORT_NUMBER = :SEARCH-REPORT-NUMBER AND
SOURCE_OF_SUPPLY >= :SEARCH-SOS AND
PART_NUM >= :SEARCH-PART-NUM AND
BIN_LOC >= :SEARCH-BIN-LOC AND
ORDER BY COMPANY_GROUP, WARE ,REPORT_NUMBER, SOURCE_OF_SUPPLY, PART_NUM, BIN_LOC, ALT_BIN ASC
END-EXEC.

On the second read/Open cursor, it returns the record which was saved off to use it to reopen the cursor. but then it skips a bunch of records. I was hoping someone would be able to tell me what am i doing wrong in the cursor. Thanks in advance and have a wonderful weekend !
. Path: i2pn2.org!i2pn.org!eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From: invalid@nowhere.com (JShepherd)
Newsgroups: comp.sys.tandem
Subject: Re: SQL Cursor skipping records
Date: Wed, 23 Aug 2023 15:44:23 -0000 (UTC)
Organization: A noiseless patient Spider
Lines: 281
Message-ID: <uc59gn$2vq23$1@dont-email.me>
References: <e10c4470-30c4-437b-916e-47ac03f30f43n@googlegroups.com>
<ub6atu$10fds$1@dont-email.me> <9c035799-1510-429d-ab35-0bc674f0449dn@googlegroups.com>
<ubgdpo$2tng1$1@dont-email.me> <3a8f4387-ed26-450b-81d3-871223d45198n@googlegroups.com>
<ubmeb2$3v5si$1@dont-email.me> <14f52dfa-a677-4f2d-b5a7-19847b68d565n@googlegroups.com>
MIME-Version: 1.0
Content-Type: Text/Plain; charset=US-ASCII
Injection-Date: Wed, 23 Aug 2023 15:44:23 -0000 (UTC)
Injection-Info: dont-email.me; posting-host="07d28896b1a59a721a16cb38794bfc22";
logging-data="3139651"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX19Z172aN9VN9S5xfpM+Dj+kU1ncfXpU3EY="
Cancel-Lock: sha1:dO6O6OsgJwPbXouBMPI6Wge46d8Xref: retrobbs comp.sys.tandem:761

In article <14f52dfa-a677-4f2d-b5a7-19847b68d565n@googlegroups.com>,
abolkini@gmail.com says...
>
>On Thursday, August 17, 2023 at 5:34:45 PM UTC-7, JShepherd wrote:
>> In article <3a8f4387-ed26-450b...@googlegroups.com>,
>> abol...@gmail.com says...
>> >
>> >On Tuesday, August 15, 2023 at 10:48:43=E2=80=AFAM UTC-7, JShepher>d wrote:
>> >> In article <9c035799-1510-429d...@googlegroups.com>,=20
>> >> abol...@gmail.com says...=20
>> >> >=20
>> >> >On Friday, August 11, 2023 at 2:59:09=3DE2=3D80=3DAFPM UTC-7, J>Shepherd =
>> >wrote:=20
>> >> >> In article <e10c4470-30c4-437b...@googlegroups.com>,=3D20=20
>> >> >> abol...@gmail.com says...=3D20=20
>> >> >> >=3D20=20
>> >> >> >I have a SQL cursor that is used to retrieve records from parts ta>ble=
>> >. T=3D=20
>> >> >he =3D3D=3D20=20
>> >> >> >program is designed to return no more than 5000 records per read, >the=
>> >n i=3D=20
>> >> >t c=3D3D=3D20=20
>> >> >> >losed the cursor.=3D3D20=3D20=20
>> >> >> >=3D20=20
>> >> >> >In case if there are more records than 5000, it saves off record n>umb=
>> >er =3D=20
>> >> >500=3D3D=20
>> >> >> >1 and use it to reopen the cursor and get the rest of the records.>=3D=
>> >20=20
>> >> >> >=3D20=20
>> >> >> >The issue appears to be not all records is returned on the second >rea=
>> >d.=3D=20
>> >> >=3D20=20
>> >> >> >=3D20=20
>> >> >> >The cursor look like this=3D20=20
>> >> >> >=3D20
>> >> >> >EXEC SQL DECLARE QUERY_PARTS_COUNT CURSOR FOR
>> >> >> > SELECT COMPANY=3D3D20=20
>> >> >> > , WAREHOUSE=3D20=20
>> >> >> > , REPORT_NUMBER=3D20=20
>> >> >> > , SOURCE_OF_SUPPLY=3D20=20
>> >> >> > , PART_NUM=3D20=20
>> >> >> > , BIN_LOC=3D20=20
>> >> >> >=20
>> >> >> > FROM =3D3D3DPARTS FOR BROWSE ACCESS=3D20=20
>> >> >> > WHERE COMPANY =3D3D3D :SEARCH-COMPANY AND=3D20=20
>> >> >> > WAREHOUSE =3D3D3D :SEARCH-WAREHOUSE AND=3D20=20
>> >> >> > REPORT_NUMBER =3D3D3D :SEARCH-REPORT-NUMBER AND=3D20=20
>> >> >> > SOURCE_OF_SUPPLY >=3D3D3D :SEARCH-SOS AND=3D20=20
>> >> >> > PART_NUM >=3D3D3D :SEARCH-PART-NUM AND=3D20=20
>> >> >> > BIN_LOC >=3D3D3D :SEARCH-BIN-LOC AND=3D20=20
>> >> >> > ORDER BY COMPANY_GROUP, WARE ,REPORT_NUMBER, SOURCE_OF_SUPPLY, PA>RT_=
>> >NUM=3D=20
>> >> >,=3D3D=3D20=20
>> >> >> > BIN_LOC, ALT_BIN ASC=3D20=20
>> >> >> > END-EXEC.=3D20=20
>> >> >> >=3D20
>> >> >> >On the second read/Open cursor, it returns the record which was sa>ved=
>> > of=3D=20
>> >> >f =3D3D=3D20=20
>> >> >> >to use it to reopen the cursor. but then it skips a bunch of recor>ds.=
>> > I =3D=20
>> >> >was=3D3D=3D20=20
>> >> >> > hoping someone would be able to tell me what am i doing wrong in >the=
>> > cu=3D=20
>> >> >rso=3D3D
>> >> >> >r. Thanks in advance and have a wonderful weekend !
>> >> >> The where clause shown seems to end with "AND ORDER BY <col list>">=3D2=
>> >0=20
>> >> >>=3D20=20
>> >> >> What are the keycols for the table ?=3D20=20
>> >> >>=3D20
>> >> >> What does an explain plan for the statement show ?=20
>> >> >=20
>> >> >Happy Monday,=20
>> >> >
>> >> >Thanks for taking the time to reply back. The key is the selected col>umn=
>> >s=3D=20
>> >> >=3D20=20
>> >> > COMPANY NUMERIC( 2, 0) UNSIGNED NO DEFAULT NO=3D
>> >> >T NULL=20
>> >> > , WARE CHAR(3) NO DEFAULT NOT NULL=20
>> >> > , REPORT_NUMBER NUMERIC( 9, 0) UNSIGNED NO DEFAULT NOT NULL=20
>> >> > , SOURCE_OF_SUPPLY CHAR(2) NO DEFAULT NOT NULL=20
>> >> > , PART_NUM CHAR(30) NO DEFAULT NOT NULL=20
>> >> > , BIN_LOC CHAR(9) NO DEFAULT NOT NULL=20
>> >> >=20
>> >> >
>> >> >Since you brought up the ORDER BY and explain plan, I noticed the key> of=
>> > th=3D=20
>> >> >e table is in ascending order and exactly is my ORDER BY columns, so >I r=
>> >emo=3D=20
>> >> >ved ORDER BY from the cursor but It still skipped records.=3D20
>> >> >=20
>> >> >Here is EXPLAIN plan:=20
>> >> >=20
>> >> > Operation 1.0 : Scan=20
>> >> > Table PARTS=20
>> >> > with correlation name PARTS=20
>> >> > Access type : No locks, browse access=20
>> >> > Lock mode : Chosen by the system=20
>> >> > Column processing : Requires retrieval of 19 out of 20 columns
>> >> >=3D20
>> >> > Access path 1 : Primary, sequential cache=20
>> >> > SBB for reads : Virtual, double buffer
>> >> > Begin key pred. : COMPANY=3D3D :SEARCH-COMPANY , WARE =3D3D :SEA>RCH-WAR=
>> >=3D=20
>> >> >E ,=3D20=20
>> >> > REPORT_NUMBER =3D3D :SEARCH-REPORT-NUMB=3D=20
>> >> >ER=20
>> >> > End key pred. : COMPANY =3D3D :SEARCH-COMPANY , WARE =3D3D=20>
>> >> > :SEARCH-WARE , REPORT_NUMBER =3D3D :SEARCH-REPORT-N=3D=20
>> >> >UMBER
>> >> > Index selectivity : Expect to examine 100% of rows from table=20>
>> >> > Index pred. : None=20
>> >> > Base table pred. : Will be evaluated by the disk process
>> >> > ( SOURCE_OF_SUPPLY >=3D3D :SEARCH-SOS ) AND ( BIN_=3D
>> >> >LOC >=3D3D :SEARCH-BIN-LOC )=20
>> >> > AND ( PART_NUM >=3D3D :SEARCH-PART-NUM )
>> >> > Pred. selectivity : Expect to select 1.2341% of rows from table
>> >> >=3D20
>> >> > Executor pred. : None=20
>> >> > Table selectivity : Expect to select 1.2341% of rows from table=20>
>> >> > Expected row count: 5 rows after the scan=20
>> >> > Operation cost : 35
>> >> >=3D20
>> >> > Operation 1.1 : Sort=20
>> >> > Requested : Explicitly in the query=20
>> >> > Sort rows in the : Result of a Select=20
>> >> > Purpose : To order rows for an Order By=20
>> >> > Sort technique : FASTSORT=20
>> >> > Sort type : Plan to use User Process Sort=20
>> >> > UPS workspace : 34 Kbytes=20
>> >> > Sort key columns : PARTS.COMPANY asc, PARTS.WARE asc,=20
>> >> > PARTS.REPORT_NUMBER asc,=20
>> >> > PARTS.SOURCE_OF_SUPPLY asc, PARTS.PART_NUM asc,
>> >> > PARTS.BIN_LOC asc,=3D20=20
>> >> > Sort cost : 1=20
>> >> >=3D20=20
>> >> > Total cost : 36
>> >> --------------------------------------------------
>> >> >>In case if there are more records than 5000, it saves off record num>ber
>> >> >>and use it to reopen the cursor and get the rest of the records.
>> >> Where does record number come from and how does it become part=20
>> >> of the where clause on reopening the cursor?
>> >
>> >
>> >When the cursor is opened, it will fetch up to 5000 record, on 5001, the> 5=
>> >000 record limit will cause the program to save off the data for record >50=
>> >01 and close the cursor. The second read will use the saved off the data> as=
>> > a starting point to read the next 5000 records. So record number is not> a =
>> >part of the table and it's not used in the WHERE clause. It's an interna>l p=
>> >rogram counter to know when to stop reading as the page limit is set to >500>> >0 records. Thanks again for your help!
>> In the absence of any sample data,
>> I loaded a few rows with the variable part of the key as
>>
>> SS P000000000 BIN000000
>> SS P000000001 BIN000001
>> SS P000000002 BIN000002
>> SS P000000003 BIN000003
>> thru
>> SS P000000099 BIN000099
>>
>> ----------------------------
>> -- start the query
>>
>> set param ?company 12;
>> set param ?warehouse "W12";
>> set param ?report_number 1234;
>>
>> set param ?source_of_supply " ";
>> set param ?part_num " ";
>> set param ?bin_loc " ";
>>
>> prepare s1 from
>> +> SELECT SOURCE_OF_SUPPLY,PART_NUM,BIN_LOC
>> +> FROM =parts FOR BROWSE ACCESS
>> +> WHERE COMPANY = ?company and
>> +> WAREHOUSE = ?warehouse and
>> +> REPORT_NUMBER = ?report_number and
>> +> SOURCE_OF_SUPPLY >= ?source_of_supply and
>> +> PART_NUM >= ?part_num and
>> +> BIN_LOC >= ?bin_loc
>> +>;
>> --- SQL command prepared.
>>
>> execute s1;
>>
>> SOURCE_OF_SUPPLY PART_NUM BIN_LOC
>> ---------------- ---------- ---------
>>
>> SS P000000000 BIN000000
>> SS P000000001 BIN000001
>> SS P000000002 BIN000002
>> SS P000000003 BIN000003
>> SS P000000004 BIN000004
>> SS P000000005 BIN000005
>> SS P000000006 BIN000006
>> SS P000000007 BIN000007
>> SS P000000008 BIN000008
>> SS P000000009 BIN000009
>>
>> Assuming that 10 rows are fetched per open cursor
>> and the last row fetched was
>>
>> set param ?source_of_supply "SS";
>> set param ?part_num "P000000010";
>> set param ?bin_loc "zzzzzzzzz";
>>
>> The variable parts of the key is the problem
>> SOURCE_OF_SUPPLY >= ?source_of_supply and
>> PART_NUM >= ?part_num and
>> BIN_LOC >= ?bin_loc
>>
>> The high value of the bin_loc restart value prevents any more rows
>> from being fetched, at least in this test data,
>> because the three cols are AND'd. .
>>
>> With a more random bin_loc you would likely skip subsequent rows with
>> a bin_loc value less than the restart value
>>
>> execute s1;
>>
>> --- 0 row(s) selected.
>
>
>Thank you again for your help. I noticed if I remove the bin-_loc I get mor>e records back.
>I am not sure what is the solution of this paging issue. In my mind I am g>iving the cursor a starting point on the second select. If both have the sa>me order by to retrieve data, why the second select is not working. I still> can not get it and that's preventing me from solving the issue. Would you >please shed any light on how to fix this. Thanks in advance and have a won>derful weekend!
>

Similar issues will occur with varying values of source_of_supply
and part_num

Say source_of_supply goes from 'SS' to 'ST'
and all part_num from 'ST' are less than part_nums from 'SS' .

I was hoping this would treat the three variable cols
as one compound data item for the compare
but explain shows that is not the case

WHERE (COMPANY,WAREHOUSE,REPORT_NUMBER ?company,?warehouse,?report_number)
and
(SOURCE_OF_SUPPLY,PART_NUM,BIN_LOC > ?source_of_supply,?part_num,?bin_loc);

.
X-Received: by 2002:a05:620a:404:b0:76d:929a:c94d with SMTP id 4-20020a05620a040400b0076d929ac94dmr59017qkp.1.1694812108800;
Fri, 15 Sep 2023 14:08:28 -0700 (PDT)
X-Received: by 2002:a05:6808:128d:b0:3a8:8b74:fd51 with SMTP id
a13-20020a056808128d00b003a88b74fd51mr1171999oiw.10.1694812108509; Fri, 15
Sep 2023 14:08:28 -0700 (PDT)
Path: i2pn2.org!i2pn.org!usenet.blueworldhosting.com!diablo1.usenet.blueworldhosting.com!peer01.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.sys.tandem
Date: Fri, 15 Sep 2023 14:08:28 -0700 (PDT)
In-Reply-To: <d6b90801-c163-4569-afc9-ce6e0f12cc1cn@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host&07:fea8:3fa9:4200:ec98:ef6d:dc7a:ffe;
posting-account=6VebZwoAAAAgrpUtsowyjrKRLNlqxnXo
NNTP-Posting-Host: 2607:fea8:3fa9:4200:ec98:ef6d:dc7a:ffe
References: <d6b90801-c163-4569-afc9-ce6e0f12cc1cn@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <67801270-9000-40f0-9460-8c56045cc8f0n@googlegroups.com>
Subject: Re: Debugging L-Series with Eclipse
From: Randall <rsbecker@nexbridge.com>
Injection-Date: Fri, 15 Sep 2023 21:08:28 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
X-Received-Bytes: 2566
Xref: retrobbs comp.sys.tandem:761

On Thursday, September 14, 2023 at 5:12:05 p.m. UTC-4, John Wilson wrote:
> Hi All -
>
> With the migration to the L-Series (X86), the manuals indicate that debugging using Visual Inspect will no longer be possible.
>
> When attempting to debug using Eclipse (using instructions from NSDEE manual) there seems to be an issue with how Eclipse invokes the debug session and which CPU is used.
>
> Has anyone experienced this? Or are you using Eclipse debugging without any issue?
>
> Thanks,
> John

Hi John,

No issues for me on using NSDEE, ECLIPSE, and GDB, but you do need to have your SSH connections set up prior to attempting to debug. You should be using the latest version of NSDEE (or appropriate version for your system). There also could be a firewall issue, and also a port forwarding setup requirement in SSH2. The important "trick" is that you will be entering GDB commands via a console window in ECLIPSE, which is not normally input enabled, but the remote debugging does set up input to enter commands. The debug at line function had some issues (clicking on the line in the code window), but I thought that was resolved long ago. Please contact GNSC for support rather than here as this is a HPE supported product.

Regards,
Randall
. X-Received: by 2002:a05:6214:5a07:b0:66c:eec1:4be4 with SMTP id lu7-20020a0562145a0700b0066ceec14be4mr340087qvb.3.1698269962767;
Wed, 25 Oct 2023 14:39:22 -0700 (PDT)
X-Received: by 2002:a25:d753:0:b0:d9a:556d:5f8a with SMTP id
o80-20020a25d753000000b00d9a556d5f8amr292211ybg.12.1698269962534; Wed, 25 Oct
2023 14:39:22 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!border-2.nntp.ord.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.sys.tandem
Date: Wed, 25 Oct 2023 14:39:22 -0700 (PDT)
In-Reply-To: <d8d4cc87-16c3-4ccd-b349-690723e8564an@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host&07:fea8:3fa9:4200:896d:de96:f0f0:d9f3;
posting-account=6VebZwoAAAAgrpUtsowyjrKRLNlqxnXo
NNTP-Posting-Host: 2607:fea8:3fa9:4200:896d:de96:f0f0:d9f3
References: <f2274207-4f8f-4111-833b-a2f10365c981n@googlegroups.com> <d8d4cc87-16c3-4ccd-b349-690723e8564an@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <626119ad-fb9e-43c7-8f09-c16654b01f5dn@googlegroups.com>
Subject: Re: ITUGLIB Update: OpenSSL 3.0.12 and 3.1.4 Available
From: Randall <rsbecker@nexbridge.com>
Injection-Date: Wed, 25 Oct 2023 21:39:22 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Lines: 32
Xref: retrobbs comp.sys.tandem:761

On Wednesday, October 25, 2023 at 5:17:19 p.m. UTC-4, Randall wrote:
> On Wednesday, October 25, 2023 at 1:42:17 p.m. UTC-4, Randall wrote:
> > The latest patches for the OpenSSL 3.0.x and 3.1.x series are now available on the ITUGLIB website. Release notes are available at https://www.openssl.org/news/openssl-3.0-notes.html and https://www.openssl.org/news/openssl-3.1-notes.html.
> >
> > Both releases contain fixes for CVE-2023-5363 (Moderate) - Incorrect cipher key & IV length processing described in the release notes.
> >
> > The 3.2 series is still in alpha state. If you are interested in testing with this series, please let ITUGLIB know here. This series is not binary compatible with the 3.0.x and 3.1.x series, so you will need to recompile your code to use it. At present, we are not planning to release a 3.2 build until it reaches beta state.
> >
> > The 1.1.1 and 1.0.2 series are no longer under official support, and do not receive security updates, so you should move off those releases. If you cannot move off those releases, please contact me to facilitate fee-based premium support from OpenSSL to obtain patched builds.
> >
> > Regards,
> > Randall Becker
> > On Behalf of the ITUGLIB Technical Committee
> Please be aware that 3.0.12 has already had reports of breakage in the pkcs11 engine and with coreutils prngd. Please let ITUGLIB know here if you encounter any problems.

Update: The pkcs11 engine issue appears to relates to atexit() processing, which I dealt with on NonStop a while ago, and memory leaks (which have no real impact after a process exits), so we appear to be safe for now.
. X-Received: by 2002:a05:622a:1994:b0:41e:a56c:23a3 with SMTP id u20-20020a05622a199400b0041ea56c23a3mr132787qtc.4.1699232354365;
Sun, 05 Nov 2023 16:59:14 -0800 (PST)
X-Received: by 2002:a05:6808:3601:b0:3b2:e488:a5d4 with SMTP id
ct1-20020a056808360100b003b2e488a5d4mr8573978oib.9.1699232354034; Sun, 05 Nov
2023 16:59:14 -0800 (PST)
Path: i2pn2.org!i2pn.org!usenet.blueworldhosting.com!diablo1.usenet.blueworldhosting.com!peer03.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.sys.tandem
Date: Sun, 5 Nov 2023 16:59:13 -0800 (PST)
In-Reply-To: <ui09vo$27hli$1@dont-email.me>
Injection-Info: google-groups.googlegroups.com; posting-host0.41.228.154; posting-account=osbHJgoAAADBhvRtSBcl0KwwWNN2TZDt
NNTP-Posting-Host: 130.41.228.154
References: <e5b77d43-34c1-4cd5-ab83-748fda235becn@googlegroups.com> <ui09vo$27hli$1@dont-email.me>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <4c4c65c7-8502-41b6-b3e1-8059244db7afn@googlegroups.com>
Subject: Re: Temporary files not automatically deleted
From: Keith <kgan238@gmail.com>
Injection-Date: Mon, 06 Nov 2023 00:59:14 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
X-Received-Bytes: 2382
Xref: retrobbs comp.sys.tandem:761

On Friday, November 3, 2023 at 12:59:24 AM UTC+11, JShepherd wrote:

> >DSAP shows a large amount of temp files on a disk. On closer investigation =
> >I found out that there are lots of temp files but are not opened by any pro=
> >cesses. This should not happened as closing a temp file should have it auto=
> >matically deleted. Attempt to manually purge them returns an error 12. Has > >anyone encountered this and how to fix this?
> A bigger problem, on systems with a lot of SQL/MX create/drop happening,
> is the mass of .ddl files in /usr/tandem/sqlmx/ddl .
>
> A single QA test cycle on MX here can create/drop a thousand MX tables.
>
> The first time /usr became full it took a while to find the culprit,
> which was was over 300,000 .ddl files in /usr/tandem/sqlmx/ddl
>
> Now, we have a program we run occasionally to clean them out
>
> From this morning on one system
> mxscan has deleted 14068 .ddl files

Raised this with HPE. The issue was that a permanent file with CLEARONPURGE was purged. DP2 converts this to a temp file but did not purge it. It's a DP2 issue unfortunately.