Read exits after system crash
Event_log contains the following errors:
Error 2016-12-02 10:21:29.394847 22210 1509279584 Reader: 11000 - sp_ordr failed: can't recreate insert key cache due to que_reread failure (from sid) [module ord]
Environment with SharePlex horizontal partitioning having accumulated old queue files with physical and logical read release don't sync correctly
RESOLUTION:
Do the following:
1. Shutdown SharePlex
sp_ctrl> shutdown
2. Run qview "old datafiles c" command to remove old queue files for capture queue:
change directory to proddir/bin
./qview -i
qview>qsetup
qview> old datafiles c
qview> exit
3. Start SharePlex from proddir/bin
./sp_cop &
4. Start read
sp_ctrl> start read
With SharePlex horizontal partitioning, the old queue files accumulating issue can happens to export queue and post queue in addition to capture queue, therefore, best practice is to periodically remove the old queue files for each of queues as below:
1. shutdown SharePlex
2. Change directory to proddir/bin and run "old datafiles" commands below:
./qview -i
qview> old datafiles c
qview> old datafiles x
qview> old datafiles p
qview> exit
3. restart cop
./sp_cop &
