[Info-ingres] Occassional glitch on insert to table with 4 long varchar

Martin Bowes martin.bowes at ndph.ox.ac.uk
Wed Apr 3 14:17:52 UTC 2019


Hi All,

On II 11.0.0 (a64.lnx/100) +p15330.

We have an insert into a table which will very occasionally fail.

The table is composed on integers, varchars, ingresdates and 4 long varchar columns.

The insert is via a prepared query which will insert 21 items.

At the front end the application receives:  E_SC0206_CANNOT_PROCESS

In the errlog we see: E_GC2820_CONN_FAIL_INFO, E_CLFE07_BS_READ_ERR

So far, I haven't been able to make a reliable test case.

Anyone seen anything like this before?

Marty

From: Alan Young [mailto:alan.young at ctsu.ox.ac.uk]
Sent: 02 April 2019 19:07
To: Martin Bowes
Subject: Glitches on bba

Hi Marty,
I'm seeing lots of errors on bba - see example below.  I believe it's connecting to ace_ice_live as user motum

Alan



DATABASE-ERROR: IIAPI_ST_FAILUREInfo: ERROR '50000' 590342: An internal error prevents
further processing of this query.
 Associated error messages which provide more detailed information about the problem can be
found in the error log, II_LOG:errlog.log

 svr_id_error     = 83886080
 svr_local error  = 590342
 svr_id_server    = 13613
 svr_server_type  = 1683974505
 svr_severity     = IIAPI_SVR_DEFAULT ( 0x0 )
        : 'Tue Apr  2 18:36:06 2019
AAn internal error prevents further processing of this query.
 Associated error messages which provide more detailed information about the problem can be
found in the error log, II_LOG:errlog.log'ERROR '08006' 13172737: The connection to the
server has been aborted.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20190403/b1d00eb6/attachment.html>


More information about the Info-ingres mailing list