Re: psqlodbc: No memory available to store statement
"Inoue, Hiroshi" <[email protected]> Fri, 28 Jun 2019 09:41:59 +0900
| Newsgroups | gmane.comp.db.postgresql.odbc |
|---|---|
| Message-ID | <[email protected]> |
This is a multi-part message in MIME format. --------------5DFEA9C9094E77AEE5361F13 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit Hi Andrei, On 2019/06/28 1:55, [email protected] wrote: > Hello, > I attached config.h, generated after configure command: It's strange that SIZEOF_LONG, SIZEOF_LONG_INT and SIZEOF_VOID_P = 0. Could you show me config.log? regards, Hiroshi Inoue > > 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]_ > <mailto:[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 > --- このメールは、AVG によってウイルス チェックされています。 http://www.avg.com --------------5DFEA9C9094E77AEE5361F13 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> </head> <body text="#000000" bgcolor="#FFFFFF"> Hi Andrei,<br> <br> <div class="moz-cite-prefix">On 2019/06/28 1:55, <a class="moz-txt-link-abbreviated" href="mailto:[email protected]">[email protected]</a> wrote:<br> </div> <blockquote type="cite" cite="mid:[email protected]"> <meta http-equiv="content-type" content="text/html; charset=windows-1252"> <font size="2" face="sans-serif">Hello,<br> I attached config.h, generated after configure command:<br> </font></blockquote> <br> It's strange that <font size="2">SIZEOF_LONG, SIZEOF_LONG_INT and SIZEOF_VOID_P = 0.<br> Could you show me config.log?<br> <br> regards,<br> Hiroshi Inoue<br> <br> </font> <blockquote type="cite" cite="mid:[email protected]"><br> <font size="2" face="sans-serif"> Best regards, </font> <br> <font size="2" face="sans-serif"> Andrei Yahorau</font> <br> <br> <br> <br> <font size="1" face="sans-serif" color="#5f5f5f">From: </font><font size="1" face="sans-serif">"Inoue, Hiroshi" <a class="moz-txt-link-rfc2396E" href="mailto:[email protected]"><[email protected]></a></font> <br> <font size="1" face="sans-serif" color="#5f5f5f">To: </font><font size="1" face="sans-serif"><a class="moz-txt-link-abbreviated" href="mailto:[email protected]">[email protected]</a>, </font> <br> <font size="1" face="sans-serif" color="#5f5f5f">Cc: </font><font size="1" face="sans-serif"><a class="moz-txt-link-abbreviated" href="mailto:[email protected]">[email protected]</a></font> <br> <font size="1" face="sans-serif" color="#5f5f5f">Date: </font><font size="1" face="sans-serif">26/06/2019 23:43</font> <br> <font size="1" face="sans-serif" color="#5f5f5f">Subject: </font><font size="1" face="sans-serif">Re: psqlodbc: No memory available to store statement</font> <br> <hr noshade="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]" moz-do-not-send="true"><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 widely use psqlodb driver with unixODBC manager on my SLES12 linux machine.<br> Not very long ago I updated psqlodbc driver from <b> 10.03.0000</b> 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 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" face="sans-serif" color="blue"><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 program I use quite common ODBC functions to establish a connection, perform a query, retrieve a result: <br> SQLConnect, SQLExecDirect, 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" face="sans-serif" color="blue"><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 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" face="sans-serif" color="blue">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> </p> </blockquote> <div id="DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2"><br /> <table style="border-top: 1px solid #D3D4DE;"> <tr> <td style="width: 55px; padding-top: 18px;"><a href="http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient" target="_blank"><img src="https://ipmcdn.avast.com/images/icons/icon-envelope-tick-green-avg-v1.png" alt="" width="46" height="29" style="width: 46px; height: 29px;" /></a></td> <td style="width: 470px; padding-top: 17px; color: #41424e; font-size: 13px; font-family: Arial, Helvetica, sans-serif; line-height: 18px;">ウイルス フリー｡ <a href="http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient" target="_blank" style="color: #4453ea;">www.avg.com</a> </td> </tr> </table> <a href="#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2" width="1" height="1"> </a></div></body> </html> --------------5DFEA9C9094E77AEE5361F13--