Just in case it is needed here is the Database Statistics: Anyone see any issues with these settings under Firebird 1.5 Classic?

Database header page information:
Flags 0
Checksum 12345
Generation 44659
Page size 8192
ODS version 10.1
Oldest transaction 26466
Oldest active 44650
Oldest snapshot 44650
Next transaction 44651
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 16
Shadow count 0
Page buffers 4096
Next header page 0
Database dialect 3
Creation date Mar 26, 2009 22:12:56
Attributes force write

Variable header data:
Sweep interval: 20000
*END*

----- Original Message -----
From: SoftTech
To: firebird-support@yahoogroups.com
Sent: Wednesday, April 01, 2009 10:12 PM
Subject: {Disarmed} [firebird-support] Validation Issues - What do they mean, and how do I fix them?


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)




[Non-text portions of this message have been removed]