Greetings All,

I use Database Workbench for development of my database.

Upon doing a validation on my database using GFix thur Database Workbench it
return these errors:

Summary of validation errors

Number of index page error : 5

Check the server log file for details.

So I checked the firebird.log and found the following. I can tell I have
index issues on certain tables.

1) Can anyone tell me how to read these errors and what I need to do to fix
them (Hopefully without losing any data)?

2) Will a deactive/reactive index fix this issue?

3) Is there a way to reindex or rebuild these tables. If so how?

Thanks to all that reply.

MICHAEL Wed Apr 01 20:13:47 2009
Database: C:\FRONTLINE\COLLECTINGIT\DATABASE\COLLECTINGIT.FDB
Index 2 is corrupt on page 738601 in table ACCT_TRAN_DEBTOR (147)


MICHAEL Wed Apr 01 20:13:56 2009
Database: C:\FRONTLINE\COLLECTINGIT\DATABASE\COLLECTINGIT.FDB
Index 2 is corrupt on page 657974 in table ACCT_TRAN_DETAIL (152)


MICHAEL Wed Apr 01 20:14:47 2009
Database: C:\FRONTLINE\COLLECTINGIT\DATABASE\COLLECTINGIT.FDB
Index 2 is corrupt on page 717491 in table ACCT_TRAN_DETAIL_TASK_DEBTS
(158)


MICHAEL Wed Apr 01 20:14:56 2009
Database: C:\FRONTLINE\COLLECTINGIT\DATABASE\COLLECTINGIT.FDB
Index 2 is corrupt on page 710258 in table ACCT_TRAN_DETAIL_TASK_MERGE
(167)


MICHAEL Wed Apr 01 20:15:10 2009
Database: C:\FRONTLINE\COLLECTINGIT\DATABASE\COLLECTINGIT.FDB
Index 3 is corrupt on page 700896 in table ACCT_TRAN_MASTER (172)


MICHAEL Wed Apr 01 21:02:44 2009
Database: C:\FRONTLINE\COLLECTINGIT\DATABASE\COLLECTINGIT.FDB
Index 2 is corrupt on page 738601 in table ACCT_TRAN_DEBTOR (147)


MICHAEL Wed Apr 01 21:02:53 2009
Database: C:\FRONTLINE\COLLECTINGIT\DATABASE\COLLECTINGIT.FDB
Index 2 is corrupt on page 657974 in table ACCT_TRAN_DETAIL (152)


MICHAEL Wed Apr 01 21:03:40 2009
Database: C:\FRONTLINE\COLLECTINGIT\DATABASE\COLLECTINGIT.FDB
Index 2 is corrupt on page 717491 in table ACCT_TRAN_DETAIL_TASK_DEBTS
(158)


MICHAEL Wed Apr 01 21:03:49 2009
Database: C:\FRONTLINE\COLLECTINGIT\DATABASE\COLLECTINGIT.FDB
Index 2 is corrupt on page 710258 in table ACCT_TRAN_DETAIL_TASK_MERGE
(167)


MICHAEL Wed Apr 01 21:04:04 2009
Database: C:\FRONTLINE\COLLECTINGIT\DATABASE\COLLECTINGIT.FDB
Index 3 is corrupt on page 700896 in table ACCT_TRAN_MASTER (172)