SharePlex target is upgraded to 9.1.3 whereas the source remained at the previous version of 8.6.6. After upgrade the Post queues for SharePlex Horizontal Partitioning (HZ) table core dumped. The HZ table was working fine with 8.6.6.
When SP_OPO_DEPENDENCY_CHECK set to 1:.
Core.out:
#0 conv_number (fmtted=0x31 <Address 0x31 out of bounds>, len=7260880, exp=0x7ffde8d45230 "0\177", <incomplete sequence \364>) at ../src/opst_mt/opst_com/opst_com.cpp:406
#1 0x00007feb9f1f7782 in getHash (msg=0xeb11e0, col=0xec02a0, row=1, fromData=@0x7ffde8d452ff, useKey=false) at ../src/lib/post/pre_table.cpp:292
#2 0x00007feb9f1f7d8f in PreTable::check (this=0xec0320, msg=0xeb11e0, ps=0xf47f30, batch_skip=@0x7ffde8d4750c) at ../src/lib/post/pre_table.cpp:432
#3 0x00007feb9f1f6786 in PreSession::checkReal (this=0xf47f30, dataRec=0xeb11e0, batch_skip=@0x7ffde8d4750c, rollback=<value optimized out>) at ../src/lib/post/pre_session.cpp:255
#4 0x00007feb9f1f6ba1 in PreSession::check (this=0xf47f30, msg=<value optimized out>, msgLen=828, batch_skip=@0x7ffde8d4750c, rollback=false, qseq=55152) at ../src/lib/post/pre_session.cpp:170
#5 0x000000000045b431 in StDispatch (rmsg_orig=0x6ec920, new_mlen=828) at ../src/opst_mt/sql_thread.cpp:626
#6 0x000000000041dc8b in main_loop () at ../src/opst_mt/sp_opst_mt.cpp:2795
#7 0x000000000041f195 in app_main (argc=<value optimized out>, argv=<value optimized out>) at ../src/opst_mt/sp_opst_mt.cpp:3290
#8 0x0000000000416b06 in main (argc=2, argv=0x7ffde8d49be8) at ../src/opst_mt/app.cpp:38
=============> End of stack trace <=============
Other case when SP_OPO_DEPENDENCY_CHECK set to 2 :
Core.out
(gdb) where
#0 0x00007fb0facf92d0 in ?? ()
#1 0x00007fb0fa5c32eb in ?? ()
#2 0x00007fffadc3fb7f in ?? ()
#3 0x0000000000000000 in ?? ()
(gdb)
It is a product defect in 9.1.x
Workaround:
Turn off PEP:
sp_ctrl>reset param SP_OPO_DEPENDENCY_CHECK
bounce the post
Status:
The fix in release 9.2.0.
