Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

DG4ODBC on Linux-64 connection fail [ODBC81] #80

Closed
firebird-automations opened this issue Mar 29, 2010 · 15 comments
Closed

DG4ODBC on Linux-64 connection fail [ODBC81] #80

firebird-automations opened this issue Mar 29, 2010 · 15 comments

Comments

@firebird-automations
Copy link

Submitted by: Andrew (andy)

Attachments:
strace_log.rar
odbc.log
dg4odbc.log
dg4odbc_config_files.rar
unixODBC_trace.log
U53Fb4ODBC_agt_20601.trc
hs_core_trace_21439.trc

Votes: 1

I have a 2 servers on Ubuntu 9.04 with Oracle11r2 with same configuration. One of them with 32, and other with 64 bit architecture. For connection to firebird I use IBPhoenix ODBC driver - implementation for 32 and 64 bit. From Linux32 everything ok, but from 64 I got error ORA-28511: connection HS Agent lost. First few queries were almost succesful (error something about charcterset conversion), but now only ORA-28511:( Connection by unixODBC's isql to DSN-source is OK.

@firebird-automations
Copy link
Author

Modified by: Andrew (andy)

Attachment: strace_log.rar [ 11603 ]

Attachment: odbc.log [ 11604 ]

Attachment: dg4odbc.log [ 11605 ]

@firebird-automations
Copy link
Author

Modified by: Andrew (andy)

Attachment: dg4odbc_config_files.rar [ 11606 ]

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

Link: This issue block progress on ODBC98 [ ODBC98 ]

@firebird-automations
Copy link
Author

Commented by: Ivan Volnikov (ivan_v)

That problem was solved in ODBC68 - it is the same

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

Link: This issue block progress on ODBC98 [ ODBC98 ] =>

@firebird-automations
Copy link
Author

Commented by: Fred (bomek)

This issue is not solved as stated.

I run Oracle x64 11.2.0.2.0 and http://libOdbcFb.so 02.00.0151.

The driver segfault at the same location (right after "SQLGetInfo returns Y for SQL_COLUMN_ALIAS")

@firebird-automations
Copy link
Author

Commented by: Stanislav Studený (studeny)

Hello.

I'm running x86_64 Oracle 11.2.0.4.0, unixODBC 2.3.2 + OdbcFb-LIB-2.0.2.153.amd64.tar + firebird-libfbclient-2.5.2.26539.0-3.el6.x86_64 and I have similar problem.
I'm able to connect using isql and issue the select command, but i'm not able to make a select from Oracle -> DG4ODBC Gateway -> unixODBC manager -> ODBC Firebird driver -> Firebird. All fails after SQLFetch.c :

[ODBC][20601][1387355005.518760][SQLGetTypeInfo.c][318]
Exit:[SQL_SUCCESS]
[ODBC][20601][1387355005.518826][SQLFetch.c][162]
Entry:
Statement = 0x1fc8dc0

Trace from unixODBC and DG4ODBC will be uploaded.

@firebird-automations
Copy link
Author

Commented by: Stanislav Studený (studeny)

unixODBC 2.3.2 trace file

@firebird-automations
Copy link
Author

Modified by: Stanislav Studený (studeny)

Attachment: unixODBC_trace.log [ 12405 ]

@firebird-automations
Copy link
Author

Commented by: Stanislav Studený (studeny)

x86_64 11.2.0.4 Oracle DG4ODBC tracefile

@firebird-automations
Copy link
Author

Modified by: Stanislav Studený (studeny)

Attachment: U53Fb4ODBC_agt_20601.trc [ 12406 ]

@firebird-automations
Copy link
Author

Commented by: Stanislav Studený (studeny)

Uploaded DG4ODBC core stacktrace hs_core_trace_21439.trc

failing call is _ZN15OdbcJdbcLibrary11OdbcConvert21convVarStringToStringEPNS_10DescRecordES2_()+308

@firebird-automations
Copy link
Author

Modified by: Stanislav Studený (studeny)

Attachment: hs_core_trace_21439.trc [ 12407 ]

@firebird-automations
Copy link
Author

Commented by: Stanislav Studený (studeny)

Driver compiled from source on RHEL 6.4, and now it works...

LDD of working library after compilation:

#⁠ ldd http://libOdbcFb.so
linux-vdso.so.1 => (0x00007fff893e4000)
libcrypt.so.1 => /lib64/libcrypt.so.1 (0x00007f7503433000)
libdl.so.2 => /lib64/libdl.so.2 (0x00007f750322f000)
libodbcinst.so.1 => /usr/local/unixODBC/lib/libodbcinst.so.1 (0x00007f7503018000)
libstdc++.so.6 => /usr/lib64/libstdc++.so.6 (0x00007f7502d12000)
libm.so.6 => /lib64/libm.so.6 (0x00007f7502a8e000)
libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007f7502877000)
libc.so.6 => /lib64/libc.so.6 (0x00007f75024e4000)
http://libfreebl3.so => /lib64/libfreebl3.so (0x00007f7502282000)
/lib64/ld-linux-x86-64.so.2 (0x00007f75039db000)
libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f7502064000)

LDD of not working lib from : http://sourceforge.net/projects/firebird/files/firebird-ODBC-driver/2.0.2-Release/OdbcFb-LIB-2.0.2.153.amd64.gz/download

#⁠ ldd http://libOdbcFb.so
linux-vdso.so.1 => (0x00007fffc1b76000)
libdl.so.2 => /lib64/libdl.so.2 (0x00007ff9a90f2000)
libodbcinst.so.1 => /usr/local/unixODBC/lib/libodbcinst.so.1 (0x00007ff9a8eda000)
libstdc++.so.6 => /usr/lib64/libstdc++.so.6 (0x00007ff9a8bd4000)
libm.so.6 => /lib64/libm.so.6 (0x00007ff9a8950000)
libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007ff9a873a000)
libc.so.6 => /lib64/libc.so.6 (0x00007ff9a83a7000)
/lib64/ld-linux-x86-64.so.2 (0x00007ff9a9618000)
libpthread.so.0 => /lib64/libpthread.so.0 (0x00007ff9a818a000)

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

status: Open [ 1 ] => Closed [ 6 ]

resolution: Fixed [ 1 ]

Fix Version: 2.0.3 [ 10581 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant