2155 error hb_cdxindexCheckVersion fivewin/harbour

[lorenzoazz]

I have a program compiled with 32bit bcc ( harbour and fivewin libs)
This error occurs only in windows 8.1 (not on XP) after the "suspension"
on windows 8.1 and also in XP compatible mode.

It happens ONLY at the moment the program try to seek on an index ( probably a "static" index that get lost after suspension mode)


The error is unrecovarable in any way i knew, and any update to the database, get lost.

Hoping to get some suggestion from you!

Thanks
Lorenzo

[cnavarro]

Try to use after recording a modified or new data DBCOMMIT ()

[lorenzoazz]

Thanks for the reply.

Consider that, the problem rises when hardware goes in suspension mode, so it happens when in stand-by,
while you take a coffee break.
I mean, if the hardware do not go in stand-by (as a notebook does) , there is no error when i go to recording!
I cannot PREVENT the stand-by event, so i cannot dbcommit() before replace()...

[cnavarro]

Thanks for the reply.

Consider that, the problem rises when hardware goes in suspension mode, so it happens when in stand-by,
while you take a coffee break.
I mean, if the hardware do not go in stand-by (as a notebook does) , there is no error when i go to recording!
I cannot PREVENT the stand-by event, so i cannot dbcommit() before replace()...

My English is very poor
DBCOMMIT, DBCOMMITALL, is to be performed at the end of the append or replace

Or it is when you leave the record unfinished?

You can not have this option selected on your network card

[lorenzoazz]

Yes, it happens only when i leave the record unfinisced!
So when i resume from suspension mode, i try to update the record and i git the unrecoverable error!

[lorenzoazz]

Please, no one has encountered this error?

I think it is a general index error depending on system suspension.

I have also read ( do not remeber where) that someone had adopted a trick
inserting at program initialization a "Request"

REQUEST DESCEND

but not working for me.

[karinha]

Look line: 1162,

https://github.com/harbour/core/blob/master/src/rdd/dbfcdx/dbfcdx1.c

In xHarbour,

Line: 1271

http://searchcode.com/codesearch/view/4483707/

Show what you are doing.

Regards,

[karinha]

Corruption detected?

Look

dbOrderInfo

http://sourceforge.net/p/xharbour/mailman/message/16232978/

Regards.

[Antonio Linares]

Lorenzo,

Maybe you can first check if a file exists to force the wake up of the computer:

Code: Select all  Expand view

while ! File( "myfile.txt" )
   SysRefresh()
end
 

[karinha]

2155 Read error on index heading page

Explanation: A read error occurred when reading the heading page of
the index file, or the header did not contain the .ntx/cdx signature, or the
macro compiler returned a syntax error when attempting to compile the
key expression.

Action: Recreate the index file and check the key expression. Make
sure the database header is updated before index recreation.

[lorenzoazz]

Lorenzo,

Maybe you can first check if a file exists to force the wake up of the computer:

Code: Select all  Expand view

while ! File( "myfile.txt" )
   SysRefresh()
end
 

Antonio,
thanks but this does not work!
It is not a problem of file not found or read error, the problem is coming from the fact that, when in suspension
the "static" ? reference to the index file is lost.
I got the same error even if i try to relink the index!

This is not a question about some wrong code logic of mine, is all about the way windows 8.1 manage
and restore the memory after suspension !!!

This error OCCURS ONLY in this occasion/situation !

and here the Harbour code that cause the ERROR 2155

Code: Select all  Expand view

/*
 * check if index was updated by other process and if it was discard buffers
 */
static void hb_cdxIndexCheckVersion( LPCDXINDEX pIndex )
{
   BYTE byBuf[8];
   ULONG ulVer, ulFree;

   if ( hb_fsSeek( pIndex->hFile, 0x04, FS_SET ) != 0x04 ||
       hb_fsRead( pIndex->hFile, byBuf, 8 ) != 8 )
   {
      if ( pIndex->lockWrite > 0 && hb_fsSeek( pIndex->hFile, 0, FS_END ) == 0 )
         memset( byBuf, 0, 8 );
      else
         hb_errInternal( 2155, "hb_cdxIndexCheckVersion: Read error on index heading page.", NULL, NULL );
   }

[lorenzoazz]

2155 Read error on index heading page

Explanation: A read error occurred when reading the heading page of
the index file, or the header did not contain the .ntx/cdx signature, or the
macro compiler returned a syntax error when attempting to compile the
key expression.

Action: Recreate the index file and check the key expression. Make
sure the database header is updated before index recreation.

This cannot not be a solution because i would have to reindex every time i update,
as the program may be in suspended mode at any moment!

[karinha]

in xHarbour, I do so... Please test.

Code: Select all  Expand view

#Include "FiveWin.Ch"
#Include "Directry.ch"
#Include "Ord.Ch"

FUNCTION INDEX()

  ... DIALOG AND BUTTONS, ETC

  ... ACTION... ReIndPack( oMeter1, oMeter2, oMeter3 )

RETURN NIL

FUNCTION ReIndPack( oMeter1, oMeter2, oMeter3 )

   LOCAL Del_Indice

   EXTERNAL DESCEND

   DEL_INDICE := DIRECTORY( "*.CDX" )

   FOR I = 1 TO LEN( Del_Indice )
      FERASE( DEL_INDICE[I][1] )
   NEXT I

   IF NetUse( "CONVENIO", .F. )

       oMeter1:nTotal = RecCount()

       INDEX ON VAL(Field->CODIGO) TAG CODIGO TO CONVENIO                ;
             FOR !DELETED()                                              ;
             EVAL ( oMeter1:Set( RecNo() ), CursorWait(), SysRefresh() ) ;
             EVERY 10

       INDEX ON Field->NOME        TAG NOME   TO CONVENIO                ;
             FOR !DELETED()                                              ;
             EVAL ( oMeter1:Set( RecNo() ), CursorWait(), SysRefresh() ) ;
             EVERY 10

       DbCloseAll()

   ENDIF

RETURN NIL
 

Regards,

[Carlos Mora]

Hi lorenzoazz,

as CNavarro explained, if the OS is allowed to turn off network cards when going into suspend or energy saving mode, all files open are being closed, so there is NO WAY to recover from such situation. You SHOULD AVOID that, not allowing the card to be turned off by the operating system, as Cristobal Navarro explained. My operating system is in spanish, so i cannot show you an screenshot but look into network card properties, and DON'T ALLOW it to go off during energy saving.

In Antonio's post there is a line that shows you when the error arises, the system isn't able to read from the file, so the issue if far beyond your code, there is nothing to do from the Harbour's side, it seems to be a configuration problem.

Better yet, don't allow the computer go into suspend!

[Antonio Linares]

Lorenzo,

You may need to close the DBF and indexes and open them again, so the memory data is updated.