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

eWVzIGkga25vdy4gSSd2ZSBqdXN0IGNvcHkgYW5kIHBhc3RlZCB0aGUgc2Ft
ZSBtZXNzYWdlIGZyb20gdGhlIHVuaXggaW5jIG9kYmMgbGlzdC4gU3J5IGZv
ciB0aGF0LiBJdCBsb29rcyBsaWtlIHRoYXQgdGhlIGJ1ZyBpcyBpbnNpZGUg
dGhlIHBvc3RncmVzcWwgb2RiYyBkcml2ZXIuDQoNCg0KUm9iZXJ0IEhhYXMg
PHJvYmVydG1oYWFzQGdtYWlsLmNvbT4gaGF0IGdlc2NocmllYmVuOg0KDQoN
Ck9uIE1vbiwgT2N0IDEwLCAyMDExIGF0IDY6NDggQU0sIEhlaW1vIFN0aWVn
IDxoZWltby5zdGllZ0BuZXh0aXJhb25lLmV1PiB3cm90ZToNCj4gYWZ0ZXIg
Mi0zIGRheXMgb3VyIEZyZWVzd2l0Y2ggd2lsbCBjcmFzaC4NCj4gQWNjb3Jk
aW5nIHRvIHRoZSBidWcgcmVwb3J0IChodHRwOi8vamlyYS5mcmVlc3dpdGNo
Lm9yZy9icm93c2UvRlMtMzYwMCApIG9uDQo+IEZTLCB0aGlzIGlzIGFuIHVu
aXhvZGJjIGJ1Zy4NCj4NCj4gWW91IGNhbiBkb3dubG9hZCB0aGUgZnJlZXN3
aXRjaCBkZWJ1ZyBmcm9tIGdkYiBoZXJlOg0KPiBodHRwOi8vamlyYS5mcmVl
c3dpdGNoLm9yZy9zZWN1cmUvYXR0YWNobWVudC8xNDc1MS9vZGJjLnR4dA0K
DQpUaGlzIG1haWxpbmcgbGlzdCBpcyBmb3IgUG9zdGdyZVNRTCBidWdzLiAg
V2UgZG9uJ3QgbWFpbnRhaW4gdW5peE9EQkMuDQoNCi0tDQpSb2JlcnQgSGFh
cw0KRW50ZXJwcmlzZURCOiBodHRwOi8vd3d3LmVudGVycHJpc2VkYi5jb208
aHR0cDovL3d3dy5lbnRlcnByaXNlZGIuY29tLz4NClRoZSBFbnRlcnByaXNl
IFBvc3RncmVTUUwgQ29tcGFueQ0K

SGVsbG8sDQoNCmRvIHlvdSBuZWVkIGFueSBmdXJ0aGVyIEluZm9ybWF0aW9u
IHRvIHNvbHZlIHRoYXQgaXNzdWU/IE9yIGRvIHlvdSBoYXZlIGFueSBoaW50
cyBob3cgdG8gc29sdmUgaXQgYnkgbXlzZWxmPw0KDQpSZWdhcmRzDQpIZWlt
byBTdGllZw0KDQpWb246IFNUSUVHIEhlaW1vDQpHZXNlbmRldDogTW9udGFn
LCAxMC4gT2t0b2JlciAyMDExIDIzOjExDQpBbjogcm9iZXJ0bWhhYXNAZ21h
aWwuY29tDQpDYzogcGdzcWwtYnVnc0Bwb3N0Z3Jlc3FsLm9yZw0KQmV0cmVm
ZjogQVc6UmU6IFtCVUdTXSBCVUcgIzYyNDc6IEZyZWVzd2l0Y2ggd2lsbCBj
cmFzaCBhZnRlciAyLTMgZGF5cyB3aXRoaW4gb2RiYyBjb25uZWN0aW9uDQoN
CnllcyBpIGtub3cuIEkndmUganVzdCBjb3B5IGFuZCBwYXN0ZWQgdGhlIHNh
bWUgbWVzc2FnZSBmcm9tIHRoZSB1bml4IGluYyBvZGJjIGxpc3QuIFNyeSBm
b3IgdGhhdC4gSXQgbG9va3MgbGlrZSB0aGF0IHRoZSBidWcgaXMgaW5zaWRl
IHRoZSBwb3N0Z3Jlc3FsIG9kYmMgZHJpdmVyLg0KDQoNClJvYmVydCBIYWFz
IDxyb2JlcnRtaGFhc0BnbWFpbC5jb20+IGhhdCBnZXNjaHJpZWJlbjoNCg0K
T24gTW9uLCBPY3QgMTAsIDIwMTEgYXQgNjo0OCBBTSwgSGVpbW8gU3RpZWcg
PGhlaW1vLnN0aWVnQG5leHRpcmFvbmUuZXU+IHdyb3RlOg0KPiBhZnRlciAy
LTMgZGF5cyBvdXIgRnJlZXN3aXRjaCB3aWxsIGNyYXNoLg0KPiBBY2NvcmRp
bmcgdG8gdGhlIGJ1ZyByZXBvcnQgKGh0dHA6Ly9qaXJhLmZyZWVzd2l0Y2gu
b3JnL2Jyb3dzZS9GUy0zNjAwICkgb24NCj4gRlMsIHRoaXMgaXMgYW4gdW5p
eG9kYmMgYnVnLg0KPg0KPiBZb3UgY2FuIGRvd25sb2FkIHRoZSBmcmVlc3dp
dGNoIGRlYnVnIGZyb20gZ2RiIGhlcmU6DQo+IGh0dHA6Ly9qaXJhLmZyZWVz
d2l0Y2gub3JnL3NlY3VyZS9hdHRhY2htZW50LzE0NzUxL29kYmMudHh0DQoN
ClRoaXMgbWFpbGluZyBsaXN0IGlzIGZvciBQb3N0Z3JlU1FMIGJ1Z3MuICBX
ZSBkb24ndCBtYWludGFpbiB1bml4T0RCQy4NCg0KLS0NClJvYmVydCBIYWFz
DQpFbnRlcnByaXNlREI6IGh0dHA6Ly93d3cuZW50ZXJwcmlzZWRiLmNvbTxo
dHRwOi8vd3d3LmVudGVycHJpc2VkYi5jb20vPg0KVGhlIEVudGVycHJpc2Ug
UG9zdGdyZVNRTCBDb21wYW55DQo=

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

