Dear sirs,
At our company, we use a copy of the production db as development db, for many
reasons.
When we do that, we make a phisycal copy of the fdb file.
We observed that, when we make this copy, the generators are not updated, what
forces us to update manually the development
Never copy the FDB file! You WILL corrupt both FDB and copy file!
The best approach is do a gbak to backup and then restore the FDB.
You MUST read the firebird FAQ here: http://www.firebirdfaq.org/
Also: http://www.firebirdsql.org/manual/qsg10-howtocorrupt.html
and
On Thu, 31 May 2012 13:23:55 +0200, Kjell Rilbe kjell.ri...@datadia.se
wrote:
Den 2012-05-31 13:19 skrev Mark Rotteveel såhär:
On Thu, 31 May 2012 08:09:33 -0300, Fabiano fabianoas...@gmail.com
mailto:fabianoaspro%40gmail.com
wrote:
Never copy the FDB file! You WILL corrupt both FDB and
Although I agree with your advice, in general copying the file can corrupt
the target file, but it cannot corrupt not the source file. Usually for
copying a file the copy program will acquire a read lock, so nothing is
changed and the database process can continue writing to the file without
On Thu, 31 May 2012 04:25:02 -0700 (PDT), Tupy... nambá
anhangu...@yahoo.com wrote:
Ok, thanks. This is well known.
Then I ask = restoring the db will put the generators in the updated
status ?
I am not sure what the problem is your having. Making a backup of
production and restoring it in
Also: google for “How to corrupt a Firebird database”. Even Anti Virus programs
can (rarely) corrupt a database.
Fabiano
[Non-text portions of this message have been removed]
Thanks, Mark. This is exactly what I needed to know.
We know about the risks making copies this way, but this is done by another
person, not by ourselves. Since there is a minimal chance of having troubles,
certainly they will happen (see Murphy laws). But dividing
responsabilities, each
Hi!
Config : FB 2.0.6 ClassicServer on Linux
firebird.log contains the followings :
kernel: fb_lock_mgr: segfault at 2e9e eip 0804dabc esp bfe43840 error 4
kernel: fb_lock_mgr: segfault at 20ca eip 0804dabc esp bfa722c0 error 4
What is the meaning of this, what cause it, and how can
Hello Tupy... nambá,
what is the setting of forced writes
because generators are outside of transaction control and thf shud be updated
immediately
Thanks, Mark. This is exactly what I needed to know.
We know about the risks making copies this way, but this is done by another
person, not
On Thu, May 31, 2012 at 8:29 AM, Hannes Streicher hstreic...@gmx.de wrote:
Hello Tupy... nambá,
what is the setting of forced writes
because generators are outside of transaction control and thf shud be
updated
immediately
Generators are not written to disk every time they're changed.
Alan,
yes, FORCED WRITES is checked.
--- On Thu, 5/31/12, Alan McDonald a...@meta.com.au wrote:
From: Alan McDonald a...@meta.com.au
Subject: RE: RES: [firebird-support] Copy of the current db not updating
generators
To: firebird-support@yahoogroups.com
Date: Thursday, May 31, 2012, 4:26
Mark,
I agree your explanation is highly logical.
But, using the words that were told to me by another developer, the generators
values he found are previous values (the last used values at the development db
before the overwriting by the new copy) (may be this information is not 100% of
Or, according to An Harrison´s explanation, the generators had not been updated
due to not have been commited
--- On Thu, 5/31/12, Tupy... nambá anhangu...@yahoo.com wrote:
From: Tupy... nambá anhangu...@yahoo.com
Subject: Re: RES: [firebird-support] Copy of the current db not updating
On Thu, 31 May 2012 06:43:14 -0700 (PDT), Tupy... nambá
anhangu...@yahoo.com wrote:
Or, according to An Harrison´s explanation, the generators had not been
updated due to not have been commited
Even then, it would still show (older) values from production, not from
your previous test
We run FB over Windows.
The db file were overwritten, not a db restore.
Also the information about the generators values can´t be taken as confident
informations.
I think I have been well attended by all of you. I have enough information
about that to me.
Thanks to all,
Roberto Camargo.
I'll test in 2.5.1 and file a bug report.
-Original Message-
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Leyne, Sean
Sent: Friday, May 25, 2012 1:04 PM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] Left join and
Evening,
On 31/05/12 13:21, Tupy... nambá wrote:
We know about the risks making copies this way, but this is done by another
person, not by ourselves.
There is a recipe for using external (to Firebird supplied) tools to
backup or copy a database here:
Bogdan,
Please, say that to the one who does it. That´s not me.
Under normal conditions, those who doesn´t know how to make the things in a
right manner don´t ask for a technical help. So is and so will long to be this
way with the one who does this copy. Till he will have a great problem,
At 02:45 AM 1/06/2012, Ismael L. Donis Garcia wrote:
Exist some program to replication automatic to database firebird in Linux?
http://www.ibphoenix.com/products/software/ibreplicator
You need a connected Windows box to configure it. A trial version is available
and this product has its own
I haven't received any responses in 10 days. Maybe the question is not
clear, so I will restate it.
How can I configure the location of all Firebird temporary, sort and
lock files and control their sizes?
Thanks,
Alec
On Mon, May 21, 2012 at 1:10 PM, Alec Swan alecs...@gmail.com wrote:
I
unsubscribe
Please follow the instructions in the footer of this message to unsubscribe
++
Yahoo! Groups Links
Hello:
I simply before any command try to get the time of the Server. If it is
successful then application can communicate.
Greetings.
Walter.
On Wed, May 30, 2012 at 3:43 AM, sasidhardoc sasidhar...@yahoo.com wrote:
**
I am developing an application using FB 2.5 and the .NET provider.
22 matches
Mail list logo