Re: psqlodbc: No memory available to store statement

--=_mixed 005CFBB543258426_=
Content-Type: multipart/alternative; boundary="=_alternative 005CFBB743258426_="


--=_alternative 005CFBB743258426_=
Content-Type: text/plain; charset="US-ASCII"

Hello,
I attached  config.h, generated after configure command:





 Best regards, 
 Andrei Yahorau



From:   "Inoue, Hiroshi" <[email protected]>
To:     [email protected], 
Cc:     [email protected]
Date:   26/06/2019 23:43
Subject:        Re: psqlodbc: No memory available to store statement



Hi Andrei,
On 2019/06/25 21:28, [email protected] wrote:
Hello PostgreSQL Community!

I  widely  use psqlodb driver with unixODBC manager on my SLES12 linux 
machine.
Not very long ago I updated psqlodbc driver from  10.03.0000  to the 
latest one 11.01.0000 .
I use unixODBC-2.3.6-7.9.1.x86_64 package installed from YAST setup and 
configurational tool and configure, build, and install  psqlodbc from the 
source code in the same way as for psqlodbc 10.03.0000:

autoreconf -i
./configure --prefix=path_to_install --with-libpq=path_to_pg_config 
--with-unixodbc=path_to_odbc_config
make
make install

In my  program I  use quite common ODBC functions to establish a 
connection, perform a query, retrieve a result: 
SQLConnect, SQLExecDirect,  SQLFetch etc.

But after I had installed psqlodbc11.01.0000 I am constantly getting the 
following error:
No memory available to store statement *** PostgreSQL SQLSTATE = HY001

I inspected all the changes in 11.00.0000 and 11.01.0000 versions and 
found out that this behaviour is caused by the following commit:
1086a6 2018-05-23 | Call AC_CHECK_SIZEOF(long int) in configure.ac and 
always place config.h before sql....h. Due to this change, sqltypes.h of 
unixODBC can recognize SIZEOF_LONG_INT used in psqlodbc driver. [Hiroshi 
Inoue]

So, in this case I see that configure script generates config.h file with 
defined  SIZEOF_LONG_INT: #define SIZEOF_LONG_INT 0,

Could you please send me config.h ?

regards,
Hiroshi Inoue

while odcb_config --header says: 
#define SIZEOF_LONG_INT 8

So, in regard to this situation I have some questions.
Unfortunately there is not enough information. So what was the aim of this 
commit? 1086a6 2018-05-23 | Call AC_CHECK_SIZEOF(long int) in configure.ac 
and always place config.h before sql....h. Due to this change, sqltypes.h 
of unixODBC can recognize SIZEOF_LONG_INT used in psqlodbc driver. 
[Hiroshi Inoue] 
Did anybody face this issue? (No memory available to store statement *** 
PostgreSQL SQLSTATE = HY001 )
What do I do wrong? How to resolve this issue?

Best regards, 
Andrei Yahorau

--=_alternative 005CFBB743258426_=
Content-Type: text/html; charset="US-ASCII"

