Subject Re: [firebird-support] How to trigger automatic sweep?
Author Gabor Boros
2019. 05. 01. 16:24 keltezéssel, hvlad@...
[firebird-support] írta:
> > After this step firebird.log contains:
> >
> > 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 ?


Don't know. I not shutdown anything.


> > and result of "gfix -validate -full -no_update EMPLOYEE":
> >
> > 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 ?


The above things and like the next:

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.


>
> > 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.


Sorry Vlad I don't know the good term. The "something went wrong in the
database" is better?

Can I create a backtrace or whatever?

Gabor