| Subject | Re: [firebird-support] Firebird - explanation of errors |
|---|---|
| Author | |
| Post date | 2016-07-20T09:36:07Z |
---In firebird-support@yahoogroups.com, <mark@...> wrote :
It means that Firebird will rollback all active transactions on shutdown. I.e. uncommitted
data could be lost.
Regards,
Vlad
Mark, your answer as usual very detailed and very good, i just want to
correct it a bit.
correct it a bit.
>> /1. //POS003 (Server) Fri Jul 15 11:56:32 2016/
>>> in order. If the backup fails, you may first need to repair the database
>> / Database: C:\GASTRO.FDB/
>>
>> / Index 6 is corrupt (missing entries) in table POZRACH
>> (259)/
> Potentially disturbing. A backup and (if successful) a restore might be
> first.
Rebuild of problem index is enough, no need to backup\restore.
If index can't be rebuild because of PK\FK violation, duplicated\orphaned
records should be found and fixed first.
...>> /6. //POS003 (Server) Mon Jul 18 12:51:48 2016/> while there were still connections. This may indicate potentially cause
>>
>> / Shutting down the Firebird service with 1 active
>> connection(s) to 1 database(s)/
> Informational message. Something or someone stopped the Firebird service
> data loss if that connection had active transactions.
It means that Firebird will rollback all active transactions on shutdown. I.e. uncommitted
data could be lost.
Regards,
Vlad