[firebase-br] Perda de dados 2 dias

Douglas Silva forum_firebird em daunebr.com
Qua Dez 23 08:30:05 -03 2009

Agora está claro. Isto nao é um defeito do linux e sim uma caracteristica. Ou seja, nós que usamos (e amamos) o Firebird precisamos estar atentos a esta caracteristica e nao fazer backup nem mexer nos *.fdb da vida sem os devidos cuidados.

Aqui vai minha pergunta: usar o nbackup é suficiente ou temos mesmo que parar o servidor? 

I love this list.

From: Carlos H. Cantu <listas em warmboot.com.br>
To: Carlos H. Cantu <listas em warmboot.com.br>; FireBase <lista em firebase.com.br>
Sent: Tue, December 22, 2009 10:46:54 PM
Subject: Re: [firebase-br] Perda de dados 2 dias

Mais informações:


Disappeared” files on Linux/Unix/HP-UX/...

It is well-known fact that Linux uses the inode mechanism to support
different file systems. One of the key features of this mechanism is
the use of cache to handle file descriptors – it means that file
descriptors are stored both in memory and on disk.

To InterBase and Firebird it brings an onerous side-effect. If you
replace a database when users are still connected, the server will
continue to work with the old file, which is wrongly assumed to be
deleted. The danger here is that, when the last user detaches, the
server will drop the file forever and the “new” file steps in to
replace it at that point. You never know it has happened until it is
too late and then, it is most likely to be discovered by furious
users: “Where is my work from last week?!”

The longest period of lost data due to such «disappearing» that I have
observed was 1.5 years. It was a multi-volume database on Linux and
one of the 4Gb volumes was completely lost.

You may say it is a very rare circumstance but I can stake a case of
beer on the fact that, right now, at least one hundred server
installations have this problem. We receive at least one repair
request due to this problem every two months!

Carlos H. Cantu
www.FireBase.com.br - www.firebirdnews.org
www.warmboot.com.br - blog.firebase.com.br

FireBase-BR (www.firebase.com.br) - Hospedado em www.locador.com.br
Para saber como gerenciar/excluir seu cadastro na lista, use: http://www.firebase.com.br/fb/artigo.php?id=1107
Para consultar mensagens antigas: http://firebase.com.br/pesquisa

Mais detalhes sobre a lista de discussão lista