--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@m...>
wrote:

> > The server makes the backup all night.
> >
> > After the backup, the same batch restore it with another name
> > (test.gdb), just to see if it's ok, and generate a log in case of
> > error messages.
> >
> > The tape backup is made after that, just on the gbk file, not on

the

> > gdb file.
> >
> > I have almost 15 servers running basically the same configuration
> > and batches for some years and it's the first time i saw this

error.

> >
> > I solved the problem removing the table REM1 (after removing its
> > dependencies), so i could make the backup, and then i restored it
> > and recreated REM1 and its dependencies and data.
> >
> > But i expected to have this problem solved by gbak or gfix, like

all

> > my previous corruption problems, not manually.
>
> It sounds like you are doing the right things. What switches did

you try

> with gfix?
> Does REM1 have blob contents? What is the page size of the

datbases?

> Alan

REM1 doesn't have blob contents.
The page size os this database is 4096.

I did the following, in this sequence:

gfix -v -full tecotton.gdb
<no errors reported>

gfix -mend -full -ignore tecotton.gdb
<no errors reported>

gfix -v -full tecotton.gdb
<no errors reported>

gbak -backup -v -ignore tecotton.gdb tecotton.gbk
<message length error>

gbak -backup -v -ignore -garbage tecotton.gdb tecotton.gbk
<message length error>

gbak -backup -v -ignore -garbage -limbo tecotton.gdb tecotton.gbk
<message length error>

After that, i droped the table, did the backup/restore withou
problems and recreated the table.

Output of gstat:

Database "tecotton.gdb"

Database header page information:
Flags 0
Checksum 12345
Generation 258142
Page size 4096
ODS version 10.1
Oldest transaction 239884
Oldest active 258118
Oldest snapshot 258118
Next transaction 258125
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 19
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Jul 14, 2003 12:54:06
Attributes

Variable header data:
Sweep interval: 20000
*END*


Database file sequence:
File tecotton.erro.051203 is the only file