Crash when attempting to write and connect to DB2
Hello, I'm working on writing a feed out to a db2 database. However when I run the code it crashes with the following output:
============================ SIGNAL SIGSEGV ============================/opt/ibm/InfoSphereStreams/lib/libstreams-apputils.so.0(Distillery::BacktraceDumper::dump(int, bool, int)+0x39) [0x2abd70eaa1a9]
/opt/ibm/InfoSphereStreams/lib/../lib/libstreams-runtime.so.0(Distillery::DistilleryApplication::faultHandler(int)+0x4d) [0x2abd722dda9d]
/opt/ibm/InfoSphereStreams/lib/../lib/libstreams-runtime.so.0(Distillery::DistilleryApplication::errorSignalHandler(int)+0x63) [0x2abd722deac3]
/opt/ibm/InfoSphereStreams/java/jre/lib/amd64/default/libjsig.so(jsig_handler+0x24e) [0x2abd7bdf845e]
/opt/ibm/InfoSphereStreams/java/jre/lib/amd64/default/libj9prt24.so [0x2abd7c2a119f]
/lib64/libc.so.6 [0x36552302d0]
/opt/ibm/InfoSphereStreams/lib/libstreams-spl-runtime.so.0(SPL::Operator::instanceOf(std::string const&)+0xc0) [0x2abd707617d0]
/opt/ibm/InfoSphereStreams/lib/libstreams-spl-runtime.so.0 [0x2abd70a05797]
/opt/ibm/InfoSphereStreams/lib/libstreams-spl-runtime.so.0 [0x2abd70a07240]
/opt/ibm/InfoSphereStreams/lib/libstreams-spl-runtime.so.0 [0x2abd7088d99d]
/opt/ibm/InfoSphereStreams/lib/libstreams-spl-runtime.so.0 [0x2abd70a01988]
/opt/ibm/InfoSphereStreams/lib/libstreams-spl-runtime.so.0(SPL::StandaloneApplicationImpl::process()+0x17e) [0x2abd70a2175e]
/opt/ibm/InfoSphereStreams/lib/libstreams-spl-runtime.so.0(SPL::StandaloneApplicationImpl::run(std::vector<std::string, std::allocator<std::string> > const&)+0x115) [0x2abd70a36755]
/opt/ibm/InfoSphereStreams/lib/../lib/libstreams-runtime.so.0(Distillery::DistilleryApplication::runSafeCatchDst(std::vector<std::string, std::allocator<std::string> > const&)+0x2ea) [0x2abd722e828a]
/opt/ibm/InfoSphereStreams/lib/../lib/libstreams-runtime.so.0(Distillery::DistilleryApplication::runSafeCatchall(std::vector<std::string, std::allocator<std::string> > const&)+0x24) [0x2abd722ef564]
/opt/ibm/InfoSphereStreams/lib/../lib/libstreams-runtime.so.0(Distillery::DistilleryApplication::main(int, char*, char*)+0x3d2) [0x2abd722e75b2]
/home/streamsadmin/StreamsStudio/workspace/RSSFeedStreamsReader/output/application.RSSFeedStreamsReader/Standalone/bin/standalone(main+0x23) [0x400a0b]
/lib64/libc.so.6(__libc_start_main+0xf4) [0x365521d994]
/home/streamsadmin/StreamsStudio/workspace/RSSFeedStreamsReader/output/application.RSSFeedStreamsReader/Standalone/bin/standalone(__gxx_personality_v0+0x89) [0x400939]
=============================================================================
The SPL for writing out is:
() as appendTable = ODBCAppend(DeFeedStream)
{
param
connection : "StreamsDB";
access : "FeedAccess";
connectionDocument : "./data/connections.xml";
}
The connection.xml is:
<connection_specifications>
<connection_specification name="StreamsDB" >
<ODBC database="streams" user="USER" password="PASS" />
</connection_specification>
</connection_specifications>
<access_specifications>
<access_specification name="FeedAccess">
<table tablename="MYTABLE" transaction_batchsize="1" rowset_size="1"/>
<uses_connection connection="StreamsDB" />
<native_schema>
<column name="TITLE" type="VARCHAR" length="250"/>
<column name="PRODUCT" type="VARCHAR" length="250"/>
<column name="ISSUE" type="VARCHAR" length="250"/>
<column name="PUBLISHED" type="VARCHAR" length="250"/>
<column name="DESCRIPTION" type="VARCHAR" length="1000"/>
</native_schema>
</access_specification>
</access_specifications>
Thanks for the help
We will review this problem and get back to you.
Thanks
Turns out I was missing a pair of header files in the db2 install folder. The issue wasnt reported until after a full clean of the project and even then it just appeared as if append table method wasn't compiling correctly. I copied them over from a different install of db2 and it worked out fine.