ibm_db does not compile under node 11.0

[ukulanne]

[panda@pandaville node-ibm_db]$ npm install

ibm_db@2.4.1 install /home/panda/src/git/node-ibm_db node installer/driverInstall.js

Downloading DB2 ODBC CLI Driver from https://public.dhe.ibm.com/ibmdl/export/pub/software/data/db2/drivers/odbc_cli/linuxx64_odbc_cli.tar.gz...

100.00% | 21040638 bytes downloaded out of 21040638 bytes.

---

You are downloading a package which includes the Node.js module for IBM DB2/Informix. The module is licensed under the Apache License 2.0. The package also includes IBM ODBC and CLI Driver from IBM, which is automatically downloaded as the node module is installed on your system/device. The license agreement to the IBM ODBC and CLI Driver is available in undefined Check for additional dependencies, which may come with their own license agreement(s). Your use of the components of the package and dependencies constitutes your acceptance of their respective license agreements. If you do not accept the terms of any license agreement(s), then delete the relevant component(s) from your device.

---

Downloading and extraction of DB2 ODBC CLI Driver completed successfully ...

make: Entering directory '/home/panda/src/git/node-ibm_db/build' CXX(target) Release/obj.target/odbc_bindings/src/odbc.o make: Leaving directory '/home/panda/src/git/node-ibm_db/build'

