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
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
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
