Re: [firebird-support] Rolling back Transaction Doesn't Work with TpFIB Components
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 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', then also
when I execute below statement in the try..finally block and rollback the
transaction data still get posted. Could anyone help ?
Here is where you need to go:
http://www.devrace.com/en/support/forum/
The question is off-topic here, sorry.
^heLen^ (List Moderator)
#yiv0308125532 #yiv0308125532 -- #yiv0308125532ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0308125532
#yiv0308125532ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0308125532
#yiv0308125532ygrp-mkp #yiv0308125532hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv0308125532 #yiv0308125532ygrp-mkp #yiv0308125532ads
{margin-bottom:10px;}#yiv0308125532 #yiv0308125532ygrp-mkp .yiv0308125532ad
{padding:0 0;}#yiv0308125532 #yiv0308125532ygrp-mkp .yiv0308125532ad p
{margin:0;}#yiv0308125532 #yiv0308125532ygrp-mkp .yiv0308125532ad a
{color:#ff;text-decoration:none;}#yiv0308125532 #yiv0308125532ygrp-sponsor
#yiv0308125532ygrp-lc {font-family:Arial;}#yiv0308125532
#yiv0308125532ygrp-sponsor #yiv0308125532ygrp-lc #yiv0308125532hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0308125532
#yiv0308125532ygrp-sponsor #yiv0308125532ygrp-lc .yiv0308125532ad
{margin-bottom:10px;padding:0 0;}#yiv0308125532 #yiv0308125532actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0308125532
#yiv0308125532activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0308125532
#yiv0308125532activity span {font-weight:700;}#yiv0308125532
#yiv0308125532activity span:first-child
{text-transform:uppercase;}#yiv0308125532 #yiv0308125532activity span a
{color:#5085b6;text-decoration:none;}#yiv0308125532 #yiv0308125532activity span
span {color:#ff7900;}#yiv0308125532 #yiv0308125532activity span
.yiv0308125532underline {text-decoration:underline;}#yiv0308125532
.yiv0308125532attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv0308125532 .yiv0308125532attach div a
{text-decoration:none;}#yiv0308125532 .yiv0308125532attach img
{border:none;padding-right:5px;}#yiv0308125532 .yiv0308125532attach label
{display:block;margin-bottom:5px;}#yiv0308125532 .yiv0308125532attach label a
{text-decoration:none;}#yiv0308125532 blockquote {margin:0 0 0
4px;}#yiv0308125532 .yiv0308125532bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv0308125532
.yiv0308125532bold a {text-decoration:none;}#yiv0308125532 dd.yiv0308125532last
p a {font-family:Verdana;font-weight:700;}#yiv0308125532 dd.yiv0308125532last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0308125532
dd.yiv0308125532last p span.yiv0308125532yshortcuts
{margin-right:0;}#yiv0308125532 div.yiv0308125532attach-table div div a
{text-decoration:none;}#yiv0308125532 div.yiv0308125532attach-table
{width:400px;}#yiv0308125532 div.yiv0308125532file-title a, #yiv0308125532
div.yiv0308125532file-title a:active, #yiv0308125532
div.yiv0308125532file-title a:hover, #yiv0308125532 div.yiv0308125532file-title
a:visited {text-decoration:none;}#yiv0308125532 div.yiv0308125532photo-title a,
#yiv0308125532 div.yiv0308125532photo-title a:active, #yiv0308125532
div.yiv0308125532photo-title a:hover, #yiv0308125532
div.yiv0308125532photo-title a:visited {text-decoration:none;}#yiv0308125532
div#yiv0308125532ygrp-mlmsg #yiv0308125532ygrp-msg p a
span.yiv0308125532yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0308125532
.yiv0308125532green {color:#628c2a;}#yiv0308125532 .yiv0308125532MsoNormal
{margin:0 0 0 0;}#yiv0308125532 o {font-size:0;}#yiv0308125532
#yiv0308125532photos div {float:left;width:72px;}#yiv0308125532
#yiv0308125532photos div div {border:1px solid
#66;height:62px;overflow:hidden;width:62px;}#yiv0308125532
#yiv0308125532photos div label
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0308125532
#yiv0308125532reco-category {font-size:77%;}#yiv0308125532
#yiv0308125532reco-desc {font-size:77%;}#yiv0308125532 .yiv0308125532replbq
{margin:4px;}#yiv0308125532 #yiv0308125532ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv0308125532 #yiv0308125532ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0308125532
#yiv0308125532ygrp-mlmsg table
[firebird-support] Rolling back Transaction Doesn't Work with TpFIB Components
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', then also when I execute below statement in the try..finally block and rollback the transaction data still get posted. Could anyone help ? FIBDataset.Post; Below is the sample code. try FIBDatabase.StartTransaction; Block of Code; FIBDataset.Post; ... finally if saveALL then FIBDatabase.CommitRetaining else FIBDatabase.RollbackRetaining; end; With Best Regards. Vishal
Re: [firebird-support] Rolling back Transaction Doesn't Work with TpFIB Components
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 TpFIBDataset with Firebird database. I have already set TpFIBDataset's 'AutoCommit' property to 'False', then also when I execute below statement in the try..finally block and rollback the transaction data still get posted. Could anyone help ? Here is where you need to go: http://www.devrace.com/en/support/forum/ The question is off-topic here, sorry. ^heLen^ (List Moderator)
Odp: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)
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 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 size4096 ODS version11.2 Oldest transaction119622 Oldest active1072065 Oldest snapshot1072058 Next transaction1072195 Bumped transaction1 Sequence number0 Next attachment ID275823 Implementation ID24 Shadow count0 Page buffers0 Next header page0 Database dialect3 Creation dateFeb 19, 2013 0:09:08 Attributesforce write Variable header data: Sweep interval:2 *END* and here is the gstat everything else: gstat version LI-V2.5.2.26508 Firebird 2.5 Database customer Database header page information: Flags0 Checksum12345 Generation1175182 Page size4096 ODS version11.2 Oldest transaction119622 Oldest active1072065 Oldest snapshot1072058 Next transaction1072193 Bumped transaction1 Sequence number0 Next attachment ID275822 Implementation ID24 Shadow count0 Page buffers0 Next header page0 Database dialect3 Creation dateFeb 19, 2013 0:09:08 Attributesforce write Variable header data: Sweep interval:2 *END* Database file sequence: File customer is the only file Firebird/linux AMD64 (access method), version LI-V2.5.2.26508 Firebird 2.5 Firebird/linux AMD64 (remote server), version LI-V2.5.2.26508 Firebird 2.5/tcp (lserver)/P12 Firebird/linux AMD64 (remote interface), version LI-V2.5.2.26508 Firebird 2.5/tcp (lserver)/P12 on disk structure version 11.2 Analyzing database pages ... CUSTOMERS (128) Primary pointer page: 183, Index root page: 184 Average record length: 340.17, total records: 70105 Average version length: 26.60, total versions: 5, max versions: 2 Data pages: 6626, data page slots: 6646, average fill: 94% Fill distribution: 0 - 19% = 1 20 - 39% = 8 40 - 59% = 14 60 - 79% = 16 80 - 99% = 6587 Index FNAME (2) Depth: 2, leaf buckets: 135, nodes: 70109 Average data length: 0.51, total dup: 57228, max dup: 584 Fill distribution: 0 - 19% = 0 20 - 39% = 1 40 - 59% = 54 60 - 79% = 40 80 - 99% = 40 Index FULLNAME (6) Depth: 3, leaf buckets: 330, nodes: 70105 Average data length: 4.83, total dup: 20467, max dup: 18169 Fill distribution: 0 - 19% = 0 20 - 39% = 133 40 - 59% = 21 60 - 79% = 173 80 - 99% = 3 Index HOME (3) Depth: 2, leaf buckets: 226, nodes: 70108 Average data length: 2.61, total dup: 9196, max dup: 2392 Fill distribution: 0 - 19% = 0 20 - 39% = 2 40 - 59% = 101 60 - 79% = 86 80 - 99% = 37 Index LNAME (0) Depth: 2, leaf buckets: 154, nodes: 70117 Average data length: 1.08, total dup: 46986, max dup: 758 Fill distribution: 0 - 19% = 1 20 - 39% = 1 40 - 59% = 74 60 - 79% = 15 80 - 99% = 63 Index NEWID (4) Depth: 2, leaf buckets: 121, nodes: 70105 Average data length: 1.04, total dup: 2, max dup: 1 Fill distribution: 0 - 19% = 0 20 - 39% = 0 40 - 59% = 30 60 - 79% = 13 80 - 99% = 78 Index OFFICEPHONE (5) Depth: 2, leaf buckets: 102, nodes: 70105 Average data length: 0.20, total dup: 67213, max dup: 38383 Fill distribution: 0 - 19% = 0 20 - 39% = 1 40 - 59% = 32 60 - 79% = 17 80 - 99% = 52 Index RDB$PRIMARY7 (1) Depth: 3, leaf buckets: 346, nodes: 70117 Average data length: 7.64, total dup: 11, max dup: 3 Fill distribution: 0 - 19% = 0 20 - 39% = 9 40 - 59% = 171 60 - 79% = 16 80 - 99% = 150 INVOICES (132) Primary pointer page: 191, Index root page: 192 Average record length: 27.41, total records: 27 Average version length: 0.00, total versions: 0, max versions: 0 Data pages: 2, data page slots: 19, average fill: 16% Fill distribution: 0 - 19% = 1 20 - 39% = 1 40 - 59% = 0 60 - 79% = 0 80 - 99% = 0
Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)
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 Firebird-2.1-ErrorCodes.pdf 09/29/2014 01:06 PM 1,159,676 Firebird-2.5-LangRef-Update.pdf 09/29/2014 01:06 PM 245,583 Firebird-2.5-QuickStart.pdf 09/29/2014 01:00 PM10,467,361 Firebird-2.5.3.26778-0_Win32.zip 09/29/2014 01:01 PM12,259,685 Firebird-2.5.3.26778-0_x64.zip 09/29/2014 01:00 PM 6,973,448 Firebird-2.5.3.26778_0_Win32.exe 09/29/2014 12:58 PM10,282,876 Firebird-2.5.3.26778_0_x64.exe 09/29/2014 01:14 PM85,664 Firebird-fbmgr.pdf 09/29/2014 01:16 PM71,972 Firebird-File-Metadata-Security.pdf 09/29/2014 01:12 PM 133,557 Firebird-gbak.pdf 09/29/2014 01:15 PM90,111 Firebird-Generator-Guide.pdf 09/29/2014 01:13 PM 133,621 Firebird-gfix.pdf 09/29/2014 01:11 PM89,144 Firebird-gsec.pdf 09/29/2014 01:14 PM47,968 Firebird-gsplit.pdf 09/29/2014 01:13 PM90,958 Firebird-gstat.pdf 09/29/2014 01:11 PM 225,636 Firebird-isql.pdf 09/29/2014 01:12 PM 102,220 Firebird-nbackup.pdf 09/29/2014 01:15 PM 309,643 Firebird-Null-Guide.pdf 09/29/2014 01:14 PM39,907 Firebird-on-Ubuntu.pdf 09/29/2014 01:13 PM56,914 Firebird-shell-scripts.pdf 09/29/2014 01:15 PM 109,705 MSSQL-to-Firebird.pdf 09/29/2014 01:16 PM 195,585 Using-Firebird_(wip).pdf 22 File(s) 43,276,951 bytes 2 Dir(s) 697,431,232,512 bytes free C:\Firebirdgstat 192.168.1.252:/bfl/smtbdb/customer 'gstat' is not recognized as an internal or external command, operable program or batch file. gstat is not a separate download but included in your Firebird installation, be it in the ZIP distribution or the installer. So, check out the Firebird\bin directory. But this won't help you much, because gstat does not work over a regular database connection, but access the database at physical level, so you have to run that locally from your Linux machine. It has been 20+ years since I have done much with Unix. If you can tell me the directory Firebird is installed in on Linux, I will run the gstat on the Linux server. Otherwise, it will take me a while to locate it which I will start now. Don't know, but I guess fbstat as mentioned in your 2 years old thread ;-): http://comments.gmane.org/gmane.comp.db.firebird.user/7145 Regards, Thomas Thanks, Jack C:\Firebird On 6/11/2015 9:13 AM, 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support] wrote: 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 C:\backups\Buford\Thursday\customer.bak and the restore is: C:\program files\firebird\firebird_2_5\bin\gbak -R -v -user SYSDBA -pas masterkey C:\backups\Buford\Thursday\customer.bak localhost:c:\temp\customer What is the result of gstat -h on the production database? Thomas Jack On 6/11/2015 9:01 AM, 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support] 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. 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 Windows because of other software we run. So, to back up the databases, we put the backups on a Windows 7 computer, blandly assuming it is just a file that can be restored by the same program that backed it up, gbak on Windows 7. You mean a physical file copy from Linux to Windows while the database is in use? We had the same problem two years ago, and it never got resolved, it just disappeared, so we assumed we had done something wrong and were no longer doing whatever that was. And you don't call a different gbak version by accident, e.g. due to a set PATH environment variable etc.? Regards, Thomas Jack On 6/11/2015 3:02 AM, Thomas Steinmaurer t...@iblogmanager.com [firebird-support] wrote: 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 preserve data integrity gbak: ERROR: table/procedure
Re: Odp: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)
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. Now we find it is virtually worthless unless we can restore a database it has backed up. Unless we can get this problem whipped such that the backups are usable, or find another way to back them up, there is no reason we should be using Firebird. That is our concern. There is apparently another backup program, nbackup, that we will try but at this point we are leery of anything other than a professional backup/restore capability for Firebird. Hopefully, someone will come up with either a fix for this problem or a different way we should be doing backups. Thanks again for your suggestion, Jack On 6/11/2015 10:46 AM, 'liviusliv...@poczta.onet.pl' liviusliv...@poczta.onet.pl [firebird-support] wrote: 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 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 size4096 ODS version11.2 Oldest transaction119622 Oldest active1072065 Oldest snapshot1072058 Next transaction1072195 Bumped transaction1 Sequence number0 Next attachment ID275823 Implementation ID24 Shadow count0 Page buffers0 Next header page0 Database dialect3 Creation dateFeb 19, 2013 0:09:08 Attributesforce write Variable header data: Sweep interval:2 *END* and here is the gstat everything else: gstat version LI-V2.5.2.26508 Firebird 2.5 Database customer Database header page information: Flags0 Checksum12345 Generation1175182 Page size4096 ODS version11.2 Oldest transaction119622 Oldest active1072065 Oldest snapshot1072058 Next transaction1072193 Bumped transaction1 Sequence number0 Next attachment ID275822 Implementation ID24 Shadow count0 Page buffers0 Next header page0 Database dialect3 Creation dateFeb 19, 2013 0:09:08 Attributesforce write Variable header data: Sweep interval:2 *END* Database file sequence: File customer is the only file Firebird/linux AMD64 (access method), version LI-V2.5.2.26508 Firebird 2.5 Firebird/linux AMD64 (remote server), version LI-V2.5.2.26508 Firebird 2.5/tcp (lserver)/P12 Firebird/linux AMD64 (remote interface), version LI-V2.5.2.26508 Firebird 2.5/tcp (lserver)/P12 on disk structure version 11.2 Analyzing database pages ... CUSTOMERS (128) Primary pointer page: 183, Index root page: 184 Average record length: 340.17, total records: 70105 Average version length: 26.60, total versions: 5, max versions: 2 Data pages: 6626, data page slots: 6646, average fill: 94% Fill distribution: 0 - 19% = 1 20 - 39% = 8 40 - 59% = 14 60 - 79% = 16 80 - 99% = 6587 Index FNAME (2) Depth: 2, leaf buckets: 135, nodes: 70109 Average data length: 0.51, total dup: 57228, max dup: 584 Fill distribution: 0 - 19% = 0 20 - 39% = 1 40 - 59% = 54 60 - 79% = 40 80 - 99% = 40 Index FULLNAME (6) Depth: 3, leaf buckets: 330, nodes: 70105 Average data length: 4.83, total dup: 20467, max dup: 18169 Fill distribution: 0 - 19% = 0 20 - 39% = 133 40 - 59% = 21 60 - 79% = 173 80 - 99% = 3 Index HOME (3) Depth: 2, leaf buckets: 226, nodes: 70108 Average data length: 2.61, total dup: 9196, max dup: 2392 Fill distribution: 0 - 19% = 0 20 - 39% = 2 40 - 59% = 101 60 - 79% = 86 80 - 99% = 37 Index LNAME (0) Depth: 2, leaf buckets: 154, nodes: 70117 Average data length: 1.08, total dup: 46986, max dup: 758 Fill distribution: 0 - 19% = 1 20 - 39% = 1 40 - 59% = 74 60 - 79% = 15 80 - 99% = 63 Index NEWID (4) Depth: 2, leaf buckets: 121, nodes: 70105 Average data length: 1.04, total dup: 2, max dup: 1 Fill distribution: 0 - 19% = 0 20 - 39% = 0 40 - 59% = 30 60 - 79% = 13 80 -
Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)
Here is the gstat - h: Database customer Database header page information: Flags0 Checksum12345 Generation1175184 Page size4096 ODS version11.2 Oldest transaction119622 Oldest active1072065 Oldest snapshot1072058 Next transaction1072195 Bumped transaction1 Sequence number0 Next attachment ID275823 Implementation ID24 Shadow count0 Page buffers0 Next header page0 Database dialect3 Creation dateFeb 19, 2013 0:09:08 Attributesforce write Variable header data: Sweep interval:2 *END* and here is the gstat everything else: gstat version LI-V2.5.2.26508 Firebird 2.5 Database customer Database header page information: Flags0 Checksum12345 Generation1175182 Page size4096 ODS version11.2 Oldest transaction119622 Oldest active1072065 Oldest snapshot1072058 Next transaction1072193 Bumped transaction1 Sequence number0 Next attachment ID275822 Implementation ID24 Shadow count0 Page buffers0 Next header page0 Database dialect3 Creation dateFeb 19, 2013 0:09:08 Attributesforce write Variable header data: Sweep interval:2 *END* Database file sequence: File customer is the only file Firebird/linux AMD64 (access method), version LI-V2.5.2.26508 Firebird 2.5 Firebird/linux AMD64 (remote server), version LI-V2.5.2.26508 Firebird 2.5/tcp (lserver)/P12 Firebird/linux AMD64 (remote interface), version LI-V2.5.2.26508 Firebird 2.5/tcp (lserver)/P12 on disk structure version 11.2 Analyzing database pages ... CUSTOMERS (128) Primary pointer page: 183, Index root page: 184 Average record length: 340.17, total records: 70105 Average version length: 26.60, total versions: 5, max versions: 2 Data pages: 6626, data page slots: 6646, average fill: 94% Fill distribution: 0 - 19% = 1 20 - 39% = 8 40 - 59% = 14 60 - 79% = 16 80 - 99% = 6587 Index FNAME (2) Depth: 2, leaf buckets: 135, nodes: 70109 Average data length: 0.51, total dup: 57228, max dup: 584 Fill distribution: 0 - 19% = 0 20 - 39% = 1 40 - 59% = 54 60 - 79% = 40 80 - 99% = 40 Index FULLNAME (6) Depth: 3, leaf buckets: 330, nodes: 70105 Average data length: 4.83, total dup: 20467, max dup: 18169 Fill distribution: 0 - 19% = 0 20 - 39% = 133 40 - 59% = 21 60 - 79% = 173 80 - 99% = 3 Index HOME (3) Depth: 2, leaf buckets: 226, nodes: 70108 Average data length: 2.61, total dup: 9196, max dup: 2392 Fill distribution: 0 - 19% = 0 20 - 39% = 2 40 - 59% = 101 60 - 79% = 86 80 - 99% = 37 Index LNAME (0) Depth: 2, leaf buckets: 154, nodes: 70117 Average data length: 1.08, total dup: 46986, max dup: 758 Fill distribution: 0 - 19% = 1 20 - 39% = 1 40 - 59% = 74 60 - 79% = 15 80 - 99% = 63 Index NEWID (4) Depth: 2, leaf buckets: 121, nodes: 70105 Average data length: 1.04, total dup: 2, max dup: 1 Fill distribution: 0 - 19% = 0 20 - 39% = 0 40 - 59% = 30 60 - 79% = 13 80 - 99% = 78 Index OFFICEPHONE (5) Depth: 2, leaf buckets: 102, nodes: 70105 Average data length: 0.20, total dup: 67213, max dup: 38383 Fill distribution: 0 - 19% = 0 20 - 39% = 1 40 - 59% = 32 60 - 79% = 17 80 - 99% = 52 Index RDB$PRIMARY7 (1) Depth: 3, leaf buckets: 346, nodes: 70117 Average data length: 7.64, total dup: 11, max dup: 3 Fill distribution: 0 - 19% = 0 20 - 39% = 9 40 - 59% = 171 60 - 79% = 16 80 - 99% = 150 INVOICES (132) Primary pointer page: 191, Index root page: 192 Average record length: 27.41, total records: 27 Average version length: 0.00, total versions: 0, max versions: 0 Data pages: 2, data page slots: 19, average fill: 16% Fill distribution: 0 - 19% = 1 20 - 39% = 1 40 - 59% = 0 60 - 79% = 0 80 - 99% = 0 Index RDB$PRIMARY11 (0) Depth: 2, leaf buckets: 1, nodes: 27 Average data length: 8.56, total dup: 0, max dup: 0 Fill distribution: 0 - 19% = 1 20 - 39% = 0 40 - 59% = 0 60 - 79% = 0 80 - 99% = 0 ON_ORDER (133) Primary pointer page: 194, Index root page: 195 Average record length: 510.49, total records: 503 Average version length:
Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)
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 C:\backups\Buford\Thursday\customer.bak and the restore is: C:\program files\firebird\firebird_2_5\bin\gbak -R -v -user SYSDBA -pas masterkey C:\backups\Buford\Thursday\customer.bak localhost:c:\temp\customer Jack On 6/11/2015 9:01 AM, 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support] 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. 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 Windows because of other software we run. So, to back up the databases, we put the backups on a Windows 7 computer, blandly assuming it is just a file that can be restored by the same program that backed it up, gbak on Windows 7. You mean a physical file copy from Linux to Windows while the database is in use? We had the same problem two years ago, and it never got resolved, it just disappeared, so we assumed we had done something wrong and were no longer doing whatever that was. And you don't call a different gbak version by accident, e.g. due to a set PATH environment variable etc.? Regards, Thomas Jack On 6/11/2015 3:02 AM, Thomas Steinmaurer t...@iblogmanager.com [firebird-support] wrote: 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 preserve data integrity gbak: ERROR: table/procedure has non-SQL security class defined gbak:Exiting before completion due to errors We have no procedures defined in or for our database. It appears gbak has restored the database except for something at the end. The database is working correctly every day. Is this copy of the database backup toast? Should we be using a different backup tool like nbackup? Can we use Interbase gbak to recreate the database? We are backing up our databases on Windows 7 using 2.52 Superserver. The databases are on a Linux Mint server. I'm confused. The databases are hosted on Linux (InterBase or Firebird?) but you are running a backup from Win7? 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/ Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc. However, when we are trying to do the restore, we are restoring it to a directory on Windows 7 because we don't trust restoring it over the currently running database. So, the backup and restore are both on the same Windows 7 computer using the same 2.52 Superserver. We need some data from the database from yesterday, so we just wanted to restore that long enough to pull the data. The table we want, ON_ORDER, appears to have been restored but we cannot open the restored database to access it. Help? Posted by: Jack Mason jackma...@mindspring.com ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links -- Our Constitution was made only for a moral and religious people. It is wholly inadequate to the government of any other. -- John Adams, Oct. 11, 1798 Where there is no vision, the people perish.. Prov 29:18 -- Our Constitution was made only for a moral and religious people. It is wholly inadequate to the government of any other. -- John Adams, Oct. 11, 1798 Where there is no vision, the people perish.. Prov 29:18
Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)
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 Windows because of other software we run. So, to back up the databases, we put the backups on a Windows 7 computer, blandly assuming it is just a file that can be restored by the same program that backed it up, gbak on Windows 7. You mean a physical file copy from Linux to Windows while the database is in use? We had the same problem two years ago, and it never got resolved, it just disappeared, so we assumed we had done something wrong and were no longer doing whatever that was. And you don't call a different gbak version by accident, e.g. due to a set PATH environment variable etc.? Regards, Thomas Jack On 6/11/2015 3:02 AM, Thomas Steinmaurer t...@iblogmanager.com [firebird-support] wrote: 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 preserve data integrity gbak: ERROR: table/procedure has non-SQL security class defined gbak:Exiting before completion due to errors We have no procedures defined in or for our database. It appears gbak has restored the database except for something at the end. The database is working correctly every day. Is this copy of the database backup toast? Should we be using a different backup tool like nbackup? Can we use Interbase gbak to recreate the database? We are backing up our databases on Windows 7 using 2.52 Superserver. The databases are on a Linux Mint server. I'm confused. The databases are hosted on Linux (InterBase or Firebird?) but you are running a backup from Win7? 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/ Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc. However, when we are trying to do the restore, we are restoring it to a directory on Windows 7 because we don't trust restoring it over the currently running database. So, the backup and restore are both on the same Windows 7 computer using the same 2.52 Superserver. We need some data from the database from yesterday, so we just wanted to restore that long enough to pull the data. The table we want, ON_ORDER, appears to have been restored but we cannot open the restored database to access it. Help? Posted by: Jack Mason jackma...@mindspring.com ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links -- Our Constitution was made only for a moral and religious people. It is wholly inadequate to the government of any other. -- John Adams, Oct. 11, 1798 Where there is no vision, the people perish.. Prov 29:18
Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)
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 Windows because of other software we run. So, to back up the databases, we put the backups on a Windows 7 computer, blandly assuming it is just a file that can be restored by the same program that backed it up, gbak on Windows 7. We had the same problem two years ago, and it never got resolved, it just disappeared, so we assumed we had done something wrong and were no longer doing whatever that was. Jack On 6/11/2015 3:02 AM, Thomas Steinmaurer t...@iblogmanager.com [firebird-support] wrote: 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 preserve data integrity gbak: ERROR: table/procedure has non-SQL security class defined gbak:Exiting before completion due to errors We have no procedures defined in or for our database. It appears gbak has restored the database except for something at the end. The database is working correctly every day. Is this copy of the database backup toast? Should we be using a different backup tool like nbackup? Can we use Interbase gbak to recreate the database? We are backing up our databases on Windows 7 using 2.52 Superserver. The databases are on a Linux Mint server. I'm confused. The databases are hosted on Linux (InterBase or Firebird?) but you are running a backup from Win7? 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/ Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc. However, when we are trying to do the restore, we are restoring it to a directory on Windows 7 because we don't trust restoring it over the currently running database. So, the backup and restore are both on the same Windows 7 computer using the same 2.52 Superserver. We need some data from the database from yesterday, so we just wanted to restore that long enough to pull the data. The table we want, ON_ORDER, appears to have been restored but we cannot open the restored database to access it. Help? Posted by: Jack Mason jackma...@mindspring.com ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links -- Our Constitution was made only for a moral and religious people. It is wholly inadequate to the government of any other. -- John Adams, Oct. 11, 1798 Where there is no vision, the people perish.. Prov 29:18
Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)
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 Firebird-2.1-ErrorCodes.pdf 09/29/2014 01:06 PM 1,159,676 Firebird-2.5-LangRef-Update.pdf 09/29/2014 01:06 PM 245,583 Firebird-2.5-QuickStart.pdf 09/29/2014 01:00 PM10,467,361 Firebird-2.5.3.26778-0_Win32.zip 09/29/2014 01:01 PM12,259,685 Firebird-2.5.3.26778-0_x64.zip 09/29/2014 01:00 PM 6,973,448 Firebird-2.5.3.26778_0_Win32.exe 09/29/2014 12:58 PM10,282,876 Firebird-2.5.3.26778_0_x64.exe 09/29/2014 01:14 PM85,664 Firebird-fbmgr.pdf 09/29/2014 01:16 PM71,972 Firebird-File-Metadata-Security.pdf 09/29/2014 01:12 PM 133,557 Firebird-gbak.pdf 09/29/2014 01:15 PM90,111 Firebird-Generator-Guide.pdf 09/29/2014 01:13 PM 133,621 Firebird-gfix.pdf 09/29/2014 01:11 PM89,144 Firebird-gsec.pdf 09/29/2014 01:14 PM47,968 Firebird-gsplit.pdf 09/29/2014 01:13 PM90,958 Firebird-gstat.pdf 09/29/2014 01:11 PM 225,636 Firebird-isql.pdf 09/29/2014 01:12 PM 102,220 Firebird-nbackup.pdf 09/29/2014 01:15 PM 309,643 Firebird-Null-Guide.pdf 09/29/2014 01:14 PM39,907 Firebird-on-Ubuntu.pdf 09/29/2014 01:13 PM56,914 Firebird-shell-scripts.pdf 09/29/2014 01:15 PM 109,705 MSSQL-to-Firebird.pdf 09/29/2014 01:16 PM 195,585 Using-Firebird_(wip).pdf 22 File(s) 43,276,951 bytes 2 Dir(s) 697,431,232,512 bytes free C:\Firebirdgstat 192.168.1.252:/bfl/smtbdb/customer 'gstat' is not recognized as an internal or external command, operable program or batch file. It has been 20+ years since I have done much with Unix. If you can tell me the directory Firebird is installed in on Linux, I will run the gstat on the Linux server. Otherwise, it will take me a while to locate it which I will start now. Thanks, Jack C:\Firebird On 6/11/2015 9:13 AM, 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support] wrote: 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 C:\backups\Buford\Thursday\customer.bak and the restore is: C:\program files\firebird\firebird_2_5\bin\gbak -R -v -user SYSDBA -pas masterkey C:\backups\Buford\Thursday\customer.bak localhost:c:\temp\customer What is the result of gstat -h on the production database? Thomas Jack On 6/11/2015 9:01 AM, 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support] 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. 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 Windows because of other software we run. So, to back up the databases, we put the backups on a Windows 7 computer, blandly assuming it is just a file that can be restored by the same program that backed it up, gbak on Windows 7. You mean a physical file copy from Linux to Windows while the database is in use? We had the same problem two years ago, and it never got resolved, it just disappeared, so we assumed we had done something wrong and were no longer doing whatever that was. And you don't call a different gbak version by accident, e.g. due to a set PATH environment variable etc.? Regards, Thomas Jack On 6/11/2015 3:02 AM, Thomas Steinmaurer t...@iblogmanager.com [firebird-support] wrote: 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 preserve data integrity gbak: ERROR: table/procedure has non-SQL security class defined gbak:Exiting before completion due to errors We have no procedures defined in or for our database. It appears gbak has restored the database except for something at the end. The database is working correctly every day. Is this copy of the database backup toast? Should we be using a different backup tool like nbackup? Can we use Interbase gbak to recreate the database? We are backing up our databases on Windows 7 using 2.52 Superserver. The databases are on a Linux Mint server. I'm confused. The databases are hosted on Linux (InterBase or
Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)
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 C:\backups\Buford\Thursday\customer.bak and the restore is: C:\program files\firebird\firebird_2_5\bin\gbak -R -v -user SYSDBA -pas masterkey C:\backups\Buford\Thursday\customer.bak localhost:c:\temp\customer What is the result of gstat -h on the production database? Thomas Jack On 6/11/2015 9:01 AM, 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support] 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. 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 Windows because of other software we run. So, to back up the databases, we put the backups on a Windows 7 computer, blandly assuming it is just a file that can be restored by the same program that backed it up, gbak on Windows 7. You mean a physical file copy from Linux to Windows while the database is in use? We had the same problem two years ago, and it never got resolved, it just disappeared, so we assumed we had done something wrong and were no longer doing whatever that was. And you don't call a different gbak version by accident, e.g. due to a set PATH environment variable etc.? Regards, Thomas Jack On 6/11/2015 3:02 AM, Thomas Steinmaurer t...@iblogmanager.com [firebird-support] wrote: 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 preserve data integrity gbak: ERROR: table/procedure has non-SQL security class defined gbak:Exiting before completion due to errors We have no procedures defined in or for our database. It appears gbak has restored the database except for something at the end. The database is working correctly every day. Is this copy of the database backup toast? Should we be using a different backup tool like nbackup? Can we use Interbase gbak to recreate the database? We are backing up our databases on Windows 7 using 2.52 Superserver. The databases are on a Linux Mint server. I'm confused. The databases are hosted on Linux (InterBase or Firebird?) but you are running a backup from Win7? 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/ Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc. However, when we are trying to do the restore, we are restoring it to a directory on Windows 7 because we don't trust restoring it over the currently running database. So, the backup and restore are both on the same Windows 7 computer using the same 2.52 Superserver. We need some data from the database from yesterday, so we just wanted to restore that long enough to pull the data. The table we want, ON_ORDER, appears to have been restored but we cannot open the restored database to access it. Help? Posted by: Jack Mason jackma...@mindspring.com ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links -- Our Constitution was made only for a moral and religious people. It is wholly inadequate to the government of any other. -- John Adams, Oct. 11, 1798 Where there is no vision, the people perish.. Prov 29:18 -- Our Constitution was made only for a moral and religious people. It is wholly inadequate to the government of any other. -- John Adams, Oct. 11, 1798 Where there is no vision, the people perish.. Prov 29:18
[firebird-support] Re: Why table of type key-value takes so much space on disk?
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: 533746, average fill: 88% Fill distribution: 0 - 19% = 0 20 - 39% = 0 40 - 59% = 0 60 - 79% = 30 80 - 99% = 533716 DETAILS_DATA (262) Primary pointer page: 842, Index root page: 843 Average record length: 20.19, total records: 164512578 Average version length: 0.00, total versions: 0, max versions: 0 Data pages: 2455600, data page slots: 2455600, average fill: 61% Fill distribution: 0 - 19% = 0 20 - 39% = 1 40 - 59% = 0 60 - 79% = 2455599 80 - 99% = 0 I guess this confirms your statement about record header size? FLAT_DATA record length is 213.90 which is over 10 times more than DETAILS_DATA record length 20.19. However in DETAILS_DATA we have 164512578 records which is 19.8 times more than in FLAT_DATA. Best regards.
Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)
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 restore them without getting the trigger (3) error. Since we have 5 databases, each built by Firebird two years ago from Interbase 6 backups and backed up for two years by Firebird 2.52 gbak, and totally different programs accessing the databases, it appears the corruption is/has been caused by Firebird. Yet, no one else has seen this problem? Jack On 6/11/2015 3:08 PM, liviusliv...@poczta.onet.pl [firebird-support] wrote: 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. Extract all files to different folder then your Firebird installation not only gbak.exe. Try to run gbak from there. – i suppose that icu or something else 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 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 customer.bak The application has failed to start because its side-by-side configuration is in correct. Please see the application event log or use the command-line sxstrace.e xe tool for more detail. What am I missing? I tried for 3.0, but it would not even run... likely because it needs the 3.0 server running. Jack On 6/11/2015 12:09 PM, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: Hi, no i mean go to http://www.firebirdsql.org/en/snapshot-builds/ download e.g. Windows build Firebird-2.5.5.26887 unzip it and get gbak.exe and do backup and restore with it regards, Karol Bieniaszewski 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 build of FB2.5 And extract from there gback file. Do backup with them and try to restore Regards, Karol Bieniaszewski -- Our Constitution was made only for a moral and religious people. It is wholly inadequate to the government of any other. -- John Adams, Oct. 11, 1798 Where there is no vision, the people perish.. Prov 29:18 -- Our Constitution was made only for a moral and religious people. It is wholly inadequate to the government of any other. -- John Adams, Oct. 11, 1798 Where there is no vision, the people perish.. Prov 29:18
Re: [firebird-support] Re: Firebird 2.52 gbak fails to do a restore - error trigger (3)
---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 specify a database SQL create database 'localhost:c:\temp\a.fdb'; Note, there is no error, i.e. database is created and isql have active connection SQL show version; ISQL Version: WI-V2.5.2.26540 Firebird 2.5 Server version: Cannot get server version without database connection Impossible... here shouild be present 3 lines with reports from engine, network server and network client subsystems: SQL show version; ISQL Version: WI-V2.5.5.26858 Firebird 2.5 Server version: Firebird/x86/Windows NT (access method), version WI-V2.5.5.26885 Firebird 2.5 Firebird/x86/Windows NT (remote server), version WI-V2.5.5.26885 Firebird 2.5/XNet (WIN7X64)/P12 Firebird/x86/Windows NT (remote interface), version WI-V2.5.5.26858 Firebird 2.5/XNet (WIN7X64)/P12 on disk structure version 11.2 Instead, we have message about absent connection ! SQL connect 'localhost:c:\temp\a.fdb'; Commit current transaction (y/n)?y Committing. It is expected - isql have active connection and active transaction and ask to commit it before disconnect. Database: 'localhost:c:\temp\a.fdb', User: sysdba SQL show version; ISQL Version: WI-V2.5.2.26540 Firebird 2.5 Server version: Cannot get server version without database connection Same error... Could you run script below ? isql -user sysdba -pass masterkey create database 'localhost:c:\temp\a.fdb'; show version; show database; exit; gstat -h c:\temp\a.fdb Regards, Vlad
Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)
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 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 restore them without getting the trigger (3) error. Since we have 5 databases, each built by Firebird two years ago from Interbase 6 backups and backed up for two years by Firebird 2.52 gbak, and totally different programs accessing the databases, it appears the corruption is/has been caused by Firebird. Yet, no one else has seen this problem? Jack On 6/11/2015 3:08 PM, liviusliv...@poczta.onet.pl [firebird-support] wrote: 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. Extract all files to different folder then your Firebird installation not only gbak.exe. Try to run gbak from there. – i suppose that icu or something else 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 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 customer.bak The application has failed to start because its side-by-side configuration is in correct. Please see the application event log or use the command-line sxstrace.e xe tool for more detail. What am I missing? I tried for 3.0, but it would not even run... likely because it needs the 3.0 server running. Jack On 6/11/2015 12:09 PM, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: Hi, no i mean go to http://www.firebirdsql.org/en/snapshot-builds/ download e.g. Windows build Firebird-2.5.5.26887 unzip it and get gbak.exe and do backup and restore with it regards, Karol Bieniaszewski 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 build of FB2.5 And extract from there gback file. Do backup with them and try to restore Regards, Karol Bieniaszewski -- Our Constitution was made only for a moral and religious people. It is wholly inadequate to the government of any other. -- John Adams, Oct. 11, 1798 Where there is no vision, the people perish.. Prov 29:18 -- Our Constitution was made only for a moral and religious people. It is wholly inadequate to the government of any other. -- John Adams, Oct. 11, 1798 Where there is no vision, the people perish.. Prov 29:18
Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)
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 metadata source and creating the database in firebird from metadata source. In that process I found some problems that let me correct the source database. I think that you would try to extract metadata source, create the database in firebird from that source, and then pump data from source to destination database. If I were you, I would have done this when moving from Interbase 6 to Firebird. I did it and have not had problems. In the process of database creation in Firebird from metadata, may be you will find the problem in your source database. Good luck Jesus Angel Garcia Zarco Cointec
Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)
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 with Interbase gbak and restoring with Firebird gbak was the proper migration procedure, but that is apparently not true? Jack On 6/11/2015 4:50 PM, Alexey Kovyazin a...@ib-aid.com [firebird-support] wrote: Hello Jack, 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. It can be an answer - when you perform backup/restore, complied codes of stored procedures, triggers, checks, etc are not upgraded to the new BLR version, so you still have old BLR (in IB6 format) inside. However, any change in source code will lead re-complication of the database object, and it can fail (for number of reasons, like ambiguous fields references) - and at restore step this will be revealed and various problems can occur. Firebird 2.52 will back them up, but will not restore them without getting the trigger (3) error. Since we have 5 databases, each built by Firebird two years ago from Interbase 6 backups and backed up for two years by Firebird 2.52 gbak, and totally different programs accessing the databases, it appears the corruption is/has been caused by Firebird. Well, your problem does not look like something very simple. I think you should think about proper migration procedure (to make database 100% compatible with Firebird 2.5). Regards, Alexey Kovyazin IBSurgeon -- Our Constitution was made only for a moral and religious people. It is wholly inadequate to the government of any other. -- John Adams, Oct. 11, 1798 Where there is no vision, the people perish.. Prov 29:18
Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)
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 (marginally but not advisedly) at Firebird 1.5. We are talking 15 years of Firebird development here, 5 major releases and thus, 5 ODS changes, to arrive at 2.5.something. Helen
Re: Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)
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 Bieniaszewski
Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)
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 preserve data integrity gbak: ERROR:table/procedure has non-SQL security class defined gbak:Exiting before completion due to errors We have no procedures defined in or for our database. It appears gbak has restored the database except for something at the end. The database is working correctly every day. Is this copy of the database backup toast? Should we be using a different backup tool like nbackup? Can we use Interbase gbak to recreate the database? We are backing up our databases on Windows 7 using 2.52 Superserver. The databases are on a Linux Mint server. I'm confused. The databases are hosted on Linux (InterBase or Firebird?) but you are running a backup from Win7? 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/ Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc. However, when we are trying to do the restore, we are restoring it to a directory on Windows 7 because we don't trust restoring it over the currently running database. So, the backup and restore are both on the same Windows 7 computer using the same 2.52 Superserver. We need some data from the database from yesterday, so we just wanted to restore that long enough to pull the data. The table we want, ON_ORDER, appears to have been restored but we cannot open the restored database to access it. Help? Posted by: Jack Mason jackma...@mindspring.com ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links
Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)
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 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 metadata source and creating the database in firebird from metadata source. In that process I found some problems that let me correct the source database. I think that you would try to extract metadata source, create the database in firebird from that source, and then pump data from source to destination database. If I were you, I would have done this when moving from Interbase 6 to Firebird. I did it and have not had problems. In the process of database creation in Firebird from metadata, may be you will find the problem in your source database. Good luck Jesus Angel Garcia Zarco Cointec
RE: [firebird-support] Re: Firebird 2.5.4 - CentOS - mon$remote_address 0.0.0.0
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 : firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Envoyé : mercredi 10 juin 2015 08:32 À : firebird-support@yahoogroups.com Objet : Re: [firebird-support] Re: Firebird 2.5.4 - CentOS - mon$remote_address 0.0.0.0 Hello , So Dmitry suggested it , we have disabled IPV6 on our server CentOS 7 (Firebird 2.5.4 Classic server (I forgot to mention it in my first mail)). By following the centos FAQ : http://wiki.centos.org/FAQ/CentOS7#head-8984faf811faccca74c7bcdd74de7467f2fcd8ee Rebooting the server. But even after this modification the mon$remote_address is still giving 0.0.0.0 Any ideas are welcome. Is this a real remote connection from a remote client or an attachment locally on the server? -- With regards, Thomas Steinmaurer http://www.upscene.com Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc. Marianne De : firebird-support@yahoogroups.commailto:firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Envoyé : lundi 8 juin 2015 12:47 À : firebird-support@yahoogroups.commailto:firebird-support@yahoogroups.com Objet : [firebird-support] Re: Firebird 2.5.4 - CentOS - mon$remote_address 0.0.0.0 08.06.2015 10:02, Marianne Castel wrote: We were working with Firebird 2.5.2 on Debian . At that time, in the monitoring table MON$ATTACHEMENTS I could see the IP address of the client connected to a database. Now our administrators have decided to work with CentOS and the last available packages thus Firebird 2.5.4, and now in the databases on that server in the table MON$ATTACHEMENTS table the field mon$remote_address always contains : 0.0.0.0 May be that the server is different too (network connection?) … Any idea why the IP address is no more reported ? How could we have the IP address again in the monitoring table ? Interesting. One possible explanation can be found here: http://stackoverflow.com/questions/17220006/in-what-conditions-getpeername-returns-ipport-0-0-0-00 Firebird 2.x does not support IPv6 and always listens on a AF_INET (i.e. v4) socket, but maybe it could be related somehow. Have you tried to disable IPv6 on the new server box? Dmitry
Re: [firebird-support] Re: Firebird 2.5.4 - CentOS - mon$remote_address 0.0.0.0
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 use at least the Firebird 2.1 client library? -- With regards, Thomas Steinmaurer http://www.upscene.com/ Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc. *De :*firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] *Envoyé :* mercredi 10 juin 2015 08:32 *À :* firebird-support@yahoogroups.com *Objet :* Re: [firebird-support] Re: Firebird 2.5.4 - CentOS - mon$remote_address 0.0.0.0 Hello , So Dmitry suggested it , we have disabled IPV6 on our server CentOS 7 (Firebird 2.5.4 Classic server (I forgot to mention it in my first mail)). By following the centos FAQ : http://wiki.centos.org/FAQ/CentOS7#head-8984faf811faccca74c7bcdd74de7467f2fcd8ee Rebooting the server. But even after this modification the mon$remote_address is still giving 0.0.0.0 Any ideas are welcome. Is this a real remote connection from a remote client or an attachment locally on the server? -- With regards, Thomas Steinmaurer http://www.upscene.com Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc. Marianne De :firebird-support@yahoogroups.com mailto:firebird-support@yahoogroups.com[mailto:firebird-support@yahoogroups.com] Envoyé : lundi 8 juin 2015 12:47 À :firebird-support@yahoogroups.com mailto:firebird-support@yahoogroups.com Objet : [firebird-support] Re: Firebird 2.5.4 - CentOS - mon$remote_address 0.0.0.0 08.06.2015 10:02, Marianne Castel wrote: We were working with Firebird 2.5.2 on Debian .At that time, in the monitoring table MON$ATTACHEMENTS I could see the IP address of the client connected to a database. Now our administrators have decided to work with CentOS and the last available packages thus Firebird 2.5.4, and now in the databases on that server in the table MON$ATTACHEMENTS table the field mon$remote_address always contains : 0.0.0.0 May be that the server is different too (network connection?) … Any idea why the IP address is no more reported ? How could we have the IP address again in the monitoring table ? Interesting. One possible explanation can be found here: http://stackoverflow.com/questions/17220006/in-what-conditions-getpeername-returns-ipport-0-0-0-00 Firebird 2.x does not support IPv6 and always listens on a AF_INET (i.e. v4) socket, but maybe it could be related somehow.Have you tried to disable IPv6 on the new server box? Dmitry
RE: [firebird-support] Re: Firebird 2.5.4 - CentOS - mon$remote_address 0.0.0.0
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 juin 2015 10:10 À : firebird-support@yahoogroups.com Objet : Re: [firebird-support] Re: Firebird 2.5.4 - CentOS - mon$remote_address 0.0.0.0 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 use at least the Firebird 2.1 client library? -- With regards, Thomas Steinmaurer http://www.upscene.com/ Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc. *De :*firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] *Envoyé :* mercredi 10 juin 2015 08:32 *À :* firebird-support@yahoogroups.commailto:firebird-support@yahoogroups.com *Objet :* Re: [firebird-support] Re: Firebird 2.5.4 - CentOS - mon$remote_address 0.0.0.0 Hello , So Dmitry suggested it , we have disabled IPV6 on our server CentOS 7 (Firebird 2.5.4 Classic server (I forgot to mention it in my first mail)). By following the centos FAQ : http://wiki.centos.org/FAQ/CentOS7#head-8984faf811faccca74c7bcdd74de7467f2fcd8ee Rebooting the server. But even after this modification the mon$remote_address is still giving 0.0.0.0 Any ideas are welcome. Is this a real remote connection from a remote client or an attachment locally on the server? -- With regards, Thomas Steinmaurer http://www.upscene.com Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc. Marianne De :firebird-support@yahoogroups.com mailto:firebird-support@yahoogroups.com[mailto:firebird-support@yahoogroups.com] Envoyé : lundi 8 juin 2015 12:47 À :firebird-support@yahoogroups.com mailto:firebird-support@yahoogroups.com Objet : [firebird-support] Re: Firebird 2.5.4 - CentOS - mon$remote_address 0.0.0.0 08.06.2015 10:02, Marianne Castel wrote: We were working with Firebird 2.5.2 on Debian .At that time, in the monitoring table MON$ATTACHEMENTS I could see the IP address of the client connected to a database. Now our administrators have decided to work with CentOS and the last available packages thus Firebird 2.5.4, and now in the databases on that server in the table MON$ATTACHEMENTS table the field mon$remote_address always contains : 0.0.0.0 May be that the server is different too (network connection?) … Any idea why the IP address is no more reported ? How could we have the IP address again in the monitoring table ? Interesting. One possible explanation can be found here: http://stackoverflow.com/questions/17220006/in-what-conditions-getpeername-returns-ipport-0-0-0-00 Firebird 2.x does not support IPv6 and always listens on a AF_INET (i.e. v4) socket, but maybe it could be related somehow.Have you tried to disable IPv6 on the new server box? Dmitry
Re: Odp: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)
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 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* system using *any* tools is pointless if you don't do regular test restores. -- Tim Ward -- Our Constitution was made only for a moral and religious people. It is wholly inadequate to the government of any other. -- John Adams, Oct. 11, 1798 Where there is no vision, the people perish.. Prov 29:18
Re: Odp: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)
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* system using *any* tools is pointless if you don't do regular test restores. -- Tim Ward
Odp: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)
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] firebird-support@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. 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* system using *any* tools is pointless if you don't do regular test restores. -- Tim Ward
[firebird-support] Re: Firebird 2.52 gbak fails to do a restore - error trigger (3)
---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 prompt (at firebird\bin folder) and show us results: isql -user sysdba -pass masterkey create database 'localhost:c:\temp\a.fdb'; show version; drop database; exit; Regards, Vlad
Re: Odp: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)
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 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] firebird-support@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. 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* system using *any* tools is pointless if you don't do regular test restores. -- Tim Ward -- Our Constitution was made only for a moral and religious people. It is wholly inadequate to the government of any other. -- John Adams, Oct. 11, 1798 Where there is no vision, the people perish.. Prov 29:18 [Non-text portions of this message have been removed]
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 customer.bak The application has failed to start because its side-by-side configuration is in correct. Please see the application event log or use the command-line sxstrace.e xe tool for more detail. What am I missing? I tried for 3.0, but it would not even run... likely because it needs the 3.0 server running. Jack On 6/11/2015 12:09 PM, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: Hi, no i mean go to http://www.firebirdsql.org/en/snapshot-builds/ download e.g. Windows build Firebird-2.5.5.26887 unzip it and get gbak.exe and do backup and restore with it regards, Karol Bieniaszewski 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 build of FB2.5 And extract from there gback file. Do backup with them and try to restore Regards, Karol Bieniaszewski -- Our Constitution was made only for a moral and religious people. It is wholly inadequate to the government of any other. -- John Adams, Oct. 11, 1798 Where there is no vision, the people perish.. Prov 29:18
Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)
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. Extract all files to different folder then your Firebird installation not only gbak.exe. Try to run gbak from there. – i suppose that icu or something else 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 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 customer.bak The application has failed to start because its side-by-side configuration is in correct. Please see the application event log or use the command-line sxstrace.e xe tool for more detail. What am I missing? I tried for 3.0, but it would not even run... likely because it needs the 3.0 server running. Jack On 6/11/2015 12:09 PM, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: Hi, no i mean go to http://www.firebirdsql.org/en/snapshot-builds/ download e.g. Windows build Firebird-2.5.5.26887 unzip it and get gbak.exe and do backup and restore with it regards, Karol Bieniaszewski 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 build of FB2.5 And extract from there gback file. Do backup with them and try to restore Regards, Karol Bieniaszewski -- Our Constitution was made only for a moral and religious people. It is wholly inadequate to the government of any other. -- John Adams, Oct. 11, 1798 Where there is no vision, the people perish.. Prov 29:18
[firebird-support] Changing process priority
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.
Re: [firebird-support] Firebird 2.52 gbak fails to do a restore - error trigger (3)
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] wrote: 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. Extract all files to different folder then your Firebird installation not only gbak.exe. Try to run gbak from there. – i suppose that icu or something else 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 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 customer.bak The application has failed to start because its side-by-side configuration is in correct. Please see the application event log or use the command-line sxstrace.e xe tool for more detail. What am I missing? I tried for 3.0, but it would not even run... likely because it needs the 3.0 server running. Jack On 6/11/2015 12:09 PM, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: Hi, no i mean go to http://www.firebirdsql.org/en/snapshot-builds/ download e.g. Windows build Firebird-2.5.5.26887 unzip it and get gbak.exe and do backup and restore with it regards, Karol Bieniaszewski 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 build of FB2.5 And extract from there gback file. Do backup with them and try to restore Regards, Karol Bieniaszewski -- Our Constitution was made only for a moral and religious people. It is wholly inadequate to the government of any other. -- John Adams, Oct. 11, 1798 Where there is no vision, the people perish.. Prov 29:18 -- Our Constitution was made only for a moral and religious people. It is wholly inadequate to the government of any other. -- John Adams, Oct. 11, 1798 Where there is no vision, the people perish.. Prov 29:18
