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.
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.