BTS-Query on RSS Secondary
Posted in 2019
informix:IBM Informix Dynamic Server Version 12.10.FC12
OS:SUSE Linux Enterprise Server 12 (x86_64) VERSION = 1 PATCHLEVEL = 3
Problems doing a BTS-Query on RSS-Secondary after INSERT/DELETE on Primary.
I have created a Sbspace(-Df "LOGGING=ON") and also a temporary Sbspace.
BTS-Index on lvarchar column.
RSS-Replication works fine.
When a row is insertet or deletet on Primary, a BTS-Query works only on
Primary.
The same Query on RSS results in ERROR:
echo 'select * from errtable where bts_contains (errcol,"trigger")order by
nr;' | dbaccess db1
Database selected.
(BTSA1) - bts clucene error: IO error: FSE IO cannot open file
/informix/err_bts/3146080/segments
Error in line 1Near character position 71
Database closed.
After restart of RSS-Server the BTS-Query works and delivers the same result
as on Primary.
What's wrong? Any Idea?
Thanx
Ruediger