Unlike Vlad, Helen and Thomas, I know next to nothing about problems like yours
(I'm good at SELECTs, which is way different from corrupted backups). Hence,
listen more to them than to me.
gbak:restoring privilege for user SYSDBA
gbak: ERROR:action cancelled by trigger (3) to preserve data
@yahoogroups.com
Onderwerp: [firebird-support] Firebird 2.52 gbak fails to do a
restore - error trigger (3)
Datum: vr, jun. 12, 2015 18:06
Ah... thanks for that info. So, export all the data and
rebuild from scratch is the way to go?
Jack
On 6/12/2015 12:56 AM, Helen
Onderwerp: [firebird-support] Firebird 2.52 gbak fails to do a restore -
error trigger (3)
Datum: vr, jun. 12, 2015 18:06
Ah... thanks for that info. So, export all the data and rebuild
from scratch is the way to go?
Jack
On 6/12/2015 12:56 AM, Helen Borrie hele...@iinet.net.au
[firebird
Thank you very much. I will get a chance to try the -o switch this
weekend when everyone goes home.
Jack
On 6/12/2015 2:25 PM, Ann Harrison aharri...@ibphoenix.com
[firebird-support] wrote:
On 6/12/2015 2:11 PM, Jack Mason jackma...@mindspring.com
[firebird-support] wrote:
Thank you very
Ah... thanks for that info. So, export all the data and rebuild
from scratch is the way to go?
Jack
On 6/12/2015 12:56 AM, Helen Borrie hele...@iinet.net.au
[firebird-support] wrote:
At 08:57 a.m. 12/06/2015, Jack Mason jackma...@mindspring.com
[firebird-support] wrote:
We were
@yahoogroups.com
Aan: firebird-support@yahoogroups.com
Onderwerp: [firebird-support] Firebird 2.52 gbak fails to do a restore - error
trigger (3)
Datum: vr, jun. 12, 2015 18:06
Ah... thanks for that info. So, export all the data and
rebuild from scratch is the way to go?
Jack
On 6/12/2015 12:56
-support@yahoogroups.com
Onderwerp: [firebird-support] Firebird 2.52 gbak fails to do a restore
- error trigger (3)
Datum: vr, jun. 12, 2015 18:06
Ah... thanks for that info. So, export all the data and rebuild
from scratch is the way to go?
Jack
On 6/12/2015 12:56 AM, Helen Borrie hele
Thank you very much. I will try the -o switch and the gfix suggestion
as well.
Jack
On 6/12/2015 2:08 PM, Ann Harrison aharri...@ibphoenix.com
[firebird-support] wrote:
On 6/11/2015 11:05 AM, Jack Mason jackma...@mindspring.com
[firebird-support] wrote:
However, that won't help us.
On 6/12/2015 2:11 PM, Jack Mason jackma...@mindspring.com
[firebird-support] wrote:
Thank you very much. I will try the -o switch and the gfix
suggestion as well.
Don't bother with gfix. It does a physical database check - pointers
point to what
they should, pages are the right type,
On 6/11/2015 11:05 AM, Jack Mason jackma...@mindspring.com
[firebird-support] wrote:
However, that won't help us. Our concern is that we have been backing
up our databases for years and it has been a fruitless exercise. We
cannot restore them. We did not have that problem with Interbase
On 6/11/2015 4:33 PM, Jack Mason jackma...@mindspring.com
[firebird-support] wrote:
Why is everyone else not having this problem? The databases are
Firebird databases. For 15 years we had no corruption from Interbase
6. Two years ago, we backed up our databases with Interbase 6 gbak
and
Temat: [firebird-support] Firebird 2.52 gbak fails to do a restore - error
trigger (3)
Data: czw., cze 11, 2015 16:26
Here is the gstat - h:
Database customer
Database header page information:
Flags0
Checksum12345
Generation1175184
Page size
gstat is not included in the Firebird release I downloaded:
C:\Firebirddir
Volume in drive C has no label.
Volume Serial Number is FA80-0C12
Directory of C:\Firebird
09/29/2014 02:25 PMDIR .
09/29/2014 02:25 PMDIR ..
09/29/2014 01:16 PM
: Jack Mason jackma...@mindspring.com [firebird-support]
firebird-support@yahoogroups.com
Do: firebird-support@yahoogroups.com
Temat: [firebird-support] Firebird 2.52 gbak fails to do a restore -
error trigger (3)
Data: czw., cze 11, 2015 16:26
Here is the gstat - h:
Database customer
Database
Here is the gstat - h:
Database customer
Database header page information:
Flags0
Checksum12345
Generation1175184
Page size4096
ODS version11.2
Oldest transaction119622
Oldest active1072065
Oldest
The databases are backed up between midnight and 6 am when no one is
using them. However, the databases are still open in multiple
programs. The backup is:
C:\program files\firebird\firebird_2_5\bin\gbak -b -v -user SYSDBA
-pas masterkey 192.168.1.252:/bfl/smtbdb/customer
The databases reside on a Linux Mint server, but we back them up to a
Windows 7 system. Both are running the same release of Firebird. We
use Linux as the server because Linux is far more reliable than Windows
for everything, but it is the only Linux computer we use. Everything
else
The databases reside on a Linux Mint server, but we back them up to a
Windows 7 system. Both are running the same release of Firebird. We
use Linux as the server because Linux is far more reliable than Windows
for everything, but it is the only Linux computer we use. Everything
else is
gstat is not included in the Firebird release I downloaded:
C:\Firebirddir
Volume in drive C has no label.
Volume Serial Number is FA80-0C12
Directory of C:\Firebird
09/29/2014 02:25 PMDIR .
09/29/2014 02:25 PMDIR ..
09/29/2014 01:16 PM 105,717
The databases are backed up between midnight and 6 am when no one is
using them. However, the databases are still open in multiple
programs. The backup is:
C:\program files\firebird\firebird_2_5\bin\gbak -b -v -user SYSDBA
-pas masterkey 192.168.1.252:/bfl/smtbdb/customer
is
different if you only copy gbak.exe
regards,
Karol Bieniaszewski
*From:* mailto:firebird-support@yahoogroups.com
*Sent:* Thursday, June 11, 2015 8:03 PM
*To:* firebird-support@yahoogroups.com
mailto:firebird-support@yahoogroups.com
*Subject:* Re: Odp: [firebird-support] Firebird 2.52 gbak fails
Bieniaszewski
*From:* mailto:firebird-support@yahoogroups.com
*Sent:* Thursday, June 11, 2015 8:03 PM
*To:* firebird-support@yahoogroups.com
mailto:firebird-support@yahoogroups.com
*Subject:* Re: Odp: [firebird-support] Firebird 2.52 gbak fails to do
a restore - error trigger (3)
Got it. Here is what
Hello jack, may be you have a problem with the metadata of your database, that
were compatible with interbase 6 but not with firebird. Firebird is more strict
than Interbase was. I had problem in the past backing up interbase 5.6 and
restoring in firebird.
The problem was solved, extracting
We do not have ANY stored procedures, triggers, checks, etc. We are not
smart enough to use them and they seemed risky because we would not be
able to see them when we modified/upgraded our software. We simply
read/write/add/subtract records from the databases.
We were told that backing up
At 08:57 a.m. 12/06/2015, Jack Mason jackma...@mindspring.com
[firebird-support] wrote:
We were told that backing up with Interbase gbak and restoring with Firebird
gbak was the proper migration procedure, but that is apparently not true?
That was true way back at Firebird 1.0 and
You asked something similar 2 years ago:
http://comments.gmane.org/gmane.comp.db.firebird.user/7145
--
With regards,
Thomas Steinmaurer
http://www.upscene.com/
Sorry for off-top but
I'am very interested what jack.mason will say about this :
You have my +1 ;-)
regards,
Karol
Hello,
We have backed up our databases daily for two years using Firebird 2.52
Superserver and its associated gbak. We now need to restore one of the
databases and gbak fails to do the restore, giving the following error:
[snip gbak output]
gbak: ERROR:action cancelled by trigger (3) to
Thanks. I appreciate your feedback. That appears to be what I will
need to do.
Jack
On 6/11/2015 5:45 PM, Jesus Garcia jeg...@gmail.com [firebird-support]
wrote:
Hello jack, may be you have a problem with the metadata of your
database, that were compatible with interbase 6 but not with
Very true, Captain Obvious. We fell prey to the Firebird is great! myth.
On 6/11/2015 11:11 AM, Tim Ward t...@telensa.com [firebird-support] wrote:
On 11/06/2015 16:05, Jack Mason jackma...@mindspring.com
[firebird-support] wrote:
Thanks,
However, that won't help us. Our concern is that
On 11/06/2015 16:05, Jack Mason jackma...@mindspring.com
[firebird-support] wrote:
Thanks,
However, that won't help us. Our concern is that we have been backing
up our databases for years and it has been a fruitless exercise. We
cannot restore them.
*Any* backup procedure for *any*
@yahoogroups.com
Do: firebird-support@yahoogroups.com
Temat: Odp: [firebird-support] Firebird 2.52 gbak fails to do a restore - error
trigger (3)
Data: czw., cze 11, 2015 17:11
On 11/06/2015 16:05, Jack Mason
jackma...@mindspring.com [firebird-support] wrote:
Thanks,
However, that won't help us
Temat: Odp: [firebird-support] Firebird 2.52 gbak fails to do a
restore - error trigger (3)
Data: czw., cze 11, 2015 17:11
On 11/06/2015 16:05, Jack Mason jackma...@mindspring.com
[firebird-support] wrote:
Thanks,
However, that won't help us. Our concern is that we have been
backing up our
Got it. Here is what I got when I tried to execute it:
C:\backups\Bufordgbak -b -v -user SYSDBA -pas masterkey
192.168.1.252:/bfl/smtb
db/customer customer.bak
The application has failed to start because its side-by-side
configuration is in
correct. Please see the application event log or
, 2015 8:03 PM
To: firebird-support@yahoogroups.com
Subject: Re: Odp: [firebird-support] Firebird 2.52 gbak fails to do a restore -
error trigger (3)
Got it. Here is what I got when I tried to execute it:
C:\backups\Bufordgbak -b -v -user SYSDBA -pas masterkey 192.168.1.252:/bfl/smtb
db/customer
, 2015 8:03 PM
*To:* firebird-support@yahoogroups.com
mailto:firebird-support@yahoogroups.com
*Subject:* Re: Odp: [firebird-support] Firebird 2.52 gbak fails to do
a restore - error trigger (3)
Got it. Here is what I got when I tried to execute it:
C:\backups\Bufordgbak -b -v -user SYSDBA -pas
We have backed up our databases daily for two years using Firebird 2.52
Superserver and its associated gbak. We now need to restore one of the
databases and gbak fails to do the restore, giving the following error:
gbak:restoring column DISCOUNT
gbak:restoring column DEPOSIT
gbak:
36 matches
Mail list logo