Re: [firebird-support] Re: Nagle Algorithm
Latestest stable version. Something intesting about the benchmark article, what version an what OS, and a copy of the config.. Sent from Yahoo Mail for iPhone On Wednesday, December 4, 2019, 6:12 AM, 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support] wrote: You didn't say what version of Firebird you are using. If it is not 3.x, you can expect very bad performance transferring data over WAN. FB 3 implemented changes in the wire protocol making things much faster in high latency networks. The only remaining "problem" is if you need to transfer blobs (it will be slow). For more info: https://www.firebirdnews.org/firebird-3-protocol-benchmark/ []s Carlos http://www.firebirdnews.org/migration-guide-to-firebird-3/ nycfs> I was able to verify that NoNaggle appears to be marking the nycfs> packets as push to avoid the Nagle Algorithm delays. The nycfs> packets show up with push flag set from client and server. nycfs> I am still very disappointed with the performance of the FB clients. nycfs> nycfs> An application that normally takes 25 seconds to open on LAN nycfs> is taking 6 minutes to load on WAN. nycfs> nycfs> The actual data transferred is less than 11 Mbit. nycfs> nycfs> The bandwidth is not an issue, 100Mbps/100Mbps up/down. nycfs> nycfs> Point to Point Bandwidth tests show 95 Mbps with 7.6 ms round trip. nycfs> nycfs> Ping tests show client to server ping with 65500 bytes round trip time 19ms. nycfs> nycfs> Am I missing something here or what is slowing down these firebird communications??? nycfs> nycfs> Any help would be appreciated. nycfs> #yiv4474195212 #yiv4474195212 -- #yiv4474195212ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4474195212 #yiv4474195212ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4474195212 #yiv4474195212ygrp-mkp #yiv4474195212hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv4474195212 #yiv4474195212ygrp-mkp #yiv4474195212ads {margin-bottom:10px;}#yiv4474195212 #yiv4474195212ygrp-mkp .yiv4474195212ad {padding:0 0;}#yiv4474195212 #yiv4474195212ygrp-mkp .yiv4474195212ad p {margin:0;}#yiv4474195212 #yiv4474195212ygrp-mkp .yiv4474195212ad a {color:#ff;text-decoration:none;}#yiv4474195212 #yiv4474195212ygrp-sponsor #yiv4474195212ygrp-lc {font-family:Arial;}#yiv4474195212 #yiv4474195212ygrp-sponsor #yiv4474195212ygrp-lc #yiv4474195212hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4474195212 #yiv4474195212ygrp-sponsor #yiv4474195212ygrp-lc .yiv4474195212ad {margin-bottom:10px;padding:0 0;}#yiv4474195212 #yiv4474195212actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4474195212 #yiv4474195212activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4474195212 #yiv4474195212activity span {font-weight:700;}#yiv4474195212 #yiv4474195212activity span:first-child {text-transform:uppercase;}#yiv4474195212 #yiv4474195212activity span a {color:#5085b6;text-decoration:none;}#yiv4474195212 #yiv4474195212activity span span {color:#ff7900;}#yiv4474195212 #yiv4474195212activity span .yiv4474195212underline {text-decoration:underline;}#yiv4474195212 .yiv4474195212attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv4474195212 .yiv4474195212attach div a {text-decoration:none;}#yiv4474195212 .yiv4474195212attach img {border:none;padding-right:5px;}#yiv4474195212 .yiv4474195212attach label {display:block;margin-bottom:5px;}#yiv4474195212 .yiv4474195212attach label a {text-decoration:none;}#yiv4474195212 blockquote {margin:0 0 0 4px;}#yiv4474195212 .yiv4474195212bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv4474195212 .yiv4474195212bold a {text-decoration:none;}#yiv4474195212 dd.yiv4474195212last p a {font-family:Verdana;font-weight:700;}#yiv4474195212 dd.yiv4474195212last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4474195212 dd.yiv4474195212last p span.yiv4474195212yshortcuts {margin-right:0;}#yiv4474195212 div.yiv4474195212attach-table div div a {text-decoration:none;}#yiv4474195212 div.yiv4474195212attach-table {width:400px;}#yiv4474195212 div.yiv4474195212file-title a, #yiv4474195212 div.yiv4474195212file-title a:active, #yiv4474195212 div.yiv4474195212file-title a:hover, #yiv4474195212 div.yiv4474195212file-title a:visited {text-decoration:none;}#yiv4474195212 div.yiv4474195212photo-title a, #yiv4474195212 div.yiv4474195212photo-title a:active, #yiv4474195212 div.yiv4474195212photo-title a:hover, #yiv4474195212 div.yiv4474195212photo-title a:visited {text-decoration:none;}#yiv4474195212 div#yiv4474195212ygrp-mlmsg #yiv4474195212ygrp-msg p a span.yiv4474195212yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4474195212 .yiv4474195212green {color:#628c2a;}#yiv4474195212 .yiv4474195212MsoNormal {margin:0 0 0 0;}#yiv4474195212 o {font-size:0;}#yiv4474
Re: [firebird-support] Database/Table Corruption
Shutdown firebird, copy the database to a new file copy. Then start firebird and try the backup and restore process on the file copy.. Sent from Yahoo Mail for iPhone On Tuesday, December 31, 2019, 12:29 PM, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: Hello Alexey. IBPump was a good idea. IBPump doesn´t recover the corrupted table but at least it is possible to restore all others. Atenciosamente, + + Hugo Eyng + + De: firebird-support@yahoogroups.com em nome de Alexey Kovyazin a...@ib-aid.com [firebird-support] Enviado: sábado, 28 de dezembro de 2019 07:33 Para: firebird-support@yahoogroups.com Assunto: Re: [firebird-support] Database/Table Corruption Hello, before you try FirstAID, download IBPump and try to pump all data to the new database with the same structure. Regards, Alexey Kovyazin IBSurgeon On 27.12.2019 22:49, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: Hello. FB 2.5.7Windows 10 64 bitsPage size 4096 I am facing some dificulties to backup and restore a corrupted DB. I searched the Internet to find some help and tried everthing I read. I already tried "gfix -full - mend" and did not work. gbak -B -V -user SYSDBA -password masterkey MYDB.FDB MYDB..FBK ... gbak:46 records written gbak: ERROR:internal Firebird consistency check (decompression overran buffer (179), file: sqz.cpp line: 239) gbak: ERROR:gds_$receive failed gbak:Exiting before completion due to errors gbak: ERROR:internal Firebird consistency check (can't continue after bugcheck) I already dropped the table that causes this message but than the error occurs ahead. .. gbak:writing table constraints gbak:writing constraint INTEG_1 gbak:writing constraint INTEG_2 gbak:writing constraint INTEG_3 gbak:writing constraint INTEG_4 gbak:writing constraint INTEG_5 gbak:writing constraint INTEG_6 gbak:writing constraint INTEG_7 gbak:writing constraint INTEG_8 gbak:writing constraint INTEG_9 gbak:writing constraint INTEG_10 gbak:writing constraint INTEG_11 gbak:writing constraint INTEG_12 gbak:writing constraint INTEG_13 gbak:writing constraint INTEG_14 gbak:writing constraint INTEG_15 gbak:writing constraint INTEG_16 gbak:writing constraint INTEG_17 gbak: ERROR:internal Firebird consistency check (decompression overran buffer (179), file: sqz.cpp line: 239) gbak:Exiting before completion due to errors gbak: ERROR:internal Firebird consistency check (can't continue after bugcheck) Any help will be apreciated. Atenciosamente, + + Hugo Eyng + + #yiv2871085108 #yiv2871085108 -- #yiv2871085108ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2871085108 #yiv2871085108ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2871085108 #yiv2871085108ygrp-mkp #yiv2871085108hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2871085108 #yiv2871085108ygrp-mkp #yiv2871085108ads {margin-bottom:10px;}#yiv2871085108 #yiv2871085108ygrp-mkp .yiv2871085108ad {padding:0 0;}#yiv2871085108 #yiv2871085108ygrp-mkp .yiv2871085108ad p {margin:0;}#yiv2871085108 #yiv2871085108ygrp-mkp .yiv2871085108ad a {color:#ff;text-decoration:none;}#yiv2871085108 #yiv2871085108ygrp-sponsor #yiv2871085108ygrp-lc {font-family:Arial;}#yiv2871085108 #yiv2871085108ygrp-sponsor #yiv2871085108ygrp-lc #yiv2871085108hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2871085108 #yiv2871085108ygrp-sponsor #yiv2871085108ygrp-lc .yiv2871085108ad {margin-bottom:10px;padding:0 0;}#yiv2871085108 #yiv2871085108actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2871085108 #yiv2871085108activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2871085108 #yiv2871085108activity span {font-weight:700;}#yiv2871085108 #yiv2871085108activity span:first-child {text-transform:uppercase;}#yiv2871085108 #yiv2871085108activity span a {color:#5085b6;text-decoration:none;}#yiv2871085108 #yiv2871085108activity span span {color:#ff7900;}#yiv2871085108 #yiv2871085108activity span .yiv2871085108underline {text-decoration:underline;}#yiv2871085108 .yiv2871085108attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2871085108 .yiv2871085108attach div a {text-decoration:none;}#yiv2871085108 .yiv2871085108attach img {border:none;padding-right:5px;}#yiv2871085108 .yiv2871085108attach label {display:block;margin-bottom:5px;}#yiv2871085108 .yiv2871085108attach label a {text-decoration:none;}#yiv2871085108 blockquote {margin:0 0 0 4px;}#yiv2871085108 .yiv2871085108bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2871085108 .yiv2871085108bold a {text-decoration:none;}#yiv2871085108 dd.yiv2871085108last p a {font-family:Verdana;font-weight:700;}#yiv2871085108 dd.yiv2871085108last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2871085108 dd.yiv2871085108last p span.yiv2871085108yshortcut
Re: [firebird-support] Firebird client connection timeout
It sounds like connection pooling is being used such as odbc, keeping 5 connections open for reuse. To avoid this, you must change the connection string to contain something new. This avoids the connection pooling process. Example adding something as simple as time with seconds to a connection string bypasses the connection pool process strictly because the connection string is recongnized as new and not in the current connection pool. In odbc I used a connection string parameter that is simply ignored such as mytime=hhmmss Sent from Yahoo Mail for iPhone On Tuesday, December 31, 2019, 6:40 AM, Nagy Szilveszter nagy_szilvesz...@yahoo.com [firebird-support] wrote: Hi all! Is there a way to set connection timeout for firebird at client side? The default value is somewhere around 50 seconds and if i have wrong IP address set up in connection parameters then the application will freeze for almost a minute before it gives an error message that it couldn't connect. I'd like to reduce this waiting time to 5 seconds. At server side there is a ConnectionTimeout parameter, but it does not help me in this case (when i try to connect to an inexistent server, caused by wrong configuration). In real world example i have 2 servers configurations in a priority list (the development server and the production one). The production server is the highest priority one, so my clients have quick connection when they use the application. But when i'm in development environment (where the production server is not reachable) the application would first try the prod server then after failing it will try next server and my connection takes about a minute. I'd like this to be 5 seconds or less. (I know i could create connection definition files on each computer and rely on those files - but that would bring more administration issues which i don't want for this simple app) Can you help me? Thank you and have a happy new year! #yiv3450127990 #yiv3450127990 -- #yiv3450127990ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3450127990 #yiv3450127990ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3450127990 #yiv3450127990ygrp-mkp #yiv3450127990hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3450127990 #yiv3450127990ygrp-mkp #yiv3450127990ads {margin-bottom:10px;}#yiv3450127990 #yiv3450127990ygrp-mkp .yiv3450127990ad {padding:0 0;}#yiv3450127990 #yiv3450127990ygrp-mkp .yiv3450127990ad p {margin:0;}#yiv3450127990 #yiv3450127990ygrp-mkp .yiv3450127990ad a {color:#ff;text-decoration:none;}#yiv3450127990 #yiv3450127990ygrp-sponsor #yiv3450127990ygrp-lc {font-family:Arial;}#yiv3450127990 #yiv3450127990ygrp-sponsor #yiv3450127990ygrp-lc #yiv3450127990hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3450127990 #yiv3450127990ygrp-sponsor #yiv3450127990ygrp-lc .yiv3450127990ad {margin-bottom:10px;padding:0 0;}#yiv3450127990 #yiv3450127990actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3450127990 #yiv3450127990activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3450127990 #yiv3450127990activity span {font-weight:700;}#yiv3450127990 #yiv3450127990activity span:first-child {text-transform:uppercase;}#yiv3450127990 #yiv3450127990activity span a {color:#5085b6;text-decoration:none;}#yiv3450127990 #yiv3450127990activity span span {color:#ff7900;}#yiv3450127990 #yiv3450127990activity span .yiv3450127990underline {text-decoration:underline;}#yiv3450127990 .yiv3450127990attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3450127990 .yiv3450127990attach div a {text-decoration:none;}#yiv3450127990 .yiv3450127990attach img {border:none;padding-right:5px;}#yiv3450127990 .yiv3450127990attach label {display:block;margin-bottom:5px;}#yiv3450127990 .yiv3450127990attach label a {text-decoration:none;}#yiv3450127990 blockquote {margin:0 0 0 4px;}#yiv3450127990 .yiv3450127990bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3450127990 .yiv3450127990bold a {text-decoration:none;}#yiv3450127990 dd.yiv3450127990last p a {font-family:Verdana;font-weight:700;}#yiv3450127990 dd.yiv3450127990last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3450127990 dd.yiv3450127990last p span.yiv3450127990yshortcuts {margin-right:0;}#yiv3450127990 div.yiv3450127990attach-table div div a {text-decoration:none;}#yiv3450127990 div.yiv3450127990attach-table {width:400px;}#yiv3450127990 div..yiv3450127990file-title a, #yiv3450127990 div.yiv3450127990file-title a:active, #yiv3450127990 div.yiv3450127990file-title a:hover, #yiv3450127990 div.yiv3450127990file-title a:visited {text-decoration:none;}#yiv3450127990 div.yiv3450127990photo-title a, #yiv3450127990 div.yiv3450127990photo-title a:active, #yiv3450127990 div.yiv3450127990photo-title a:hover, #yiv3450127990 div.yiv3450127990p