---In firebird-support@yahoogroups.com, <mark@...> wrote :
Mark, your answer as usual very detailed and very good, i just want to
correct it a bit.
>> /1. //POS003 (Server) Fri Jul 15 11:56:32 2016/
> 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.
...
> data loss if that connection had active transactions.
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
__._,_.___
Posted by: hvlad@users.sourceforge.net
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (4) |
Save time and get your email on the go with the Yahoo Mail app
Get the beautifully designed, lighting fast, and easy-to-use Yahoo Mail today. Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
.
__,_._,___
No comments:
Post a Comment