Re: BUG #6247: Freeswitch will crash after 2-3 days within odbc connection

Hello,

do you need any further Information to solve that issue? Or do you have any hints how to solve it by myself?

Regards
Heimo Stieg

Von: STIEG Heimo
Gesendet: Montag, 10. Oktober 2011 23:11
An: robertmhaas@gmail.com
Cc: pgsql-bugs@postgresql.org
Betreff: AW:Re: [BUGS] BUG #6247: Freeswitch will crash after 2-3 days within odbc connection

yes i know. I've just copy and pasted the same message from the unix inc odbc list. Sry for that. It looks like that the bug is inside the postgresql odbc driver.

Robert Haas <robertmhaas@gmail.com> hat geschrieben:

On Mon, Oct 10, 2011 at 6:48 AM, Heimo Stieg <heimo.stieg@nextiraone.eu> wrote:

after 2-3 days our Freeswitch will crash.
According to the bug report (http://jira.freeswitch.org/browse/FS-3600 ) on
FS, this is an unixodbc bug.

You can download the freeswitch debug from gdb here:
http://jira.freeswitch.org/secure/attachment/14751/odbc.txt

This mailing list is for PostgreSQL bugs. We don't maintain unixODBC.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com&lt;http://www.enterprisedb.com/&gt;
The Enterprise PostgreSQL Company

On 10/12/2011 08:40 AM, STIEG Heimo wrote:

Hello,

do you need any further Information to solve that issue? Or do you have
any hints how to solve it by myself?

well this list is for PostgreSQL bugs, we don't maintain unixODBC nor do
we maintain the postgresql odbc driver - to quote the bug-reporting form:

"This bug report form should only be used for reporting bugs and
problems with the PostgreSQL database. Problems with database connectors
such as ODBC and JDBC, graphical administration tools such as pgAdmin or
other external projects should not be reported here; please report to
those projects directly. For products closely connected with PostgreSQL,
there may be an appropriate mailing list available."

In this case I would advise you to either ask on pgsql-odbc or fill out
a bugreport on the projects website: http://pgfoundry.org/projects/psqlodbc/

regards

Stefan

OH, I thought, that the psql maintains also the odbc driver.

thanks for the information.

-----Ursprüngliche Nachricht-----
Von: Stefan Kaltenbrunner [mailto:stefan@kaltenbrunner.cc]
Gesendet: Mittwoch, 12. Oktober 2011 08:51
An: STIEG Heimo
Cc: pgsql-bugs@postgresql.org; robertmhaas@gmail.com
Betreff: Re: [BUGS] BUG #6247: Freeswitch will crash after 2-3 days within odbc connection

On 10/12/2011 08:40 AM, STIEG Heimo wrote:

Hello,

do you need any further Information to solve that issue? Or do you have
any hints how to solve it by myself?

well this list is for PostgreSQL bugs, we don't maintain unixODBC nor do
we maintain the postgresql odbc driver - to quote the bug-reporting form:

"This bug report form should only be used for reporting bugs and
problems with the PostgreSQL database. Problems with database connectors
such as ODBC and JDBC, graphical administration tools such as pgAdmin or
other external projects should not be reported here; please report to
those projects directly. For products closely connected with PostgreSQL,
there may be an appropriate mailing list available."

In this case I would advise you to either ask on pgsql-odbc or fill out
a bugreport on the projects website: http://pgfoundry.org/projects/psqlodbc/

regards

Stefan

On 10/12/2011 03:21 PM, STIEG Heimo wrote:

OH, I thought, that the psql maintains also the odbc driver.

The PostgreSQL odbc driver, psqlODBC, is maintained as a project
associated with (though not part of) PostgreSQL proper.

unixODBC, which is the ODBC implementation for UNIX, has nothing to do
with PostgreSQL. I think the PostgreSQL ODBC driver is primarily used on
Windows for ODBC on Windows systems, though of course unixODBC should
also be supported.

Looking at your stack trace, it doesn't look like the psqlODBC driver is
involved, unless it's indirectly by corrupting memory. It crashes in
unixODBC proper.

If you have an issue with unixODBC its self, you need to report that to
the unixODBC maintainers. See http://www.unixodbc.org/

If the issue does turn out to be with the psqlODBC driver, then please
provide more detail including `mylog' from the psqlODBC driver, the ODBC
trace logs, a query history from PostgreSQL, an explanation of your
reasoning, and preferably a self-contained test case allowing others to
reproduce the issue without having to have freeswitch etc.

--
Craig Ringer