table failure

Post Reply
kevin12
Posts: 19
Joined: Mon Mar 12, 2001 11:55 am

table failure

Post by kevin12 »

Our 420r running texis apparently suffered an unhealthy reboot last night. We failed over to our backup texis copy, so all is (mostly) well, but we'd like to fix this instance.

Apparently our main table "article" has disappeared. The article.tbl file is still there, and it's still listed in all the SYS* tables.

Any suggestions on what might have happened or how we can recover it? Here's the output of tsql:

/p/server/texis/bin/tsql -VVV -d /p/data/texis/fulltext -u xxx -p xxx 'select count(*) from article;'
Texis Version 03.01.976899697(20001214) Copyright (c) 1988-2000 Thunderstone EPI

002 Unable to open table /p/data/texis/fulltext/article in the function opendbtbl
115 No such table: article in the database: /p/data/texis/fulltext/
000 SQL failed
kevin12
Posts: 19
Joined: Mon Mar 12, 2001 11:55 am

table failure

Post by kevin12 »

Well, the file is there and readable by the texis user,

-rw------- 1 texis texis 790361426 Nov 1 22:33 /p/data/texis/fulltext/article.tbl

and texisd is running as the texis user according to ps. What are some of the uncommon reasons?

A truss of the tsql trying to open the file shows the problem is on the read, but I don't know enough to interpret it further, does this mean anything to you?:

open64("/p/data/texis/fulltext/article.tbl", O_RDWR) = 8
fstat64(8, 0xFFBEF078) = 0
llseek(8, 0, SEEK_SET) = 0
read(8, 0x005FB598, 18) Err#6 ENXIO
l
Post Reply