Subject | Re: FB2.1 frequently Index corruption in DB |
---|---|
Author | mnavahan |
Post date | 2008-07-19T01:35:24Z |
Note always i have problem with one table (table 129 !)
Database header page information:
Flags 0
Checksum 12345
Generation 16019
Page size 4096
ODS version 11.1
Oldest transaction 3858
Oldest active 15172
Oldest snapshot 15172
Next transaction 15173
Bumped transaction 1
Sequence number 0
Next attachment ID 839
Implementation ID 16
Shadow count 0
Page buffers 8192
Next header page 0
Database dialect 3
Creation date Jul 10, 2008 0:25:19
Attributes force write
Variable header data:
Sweep interval: 0
*END*
and also report for table 129 index :
XXX (129)
Primary pointer page: 238, Index root page: 239
Average record length: 181.76, total records: 45025
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 2528, data page slots: 2532, average fill: 87%
Fill distribution:
0 - 19% = 6
20 - 39% = 3
40 - 59% = 2
60 - 79% = 16
80 - 99% = 2501
Index PK_XXX (1)
Depth: 2, leaf buckets: 58, nodes: 45025
Average data length: 1.02, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 57
Database header page information:
Flags 0
Checksum 12345
Generation 16019
Page size 4096
ODS version 11.1
Oldest transaction 3858
Oldest active 15172
Oldest snapshot 15172
Next transaction 15173
Bumped transaction 1
Sequence number 0
Next attachment ID 839
Implementation ID 16
Shadow count 0
Page buffers 8192
Next header page 0
Database dialect 3
Creation date Jul 10, 2008 0:25:19
Attributes force write
Variable header data:
Sweep interval: 0
*END*
and also report for table 129 index :
XXX (129)
Primary pointer page: 238, Index root page: 239
Average record length: 181.76, total records: 45025
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 2528, data page slots: 2532, average fill: 87%
Fill distribution:
0 - 19% = 6
20 - 39% = 3
40 - 59% = 2
60 - 79% = 16
80 - 99% = 2501
Index PK_XXX (1)
Depth: 2, leaf buckets: 58, nodes: 45025
Average data length: 1.02, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 57
--- In firebird-support@yahoogroups.com, "Leyne, Sean" <Sean@...> wrote:
>
>
> > > > COMPUTER1 Thu Jul 10 00:24:16 2008
> > > > Database: MI4
> > > > Index 1 is corrupt on page 33525 level 1. File:
> > > > ..\..\..\src\jrd\validation.cpp, line: 1658
> > > > in table XXX (129)
> > >
> > > Please open a case in the project tracker
> > > (http://tracker.firebirdsql.org)
> > >
> > > It would be ideal if you had a reproducible case to include with the
> > > case.
> >
> > its very hard to reproducible case is large db (180MB size )with over
> > 140Table and contain my org info !
>
> As the expression goes, size is relative ;-)
>
> A _small_ database for me is 800MB!
>
> Can you please post the database header statistics.
>
>
> Sean
>