>
> 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 <http://www.enterprisedb.com/>
> The Enterprise PostgreSQL Company
>

T0gsIEkgdGhvdWdodCwgdGhhdCB0aGUgcHNxbCBtYWludGFpbnMgYWxzbyB0
aGUgb2RiYyBkcml2ZXIuDQoNCnRoYW5rcyBmb3IgdGhlIGluZm9ybWF0aW9u
Lg0KDQotLS0tLVVyc3Byw7xuZ2xpY2hlIE5hY2hyaWNodC0tLS0tDQpWb246
IFN0ZWZhbiBLYWx0ZW5icnVubmVyIFttYWlsdG86c3RlZmFuQGthbHRlbmJy
dW5uZXIuY2NdIA0KR2VzZW5kZXQ6IE1pdHR3b2NoLCAxMi4gT2t0b2JlciAy
MDExIDA4OjUxDQpBbjogU1RJRUcgSGVpbW8NCkNjOiBwZ3NxbC1idWdzQHBv
c3RncmVzcWwub3JnOyByb2JlcnRtaGFhc0BnbWFpbC5jb20NCkJldHJlZmY6
IFJlOiBbQlVHU10gQlVHICM2MjQ3OiBGcmVlc3dpdGNoIHdpbGwgY3Jhc2gg
YWZ0ZXIgMi0zIGRheXMgd2l0aGluIG9kYmMgY29ubmVjdGlvbg0KDQpPbiAx
MC8xMi8yMDExIDA4OjQwIEFNLCBTVElFRyBIZWltbyB3cm90ZToNCj4gSGVs
bG8sDQo+IA0KPiAgDQo+IA0KPiBkbyB5b3UgbmVlZCBhbnkgZnVydGhlciBJ
bmZvcm1hdGlvbiB0byBzb2x2ZSB0aGF0IGlzc3VlPyBPciBkbyB5b3UgaGF2
ZQ0KPiBhbnkgaGludHMgaG93IHRvIHNvbHZlIGl0IGJ5IG15c2VsZj8NCg0K
d2VsbCB0aGlzIGxpc3QgaXMgZm9yIFBvc3RncmVTUUwgYnVncywgd2UgZG9u
J3QgbWFpbnRhaW4gdW5peE9EQkMgbm9yIGRvDQp3ZSBtYWludGFpbiB0aGUg
cG9zdGdyZXNxbCBvZGJjIGRyaXZlciAtIHRvIHF1b3RlIHRoZSBidWctcmVw
b3J0aW5nIGZvcm06DQoNCiJUaGlzIGJ1ZyByZXBvcnQgZm9ybSBzaG91bGQg
b25seSBiZSB1c2VkIGZvciByZXBvcnRpbmcgYnVncyBhbmQNCnByb2JsZW1z
IHdpdGggdGhlIFBvc3RncmVTUUwgZGF0YWJhc2UuIFByb2JsZW1zIHdpdGgg
ZGF0YWJhc2UgY29ubmVjdG9ycw0Kc3VjaCBhcyBPREJDIGFuZCBKREJDLCBn
cmFwaGljYWwgYWRtaW5pc3RyYXRpb24gdG9vbHMgc3VjaCBhcyBwZ0FkbWlu
IG9yDQpvdGhlciBleHRlcm5hbCBwcm9qZWN0cyBzaG91bGQgbm90IGJlIHJl
cG9ydGVkIGhlcmU7IHBsZWFzZSByZXBvcnQgdG8NCnRob3NlIHByb2plY3Rz
IGRpcmVjdGx5LiBGb3IgcHJvZHVjdHMgY2xvc2VseSBjb25uZWN0ZWQgd2l0
aCBQb3N0Z3JlU1FMLA0KdGhlcmUgbWF5IGJlIGFuIGFwcHJvcHJpYXRlIG1h
aWxpbmcgbGlzdCBhdmFpbGFibGUuIg0KDQoNCkluIHRoaXMgY2FzZSBJIHdv
dWxkIGFkdmlzZSB5b3UgdG8gZWl0aGVyIGFzayBvbiBwZ3NxbC1vZGJjIG9y
IGZpbGwgb3V0DQphIGJ1Z3JlcG9ydCBvbiB0aGUgcHJvamVjdHMgd2Vic2l0
ZTogaHR0cDovL3BnZm91bmRyeS5vcmcvcHJvamVjdHMvcHNxbG9kYmMvDQoN
Cg0KcmVnYXJkcw0KDQoNClN0ZWZhbg0KDQo+IA0KPiBSZWdhcmRzDQo+IA0K
PiBIZWltbyBTdGllZw0KPiANCj4gIA0KPiANCj4gKlZvbjoqIFNUSUVHIEhl
aW1vDQo+ICpHZXNlbmRldDoqIE1vbnRhZywgMTAuIE9rdG9iZXIgMjAxMSAy
MzoxMQ0KPiAqQW46KiByb2JlcnRtaGFhc0BnbWFpbC5jb20NCj4gKkNjOiog
cGdzcWwtYnVnc0Bwb3N0Z3Jlc3FsLm9yZw0KPiAqQmV0cmVmZjoqIEFXOlJl
OiBbQlVHU10gQlVHICM2MjQ3OiBGcmVlc3dpdGNoIHdpbGwgY3Jhc2ggYWZ0
ZXIgMi0zIGRheXMNCj4gd2l0aGluIG9kYmMgY29ubmVjdGlvbg0KPiANCj4g
IA0KPiANCj4geWVzIGkga25vdy4gSSd2ZSBqdXN0IGNvcHkgYW5kIHBhc3Rl
ZCB0aGUgc2FtZSBtZXNzYWdlIGZyb20gdGhlIHVuaXggaW5jDQo+IG9kYmMg
bGlzdC4gU3J5IGZvciB0aGF0LiBJdCBsb29rcyBsaWtlIHRoYXQgdGhlIGJ1
ZyBpcyBpbnNpZGUgdGhlDQo+IHBvc3RncmVzcWwgb2RiYyBkcml2ZXIuDQo+
IA0KPiANCj4gUm9iZXJ0IEhhYXMgPHJvYmVydG1oYWFzQGdtYWlsLmNvbT4g
aGF0IGdlc2NocmllYmVuOg0KPiANCj4gT24gTW9uLCBPY3QgMTAsIDIwMTEg
YXQgNjo0OCBBTSwgSGVpbW8gU3RpZWcgPGhlaW1vLnN0aWVnQG5leHRpcmFv
bmUuZXU+DQo+IHdyb3RlOg0KPj4gYWZ0ZXIgMi0zIGRheXMgb3VyIEZyZWVz
d2l0Y2ggd2lsbCBjcmFzaC4NCj4+IEFjY29yZGluZyB0byB0aGUgYnVnIHJl
cG9ydCAoaHR0cDovL2ppcmEuZnJlZXN3aXRjaC5vcmcvYnJvd3NlL0ZTLTM2
MDAgKSBvbg0KPj4gRlMsIHRoaXMgaXMgYW4gdW5peG9kYmMgYnVnLg0KPj4N
Cj4+IFlvdSBjYW4gZG93bmxvYWQgdGhlIGZyZWVzd2l0Y2ggZGVidWcgZnJv
bSBnZGIgaGVyZToNCj4+IGh0dHA6Ly9qaXJhLmZyZWVzd2l0Y2gub3JnL3Nl
Y3VyZS9hdHRhY2htZW50LzE0NzUxL29kYmMudHh0DQo+IA0KPiBUaGlzIG1h
aWxpbmcgbGlzdCBpcyBmb3IgUG9zdGdyZVNRTCBidWdzLiAgV2UgZG9uJ3Qg
bWFpbnRhaW4gdW5peE9EQkMuDQo+IA0KPiAtLSANCj4gUm9iZXJ0IEhhYXMN
Cj4gRW50ZXJwcmlzZURCOiBodHRwOi8vd3d3LmVudGVycHJpc2VkYi5jb20g
PGh0dHA6Ly93d3cuZW50ZXJwcmlzZWRiLmNvbS8+DQo+IFRoZSBFbnRlcnBy
aXNlIFBvc3RncmVTUUwgQ29tcGFueQ0KPiANCg0K

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