{ Error: Command failed: node-gyp configure build --IS_DOWNLOADED=true --IBM_DB_HOME="$IBM_DB_HOME" In file included from ../node_modules/nan/nan_new.h:189, from ../node_modules/nan/nan.h:222, from ../src/odbc.h:23, from ../src/odbc.cpp:28: ../node_modules/nan/nan_implementation_12_inl.h: In static member function ‘static Nan::imp::FactoryBase::return_t Nan::imp::Factory::New(v8::Local)’: ../node_modules/nan/nan_implementation_12_inl.h:337:37: warning: ‘static v8::Local v8::StringObject::New(v8::Local)’ is deprecated: Use Isolate version [-Wdeprecated-declarations] return v8::StringObject::New(value).As(); ^ In file included from /home/panda/.node-gyp/11.0.0/include/node/v8.h:26, from ../src/odbc.cpp:22: /home/panda/.node-gyp/11.0.0/include/node/v8.h:5236:37: note: declared here static Local New(Local value)); ^~~ /home/panda/.node-gyp/11.0.0/include/node/v8config.h:326:3: note: in definition of macro ‘V8_DEPRECATED’ declarator attribute((deprecated(message))) ^~~~~~ In file included from ../node_modules/nan/nan_new.h:189, from ../node_modules/nan/nan.h:222, from ../src/odbc.h:23, from ../src/odbc.cpp:28: ../node_modules/nan/nan_implementation_12_inl.h:337:37: warning: ‘static v8::Local v8::StringObject::New(v8::Local)’ is deprecated: Use Isolate version [-Wdeprecated-declarations] return v8::StringObject::New(value).As(); ^ In file included from /home/panda/.node-gyp/11.0.0/include/node/v8.h:26, from ../src/odbc.cpp:22: /home/panda/.node-gyp/11.0.0/include/node/v8.h:5236:37: note: declared here static Local New(Local value)); ^~~ /home/panda/.node-gyp/11.0.0/include/node/v8config.h:326:3: note: in definition of macro ‘V8_DEPRECATED’ declarator attribute((deprecated(message))) ^~~~~~ In file included from ../src/odbc.h:23, from ../src/odbc.cpp:28: ../node_modules/nan/nan.h: In constructor ‘Nan::Utf8String::Utf8String(v8::Local)’: ../node_modules/nan/nan.h:1063:53: warning: ‘v8::Local v8::Value::ToString() const’ is deprecated: Use maybe version [-Wdeprecated-declarations] v8::Local string = from->ToString(); ^ In file included from ../src/odbc.cpp:22: /home/panda/.node-gyp/11.0.0/include/node/v8.h:10242:15: note: declared here Local Value::ToString() const { ^~~~~ In file included from ../src/odbc.h:23, from ../src/odbc.cpp:28: ../nodemodules/nan/nan.h:1073:74: warning: ‘int v8::String::WriteUtf8(char, int, int, int) const’ is deprecated: Use Isolate* version [-Wdeprecated-declarations] length = string->WriteUtf8(str_, static_cast(len), 0, flags); ^ In file included from /home/panda/.node-gyp/11.0.0/include/node/v8.h:26, from ../src/odbc.cpp:22: /home/panda/.node-gyp/11.0.0/include/node/v8.h:2754:21: note: declared here int WriteUtf8(char buffer, int length = -1, ^~~~~ /home/panda/.node-gyp/11.0.0/include/node/v8config.h:326:3: note: in definition of macro ‘V8_DEPRECATED’ declarator attribute((deprecated(message))) ^~~~~~ In file included from ../src/odbc.h:23, from ../src/odbc.cpp:28: ../node_modules/nan/nan.h: In function ‘void Nan::AsyncQueueWorker(Nan::AsyncWorker)’: ../node_modules/nan/nan.h:2200:62: warning: cast between incompatible function types from ‘void ()(uv_work_t)’ {aka ‘void ()(uv_work_s)’} to ‘uv_after_work_cb’ {aka ‘void ()(uv_work_s, int)’} [-Wcast-function-type] , reinterpret_cast(AsyncExecuteComplete) ^ ../src/odbc.cpp: In static member function ‘static void ODBC::UV_AfterCreateConnection(uv_work_t, int)’: ../src/odbc.cpp:210:27: warning: ‘v8::Local Nan::Callback::Call(int, v8::Local) const’ is deprecated [-Wdeprecated-declarations] data->cb->Call(1, info); ^ In file included from ../src/odbc.h:23, from ../src/odbc.cpp:28: ../node_modules/nan/nan.h:1647:3: note: declared here Call(int argc, v8::Local argv[]) const { ^~~~ ../src/odbc.cpp:217:99: error: no matching function for call to ‘v8::Function::NewInstance(int, v8::Local [2])’ Local

[bimalkjha]

@ukulanne Please install using npm install git+https://git@github.com/rhtpandeyIN/node-ibm_db.git command. It should work. Thanks.

[huineng]

That clone is 26 commits behind ibm_db . is that an issue ?

[rhtpandeyIN]

Hi @huineng , check that now, I have merged it with the latest code.

[ukulanne]

What can we do so the contents on that branch be pushed to master? Apart from the AIX problems what other problems are there. Now that node 10 is LTS this seems very important. I am not sure that any one would want to develop production code that relies on on released modules.

[bimalkjha]

@ukulanne Only 2 problems are there. AIX and mac. The AIX problem is on mac too. We are looking into it. On mac, we don't see the issue with debug build i.e. when we use --debug option with node-gyp to compile the code. Same should be on AIX too. Adding some printf in the code fixes the issue for few test case, but other test case starts failing. It seems something related to memory management or how clidriver get loaded with newer version of load. Same code with older version of node works fine, but just by changing the node version fails. Thanks.

[bimalkjha]

@ukulanne Seems code changed by commit https://github.com/ibmdb/node-ibm_db/commit/1b7d5c69a87b363e6448781df7e7d076edc25e13 did some miracle for this issue. Please have a fresh install of ibm_db using command: npm install git+https://git@github.com/ibmdb/node-ibm_db.git and nodev 11.0. Fresh install to download the updated version of clidriver that older install do not have. I have merged the pull request to maser now. It works for me on Mac, Windows and Linux platforms. Thanks.

[huineng]

seems to work indeed

[ukulanne]

Still core dumping.

[panda@panda test]$ node test-all-data-types.js 
[ { C1: 1,
    C2: 2,
    C3: '456736789',
    C4: 1234,
    C5: '67',
    C6: '5689',
    C7: 56.239,
    C8: 34567890,
    C9: '45.234',
    C10: 'bimal     ',
    C11: 'kumar',
    C12: '50',
    C13: 'jha123456',
    C14: '2015-09-10',
    C15: '10:16:33',
    C16: '2015-09-10 10:16:33.770139',
    C17: 'abc' } ]
Illegal instruction (core dumped)

I had to add change the timeout to the test to run:

const options = { connectTimeout : 10000}//, systemNaming : true }

    ibmdb.open(cn, options, function(err, conn) {

Is there an issue number where I can see what was the problem on MacOs? It could have been a different issue.

[ukulanne]

Previously you mentioned

we use --debug option with node-gyp to compile the code. Same should be on AIX too.

Where / how do I add the flag?

[ukulanne]

Similar core than the one found on #439 . Again things seems to work until the script finishes.

[panda@panda test]$ gdb node core
GNU gdb (GDB) 7.12.1
Copyright (C) 2017 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.  Type "show copying"
and "show warranty" for details.
This GDB was configured as "powerpc64-ibm-aix6.1.2.0".
Type "show configuration" for configuration details.
For bug reporting instructions, please see:
<http://www.gnu.org/software/gdb/bugs/>.
Find the GDB manual and other documentation resources online at:
<http://www.gnu.org/software/gdb/documentation/>.
For help, type "help".
Type "apropos word" to search for commands related to "word"...
Reading symbols from node...done.

warning: core file may not match specified executable file.
Core was generated by `node'.
Program terminated with signal SIGILL, Illegal instruction.
#0  0x0000000000000000 in ?? ()
(gdb)  thread apply all backtrace full

Thread 1 (process 1):
#0  0x0000000000000000 in ?? ()
No symbol table info available.
#1  0x0900000000561d50 in __new_exitfn ()
   from /opt/freeware/lib/gcc/powerpc-ibm-aix7.1.0.0/6.3.0/pthread/ppc64/libgcc_s.a(shr.o)
No symbol table info available.
#2  0x22828228a0113490 in ?? ()
No symbol table info available.
#3  0x0000000101584194 in _GLOBAL__FD_node ()
No symbol table info available.
#4  0x09fffffff000afa0 in mod_fini1 () from /usr/ccs/bin/usla64
No symbol table info available.
#5  0x09fffffff000bf48 in usl_fini_mods () from /usr/ccs/bin/usla64
No symbol table info available.
#6  0x09fffffff000aeac in usl_exit_fini () from /usr/ccs/bin/usla64
No symbol table info available.
#7  0x09fffffff000bdec in usl_exit_fini_mods () from /usr/ccs/bin/usla64
No symbol table info available.
#8  0x0900000000001714 in __modfini64 () from /usr/lib/libc.a(shr_64.o)
No symbol table info available.
#9  0x0900000000057454 in exit () from /usr/lib/libc.a(shr_64.o)
No symbol table info available.
#10 0x0000000100000314 in __start ()
No symbol table info available.

[bimalkjha]

@ukulanne The mac test result is pasted here: https://github.com/ibmdb/node-ibm_db/pull/398#issuecomment-388958059 I do not have stack trace.

Debug option can be enabled if you are recompiling ibm_db as documented here: https://github.com/ibmdb/node-ibm_db#debug Basically you can do that by executing below commands from ibm_db directory:

1. export IBM_DB_HOME=<path/to/clidriver>
2. export PATH=$IBM_DB_HOME/bin:$IBM_DB_HOME/lib:$PATH
3. export LIBPATH=IBM_DB_HOME/lib:$LIBPATH
2. npm install -g node_gyp
3. node-gyp rebuild --debug --IBM_DB_HOME=$IBM_DB_HOME  --IS_DOWNLOADED=true

thanks.

[ukulanne]

The mac tests shows a lot of SIGFPE while I am getting SIGILLs so they might have not been related.

[ukulanne]

[panda@panda aix-server-example]$ node db2.js 
ODBC::Init
ODBCResult::Init
ODBCConnection::Init
ODBCStatement::Init
DATABASE=***
ODBC::New - Entry
ODBC::New - Exit
ODBC::CreateConnection - Entry
ODBC::CreateConnection - Exit
ODBC::UV_CreateConnection - Entry
ODBC::UV_CreateConnection - Exit: hDBC = 1
ODBC::UV_AfterCreateConnection - Entry
ODBCConnection::New
ODBCConnection::Open - Entry
ODBCConnection::Open - Exit
ODBC::UV_AfterCreateConnection - Exit
ODBCConnection::UV_Open - Entry
ODBCConnection::SetConnectionAttributes - timeOut = 10000, systemNaming = 1
ODBCConnection::UV_Open - Exit
ODBCConnection::UV_AfterOpen - Entry
ODBCConnection::Query - Entry
ODBCConnection::Query : sqlLen=100, sqlSize=101, sql=select USER_ID, INTRANET, FULLNAME, IS_AUTHORIZED from PANDA.USER WHERE INTRANET='panda@panda.com', hDBC=1
ODBCConnection::Query - Exit for hDBC=1
ODBCConnection::UV_AfterOpen - Exit
ODBCConnection::UV_Query - Entry: hDBC=1
ODBCConnection::UV_Query - Exit: hDBC=1
ODBCConnection::UV_AfterQuery - Entry
ODBCConnection::UV_AfterQuery : data->result=0, data->noResultObject=0, stmt=10001
ODBCConnection::UV_AfterQuery : outParamCount=0
ODBCResult::New
ODBCResult::New m_hENV=1 m_hDBC=1 m_hSTMT=10001 canFreeHandle=1
ODBCResult::FetchAll - Entry
ODBCResult::FetchAll - Exit
ODBCConnection::UV_AfterQuery - Exit
ODBCResult::UV_FetchAll - Entry
ODBCResult::UV_FetchAll - Exit, return code = 0 for stmt 10001
ODBCResult::UV_AfterFetchAll - Entry
ODBC::GetColumns - Entry
ODBC::GetColumns index = 1, buflen=7
ODBC::GetColumns index = 2, buflen=8
ODBC::GetColumns index = 3, buflen=8
ODBC::GetColumns index = 4, buflen=13
ODBC::GetColumns - Exit
ODBCResult::UV_AfterFetchAll, colcount = 4, columns = 275099664, stmt = 10001
Column Type : 4 9       11      92
ODBC::GetColumnValue - Integer: index=1 name=USER_ID type=4 len=4 ret=0
Column Type : 12        9       11      92
ODBC::GetColumnValue - String: index=2 name=INTRANET type=12 len=18 ret=0 bufferLength=1022
Column Type : 12        9       11      92
ODBC::GetColumnValue - String: index=3 name=FULLNAME type=12 len=10 ret=0 bufferLength=1022
Column Type : 5 9       11      92
ODBC::GetColumnValue - Integer: index=4 name=IS_AUTHORIZED type=5 len=4 ret=0
ODBCResult::UV_AfterFetchAll - Exit
ODBCResult::UV_FetchAll - Entry
ODBCResult::UV_FetchAll - Exit, return code = 100 for stmt 10001
ODBCResult::UV_AfterFetchAll - Entry
ODBCResult::UV_AfterFetchAll Done for stmt 10001
ODBCResult::MoreResultsSync
ODBCResult::CloseSync - Entry
ODBCResult::CloseSync closeOption=9999 m_canFreeHandle=1, hSTMT=10001
ODBCResult::Free m_hSTMT=10001 m_canFreeHandle=1
ODBCResult::Free() Done.
ODBCResult::CloseSync - Exit
[ { USER_ID: 3,
    INTRANET: 'panda@panda.com',
    FULLNAME: 'Panda Panda',
    IS_AUTHORIZED: 1 } ]
ODBCConnection::Close
ODBCResult::UV_AfterFetchAll - Exit
ODBCConnection::UV_Close
ODBCConnection::Free m_hDBC = 1 
ODBCConnection::UV_AfterClose

Illegal instruction (core dumped)

[ukulanne]

[panda@panda aix-server-example]$ dbx /opt/node/bin/node core
Type 'help' for help.
warning: The core file is not a fullcore. Some info may
not be available.
[using memory image in core]
reading symbolic information ...internal error: assertion failed at line 6656 in file object.c
internal error: assertion failed at line 6656 in file object.c
internal error: assertion failed at line 6656 in file object.c
internal error: assertion failed at line 6656 in file object.c
internal error: assertion failed at line 6656 in file object.c
internal error: assertion failed at line 6656 in file object.c
internal error: assertion failed at line 6656 in file object.c
internal error: assertion failed at line 6656 in file object.c

Illegal instruction (illegal opcode) in . at 0x0
warning: Unable to access address 0x0 from core

(dbx) where
.() at 0x0
internal error: unexpected value 120 at line 5201 in file stabstring.c
internal error: expected char ',', found 's__LC_locale:,1088,64;__meth_ptr:151,1152,64;__data_ptr:151,1216,64;;'
internal error: expected char ',', found '__LC_locale:,1088,64;__meth_ptr:151,1152,64;__data_ptr:151,1216,64;;'
internal error: expected char ';', found '_LC_locale:,1088,64;__meth_ptr:151,1152,64;__data_ptr:151,1216,64;;'
internal error: unexpected value 44 at line 5201 in file stabstring.c
internal error: expected char ',', found '1088,64;__meth_ptr:151,1152,64;__data_ptr:151,1216,64;;'
internal error: unexpected value 120 at line 5201 in file stabstring.c
internal error: unexpected value 120 at line 5201 in file stabstring.c
internal error: expected char ',', found 's_LC_locale_objhdl:,128,64;;'
internal error: expected char ',', found '_LC_locale_objhdl:,128,64;;'
internal error: expected char ';', found 'LC_locale_objhdl:,128,64;;'
internal error: unexpected value 44 at line 5201 in file stabstring.c
internal error: expected char ',', found '128,64;;'
internal error: unexpected value 120 at line 5201 in file stabstring.c
internal error: unexpected value 120 at line 5201 in file stabstring.c
internal error: unexpected value 120 at line 5201 in file stabstring.c
internal error: unexpected value 120 at line 5201 in file stabstring.c
internal error: unexpected value 120 at line 5201 in file stabstring.c
internal error: unexpected value 120 at line 5201 in file stabstring.c
internal error: unexpected value 120 at line 5201 in file stabstring.c
unnamed block in __cxa_finalize(d = (nil)), line 69 in "cxa_finalize.c"
unnamed block in __cxa_finalize(d = (nil)), line 69 in "cxa_finalize.c"
unnamed block in __cxa_finalize(d = (nil)), line 69 in "cxa_finalize.c"
__cxa_finalize(d = (nil)), line 69 in "cxa_finalize.c"
crtcxa.__init_aix_libgcc_cxa_atexit() at 0x101583d70
_GLOBAL__FD_node() at 0x101584190
mod_fini1(??, ??) at 0x9fffffff000af9c
usl_fini_mods(??, ??, ??, ??) at 0x9fffffff000bf44
usl_exit_fini(??, ??, ??) at 0x9fffffff000aea8
usl_exit_fini_mods(??) at 0x9fffffff000bde8
__modfini64() at 0x900000000001710
exit(??) at 0x900000000057450

(dbx) where
.() at 0x0
unnamed block in __cxa_finalize(d = (nil)), line 69 in "cxa_finalize.c"
unnamed block in __cxa_finalize(d = (nil)), line 69 in "cxa_finalize.c"
unnamed block in __cxa_finalize(d = (nil)), line 69 in "cxa_finalize.c"
__cxa_finalize(d = (nil)), line 69 in "cxa_finalize.c"
crtcxa.__init_aix_libgcc_cxa_atexit() at 0x101583d70
_GLOBAL__FD_node() at 0x101584190
mod_fini1(??, ??) at 0x9fffffff000af9c
usl_fini_mods(??, ??, ??, ??) at 0x9fffffff000bf44
usl_exit_fini(??, ??, ??) at 0x9fffffff000aea8
usl_exit_fini_mods(??) at 0x9fffffff000bde8
__modfini64() at 0x900000000001710
exit(??) at 0x900000000057450

(dbx) where
.() at 0x0
unnamed block in __cxa_finalize(d = (nil)), line 69 in "cxa_finalize.c"
unnamed block in __cxa_finalize(d = (nil)), line 69 in "cxa_finalize.c"
unnamed block in __cxa_finalize(d = (nil)), line 69 in "cxa_finalize.c"
__cxa_finalize(d = (nil)), line 69 in "cxa_finalize.c"
crtcxa.__init_aix_libgcc_cxa_atexit() at 0x101583d70
_GLOBAL__FD_node() at 0x101584190
mod_fini1(??, ??) at 0x9fffffff000af9c
usl_fini_mods(??, ??, ??, ??) at 0x9fffffff000bf44
usl_exit_fini(??, ??, ??) at 0x9fffffff000aea8
usl_exit_fini_mods(??) at 0x9fffffff000bde8
__modfini64() at 0x900000000001710
exit(??) at 0x900000000057450

(dbx) map
Entry 1:
   Object name: /opt/node/bin/node
   Text origin:     0x100000000
   Text length:     0x29f3ce0
   Data origin:     0x110000014
   Data length:     0x204c2c
   TLS origin:      Not allocated
   TLS length:      0x4
   File descriptor: 0x5

Entry 2:
   Object name: /usr/ccs/bin/usla64
   Text origin:     0x9fffffff0000000
   Text length:     0xfa7e
   Data origin:     0x9fffffff000fa7e
   Data length:     0x0
   File descriptor: 0x7

Entry 3:
   Object name: /usr/lib/security/GSA64
   Text origin:     0x900000001d1e000
   Text length:     0x7127
   Data origin:     0x9001000a05aa7f8
   Data length:     0xb39d8
   File descriptor: 0x9

Entry 4:
   Object name: /usr/lib/libC.a
   Member name: ansicore_64.o
   Text origin:     0x9000000009ee100
   Text length:     0x1e076
   Data origin:     0x9001000a01e4700
   Data length:     0x916c
   File descriptor: 0xb

Entry 5:
   Object name: /usr/lib/libC.a
   Member name: shrcore_64.o
   Text origin:     0x9000000009cbc00
   Text length:     0x21b4e
   Data origin:     0x9001000a01dd800
   Data length:     0x6698
   File descriptor: 0xd

Entry 6:
   Object name: /usr/lib/libC.a
   Member name: shr2_64.o
   Text origin:     0x900000001771808
   Text length:     0xa54
   Data origin:     0x9001000a044d808
   Data length:     0x0
   File descriptor: 0xf

Entry 7:
   Object name: /usr/lib/libC.a
   Member name: shr3_64.o
   Text origin:     0x9000000017739e8
   Text length:     0xa3b
   Data origin:     0x9001000a044e9e8
   Data length:     0x0
   File descriptor: 0x11

Entry 8:
   Object name: /usr/lib/libC.a
   Member name: ansi_64.o
   Text origin:     0x90000000060e180
   Text length:     0x254c0b
   Data origin:     0x9001000a01f4580
   Data length:     0x4f930
   File descriptor: 0x13

Entry 9:
   Object name: /usr/lib/libC.a
   Member name: shr_64.o
   Text origin:     0x9000000005ebb00
   Text length:     0x21fc8
   Data origin:     0x9001000a01eeb00
   Data length:     0x4df8
   File descriptor: 0x15

Entry 10:
   Object name: /opt/node-apps/aix-server-example/node_modules/ibm_db/installer/clidriver/lib/libdb2.a
   Member name: shr_64.o
   Text origin:     0x90000000d645100
   Text length:     0x3995363
   Data origin:     0x9001000a06a29c9
   Data length:     0x895947
   File descriptor: 0x17

Entry 11:
   Object name: /opt/node-apps/aix-server-example/node_modules/ibm_db/build/Debug/odbc_bindings.node
   Text origin:     0x90000000c6d9000
   Text length:     0x4bf3c
   Data origin:     0x8001000a0029124
   Data length:     0x45e0
   File descriptor: 0x19

Entry 12:
   Object name: /usr/lib/libsrc.a
   Member name: shr_64.o
   Text origin:     0x9000000004e3800
   Text length:     0x173f9
   Data origin:     0x9001000a01b3268
   Data length:     0xdec8
   File descriptor: 0x1b

Entry 13:
   Object name: /usr/lib/libcrypt.a
   Member name: shr_64.o
   Text origin:     0x90000000046b400
   Text length:     0xb43
   Data origin:     0x9001000a010da28
   Data length:     0x190
   File descriptor: 0x1d

Entry 14:
   Object name: /usr/lib/libcorcfg.a
   Member name: shr_64.o
   Text origin:     0x900000000470280
   Text length:     0x2817b
   Data origin:     0x9001000a01c24d0
   Data length:     0xa244
   File descriptor: 0x1f

Entry 15:
   Object name: /usr/lib/liblvm.a
   Member name: shr_64.o
   Text origin:     0x900000000863b80
   Text length:     0xc5979
   Data origin:     0x9001000a0244710
   Data length:     0x37dcd
   File descriptor: 0x21

Entry 16:
   Object name: /usr/lib/libodm.a
   Member name: shr_64.o
   Text origin:     0x900000000446380
   Text length:     0x2415f
   Data origin:     0x9001000a019eab8
   Data length:     0xc3a0
   File descriptor: 0x23

Entry 17:
   Object name: /usr/lib/libcfg.a
   Member name: shr_64.o
   Text origin:     0x9000000004fbb00
   Text length:     0x16780
   Data origin:     0x9001000a01ab328
   Data length:     0x77b0
   File descriptor: 0x25

Entry 18:
   Object name: /usr/lib/libc.a
   Member name: shr_64.o
   Text origin:     0x900000000000d80
   Text length:     0x4450b2
   Data origin:     0x9001000a00005a0
   Data length:     0x10c7c8
   File descriptor: 0x27

Entry 19:
   Object name: /usr/lib/libpthreads.a
   Member name: shr_xpg5_64.o
   Text origin:     0x900000000513000
   Text length:     0x42c17
   Data origin:     0x9001000a010e000
   Data length:     0x8f04c
   File descriptor: 0x29

Entry 20:
   Object name: /opt/freeware/lib/gcc/powerpc-ibm-aix7.1.0.0/6.3.0/pthread/ppc64/libgcc_s.a
   Member name: shr.o
   Text origin:     0x90000000d34c600
   Text length:     0x16ae7
   Data origin:     0x9001000a2666858
   Data length:     0x18f0
   File descriptor: 0x2b

Entry 21:
   Object name: /opt/freeware/lib/gcc/powerpc-ibm-aix7.1.0.0/6.3.0/pthread/ppc64/libstdc++.a
   Member name: libstdc++.so.6
   Text origin:     0x900000015ed3780
   Text length:     0x269dcb
   Data origin:     0x8001000a0000930
   Data length:     0x27bf4
   TLS origin:      Not allocated
   TLS length:      0x20
   File descriptor: 0x2d

Entry 22:
   Object name: /usr/lib/libperfstat.a
   Member name: shr_64.o
   Text origin:     0x90000000093e500
   Text length:     0x8bcff
   Data origin:     0x9001000a027d578
   Data length:     0x26b2c
   File descriptor: 0x2f

[bimalkjha]

@ukulanne Here is the debug output for node test-basic-test.js on mac.

ODBCResult::Free() Done.
ODBCResult::CloseSync - Exit
ODBCConnection::Close
ODBCConnection::UV_Close
ODBCConnection::Free m_hDBC = 1
ODBCStatement::UV_AfterExecute - Exit
ODBCConnection::UV_AfterClose
done
BLR-D-MACOS02.local: master/ibm_db/test>

AIX trace also has all the logs. It seems the SIGILL is coming from node itself once ibm_db finishes execution. Are you getting same error with node v8.x or v9.x too? Could you please contact gpunathi@in.ibm.com with these stack trace? He is a node.exe runtime developer for AIX. Thanks.

[bimalkjha]

ibm_db@2.5.0 compiles with node.js v10.x and v11.x. Thanks.

[ukulanne]

While it compiles this still segfaults. @bimaljha

[bimalkjha]

@ukulanne I think the segfault is in node.exe not in ibm_db add on binary. Have you checked with gpunathi@in.ibm.com about it? Thanks.