Re: Intermittent errors when fetching cursor rows on PostgreSQL 16

On 12/19/24 11:40 AM, Enrico Schenone wrote:
> Hello, my answers in line along your message ...
> Thanks a lot again.
>
> Enrico
>

>> On 12/19/24 10:11, Enrico Schenone wrote:
>>> Good day, Adrian.
>>> I get the error inside the program by catching the exception and
>>> logging it with diagnostic info provided by the DVM (a runtime
>>> interpreter similar in concept to a JVM) that embed the PG driver.
>>

> The 4Js DVM (Dynamic Virtual Machine) is that one
> https://4js.com/online_documentation/fjs-gas-manual-html/index.html#gas-topics/c_gas_what_is_dvm.html
>
>> In other words an Android client?
>>
> No, it is a runtime interpreter for Linux, Windows, IBM AIX, macOS and
> other unix-like OSs. It ensures the portability of 4Js Genero compiled
> programs (p-code) on several OS platforms.
> 4Js Genero is a Low Code Application Platform. The programming language,
> named "BDL - Business Development Language", is an evolution of the
> Informix-4gl.
> Compiled programs needs a runtime interpreter (DVM) to be executed.
> The DVM embeds at low-level the DB drivers provided by several vendors,

From previous post you mentioned:

"Four Js support said <We use the standard C API provided by the DB
vendor. In the case of PostgreSQL, we use the C API client "

So are they building their own driver over libpq?

> and at BDL high level the application program can easily connect to the
> major DBs on the market thanks to its ODI (Open Database Interface).
>>> I can't give you info on what the DVM does at low level, but I can
>>> send you the distinct full session log fragment at server side, where
>>> it is quite easy to understand how the DVM translates the program's
>>> SQL queries end what PostgreSQL does.
>>
>> That might be useful.
>>
> Please take a look to the attached text file, that is the full failing
> session log (filtered from the debug5 PostgreSQL server log).

This is where it falls off the rails, but I can't see why?:

2024-12-16 17:27:14.406 CET [2214722] cleistech(at)hh24odds_prod -
192.168.16.17900000676054e0.21cb42 LOCATION: ShowTransactionStateRec,
xact.c:5510
2024-12-16 17:27:14.406 CET [2214722] cleistech(at)hh24odds_prod -
192.168.16.17900000676054e0.21cb42 STATEMENT: fetch forward 50 from cu6
2024-12-16 17:27:14.406 CET [2214722] cleistech(at)hh24odds_prod -
192.168.16.17900000676054e0.21cb42 LOG: 00000: statement: fetch forward
50 from cu6
2024-12-16 17:27:14.406 CET [2214722] cleistech(at)hh24odds_prod -
192.168.16.17900000676054e0.21cb42 LOCATION: exec_simple_query,
postgres.c:1073
2024-12-16 17:27:14.406 CET [2214722] cleistech(at)hh24odds_prod -
192.168.16.17900000676054e0.21cb42 DEBUG: 00000: CommitTransaction(1)
name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0

2024-12-16 17:27:14.406 CET [2214722] cleistech(at)hh24odds_prod -
192.168.16.17900000676054e0.21cb42 LOCATION: ShowTransactionStateRec,
xact.c:5510
2024-12-16 17:27:14.406 CET [2214722] cleistech(at)hh24odds_prod -
192.168.16.17900000676054e0.21cb42 STATEMENT: fetch forward 50 from cu6
2024-12-16 17:27:14.407 CET [2214722] cleistech(at)hh24odds_prod -
192.168.16.17908006676054e0.21cb42 LOG: 08006: could not receive data
from client: Connessione interrotta dal corrispondente

>>> Thanks again and best regards.
>>> Enrico

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com