Re: SQLDescribeParam / SUPPORT_DESCRIBE_PARAM

From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: lehmann(at)cnm(dot)de
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: SQLDescribeParam / SUPPORT_DESCRIBE_PARAM
Date: 2011-11-10 13:35:58
Message-ID: 4EBBD33E.8070205@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi,

(2011/11/10 11:07), lehmann(at)cnm(dot)de wrote:
> Hello,
>
>> Please check the *Server side prepare* option of your datasource or
>> add UseServerSidePrepare=1 to your connection string.
>
> I tried, but it doesn't work completely. Actually, when I just use
> UseServerSidePrepare = 1 in odbc.ini, I get some error like this:
>
> Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to
> allocate 3086129905 bytes)

The above message comes from the PostgreSQL server. Could you examine
which query causes the error using the server log?

> in testbase.php on line 64
>
> Then when I add Parse = 1 it works fine on the command line, ie. when I
> call the php-cgi instance with the testscript.
>
> But is soon as I start the script through Apache und mod_php with the
> same ldd-dependencies, I again get exhausted memory errors.
>
> I traced the query - it's as simple as "select count(*) from sessions
> where cust_id = ?" - and I found these lines:
>
> [ODBC][3429][1320890058.574677][SQLNumResultCols.c][248]
> Exit:[SQL_SUCCESS]
> Count = 0xb7f2a80c -> 1
> [ODBC][3429][1320890058.574872][SQLColAttributes.c][280]
> Entry:
> Statement = 0x9c3cff0
> Column Number = 1
> Field Identifier = SQL_COLUMN_NAME
> Character Attr = 0xb7f2a82c
> Buffer Length = 32
> String Length = 0xbff54e3a
> Numeric Attribute = (nil)
> [ODBC][3429][1320890058.576863][SQLColAttributes.c][597]
> Exit:[SQL_SUCCESS]
>
> So SQLNumResultCols = 1 seems to be correct. But String Length =
> 0xbff54e3a seems to be very absurd! That's 3220524602 bytes which means
> around 3 GB! But the correct result is an integer of 5. Any idea how
> this problem arises? Does psqlodbc through mod_php not set the
> Parse-option? What is the actual problem? I didn't have such problems
> with the DBD::Pg driver.
>
> Kind regards
> Marten

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message tamanna madaan 2011-11-11 07:15:13 enabling psqlODBC logs
Previous Message BGoebel 2011-11-10 10:20:55 Re: FETCH LAST is returning "no data" after a Cursor Update