Re: Re: [ADMIN] Cannot retrieve images inserted through VB and odbc, after a table reorganization. - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Re: [ADMIN] Cannot retrieve images inserted through VB and odbc, after a table reorganization.
Date
Msg-id 540A3480.9040601@aklaver.com
Whole thread Raw
In response to Re: Re: [ADMIN] Cannot retrieve images inserted through VB and odbc, after a table reorganization.  (Alanoly Andrews <alanolya@invera.com>)
List pgsql-general
On 09/05/2014 08:33 AM, Alanoly Andrews wrote:
> Hi Adrian,
>
> 1. We are storing our large objects in a table column whose datatype is "lo" (which, I understand, ultimately is in
fact"bytea"). 

As way of testing where the issue is, you might explore  saving some
images in a test table directly to a bytea column. This is presumably
what the Bytea as LO option is for. Then run CLUSTER on the test table
and see what happens.

> 2. The error messge returned to the VB is, yes, very generic. And the backend postgres server does not have any
messagesrelevant to this issue. 
> 3. We set the trace on in the odbc driver and got a large log file, from which I give below the part that I think is
significant.It refers to the "buffer size being too small". Where, in the odc settings, do we set the buffer size? 
>

I would recommend posting the below(with some background information) on
the -odbc list where there are folks that might better understand it.

>
> STELimageViewOn 834-fec          EXIT  SQLGetData  with return code 1 (SQL_SUCCESS_WITH_INFO)
>                                  HSTMT               0x002BFC70
>                                  UWORD                        2
>                                  SWORD                        1 <SQL_C_CHAR>
>                                  PTR                 0x0018EECF [       0] ""
>                                  SQLLEN                     0
>                                  SQLLEN *            0x0018EEA4 (6)
>
>                                  DIAG [01004] The buffer was too small for the GetData. (-2)
>
> STELimageViewOn 834-fec          ENTER SQLGetData
>                                  HSTMT               0x002BFC70
>                                  UWORD                        2
>                                  SWORD                       -2 <SQL_C_BINARY>
>                                  PTR                 <unknown type>
>                                  SQLLEN                     0
>                                  SQLLEN *            0x0018EE54
>
> STELimageViewOn 834-fec          EXIT  SQLGetData  with return code 1 (SQL_SUCCESS_WITH_INFO)
>                                  HSTMT               0x002BFC70
>                                  UWORD                        2
>                                  SWORD                       -2 <SQL_C_BINARY>
>                                  PTR                 <unknown type>
>                                  SQLLEN                     0
>                                  SQLLEN *            0x0018EE54 (46165)
>
>                                  DIAG [01004] The buffer was too small for the GetData. (-2)
>
> STELimageViewOn 834-fec          ENTER SQLGetData
>                                  HSTMT               0x002BFC70
>                                  UWORD                        2
>                                  SWORD                       -2 <SQL_C_BINARY>
>                                  PTR                 <unknown type>
>                                  SQLLEN                 32768
>                                  SQLLEN *            0x003CE284
>
> STELimageViewOn 834-fec          EXIT  SQLGetData  with return code -1 (SQL_ERROR)
>                                  HSTMT               0x002BFC70
>                                  UWORD                        2
>                                  SWORD                       -2 <SQL_C_BINARY>
>                                  PTR                 <unknown type>
>                                  SQLLEN                 32768
>                                  SQLLEN *            0x003CE284
>
>                                  DIAG [S1000] Error reading from large object. (1)


--
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Cal Heldenbrand
Date:
Subject: Re: Querying a time range across multiple partitions
Next
From: David G Johnston
Date:
Subject: Re: Querying a time range across multiple partitions