table failure

[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

[John]

Apparently it is unable to open the file /p/data/texis/fulltext/article.tbl which would have caused that message. It should indicate why, but the most common reasons would be either that .tbl file doesn't exist, or doesn't have the correct permissions for the texis user to open it.

[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

[John]

The error ENXIO means "No such device or address". Is the filesystem it's on a normal filesystem, or is it a RAID or mounted or otherwise different? It sounds as if at a device level it is unable to read the data. Are you able to look at the file, e.g.

cat -vt /p/data/texis/fulltext/article.tbl | head