Re: AW: AW: [firebird-support] High number of NULL attachments

[monteropetronila...@yahoo.com [firebird-support]]

Perfect 

Sent from Yahoo Mail. Get the app 

On Tuesday, October 4, 2016 8:26 PM, "'Gregor Kobler' g...@gksoft.ch 
[firebird-support]"  wrote:
 

     OK, but are the version of the bundled (client) dll compared to the dll 
comes with FB2.5.3 are the same?  Von: firebird-support@yahoogroups.com 
[mailto:firebird-support@yahoogroups.com] 
Gesendet: Dienstag, 4. Oktober 2016 11:39
An: firebird-support@yahoogroups.com
Betreff: Re: AW: [firebird-support] High number of NULL attachments    
fbclient.dll is bundled with the client application.

-Tom

On Tue, October 4, 2016 10:14 am, 'Gregor Kobler' g...@gksoft.ch
[firebird-support] wrote:
> Does the Client uses the right fbclient.dll or GDS32.dll?
>
>
>
>
>
> Best Regards
>
>
> Gregor
>
>
>
>
>
> Von: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com]
> Gesendet: Dienstag, 4. Oktober 2016 08:41
> An: firebird-support@yahoogroups.com
> Betreff: [firebird-support] High number of NULL attachments
>
>
>
>
>
>
>
>
> Hi all.
>
>
> I am running a FB 2.5.3 server to which a delphi application connects. We
> usually have 20-30 concurrent connections.
> I have inspected the MON$ATTACHMENTS table and noticed many of the records
> have NULL values in MON$REMOTE_PID and MON$REMOTE_PROCESS but not in
> MON$REMOTE_ADDRESS.
>
>
> Does that mean that the connection to the server is still open even if the
> application isn't? How can I mitigate that?
> Thanks.
>
>
> -Tom
>
>
>
>
>
>
>  #yiv4816030198 #yiv4816030198 -- #yiv4816030198ygrp-mkp {border:1px solid 
> #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4816030198 
> #yiv4816030198ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4816030198 
> #yiv4816030198ygrp-mkp #yiv4816030198hd 
> {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
> 0;}#yiv4816030198 #yiv4816030198ygrp-mkp #yiv4816030198ads 
> {margin-bottom:10px;}#yiv4816030198 #yiv4816030198ygrp-mkp .yiv4816030198ad 
> {padding:0 0;}#yiv4816030198 #yiv4816030198ygrp-mkp .yiv4816030198ad p 
> {margin:0;}#yiv4816030198 #yiv4816030198ygrp-mkp .yiv4816030198ad a 
> {color:#ff;text-decoration:none;}#yiv4816030198 
> #yiv4816030198ygrp-sponsor #yiv4816030198ygrp-lc 
> {font-family:Arial;}#yiv4816030198 #yiv4816030198ygrp-sponsor 
> #yiv4816030198ygrp-lc #yiv4816030198hd {margin:10px 
> 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4816030198 
> #yiv4816030198ygrp-sponsor #yiv4816030198ygrp-lc .yiv4816030198ad 
> {margin-bottom:10px;padding:0 0;}#yiv4816030198 #yiv4816030198actions 
> {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4816030198 
> #yiv4816030198activity 
> {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4816030198
>  #yiv4816030198activity span {font-weight:700;}#yiv4816030198 
> #yiv4816030198activity span:first-child 
> {text-transform:uppercase;}#yiv4816030198 #yiv4816030198activity span a 
> {color:#5085b6;text-decoration:none;}#yiv4816030198 #yiv4816030198activity 
> span span {color:#ff7900;}#yiv4816030198 #yiv4816030198activity span 
> .yiv4816030198underline {text-decoration:underline;}#yiv4816030198 
> .yiv4816030198attach 
> {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
> 0;width:400px;}#yiv4816030198 .yiv4816030198attach div a 
> {text-decoration:none;}#yiv4816030198 .yiv4816030198attach img 
> {border:none;padding-right:5px;}#yiv4816030198 .yiv4816030198attach label 
> {display:block;margin-bottom:5px;}#yiv4816030198 .yiv4816030198attach label a 
> {text-decoration:none;}#yiv4816030198 blockquote {margin:0 0 0 
> 4px;}#yiv4816030198 .yiv4816030198bold 
> {font-family:Arial;font-size:13px;font-weight:700;}#yiv4816030198 
> .yiv4816030198bold a {text-decoration:none;}#yiv4816030198 
> dd.yiv4816030198last p a {font-family:Verdana;font-weight:700;}#yiv4816030198 
> dd.yiv4816030198last p span 
> {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4816030198 
> dd.yiv4816030198last p span.yiv4816030198yshortcuts 
> {margin-right:0;}#yiv4816030198 div.yiv4816030198attach-table div div a 
> {text-decoration:none;}#yiv4816030198 div.yiv4816030198attach-table 
> {width:400px;}#yiv4816030198 div.yiv4816030198file-title a, #yiv4816030198 
> div.yiv4816030198file-title a:active, #yiv4816030198 
> div.yiv4816030198file-title a:hover, #yiv4816030198 
> div.yiv4816030198file-title a:visited {text-decoration:none;}#yiv4816030198 
> div.yiv4816030198photo-title a, #yiv4816030198 div.yiv4816030198photo-title 
> a:active, #yiv4816030198 div.yiv4816030198photo-title a:hover, #yiv4816030198 
> div.yiv4816030198photo-title a:visited {text-decoration:none;}#yiv4816030198 
> div#yiv4816030198ygrp-mlmsg #yiv4816030198ygrp-msg p a 
> span.yiv4816030198yshortcuts 
> {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4816030198 
> .yiv4816030198green {color:#628c2a;}#yiv4816030198 .yiv4816030198MsoNormal 
> {margin:0 0 0 0;}#yiv4816030198 o {font-size:0;}#yiv4816030198 
> 

Re: [firebird-support] Encryption on FB3

[Christian Gütter n...@guetter.org [firebird-support]]

Hi there,

Paul Beach wrote:

>> IBPhoenix have a working plugin thats available for use.
>> http://www.ibphoenix.com/products/software/encryptionplugin

Elton Amorim wrote:

> Except for ibphoenix, nobody knows that.

Everybody who is able to use Google can know about that.
Just type "encryption plugin firebird 3" and click the search button.


Cheers,
Christian

AW: AW: [firebird-support] High number of NULL attachments

['Gregor Kobler' g...@gksoft.ch [firebird-support]]

OK, but are the version of the bundled (client) dll compared to the dll
comes with FB2.5.3 are the same?


 


Von: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] 
Gesendet: Dienstag, 4. Oktober 2016 11:39
An: firebird-support@yahoogroups.com
Betreff: Re: AW: [firebird-support] High number of NULL attachments


 


  


fbclient.dll is bundled with the client application.


-Tom


On Tue, October 4, 2016 10:14 am, 'Gregor Kobler'  
g...@gksoft.ch
[firebird-support] wrote:
> Does the Client uses the right fbclient.dll or GDS32.dll?
>
>
>
>
>
> Best Regards
>
>
> Gregor
>
>
>
>
>
> Von: firebird-support@yahoogroups.com
 
> [mailto:firebird-support@yahoogroups.com]
> Gesendet: Dienstag, 4. Oktober 2016 08:41
> An: firebird-support@yahoogroups.com
 
> Betreff: [firebird-support] High number of NULL attachments
>
>
>
>
>
>
>
>
> Hi all.
>
>
> I am running a FB 2.5.3 server to which a delphi application connects. We
> usually have 20-30 concurrent connections.
> I have inspected the MON$ATTACHMENTS table and noticed many of the records
> have NULL values in MON$REMOTE_PID and MON$REMOTE_PROCESS but not in
> MON$REMOTE_ADDRESS.
>
>
> Does that mean that the connection to the server is still open even if the
> application isn't? How can I mitigate that?
> Thanks.
>
>
> -Tom
>
>
>
>
>
>
>

Re: [firebird-support] Re: internal Firebird consistency check (decompression overran buffer (179), file: sqz.cpp line: 239)

[monteropetronila...@yahoo.com [firebird-support]]

Thank you 

Sent from Yahoo Mail. Get the app 

On Tuesday, October 4, 2016 1:17 PM, 
"n6auei4hz6ypittow3d2xkak432y2oszb2gth...@yahoo.com [firebird-support]" 
 wrote:
 

     We shouldn't do. Just single big file in the first case, and a fairly 
small 500MB one in the second.  #yiv2669714009 #yiv2669714009 -- 
#yiv2669714009ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 
0;padding:0 10px;}#yiv2669714009 #yiv2669714009ygrp-mkp hr {border:1px solid 
#d8d8d8;}#yiv2669714009 #yiv2669714009ygrp-mkp #yiv2669714009hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv2669714009 #yiv2669714009ygrp-mkp #yiv2669714009ads 
{margin-bottom:10px;}#yiv2669714009 #yiv2669714009ygrp-mkp .yiv2669714009ad 
{padding:0 0;}#yiv2669714009 #yiv2669714009ygrp-mkp .yiv2669714009ad p 
{margin:0;}#yiv2669714009 #yiv2669714009ygrp-mkp .yiv2669714009ad a 
{color:#ff;text-decoration:none;}#yiv2669714009 #yiv2669714009ygrp-sponsor 
#yiv2669714009ygrp-lc {font-family:Arial;}#yiv2669714009 
#yiv2669714009ygrp-sponsor #yiv2669714009ygrp-lc #yiv2669714009hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2669714009 
#yiv2669714009ygrp-sponsor #yiv2669714009ygrp-lc .yiv2669714009ad 
{margin-bottom:10px;padding:0 0;}#yiv2669714009 #yiv2669714009actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2669714009 
#yiv2669714009activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2669714009
 #yiv2669714009activity span {font-weight:700;}#yiv2669714009 
#yiv2669714009activity span:first-child 
{text-transform:uppercase;}#yiv2669714009 #yiv2669714009activity span a 
{color:#5085b6;text-decoration:none;}#yiv2669714009 #yiv2669714009activity span 
span {color:#ff7900;}#yiv2669714009 #yiv2669714009activity span 
.yiv2669714009underline {text-decoration:underline;}#yiv2669714009 
.yiv2669714009attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv2669714009 .yiv2669714009attach div a 
{text-decoration:none;}#yiv2669714009 .yiv2669714009attach img 
{border:none;padding-right:5px;}#yiv2669714009 .yiv2669714009attach label 
{display:block;margin-bottom:5px;}#yiv2669714009 .yiv2669714009attach label a 
{text-decoration:none;}#yiv2669714009 blockquote {margin:0 0 0 
4px;}#yiv2669714009 .yiv2669714009bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv2669714009 
.yiv2669714009bold a {text-decoration:none;}#yiv2669714009 dd.yiv2669714009last 
p a {font-family:Verdana;font-weight:700;}#yiv2669714009 dd.yiv2669714009last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2669714009 
dd.yiv2669714009last p span.yiv2669714009yshortcuts 
{margin-right:0;}#yiv2669714009 div.yiv2669714009attach-table div div a 
{text-decoration:none;}#yiv2669714009 div.yiv2669714009attach-table 
{width:400px;}#yiv2669714009 div.yiv2669714009file-title a, #yiv2669714009 
div.yiv2669714009file-title a:active, #yiv2669714009 
div.yiv2669714009file-title a:hover, #yiv2669714009 div.yiv2669714009file-title 
a:visited {text-decoration:none;}#yiv2669714009 div.yiv2669714009photo-title a, 
#yiv2669714009 div.yiv2669714009photo-title a:active, #yiv2669714009 
div.yiv2669714009photo-title a:hover, #yiv2669714009 
div.yiv2669714009photo-title a:visited {text-decoration:none;}#yiv2669714009 
div#yiv2669714009ygrp-mlmsg #yiv2669714009ygrp-msg p a 
span.yiv2669714009yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2669714009 
.yiv2669714009green {color:#628c2a;}#yiv2669714009 .yiv2669714009MsoNormal 
{margin:0 0 0 0;}#yiv2669714009 o {font-size:0;}#yiv2669714009 
#yiv2669714009photos div {float:left;width:72px;}#yiv2669714009 
#yiv2669714009photos div div {border:1px solid 
#66;min-height:62px;overflow:hidden;width:62px;}#yiv2669714009 
#yiv2669714009photos div label 
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2669714009
 #yiv2669714009reco-category {font-size:77%;}#yiv2669714009 
#yiv2669714009reco-desc {font-size:77%;}#yiv2669714009 .yiv2669714009replbq 
{margin:4px;}#yiv2669714009 #yiv2669714009ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv2669714009 #yiv2669714009ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2669714009 
#yiv2669714009ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2669714009 
#yiv2669714009ygrp-mlmsg select, #yiv2669714009 input, #yiv2669714009 textarea 
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv2669714009 
#yiv2669714009ygrp-mlmsg pre, #yiv2669714009 code {font:115% 
monospace;}#yiv2669714009 #yiv2669714009ygrp-mlmsg * 
{line-height:1.22em;}#yiv2669714009 #yiv2669714009ygrp-mlmsg #yiv2669714009logo 
{padding-bottom:10px;}#yiv2669714009 #yiv2669714009ygrp-msg p a 
{font-family:Verdana;}#yiv2669714009 #yiv2669714009ygrp-msg 
p#yiv2669714009attach-count span 

Re: AW: [firebird-support] High number of NULL attachments

[monteropetronila...@yahoo.com [firebird-support]]

Great, Thanks! 

Sent from Yahoo Mail. Get the app 

On Tuesday, October 4, 2016 1:04 PM, "'Thomas Steinmaurer' 
t...@iblogmanager.com [firebird-support]"  
wrote:
 

     > fbclient.dll is bundled with the client application.

If I remember correctly, you need a client library 2.1+ to get that information 
popping up in MON$ATTACHMENTS

--
With regards,
Thomas Steinmaurer
http://www.upscene.com

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.

> 
> -Tom
> 
> On Tue, October 4, 2016 10:14 am, 'Gregor Kobler' g...@gksoft.ch
> [firebird-support] wrote:
>> Does the Client uses the right fbclient.dll or GDS32.dll?
>>
>>
>>
>>
>>
>> Best Regards
>>
>>
>> Gregor
>>
>>
>>
>>
>>
>> Von: firebird-support@yahoogroups.com
>> [mailto:firebird-support@yahoogroups.com]
>> Gesendet: Dienstag, 4. Oktober 2016 08:41
>> An: firebird-support@yahoogroups.com
>> Betreff: [firebird-support] High number of NULL attachments
>>
>>
>>
>>
>>
>>
>>
>>
>> Hi all.
>>
>>
>> I am running a FB 2.5.3 server to which a delphi application connects. We
>> usually have 20-30 concurrent connections.
>> I have inspected the MON$ATTACHMENTS table and noticed many of the records
>> have NULL values in MON$REMOTE_PID and MON$REMOTE_PROCESS but not in
>> MON$REMOTE_ADDRESS.
>>
>>
>> Does that mean that the connection to the server is still open even if the
>> application isn't? How can I mitigate that?
>> Thanks.
>>
>>
>> -Tom
>>
>>
>>
>>
>>
>>
>>
> 
> 
> 
> 
> 
> Posted by: "Tom" 
> 
> 
> ++
> 
> 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
> 
> 
> 

  #yiv2603786793 #yiv2603786793 -- #yiv2603786793ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2603786793 
#yiv2603786793ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2603786793 
#yiv2603786793ygrp-mkp #yiv2603786793hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv2603786793 #yiv2603786793ygrp-mkp #yiv2603786793ads 
{margin-bottom:10px;}#yiv2603786793 #yiv2603786793ygrp-mkp .yiv2603786793ad 
{padding:0 0;}#yiv2603786793 #yiv2603786793ygrp-mkp .yiv2603786793ad p 
{margin:0;}#yiv2603786793 #yiv2603786793ygrp-mkp .yiv2603786793ad a 
{color:#ff;text-decoration:none;}#yiv2603786793 #yiv2603786793ygrp-sponsor 
#yiv2603786793ygrp-lc {font-family:Arial;}#yiv2603786793 
#yiv2603786793ygrp-sponsor #yiv2603786793ygrp-lc #yiv2603786793hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2603786793 
#yiv2603786793ygrp-sponsor #yiv2603786793ygrp-lc .yiv2603786793ad 
{margin-bottom:10px;padding:0 0;}#yiv2603786793 #yiv2603786793actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2603786793 
#yiv2603786793activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2603786793
 #yiv2603786793activity span {font-weight:700;}#yiv2603786793 
#yiv2603786793activity span:first-child 
{text-transform:uppercase;}#yiv2603786793 #yiv2603786793activity span a 
{color:#5085b6;text-decoration:none;}#yiv2603786793 #yiv2603786793activity span 
span {color:#ff7900;}#yiv2603786793 #yiv2603786793activity span 
.yiv2603786793underline {text-decoration:underline;}#yiv2603786793 
.yiv2603786793attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv2603786793 .yiv2603786793attach div a 
{text-decoration:none;}#yiv2603786793 .yiv2603786793attach img 
{border:none;padding-right:5px;}#yiv2603786793 .yiv2603786793attach label 
{display:block;margin-bottom:5px;}#yiv2603786793 .yiv2603786793attach label a 
{text-decoration:none;}#yiv2603786793 blockquote {margin:0 0 0 
4px;}#yiv2603786793 .yiv2603786793bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv2603786793 
.yiv2603786793bold a {text-decoration:none;}#yiv2603786793 dd.yiv2603786793last 
p a {font-family:Verdana;font-weight:700;}#yiv2603786793 dd.yiv2603786793last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2603786793 
dd.yiv2603786793last p span.yiv2603786793yshortcuts 
{margin-right:0;}#yiv2603786793 div.yiv2603786793attach-table div div a 
{text-decoration:none;}#yiv2603786793 div.yiv2603786793attach-table 
{width:400px;}#yiv2603786793 div.yiv2603786793file-title a, #yiv2603786793 
div.yiv2603786793file-title a:active, #yiv2603786793 
div.yiv2603786793file-title a:hover, #yiv2603786793 div.yiv2603786793file-title 
a:visited {text-decoration:none;}#yiv2603786793 

[firebird-support] Re: internal Firebird consistency check (decompression overran buffer (179), file: sqz.cpp line: 239)

[n6auei4hz6ypittow3d2xkak432y2oszb2gth...@yahoo.com [firebird-support]]

We shouldn't do. Just single big file in the first case, and a fairly small 
500MB one in the second.

Re: AW: [firebird-support] High number of NULL attachments

['Thomas Steinmaurer' t...@iblogmanager.com [firebird-support]]

> fbclient.dll is bundled with the client application.

If I remember correctly, you need a client library 2.1+ to get that information 
popping up in MON$ATTACHMENTS


--
With regards,
Thomas Steinmaurer
http://www.upscene.com

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.



> 
> -Tom
> 
> On Tue, October 4, 2016 10:14 am, 'Gregor Kobler' g...@gksoft.ch
> [firebird-support] wrote:
>> Does the Client uses the right fbclient.dll or GDS32.dll?
>>
>>
>>
>>
>>
>> Best Regards
>>
>>
>> Gregor
>>
>>
>>
>>
>>
>> Von: firebird-support@yahoogroups.com
>> [mailto:firebird-support@yahoogroups.com]
>> Gesendet: Dienstag, 4. Oktober 2016 08:41
>> An: firebird-support@yahoogroups.com
>> Betreff: [firebird-support] High number of NULL attachments
>>
>>
>>
>>
>>
>>
>>
>>
>> Hi all.
>>
>>
>> I am running a FB 2.5.3 server to which a delphi application connects. We
>> usually have 20-30 concurrent connections.
>> I have inspected the MON$ATTACHMENTS table and noticed many of the records
>> have NULL values in MON$REMOTE_PID and MON$REMOTE_PROCESS but not in
>> MON$REMOTE_ADDRESS.
>>
>>
>> Does that mean that the connection to the server is still open even if the
>> application isn't? How can I mitigate that?
>> Thanks.
>>
>>
>> -Tom
>>
>>
>>
>>
>>
>>
>>
> 
> 
> 
> 
> 
> Posted by: "Tom" 
> 
> 
> ++
> 
> 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] High number of NULL attachments

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

04.10.2016 11:38, 'Tom' tom...@vp44.net [firebird-support] wrote:
> fbclient.dll is bundled with the client application.

   Check client version to be outdated, because PID and process name is 
reported by client 
library.


-- 
   WBR, SD.






++

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

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] internal Firebird consistency check (decompression overran buffer (179), file: sqz.cpp line: 239)

[Alexey Kovyazin a...@ib-aid.com [firebird-support]]

Hi Ian,

It seems that you have multi-volume database, is it correct?

Regards,
Alexey Kovyazin
IBSurgeon


Hi FB Support!


We have been running FB since IB4.2 days and have only previously had 
any database corruption when we've had hardware issues...until 
recently, when I've seen this error on 2 different servers that I'm 
reasonably confident are both fine! However, our setup is probably 
fairly unique. I'm not panicking at the moment as we recovered all the 
data from the backup, but as I've had this twice in a month on 
different machines I'm keen to adjust the setup so it doesn't happen 
again.



We are running about 20 customers on a server, each with their own set 
of Firebird/PHP-FPM/Nginx/custom python servers running as services 
bound to separate IP addresses – this is (in theory!) to keep each 
customer isolated from the others whilst sharing most of the resources 
on the box without too much overhead from containers or full 
visualisation.



FB is listening as a tcpsvd service but with a shared lock folder:


exec tcpsvd -c 60 -u firebird:firebird -l $remote_bind_addr 
$remote_bind_addr $remote_bind_port /usr/sbin/fb_inet_server -i -e 
"/srv/$CUSTOMER/interbase/" -el "/tmp/firebird/tmpfs"



and with a “localhost” for our own convenience:


exec tcpsvd -c 60 -u firebird:firebird -l 127.0.0.1 127.0.0.1 3050 
/usr/sbin/fb_inet_server -i -e "/var/interbase/" -el "/tmp/firebird/tmpfs"



I had assumed because they were using the share lock folder that this 
is allowed.



Each night we loop through all the customers and run :


for database in /customers/*.gdb

do

echo “Doing $database:”

echo -n “gbak ”

gbak -b -g localhost:$database /backupdata/$database.gbak

echo $?

echo -n “gfix ”

gfix -sweep localhost:$database

echo $?

echo -n “isql “

echo “EXECURE PROCEDURE nightlySQL;” | isql localhost$database

echo $?

done


Whilst this backup is running we don't disable any external access and 
have a mixture of python and php clients accessing throughout the 
night using the $remote_bind_addr:$database connection string rather 
than localhost:.



Over the weekend a 12GB backup finished successfully, but errors 
started appearing in the firebird2.5.log file at the same time as the 
next database was being backed up – suggesting that either the gfix or 
isql had tripped up before the script moved on. However, the output 
from the backup was:



Doing :

gbak 0

gfix 0

isql 0


The firebird log has the next customer's sweep starting immediately 
after the first “internal Firebird consistency check (decompression 
overran buffer (179), file: sqz.cpp line: 239)” on the now corrupt 
database which suggests the isql line is “to blame” - but the 
nightlySQL doesn't do a lot, just deletes from a table and 
re-populates a load of summaries from a big table. The firebird log 
error coincides with an NGINX request for the data that the nightlySQL 
is building, but I've repeated this today and it doesn't by itself 
kill the database. I've got nothing else in either syslog or dmesg.



I've run IBSurgeon against the file. It gives me the following output:


03/10/2016 11:23:53 INFO: Open database files: Z:\home\**-bad.gdb


03/10/2016 11:23:53 INFO: Analyzing database low-level structures...

03/10/2016 11:27:42 INFO: Actual PageCount: 1534112 found in database

03/10/2016 11:27:42 ERROR: Found 18 undefined or unrecognized pages.

03/10/2016 11:27:42 INFO: == DATABASE IS READY FOR DIAGNOSING AND 
REPAIRING. 


03/10/2016 11:27:42 INFO: == Now choose "Diagnose" or "Repair". 

03/10/2016 11:51:31 INFO: --- Starting diagnose

03/10/2016 11:51:31 INFO: Running procedure: Header page check

03/10/2016 11:51:31 INFO: ODS Major = 11 (32779)

03/10/2016 11:51:31 INFO: ODS Minor = 2

03/10/2016 11:51:31 INFO: Next transaction = 13910909

03/10/2016 11:51:31 INFO: Oldest transaction = 13910907

03/10/2016 11:51:31 INFO: Oldest active = 13910908

03/10/2016 11:51:31 INFO: Oldest snapshot = 13910908

03/10/2016 11:51:31 INFO: PageSize is Ok = 8192

03/10/2016 11:51:31 INFO: Running procedure: Checking of RDB$Pages 
consistency


03/10/2016 11:53:42 INFO: Checking of RDB$Pages consistency: Ok

03/10/2016 11:53:42 INFO: Running procedure: Low-level check of all 
relations


03/10/2016 11:53:43 INFO: Relation RDB$DATABASE (1) is OK

03/10/2016 11:53:44 INFO: Relation RDB$FIELDS (2) is OK

03/10/2016 11:53:46 INFO: Relation RDB$INDEX_SEGMENTS (3) is OK

03/10/2016 11:53:47 INFO: Relation RDB$INDICES (4) is OK

03/10/2016 11:53:47 INFO: Relation RDB$RELATION_FIELDS (5) is OK

03/10/2016 11:53:48 INFO: Relation RDB$RELATIONS (6) is OK

03/10/2016 11:53:48 INFO: Relation RDB$VIEW_RELATIONS (7) is OK

03/10/2016 11:53:48 INFO: Relation RDB$FORMATS (8) is OK

03/10/2016 11:53:48 INFO: Relation RDB$SECURITY_CLASSES (9) is OK

03/10/2016 11:53:48 ERROR: DP#1533855 has wrong rel#:136

03/10/2016 11:53:48 ERROR: Found 1 record errors on datapage#1533855

03/10/2016 11:53:48 ERROR: Error on 

Re: AW: [firebird-support] High number of NULL attachments

['Tom' tom...@vp44.net [firebird-support]]

fbclient.dll is bundled with the client application.

-Tom

On Tue, October 4, 2016 10:14 am, 'Gregor Kobler' g...@gksoft.ch
[firebird-support] wrote:
> Does the Client uses the right fbclient.dll or GDS32.dll?
>
>
>
>
>
> Best Regards
>
>
> Gregor
>
>
>
>
>
> Von: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com]
> Gesendet: Dienstag, 4. Oktober 2016 08:41
> An: firebird-support@yahoogroups.com
> Betreff: [firebird-support] High number of NULL attachments
>
>
>
>
>
>
>
>
> Hi all.
>
>
> I am running a FB 2.5.3 server to which a delphi application connects. We
> usually have 20-30 concurrent connections.
> I have inspected the MON$ATTACHMENTS table and noticed many of the records
> have NULL values in MON$REMOTE_PID and MON$REMOTE_PROCESS but not in
> MON$REMOTE_ADDRESS.
>
>
> Does that mean that the connection to the server is still open even if the
> application isn't? How can I mitigate that?
> Thanks.
>
>
> -Tom
>
>
>
>
>
>
>

AW: [firebird-support] High number of NULL attachments

['Gregor Kobler' g...@gksoft.ch [firebird-support]]

Does the Client uses the right fbclient.dll or GDS32.dll?





Best Regards


Gregor





Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Gesendet: Dienstag, 4. Oktober 2016 08:41
An: firebird-support@yahoogroups.com
Betreff: [firebird-support] High number of NULL attachments








Hi all.


I am running a FB 2.5.3 server to which a delphi application connects. We
usually have 20-30 concurrent connections.
I have inspected the MON$ATTACHMENTS table and noticed many of the records
have NULL values in MON$REMOTE_PID and MON$REMOTE_PROCESS but not in
MON$REMOTE_ADDRESS.


Does that mean that the connection to the server is still open even if the
application isn't? How can I mitigate that?
Thanks.


-Tom

[firebird-support] High number of NULL attachments

['Tom' tom...@vp44.net [firebird-support]]

Hi all.


I am running a FB 2.5.3 server to which a delphi application connects. We
usually have 20-30 concurrent connections.
I have inspected the MON$ATTACHMENTS table and noticed many of the records
have NULL values in MON$REMOTE_PID and MON$REMOTE_PROCESS but not in
MON$REMOTE_ADDRESS.


Does that mean that the connection to the server is still open even if the
application isn't? How can I mitigate that?
Thanks.


-Tom