Hi,

Using BDS 2006 and ElevateDB 1.05b2.
I have a memory table which i use as a reporting table (attached to grid).
When table holds large amounts of data, and on repeated deletion and insertion of data (say about 3 times), I get error
'ElevateDB Error #601 The table TABLE_1 is corrupt (Cannot find index page during retrieval from cache)' when executing
DELETE FROM TABLE_1 statement.
No special cases, only plain insert/delete operations taking place on table.
I need a fix / workaround for this ? I cannot upgrade to 1.09.

Thanks
Praveen.

Praveen,

Can you reproduce this ?  If so, can you send me a small project that
reproduces it ?

<< I need a fix / workaround for this ? I cannot upgrade to 1.09. >>

Well, any fix for this would only come in the form of a 1.09 build.  We
don't issue fixes for every minor release ever released, only for the latest
minor release.

--
Tim Young
Elevate Software
www.elevatesoft.com

Hi,

Reproducing the issue is a problem. Sometimes it occurs frequently or never when required.
What I want to know is of any possible workaround for this, or any fix I can do ?
Reason for this issue ?

Regards
Praveen.

Praveen


Does setting ForceBufferFlush to True help?

Roy Lambert [Team Elevate]

Praveen,

<< Reproducing the issue is a problem. Sometimes it occurs frequently or
never when required. What I want to know is of any possible workaround for
this, or any fix I can do ? Reason for this issue ? >>

I have no idea what the issue is because we have no other current reports of
this, and the last report we had was for 1.01 a long time ago.  Did you try
using 1.09 ?  Until it can be confirmed as an issue in 1.09, I really can't
help you any further.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim ,

I must say that I had this error (atest version), too. Only a few times,
not reproducible.
Actually the tables didn't need any repair.

Uli

Hi,

This is call stack when i get the exception.

kernel32.RaiseException
TEDBTableFileManager.CorruptError
TEDBIndexNavigator.Delete
TEDBTableManager.DeleteExistingKey
TEDBTableManager.DeleteRow
TEDBVirtualTableManager.Delete
TEDBLocalCursor.Delete
TEDBDeleteManager.Execute
TEDBLocalStatementManager.Execute
TEDBQuery.GetQueryCursor
TEDBQuery.CreateCursor
TEDBQuery.ExecSQL
TEDBDataBase.Execute('DELETE FROM TRD_SELECT_0',nil,$XXXX)

Praveen

Praveen,

<< This is call stack when i get the exception. >>

I know where the error can occur.  The information that I need is what code
causes it to occur.

Also, are you using text indexes in that table at all ?

--
Tim Young
Elevate Software
www.elevatesoft.com