<font size=2 face="sans-serif">Hello,<br>
I attached &nbsp;config.h, generated after configure command:<br>
<br>
</font>
<br>
<br>
<br>
<br><font size=2 face="sans-serif">&nbsp;Best regards, </font>
<br><font size=2 face="sans-serif">&nbsp;Andrei Yahorau</font>
<br>
<br>
<br>
<br><font size=1 color=#5f5f5f face="sans-serif">From: &nbsp; &nbsp; &nbsp;
&nbsp;</font><font size=1 face="sans-serif">&quot;Inoue, Hiroshi&quot;
&lt;[email protected]&gt;</font>
<br><font size=1 color=#5f5f5f face="sans-serif">To: &nbsp; &nbsp; &nbsp;
&nbsp;</font><font size=1 face="sans-serif">[email protected],
</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Cc: &nbsp; &nbsp; &nbsp;
&nbsp;</font><font size=1 face="sans-serif">[email protected]</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Date: &nbsp; &nbsp; &nbsp;
&nbsp;</font><font size=1 face="sans-serif">26/06/2019 23:43</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Subject: &nbsp; &nbsp;
&nbsp; &nbsp;</font><font size=1 face="sans-serif">Re: psqlodbc:
No memory available to store statement</font>
<br>
<hr noshade>
<br>
<br>
<br><font size=3>Hi Andrei,</font>
<p><font size=3>On 2019/06/25 21:28, </font><a href=mailto:[email protected]><font size=3 color=blue><u>[email protected]</u></font></a><font size=3>
wrote:</font>
<br><font size=2 face="sans-serif">Hello PostgreSQL Community!<br>
<br>
I &nbsp;widely &nbsp;use psqlodb driver with unixODBC manager on my SLES12
linux machine.<br>
Not very long ago I updated psqlodbc driver from <b>&nbsp;10.03.0000</b>
&nbsp;to the latest one <b>11.01.0000 </b>.<br>
I use unixODBC-2.3.6-7.9.1.x86_64 package installed from YAST setup and
configurational tool and configure, build, and install &nbsp;psqlodbc from
the source code in the same way as for psqlodbc 10.03.0000:</font><tt><font size=2 color=#2f2f2f><br>
</font></tt><font size=2 color=blue face="sans-serif"><br>
autoreconf -i<br>
./configure --prefix=path_to_install --with-libpq=path_to_pg_config --with-unixodbc=path_to_odbc_config<br>
make<br>
make install</font><font size=3 face="sans-serif"><br>
</font><font size=2 face="sans-serif"><br>
In my &nbsp;program I &nbsp;use quite common ODBC functions to establish
a connection, perform a query, retrieve a result: <br>
SQLConnect, SQLExecDirect, &nbsp;SQLFetch etc.</font><font size=3 face="sans-serif"><br>
</font><font size=2 face="sans-serif"><br>
But after I had installed psqlodbc11.01.0000 I am constantly getting the
following error:</font><tt><font size=3><b><u><br>
No memory available to store statement *** PostgreSQL SQLSTATE = HY001</u></b></font></tt><font size=2 face="sans-serif"><br>
<br>
I inspected all the changes in <b>11.00.0000</b> and <b>11.01.0000</b>
versions and found out that this behaviour is caused by the following commit:</font><font size=2 color=blue face="sans-serif"><br>
1086a6 2018-05-23 | Call AC_CHECK_SIZEOF(long int) in configure.ac and
always place config.h before sql....h. Due to this change, sqltypes.h of
unixODBC can recognize SIZEOF_LONG_INT used in psqlodbc driver. [Hiroshi
Inoue]</font><font size=2 face="sans-serif"><br>
<br>
So, in this case I see that configure script generates config.h file with
defined &nbsp;SIZEOF_LONG_INT: #define SIZEOF_LONG_INT 0,</font>
<br><font size=2><br>
Could you please send me config.h ?<br>
<br>
regards,<br>
Hiroshi Inoue</font><font size=3><br>
</font>
<br><font size=2 face="sans-serif">while <b>odcb_config --header</b> says:
<br>
#define SIZEOF_LONG_INT 8<br>
<br>
So, in regard to this situation I have some questions.<br>
Unfortunately there is not enough information. So what was the aim of this
commit? </font><font size=2 color=blue face="sans-serif">1086a6 2018-05-23
| Call AC_CHECK_SIZEOF(long int) in configure.ac and always place config.h
before sql....h. Due to this change, sqltypes.h of unixODBC can recognize
SIZEOF_LONG_INT used in psqlodbc driver. [Hiroshi Inoue]</font><font size=2 face="sans-serif">
<br>
Did anybody face this issue? (</font><tt><font size=3><b><u>No memory available
to store statement *** PostgreSQL SQLSTATE = HY001</u></b></font></tt><font size=2 face="sans-serif">
)<br>
What do I do wrong? How to resolve this issue?</font><font size=3><br>
</font><font size=2 face="sans-serif"><br>
Best regards, <br>
Andrei Yahorau</font>
<br>
--=_alternative 005CFBB743258426_=--
--=_mixed 005CFBB543258426_=
Content-Type: application/zip; name="config.zip"
Content-Disposition: attachment; filename="config.zip"
Content-Transfer-Encoding: base64

