Thunderstone Support Forums

I have a problem with CHKIND/SYSMETAINDEX table,
I'm doing a batch of updates, CHKIND is turned on, but SYSMETAINDEX = 1 in texis.cnf file.so I update the metamorph index manually at the end of the batch.
Here is a snippet of Texis.cnf:

[Chkind] ; --------------------- Check-Index settings ---------------------

; How often to check for tables that need to be checked.

;Refresh = 4

; Only check indexes in SYSMETAINDEX

;SYSMETAINDEX = 1

; Automatically invoke chkind if 1. Set to 0 if you're doing manual index
; updates, ie. after a batch table update:

;Automatic = 1
-------------------------------------------------

I have no records in the SYSMETAINDEX table for that db directory.
The script is doing 3 steps:
step 1: delete some records from the table.
step 2: insert some records to the table.
step 3: Update the metamorph index.

But I've noticed that during the processing of step2, there is an index in SYSINDEX table with the same name as the manual metamorph index, with a temporary FNAME "T02612a"
also, there is another few files being updated called "T02612b.btr" ,"T02612b.dat", "T02612c.btr" and "T02612c.dat".

When the script reaches step3, it returns an error:
*Index E:\IncBuild\mainlocation\T02612a appears to be being updated*

any reasons why chkind is still insisting to refresh the index? should I set ;Automatic = 0 in the CNF file?

A semicolon or pound sign introduces a comment in texis.cnf. Most of the default settings -- including SYSMETAINDEX -- are commented out in your file, so SYSMETAINDEX is really the default value of 0, hence the attempt to update the index. Delete the semicolon.

that make sense!!

By the end of the metamorph manual index update process, the final merged Temp files are not renamed to the index name, the index is working fine, but the final file names are still "T02108a" , also it's the index file name in the SYSINDEX table.
should I worry about this?

The Windows version does that, because in-use files can't be renamed under Windows. It's normal.