Problem creating metamorph index on existing table

Post Reply
valery
Posts: 26
Joined: Thu Mar 15, 2001 9:24 pm

Problem creating metamorph index on existing table

Post by valery »

Hi,

I'm having a problem creating index on existing Texis table under Linux.
I have copied the database from another identical machine which we use for batch indexing and tried to do:
---------------
[DBA] > texis -d /bigdisk/BioSearchEngine/db_news_diff/ "create metamorph inverted index xhtmlbodonly on html(Body)"
---------------
In response, I get:
---------------
002 Can't open KDBF file /bigdisk/BioSearchEngine/db_news_diff/xhtmlbodonly_D.btr for writing: error 2: No such file or directory
002 Can't open KDBF file /bigdisk/BioSearchEngine/db_news_diff/xhtmlbodonly_T.btr for writing: error 2: No such file or directory
002 Can't open Metamorph index token file /bigdisk/BioSearchEngine/db_news_diff/xhtmlbodonly.tok read/write: No such file or directory in the function openwtix
000 SQLPrepare() failed with -1 in the function prepntexis
---------------

which is very interesting as the /bigdisk/BioSearchEngine/db_news_diff/ and files xhtmlbodonly_D.btr and xhtmlbodonly_T.btr apparently exist and uid under which texis has been setup can write/read in that directory:
----------------
[DBA] > ls -la /bigdisk/BioSearchEngine/db_news_diff/
total 12256
drwxrwxrwx 2 DBA wwwdevel 4096 Nov 2 11:05 .
drwxrwxrwx 18 DBA root 4096 Oct 27 09:03 ..
-rw-rw-rw- 1 DBA wwwdevel 31162 Nov 1 21:01 SYSCOLUMNS.tbl
-rw-rw-rw- 1 DBA wwwdevel 8828 Nov 1 21:08 SYSINDEX.tbl
-rw-rw-rw- 1 DBA wwwdevel 8 Nov 2 11:09 SYSLOCKS.SEQ
-rw-rw-rw- 1 DBA wwwdevel 3314 Nov 1 21:01 SYSMETAINDEX.tbl
-rw-rw-rw- 1 DBA wwwdevel 5608 Nov 1 21:01 SYSPERMS.tbl
-rw-rw-rw- 1 DBA wwwdevel 3606 Nov 2 11:09 SYSSTATS.tbl
-rw-rw-rw- 1 DBA wwwdevel 10738 Nov 1 21:01 SYSTABLES.tbl
-rw-rw-rw- 1 DBA wwwdevel 3314 Nov 1 21:01 SYSTRIG.tbl
-rw-rw-rw- 1 DBA wwwdevel 3438 Nov 1 21:01 SYSUSERS.tbl
-rw-rw-rw- 1 DBA wwwdevel 3314 Nov 1 21:01 error.tbl
-rw-rw-rw- 1 DBA wwwdevel 3833004 Nov 1 21:01 html.blb
-rw-rw-rw- 1 DBA wwwdevel 1497686 Nov 1 21:01 html.tbl
-rw-rw-rw- 1 DBA wwwdevel 3314 Nov 1 21:01 options.tbl
-rw-rw-rw- 1 DBA wwwdevel 3314 Nov 1 21:01 querylog.tbl
-rw-rw-rw- 1 DBA wwwdevel 3314 Nov 1 21:01 refs.tbl
-rw-rw-rw- 1 DBA wwwdevel 3314 Nov 1 21:01 todo.tbl
-rw-rw-rw- 1 DBA wwwdevel 3314 Nov 1 21:01 vortex.tbl
-rw-rw-rw- 1 DBA wwwdevel 544148 Nov 1 21:01 xhtmlbod.btr
-rw-rw-rw- 1 DBA wwwdevel 973629 Nov 1 21:01 xhtmlbod.dat
-rw-rw-rw- 1 DBA wwwdevel 17080 Nov 1 21:01 xhtmlbod.tok
-rw-rw-rw- 1 DBA wwwdevel 46 Nov 1 21:01 xhtmlbod_D.btr
-rw-rw-rw- 1 DBA wwwdevel 1313 Nov 1 21:01 xhtmlbod_P.tbl
-rw-rw-rw- 1 DBA wwwdevel 24118 Nov 1 21:01 xhtmlbod_T.btr
-rw------- 1 DBA wwwdevel 39 Nov 2 11:05 xhtmlbodonly_D.btr
-rw------- 1 DBA wwwdevel 39 Nov 2 11:05 xhtmlbodonly_T.btr
-rw-rw-rw- 1 DBA wwwdevel 140552 Nov 1 21:01 xhtmlbus_status.btr
-rw-rw-rw- 1 DBA wwwdevel 189740 Nov 1 21:01 xhtmlcity.btr
-rw-rw-rw- 1 DBA wwwdevel 156948 Nov 1 21:01 xhtmlcomp_last_updated.btr
-rw-rw-rw- 1 DBA wwwdevel 156948 Nov 1 21:01 xhtmlcomp_time_submitted.btr
-rw-rw-rw- 1 DBA wwwdevel 132354 Nov 1 21:01 xhtmlcompany_stage.btr
-rw-rw-rw- 1 DBA wwwdevel 46 Nov 1 21:01 xhtmlcompname.btr
-rw-rw-rw- 1 DBA wwwdevel 8 Nov 1 21:01 xhtmlcompname.dat
-rw-rw-rw- 1 DBA wwwdevel 0 Nov 1 21:01 xhtmlcompname.tok
-rw-rw-rw- 1 DBA wwwdevel 30136 Nov 1 21:01 xhtmlcompname_D.btr
-rw-rw-rw- 1 DBA wwwdevel 1313 Nov 1 21:01 xhtmlcompname_P.tbl
-rw-rw-rw- 1 DBA wwwdevel 127458 Nov 1 21:01 xhtmlcompname_T.btr
-rw-rw-rw- 1 DBA wwwdevel 140552 Nov 1 21:01 xhtmlcontact_present_mask.btr
-rw-rw-rw- 1 DBA wwwdevel 156948 Nov 1 21:01 xhtmlgeo2code.btr
-rw-rw-rw- 1 DBA wwwdevel 197938 Nov 1 21:01 xhtmlid.btr
-rw-rw-rw- 1 DBA wwwdevel 148750 Nov 1 21:01 xhtmlincome12.btr
-rw-rw-rw- 1 DBA wwwdevel 132354 Nov 1 21:01 xhtmllat.btr
-rw-rw-rw- 1 DBA wwwdevel 140552 Nov 1 21:01 xhtmllocation.btr
-rw-rw-rw- 1 DBA wwwdevel 132354 Nov 1 21:01 xhtmllon.btr
-rw-rw-rw- 1 DBA wwwdevel 148750 Nov 1 21:01 xhtmlmarketcap.btr
-rw-rw-rw- 1 DBA wwwdevel 124156 Nov 1 21:01 xhtmlmember_ID.btr
-rw-rw-rw- 1 DBA wwwdevel 148750 Nov 1 21:01 xhtmln_employees.btr
-rw-rw-rw- 1 DBA wwwdevel 46 Nov 1 21:01 xhtmlprofile.btr
-rw-rw-rw- 1 DBA wwwdevel 8 Nov 1 21:01 xhtmlprofile.dat
-rw-rw-rw- 1 DBA wwwdevel 0 Nov 1 21:01 xhtmlprofile.tok
-rw-rw-rw- 1 DBA wwwdevel 30136 Nov 1 21:01 xhtmlprofile_D.btr
-rw-rw-rw- 1 DBA wwwdevel 1313 Nov 1 21:01 xhtmlprofile_P.tbl
-rw-rw-rw- 1 DBA wwwdevel 127458 Nov 1 21:01 xhtmlprofile_T.btr
-rw-rw-rw- 1 DBA wwwdevel 544148 Nov 1 21:01 xhtmlprofileext.btr
-rw-rw-rw- 1 DBA wwwdevel 973137 Nov 1 21:01 xhtmlprofileext.dat
-rw-rw-rw- 1 DBA wwwdevel 16592 Nov 1 21:01 xhtmlprofileext.tok
-rw-rw-rw- 1 DBA wwwdevel 46 Nov 1 21:01 xhtmlprofileext_D.btr
-rw-rw-rw- 1 DBA wwwdevel 1313 Nov 1 21:01 xhtmlprofileext_P.tbl
-rw-rw-rw- 1 DBA wwwdevel 30136 Nov 1 21:01 xhtmlprofileext_T.btr
-rw-rw-rw- 1 DBA wwwdevel 140552 Nov 1 21:01 xhtmlprofilequality.btr
-rw-rw-rw- 1 DBA wwwdevel 140552 Nov 1 21:01 xhtmlrev12.btr
-rw-rw-rw- 1 DBA wwwdevel 148750 Nov 1 21:01 xhtmlsic.btr
-rw-rw-rw- 1 DBA wwwdevel 394690 Nov 1 21:02 xhtmlurl.btr
-rw-rw-rw- 1 DBA wwwdevel 156948 Nov 1 21:02 xhtmlvisited.btr
-rw-rw-rw- 1 DBA wwwdevel 156948 Nov 1 21:02 xhtmlzip.btr
-rw-rw-rw- 1 DBA wwwdevel 152 Nov 1 21:02 xoptname.btr
-rw-rw-rw- 1 DBA wwwdevel 152 Nov 1 21:02 xoptstr.btr
-rw-rw-rw- 1 DBA wwwdevel 152 Nov 1 21:02 xqueryid.btr
-rw-rw-rw- 1 DBA wwwdevel 152 Nov 1 21:02 xtodourl.btr
-rw-rw-rw- 1 DBA wwwdevel 152 Nov 1 21:02 xvid.btr
---------------------------

I have tried to suid to root and to our web server uid with the same results.

Could you please hint us what the problem might be?

The 2 machines we use are TOTALLY identical with the same RAM/drives/directory structures

Thanks,
Valery.
User avatar
mark
Site Admin
Posts: 5519
Joined: Tue Apr 25, 2000 6:56 pm

Problem creating metamorph index on existing table

Post by mark »

Texis is probably setuid to some user other than DBA. The _D and _T files are only read/writable by DBA. I would have expected a permission error though, not existence. Try making those files have the same perms as the others. Also, their sizes are suspicious. Are you sure you got an exact copy of the originals? Double check your owners and perms on the database directory and files and texis itself on both systems.
havefun567
Posts: 1
Joined: Mon Mar 18, 2002 11:15 am

Problem creating metamorph index on existing table

Post by havefun567 »

It may sound border weird, but try to look into SYSINDEX table and see if everything is kosher

run this sql:
"select FNAME from SYSINDEX where NAME='xhtmlbod'"
Post Reply