[Info-ingres] [openroad-users] Lost connection to DB cursor loop. E_LQ0040 E_LC0022

[Paul White]

Thanks Adrian.
Great. I found the fix listed in P15221 on Linux. I will give that a go.
I didn’t realize it was a server problem.
Our symptoms are identical except we have vch_compression=on.
Programmer identified the problem occurs only with 13 rows of data in the cursor. 12 or 14 rows are no problem.
Paul

-----Original Message-----
From: Adrian Williamson [mailto:adrian.williamson at rationalcommerce.com] 
Sent: Thursday, 19 October 2017 5:42 PM
To: openroad-users at googlegroups.com; 'Paul White'
Subject: RE: [openroad-users] Lost connection to DB cursor loop. E_LQ0040 E_LC0022

They found two issues:


Bug 131539 (Generic)

COPY via IngresNet with vch_compression OFF fails with E_CO002B, E_CO0029.

Trying to copy out a specific table via IngresNet from a database where vch_compression is OFF and, II_FORCE_HET is TRUE either on the client, server or both; fails to copy out the last row with E_CO002B, E_CO0029.
This occurs with either binary, ASCII and/or CSV copy.

The test case table had 15686 rows. The issue disappear when adding one more row to the table or deleting one (or more) row from the table.

Bug 131552 (Generic)

A REPEATED SELECT fails in OpenROAD 6.2 with E_LQ0040 and E_LC0022.

A REPEATED SELECT ... BEGIN CurObject.warnings_ar[i].locale= :location; END; fails in OpenROAD 6.2 with "E_LQ0040 Protocol read-failure on internal data. Execution of this query is stopped" and "E_LC0022 Protocol data read failure. Found message GCA_RESPONSE while reading message GCA_TUPLES, and read only 20 bytes". The query runs fine when executed in sql tm against the same database server via the same vnode.

-----Original Message-----
From: Adrian Williamson [mailto:adrian.williamson at rationalcommerce.com] 
Sent: 19 October 2017 08:38
To: 'openroad-users at googlegroups.com' <openroad-users at googlegroups.com>; 'Paul White' <paul.white at shift7solutions.com.au>
Subject: RE: [openroad-users] Lost connection to DB cursor loop. E_LQ0040 E_LC0022

Yes we had that.

"This is an Ingres Net bug reported as 131577 & 131552 (II-797, OR-2139) which is now fixed. The fix was delivered with patch 15106 and verified by the customer."

-----Original Message-----
From: openroad-users at googlegroups.com [mailto:openroad-users at googlegroups.com] On Behalf Of Paul White
Sent: 19 October 2017 04:40
To: openroad-users at googlegroups.com
Subject: [openroad-users] Lost connection to DB cursor loop. E_LQ0040 E_LC0022

Has anyone run into this problem?  
It appears to be a bug in Ingres Net V10.2 with a workaround to modify the vnode, may be fixed in V11.

 
Lost connection to DB
Communications error failure to connect to database - exiting

W4GL Trace shows
E_LQ0040 Protocol read-failure on internal data Execution of the query is stopped
E_LC0022 Protocol data read failure
Found message GCA_RESPONSE while reading message GCA_TUPLES, and read only
12 bytes


Client: OpenROAD 6.2 Windows, Ingres Net 10.2.0
Server: Either Windows 64 or Linux 64
vch_compression is enabled at db server end.
The problem occurs with some combinations of data, have not yet worked out a pattern.
It is a pretty basic requirement, we have this type of code everywhere in the app.

Code
REPEATED SELECT
        CurObject.arr[Li_idx].contact        = contact,
...
        CurObject.arr[Li_idx].first_name     = first_name,  
        CurObject.arr[Li_idx].last_name      = last_name    
    FROM customer_contacts
    WHERE 
        cust_code = :cust_code AND 
        (contact != '' OR telephone != '' OR internet_add != '') 
    ORDER BY contact       
    BEGIN
        Li_idx = Li_idx + 1;
    END;

There are a couple of bugs which have similar symptoms, recommending a workaround changing vch_compression, and setting an additional vnode attribute. The problem appears fixed in Ingres V11.

>From Actian Support Portal
0000176723 A REPEATED SELECT where last column in the result set is a varchar fails with errors E_LQ0040 and E_LC0022. This may happen in OpenROAD and/or Embedded SQL applications when run in a heterogeneous environment when varchar compression is disabled.  Jan 17, 2017
131577 & 131552 (OR-2139,II-797)


Fixed in V11 release.
Bug 131552 (GENERIC)
A REPEATED SELECT via GCA Remote Access where last column in result-set is varchar fails with E_LQ0040 and E_LC0022.  

Paul White

&
Shift Seven Solutions
www.shift7solutions.com.au



--
You received this message because you are subscribed to the Google Groups "OpenROAD Users Mailing List" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openroad-users+unsubscribe at googlegroups.com.
To post to this group, send email to openroad-users at googlegroups.com.
Visit this group at https://groups.google.com/group/openroad-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/openroad-users/59e81e9e.d093620a.11c60.df54%40mx.google.com.
For more options, visit https://groups.google.com/d/optout.