From: Adrian Klaver <adrian.klaver@aklaver.com>
To: Alanoly Andrews <alanolya@invera.com>
To: Craig James <cjames@emolecules.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Cc: pgsql-general@postgresql.org <pgsql-general@postgresql.org>
Subject: Re: [GENERAL] Re: Cannot retrieve images inserted through VB and odbc, after a table reorganization.
Date: Fri, 05 Sep 2014 15:09:04 -0700
Message-ID: <540A3480.9040601@aklaver.com> (raw)
In-Reply-To: <8dd4e9c35f6441b6b9d20b1eb659688e@Exch2.invera.com>
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>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: adrian.klaver@aklaver.com, alanolya@invera.com, cjames@emolecules.com, pgsql-general@postgresql.org
Subject: Re: [GENERAL] Re: Cannot retrieve images inserted through VB and odbc, after a table reorganization.
In-Reply-To: <540A3480.9040601@aklaver.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox