[IGNITE-8702] Crash in ODBC driver under Informatica connection checker on Linux

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.4
• Fix Version/s: 2.7
• Component/s: odbc
• Assignee: Igor Sapego
• Reporter: Ilya Kasnacheev
• Created: 05/Jun/18 11:57
• Updated: 26/Jun/18 17:50
• Resolved: 07/Jun/18 15:41

Description

I'm trying to connect Informatica to Ignite via ODBC.

When I try to specify my connection as a ready-made DSN by its name, it starts connecting to remote but then fails:

[ikasnacheev@lab15 ODBC7.1]$ IGNITE_ODBC_LOG_PATH=/home/ikasnacheev/odbc2.log INFA_HOME=/storage/ssd/ikasnacheev LD_LIBRARY_PATH=/storage/ssd/ikasnacheev/ODBC7.1/lib:$LD_LIBRARY_PATH:/storage/ssd/ikasnacheev/services/shared/bin /storage/ssd/ikasnacheev/java/jre/bin/java -d64 -DpwdDecrypt=true -DconnectionName=Lab -DuserName=lab -Dpassword="nq/Jypc7Q2EhoQ2iAQlOCA==" -DconnectionString=LABignite -DdataStoreType=ODBC -DINFA_HOME=/storage/ssd/ikasnacheev -classpath '.:/storage/ssd/ikasnacheev/services/AdministratorConsole/webapps/administrator/WEB-INF/lib/*:/storage/ssd/ikasnacheev/services/shared/jars/platform/*:/storage/ssd/ikasnacheev/services/shared/jars/thirdparty/*:/storage/ssd/ikasnacheev/plugins/osgi/*:/storage/ssd/ikasnacheev/plugins/infa/*:/storage/ssd/ikasnacheev/plugins/dynamic/*' com.informatica.adminconsole.app.chain.commands.TestODBCConnection
...
#
# A fatal error has been detected by the Java Runtime Environment:
#
#  SIGSEGV (0xb) at pc=0x00007faeb806d5e4, pid=26471, tid=140392269498112
#
# JRE version: Java(TM) SE Runtime Environment (8.0_77-b03) (build 1.8.0_77-b03)
# Java VM: Java HotSpot(TM) 64-Bit Server VM (25.77-b03 mixed mode linux-amd64 compressed oops)
# Problematic frame:
# C  [libignite-odbc.so+0x2c5e4]  ignite::odbc::system::TcpSocketClient::Connect(char const*, unsigned short, int, ignite::odbc::diagnostic::Diagnosable&)+0x7b4

The contents of Ignite driver log file as follows:

SQLAllocEnv: SQLAllocEnv called
SQLSetEnvAttr: SQLSetEnvAttr called
AddStatusRecord: Adding new record: ODBC version is not supported., rowNum: 0, columnNum: 0
SQLAllocConnect: SQLAllocConnect called
SQLGetInfo: SQLGetInfo called: 77 (SQL_DRIVER_ODBC_VER), 7faec08d1450, 6, 7faf9f5a29ee
GetInfo: SQLGetInfo called: 77 (SQL_DRIVER_ODBC_VER), 7faec08d1450, 6, 7faf9f5a29ee
SQLSetConnectOption: SQLSetConnectOption called
SQLConnect: SQLConnect called

SQLConnect: DSN: LABignite
Connect: Host: 172.25.1.16, port: 10800
Connect: Addr: 172.25.1.16

Issue Links

• links to: GitHub Pull Request #4144