Subject | Re: [firebird-support] How to trigger automatic sweep? |
---|---|
Author | |
Post date | 2019-05-02T12:49:34Z |
>> Why it was shut down ?If you run CS and disconnected - both connections will be shutdown (yours one and sweep) as they
>
>
> Don't know. I not shutdown anything.
both handled by the same worker process. Are you run CS and disconnect immediately after triggering
auto-sweep ?
>> What is in firebird.log ? Are you sure there was no errors before theIt is not good and it shouldn't happen. The good thing is that It is easy to fix - just rebuild index.
>> 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)
Also, it could be false alarm - run manual sweep and validate database again to check it.
> I updating the SALARY table.Because you never validate database before, isn't it ?
>
> The firebird.log not exists before the above messages.
>>> So, I wanted to see this! Automatic sweep destroy the database. And easyAre your db really *destroyed* ? Is there a smoking hole in the HDD ?
>>> 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 you connect ? Can you read the data ? (I know - you can ;)
Yes, it seems somewhat corrupted but we not know if it was not corrupted before the sweep run.
Don't get me wrong - i need to know all such details.
> Can I create a backtrace or whatever?If it is really reproduced (starting with clean database) - create ticket and i'll fix it.
Regards,
Vlad