Message-ID: <540A3480.9040601@aklaver.com>
Date: Fri, 05 Sep 2014 15:09:04 -0700
From: Adrian Klaver <adrian.klaver@aklaver.com>
User-Agent: Mozilla/5.0 (X11; Linux i686;
 rv:24.0) Gecko/20100101 Thunderbird/24.6.0
MIME-Version: 1.0
To: Alanoly Andrews <alanolya@invera.com>,
 'Craig James' <cjames@emolecules.com>
CC: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>,
 "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Subject: Re: [GENERAL] Re: Cannot retrieve images inserted through
 VB and odbc, after a table reorganization.
References: <6909b219ecae4d41b431efdaf6c953a3@Exch2.invera.com>
	<CAFwQ8rd0Abfm=0j4Oq5D0hcRPBn=D7A-HJzSPJmDk=EgDMA9zQ@mail.gmail.com>
	<a45db4656040438eaf2034a8f5870b8d@Exch2.invera.com>
	<5407679B.2030906@aklaver.com>
	<aafcb3551e2c4dddb696ec4a6d6087e8@Exch2.invera.com>
	<54086B77.9090102@aklaver.com>
	<af0397c0ba2f4fefb79c0ba63a5ab50d@Exch2.invera.com>
	<5408CED2.10302@aklaver.com>
 <8dd4e9c35f6441b6b9d20b1eb659688e@Exch2.invera.com>
In-Reply-To: <8dd4e9c35f6441b6b9d20b1eb659688e@Exch2.invera.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

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 messages relevant 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


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin