--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...> wrote:
>
> At 08:31 PM 21/11/2009, you wrote:
>
> >hmmm. finally i do like this:
> >1/ gfix -v -f => ok i receive error report
> >2/ gfix -m -i => receive error report
> >3/ again gfix -v -f => ok i receive error report
> >4/ backup the data => OK
> >5/ restore the data => OK with error : some foreign key are not active because of foreign key violation
> >6/ ISQL => locate and delete all the data in error (only one record in the master database missing, so i delete all the record connected to this reccord)
> >7/ activate the foreign key
> >8/ backup the data
> >9/ restore the data => OK
> >10/ run gfix -v -f => OK
> >
> >now everything seam to work weel ... did i forget something ? now can i m be sure now that the integrity of the database is OK? all the corruption is really go away ?
>
> Sounds good to me. :-)
>
> ./heLen
>
>
>
> >>
> >> We have an expression in English - "shutting the stable door after >the horse has bolted". In the hope that this is not such a case, >please study this paper, which shows at least how important it is to >do the right things, in the right order, and only on a COPY of your >database:
> >>
> >> http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_db_corr
> >
> >yes thanks for the link. the first think i do is :
> >gfix -write sync database.gdb
> >
> >because in fact the probleme is not only power lost, but it's can also be server crash ! if the FB_inet crash (like out of memory) then if data are not flush the database can be corrupted (i thing it's what happen to me). in fact sometime the fb_inet simply "hang" accepting incomming connection but not answer to them (making the client freezing) ... why ? i don't really know... at the beginning i was thing the the probleme was on the client side, but now i m not sure anymore. As it is an web app, more and more connection arrive and are "trap" like this... stil no more memory availale on the server (monday i will buy 64GO) ... killing the client not change anything and the only way i found was to restart the server ! after you know the story ....
> >
> >stephane
> >
> >
> >
> >
> >
> >
> >------------------------------------
> >
> >++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> >Visit http://www.firebirdsql.org and click the Resources item
> >on the main (top) menu. Try Knowledgebase and FAQ links !
> >
> >Also search the knowledgebases at http://www.ibphoenix.com
> >
> >++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >Yahoo! Groups Links
> >
> >
> >
>