Thank You so much Helen :)
Cheers...
On Thursday, 11 June 2015 3:19 PM, Helen Borrie hele...@iinet.net.au
[firebird-support] firebird-support@yahoogroups.com wrote:
At 09:17 p.m. 11/06/2015, Vishal Tiwari vishuals...@yahoo.co.in
[firebird-support] wrote:
Hi All,
I am not sure
Hi All,
I am not sure whether this question is suitable here or not, but still I would
like to give a try.
I am using Delphi 2010 with FIB Components like TpFIBDataset, TpFIBTransaction
and TpFIBDataset with Firebird database.
I have already set TpFIBDataset's 'AutoCommit' property to 'False',
At 09:17 p.m. 11/06/2015, Vishal Tiwari vishuals...@yahoo.co.in
[firebird-support] wrote:
Hi All,
I am not sure whether this question is suitable here or not, but still I would
like to give a try.
I am using Delphi 2010 with FIB Components like TpFIBDataset, TpFIBTransaction
and
Hi,
Maybe wrong direction
But set this restored with error database to be a readonly and try to connect
to it
Regards,
Karol Bieniaszewski
- Reply message -
Od: Jack Mason jackma...@mindspring.com [firebird-support]
firebird-support@yahoogroups.com
Do: firebird-support@yahoogroups.com
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
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. We did not have that problem with Interbase 6 but
switched to Firebird because it was touted as being modern, safer
etc.
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
Thank you Dmitry.
Here are the results of gstat:
FLAT_DATA (290)
Primary pointer page: 5239142, Index root page: 5239147
Average record length: 213.90, total records: 8288203
Average version length: 0.00, total versions: 0, max versions: 0
Data pages: 533746, data page slots:
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
then used Firebird 2.52 to restore them.
Firebird 2.52 will back them up, but will not
---In firebird-support@yahoogroups.com, jackmason@... wrote :
Is this what you needed?
Hmm... i'd say it is impossible to obtain such results using FIrebird. See
below
C:\Program Files\Firebird\Firebird_2_5\binisql -user sysdba -pass masterkey
Use CONNECT or CREATE DATABASE to
IMHO you have a corrupted database. You must use gfix to correct it
(google it) and then your backup/restore cycle will be completed with no
errors.
On 11/06/2015 17:33, Jack Mason jackma...@mindspring.com
[firebird-support] wrote:
Why is everyone else not having this problem? The
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
Thanks Steve for the information. I think we’ll try on a virtual machine the
centOS versions with the different mode of firebird (classic, superserver,
superclassic).
To Thomas, yes that’s real remote connections from different remote servers
(there is no local connections).
De :
Thanks Steve for the information. I think we’ll try on a virtual machine
the centOS versions with the different mode of firebird (classic,
superserver, superclassic).
To Thomas, yes that’s real remote connections from different remote
servers (there is no local connections).
Ok, do they all
Yes. They have all a Firebird 2.5.2 client library.
And before we went on Centos 7 for the server we were working on a debian
server and at that time de mon$remote_address had a correct information.
De : firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Envoyé : jeudi 11
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*
Hi,
Maybe another wrong direction,
But download snapshot build of FB2.5
And extract from there gback file. Do backup with them and try to restore
Regards,
Karol Bieniaszewski
Wysłane z mojego HTC
- Reply message -
Od: Tim Ward t...@telensa.com [firebird-support]
---In firebird-support@yahoogroups.com, jackmason@... wrote :
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.
Are you sure you run Firebird 2.5 on Win7 (not 2.1) ?
Please, run following in command
Could not find gback file, but attached is a snapshot of the bin
directory for our download. Is that what you needed?
Jack
On 6/11/2015 11:35 AM, 'liviusliv...@poczta.onet.pl'
liviusliv...@poczta.onet.pl [firebird-support] wrote:
Hi,
Maybe another wrong direction,
But download snapshot
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
Hi,
you tried “also” 3.0 or only 3.0?
If only then try 2.5.5 snapshot
but error is about c++ configuration
http://answers.microsoft.com/en-us/windows/forum/windows_7-pictures/error-the-application-has-failed-to-start-because/df019c0d-746e-42d0-ad68-465e18e3f3ef
but first try different think.
Is it safe to change firebirds process priority to above normal , high
or realtime ?
We have been having problems with it set to normal.
Sometimes admins will copy files or do other process that are as prioritized
and that ruins the servers.
I also tried 3.0 and it did not work. However, using your suggestion
of unzipping everything, 2.55 did run and backed up the database. It
did not restore the database, however, and got the same error 'filter (3)'.
Jack
On 6/11/2015 3:08 PM, liviusliv...@poczta.onet.pl [firebird-support]
34 matches
Mail list logo