Subject | Re: [firebird-support] How to trigger automatic sweep? |
---|---|
Author | Gabor Boros |
Post date | 2019-05-01T18:09:36Z |
2019. 05. 01. 16:24 keltezéssel, hvlad@...
[firebird-support] írta:
SRV Wed May 01 19:51:35 2019
Database: EMPLOYEE
Index 1 is corrupt (record 29189 have missing entries) in table
SALARY_HISTORY (136)
I updating the SALARY table.
The firebird.log not exists before the above messages.
database" is better?
Can I create a backtrace or whatever?
Gabor
[firebird-support] írta:
> > After this step firebird.log contains:Don't know. I not shutdown anything.
> >
> > SRV Wed May 01 14:54:40 2019
> > Sweep is started by SWEEPER
> > Database "EMPLOYEE"
> > OIT 156, OAT 20157, OST 20157, Next 20157
> >
> > SRV Wed May 01 14:54:41 2019
> > Shutting down the server with 1 active connection(s) to 1 database(s),
> > 0 active service(s)
>
> Why it was shut down ?
> > and result of "gfix -validate -full -no_update EMPLOYEE":The above things and like the next:
> >
> > Summary of validation errors
> > Number of index page errors : 1
>
> What is in firebird.log ? Are you sure there was no errors before the
> sweep ?
SRV Wed May 01 19:51:35 2019
Database: EMPLOYEE
Index 1 is corrupt (record 29189 have missing entries) in table
SALARY_HISTORY (136)
I updating the SALARY table.
The firebird.log not exists before the above messages.
>Sorry Vlad I don't know the good term. The "something went wrong in the
> > So, I wanted to see this! Automatic sweep destroy the database. And easy
> > to reproduce. Too easy! :-(
>
> Why do you think database is "destroyed" ? Too strong statement without
> answes on my questions above.
database" is better?
Can I create a backtrace or whatever?
Gabor