Transactions Cannot be Properly Flushed (AREV Specific)
At 28 JUL 1998 05:30:47PM Diane Jackson wrote:
Link List in the table !Apps*cmsnew*18:21:27 07 Jul 1995 is broken
Transactions cannot be properly flushed. To correct this problem, please rebuild all the indexes in the table.
Can anyone interpret this for me?
At 29 JUL 1998 12:09AM Curt Putnam wrote:
Go to your developer's menu and rebuild all the indexes in the affected file. If that doesn't work, delete all the indexes in the affected file and recreate them.
At 29 JUL 1998 03:46AM Egbert Poell wrote:
Curt's advice is correct but the cause might be of some importance because if it is structural it will come back.
We saw this problem at a few client sites.
This problem is caused by an interruption of the index building process.
The things that might be happening :
- Problems with the electricity supply
- Misfunctioning of the harddisk of an index server
- Troublesome network card in an index server
With other words it will be something in your hardware.
Best regards,
Egbert Poell
Mecomp Automatisering vof
At 29 JUL 1998 05:02AM Andrew P McAuley wrote:
When records are written to disk, transactions are created in the appropriate ! file. These transactions are numbered 0, 1, 2, 3 etc with each record pointing to the next one in the sequence. Occasionally this sequence will become corrupt. We have only seen this when there are more transactions being created than the indexer can deal with. The fix (to prevent) was to install a faster indexing machine or write a specialised indexing routine to ensure that transactions do not back up.
The short term fix is to delete EVERY transaction in the ! file with a numeric key, then rebuild the indexes. Until the numeric rows have gone you will not be able to rebuild.
Try
:Select !MyFile With @Id between 0 and 999999:Delete !MyFilethen rebuild