UEsDBBQAAAAIAG2c207Zmp2xAgUAAN4SAAAIAAAAY29uZmlnLmiVmFtzmkAUgN/7K3bsg22mMfWl
T06niNTQIljA9PKCXFZhCqzdXZLaX9+zQCQoyprJOAK73zl77nh3g0KSb5LtKB4hNMc5pj7HEdpQ
kjVPkhwF+/qyoBhW3ty9ElubBae7m+V+KLb7BScx9iNMq/0CMMObJMeIEzRGyQbtSYFi/xFuxBit
w/EHykkWDNGmyEOeEBAC+15H1aZ75UHz1PEH27UWUzTu5UU4TH3qCw4iG7RmnGJKCfXo8B3y80js
el/veoUQikg+5KcSZ5pqeI5ra7Zt2Z4tIXgSpZswH8UfUXV8tElS3AE2Pqumdy8DTHLO9zvMepm6
6bo/l5ojhV3v/gxRmgTUp3v05jbd/Xl7SjT06fKbFIzHFFRrEet7Z7Duva0psyvYrAvOSrpAvC5y
EHHMd2Rib5KS0E9xr30NS1UMTc66JZInGfZoE9FnkK6+0M7EVglje8ZxBnBWXkIwlALyLRIfwy6q
OS8/ZDTNAsg7yL5Lai6mkHeQfXI8xslTyC7zHNf6rjoSvEmGM0L3vc5ZaAvL/innnDp4vKzg+K/P
OfUYLnPsks51RHmLlav9UFzX9hytzLcrHceSbQ5VM4x92uE6R5+b2sxT75VrA4Kx5B/2eBfT0X9p
nithmQnjEZSbXmM77gyKjZSxBRLyVgYJaSuFPBTzi7l1ZdkGZpJv+4ssUHVzLldja6gkUwopzp6G
Pm8O3i6AB6ChKq5M8RNATn73mtK1vkoZsuKlaS/OMKRpRT9tJUObQOLcMe5LBPhPB7iKbIgDFmp9
fwcRWKj2cj2kxMp1fsGVb/2TQhSfXuhKFCFJYJ5AmvcTTR3SXAq5hg4ixsGLbQQ6iBgHT9pIVSSL
4DZKKA45tA8EQ+1TnISxmCE4ISlicBszBJrnEBFpiqN6vEjA3jARvhRmuJ41/TLTbTQYwSJ2Nyjl
mX6GxXC588Pf/ha/3LFU1K/KXEODHfuTkigIBx0a+lEEKjBQDFOMgmKLKN4RyhnaEAorEnZAsxiS
IEIBfMNQnztEedPV3NaWlu2C0C1IvRViP+0I41uK4XpE6LZLi02RpiivjtIS2inFVBaXT9XwyjH7
EVMGvpNiV2WwoaPxePQe/uGvSxDJRSfMAuHMGMwmfwhXsfvPEROg7QAhvNHPXNkGGnRwrrLAg2Y7
umWiQffJW1nSmkc8W1NXsPcBPLRskefNo2Z0Obf5OC3FR1AkEHlPCY/R89ANubUTgQqD+C3O/SDF
t4d5vCXccvQfIAMm3Fqes1qKEK0T1hVpmvwTTqsGWvFuxuBdMtsV4s0y2JePyaZlLDHNWJ+r+fZ9
NwfSnV/LEq9PXbxHkkTo5hrag6XPvKVgnRY555uhklThMBgEQEIFw+KeoZkvQOUqyxCe0qfgIa9a
IVE2FdPRkfqyCrO2hu5M9e7BExBo3bhmtoJqxAuas3JURTdHc0YzXXlln1heGDZCP0fM3+BU1OEw
LSKodoTHrcZZVotJfdHSuWyY3yGCDu3zrCFoC1n/CIBZOUYUIUc8Gx4dw12A3w/g5zM81DmbF1mA
6Zka35WsPQmUWLOp+pw9bUXKA+riOdy/jBFN62+L1GhVckSj/SEWtA0Fea6Zrq2YblnSGIbS5Kdo
l/pwmbGKcrz0xNY42/G9sPc6JNA6h/DTCVg4JxzBtQDBojoOj2xdrj893brIq3eiMmuB3J58Gn6l
2xG0eusR9/4DUEsBAj8AFAAAAAgAbZzbTtmanbECBQAA3hIAAAgAJAAAAAAAAAAgAAAAAAAAAGNv
bmZpZy5oCgAgAAAAAAABABgAAFvUUgYt1QGAs1hfBi3VAQNQh9oILdUBUEsFBgAAAAABAAEAWgAA
ACgFAAAAAA==

--=_mixed 005CFBB543258426_=--