Issue Details (XML | Word | Printable)

Key: ODBC-81
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Unassigned
Reporter: Andrew
Votes: 1
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
ODBC Driver

DG4ODBC on Linux-64 connection fail

Created: 29/Mar/10 06:01 AM   Updated: 01/Jan/15 03:33 PM
Component/s: None
Affects Version/s: 2.0 RC1
Fix Version/s: 2.0.3

File Attachments: 1. Text File dg4odbc.log (10 kB)
2. File dg4odbc_config_files.rar (2 kB)
3. File hs_core_trace_21439.trc (115 kB)
4. Text File odbc.log (16 kB)
5. File strace_log.rar (16 kB)
6. File U53Fb4ODBC_agt_20601.trc (10 kB)
7. Text File unixODBC_trace.log (7 kB)

Environment: Ubuntu 9.04, 64-bit. ODBC Driver 2.0.148 64-bit. Oracle DG4ODBC 11.2.0.1.0 64-bit.


 Description  « Hide
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.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Andrew made changes - 29/Mar/10 06:05 AM
Field Original Value New Value
Attachment strace_log.rar [ 11603 ]
Attachment odbc.log [ 11604 ]
Attachment dg4odbc.log [ 11605 ]
Andrew made changes - 29/Mar/10 06:06 AM
Attachment dg4odbc_config_files.rar [ 11606 ]
Alexander Potapchenko made changes - 21/Dec/10 02:58 PM
Link This issue block progress on ODBC-98 [ ODBC-98 ]
Ivan Volnikov added a comment - 28/Feb/11 02:15 PM
That problem was solved in http://tracker.firebirdsql.org/browse/ODBC-68 - it is the same

Alexander Potapchenko made changes - 08/Mar/11 09:22 AM
Link This issue block progress on ODBC-98 [ ODBC-98 ]
Fred added a comment - 17/Nov/11 04:04 PM
This issue is not solved as stated.

I run Oracle x64 11.2.0.2.0 and libOdbcFb.so 02.00.0151.

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

Stanislav Studený added a comment - 18/Dec/13 08:42 AM - edited
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.

Stanislav Studený added a comment - 18/Dec/13 08:43 AM
unixODBC 2.3.2 trace file

Stanislav Studený made changes - 18/Dec/13 08:43 AM
Attachment unixODBC_trace.log [ 12405 ]
Stanislav Studený added a comment - 18/Dec/13 08:46 AM
x86_64 11.2.0.4 Oracle DG4ODBC tracefile

Stanislav Studený made changes - 18/Dec/13 08:46 AM
Attachment U53Fb4ODBC_agt_20601.trc [ 12406 ]
Stanislav Studený added a comment - 18/Dec/13 09:10 AM
Uploaded DG4ODBC core stacktrace hs_core_trace_21439.trc

failing call is _ZN15OdbcJdbcLibrary11OdbcConvert21convVarStringToStringEPNS_10DescRecordES2_()+308

Stanislav Studený made changes - 18/Dec/13 09:10 AM
Attachment hs_core_trace_21439.trc [ 12407 ]
Stanislav Studený added a comment - 18/Dec/13 12:26 PM
Driver compiled from source on RHEL 6.4, and now it works...

LDD of working library after compilation:

# ldd 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)
        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 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)

Alexander Potapchenko made changes - 01/Jan/15 03:33 PM
Status Open [ 1 ] Closed [ 6 ]
Fix Version/s 2.0.3 [ 10581 ]
Resolution Fixed [ 1 ]