Table Size (OpenInsight Specific)
At 10 JUN 1999 06:22:46PM Aracely Cazares wrote:
Hi
I had a problem with a Table. Last week the size of the table was 96 MB and 4 days after it was more then 2 GB. I realised that because an error occurred with that table (FS107 or FS127 don't remember). I would like to know what could happend to it because it isn't normal the size. The frame size is 4086 and the threshold is 80, the number of records before the error was 14076. Do you know if there is a limit in number of records or something like that?
Note: I have tables with more then 80000 records and they are right.
After this error the Revelation software crash. "Unable to Access Linear Hash Files Error=FS1019" I ran a VerifyLH for all the tables. The REVMEDIA table was bad and I copied it from a backup. Any other table was bad, but when I got into the system one table didn't exist, so I Added it, but the table has only 2 columns. Before it had 3 columns. I don't know what happend to it. Right now the system is fine, but I want to prevent these errors.
Please Help me
Aracely Cazares
At 11 JUN 1999 04:10AM Oystein Reigem wrote:
Aracely,
Can't help you with your main problem (the bloated table). Except I can tell you what the error codes mean:
FS107: Read error. OS Table=%1%".
FS127: Group Format Error: OS File : %1% Group # : %2% Record length incorrect or frame linkage error.
FS1019: Server only access specified in REVPARAM file.
You can look up error codes in the two files REVERROR.DAT and BERROR.DAT in the OpenInsight folder.
And I think you should search this list for "FS1019".
Perhaps there's a natural explanation for the missing table and field at least.
… The REVMEDIA table was bad and I copied it from a backup. Any other table was bad, but when I got into the system one table didn't exist,
I assume you know the REVMEDIA table is a special table which is sort of a directory for all the (normal) tables in the same folder ("location", "volume"). So if that missing table was created after you did your backup, the backed up REVMEDIA didn't know about it.
so I Added it, but the table has only 2 columns. Before it had 3 columns.
Oops. Cannot explain that. REVMEDIA doesn't know about fields, only tables. Are you sure REVMEDIA was the only table you restored from backup? If you also restored the dictionary for your missing table that could explain it. If you originaly had 2 fields and added that 3rd field after you did your backup, that is. It's the dictionary tables that know about which fields the data tables contain. (But you probably know all this.)
- Oystein -